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) -             
      OUTDATASET(USERCAT) -             
      MERGECAT -                            
      LVL(SAPQAS)

 DEF ALIAS(NAME(SAPQAS) REL(USERCAT))      
/*                                           


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 Zoran Trifunovic
Sent: 04 October 2006 06:47
To: [email protected]
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 500000 tables).We have a large
number (about 50000) 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

Reply via email to