PK76837: ABEND0C1, ABEND0C4 OR ABEND0C7 FOLLOWED BY ABENDU1017

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Abend0c1 or ABEND0C4 or ABEND0C7 followed by ABENDU1017 with
  the following message:
  LSCX041 **** ERROR ****
          ABEND occurred in line  381 of @@406282(IRUNH)  ,offset
          000540
          Extended name: inzrunhUnload
          Program terminated by operating system. ABEND code =
          U1017  A non-C or system routine was running at the
          time of ABEND
  ADDITIONAL SYMPTOMS:
  1. Getting the following error message:
     INZU127W DIRECT ACCESS TO DB2 CATALOG FAILED: SWITCH TO SQL
     ACCESS
     To work around this problem change to VUM027/SQLACCES = YES.
  2. When using SCALAR FUNCTION RAND() the following error
     messages are issued:
     INZU039E FATAL SYNTAX ERROR BEFORE LINE 8 COLUMN 73
     INZU366I UTILITY RETURN CODE 8 (REASON CODE 0x107a002)
     It does not fail when there is a value in the RAND()
     function.
     Ex:   RAND(0)
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: The following are HPU310 only:          *
  *                      1. Different errors when the COALESCE   *
  *                      or VALUE scalar functions are used in   *
  *                      a SELECT processecd natively:           *
  *                      - An incorrect value when the value     *
  *                       returned by COALESCE is a decimal      *
  *                       constant with a scale greater than     *
  *                       15 on a DEC31 site.                    *
  *                      - an ABEND due to a memory overlap can  *
  *                       occur when a decimal constant is       *
  *                       converted into a FLOAT data type in a  *
  *                       COALESCE scalar function.              *
  *                      - An error message INZU238E is issued   *
  *                       when the first argument of a COALESCE  *
  *                       scalar function is an expression that  *
  *                       returns a decimal value.               *
  *                      The exact text of the error messag is:  *
  *                      INZU238E UNEXPECTED UNSUPPORTED SELECT  *
  *                         UTILITY CANNOT SWITCH TO SQL         *
  *                         PROCESSING REASON 0Xcfffc            *
  *                      PB 0                                    *
  *                      2. When ORDER CLUSTER is requested on   *
  *                      a table that has no explicit            *
  *                      clustering index, but on which the      *
  *                      first created index is an index on      *
  *                      expression output data is sorted in an  *
  *                      incorrect order. HPU should ignore the  *
  *                      ORDER CLUSTER clause in this case, and  *
  *                      should issue a warning message          *
  *                      INZU044W NO CLUSTER INDEX FOUND FOR     *
  *                        TABLESPACE name ORDER CLUSTER         *
  *                        STATEMENT IS IGNORED FOR SELECT n     *
  *                      PB 9671                                 *
  *                      3. When a SELECT that includes a DAY    *
  *                      scalar function on a date duration is   *
  *                      processed natively, the result of this  *
  *                      scalar function is incorrect.           *
  *                      PB 9677                                 *
  *                      4. An abend S0C1 can occur when         *
  *                      processing a WHERE clause in very       *
  *                      specific cases, when several AND and    *
  *                      OR boolean operators are used between   *
  *                      predcates.                              *
  *                      PB 9707                                 *
  *                      5. A warning message INZU127W DIRECT    *
  *                      ACCESS TO DB2 CATALOG FAILED: SWITCH    *
  *                      TO SQL ACCESS occurs when HPU 310       *
  *                      tries to access to a DB2 member         *
  *                      running in V8 NFM part of a DB2 Data    *
  *                      Sharing group with GROUP LEVEL(910)     *
  *                      MODE(C).                                *
  *                      PB 9731                                 *
  *                      6. When a scalar function or an UDF is  *
  *                      coded in the SELECT without any         *
  *                      parameter, HPU 310 issues error         *
  *                      message INZU039E FATAL SYNTAX ERROR     *
  *                      BEFORE LINE nn COLUMN nn.               *
  *                      PB 9749                                 *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  1. Module inznode was changed to fix the problems on the
  COALESCE scalar function.
  2. Module inzctlr, function inzcontrolOrderBy was changed to
  reject the index on expression as a clustering index.
  3. Module udbspgsq was fixed to generate the correct code to
  process DAY scalar function ona date duration.
  4. Module UDBSPGCM was changed to fix the adressing problem.
  5. Module odb2cmd was changed to interpret correctly the
  result of the DISPLAY GROUP command when there is a mix of DB2
  versions in the same data sharing group.
  6. Module inzhyacc, inzdyacc and inzfyacc were changed to
  support functions without arguments
  

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:

Modules/Macros

•    INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R310 PSY UK43572

     UP09/02/05 P F902

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.