Saturday, August 24, 2013

0 How to fix the SQL2441N

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

image 

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

image

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

0 comments:

Post a Comment

 

SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates