Saturday, August 24, 2013

1 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

1 comments:

  1. replica rolex watches offers a variety of models, replica rolex Cellini watchesfrom professional to classic watches, to fit any wrist. Choose your favorite model, material, bezel, dial and bracelet, explore the Rolex series, and find the watch that suits you.

    ReplyDelete

 

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