IZ15107: BINDING WITH DB2CAP FAILS WITH A LARGE NUMBER OF STATEMENTS

DB2 Version 9.5 Fix Pack 3b for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 2a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 2  for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 4  for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 4a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• When binding a large number of statements which include
  parameter markers with db2cap later statements will fail.
  
  The problem occurs when the number of parameter markers across
  all statements reaches 10000 (ten thousand).
  

Local fix

Problem summary

• Users Affected:  CLI applications using static profiling/db2cap
  Problem Description:  db2cap can fail when all statements in the
  application combined use more than ten thousand parameter
  markers.
  

Problem conclusion

• First fixed in DB2 UDB Version 9.5, Fixpak 2
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

  IY85162

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  DB2 CEE SOLARIS

• Fixed component ID

  5765F3002

Applicable component levels

• R950 PSN

     UP