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

Products

• RC Compare for DB2 for z/OS
• Database Analyzer for DB2 for z/OS
• Fast Unload for DB2 for z/OS
• Fast Check for DB2 for z/OS
• Fast Index for DB2 for z/OS
• Rapid Reorg for DB2 for z/OS

Issue/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. 

Environment

Release:
Component: RBP

Resolution

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.