George, Let me second Mike Spencer's recommendation to backup the catalog before starting. Depending on your level of experience, confidence both an Export and a Volume backup might be in order. Also make sure the HLQ of your backup is not an alias in the catalog being worked on. I saw a co-worker do that. He deleted the catalog and then could not access the now uncataloged SMS managed backup dataset.
Dave O'Brien NIH Contractor ________________________________________ From: IBM Mainframe Discussion List [ibm-m...@bama.ua.edu] On Behalf Of George Rodriguez [rodrigu...@palmbeach.k12.fl.us] Sent: Friday, May 15, 2009 10:21 AM To: IBM-MAIN@bama.ua.edu Subject: Re: USERCAT Error (Out of Space) >From all the responses that I've gotten, it seems a product is "highly" recommended. To answer some of the questions asked or implied ... No I have not exceed the alias limit ... in fact there will only be 15 alias' defined after all is said and done. The original catalog was defined only with a primary space or 230 tracks (no secondary allocation). I do have a window already scheduled for 7:00 am Sunday morning. Yes, after all is said and done, I will run an examine to make sure everything is ok... Thanks, George Rodriguez Specialist, Systems Programmer Network & Technical Services (561) 357-7652 (office) (561) 707-3496 (mobil) School District of Palm Beach County 3348 Forest Hill Blvd. Room B-332 West Palm Beach, FL. 33406-5869 Rated "A" by the Florida Department of Education 2005, 2006, 2007 & 2008 -----Original Message----- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of Spencer, Mike Sent: Friday, May 15, 2009 10:10 AM To: IBM-MAIN@bama.ua.edu Subject: Re: USERCAT Error (Out of Space) T-Rex is a nice product that might be able to help you in this situation. If you do have a window of downtime, the suggestion would be to perform an IDCAMS MERGECAT. If you're at the limit of alias entries, than you should split the catalog into multiple usercats. You should look at the size of the current usercat and the number of entries in the catalog. Michael Spencer BMC Software -----Original Message----- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of Larry Crilley Sent: Friday, May 15, 2009 10:00 AM To: IBM-MAIN@bama.ua.edu Subject: Re: USERCAT Error (Out of Space) You have to keep in mind that a usercatalog is basically a KSDS. When you delete records, there are keys associated with them. If new keys you add do not collate properly, then VSAM will add them to freespace at the end. A REORG would reclaim this space. There are a few products on the market that would allow you to do this without any downtime, T-REX from Dino-Software being one of them. However, if you have a maintenance window, you could use IDCAMS EXPORT and IMPORT. If you have more questions, feel free to contact me directly. Larry Crilley 412.366.3566 -----Original Message----- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of George Rodriguez Sent: Friday, May 15, 2009 9:24 AM To: IBM-MAIN@bama.ua.edu Subject: USERCAT Error (Out of Space) I've got this out of space problem in one of our user catalogs. Since this particular catalog is used by a bunch of STC, I was thinking of expanding the catalog this Sunday in a window. Here's my question...Is it possible to REORG the catalog to reclaim "dead space"? I've deleted about 600 entries but that only bought me about 4 hours until it got full again. George Rodriguez Specialist, Systems Programmer Network & Technical Services (561) 357-7652 (office) (561) 707-3496 (mobil) School District of Palm Beach County 3348 Forest Hill Blvd. Room B-332 West Palm Beach, FL. 33406-5869 Rated "A" by the Florida Department of Education 2005, 2006, 2007 & 2008 ----------------------------------------- Under Florida law, e-mail addresses are public records. If you do not want your e-mail address released in response to a public records request, do not send electronic mail to this entity. Instead, contact this office by phone or in writing. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu 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 lists...@bama.ua.edu 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 lists...@bama.ua.edu 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 lists...@bama.ua.edu 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 lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html