Checkout out the CATSCRUB function of Catalog RecoveryPlus from Mainstar/Rocket Software: www.mainstar.com
Bob Richards -----Original Message----- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Harold Zbiegien Sent: Tuesday, December 12, 2006 6:02 PM To: IBM-MAIN@BAMA.UA.EDU Subject: delete noscratch performance at DR We have a performance problem I am trying to improve. When we do our Disaster recovery tests we wind up do a large amount of delete noscratch against our user catalogs. We basically uncatalog all of our disk datasets leaving just the tape datasets in the catalogs. The catalogs are restored along with full pack restores of certain volumes. We then selectively restore our needed disk datasets, almost always to different volsers than in production. Well we generate the IDCAMS delete noscratch statements in about 20 seconds, but then running the acutal IDCAMS deletes takes upwards of 80 minutes to uncatalog 92,000 entries from our largest user catalog. We delete them in alphabetical order. Do you know of anyway I can SPEED up this process?? The job runs unconstrained. It pretty much is the only thing running in the system, it (CATALOG address space) must be doing a huge amount of IO. I though perhaps deleteing things in reverse alphabetical order might improve things but that is just a wild guess. LEGAL DISCLAIMER The information transmitted is intended solely for the individual or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you have received this email in error please contact the sender and delete the material from any computer. SunTrust and Seeing beyond money are federally registered service marks of SunTrust Banks, Inc. [ST:XCL] ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
