IZ25221: CLI RE-EXECUTE OF A STATEMENT FAILING WITH SQL0301 DOES NOT KICK IN, WHEN STATEMENT CHAINING IS TURNED ON

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

• The CLI Re-execution will not kick in, when statement chaining
  is turned on.
  
  For example a SQL statement binding a VARBINARY against a BLOB
  column will fail with SQL0301. CLI will reexecute this
  statement with the correct bindings under the cover and return
  the data requested. When statement chaining is turned on, the
  SQL0301 error is returned to the application without trying to
  reexecute it.
  

Local fix

Problem summary

• Users Affected:  CLI applications using statement chaining
  Problem Description:  An SQL0301N error is not causing CLI to
  re-execute the statement when statement chaining is enabled.
  

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:

  IZ15862

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

Fix information

• Fixed component name

  DB2 CEE AIX

• Fixed component ID

  5765F3000

Applicable component levels

• R950 PSN

     UP