IO07848: EXCESSIVE CPU USAGE IN SYSIBM.SQLPROCEDURECOLS DUE TO LACK OF LIBRARY SERVER SCHEMA NAME

APAR status

• Closed as program error.

Error description

• The II4C Java API is invoking the library server stored
  procedures without schema name qualification. The JDBC driver
  ultimately calls the SYSIBM.SQLPROCEDURECOLS DB2 z/OS stored
  procedure to obtain information about certain of the
  Content Manager library server stored procedures and it does so
  without providing an LS schema name (because none was provided
  by the II4C Java API). This NULL value being passed for the
  SQLPROCEDURECOLS schema parameter adversely affects performance
  of the SQLPROCEDURECOLS stored procedure because without the
  schema name it must perform table or index scans rather than
  using index-based access to the SYSIBM.SYSROUTINES and
  SYSIBM.SYSPARMS tables.
  

Local fix

• Setting SPCACHE=1 in db2cli.ini can help.  See DB2 CLI APAR
  JR22002.
  

Problem summary

• Excessive CPU Usage in SYSIBM.SQLPROCEDURECOLS due to lack of
  library server schema name qualification of stored procedures
  for DB2 z/OS.
  

Problem conclusion

• Added database schema name qualification to stored procedure
  calls for DB2 in Java?.
  
  Fixed in DB2 Content Manager V8.3 Fix Pack 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

  CM CONNECT V8

• Fixed component ID

  5724B43A1

Applicable component levels