ANR3497W Reorganization is required on excluded table BACKUP_OBJECTS. The reason code is 2.
if you get this warning, you should rebuild your index.You can fix this to run below commands.
db2 connect to tsmdb1
db2 set schema tsmdb1
db2 “call sysproc.reorgchk_tb_stats(‘T’,’tsmdb1.BACKUP_OBJECTS’) ”
db2 “select tsize from session.tb_stats”
db2 “reorg table tsmdb1.BACKUP_OBJECTS allow no access ”
db2 REORG INDEXES ALL FOR TABLE tsmdb1.BACKUP_OBJECTS
db2 “RUNSTATS ON TABLE tsmdb1.BACKUP_OBJECTS WITH DISTRIBUTION AND SAMPLED DETAILED INDEXES ALL”
db2 REORGCHK CURRENT STATISTICS ON TABLE tsmdb1.BACKUP_OBJECTS
db2 REORGCHK UPDATE STATISTICS ON TABLE tsmdb1.BACKUP_OBJECTS
–####################################################
db2pd -d tsmdb1 -runstats
db2pd -d tsmdb1 -reorg
db2 REORG INDEX index_name
