PK63325: LOAD COPYDICTIONARY ENHANCEMENT

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• LOAD COPYDICTIONARY ENHANCEMENT
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 9 for z/OS utility users of LOAD     *
  ****************************************************************
  * PROBLEM DESCRIPTION: New function to enable LOAD             *
  *                      COPYDICTIONARY option to allow          *
  *                      compression dictionaries to be copied   *
  *                      from one partition to another in a      *
  *                      classic partitioned or Partition-by-    *
  *                      Range table space                       *
  ****************************************************************
  * RECOMMENDATION: Apply corrective PTF when available          *
  ****************************************************************
  New LOAD keyword, COPYDICTIONARY integer, at the table space
  level enables LOAD PART REPLACE to copy an existing
  compression dictionary from the partition specified to all
  partitions being PART REPLACEd.
  

Problem conclusion

Temporary fix

Comments

• Code has been changed to enable the new LOAD COPYDICTIONARY
  option.
  
  EXAMPLE: How to copy a compression dictionary from physical
           partition 1 to partitions 3 and 5.
  
       LOAD COPYDICTIONARY 1
            INTO TABLE PART 3 REPLACE
            INTO TABLE PART 5 REPLACE
  
  The following books will be updated.
  
  The Utility Guide and Reference has been updated to add the
  new COPYDICTIONARY option:
  
  updated SYNTAX DIAGRAM:
  
           .-DATA-.  .-INDDN--SYSREC----------.
  >>-LOAD--+------+--+------------------------+--+-----------+-->
                     +-INDDN--ddname---------+  '-PREFORMAT-'
  
  ...
  
  |>--+----------------------------+---------------------------->
  |   |                .-1-------. |
  |   '-COPYDICTIONARY-+---------+-'
  |                    '-integer-'
  
  new OPTIONS DESCRIPTION:
  
  COPYDICTIONARY integer
  Allows the LOAD utility to copy an existing compression
  dictionary from the specified partition to other partitions
  on a partitioned table space.  LOAD copies the current
  compression dictionary from the specified partition and
  uses it for compressing the input data for the partitions
  being replaced.  This option provides a method to copy a
  compression dictionary to an empty partition that normally
  wouldn't have a compression dictionary built.
  
  The COPYDICTIONARY keyword is only compatible on classic
  partitioned and UTS Partition-by-range table spaces with
  PART integer REPLACE statements, where the partition being
  copied is not the same as the partition(s) being replaced.
  LOAD PART integer RESUME is not supported with the
  COPYDICTIONARY keyword.  Neither is LOAD RESUME YES
  COPYDICTIONARY.
  
  
  The COPYDICTIONARY keyword is incompatible with the
  KEEPDICTIONARY keyword at the table space or partition
  level and the REPLACE keyword at the table space level.
  This keyword will only copy the compression dictionary
  to partition(s) being replaced that has the COMPRESS YES
  attribute.  A valid dictionary must exist for the partition
  specified with the COPYDICTIONARY keyword.
  
  You can specify any valid partition number that is not
  being replaced for the partitioned table space.  The
  default value is 1.
  
  
  The Messages and Codes book will be updated to add or modify
  the following messages:
  
  DSNU242I
  |csect-name KEEPDICTIONARY OR COPYDICTIONARY REQUESTED
  BUT COMPRESS ATTRIBUTE NOT DEFINED ON TABLE SPACE
  table-space-name, PARTITION part-num
  
  Explanation
  |The KEEPDICTIONARY  option was specified in the LOAD
  |or REORG TABLESPACE utility statement or the
  | COPYDICTIONARY option was specified in
  |a LOAD utility statement. This keyword should only
  be used with table space partitions that have the
  COMPRESS YES attribute. Otherwise, it is ignored. The
  COMPRESS column of SYSIBM.SYSTABLEPART contains the
  current compression status.
  
  System action
  Processing continues. If the dictionary exists, it is
  erased if LOAD REPLACE or REORG is specified.
  
  Severity
  4 (warning)
  
  DSNU243I
  csect-name COMPRESSION DICTIONARY DOES NOT EXIST FOR
  TABLE SPACE table-space-name, PARTITION part-num
  
  Explanation
  | The KEEPDICTIONARY option was specified in the LOAD
  |or REORG TABLESPACE utility statement or the
  |COPYDICTIONARY option was specified in
  |a LOAD utility statement for a table space partition
  that does not have a compression dictionary.
  
  System action
  |Processing continues. If KEEPDICTIONARY was specified,
  |a dictionary is built for the table space partition.
  |If COPYDICTIONARY was specified, no dictionaries
  |are copied.
  
  Severity
  4 (warning)
  
  DSNU247I
  csect-name COMPRESSION DICTIONARY FROM TABLE SPACE
  table-space-name PARTITION part-num1 COPIED to
  PARTITION part-num2
  
  Explanation
  A compression dictionary from partition part-num1 was
  successfully copied to part-num2 for the specified
  table space.
  
  System action
  Processing continues.
  
  Severity
  0 (informational)
  
  DSNU1132I
  csect-name COPYDICTIONARY OPERAND CANNOT BE A
  PARTITION THAT IS BEING REPLACED
  
  Explanation
  LOAD COPYDICTIONARY was specified on a partition that
  was also being replaced.  COPYDICTIONARY is not
  supported for this case.
  
  System action
  Utility operation is terminated with return code 8.
  
  User response
  Correct the LOAD statement in one of the following ways:
  Specify a different partition number on the INTO TABLE
  PART clause
  Specify a different partition number on the COPYDICTIONARY
  option
  
  Severity
  8 (error)
  

APAR Information

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

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

  UK37143

Modules/Macros

• DSNDUSMF DSNDUSO  DSNDUSU  DSNFMDIR DSNFUDRA
  DSNFUDRB DSNFUDRC DSNFUDRD DSNFUDRE DSNUGDDF DSNUGMST DSNUGPPF
  DSNUGPRT DSNUGTTF DSNUMSGA DSNUMSGB DSNUMSGC DSNUMSGD DSNUMSGE
  DSNURPDC DSNURUSO DSNURWI
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• R910 PSY UK37143

     UP08/06/24 P F806

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.