Exponential Database Growth

TomBascom

Curmudgeon
Lastly (for now) and getting back to the after-image extents... 2 ai extents is really not a very good idea. That makes it way too easy to get into a bind where normal operations (like making a backup) are difficult or impossible. You should have at least 4 ai extents as a very threadbare minimum. 8 is better. Large numbers of ai extents (more than 16), on the other hand, are not terribly useful.
 

dimitri.p

New Member
Seeing all this information makes me want to know how all extents prior to .d21 are limited to 2GB .
Was enablelargefiles used before figuring out the reason for the sudden growth?
I love using 2GB extents for this specific reason :)
 

bodom131286

New Member
thank you All for your inputs &guide.
This has been sorted.
Process was trying to store file of 200+MB as some scanned file with different scan settings.
So file was not getting loaded and DB space was increasing. As this process was running every hour, so DB space was increasing by 200MBper hour.
we removed that file and updated process to not process file greater than 100MB.

lease select a function. F4 or blank to EXIT wacreapo.p
Maximum size for CLOB in field 'xxblob_content' is 104857600. Attempted 105512960 (14496)
Failed to create/update blob from file '/ext1/prod/INTERFACE/astra/invoices/30/TMobile April 2020.pdf'. (11275)
COPY-LOB failed to copy file '/ext1/prod/INTERFACE/astra/invoices/30/TMobile April 2020.pdf' to large object. (11300)
Maximum size for CLOB in field 'xxblob_content' is 104857600. Attempted 105512960 (14496)
Failed to create/update blob from file '/ext1/prod/INTERFACE/astra/invoices/30/TMobile March 2020.pdf'. (11275)
COPY-LOB failed to copy file '/ext1/prod/INTERFACE/astra/invoices/30/TMobile March 2020.pdf' to large object. (11300)
Maximum size for CLOB in field 'xxblob_content' is 104857600. Attempted 105512960 (14496)
Failed to create/update blob from file '/ext1/prod/INTERFACE/astra/invoices/HQN/TMobileApril20.pdf'. (11275)
COPY-LOB failed to copy file '/ext1/prod/INTERFACE/astra/invoices/HQN/TMobileApril20.pdf' to large object. (11300)
Maximum size for CLOB in field 'xxblob_content' is 104857600. Attempted 105512960 (14496)
Failed to create/update blob from file '/ext1/prod/INTERFACE/astra/invoices/HQN/TMobileMarch20.pdf'. (11275)
COPY-LOB failed to copy file '/ext1/prod/INTERFACE/astra/invoices/HQN/TMobileMarch20.pdf' to large object. (11300)


Kind Regards,
rahul
 
Top