MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » October 2012

Re: QADBIFLD - Size?



fixed

Reorging your user files will have zero effect.

Try a DSPFD of QADBIFLD. At the bottom what do you see for deleted
records?
You will not be able to do a RGZPFM on this file itself due to
Allow write operation . . . . . . . . . . . : No
The way to fix that is to bring your system down into a restricted state
and run
RCLSTG SELECT(*DBXREF)
This will be much shorter than a full RCLSTG. A real example is 20
minutes versus 6 hours.
The file is coded as
Reuse deleted records . . . . . . . . . . . : REUSEDLT *YES
However, we also have 369k deleted records. Oh well, when your ERP
library has over 5k tables in it, each with several columns and you do a
DLTLIB and a RSTLIB from production to generate a new test library perhaps
it doesn't do such a hot job on reusing deleted records.


Total records . . . . . . . . . . . . . . : 2085358
Total deleted records . . . . . . . . . . : 369431
Total of member sizes . . . . . . . . . . : 1070915584

STRSQL
CREATE TABLE ROB/OCT10 (MYCOL1 CHAR (10 ) NOT NULL WITH DEFAULT,
MYCOL2 CHAR (10 ) NOT NULL WITH DEFAULT, MYCOL3 CHAR (10 ) NOT NULL
WITH DEFAULT, MYCOL4 CHAR (10 ) NOT NULL WITH DEFAULT)
Table OCT10 created in ROB.
Total records . . . . . . . . . . . . . . : 2085362
Total deleted records . . . . . . . . . . : 369427
Well, that did a pretty good job of reusing deleted records. That
dropped.



Rob Berendt





Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact