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
Re: USERCAT Error (Out of Space)
I would look at: a) clean up unneeded entries b) reorg c) expand the space d) split the catalog e) all of the above Dennis Roach GHG Corporation Lockheed Martin Mission Services Flight Design and Operations Contract NASA/JSC Address: 2100 Space Park Drive LM-15-4BH Houston, Texas 77058 Mail: P.O. Box 58487 Mail Code H4C Houston, Texas 77258 Phone: Voice: (281)336-5027 Cell: (713)591-1059 Fax:(281)336-5410 E-Mail: dennis.ro...@lmco.com All opinions expressed by me are mine and may not agree with my employer or any person, company, or thing, living or dead, on or near this or any other planet, moon, asteroid, or other spatial object, natural or manufactured, since the beginning of time. > -Original Message- > From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On > Behalf Of George Rodriguez > Sent: Friday, May 15, 2009 8: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
Re: USERCAT Error (Out of Space)
Catalog Recovery Plus from Mainstar.com will allow you to increase the size of your catalog, re-organize it with optimum CI sizes and move it if necessary to another volume, non-disruptively. In theory this can be done with multiple LPARs accessing the catalog. In practice I've done this type of catalog work during quiet times on Sunday. I suspect there are other products, CRP is just the one with which I'm most familiar. 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 9:23 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
Re: USERCAT Error (Out of Space)
Dave, Can this process be done using standard repro commands or do I need a product to do it? 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 O'Brien, David W. (NIH/CIT) [C] Sent: Friday, May 15, 2009 9:41 AM To: IBM-MAIN@bama.ua.edu Subject: Re: USERCAT Error (Out of Space) Catalog Recovery Plus from Mainstar.com will allow you to increase the size of your catalog, re-organize it with optimum CI sizes and move it if necessary to another volume, non-disruptively. In theory this can be done with multiple LPARs accessing the catalog. In practice I've done this type of catalog work during quiet times on Sunday. I suspect there are other products, CRP is just the one with which I'm most familiar. 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 9:23 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
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
Re: USERCAT Error (Out of Space)
Sure, if you like living dangerously. You might consider allocating a new larger catalog then use Idcams Mergecat to move the entries. I would move them selectively ensuring that my most important HLQs were moved first. Also you will want to run Diagnose and Examine commands to make sure the catalog is clean. Good Luck, Dave O'Brien NIH Contractor PS. I have had Mergecat fail in the far distant past which is partially why I prefer CRP. That was years ago and I'm sure IBM has improved the code. 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 9:48 AM To: IBM-MAIN@bama.ua.edu Subject: Re: USERCAT Error (Out of Space) Dave, Can this process be done using standard repro commands or do I need a product to do it? 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 O'Brien, David W. (NIH/CIT) [C] Sent: Friday, May 15, 2009 9:41 AM To: IBM-MAIN@bama.ua.edu Subject: Re: USERCAT Error (Out of Space) Catalog Recovery Plus from Mainstar.com will allow you to increase the size of your catalog, re-organize it with optimum CI sizes and move it if necessary to another volume, non-disruptively. In theory this can be done with multiple LPARs accessing the catalog. In practice I've done this type of catalog work during quiet times on Sunday. I suspect there are other products, CRP is just the one with which I'm most familiar. 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 9:23 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
Re: USERCAT Error (Out of Space)
I appreciate your honesty about living dangerously and your PS on your failure and I'm thing to myself ... I'm on a 1.4 system ... Should I be concerned? 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 O'Brien, David W. (NIH/CIT) [C] Sent: Friday, May 15, 2009 10:02 AM To: IBM-MAIN@bama.ua.edu Subject: Re: USERCAT Error (Out of Space) Sure, if you like living dangerously. You might consider allocating a new larger catalog then use Idcams Mergecat to move the entries. I would move them selectively ensuring that my most important HLQs were moved first. Also you will want to run Diagnose and Examine commands to make sure the catalog is clean. Good Luck, Dave O'Brien NIH Contractor PS. I have had Mergecat fail in the far distant past which is partially why I prefer CRP. That was years ago and I'm sure IBM has improved the code. 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 9:48 AM To: IBM-MAIN@bama.ua.edu Subject: Re: USERCAT Error (Out of Space) Dave, Can this process be done using standard repro commands or do I need a product to do it? 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 O'Brien, David W. (NIH/CIT) [C] Sent: Friday, May 15, 2009 9:41 AM To: IBM-MAIN@bama.ua.edu Subject: Re: USERCAT Error (Out of Space) Catalog Recovery Plus from Mainstar.com will allow you to increase the size of your catalog, re-organize it with optimum CI sizes and move it if necessary to another volume, non-disruptively. In theory this can be done with multiple LPARs accessing the catalog. In practice I've done this type of catalog work during quiet times on Sunday. I suspect there are other products, CRP is just the one with which I'm most familiar. 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 9:23 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/arc
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
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
Re: USERCAT Error (Out of Space)
George, As an FYI, I've completed hundreds of MERGECATS through many different releases of MVS without any problems. There was a problem many years ago with SMS managed data and a usercat move. I don't remember the specifics, but it was back in the ESA days. With a usercat of only 230 tracks, a MERGECAT into a larger catalog would not take much time and would be easy to verify the results. Be sure to back up the original usercat before doing any work. :-) Michael Spencer BMC Software -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of George Rodriguez Sent: Friday, May 15, 2009 10:22 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 w
Re: USERCAT Error (Out of Space)
You said you gained 4 hours by deleting a lot of entries. What's eating your space? What's changed? Why now and not before? I'm just curious. -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of George Rodriguez Sent: Friday, May 15, 2009 9:22 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 =
Re: USERCAT Error (Out of Space)
I have a product called Power Exchange from Informatica and it creates these condense files. Right now I have 488 of these entries in the catalog in question...Nothing has really changed except that I'm allocating space more efficiently by using a better block size for the file. 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 Ward, Mike S Sent: Friday, May 15, 2009 10:28 AM To: IBM-MAIN@bama.ua.edu Subject: Re: USERCAT Error (Out of Space) You said you gained 4 hours by deleting a lot of entries. What's eating your space? What's changed? Why now and not before? I'm just curious. -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of George Rodriguez Sent: Friday, May 15, 2009 9:22 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/i
Re: USERCAT Error (Out of Space)
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 w
Re: USERCAT Error (Out of Space)
George Rodriguez wrote: 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... I don't have a "product", so I do this with IDCAMS. I have never had a problem. You should check Managing catalogs http://publibz.boulder.ibm.com/epubs/pdf/dgt2c160.pdf. If you want to re-org the catalog do something like this (note this is from memory, you should verify this): //CATREORG JOB //* //REORG EXEC PGM=IDCAMS //* //OUT DD DSN=unload.name, // UNIT=SYSDA, // SPACE=( // DISP=(NEW,CATLG) //SYSPRINT DD SYSOUT=* //SYSIN DD * ALTER CATALOG.catname LOCK /* */ IF MAXCC = 0 THEN + EXPORT catname - OUTFILE(OUT) - TEMPORARY /* */ IF MAXCC = 0 THEN + IMPORT INFILE(OUT) - OUTDATASET(catname) - ALIAS- CATALOG(mstcat) /* */ IF MAXCC = 0 THEN + ALTER CATALOG.catname UNLOCK If you want to make the catalog bigger, you need to delete reallocate it in the middle ot this. 1. ALTER catdsname LOCK 2. EXPORT catdsname OUTFILE(EXPDD) TEMPORARY 3. DELETE catdsname RECOVERY USERCATALOG 4. DEFINE USERCATALOG (many parameters) 5. IMPORT INDATASET(backupdsn) OUTDATASET(catdsname) ALIAS UNLOCK INTOEMPTY WARNING PRIVLEDGED TASK CAN BYPASS LOCK You may want to review IBM info APAR II13354 on moving catalogs. -- Richard -- 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
Re: USERCAT Error (Out of Space)
See II13354: MOVING ICF CATALOGS - STEP BY STEP SCENARIOS, INCLUDING SHARED CATALOGS on IBMLINK. You can probably do this right now with little or no impact. Of course, if you want to wait for the window... HTH, 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 -- 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
Re: USERCAT Error (Out of Space)
Do the files created by Power Exchange have a timestamp in the DSN. If so, you have the old "creeping key" problem and a REORG for this catalog will need to be scheduled periodically. I would not recommend a REPRO MERGECAT (IDCAMS) if files in the catalog are OPEN. There are a lot of issues when moving entries associated with OPEN datasets that are not covered by IDCAMS. -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of George Rodriguez Sent: Friday, May 15, 2009 10:42 AM To: IBM-MAIN@bama.ua.edu Subject: Re: USERCAT Error (Out of Space) I have a product called Power Exchange from Informatica and it creates these condense files. Right now I have 488 of these entries in the catalog in question...Nothing has really changed except that I'm allocating space more efficiently by using a better block size for the file. 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 Ward, Mike S Sent: Friday, May 15, 2009 10:28 AM To: IBM-MAIN@bama.ua.edu Subject: Re: USERCAT Error (Out of Space) You said you gained 4 hours by deleting a lot of entries. What's eating your space? What's changed? Why now and not before? I'm just curious. -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of George Rodriguez Sent: Friday, May 15, 2009 9:22 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 Flo
Re: USERCAT Error (Out of Space)
Richard Peurifoy wrote: George Rodriguez wrote: 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... I don't have a "product", so I do this with IDCAMS. I have never had a problem. You should check Managing catalogs http://publibz.boulder.ibm.com/epubs/pdf/dgt2c160.pdf. If you want to re-org the catalog do something like this (note this is from memory, you should verify this): //CATREORG JOB //* //REORG EXEC PGM=IDCAMS //* //OUT DD DSN=unload.name, // UNIT=SYSDA, // SPACE=( // DISP=(NEW,CATLG) //SYSPRINT DD SYSOUT=* //SYSIN DD * ALTER CATALOG.catname LOCK /* */ IF MAXCC = 0 THEN + EXPORT catname - OUTFILE(OUT) - TEMPORARY /* */ IF MAXCC = 0 THEN + IMPORT INFILE(OUT) - OUTDATASET(catname) - ALIAS- CATALOG(mstcat) /* */ IF MAXCC = 0 THEN + ALTER CATALOG.catname UNLOCK If you want to make the catalog bigger, you need to delete reallocate it in the middle ot this. 1. ALTER catdsname LOCK 2. EXPORT catdsname OUTFILE(EXPDD) TEMPORARY 3. DELETE catdsname RECOVERY USERCATALOG 4. DEFINE USERCATALOG (many parameters) 5. IMPORT INDATASET(backupdsn) OUTDATASET(catdsname) ALIAS UNLOCK INTOEMPTY WARNING PRIVLEDGED TASK CAN BYPASS LOCK You may want to review IBM info APAR II13354 on moving catalogs. I forgot to mention that you should use diagnose and examine on the old catalog before you start to make sure there are no existing problems. -- Richard -- 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
Re: USERCAT Error (Out of Space)
Larry, Yes, there a date and time stamp for each file...It looks like this: OEM#P.STR.V8.CND.CP090430.T0635812 Thanks for the heads up on the periodic "REORG" for this catalog. I may go a step further and change its HLQ so that it is in its own catalog... The reason I'm doing this Sunday is because all my other OEM products reside in the same catalog... 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 Larry Crilley Sent: Friday, May 15, 2009 10:48 AM To: IBM-MAIN@bama.ua.edu Subject: Re: USERCAT Error (Out of Space) Do the files created by Power Exchange have a timestamp in the DSN. If so, you have the old "creeping key" problem and a REORG for this catalog will need to be scheduled periodically. I would not recommend a REPRO MERGECAT (IDCAMS) if files in the catalog are OPEN. There are a lot of issues when moving entries associated with OPEN datasets that are not covered by IDCAMS. -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of George Rodriguez Sent: Friday, May 15, 2009 10:42 AM To: IBM-MAIN@bama.ua.edu Subject: Re: USERCAT Error (Out of Space) I have a product called Power Exchange from Informatica and it creates these condense files. Right now I have 488 of these entries in the catalog in question...Nothing has really changed except that I'm allocating space more efficiently by using a better block size for the file. 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 Ward, Mike S Sent: Friday, May 15, 2009 10:28 AM To: IBM-MAIN@bama.ua.edu Subject: Re: USERCAT Error (Out of Space) You said you gained 4 hours by deleting a lot of entries. What's eating your space? What's changed? Why now and not before? I'm just curious. -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of George Rodriguez Sent: Friday, May 15, 2009 9:22 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
Re: USERCAT Error (Out of Space)
Weekly, I run this job against all my catalogs: //STEP010 EXEC PGM=IDCAMS //SYSPRINT DD SYSOUT=* //SYSINDD * EXAMINE NAME(CATALOG.SBPBC.USERCAT)INDEXTEST DATATEST /* Since I started this about a year or so ago, I have not had one problem with any catalog. 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 Richard Peurifoy Sent: Friday, May 15, 2009 10:55 AM To: IBM-MAIN@bama.ua.edu Subject: Re: USERCAT Error (Out of Space) Richard Peurifoy wrote: > George Rodriguez wrote: >> 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... > > I don't have a "product", so I do this with IDCAMS. I have never > had a problem. > > You should check Managing catalogs > > http://publibz.boulder.ibm.com/epubs/pdf/dgt2c160.pdf. > > If you want to re-org the catalog do something like this > (note this is from memory, you should verify this): > > > //CATREORG JOB > //* > //REORG EXEC PGM=IDCAMS > //* > //OUT DD DSN=unload.name, > // UNIT=SYSDA, > // SPACE=( > // DISP=(NEW,CATLG) > //SYSPRINT DD SYSOUT=* > //SYSIN DD * > > ALTER CATALOG.catname LOCK > /* */ > IF MAXCC = 0 THEN + > EXPORT catname - > OUTFILE(OUT) - > TEMPORARY > /* */ > IF MAXCC = 0 THEN + > IMPORT INFILE(OUT) - > OUTDATASET(catname) - > ALIAS- > CATALOG(mstcat) > /* */ > IF MAXCC = 0 THEN + > ALTER CATALOG.catname UNLOCK > > > If you want to make the catalog bigger, you need to delete > reallocate it in the middle ot this. > > 1. ALTER catdsname LOCK > 2. EXPORT catdsname OUTFILE(EXPDD) TEMPORARY > 3. DELETE catdsname RECOVERY USERCATALOG > 4. DEFINE USERCATALOG (many parameters) > 5. IMPORT INDATASET(backupdsn) OUTDATASET(catdsname) ALIAS UNLOCK > INTOEMPTY > > > > > WARNING PRIVLEDGED TASK CAN BYPASS LOCK > You may want to review IBM info APAR II13354 on moving catalogs. > I forgot to mention that you should use diagnose and examine on the old catalog before you start to make sure there are no existing problems. -- Richard -- 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 - 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
Re: USERCAT Error (Out of Space)
There is another product I am familiar with that updated the key of the DSN to avoid the creeping key. I believe they simply put the timestamp before the date. I wonder if the vendor for your tool could do the same? -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of George Rodriguez Sent: Friday, May 15, 2009 11:02 AM To: IBM-MAIN@bama.ua.edu Subject: Re: USERCAT Error (Out of Space) Larry, Yes, there a date and time stamp for each file...It looks like this: OEM#P.STR.V8.CND.CP090430.T0635812 Thanks for the heads up on the periodic "REORG" for this catalog. I may go a step further and change its HLQ so that it is in its own catalog... The reason I'm doing this Sunday is because all my other OEM products reside in the same catalog... 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 Larry Crilley Sent: Friday, May 15, 2009 10:48 AM To: IBM-MAIN@bama.ua.edu Subject: Re: USERCAT Error (Out of Space) Do the files created by Power Exchange have a timestamp in the DSN. If so, you have the old "creeping key" problem and a REORG for this catalog will need to be scheduled periodically. I would not recommend a REPRO MERGECAT (IDCAMS) if files in the catalog are OPEN. There are a lot of issues when moving entries associated with OPEN datasets that are not covered by IDCAMS. -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of George Rodriguez Sent: Friday, May 15, 2009 10:42 AM To: IBM-MAIN@bama.ua.edu Subject: Re: USERCAT Error (Out of Space) I have a product called Power Exchange from Informatica and it creates these condense files. Right now I have 488 of these entries in the catalog in question...Nothing has really changed except that I'm allocating space more efficiently by using a better block size for the file. 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 Ward, Mike S Sent: Friday, May 15, 2009 10:28 AM To: IBM-MAIN@bama.ua.edu Subject: Re: USERCAT Error (Out of Space) You said you gained 4 hours by deleting a lot of entries. What's eating your space? What's changed? Why now and not before? I'm just curious. -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of George Rodriguez Sent: Friday, May 15, 2009 9:22 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 reco
Re: 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. --- In one of the manuals, I forget which, under the main heading "Managing ICF Catalogs", there was a set of sample JCL that demonstrated the exact process for the re-org of a ICF Catalog. I've used that JCL for years with nary a problem, although I broke it into multiple jobs for my own peace of mind. Select a quiet time, check it through to be sure you understand exactly what it's doing and I think you'll be quite pleased with the results. You should also investigate WHY this condition is occuring and consider alternative mechanisms when you find the problem/issue/process. -- Rick -- Remember that if you’re not the lead dog, the view never changes. -- 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
Re: USERCAT Error (Out of Space)
I believe Innovations FDR Compactor can be used to reorganize usercats on the fly also. If you have Compactor, your Sunday window would be a good time. It probably would be easier to use than IDCAMs. Eric Eric Bielefeld Sr. Systems Programmer Milwaukee, Wisconsin 414-475-7434 -- 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
Re: USERCAT Error (Out of Space)
Not so sure about FDR. Do you have a link? I see a lot of references to reorganizing datasets on a volume (releasing space, consolidate free space, consolidate data set extents, etc.), but I don't see any reference to reorganizing user catalogs. -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of Eric Bielefeld Sent: Friday, May 15, 2009 3:45 PM To: IBM-MAIN@bama.ua.edu Subject: Re: USERCAT Error (Out of Space) I believe Innovations FDR Compactor can be used to reorganize usercats on the fly also. If you have Compactor, your Sunday window would be a good time. It probably would be easier to use than IDCAMs. Eric Eric Bielefeld Sr. Systems Programmer Milwaukee, Wisconsin 414-475-7434 -- 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
Re: USERCAT Error (Out of Space)
Yeah, I believe COMPAKTOR will re-arrange the extents of a usercat, but I don't think it will even merge the extents. It certainly WILL NOT reorganize the catalog records. >>> Larry Crilley 5/15/2009 4:04 PM >>> Not so sure about FDR. Do you have a link? I see a lot of references to reorganizing datasets on a volume (releasing space, consolidate free space, consolidate data set extents, etc.), but I don't see any reference to reorganizing user catalogs. -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of Eric Bielefeld Sent: Friday, May 15, 2009 3:45 PM To: IBM-MAIN@bama.ua.edu Subject: Re: USERCAT Error (Out of Space) I believe Innovations FDR Compactor can be used to reorganize usercats on the fly also. If you have Compactor, your Sunday window would be a good time. It probably would be easier to use than IDCAMs. Eric Eric Bielefeld Sr. Systems Programmer Milwaukee, Wisconsin 414-475-7434 -- 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 CONFIDENTIALITY/EMAIL NOTICE: The material in this transmission contains confidential and privileged information intended only for the addressee. If you are not the intended recipient, please be advised that you have received this material in error and that any forwarding, copying, printing, distribution, use or disclosure of the material is strictly prohibited. If you have received this material in error, please (i) do not read it, (ii) reply to the sender that you received the message in error, and (iii) erase or destroy the material. Emails are not secure and can be intercepted, amended, lost or destroyed, or contain viruses. You are deemed to have accepted these risks if you communicate with us by email. Thank you. -- 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
Re: USERCAT Error (Out of Space)
Why not just pick one of the larger high level qualifiers and move it to another usercat, especially if the large high level is lightly used? MERGECAT will move the high level, and then all you need to do is delete and redefine the alias in all of the effected master catalogs. This might buy you more time until Sunday. C. Todd Burrell, PMP, MCP Lead z/OS Systems Programmer ITSO (404) 723-2017 (Cell) -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of Rick Fochtman Sent: Friday, May 15, 2009 1:06 PM To: IBM-MAIN@bama.ua.edu Subject: Re: 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. --- In one of the manuals, I forget which, under the main heading "Managing ICF Catalogs", there was a set of sample JCL that demonstrated the exact process for the re-org of a ICF Catalog. I've used that JCL for years with nary a problem, although I broke it into multiple jobs for my own peace of mind. Select a quiet time, check it through to be sure you understand exactly what it's doing and I think you'll be quite pleased with the results. You should also investigate WHY this condition is occuring and consider alternative mechanisms when you find the problem/issue/process. -- Rick -- Remember that if you're not the lead dog, the view never changes. -- 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
Re: USERCAT Error (Out of Space)
I was trying to find my CD with FDR, and I found it, but its too hard finding anything with a PDF file. I thought I read something in the book about reorging catalogs with Compactor, but its been a long time since I read about that, and I don't really remember what it does and doesn't do. I don't remember if FDR has their books on their web site, or if you have to own the product to access them. I know I always used the paper manual, which I could always find what I wanted. Eric Bielefeld Sr. Systems Programmer Milwaukee, Wisconsin 414-475-7434 - Original Message - From: "Scott Rowe" Newsgroups: bit.listserv.ibm-main To: Sent: Friday, May 15, 2009 3:42 PM Subject: Re: USERCAT Error (Out of Space) Yeah, I believe COMPAKTOR will re-arrange the extents of a usercat, but I don't think it will even merge the extents. It certainly WILL NOT reorganize the catalog records. Larry Crilley 5/15/2009 4:04 PM >>> Not so sure about FDR. Do you have a link? I see a lot of references to reorganizing datasets on a volume (releasing space, consolidate free space, consolidate data set extents, etc.), but I don't see any reference to reorganizing user catalogs. -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of Eric Bielefeld Sent: Friday, May 15, 2009 3:45 PM To: IBM-MAIN@bama.ua.edu Subject: Re: USERCAT Error (Out of Space) I believe Innovations FDR Compactor can be used to reorganize usercats on the fly also. If you have Compactor, your Sunday window would be a good time. It probably would be easier to use than IDCAMs. Eric Eric Bielefeld Sr. Systems Programmer Milwaukee, Wisconsin 414-475-7434 -- 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 CONFIDENTIALITY/EMAIL NOTICE: The material in this transmission contains confidential and privileged information intended only for the addressee. If you are not the intended recipient, please be advised that you have received this material in error and that any forwarding, copying, printing, distribution, use or disclosure of the material is strictly prohibited. If you have received this material in error, please (i) do not read it, (ii) reply to the sender that you received the message in error, and (iii) erase or destroy the material. Emails are not secure and can be intercepted, amended, lost or destroyed, or contain viruses. You are deemed to have accepted these risks if you communicate with us by email. Thank you. -- 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
Re: USERCAT Error (Out of Space)
In a message dated 5/15/2009 3:51:52 P.M. Central Daylight Time, z...@cdc.gov writes: MERGECAT will move the high level, and then all you need to do is delete and redefine the alias in all of the effected master catalogs. This might buy you more time until Sunday. >> ---> listc ent('ucat_name') **An Excellent Credit Score is 750. See Yours in Just 2 Easy Steps! (http://pr.atwola.com/promoclk/100126575x1221823239x1201398650/aol?redir=http://www.freecreditreport.com/pm/default.aspx?sc=668072&hmpgID=62&bcd=May Excfooter51509NO62) -- 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
Re: USERCAT Error (Out of Space)
Eric Bielefeld wrote: I was trying to find my CD with FDR, and I found it, but its too hard finding anything with a PDF file. I thought I read something in the book about reorging catalogs with Compactor, but its been a long time since I read about that, and I don't really remember what it does and doesn't do. I don't remember if FDR has their books on their web site, or if you have to own the product to access them. I know I always used the paper manual, which I could always find what I wanted. Probably what you are thinking of is that when compacting there was an option to reorg the VTOC so that all the unused DSCB's were at the end. I think the intent was to speed up VTOC searches, but it actually slowed most down, because usually the DSCB TTR was in the catalog entry, and after being reorg'd, they were wrong. This would eventually be corrected, because the system will recatalog datasets with bad DSCB TTR pointers. The compactor manual now recommends against reorging the VTOC. Of course if you are moving the VTOC this doesn't apply as the TTR's will be wrong anyway. I don't recall any option to reorg a CATALOG. -- Richard -- 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
Re: USERCAT Error (Out of Space)
You are probably correct. Maybe someone from Innovation will reply on Monday with the definitive answer. Eric Bielefeld Sr. Systems Programmer Milwaukee, Wisconsin 414-475-7434 - Original Message - From: "Richard Peurifoy" Newsgroups: bit.listserv.ibm-main To: Sent: Friday, May 15, 2009 4:45 PM Subject: Re: USERCAT Error (Out of Space) Eric Bielefeld wrote: I was trying to find my CD with FDR, and I found it, but its too hard finding anything with a PDF file. I thought I read something in the book about reorging catalogs with Compactor, but its been a long time since I read about that, and I don't really remember what it does and doesn't do. I don't remember if FDR has their books on their web site, or if you have to own the product to access them. I know I always used the paper manual, which I could always find what I wanted. Probably what you are thinking of is that when compacting there was an option to reorg the VTOC so that all the unused DSCB's were at the end. I think the intent was to speed up VTOC searches, but it actually slowed most down, because usually the DSCB TTR was in the catalog entry, and after being reorg'd, they were wrong. This would eventually be corrected, because the system will recatalog datasets with bad DSCB TTR pointers. The compactor manual now recommends against reorging the VTOC. Of course if you are moving the VTOC this doesn't apply as the TTR's will be wrong anyway. I don't recall any option to reorg a CATALOG. -- Richard -- 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
Re: USERCAT Error (Out of Space)
> -Original Message- > From: IBM Mainframe Discussion List > [mailto:ibm-m...@bama.ua.edu] On Behalf Of Eric Bielefeld > Sent: Saturday, 16 May 2009 7:57 AM > To: IBM-MAIN@bama.ua.edu > Subject: Re: USERCAT Error (Out of Space) > > You are probably correct. Maybe someone from Innovation will > reply on Monday with the definitive answer. > To answer the question about Innovation's FASTCPK product, it does not handle the internal reorganisation of catalogs. FASTCPK's primary function is to reduce free space fragmentation on a volume by the consolidation of free space areas. Additionally FASTCPK provides for the merging of dataset extents and the releasing or partial releasing of unused space from overallocated PS, PO, PDSE datasets and VSAM components. There are also features for the enlarging and/or moving of the volume's VTOC. Here's the link to FASTCPK on Innovation's web site for anyone who might be interested: http://www.innovationdp.fdr.com/products/fdr/fdrcpk.cfm Stephen Mednick Computer Supervisory Services Sydney, Australia Asia/Pacific representatives for Innovation Data Processing, Inc. -- 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
Re: USERCAT Error (Out of Space)
Also, because I like the product... CIM (Catalog Information Manager), from ASPG, Inc. (last I knew) is also a very good catalog mgmt tool. Very extensive ISPF interface; tons of online help, etc. The developers are also *very* willing to provide desired features/functions, as requested. All the best, Scott T. Harder On 5/15/09, O'Brien, David W. (NIH/CIT) [C] wrote: > Catalog Recovery Plus from Mainstar.com will allow you to increase the size > of your catalog, re-organize it with optimum CI sizes and move it if > necessary to another volume, non-disruptively. > In theory this can be done with multiple LPARs accessing the catalog. In > practice I've done this type of catalog work during quiet times on Sunday. > > I suspect there are other products, CRP is just the one with which I'm most > familiar. > > 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 9:23 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 > -- All the best, Scott T. Harder -- 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
Re: USERCAT Error (Out of Space)
I just wanted to say that the MERGECAT was successful. I did make a small mistake, but nothing that was not correctable. Thanks to all the members from the list that assisted and provided the support (you guys are really GREAT!). I think I'm going to make a pitch for one of the catalog recovery products that some of you have suggested. I'll look for any additional responses for products. BTW, one list member, Larry Crilley, mention "creeping key" and I was wondering if anyone else has heard about this. When I contacted the vendor of the software that creates the dataset he did not know anything about the problem. Any and all help is appreciated. Once again thanks for all the assistance... 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 Scott T. Harder Sent: Saturday, May 16, 2009 7:20 AM To: IBM-MAIN@bama.ua.edu Subject: Re: USERCAT Error (Out of Space) Also, because I like the product... CIM (Catalog Information Manager), from ASPG, Inc. (last I knew) is also a very good catalog mgmt tool. Very extensive ISPF interface; tons of online help, etc. The developers are also *very* willing to provide desired features/functions, as requested. All the best, Scott T. Harder On 5/15/09, O'Brien, David W. (NIH/CIT) [C] wrote: > Catalog Recovery Plus from Mainstar.com will allow you to increase the size > of your catalog, re-organize it with optimum CI sizes and move it if > necessary to another volume, non-disruptively. > In theory this can be done with multiple LPARs accessing the catalog. In > practice I've done this type of catalog work during quiet times on Sunday. > > I suspect there are other products, CRP is just the one with which I'm most > familiar. > > 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 9:23 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 > -- All the best, Scott T. Harder -- 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
Re: USERCAT Error (Out of Space)
> BTW, one list member, Larry Crilley, mention "creeping key" and I was wondering if anyone else has heard about this. George, The "Creeping key" - phenomenon comes up in a catalog when you have an application that constantly creates new dataset names containing either a sequence number or a date/timestamp (such as your application seems to do). As a new dataset gets cataloged, using a key higher than the previous ones, the record is written at the end of the chain of existing dataset names. Old datasets eventually expire and get deleted, leaving a deleted record somewhere in the catalog. What that means is that the catalog constantly grows, because each new dataset entry occupies new space within the catalog. "Holes" left within the catalog from previously deleted records hardly ever get reused. So, even if you have only a limited number of these datasets, the catalog grows and grows, using ever more space. A brief history lesson: This creepy phenomenon was first detected many years ago, when IBM introduced VSAM Usercatalogs. The VSAM usercatalog structure for GDGs (generation datasets) consisted of a GDG-base record and one physical GDG-entry record for each generation dataset (e.g.: ABC.DEF.G0001V00, ABC.DEF.G0002V00, etc.). As a '+1'-generation dataset was created, it was added after the '0'-generation record. The oldest generation record was deleted, if the GDG-limit was exceeded. Physically, within the catalog, the records looked like this (assuming a 2-generation limit): GDG-base-record, G0001V00, G0002V00 Adding a +1-generation: GDG-base-record, -deleted, G0002V00, G0003V00 Adding another +1-generation: GDG-base-record, -deleted, -deleted, G0003V00, G0004V00 And that's where the creepy part begins. Eventually, the CI used by these catalog records fills up, a CI-split is required and perhaps even a CA-split (and you know, what that means ...). These old VSAM Usercatalogs containing GDGs required constant care and frequent reorgs. (Well, IBM eventually solved this problem by inventing ICF Usercatalogs. Here GDG record structures are formatted differently and occupy a fixed amount of space that does not usually creep as each successive generation is added). Back to your application ... if it creates discreet dataset names containing timestamps or other constantly incremented sequence numbers, then you will encounter this problem and you will need to monitor and regularly reorg your catalog. The rate at which new datasets get created per day will determine the growth rate of your catalog and how frequent you will need to reorg. As far as I can see, the only way to minimize the impact of this application's behavior on other applications or users or even the entire system is to keep this application's datasets in a separate catalog. This allows a catalog reorg to be scheduled when it's convenient for the application, with little to no impact on others. HTH Regards, Ulrich Krueger -- 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
Re: USERCAT Error (Out of Space)
I enclose a link detaining the creeping key issue that may be of interest to you. http://www.mainstar.com/pdf/010-0107_ICFCAT-Prac_WP.pdf regards Amerigo -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of George Rodriguez Sent: Sunday, May 17, 2009 12:29 AM To: IBM-MAIN@bama.ua.edu Subject: Re: USERCAT Error (Out of Space) I just wanted to say that the MERGECAT was successful. I did make a small mistake, but nothing that was not correctable. Thanks to all the members from the list that assisted and provided the support (you guys are really GREAT!). I think I'm going to make a pitch for one of the catalog recovery products that some of you have suggested. I'll look for any additional responses for products. BTW, one list member, Larry Crilley, mention "creeping key" and I was wondering if anyone else has heard about this. When I contacted the vendor of the software that creates the dataset he did not know anything about the problem. Any and all help is appreciated. Once again thanks for all the assistance... 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 Scott T. Harder Sent: Saturday, May 16, 2009 7:20 AM To: IBM-MAIN@bama.ua.edu Subject: Re: USERCAT Error (Out of Space) Also, because I like the product... CIM (Catalog Information Manager), from ASPG, Inc. (last I knew) is also a very good catalog mgmt tool. Very extensive ISPF interface; tons of online help, etc. The developers are also *very* willing to provide desired features/functions, as requested. All the best, Scott T. Harder On 5/15/09, O'Brien, David W. (NIH/CIT) [C] wrote: > Catalog Recovery Plus from Mainstar.com will allow you to increase the size > of your catalog, re-organize it with optimum CI sizes and move it if > necessary to another volume, non-disruptively. > In theory this can be done with multiple LPARs accessing the catalog. In > practice I've done this type of catalog work during quiet times on Sunday. > > I suspect there are other products, CRP is just the one with which I'm most > familiar. > > 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 9:23 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 > -- All the best, Scott T. Harder -- 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 ---
Re: USERCAT Error (Out of Space)
Hi Amerigo, Thanks for the link to the white paper and you're about finding the article interesting. I will go back to vendor, Infomatica, and provide him with the link to the white paper to see what he says. Once again thanks Amerigo! 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 Dept. of Education 2005, 2006, 2007 & 2008 - Original Message - From: IBM Mainframe Discussion List To: IBM-MAIN@bama.ua.edu Sent: Sat May 16 19:10:02 2009 Subject: Re: USERCAT Error (Out of Space) I enclose a link detaining the creeping key issue that may be of interest to you. http://www.mainstar.com/pdf/010-0107_ICFCAT-Prac_WP.pdf regards Amerigo -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of George Rodriguez Sent: Sunday, May 17, 2009 12:29 AM To: IBM-MAIN@bama.ua.edu Subject: Re: USERCAT Error (Out of Space) I just wanted to say that the MERGECAT was successful. I did make a small mistake, but nothing that was not correctable. Thanks to all the members from the list that assisted and provided the support (you guys are really GREAT!). I think I'm going to make a pitch for one of the catalog recovery products that some of you have suggested. I'll look for any additional responses for products. BTW, one list member, Larry Crilley, mention "creeping key" and I was wondering if anyone else has heard about this. When I contacted the vendor of the software that creates the dataset he did not know anything about the problem. Any and all help is appreciated. Once again thanks for all the assistance... 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 Scott T. Harder Sent: Saturday, May 16, 2009 7:20 AM To: IBM-MAIN@bama.ua.edu Subject: Re: USERCAT Error (Out of Space) Also, because I like the product... CIM (Catalog Information Manager), from ASPG, Inc. (last I knew) is also a very good catalog mgmt tool. Very extensive ISPF interface; tons of online help, etc. The developers are also *very* willing to provide desired features/functions, as requested. All the best, Scott T. Harder On 5/15/09, O'Brien, David W. (NIH/CIT) [C] wrote: > Catalog Recovery Plus from Mainstar.com will allow you to increase the size > of your catalog, re-organize it with optimum CI sizes and move it if > necessary to another volume, non-disruptively. > In theory this can be done with multiple LPARs accessing the catalog. In > practice I've done this type of catalog work during quiet times on Sunday. > > I suspect there are other products, CRP is just the one with which I'm most > familiar. > > 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 9:23 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
Re: USERCAT Error (Out of Space)
Hi Ulrich, Thanks for the information... The brief history lesson was perfect in explaining how this all got started. Before I take any additional steps to migrating these datasets to their own catalog, I'm going to pursue this with the vendor... Thanks 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 -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of Ulrich Krueger Sent: Saturday, May 16, 2009 1:47 PM To: IBM-MAIN@bama.ua.edu Subject: Re: USERCAT Error (Out of Space) > BTW, one list member, Larry Crilley, mention "creeping key" and I was wondering if anyone else has heard about this. George, The "Creeping key" - phenomenon comes up in a catalog when you have an application that constantly creates new dataset names containing either a sequence number or a date/timestamp (such as your application seems to do). As a new dataset gets cataloged, using a key higher than the previous ones, the record is written at the end of the chain of existing dataset names. Old datasets eventually expire and get deleted, leaving a deleted record somewhere in the catalog. What that means is that the catalog constantly grows, because each new dataset entry occupies new space within the catalog. "Holes" left within the catalog from previously deleted records hardly ever get reused. So, even if you have only a limited number of these datasets, the catalog grows and grows, using ever more space. A brief history lesson: This creepy phenomenon was first detected many years ago, when IBM introduced VSAM Usercatalogs. The VSAM usercatalog structure for GDGs (generation datasets) consisted of a GDG-base record and one physical GDG-entry record for each generation dataset (e.g.: ABC.DEF.G0001V00, ABC.DEF.G0002V00, etc.). As a '+1'-generation dataset was created, it was added after the '0'-generation record. The oldest generation record was deleted, if the GDG-limit was exceeded. Physically, within the catalog, the records looked like this (assuming a 2-generation limit): GDG-base-record, G0001V00, G0002V00 Adding a +1-generation: GDG-base-record, -deleted, G0002V00, G0003V00 Adding another +1-generation: GDG-base-record, -deleted, -deleted, G0003V00, G0004V00 And that's where the creepy part begins. Eventually, the CI used by these catalog records fills up, a CI-split is required and perhaps even a CA-split (and you know, what that means ...). These old VSAM Usercatalogs containing GDGs required constant care and frequent reorgs. (Well, IBM eventually solved this problem by inventing ICF Usercatalogs. Here GDG record structures are formatted differently and occupy a fixed amount of space that does not usually creep as each successive generation is added). Back to your application ... if it creates discreet dataset names containing timestamps or other constantly incremented sequence numbers, then you will encounter this problem and you will need to monitor and regularly reorg your catalog. The rate at which new datasets get created per day will determine the growth rate of your catalog and how frequent you will need to reorg. As far as I can see, the only way to minimize the impact of this application's behavior on other applications or users or even the entire system is to keep this application's datasets in a separate catalog. This allows a catalog reorg to be scheduled when it's convenient for the application, with little to no impact on others. HTH Regards, Ulrich Krueger -- 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 - 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