How to fix SQLCODE = -910 in an ALTER INDEX PTI.PTLOG_MAIN_1500 statement?

Document ID : KB000094719
Last Modified Date : 04/05/2018
Show Technical Document Details
Introduction:
You have to update PRIQTY and SECQTY in tablespace PTDB.PTITLOG2 and index PTI.PTLOG_MAIN_1500. 
  
ALTER TABLESPACE DBOEMCA.PTITLOG2 
PRIQTY nnn 
SECQTY nnn; 
 
ALTER INDEX PTI.PTLOG_MAIN_1500 
PRIQTY nnn 
SECQTY nnn;  
  
Got an SQLCODE = -910 error message. 
Instructions:
The problem is because when we run through Batch Processor it logs what is happening in the table you are trying to change (Table PTI.PTLOG_MAIN_1500 is in table space PTITLOG2). So the ALTER TABLESPACE statement executes but that generates an INSERT into PTI.PTLOG_MAIN_1500 table which we are not seeing. That is a DML update statement so when we issue the ALTER INDEX it fails.

The Batch Processor table PTI.PTLOG_MAIN_1500 has to be handle differently, with Batch Processor you have to add a command .OPTION NOLOG before the command .CONNECT SSID or you have to handle it with other DB2 Tools.