Simon, Assuming you are on the same operating system (AIX : the version isn't a problem) and the new machine has DB2 at the same or higher version and fix level, then a restore from a backup is the best way to go.
If the disk structure and directories are different on the target machine then you will need a redirected restore to change the tablespace definitions. I can help with a script which will give you a "starter for ten" in generating the redirected restore script. Just drop me a private email and I'll send it to you. Phil On Thu, 2002-03-21 at 13:14, Dimoline, Simon wrote: > AIX 4.3.2 to AIX 4.3.3 > DB2 v5.2 > Hello all, > We are upgrading our server and moving the db2 databases onto the new > machine. All the tables have been copied but some of the SYSCAT tables > haven't been e.g. packages, functions. > Will doing a restore on the new machine from a backup of the database on the > old machine solve the problem? or is there another 'right' way to duplicate > a database. > Any help or pointers on this gratefully received. > Simon. > > > "This communication is intended solely for the addressee and is confidential and not >for third party unauthorised distribution." - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
