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:[email protected]] On Behalf Of Larry Crilley Sent: Friday, May 15, 2009 10:00 AM To: [email protected] 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:[email protected]] On Behalf Of George Rodriguez Sent: Friday, May 15, 2009 9:24 AM To: [email protected] 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 [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 ---------------------------------------------------------------------- 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
