PK45094: ABEND0C4 DURING HPU UNLOAD

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• After installing HPU 3.1 when running JCL member INZEXECU in the
  SINZSAMP library to verify the installation, the following
  error was received:
  LSCX064 ABEND diagnostic messages directed to ddname SYS00001
  IEA995I SYMPTOM DUMP OUTPUT  248
    USER COMPLETION CODE=1206
         PB 8837
  ADDITIONAL SYMPTOM:
  1) CONCAT on RTRIM not processed natively by HPU.
     INZU025E INVALID OPERAND FOR OPERATOR CONCAT.
     MSGINZU025E
     PB 8836.
  2) INZU010I ITEM STARTING AT (m,nn) ENDING AT (m,nn)
     INZU016E WITH STATEMENT SYNTAX IS INVALID
     INZU366I UTILITY RETURN CODE 8 (REASON CODE 0x107a002)
     The problem occurs only when the first CTE definition in a
     WITH clause doesn't contain the explicit list of columns. All
     other cases work.
     CTE = Common Table Expression. PB
  3) - Abend U1019 when a LEFT or RIGHT scalar function is used in
     a SELECT. The LEFT and RIGHT scalar functions are not
     supported natively and the select should be processed by DB2.
     - Scalar function CHAR on a numeric operand is passed to DB2
     while it should be natively supported. PB 8836
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Utility.       *
  ****************************************************************
  * PROBLEM DESCRIPTION: The following applies to R220 and R310: *
  *                      1. RTRIM/LTRIM scalar functions not     *
  *                      correctly processed. An error message   *
  *                      INZU025E INVALID OPERAND FOR OPERATOR   *
  *                      operator may be issued. PB 8727         *
  *                      2. Abend S0C4 when a WHERE clause       *
  *                      contains a wrong column name in a IS    *
  *                      NULL or IS NOT NULL predicate.          *
  *                      Additional symptom:                     *
  *                      - (HPU 310 only) Abend U1019 when a     *
  *                       LEFT or RIGHT scalar function is used  *
  *                       in a SELECT. The LEFT and RIGHT        *
  *                       scalar functions are not supported     *
  *                       natively and the select should be      *
  *                       processed by DB2.                      *
  *                      - CONCAT operator or function on a      *
  *                       CHAR(num) scalar function is passed    *
  *                       to DB2 while it should be natively     *
  *                       supported.                             *
  *                      - When a SUBSTR scalar function         *
  *                       contains some "out of range" operands, *
  *                       no error message are issued. PB 8836   *
  *                                                              *
  *                      The following applies to R310:          *
  *                      3. Message INZU016E WITH STATEMENT      *
  *                      SYNTAX IS INVALID is issued when a      *
  *                      Common Table Expression contains no     *
  *                      list of column before the SELECT that   *
  *                      defines the CTE. PB 8768                *
  *                      4. Missing field in the output record   *
  *                      or S0C1 when the unload statement       *
  *                      involves conversion from constant to    *
  *                      SMALLINT. PB 8829                       *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  1. Modules inzmsgs, inznode and inzdyacc were changed to
  process correctly the described cases.
  2. Modules inzmsgs, inznode and inzdyacc were changed to
  process correctly the described cases.
  3. Module inzhyacc was changed to accept CTE without list of
  columns.
  4. Module Inznode was changed to process correctly this
  conversion.
  

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:

  UK26448 UK26449

Modules/Macros

•    INZUTILB
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R220 PSY UK26448

     UP07/07/07 P F707

• R310 PSY UK26449

     UP07/07/07 P F707

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.