PK09531: WRONG SYSREC RECORD ORDER USING BMC COMPATIBILITY STATEMENT ORDER YES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• 1. Using BMC compatibility statement ORDER YES and getting a
  different sysrec record order when the same HPU job is run on
     a qualified table or against its alias. Aliases will now be
     natively supported by HPU just like table names are
     supported.
     PB 7326
  2. DSNT408I SQLCODE104 (-104) using Fastload syntax due to a
     column in a SELECT statement with DEFAULTIF.
     This symptom occurs when the keywords in the field
     description of the INTO clause is not in the order
     specified in the manual: for example when NOTNULL
     is coded before DEFAULTIF.
     PB 7343
  3. ABEND0C4 when many unload commands on different table spaces
     are in the same sysin and that the SELECT statements coded
     for these UNLOAD commands are not supported by HPU.
     PB 7363
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. Using BMC compatibility statement    *
  *                       ORDER YES and getting a different      *
  *                       sysrec record order when the same HPU  *
  *                       job is run on a qualified table or     *
  *                       against its alias. Aliases will now be *
  *                       natively supported by HPU just like    *
  *                       table names are supported. PB 7326     *
  *                      2. DSNT408I SQLCODE104 (-104) using     *
  *                       Fastload syntax due to a column in a   *
  *                       SELECT statement with DEFAULTIF. This  *
  *                       symptom occurs when the keywords in    *
  *                       the field description of the INTO      *
  *                       clause is not in the order specified   *
  *                       in the manual: for example when        *
  *                       NOTNULL is coded before DEFAULTIF.     *
  *                       PB 7343                                *
  *                      3. ABEND0C4 when many unload commands   *
  *                       on different table spaces are in the   *
  *                       same sysin and that the SELECT         *
  *                       statements coded for these UNLOAD      *
  *                       commands are not supported by HPU.     *
  *                       PB 7363                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  1. inzctrl has been modified to accept ALIASes and SYNONYMs
  2. inzfyacc module has been changed to modifiy the syntax rules
  3. inzcontrolHPU, inzcontrolUNP and inzcontrolFUn have been
   changed.
  

Problem conclusion

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:

  UK06201 UK06202

Modules/Macros

•    INZQRYV8 INZQUERY INZUTILB
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R210 PSY UK06201

     UP05/08/25 P F508

• R220 PSY UK06202

     UP05/08/25 P F508

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.