Toad World® Forums

After alteration of Piecesize, TOAD has REORG Index, which fails: PAGESET REBUILD PENDING ON INDEX B027043.X7100199 PROHIBITS PROCESSING


#1

Still open Question with alter Index alter Piecsize:

In the Script a Reorg Index follows the Piecesize-change. the Index is set to PSRBD. This Reorg fails becoause of the PSRBD. When I do a Rebuild Index, this is o.k.

For my opinion this is an error: Only with Rebuild Index or with the more resource-consuming Reorg Tablespace this PSRBD kann be removed.

In case of reorg Index, Rebuild Index and Runstats Index has to be done.

Statement:10.09.2014 09:36:55 0:00:00.000: Executed Successfully 1: SET CURRENT SCHEMA = B027043 Statement:10.09.2014 09:36:55 0:00:00.000: Executed Successfully 3: SET CURRENT SQLID = ‘B027043’ DB2:10.09.2014 09:36:55: 610: [IBM][DB2] A CREATE/ALTER ON OBJECT B027043.X7100199 Statement:10.09.2014 09:36:55 0:00:00.093: Executed Successfully 5: ALTER INDEX B027043.X7100199 PIECESIZE 1G Statement:10.09.2014 09:36:55 0:00:00.000: Executed Successfully 8: COMMIT Statement:10.09.2014 09:36:55 0:00:00.000: Executed Successfully 10: COMMIT Statement:10.09.2014 09:36:55 0:00:00.000: Utility template command held for processing. 12: TEMPLATE TOAD4 DSN SYSUT1 Error:10.09.2014 09:36:55 0:00:00.000: Lookup Error - DB2 Database Error: Utility command failure: REORG INDEX B027043.X7100199 STA… Return code = 8 1DSNU000I 253 09:36:56.04 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = TOADDB2#66433646

DSNU1045I 253 09:36:56.06 DSNUGTIS - PROCESSING SYSIN AS UNICODE UTF-8

0DSNU050I 253 09:36:56.07 DSNUGUTC - TEMPLATE TOAD4 DSN SYSUT1 DSNU1035I 253 09:36:56.08 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY

0DSNU050I 253 09:36:56.08 DSNUGUTC - REORG INDEX B027043.X7100199 STATISTICS UPDATE ALL HISTORY ALL WORKDDN( TOAD4) DSNU204I -DT1C 253 09:36:56.17 DSNUGDTC - PAGESET REBUILD PENDING ON INDEX B027043.X7100199 PROHIBITS PROCESSING DSNU012I 253 09:36:56.18 DSNUGBAC - UTILITY EXECUTION TERMINATED, HIGHEST RETURN CODE=8

14: REORG INDEX B027043.X7100199 STATISTICS

UPDATE ALL HISTORY ALL WORKDDN(TOAD4)


#2

Thanks for your feedback.

We have created TDB-1203 to track this issue

Thanks

Jeff