How to fix SQLCODE = -910 in an ALTER INDEX PTI.PTLOG_MAIN_1500 statement?
Article ID: 94719
RC Compare for DB2 for z/OSDatabase Analyzer for DB2 for z/OSFast Unload for DB2 for z/OSFast Check for DB2 for z/OSFast Index for DB2 for z/OSRapid Reorg for DB2 for z/OS
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.
Release: Component: RBP
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.