IC67712: SQLCODE -802 FAILURE WITH REPORTING AND MONITORING FEATURE SERVER ACTIVITY AND CLIENT ACTIVITY REPORTS

IBM Tivoli Storage Manager V6.1 Fix Pack 4 (6.1.4) Server Downloads

APAR status

• Closed as program error.

Error description

• The "Client Activity Detail" report may provide additional
  details for some nodes and others may fail with SQLCODE: -802.
  The "Server Activity Detail" reports may also fail in some
  cases with SQLCODE: -802.  Here is an example of the text that
  may be seen.  Note SQLCODE: -802, SQLSTATE: 22003.
  The following items have errors:
  ReportDesign (id = 1):
  + Cannot execute the statement.
  SQL statement does not return a ResultSet object.
  SQL error #1: DB2 SQL error SQLCODE: -802, SQLSTATE: 22003,
  SQLERRMC: null
  Initial Impact: Low
  Tivoli Storage Manager Versions Affected: All 6.1/6.2
  Additional Keywords: TSM ITM RM R&M
  

Local fix

• TSM_client_activity_details.rptdesign
  --------------------------------------
  -1-  cd <install_dir>/AC/data/database/design/TSMReports
  -2-  copy TSM_client_activity_details.rptdesign
         TSM_client_activity_details.rptdesign.org
  -3-  edit the file TSM_client_activity_details.rptdesign
  -4-  find:   sum("Total_K_Bytes") as "Total_Bytes"
  -5-  change:  sum("Total_K_Bytes"/1024) as "Total_Bytes"
  -6-  find:  bytes_moved_kb
  -7-  change:  bytes_moved_mb
  -8-  save the file
  TSM_client_top_activity.rptdesign
  -----------------------------------
  -1-  cd <install_dir>/AC/data/database/design/TSMReports
  -2-  copy TSM_client_top_activity.rptdesign
         TSM_client_top_activity.rptdesign.org
  -3-  edit the file TSM_client_top_activity.rptdesign
  -4-  find: sum("Total_K_Bytes") as "Total_Bytes",
  -5-  change:  sum("Total_K_Bytes"/1024) as "Total_Bytes",
  -6-  save the file
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Tivoli Storage Manager Reporting         *
  *                 and Monitoring users                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: See APAR error description              *
  ****************************************************************
  * RECOMMENDATION: Install 6.1.4 or 6.2.2 of reporting and      *
  *                 monitoring.                                  *
  *                                                              *
  *                 NOTE that this is subject to change at       *
  *                 the discreation of ITM                       *
  ****************************************************************
  *
  

Problem conclusion

• This problem is fixed
  Affected platforms:  AIX, HP-UX, Linux, Sun Solaris 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

• R62A PSY

     UP