IC79063: SRV0081E/UNABLE TO ACCESS TABLE T_RES_STORAGE_SUBSYSTEM

4.2.2 Fix Pack 7 (July 2014) for Tivoli Storage Productivity Center
4.2.2 Interim Fix 2 (December 2012) for Tivoli Storage Productivity Center
4.2.2 Fix Pack 8 (March 2015) for Tivoli Storage Productivity Center
4.2.2 Fix Pack 9 (May 2015) for Tivoli Storage Productivity Center
4.2.2 Fix Pack 10 (August 2015) for Tivoli Storage Productivity Center
4.2.2 Fix Pack 3 (October 2012) for Tivoli Storage Productivity Center

APAR status

• Closed as program error.

Error description

• When open the report:
  Data Manager -> Reporting -> Monitored Computer Storage Space ->
  By Filesystem / Logical Volumes
  customer is getting error message:
  
  Error Server IP address  Status:12
  SRV0081E: SQL error. Unable to access table
  t_res_storage_subsystem
  Stmt Type: SELECT, stmt Phase: EXECUTE
  SQLSTATE: 21000, Vendor error code: -811
  DB2 SQL Error: SQLCODE=-811, SQLSTATE=21000,
  SQLERRMC=null, Driver=3.57.82
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: TPC 4.2.1 FP4 users                          *
  ****************************************************************
  * PROBLEM DESCRIPTION: Data manager filesystem reports fail    *
  *                      when older orphan filesystem records    *
  *                      (without associated logical disk        *
  *                      volumes) are present in the TPC         *
  *                      database.                               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  -
  

Problem conclusion

• The fix for this APAR is included with the following
  maintenance package:
  | fix pack | 4.2.2-TIV-TPC-FP0001 - December 2011
  
  http://www-01.ibm.com/support/docview.wss?&uid=swg21320822
  
  The target dates for future fix packs do not represent a formal
  commitment by IBM. The dates are subject to change without
  notice.
  

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

  TPC FOR DATA

• Fixed component ID

  5608TC300

Applicable component levels

• R42A PSY

     UP

• R42L PSY

     UP

• R42W PSY

     UP