PK65272: CC=04 IS SET FOR HPU UNLOAD JOB WHEN MSGS INZU063I UNSUPPORTED SELECT & INZU103W DB2 YES, EVEN IF VUU024/UNLZLRC IS SET TO '5'.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• HPU provides INZTVAR variable VUU024/UNLZLRC which allows the
  installation to choose a specific condition code to be set
  when any SELECT statement in the unload results in zero rows
  returned. In this case the customer had set VUU024 to '5',
  expecting CC=5 when no rows returned. However, if HPU finds
  a SELECT is unsupported and issues msgs:
  INZU063I UNSUPPORTED SELECT :
  and
  INZU103W DB2 YES SPECIFIED, WILL ATTEMPT DB2 PROCESSING.
  these result in CC=04. This overrides the CC=05 the customer
  wanted via VUU024.
  This apar will deliver a new INZTVAR parm that will allow the
  cusotmer installation to opt for the HIGHEST issued RC to
  be externalized.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: The VUU024/UNLZLRC parmlib variable     *
  *                      is ignored when a warning message is    *
  *                      issued. The unload process may end      *
  *                      with return code 4 when no rows are     *
  *                      unloaded even if UNLZLRC is set to a    *
  *                      value greater than 4. PB9296            *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Modules udbdbopt, inzmain and inzparm were changed to use a
  new optional sub-parameter of parmlib variable
  VUU024/UNLZLRC: MAXRC.
  

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:

  UK36448 UK36449

Modules/Macros

•    INZRSAVE INZUTILB
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R220 PSY UK36448

     UP08/05/20 P F805

• R310 PSY UK36449

     UP08/05/20 P F805

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.