PH51701: IN SQL MODE REPORT POSITIVE SQLCODE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When processing an unload in SQL mode, Db2 HPU should report any
  positive SQLCODE received from Db2 as it may provide useful
  information about how the SELECT statement is processed by Db2.
  It is noticeably useful to check whether an OPTIMIZATION HINT
  specified through the Db2 HPU OPTiMIZATION_HINT option is taken
  into account by Db2, as Db2 informs about that by issuing
  SQLCODE +394 or SQLCODE +305.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload         *
  *                 for z/OS                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: When processing an unload in SQL mode,  *
  *                      Db2 HPU should report any positive      *
  *                      SQLCODE received from Db2 when it       *
  *                      performs a PREPARE statement for the    *
  *                      SELECT statement involved in the        *
  *                      logical unload. Such information        *
  *                      provides details about how the SELECT   *
  *                      statement will be processed by Db2.     *
  *                      It is noticeably useful to check        *
  *                      whether an OPTIMIZATION HINT specified  *
  *                      through the Db2 HPU OPTiMIZATION_HINT   *
  *                      option is taken into account by Db2, as *
  *                      Db2 informs about that by issuing       *
  *                      SQLCODE +394 or SQLCODE +395.           *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  In SQL mode report positive SQLCODE
  

Problem conclusion

• Code has been changed to fix this problem
  

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:

  UI90505

Modules/Macros

• INZCRXSM INZCRXSQ INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R510 PSY UI90505

     UP23/02/17 P F302

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.