The best way would be to use a product like T-REX. The T-REX SCRUB command will remove entries from your usercatalogs without the need to go thru IDCAMS. Also, T-REX is the only tool on the market that can subtask the SCRUB process. As many as 32 catalogs can be scrubbed simultaneously.
Of course, an even better option would be to use the T-REX DRIMPORT command. This will reload your usercatalogs (delete and redefine them, reestablish all ALIAS, etc) and provide you with the option to only restore entries defined to TAPE. Thus, your time to SCRUB is eliminated completely. When your catalogs are reloaded, only your tape entries are restored. Larry Crilley Dino Software, Corp. http://www.dino-software.com/ 412.734.2853 -----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. Harold ---------------------------------------------------------------------- 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 ---------------------------------------------------------------------- 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