PK36600: ABEND S0C4 IN IGG019AK WHEN PARTIAL INDEXSCAN IS USED. PB 8590.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Abend S0C4 in IGG019AK when partial INDEXSCAN is used. PB 8590.
  ADDITIONAL SYMPTOMS:
  1) ABEND413-34 when unloading in VARIABLE format into several
     files stacked on tape. PB 8602
  2) When generating the LOAD SYSIN, the SORTKEYS(nnn) is
     processed as SORTKEYS(&SORTKEYS), and the value specified in
     parmlib is replaced by a calculated value. PB 8612
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: Abend S0C4 in IGG019AK when partial     *
  *                      INDEXSCAN is used. PB 8590.             *
  *                      ADDITIONAL SYMPTOMS:                    *
  *                      1. ABEND413-34 when unloading in        *
  *                      VARIABLE format into several files      *
  *                      stacked on tape. PB 8602                *
  *                      2. When generating the LOAD SYSIN, the  *
  *                      SORTKEYS(nnn) is processed as           *
  *                      SORTKEYS(&SORTKEYS), and the value      *
  *                      specified in parmlib is replaced by a   *
  *                      calculated value. PB 8612               *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Module udbsputs was changed to compute the length of the record
  in case of INDEXSCAN. When some columns are not used in
  predicates and are not part of the unloaded data they are not
  passed to the SORT, and not written in the T001MG file, so
  their length should be substracted from the physical record
  length.
  ADDITIONAL SYMPTOMS:
  1. Modules inzrun and inzrload were changed. In case of FORMAT
  VARIABLE, the OPEN and CLAUSE operation is no longer processed
  before processing the UNLOAD commands. New functions
  inzrunOpenFileUnload() and inzrunCloseFileUnload are added to
  process the open and close operations when necessary.
  2. Modules inzctrl, inzrload, and inzhyacc were changed to
  process correctly the SORTKEYS(nnn) setting.
  

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:

  UK21293

Modules/Macros

•    INZUTILB
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R220 PSY UK21293

     UP07/01/18 P F701

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.