PH33271: REMOVE USELESS WITH HOLD FROM CUSOR USED IN SQL MODE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When run SQL mode, Db2 HPU declares a cursor with the WITH HOLD
  option. The use of this option may cause a Db2 error to occur
  which is reported by Db2 HPU with the following message:
  
  INZR2001 DB2 ERROR: OPEN CURSOR
  DSNT408I SQLCODE = -904, ERROR: EXECUTION FAILURE CAUSED BY A
  RESOURCE NOT AVAILABLE. REASON 00C90084, RESOURCE TYPE 00000100,
  AND
  NAME OF THE RESOURCE SPACE MANAGED BY DB2 WITHOUT SECONDARY
  ALLOCATION OR US
  
  As the WITH HOLD option is actually useless to Db2 HPU, it
  should be removed to avoid the occurrence of the above
  mentioned Db2 error.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload         *
  *                 for z/OS                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: When run SQL mode, Db2 HPU declares a   *
  *                      cursor with the WITH HOLD option.       *
  *                      The use of this option may cause a Db2  *
  *                      error to occur which is reported by Db2 *
  *                      HPU with the following message:         *
  *                                                              *
  *                      INZR2001 DB2 ERROR: OPEN CURSOR         *
  *                      DSNT408I SQLCODE = -904, ERROR:         *
  *                      EXECUTION FAILURE CAUSED BY A RESOURCE  *
  *                      NOT AVAILABLE. REASON 00C90084,         *
  *                      RESOURCE TYPE 00000100, AND             *
  *                      NAME OF THE RESOURCE SPACE MANAGED BY   *
  *                      DB2 WITHOUT SECONDARY ALLOCATION OR US  *
  *                                                              *
  *                      As the WITH HOLD option is actually     *
  *                      useless to Db2 HPU, it should be        *
  *                      removed to avoid the occurrence of the  *
  *                      above mentioned Db2 error.              *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  Remove useless WITH HOLD from CUSOR used in SQL mode
  

Problem conclusion

• Code has been changed to fix this problem
  

Temporary fix

Comments

• ×**** PE21/07/08 FIX IN ERROR. SEE APAR PH38791  FOR DESCRIPTION
  

APAR Information

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

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

  UI74156

Modules/Macros

• INZCRXSM INZCRXSQ INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R510 PSY UI74156

     UP21/04/01 P F103

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.