Toad World® Forums

alter Index alter Piecesize gets SQL0644N Invalid value specified for keyword "PIECESIZE.CREATE" in statement "".

alter Index alter Piecesize: this statement is generated:
ALTER INDEX B027043.X7100199
PIECESIZE 4G;
Error:
SQL0644N Invalid value specified for keyword “PIECESIZE.CREATE” in statement “”.
5: ALTER INDEX B027043.X7100199 PIECESIZE 4G;

What’s wrong?

That looks valid to me. What version of DB2 are you running against? What is the current piecesize of the index?

Can you post the DDL of the index and the table and the table’s tablespace?

Hi Jeff,

I found the Problem, it’s not in Toad. This Tablespace is not yet UTS, so Piecesize must bei 2 G or less.

In the Script a Reorg Index follows the Piecesize-change. the Index is set PSRBD.

This Reorg fails becoause of the PSRBD. When I do a Rebuild Index, this is o.k.

Would’nt it be better to generate Rebuild Index (and Runstats) instead of Reorg Index, which fails?

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)