IC81184: TPC SCHEDULER FAILING WITH DB2 SQLCODE -805 ERRORS

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

• tpc jobs will not run or start because the scheduler fails with
  sqlcode -805 errors.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All TPC users.                               *
  *                 The APAR is most visible if the TPC server   *
  *                 is restarted while jobs are running.         *
  ****************************************************************
  * PROBLEM DESCRIPTION: Data Server logs contain following      *
  *                      SQL error:                              *
  *                                                              *
  *                      SQLSTATE: 51002, Vendor error code:-805 *
  *                      DB2 SQL Error: SQLCODE=-805,            *
  *                      SQLSTATE=51002,                         *
  *                      SQLERRMC=NULLID.SYSLH21E                *
  *                      0X5359534C564C3031, DRIVER=3.57.82      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  -
  

Problem conclusion

• This APAR is caused by SQL statements left open.
  The fix for this APAR closed those statements.
  
  APAR is targeted for the following maintenance
  packages:
  
  | fix pack | 4.2.2-TIV-TPC-FP0002 - target June 2012
  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