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:[email protected]] On Behalf Of Larry Crilley Sent: Friday, May 15, 2009 10:48 AM To: [email protected] 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:[email protected]] On Behalf Of George Rodriguez Sent: Friday, May 15, 2009 10:42 AM To: [email protected] 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:[email protected]] On Behalf Of Ward, Mike S Sent: Friday, May 15, 2009 10:28 AM To: [email protected] 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:[email protected]] On Behalf Of George Rodriguez Sent: Friday, May 15, 2009 9:22 AM To: [email protected] 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:[email protected]] On Behalf Of Spencer, Mike Sent: Friday, May 15, 2009 10:10 AM To: [email protected] 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:[email protected]] On Behalf Of Larry Crilley Sent: Friday, May 15, 2009 10:00 AM To: [email protected] Subject: Re: USERCAT Error (Out of Space) You have to keep in mind that a usercatalog is basically a KSDS. When you delete records, there are keys associated with them. If new keys you add do not collate properly, then VSAM will add them to freespace at the end. A REORG would reclaim this space. There are a few products on the market that would allow you to do this without any downtime, T-REX from Dino-Software being one of them. However, if you have a maintenance window, you could use IDCAMS EXPORT and IMPORT. If you have more questions, feel free to contact me directly. Larry Crilley 412.366.3566 -----Original Message----- From: IBM Mainframe Discussion List [mailto:[email protected]] On Behalf Of George Rodriguez Sent: Friday, May 15, 2009 9:24 AM To: [email protected] Subject: USERCAT Error (Out of Space) I've got this out of space problem in one of our user catalogs. Since this particular catalog is used by a bunch of STC, I was thinking of expanding the catalog this Sunday in a window. Here's my question...Is it possible to REORG the catalog to reclaim "dead space"? I've deleted about 600 entries but that only bought me about 4 hours until it got full again. George Rodriguez Specialist, Systems Programmer Network & Technical Services (561) 357-7652 (office) (561) 707-3496 (mobil) School District of Palm Beach County 3348 Forest Hill Blvd. Room B-332 West Palm Beach, FL. 33406-5869 Rated "A" by the Florida Department of Education 2005, 2006, 2007 & 2008 ----------------------------------------- Under Florida law, e-mail addresses are public records. If you do not want your e-mail address released in response to a public records request, do not send electronic mail to this entity. Instead, contact this office by phone or in writing. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html ========================== This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to which they are addressed. If you have received this email in error please notify the system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. If you are not the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
