Sunil, To export a SQL/PL procedure you can use:- "db2 get routine into \<procname>.sar from procedure <procname>"
To import the SQL/PL procedure into your new database, use:- "db2 put routine from \<procname>.sar" Simple, eh! For more info, there's an excellent document here:- http://www7b.software.ibm.com/dmdd/library/events/0205dwlive/e1110/E1110.pdf -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Sunil Inchal Sent: 31 July 2003 16:55 To: [EMAIL PROTECTED] Subject: [DB2EUG] Migration from AIX to HP Hi all, Right now we have DB2 V8.1 installed on AIX 5. We are planning to move all tdatabases on this instance to HP UX. What's the best way of doing this? I suppose db2move only moves tables, indexes etc. what about stored procedures (SQL and JAVA) and other objects? I think taking backup on AIX and restoring it on HP won't work. In Informix we used to dbexport databases (which will export all databases including tables, indexes, constriants, views, synonyms, stored procedures, user privileges), I mean exact copy of database, with just two simple statements, dbexport on source database and dbimport on target database. How this can be done in DB2 environment in the easiest way? Thanks and regards Sunil - ::: 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 - ::: 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
