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 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
----------------------------------------------------------------------
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
