DB2 Version 10.1 for Linux, UNIX, and Windows

REORG INDEXES/TABLE command parameters and parameter values for related DB2 API data structures have been deprecated or discontinued

To improve readability of the REORG INDEXES/TABLE command, certain command parameters have been deprecated and replaced by a new option. Also, some parameter values for related DB2® API data structures have been deprecated or discontinued.

Details

The CLEANUP ONLY parameter of the REORG INDEXES command has been deprecated and has been replaced by the CLEANUP option. The following example uses the CLEANUP option:
REORG INDEXES ALL FOR TABLE USER1.TABLE2 ALLOW WRITE ACCESS CLEANUP ALL;
The RECLAIM EXTENTS ONLY parameter of the REORG TABLE command has been deprecated and has been replaced by the RECLAIM EXTENTS option. The following example uses the RECLAIM EXTENTS option:
REORG TABLE USER1.TABLE1 RECLAIM EXTENTS;

The CONVERT parameter of the REORG INDEXES command has been discontinued. The type-1 indexes were discontinued in Version 9.7. Therefore, this parameter has become obsolete. Databases upgraded from Version 9.7 to Version 10.1 no longer have type-1 indexes. Databases upgraded from Version 9.5 to Version 10.1 have type-1 indexes automatically rebuilt as type-2 indexes on the first access to the table after the upgrade.

In the db2ReorgStruct data structure for the db2Reorg API, the following values for the reorgFlags parameter have been deprecated or discontinued:
  • The DB2REORG_CLEANUP_NONE value has been deprecated. This value indicates that no clean up is required when the reorgType is set to DB2REORG_OBJ_INDEXESALL or DB2REORG_OBJ_INDEX. Not specifying this value has the same effect, therefore, specifying the value is redundant.
  • The DB2REORG_CONVERT_NONE value has been deprecated. In earlier releases, this value indicated that no index conversion was required when the reorgType is set to DB2REORG_OBJ_INDEXESALL or DB2REORG_OBJ_INDEX. This value has become obsolete because type-1 indexes were discontinued since Version 9.7.
  • The DB2REORG_CONVERT value has been discontinued. In earlier releases, this value indicated that index conversion was required when the reorgType is set to DB2REORG_OBJ_INDEXESALL or DB2REORG_OBJ_INDEX. This value has become obsolete because type-1 indexes were discontinued since Version 9.7.

In the db2LoadQueryOutputStruct data structure and db2LoadQueryOutputStruct64 data structure for the db2LoadQuery API, the DB2LOADQUERY_TYPE1_INDEXES value for the TableState parameter has been discontinued. This value indicates table currently uses type-1 indexes and has become obsolete because type-1 indexes were discontinued since Version 9.7.

Resolution

Start using the CLEANUP option with the REORG INDEXES command or the RECLAIM EXTENTS option with the REORG TABLE command. You are no longer required to indicate the DB2REORG_CLEANUP_NONE in the reorgFlags parameter.

Stop using the CONVERT parameter of the REORG INDEXES command. If you use the parameter, an error is returned.