PK18123: INCORRECT OUTPUT UNLOADING A UNICODE TABLE.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• 1. Incorrect output when unloading a UNICODE table.
  PB7810
  2. Different results during BMC to HPU conversion.
     PB 7809
  3. Launching HPU from panel ADB21S in Admin gets an INVALID
     MATCH message from panel INZA61.
     PB 7806
  4. ORDER BY allocates sortwork data sets even when they
     are not used.
     PB 7802
  5) ABENDB37 on HPU unload in the SORT step:
     B37-04,IFG0554A,INCJ0301,DB2HPU,T001MG
     on the T001MG file. This problem can occur when
     the compression ratio for a very big tablespace is higher
     than 95% and when the DASD volumes on which the T001MG
     file are placed are limited, either in available space per
     volume or in the number of volsers. PB 4837
     CIRCUMVENTION: Make more space available to the T001MG
     allocation, either by providing additional volsers or by
     freeing space on the volsers already available.
  6) Provide native support of SECLABEL. PB 7103
  7) Wrong LOAD SYSIN when using table name longer than 61 char.
     PB 7836
  8) Potential S0C4 when unloading a
     compressed partitioned tablespace that
     has more than 256 partitions. PB 7803
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. Incorrect output when unloading a    *
  *                      UNICODE table. PB 7810                  *
  *                      2. Different results during BMC to HPU  *
  *                      conversion. PB 7809                     *
  *                      3. Launching HPU from panel ADB21S in   *
  *                      Admin gets an INVALID MATCH message     *
  *                      from panel INZA61. PB 7806              *
  *                      4. ORDER BY allocates sortwork datasets *
  *                      even when they are not used. PB 7802    *
  *                      5. ABENDB37 on HPU unload in the SORT   *
  *                      step: B37-04,IFG0554A,INCJ0301,DB2HPU,  *
  *                      T001MG on the T001MG file. This problem *
  *                      can occur when the compression ratio    *
  *                      for a very big tablespace is higher     *
  *                      than 95% and when the DASD volumes on   *
  *                      which the T001MG file are placed are    *
  *                      limited, either in available space per  *
  *                      volume or in the number of volsers.     *
  *                      PB 4837                                 *
  *                      6. Provide native support of SECLABEL.  *
  *                      PB 7103                                 *
  *                      7. Wrong LOAD SYSIN when using table    *
  *                      name longer than 61 char. PB 7836       *
  *                      8. Potential S0C4 when unloading a      *
  *                      compressed partitioned tablespace that  *
  *                      has more than 256 partitions. PB 7803   *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  1. Module UDBCRFELwas changed to initialize with the proper
  characters the output field when a CCSID conversion is invoked.
  2. Modules inzcol, inzctrlp, inznode and inzpyacc were changed
  to process the conversion from numeric or date/time to CHAR the
  same way as conversion to numeric external or date/time
  external in case of Unload Plus syntax.
  3. Module inzacdb2 was changed. Select statements used to read
  the DB2 catalog which used to use LIKE 'name'.
  4. Module UDBSPUTS was changed to use the size of the biggest
  partition instead of the sum of all partitions in the specific
  case described.
  5. Module udbevtts was changed by modifying the estimated
  compression ratio, in order to support tablespaces with a high
  compression ratio.
  6. Not a bug.
  7. Module inzrload was changed to cut correctly the LOAD command
  into serveral lines of 72 characters each.
  8. Module UDBSPUTS was changed to use a buffer large enough to
  store 4096 entries for the address of the compression
  dictionaries.
  

Problem conclusion

• APPLY the PTF.
  

Temporary fix

Comments

• ž**** PE06/08/28 FIX IN ERROR. SEE APAR PK30591  FOR DESCRIPTION
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UK12543 UK12544

Modules/Macros

•    INZACDB2 INZTPMEM INZUTILB
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R210 PSY UK12543

     UP06/03/17 P F603

• R220 PSY UK12544

     UP06/03/17 P F603

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.