IC78285: MESSAGE ANR0162W AND ANR0294I REPEAT EVERY 5 MINUTES

IBM Tivoli Storage Manager (TSM) server V6.2.3.x interim fix downloads

APAR status

• Closed as program error.

Error description

• The messages repeat for the same table every 5 minutes:
  Ex:
  ANR0162W Supplemental database diagnostic information:  -2219:
  :11 (xxx).
  ANR0294I Reorganization for table BF_AGGREGATED_BITFILES ended.
  (can be for any table)
  
  The ANR0162W message provides the DB2 SQL return code of
  SQL2219 rc 11.
  SQL2219 rc 11 is:  "There is no table reorganization to PAUSE
  or STOP."
  
  It was found that the last Reorg/Runstats has finished but is
  still doing clean up activity.
  
  Initial Impact: Low
  Additional Keywords: TSM  Flood of Messages Loop
  

Local fix

• To reduce the number of messages while waiting for DB2 to do the
  necessary clean up, do the following steps:
  While the TSM server is running, do the following DB2 commands
  from the instance owner account:
  db2 connect to tsmdb1
  db2 set schema tsmdb1
  db2 "insert into global_attributes
  (owner,name,type,length,int32)
  values('RDB','REORG_RUNINTERVAL',3,0,1200) "
  Note:
  This will change the wait time from the default of 5 minutes to
  20 minutes.
  The new timeout value will be picked up without further action.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Tivoli Storage Manager server users.     *
  ****************************************************************
  * PROBLEM DESCRIPTION: See error description.                  *
  ****************************************************************
  * RECOMMENDATION: Apply fixing level when available. This      *
  *                 problem is currently projected to be fixed   *
  *                 in level and 6.2.4.                          *
  *                 Note that this is subject to change at the   *
  *                 discretion of IBM.                           *
  ****************************************************************
  *
  

Problem conclusion

• This problem was fixed.
  Affected platforms: AIX, HP-UX, Solaris, Linux and Windows.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  TSM SERVER

• Fixed component ID

  5698ISMSV

Applicable component levels

• R61A PSY

     UP

• R61H PSY

     UP

• R61L PSY

     UP

• R61S PSY

     UP

• R61W PSY

     UP

• R62A PSY

     UP

• R62H PSY

     UP

• R62L PSY

     UP

• R62S PSY

     UP

• R62W PSY

     UP