IC70672: DATA SERVER BECOMES UNRESPONSIVE AND POSTS DB2 SQLCODE: -805, SQLSTATE: 51002 ERRORS

4.2.1 Interim Fix 1 (November 2011) for Tivoli Storage Productivity Center

APAR status

• Closed as program error.

Error description

• The data server becomes unresponsive and posts
  DB2 SQLCODE: -805, SQLSTATE: 51002 errors.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: IBM Tivoli Storage Productivity Center       *
  *                 for Data users who have several data or      *
  *                 storage resource agents.                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: The user is seeing the following DB2 SQ *
  *                      LCODE: -805 exceptions when trying to a *
  *                      ccess TPC GUI. The TPC data server beco *
  *                      mes unresponsive. Rebooting the TPC dat *
  *                      a server temporarily resolves the probl *
  *                      em for a few days.                      *
  *                                                              *
  *                      The following SQL Exceptions are logged *
  *                       in the TPC message logs:               *
  *                      com.ibm.db2.jcc.c.SqlException: DB2 SQL *
  *                       error: SQLCODE: -805, SQLSTATE: 51002, *
  *                       SQLERRMC: NULLID.SYSLH21E 0X5359534C56 *
  *                      4C3031                                  *
  *                       at com.ibm.db2.jcc.c.kh.c(kh.java:1660 *
  *                      )                                       *
  *                       at com.ibm.db2.jcc.b.db.o(db.java:765) *
  *                       at com.ibm.db2.jcc.b.db.g(db.java:142) *
  *                       at com.ibm.db2.jcc.b.db.a(db.java:39)  *
  *                       at com.ibm.db2.jcc.b.t.a(t.java:34)    *
  *                       at com.ibm.db2.jcc.b.sb.f(sb.java:142) *
  *                       at com.ibm.db2.jcc.c.kh.m(kh.java:1176 *
  *                      )                                       *
  *                       at com.ibm.db2.jcc.c.lh.bb(lh.java:194 *
  *                      1)                                      *
  *                       at com.ibm.db2.jcc.c.lh.d(lh.java:2383 *
  *                      )                                       *
  *                       at com.ibm.db2.jcc.c.lh.S(lh.java:432) *
  *                       at com.ibm.db2.jcc.c.lh.executeQuery(l *
  *                      h.java:415)                             *
  *                       at com.tivoli.itsrm.TStorm.repository. *
  *                      TStatComputer.getGuiComputerStats(TStat *
  *                      Computer.java:494)                      *
  *                       at com.tivoli.itsrm.TStorm.repository. *
  *                      TStatComputer.getGuiComputerStats(TStat *
  *                      Computer.java:465)                      *
  *                       at com.tivoli.itsrm.server.GuiHndlr.ha *
  *                      ndle(GuiHndlr.java:232)                 *
  *                       at com.tivoli.itsrm.server.RequestMana *
  *                      ger$RmThread.run(RequestManager.java:49 *
  *                      9)                                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  -
  

Problem conclusion

• The fix for this APAR is targeted for the following maintenance
  packages:
  
  | fix pack | 4.1.1-TIV-TPC-FP0006 - target April 2011
  | fix pack | 4.2.1-TIV-TPC-GA - target November 2010
  
  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:

  IC72459

Fix information

• Fixed component name

  MDM PERFORMANCE

• Fixed component ID

  5648GPC01

Applicable component levels

• R411 PSY

     UP