PK80559: RC=8 WITHOUT MESSAGE WHEN PROCESSING A LIKE CLAUSE.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This seems to occur only on a UNICODE table when the pattern
  expression of the LIKE is coded in SBCS for a GRAPHIC or
  VARGRAPHIC column.
  For HPU 220 and HPU 310:
  HPU issues a return code 8 without message in the following case
  (all conditions must match):
  - Table's encoding scheme is UNICODE
  - LIKE predicate on a GRAPHIC or VARGRAPHIC column with a
    pattern coded in SBCS.
  - Select is processed natively
  For HPU 310 only:
  Incorrect processing on a SELECT processed natively when using a
  LIKE predicate on a graphic/vargraphic column/expression. The
  rows unloaded are not the expected rows. HPU unloads either no
  rows, or rows that don't match the LIKE predicate.
  PB 9856
  ADDITIONAL SYMPTOMS:
  1. When an image copy is specified that is not in SYSCOPY,
     HPU unloads from the actual table. HPU should still unload
     from the FIC, even if it is not found in the SYSCOPY.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: For HPU 220:                            *
  *                      1. When unloading from a single         *
  *                      partition, using as input the FIC of    *
  *                      this partition with the suffixed ddname *
  *                      for the input fic and the output file   *
  *                      (exemple COPY01 ans SYSREC01), an       *
  *                      abend U1003 occurs because HPU tries    *
  *                      to read from the base ddname of the     *
  *                      FIC.                                    *
  *                      An error message is also issued:        *
  *                      IEC130I COPY     DD STATEMENT MISSING   *
  *                      PB 9914                                 *
  *                      For HPU 220 and 310:                    *
  *                      2. HPU issues a return code 8 without   *
  *                      message in the following case (all      *
  *                      conditions must match):                 *
  *                      - Table's encoding scheme is UNICODE    *
  *                      - LIKE predicate on a GRAPHIC or        *
  *                       VARGRAPHIC column with a pattern       *
  *                       coded in SBCS.                         *
  *                      - Select is processed natively          *
  *                      PB 9856                                 *
  *                      3. When using a FIC as input with       *
  *                      keyword COPYDDN, when VUU033/ULCHKCPY   *
  *                      is set to YES in the parmlib, and       *
  *                      when the input FIC is not found in      *
  *                      the SYSCOPY, HPU unloads from the TS    *
  *                      while it should unload from the FIC.    *
  *                      PB 9902                                 *
  *                      For HPU 310:                            *
  *                      4. Fast unload syntax: HPU 310 doesn't  *
  *                      accept comments in the Fastunload       *
  *                      format (asterisk in column 1) when      *
  *                      they appear in the middle of the        *
  *                      SELECT statement.                       *
  *                      PB 9870                                 *
  *                      5. A SQLCODE -805 or SQLCODE -818       *
  *                      occurs in the ISPF application when     *
  *                      APAR PK79701 or PK82130 is applied.     *
  *                      These APARs replaced the INZQUERY and   *
  *                      INZQRYV8 DBRMs that are used by         *
  *                      module INZTPMEM of the ISPF             *
  *                      application. This APAR replaces the     *
  *                      INZTPMEM module with the correct code   *
  *                      level.                                  *
  *                      PB 9938                                 *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  1. Modules inzctrl, inzrun, and inzbab were changed to check
  correctly when ddnames are allocated per partition.
  2. Module inznode and udbspgsq were changed to process
  correctly the LIKE on an UTF16 column.
  3. Modules inzctrlh and inzctrl  were changed to process
  correctly the return codes returned by function
  inzcontrolCheckCopyDdnOneDdn.
  4. Modules inzdyacc and inzfyacc were changed to detect
  correctly the comments in the SELECT in case of FastUnload
  syntax.
  5. Apar replaces content of module INZTPMEM to be consistent
  with DBRM INZQUERY and INZQRYV8 that were delivered by APAR
  PK79701.
  

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:

  UK45749 UK45750

Modules/Macros

•    INZTPMEM INZUTILB INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R220 PSY UK45749

     UP09/04/28 P F904

• R310 PSY UK45750

     UP09/04/28 P F904

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.