PK34051: WHEN HPU UNLOAD PASSES COMPLEX SQL TO DB2 PER DB2 YES & DB2 FORCE ROWS MAY BE MISSING OR APPEAR AS BINARY ZEROES IN OUTPUT.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• WHEN HPU UNLOAD PASSES COMPLEX SQL TO DB2 PER DB2 YES & DB2
  FORCE ROWS MAY BE MISSING OR APPEAR AS BINARY ZEROES IN OUTPUT.
  ADDITIONAL SYMPTOM: The same problem may be seen as an ABEND0C7
  during HPU UNLOAD with messages:
  LSCX041 **** ERROR ****
  ABEND occurred in line  1976 of @@219178(IRUN), offset 0027A
  .
    Extended name: _inzrunUnload
    Program terminated by operating system. ABEND code = S0C7
  .
  

Local fix

• CIRCUMVENTION: Change INZTVAR variable VUU035/ULROWSET to
  a value of '1'.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: WHEN HPU UNLOAD PASSES COMPLEX SQL TO   *
  *                      DB2 PER DB2 YES & DB2 FORCE ROWS MAY    *
  *                      BE MISSING OR APPEAR AS BINARY ZEROES   *
  *                      IN OUTPUT.                              *
  *                      ADDITIONAL SYMPTOM: The same problem    *
  *                      may be seen as an ABEND0C7 during HPU   *
  *                      UNLOAD with messages:                   *
  *                      LSCX041 **** ERROR ****                 *
  *                      ABEND occurred in line  1976 of         *
  *                      @@219178(IRUN), offset 0027A            *
  *                        Extended name: _inzrunUnload          *
  *                        Program terminated by operating       *
  *                      system. ABEND code = S0C7               *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Modules inzrload, inzbab, inzctrl, inzatom and inzmsgs were
  changed to tolerate a separator or delimiter on more than 1
  character. In this case a warning message INZU112W is now issued
  with a return code 4 to indicate that only the first character
  of the string is used as a separator or delimiter.
  Module inzgcxtr was changed to set correctly the content of the
  SQLNAME field of the SQLDA when using the multi-row fetch of DB2
  V8. The length of SQLNAME is set to 8, and bytes 5 and 6 of the
  data portion of SQLNAME are set to x'0001' to indicate a host
  variable array.
  

Problem conclusion

• APPLY the PTF.
  

Temporary fix

• *********
  * HIPER *
  *********
  

Comments

APAR Information

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

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

  UK19607 UK19608

Modules/Macros

•    INZUTILB
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R210 PSY UK19607

     UP06/11/16 P F611

• R220 PSY UK19608

     UP06/11/16 P F611

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.