When migrating from DB2 or DDCS Version 2 to DB2 Connect or DB2 UDB Version 6, first ensure that there are no indoubt transactions. You can verify this by entering the following command in the command line processor:
list drda indoubt transactions
Note that, before issuing LIST DRDA INDOUBT TRANSACTIONS, the application must be connected to the Syncpoint Manager (SPM) instance - use the SPM_NAME database manager configuration parameter as the dbalias on the CONNECT statement. If any transactions are listed, ensure that automatic resolution occurs, or - if automatic resolution is not possible - you can force the resolution by issuing the following command:
list drda indoubt transactions with prompting