IC55585: COM.IBM.DB2.JCC.A.SQLEXCEPTION: DB2 SQL ERROR: SQLCODE: -805, SQLSTATE: 51002, SQLERRMC: NULLID.SYSLH21E 0X5359534C564C3031

APAR status

• Closed as program error.

Error description

• com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -805,
  SQLSTATE: 51002, SQLERRMC: NULLID.SYSLH21E 0X5359534C564C3031
  causing probe/performance monitoring failed
  The reason for SQL error -805 is that TPC has to many concurrent
  statements open.
  

Local fix

• none known
  

Problem summary

• Users Affected:
  Those doing subsystem probes with a CIMOM.
  
  Problem Description:
  EMC probes failing with "2/18/08 3:48:03 PM BTADS0035E The
  execution of the job failed with:
  com.ibm.tpc.common.api.TPCServerException: HWN021503E An
  internal error occurred, please try
  again.
  
  The probes run for 1.5 - 2 hours before failing.  They seem to
  be close to the end of the process.  The ending error messages
  are as follows.
  
  2/18/08 3:45:48 PM HWN021719I Perform collection post process
  tasks for
  storage system SYMMETRIX\+xxxxxxxx+0.
  2/18/08 3:48:03 PM BTADS0035E The execution of the job failed
  with:
  com.ibm.tpc.common.api.TPCServerException: HWN021503E An
  internal error
  occurred, please try again. If the problem persist, please
  contact IBM
  service. .
  2/18/08 3:48:04 PM HWN021709I Collection for storage system
  SYMMETRIX\+xxxxxxxx+0 completed.
  2/18/08 3:48:04 PM BTADS0001I Discover Process with Device
  Server RUN ID
  45962 and Job ID 224270 is complete with Status= 4 , Return
  Code= 1 .
  
  
  BTADS0001I Discover Process with Device Server RUN ID 2033 and
  Job ID
  2323 is complete with Status= 4 ,Return Code=10011
  
  dmSvcTrace.log showed this:
  2008.02.18 15:45:48.680-08:00 Msg: HWN021719I Perform collection
  post process tasks for storage system SYMMETRIX\+xxxxxxxx+0.
  @(-9223372036845992243;[-9223372036854773838,0,543];-825397;Proc
  esses (Thread-102))
  com.ibm.tpc.disk.collection.ProbeGenericMaskingMappingProcess
  process
  2008.02.18 15:48:00.195-08:00 HWN099993E Non-deadlock exception
  during re-persisting of commit buffer
  @(-9223372036845872476;[-9223372036854773838,0,547];-92233720368
  44673758;Processes (Thread-102))
    com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -805,
  SQLSTATE: 51002, SQLERRMC: NULLID.SYSLH21E 0X5359534C564C3031
   at com.ibm.db2.jcc.a.hd.e(hd.java(Compiled Code))
   at com.ibm.db2.jcc.c.jb.p(jb.java:684)
   at com.ibm.db2.jcc.c.jb.h(jb.java(Compiled Code))
   at com.ibm.db2.jcc.c.jb.a(jb.java(Compiled Code))
   at com.ibm.db2.jcc.c.w.a(w.java(Inlined Compiled Code))
   at com.ibm.db2.jcc.c.cc.g(cc.java(Compiled Code))
   at com.ibm.db2.jcc.a.hd.n(hd.java(Inlined Compiled Code))
   at com.ibm.db2.jcc.a.id.gb(id.java(Compiled Code))
   at com.ibm.db2.jcc.a.id.d(id.java(Compiled Code))
   at com.ibm.db2.jcc.a.id.Y(id.java(Compiled Code))
   at com.ibm.db2.jcc.a.id.executeUpdate(id.java(Compiled Code))
   at
  com.ibm.tpc.infrastructure.database.DBPreparedStatement.executeU
  pdate(DBPreparedStatement.java(Compiled Code))
   at
  com.ibm.tpc.infrastructure.database.ComplexQuery.sqlUpdate(Compl
  exQuery.java(Compiled Code))
   at
  com.ibm.tpc.disk.collection.DiskCIMProcessor.updateComplexQueryD
  eadlockRetry(DiskCIMProcessor.java(Compiled Code))
   at
  com.ibm.tpc.disk.collection.SVCExtentUpdatePostProcess.UpdateMdi
  sk_VolumeID(SVCExtentUpdatePostProcess.java(Compiled Code))
   at
  com.ibm.tpc.disk.collection.SVCExtentUpdatePostProcess.processMd
  isk(SVCExtentUpdatePostProcess.java(Compiled Code))
   at
  com.ibm.tpc.disk.collection.ExtentUpdatePostProcess.process(Exte
  ntUpdatePostProcess.java:147)
   at com.ibm.tpc.Router.perform(Router.java(Compiled Code))
   at com.ibm.tpc.Router.perform(Router.java(Compiled Code))
   at
  com.ibm.tpc.disk.collection.ProbeGenericMaskingMappingProcess.pr
  ocess(ProbeGenericMaskingMappingProcess.java:662)
   at com.ibm.tpc.Router.perform(Router.java(Compiled Code))
   at com.ibm.tpc.Router.perform(Router.java(Compiled Code))
   at
  com.ibm.tpc.disk.collection.ProbeCompleteSubsystem.process(Probe
  CompleteSubsystem.java:124)
   at com.ibm.tpc.Router.perform(Router.java(Compiled Code))
   at com.ibm.tpc.Router.perform(Router.java(Inlined Compiled
  Code))
   at
  com.ibm.tpc.discovery.ProcessProcessor.run(ProcessProcessor.java
  (Compiled Code))   com.ibm.tpc.disk.collection.DiskCIMProcessor
  updateComplexQueryDeadlockRetry
  

Problem conclusion

• A fix will be available in upcoming monthly releases for IBM
  TotalStorage Productivity Center that will be available for
  download from the support web site.
  
  IBM TotalStorage Productivity Center v3.3.0 monthly interim fix
  target April 2008
  http://www-1.ibm.com/support/docview.wss?&uid=swg24018331
  
  IBM TotalStorage Productivity Center v3.3.1 monthly interim fix
  target May 2008
  http://www-1.ibm.com/support/docview.wss?&dc=D400&uid=swg2401832
  8
  

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

  MULTIPLE DEVICE

• Fixed component ID

  5648HWN01

Applicable component levels

• R330 PSY

     UP

• R331 PSY

     UP