Re: mastercatalog

2006-10-04 Thread Rob Scott
Have a look at the REPRO MERGECAT service in the SMS manuals - you will need something like this (after locking both catalogs) //STEP1 EXEC PGM=IDCAMS //SYSPRINT DD SYSOUT=* //SYSIN DD * REPRO INDATASET(MASTERCAT) -

Re: mastercatalog

2006-10-04 Thread Larry Crilley
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

Re: mastercatalog

2006-10-04 Thread Rob Scott
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

Re: mastercatalog

2006-10-04 Thread Larry Crilley
: 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

Re: mastercatalog

2006-10-04 Thread Jon Brock
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(m

Re: mastercatalog

2006-10-04 Thread Ed Gould
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 c

Re: mastercatalog

2006-10-04 Thread Glenn Siegel
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: > >

Re: mastercatalog

2006-10-04 Thread Ed Gould
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 th

Re: mastercatalog

2006-10-07 Thread Ken Gunther
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 dataset