JR31272: PREDICTIVE GOVERNOR IN DB2 V8 IS NOT IMPLEMENTED, THUS CAUSING HIS APPLICATION TO FAIL WITH A -30002 ERROR CODE

DB2 Version 9.1 Fix Pack 7  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 7a  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 8  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 9  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows

APAR status

• Closed as program error.

Error description

• The customer is running a CLI-based application with Deferred
  Prepare enabled (default).
  In the application they execute a query against DB2 z/OS v7.
  They are connecting through a v8.2 gateway.
  
  The query fails with a -30002 error:
  
  -30002 THE SQL STATEMENT CANNOT BE EXECUTED DUE TO A PRIOR
  CONDITION IN A
            CHAIN OF STATEMENTS
  
  SInce Deferred Prepare is enabled, the PREPARE and OPEN are sent
  on the same request.  The PREPARE receives a warning +1140W, and
  the OPEN succeeds. The Warning on the
  prepare however causes the entire statement to fail with the
  severe -30002 error, causing the application to return
  an error.
  

Local fix

• Local Fix :  N/A
  

Problem summary

• PREDICTIVE GOVERNOR IN DB2 V8 IS NOT IMPLEMENTED, THUS CAUSING
  HIS APPLICATION TO FAIL WITH A -30002 ERROR CODE
  

Problem conclusion

• First fixed in DB2 UDB Version 9.1, FixPak 7
  

Temporary fix

• N/A
  

Comments

APAR Information

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

  JR31261

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

Fix information

• Fixed component name

  DB2 UDB ESE WIN

• Fixed component ID

  5765F4101

Applicable component levels

• R910 PSY

     UP