PK72110: INZU366I UTILITY RETURN CODE 8 (REASON CODE 0X107A002) WHEN WITH UR IS CODED WITH UNION IN HPU UNLOAD AFTER UK39075.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• 1) MSGINZU366I UTILITY RETURN CODE 8 (REASON CODE 0x107a002)
  when HPU unload with UNION and WITH UR after UK39075.
  2) OUTDDN is documented to require Parentheses, but in R220
     did not require them.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. In some case, a non supported select *
  *                      processed in DB2 YES or in DB2 FORCE    *
  *                      issue the following error messages:     *
  *                      INZU016E  STATEMENT SYNTAX IS INVALID   *
  *                      INZU039E FATAL SYNTAX ERROR BEFORE      *
  *                       LINE 8 COLUMN 8                        *
  *                      The same sysin was correctly processed  *
  *                      before applying PTF UK39075             *
  *                      Potential error case:                   *
  *                      - Select containing an UNION clause     *
  *                       and terminated by a WITH clause        *
  *                       (Isolation clause)                     *
  *                      - Select containing an UNION clause     *
  *                       followed by an OUTDDN without          *
  *                       parentheses. PB 9611-9612              *
  *                      2. For a select processed natively      *
  *                      that contains a SUBSTR scalar function  *
  *                      without the lenth parameter, the output *
  *                      data type is VARCHAR while is should    *
  *                      be CHAR. PB 9592                        *
  *                      3. Potential abend S0C4 can occur for   *
  *                      select processed natively that          *
  *                      contains a scalar function with         *
  *                      optional parameters that are not        *
  *                      specified. PB 9593                      *
  *                      4. FastUnload syntax. After PTF         *
  *                      UK39911 is applied, a Fastunload Sysin  *
  *                      that contains more than 2 SELECT        *
  *                      statement issues error message          *
  *                      INZU039E FATAL SYNTAX ERROR BEFORE      *
  *                      LINE nn COLUMN nn. PB 9608              *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  1. Module inzhyacc was changed to process correctly the syntax
  analysis when an UNION is coded in the SELECT.
  2. Module Inznode, function inznodeCheckOperator was changed to
  fix the processing of the SUBSTR scalar function.
  3. Module Inznode, function inznodeGenerateAsm was changed to
  avoid the S0C4 abend.
  4. Module inzfyacc was changed to accept more than 2 select in
  FastUnload syntax.
  

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:

  UK40110

Modules/Macros

•    HINZ310J INZPRMSK INZRSAVE INZRSKEL INZTTBL
  INZUTILB INZUTILK INZUTISK INZZAPEX INZZAPSK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R310 PSY UK40110

     UP08/09/30 P F809

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.