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.
REORG INDEXES ALL FOR TABLE USER1.TABLE2 ALLOW WRITE ACCESS CLEANUP ALL;
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 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.
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.