I had the same situation, trying to copy/restore one database from one computer to another (pre-production to Production).
However, there was not any way to change the SCHEMA, the IBM recommendation was "Make the EXPORT on Server A, FTP from A to B, and LOAD the data on B).
I found another solution, this time it works,
I have created a GLOBAL user with SYSADM authorization, I use this USER for all the maintenance (Create tables, create schema, etc),
I can just make the BACKUP on server An and RESTORE on B (Restore redirect) and the schemas will be owned by the same USER because this GLOBAL user is ON all the servers.
Maybe this idea can help you!
Good luck!
Miguel Celi
DB2 DBA
Northern Trust Bank
Chicago, IL.
Subj:DB2EUG: change schema id
Date:11/21/01 06:11:53 PM Central Standard Time
From:[EMAIL PROTECTED]
Reply-to:[EMAIL PROTECTED]
To:[EMAIL PROTECTED]
File:Disclaimer.txt (607 bytes) DL Time (TCP/IP): < 1 minute
Sent from the Internet
Hi all,
I am running UDB7.1 on NT4.
Is there a way to copy a database from the server A to server B and change
the schema (table qualifier) from XXX to YYY ?
TIA,
Shirley.
Miguel Celi
3950 North Lake Shore Dr. 723-D
Chicago, Illinois 60613
USA
