|
Luckily we have downtime available to re-org all files on a Sunday. To do this we use a tool from OS Solutions called OS Director. This lets you specify by library what to re-organise, whether to use a particular key, and to re-organise on a % of deleted space. As well as letting you schedule re-orgs, you can clean up spool files, journals, IBM logs etc. You can also use it to log library/file sizes for capacity planning, and it even has it's own scheduler, plus a lot more besides! For its ease of use, and its "set-up and forget" operation, i'd certainly recommend taking a look. (I have no contact with this company, apart from being a user of their products) http://www.os-solutions.com/ JBA don't recommend re-using deleted records, but so long as you don't have any mods/other software that uses sequential processing, you should be ok. Should. Regards, Stuart > -----Original Message----- > From: Dan Thomas [SMTP:DThomas@lpw-mdi.com] > Sent: Friday, October 01, 1999 2:05 PM > To: 'JBAUSERS-L@midrange.com' > Subject: Reuse Deleted Records Option > > Any opinions of use of this option? Obviously many of the JBA files need > to > be reorganized regularly. We've turned this option on for a few lock > files > without consequence and we're considering turning it on for all files. I > believe that this can't be used with journaling, but we don't do that. > Theoretically, this would have a small negative impact on performance, but > we never seem to get around to reorganizing files. > On the other side, have some of you effectively automated reorganizing all > JBA files. If so, did you use some tool or utility to accomplish this? > > Dan Thomas > Sr. VP Information Systems > Medical Distribution, Inc. > 4500 Progress Blvd > Louisville, KY 40218-5058 > Phone (502) 454-9013 ext 120 > email DThomas@lpw-mdi.com > > +--- > | This is the JBA Software Users Mailing List! > | To submit a new message send your mail to JBAUSERS-L@midrange.com. > | To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com. > | To unsubscribe from this list send email to > JBAUSERS-L-UNSUB@midrange.com. > | Questions should be directed to the list owner: doug333@aol.com. > +--- +--- | This is the JBA Software Users Mailing List! | To submit a new message send your mail to JBAUSERS-L@midrange.com. | To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com. | To unsubscribe from this list send email to JBAUSERS-L-UNSUB@midrange.com. | Questions should be directed to the list owner: doug333@aol.com. +---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.