>I think taking backup on AIX and restoring it on HP won't work.
You are correct.
>I suppose db2move only moves tables, indexes etc. what about stored
>procedures (SQL and JAVA) and other objects?
Look at db2look, which reverse-engineers a DB2 database into a DDL script.
It can be run while the database is active. I've used it to create build
scripts for test environments by running db2look on production. Some people
even use db2look to extract production statistics (indexes, tables, etc)
and load them into test in order to trick the optimizer into behaving like
it does on production. Overall, db2look is an excellent tool.
Fred Sobotka
IBM Certified Database Administrator - DB2 UDB V8.1 for Linux, UNIX, and
Windows
CollegeNET, Inc.
-
::: 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
