The server has determined that reorganization is required on a table or index that has been excluded from online reorganization by the server or a server option. Reason code 1 means that table reorganization is required on the listed table. And this table is currently excluded from online reorganization processing because it is either specified in the DISABLEREORGTable server option or is one of the following tables: STAGED_EXPIRING_OBJECTS, STAGED_OBJECT_IDS (which are permanently excluded by the server from online table reorganization. Reason code 2 means that index reorganization is required for the listed table. And index reorganization is excluded because it is either specified in the DISABLEREORGIndex server option or is against one of the following tables: STAGED_EXPIRING_OBJECTS, STAGED_OBJECT_IDS, REPLICATED_OBJECTS (which are permanently excluded by the server from online index reorganization. Reason code 3 means that index reorganization with the CLEANUP PAGES ALL option is required. This reason is only valid for the BF_BITFILE_EXTENTS table when it is specified in the DISABLEREORGCleanupindex server option.
Server operation continues.
Tables and indices not reorganized when needed can lead to database growth and server performance degradation over time. If you experience either of these symptoms, and receive this message consideration should be given to running an offline reorganization of the given table or index.
For instructions on running an offline reorganization, see Tivoli® Storage Manager Technote 1598476 "Database size, database reorganization, and performance considerations".