HI Shirley, What it comes to my mind is to use the db2move and the db2look utilities: 1) Use the db2look to get the ddl to recreate the server A DB on server B. 2) Then use sed to change the schema XXX to YYY in the db2look file. 3) ftp the modified db2look file to server B. 4) create th new DB on the server B. 5) Use db2move to export all the data. 6) ftp all the export file from server A to server B. 7) Use sed to change in the db2move.lst file the schema XXX to YYY. 8) load the exports in the DB on server B.
Well this is the only thing that came to my mind. Hope this helps Fabrizio -----Original Message----- From: Shirley Fan To: [EMAIL PROTECTED] Sent: 22/11/01 0.12 Subject: DB2EUG: change schema id 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. <<Disclaimer.txt>> ===== To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
