ANR3498W
One-time setting of the server reorganization options is performed.

Explanation

The following server options are set after the server starts for the first time: 1) The DISABLEREORGTABLE option is set with no tables specified. As a result, no tables are excluded from the table-reorganization processing. 2) The DISABLEREORGINDEX option is set to ARCHIVE_OBJECTS,BACKUP_OBJECTS, BF_AGGREGATED_BITFILES, and BF_BITFILE_EXTENTS. As a result, index reorganization will not be run on these tables. 3) The DISABLEREORGCLEANUPINDEX is set with no tables specified. As a result, INDEX REORG with the CLEANUP PAGES ALL option will be run on the BF_BITFILE_EXTENTS table. This process of updating the server options file runs only one time, which is after the server starts for the first time.

System action

Server operation continues.

User response

If you do not want the one-time reorganization processing to occur, issue the following commands from a DB2® command window: db2 connect to tsmdb1 db2 "insert into tsmdb1.global_attributes (owner,name,type,length,int32) values('RDB','REORG_ONETIME_AUTO_INIT',3,0,2)" The commands can be issued on any Version 6 server or at the fixing level for APAR IC95301, before you start the server.