Re: mastercatalog
I had a similar problem many years ago on an MVS/XA system. What I did was to create an alias (let's call it SAPQA1) for a usercatalog. I then took the listing of datasets and wrote a program to create a TSO CLIST that renamed the files from SAPQUAS... to SAPQA1... Once all the SAPQUAS datasets were renamed you can then define SAPQUAS as an alias for a usercatalog and run the CLIST renaming all the files from SAPQA1... back to SAPQUAS... The TSO rename command placed the files in the proper catalog (at least it did in MVS/XA) Ken G. Zoran Trifunovic wrote: We have sap on db2 v.8 on zseries. We made mistake, we don't define alias SAPQAS for tables (we have about 50 tables).We have a large number (about 5) entires (SAPQUAS..) in mastercatalog. My questuin: How can i move entries (sapqas) from mastercatalog to any usercatalog Best regards, PTT Serbia Zoran Trifunovic -- 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
Re: mastercatalog
You can use IDCAMS REPRO MERGECAT, but the process can be painfully slow. I can volunteer a copy of our T-REX product that can perform the REPRO MERGECAT in a fraction of the time as compared to IDCAMS. Just contact me offline. Another consideration, since these are DB2 files, is that all files must be CLOSED. This is true for IDCAMS REPRO MERGECAT and T-REX. My only advise here would be our TERADON product that can perform the REPRO MERGECAT process while the dataset remain OPEN. Larry Crilley Dino Software, Corp. http://www.dino-software.com/ 412.734.2853 -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Zoran Trifunovic Sent: Wednesday, October 04, 2006 6:47 AM To: IBM-MAIN@BAMA.UA.EDU Subject: mastercatalog We have sap on db2 v.8 on zseries. We made mistake, we don't define alias SAPQAS for tables (we have about 50 tables).We have a large number (about 5) entires (SAPQUAS..) in mastercatalog. My questuin: How can i move entries (sapqas) from mastercatalog to any usercatalog Best regards, PTT Serbia Zoran Trifunovic -- 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
Re: mastercatalog
There is also Catalog Recovery Plus (CR+) from Mainstar (www.mainstar.com) that does the same thing. Rob Scott Rocket Software, Inc 275 Grove Street Newton, MA 02466 617-614-2305 [EMAIL PROTECTED] http://www.rs.com/portfolio/mxi/ -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Larry Crilley Sent: 04 October 2006 08:46 To: IBM-MAIN@BAMA.UA.EDU Subject: Re: mastercatalog You can use IDCAMS REPRO MERGECAT, but the process can be painfully slow. I can volunteer a copy of our T-REX product that can perform the REPRO MERGECAT in a fraction of the time as compared to IDCAMS. Just contact me offline. Another consideration, since these are DB2 files, is that all files must be CLOSED. This is true for IDCAMS REPRO MERGECAT and T-REX. My only advise here would be our TERADON product that can perform the REPRO MERGECAT process while the dataset remain OPEN. Larry Crilley Dino Software, Corp. http://www.dino-software.com/ 412.734.2853 -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Zoran Trifunovic Sent: Wednesday, October 04, 2006 6:47 AM To: IBM-MAIN@BAMA.UA.EDU Subject: mastercatalog We have sap on db2 v.8 on zseries. We made mistake, we don't define alias SAPQAS for tables (we have about 50 tables).We have a large number (about 5) entires (SAPQUAS..) in mastercatalog. My questuin: How can i move entries (sapqas) from mastercatalog to any usercatalog Best regards, PTT Serbia Zoran Trifunovic -- 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
Re: mastercatalog
Correct. Unless the dataset are OPEN and then only TERADON can perform the REPRO MERGECAT process. Larry Crilley Dino Software, Corp. http://www.dino-software.com/ 412.734.2853 -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Rob Scott Sent: Wednesday, October 04, 2006 10:20 AM To: IBM-MAIN@BAMA.UA.EDU Subject: Re: mastercatalog There is also Catalog Recovery Plus (CR+) from Mainstar (www.mainstar.com) that does the same thing. Rob Scott Rocket Software, Inc 275 Grove Street Newton, MA 02466 617-614-2305 [EMAIL PROTECTED] http://www.rs.com/portfolio/mxi/ -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Larry Crilley Sent: 04 October 2006 08:46 To: IBM-MAIN@BAMA.UA.EDU Subject: Re: mastercatalog You can use IDCAMS REPRO MERGECAT, but the process can be painfully slow. I can volunteer a copy of our T-REX product that can perform the REPRO MERGECAT in a fraction of the time as compared to IDCAMS. Just contact me offline. Another consideration, since these are DB2 files, is that all files must be CLOSED. This is true for IDCAMS REPRO MERGECAT and T-REX. My only advise here would be our TERADON product that can perform the REPRO MERGECAT process while the dataset remain OPEN. Larry Crilley Dino Software, Corp. http://www.dino-software.com/ 412.734.2853 -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Zoran Trifunovic Sent: Wednesday, October 04, 2006 6:47 AM To: IBM-MAIN@BAMA.UA.EDU Subject: mastercatalog We have sap on db2 v.8 on zseries. We made mistake, we don't define alias SAPQAS for tables (we have about 50 tables).We have a large number (about 5) entires (SAPQUAS..) in mastercatalog. My questuin: How can i move entries (sapqas) from mastercatalog to any usercatalog Best regards, PTT Serbia Zoran Trifunovic -- 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
Re: mastercatalog
Zoran, The MERGECAT option of REPRO should do what you need. Try something like: //STEP1EXEC PGM=IDCAMS //DD1 DDVOL=SER=xx,UNIT=DISK,DISP=OLD // DDVOL=SER=yy,UNIT=DISK,DISP=OLD //SYSPRINT DDSYSOUT=X //SYSINDD* REPRO - INDATASET(master.catalog) - OUTDATASET(user.catalog) - LEVEL(SAPQUAS) - MERGECAT - FILE(DD1) After doing the REPRO MERGECAT, you should be able to define an alias and be in good shape. Jon snip We have sap on db2 v.8 on zseries. We made mistake, we don't define alias SAPQAS for tables (we have about 50 tables).We have a large number (about 5) entires (SAPQUAS..) in mastercatalog. My questuin: How can i move entries (sapqas) from mastercatalog to any usercatalog /snip -- 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
Re: mastercatalog
Look at repro mergcat Ed On Oct 4, 2006, at 5:46 AM, Zoran Trifunovic wrote: We have sap on db2 v.8 on zseries. We made mistake, we don't define alias SAPQAS for tables (we have about 50 tables).We have a large number (about 5) entires (SAPQUAS..) in mastercatalog. My questuin: How can i move entries (sapqas) from mastercatalog to any usercatalog Best regards, PTT Serbia Zoran Trifunovic -- 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
Re: mastercatalog
I like the old IPO CATCVTM to build a new master catalog allthough it's unsupported, there also a rewite of it in rexx on the CBT Tape. On Wed, 4 Oct 2006 19:04:21 -0500, Ed Gould [EMAIL PROTECTED] wrote: Look at repro mergcat Ed On Oct 4, 2006, at 5:46 AM, Zoran Trifunovic wrote: We have sap on db2 v.8 on zseries. We made mistake, we don't define alias SAPQAS for tables (we have about 50 tables).We have a large number (about 5) entires (SAPQUAS..) in mastercatalog. My questuin: How can i move entries (sapqas) from mastercatalog to any usercatalog Best regards, PTT Serbia Zoran Trifunovic -- 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
Re: mastercatalog
On Oct 4, 2006, at 7:16 PM, Glenn Siegel wrote: I like the old IPO CATCVTM to build a new master catalog allthough it's unsupported, there also a rewite of it in rexx on the CBT Tape. Glenn, Good idea.. REPRO MERGECAT is *PAINFULLY SLOW* there are other products (from DINO ?) out there that might do the same thing. Do you think IBM would take an APAR against repro mergecat for being so *SLOW* ? Ed On Wed, 4 Oct 2006 19:04:21 -0500, Ed Gould [EMAIL PROTECTED] wrote: Look at repro mergcat Ed On Oct 4, 2006, at 5:46 AM, Zoran Trifunovic wrote: We have sap on db2 v.8 on zseries. We made mistake, we don't define alias SAPQAS for tables (we have about 50 tables).We have a large number (about 5) entires (SAPQUAS..) in mastercatalog. My questuin: How can i move entries (sapqas) from mastercatalog to any usercatalog Best regards, PTT Serbia Zoran Trifunovic -- 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