IC90381: TPC DATABASE FILESYSTEM RUNS OUT OF SPACE WHEN TPC SERVER ISSUES REFRESH STATEMENTS AGAINST THE T_RPT_HOST_KEYS TABLE

Fix Pack 5.1.1.2 (September 2013) for Tivoli Storage Productivity Center
Fix Pack 5.1.1.5 (July 2014) for Tivoli Storage Productivity Center
Fix Pack 5.1.1.6 (March 2015) for Tivoli Storage Productivity Center
Fix Pack 5.1.1.9 (October 2015) for Tivoli Storage Productivity Center
Fix Pack 5.1.1.12 (October 2016) for Tivoli Storage Productivity Center
Fix Pack 5.1.1.13 (February 2017) for Tivoli Storage Productivity Center
Fix Pack 5.1.1.14 (June 2017) for Tivoli Storage Productivity Center
Fix Pack 5.1.1.15 (Sept 2017) for Tivoli Storage Productivity Center
Fix Pack 5.1.1.8 (July 2015) for Tivoli Storage Productivity Center

APAR status

• Closed as program error.

Error description

• The T_RPT_HOST_KEYS table is a Materialized Query Table (MQT)
  that the TPC server creates for use in Cognos reporting.  MQT
  tables are created through a series of select statements against
  other database tables.  The refresh statement issued by the TPC
  server to update that table causes the filesystem that hosts the
  TPCDB to fill up quickly, and also consumes lot of RAM.
  Aside from filling up the database filesystem, the following
  messages are observed in the traceTPCDeviceServer.log file:
  yyyy-mm-dd hh:mm:ss.xxx-xxx com.ibm.db2.jcc.am.SqlException: DB2
  SQL
  Error: SQLCODE=-968, SQLSTATE=57011, SQLERRMC=null,
  DRIVER=3.64.82
   at com.ibm.db2.jcc.am.bd.a(bd.java:682)
   at com.ibm.db2.jcc.am.bd.a(bd.java:60)
  SQLSTATE 57011 indicating Virtual storage or database resource
  is not available, an after-effect of the refresh statement, and
  it will be followed by messaging like this:
  yyyy-mm-dd hh:mm:ss.xxx-xxx Can not perform MQT refresh on table
  T_RPT_HOST_KEYS because the service is not running!
  com.ibm.tpc.common.dbaccess.MQTRefresher refreshTable
  WebContainer : 0
  
  
  RECREATE STEPS:
  Observe database filesystems filling up when using Cognos
  reporting with TPC 5.1.
  ________________________________________________________________
  DB2 Version used for Server:    N/A
  The defect is against component:   5608TPC00
  Server/Manager build/release (TPC):   510
  Agent build/release (TPC):    N/A
  Server/Manager (OS):     N/A
  Agent (OS):       N/A
  ________________________________________________________________
  Problem as described by customer:    Tablespace filesystems
  filling up quickly
  Initial customer impact (low/med/high):   med
  

Local fix

• Local Fix:  An improved SQL statement can be obtained from TPC
  L2 support.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * TPC 5.1.0 and 5.1.1.0 users                                  *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See ERROR DESCRIPTION.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to fix pack maintenance when available.              *
  ****************************************************************
  

Problem conclusion

• The fix for this APAR is targeted for the following maintenance
  package:
  
  | fix pack | 5.1.1-TIV-TPC-FP0001 - target April 2013
  
  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:

Modules/Macros

• DB
  

Fix information

• Fixed component name

  TPC

• Fixed component ID

  5608TPC00

Applicable component levels

• R511 PSY

     UP

• R510 PSY

     UP