IT06967: ACTIVITY LOG MAY SHOW ANR0162W AND ANR0516E REPEATEDLY FOR STANDARD OPERATIONS CENTER QUERIES

7.1.3.000-TIV-TSMOC-LinuxS390
7.1.3.000-TIV-TSMOC-LinuxPPC64
7.1.3.000-TIV-TSMOC-Windows
7.1.3.000-TIV-TSMOC-Linuxx64
7.1.3.000-TIV-TSMOC-AIX

APAR status

• Closed as program error.

Error description

• The Tivoli Storage Manager Activity Log may show multiple
  occurrences of the following messages when Operations Center
  standard queries do run:
  
  
  ANR0162W Supplemental database diagnostic information:
  -1:21000:-811 ([IBM][CLI Driver][DB2/NT64]
  SQL0811N  The result of a scalar fullselect, SELECT INTO
  statement, or VALUES INTO statement is more than one row.
  SQLSTATE=21000).
  ANR0516E SQL processing for statement select  count ( * )   as
  COUNT from TSMGUI_SCHCLI_GRID where SERVER  =  'BACKUP01' and
  DOMAIN = ( select unique DOMAIN from TSMGUI_ALLCLI_GRID where
  SERVER = 'BACKUP01'  and NAME ='FILSYS' )  failed.
  
  In this scenario, both the warning and the error message are
  harmless.
  
  
  
  Customer/L2 Diagnostics:
  The problem is caused by the select syntax: it will be changed
  in order to bypass the problem.
  
  
  
  Tivoli Storage Manager Versions Affected:
  All supported Tivoli Storage Manager Server versions
  
  
  
  Initial Impact:
  Low
  
  
  
  Additional Keywords:
  TSM select ANR0162W ANR0516E OC
  

Local fix

Problem summary

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

Problem conclusion

• This problem was fixed.
  Affected platforms: AIX, 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