MQSeries.net :: View topic - Problems migrating MQWF W2k/DB2 7.2 database to AIX/DB2 8.2

justinfung

This is using MQWF 3.4.5...

1. Ran db2look -d <dbname> -a -e -m -l -xd -f -i <username>-w <password> -o filename.sql to export DDL from Server 1 (Win2k/DB2 7.2)
2. Ran db2move to EXPORT data from Server 1 into IXF files (DB2's standard interchange files)
3. Created a new database on Server 2 (pSeries/AIX/DB2 8.2)
4. Modified the DDL from step 1 to amend paths for tablespaces
5. Applied the DDL to Server 2
6. Ran db2move to LOAD data into the new database
7. Upgraded the db2 client on the MQWF server to 8.2
8. Catalogued the new database residing on Server 2 on MQWF server
9. Ran the IBM WebSphere MQ Workflow Configuration assistant.

I created a new MQWF configuration, and selected the newly created database on the pSeries, however, after clicking the database in the MQWF config, I get error message: FMC33703E The selected DB2 database is not a valid WebSphere MQ Workflow Runtime database.

Furthermore, in the MQWF logs, I've found a SQL error -805 which indicates some problem with package names or binding. (I'm not a DBA!)

Any help would be greatly appreciated![/list]