PQ98706: HPU ABEND U1017 IS PRECEEDED BY A DFSORT ABEND U0027 IN ICEMAN.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• HPU abend U1017 is preceeded by a DFSORT ABEND U0027 in ICEMAN.
  PB 6675
  ADDITIONAL SYMPTOMS:
  1) Provide HPU support for 3-part names of tablespaces. PB 6691
  2) The function DIGITS(YEAR('01.01.0001')) should return
     value 0000000001 in HPU as it does in DSNTIAUL, but it
     returns 0001 instead. PB 6690
     A second symptom of this same PB 6690 is a possible
     ABEND0C7 in INZUTILB when processing a DECIMAL column R220.
  3) HPU UNLOAD of DECIMAL EXTERNAL fields results in extra spaces
     ( blanks ) in the output. PB 6600 MR040804614.
  4) MSGINZU096E REQUIRED KEYWORD, keywrd, NOT SPECIFIED,
     PROCESSING TERMINATED. This is received when a SELECT
     statement coded in the HPU UNLOAD ends with a decimal
     point ( American period or European comma ) like this:
     WHERE DECIMAL_COL < 200000005.
     Problem can be circumvented by setting the where so that
     the decimal point is NOT last, like this:
     WHERE ARR_ID_CHAIN < 200000005.0
  5) When running INZT02 receive errors building
     INXBNDSK:
     IKJ56702I INVALID FILE NAME, 00000002
     IKJ56701I MISSING FILE NAME+
     IKJ56701I MISSING FILE NAME OF DATA SET TO BE UNALLOCATED
            +++ RC(12) +++ PB 6720
  6) New FORMAT USER conversions for DATE, TIME
     TIMESTAMP. PB 6593 MR1014041639.
  7) MSGINZRE42
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: - Problem with partial INDEX SCAN       *
  *                       when the last columns of the index key *
  *                       are used in the ORDER BY and are not   *
  *                       part of the selected columns.          *
  *                       May also occur if ORDER CLUSTER is     *
  *                       used and the last columns of the       *
  *                       clustering index are not selected.     *
  *                       Symptom may be Abend U1017 issued by   *
  *                       HPU after encountering a U0027 issued  *
  *                       by DFSORT.                             *
  *                       Abend S0C4 may also occur.             *
  *                      1. Enhancement:                         *
  *                       Support of the location name in the    *
  *                       table's name (Three-Part Name).        *
  *                       When the Location name specified in    *
  *                       the SYSIN is equal to the name of the  *
  *                       current server (Local DB2), the SELECT *
  *                       can be processed natively by HPU using *
  *                       VSAM access.                           *
  *                       When the Location name specified in    *
  *                       the SYSIN is different from the        *
  *                       current server, the statement cannot   *
  *                       be processed natively by HPU. A        *
  *                       message INZSE224 WARNING :  SELECT x   *
  *                       IS NOT SUPPORTED BY DB2 HPU AND        *
  *                       SUBMITTED TO DB2 is issued.            *
  *                       If DB2 YES was specified in SYSIN,     *
  *                       the SELECT will be processed by DB2,   *
  *                       using the standard Distributed Data    *
  *                       connection. The SSID must be           *
  *                       configured to use Distributed Data.    *
  *                       In particular, if DRDA is the chosen   *
  *                       method to access data at a remote      *
  *                       server, the INZBIND job should have    *
  *                       been executed on the remote server.    *
  *                       The INZBIND job has been modified to   *
  *                       use packages and the new parmlib       *
  *                       variable VUM030 COLLOBJT that          *
  *                       contains the name of a collection for  *
  *                       the packages has been added to member  *
  *                       INZTVAR. This variable should be       *
  *                       correctly set in order to access data  *
  *                       on a remote server.                    *
  *                       If DB2 NO is specified, a message      *
  *                       INZU101E DB2 NO SPECIFIED, PROCESSING  *
  *                       TERMINATED is issued, and the SELECT   *
  *                       is not processed.                      *
  *                      2. a. Invalid output data length when   *
  *                       functions YEAR, MICROSECOND,           *
  *                       DAYOFMONTH, MONTH, DAYS, HOUR, MINUTE, *
  *                       SECOND, MIDNIGTH_SECONDS are used as   *
  *                       the argument of functions DIGITS or    *
  *                       CHAR.                                  *
  *                       b. Wrong output when scalar function   *
  *                       DECIMAL is used as the argument of     *
  *                       another scalar function.               *
  *                      3. Requirement MR040804614              *
  *                       HPU syntax : New conversion available  *
  *                       in the FORMAT USER: DECIMAL ZONED      *
  *                      4. Message INZU096E REQUIRED KEYWORD,   *
  *                       OUTDDN, NOT SPECIFIED, PROCESSING      *
  *                       TERMINATED is issued when the WHERE    *
  *                       clause finishes with a decimal value   *
  *                       that has no digits after the decimal   *
  *                       point.                                 *
  *                      5. Error message IKJ56702I INVALID      *
  *                       FILE NAME, 00000002 is displayed       *
  *                       during execution of INZT02 procedure   *
  *                       when more than 7 different values are  *
  *                       used for variable VZD012 (contains     *
  *                       the SYSAFF to use in the BIND job)     *
  *                       In addition a limit to 20 different    *
  *                       values for variable VZD012 exist and   *
  *                       makes that when more than 20 SYSAFF    *
  *                       are defined, other SYSAFF are ignored  *
  *                       and the BIND commands are not          *
  *                       correctly generated.                   *
  *                      6. New conversions available in the     *
  *                       FORMAT USER for date/time/timestamp    *
  *                       format                                 *
  *                      7. PB 6673 Problems when using BMC      *
  *                       UNLOAD PLUS syntax when DECIMAL        *
  *                       EXTERNAL or SMALLINT EXTERNAL is used. *
  *                      8. New functionnality HPU210, during    *
  *                       installation, the SYSAFF and the Data  *
  *                       Sharing groups are now taken into      *
  *                       account to generate in the INZBIND     *
  *                       only the necessary BIND commands. The  *
  *                       Steps are grouped into one job for     *
  *                       each SYSAFF.                           *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  

Problem conclusion

• - Module Inzbab was changed to keep all the columns that are
   used in the ORDER BY clause in the data passed to the SORT
  1. N/A
  2. Modules inzdyacc, inzcol and inznode were changed to process
   correctly the cases described.
  3. N/A
  4. Module inzhyacc was fixed to process correctly the decimal
   values during the global control of the sysin.
  5. Skeletons INZBNDSK and INZSBIND were changed to remove the
   error message and remove the limitation to 20 different SYSAFF.
   Procedure INZT02 was modified to allow a TBSORT to be executed
   on the ISPF table that describes the DB2 subsystems before
   generating the INZBIND job.
  6. N/A
  7. Modules inzcol and inzctrlp were fixed to process correctly
   the DECIMAL EXTERNAL and SMALLINT EXTERNAL conversions.
  8. Skeleton INZBNDSK was changed.New skeleton INZSBIND was
   added. 2 new variables VZD012 and VZD013 were added to the
   INZTVAR member. Procedure INZT02 was modified to allow a
   TBSORT to be executed on the ISPF table that describes the DB2
   subsystems before generating the INZBIND job.
  

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:

  UK00346 UK00347

Modules/Macros

•    INZBNDSK INZI01   INZQUERY INZRSAVE INZRSKEL
  INZSBIND INZTTBL  INZT02   INZUTILB INZUTISK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R210 PSY UK00346

     UP05/02/17 P F502

• R220 PSY UK00347

     UP05/02/17 P F502

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.