PK31781: HPU UNLOAD ENDS WITH RC=4 THOUGH DSNT408I SQLCODE = -904, ERROR:UNSUCCESSFUL EXECUTION CAUSED BY UNAVAILABLE RESOURCE.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• HPU unload passes the an UNSUPPORTED SELECT ( MSGINZU063I )
  to DB2 for processing. DB2 then fails the SELECT with:
  INZR2001 DB2 ERROR: OPEN CURSOR
  DSNT408I SQLCODE = -904, ERROR:  UNSUCCESSFUL EXECUTION CAUSED
  BY AN UNAVAILABLE RESOURCE. REASON 00C90086,
  TYPE OF RESOURCE 00000200
  But HPU ends the UNLOAD with RC=4 when RC=8 would be more
  appropriate.   PB 8450
  ADDITIONAL SYMPTOMS:
  1) RC=12 issued with no error or warning message when
     the SEP keyword is used in the UNLOAD SYSIN statement
     and uses the wrong number of blanks. For example:
     FORMAT DELIMITED SEP  '   '
     should be
     FORMAT DELIMITED SEP  ' '
     This apar will provide a warning message to help the user
     find this error rather than simply issue RC=12. PB 8393
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: HPU unload passes the an UNSUPPORTED    *
  *                      SELECT ( MSGINZU063I ) to DB2 for       *
  *                      processing. DB2 then fails the SELECT   *
  *                      with: INZR2001 DB2 ERROR: OPEN CURSOR   *
  *                      DSNT408I SQLCODE = -904, ERROR:         *
  *                        UNSUCCESSFUL EXECUTION CAUSED BY AN   *
  *                        UNAVAILABLE RESOURCE. REASON          *
  *                        00C90086, TYPE OF RESOURCE 00000200   *
  *                      But HPU ends the UNLOAD with RC=4 when  *
  *                      RC=8 would be more appropriate.         *
  *                      PB 8450                                 *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Module inzspusq was changed to return a return code 8 when an
  error is signaled by the multi-fetch routine.
  

Problem conclusion

• APPLY the PTF.
  

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:

Modules/Macros

•    INZUTILB
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R210 PSY UK18907

     UP06/10/26 P F610

• R220 PSY UK18908

     UP06/10/26 P F610

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.