db2 rebuild index – BACKUP_OBJECTS – ANR3497W – Tivoli Storage Manager

0
1180

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

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.