0 How to fix the SQL2441N

While testing db2covert for converting row base table to column base table , I got the error SQL2441N.

 

The error is causing by previous convert fail which left the orphan entry in  SYSTOOLS.ADMIN_MOVE_TABLE.

db2convert is calling the SYSPROC.ADMIN_MOVE_TABLE procedure so we can see the current status from SYSTOOLS.ADMIN_MOVE_TABLE.

I want to clean up the process and restart over. I have tried CANCEL, CLEANUP ..etc but it does not seems to help.

 CALL SYSPROC.ADMIN_MOVE_TABLE (

'DB2INST1',

'CUSTOMER_R',

'',

'',

'',

'',

'',

'',

'',

'',

'CANCEL'

 

Finally, I truncate the SYSPROC.ADMIN_MOVE_TABLE  and the I can restart my convert process.

reference

http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=%2Fcom.ibm.db2.luw.sql.rtn.doc%2Fdoc%2Fr0055069.html