MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » July 2014

Re: Deleted records



fixed

On 30-Jun-2014 14:31 -0500, John McKee wrote:

<<SNIP>> I had no intent of attempting to operate on this particular
file <ed: file QADBIFLD in QSYS>. To me, QSYS is not a library to be
tinkering with. I had hoped that there was a method to release the
deleted records. Currently, our backup just barely requires a second
3590 cartridge. I had hoped, by reducing deleted records, to allow
the backup to fit on a single cartridge. <<SNIP>>

Reducing the size of the *DBXREF files will not reduce storage requirements on tape\backups, only reduce the storage on disk\DASD.

That is because the Save System (SAVSYS) does *not* include the data [from all but one, typically the smallest] of those files QADB* in QSYS; neither the physical data nor the access paths of all but the QADBXRDBD files are ever saved.

To reduce the size of storage in the SAVSYS, delete any unneeded History files (QHST*) and reduce the private authorities; private authorities can be moved to Authorization Lists (*AUTL), but as consolidated authorities, they will take significantly less storage.






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