A fix is available
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 number
PK63325
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
910
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2008-03-26
Closed date
2008-06-06
Last modified date
2010-02-26
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
SC18985502 | GC18984302 |
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.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
26 February 2010