A fix is available
APAR status
Closed as program error.
Error description
The DB2 Object Comparison Tool for z/OS panel's GOC5 'Generate Compare Jobs' field 'Unload method''s option 'P - Parallel unload' does not result in parallel unloads even when a TEMPLATE specifying the &PART. or &PA. variable is used.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Administration Tool and * * DB2 Object Comparison Tool for z/OS who * * would like to activate DB2 Parallel * * UNLOAD/LOAD or HPU Parallel UNLOAD/LOAD * * for a dropped and recreated table in the * * APPLY batch job. * **************************************************************** * PROBLEM DESCRIPTION: The DB2 Administration Tool and DB2 * * Object Comparison Tool for z/OS do * * not execute the UNLOAD/LOAD in * * parallel in the APPLY batch job even * * when specifying 'Unload method' of * * 'P - Parallel unload' or 'H - HPU' * * on panels GOC5 'Generate Compare * * Job' / ADBPALT 'Build Analyze and * * Apply Job', and including variable * * &PART. or &PA. in the template for * * unloading data. * **************************************************************** * RECOMMENDATION: * **************************************************************** The DB2 Administration Tool and DB2 Object Comparison Tool for z/OS do not execute the UNLOAD/LOAD in parallel in the APPLY batch job even when specifying 'Unload method' of 'P - Parallel unload' or 'H - HPU' on panels GOC5 'Generate Compare Job' / ADBPALT 'Build Analyze and Apply Job', and including variable &PART. or &PA. in the template for unloading data.
Problem conclusion
The program has been modified to activate DB2 Parallel UNLOAD/LOAD and HPU Parallel UNLOAD/LOAD in the APPLY batch job. After applying this APAR, please note the following changes: For DB2 Parallel UNLOAD/LOAD: 1. DB2 Parallel UNLOAD/LOAD will be activated in the APPLY batch job when the following factors are true: - The changes are compatible with DB2 Parallel UNLOAD/LOAD when a table is loaded into a partitioned table space and the number of partitions has not been changed. - The field 'Unload method' on panels GOC5 'Generate Compare Job' / ADBPALT 'Build Analyze and Apply Job' is set to 'P'. 2. If the user-defined template ALULD or ALULDC is specified and DB2 UNLOAD is requested to be done in parallel in the APPLY batch job, an additional P&PA qualifier will be added to the template if &PA is not already present in the template which will extend the length of the result data set name by 7 bytes. Please take this into consideration when specifying the entire maximum data set length for the template. 3. If the user-defined template ALULD or ALULDC is not used and DB2 UNLOAD is requested to be done in parallel in the APPLY batch job, the default data sets defined in variables ASYRECH/ASYRECHC of skeleton ADB2UCUS will be used as a parallel unload template for base and clone objects, so they must include &&PART. or &&PA., and the default data sets defined in variables ASYRECW/ASYRECWC of skeleton ADB2UCUS will be used for converting unload data if needed for base and clone objects, so they must include &&PART. or &&PA. as well. 4. If the user-defined template DISCARDDN is specified and DB2 LOAD is to be done in parallel in the APPLY batch job, an additional P&PA qualifier will be added to the template if &PA is not already present in the template which will extend the length of the result data set name by 7 bytes. Please take this into consideration when specifying the entire maximum data set length for the template. 5. If the user-defined template DISCARDDN is not used and DB2 LOAD is to be done in parallel in the APPLY batch job, the default data set defined in variable SYSDISC of skeleton ADB2UCUS will be used as a parallel discard template and be forced to append an additional P&PA qualifier if &PA is not already present in the data set name which will extend the length of the result data set name by 7 bytes. Please take this into consideration before running the APPLY job. For HPU Parallel UNLOAD/LOAD: 1. HPU Parallel UNLOAD/LOAD will be activated in the APPLY batch job when the following factors are true: - The changes are compatible with HPU Parallel UNLOAD/LOAD when a table is loaded into a partitioned table space and the number of partitions has not been changed. - The field 'Unload method' on panels GOC5 'Generate Compare Job' / ADBPALT 'Build Analyze and Apply Job' is set to 'H'. - If the user-defined template ALULD is specified, the template name should include variable &PART. or &PA. or HPU Parallel UNLOAD/LOAD will not be activated. If the user-defined template ALULD is not used, the default data set name defined in variables ASYRECD/ASYRECDC of skeleton ADB2UCUS for unloading data for base and clone objects should include variable &&PART. or &&PA., or HPU Parallel UNLOAD/LOAD will not be activated. Please note that the variables ASYRECD/ASYRECDC are also used for unloading data when 'Unload method' equals 'U' and the user-defined template ALULD is not used, so in order to not influence the usage for 'Unload method' = 'U', the proposed way to activate HPU Parallel Unload is to use user-defined template ALULD with variable &PART. or &PA. in it. 2. If HPU Parallel UNLOAD was done, the convert program of Admin Tool will append an additional P&PA qualifier to the data set name which is defined in user-defined template ALULDC or in the variables ASYRECG/ASYRECGC of skeleton ADB2UCUS for converting unload data if &PA is not already present in the data set name which will extend the length of the result data set name by 7 bytes. Please take this into consideration before running the APPLY job. 3. If the user-defined template DISCARDDN is specified and DB2 LOAD is to be done in parallel in the APPLY batch job, please note that the template must include &PART. or &PA. so that discard data can be restored in parallel. 4. If the user-defined template DISCARDDN is not used and DB2 LOAD is to be done in parallel in the APPLY batch job, the default data set defined in variable SYSDISC of skeleton ADB2UCUS will be used as a parallel discard template and be forced to append an additional P&PA qualifier if &PA is not already present in the data set name which will extend the length of the result data set name by 7 bytes. Please take this into consideration before running the APPLY job. After applying this APAR, you may encounter the following known issues: - When HPU Parallel UNLOAD is activated for PBG table space, the LOAD utility will fail because an invalid partition specification PART(n) is generated in the LOAD control statement. This issue will be addressed in a follow-on APAR PM90898. - When DB2 Parallel UNLOAD is activated for a table with LOB columns, the UNLOAD utility will fail with error message: DSNU283I >timestamp< DSNUULVA - LOB ERROR SQLCODE = -452 SQLERRM = >data_set< 13 SQLSTATE= 428A1 SQLERRP = DSNOLFRV This issue will be addressed in follow-on APAR PM57188. When performing ALT 'ALT Alter Table' on a table and specifying column truncation 'D - put it on DISCARDS file' and setting the Unload method to 'P - DB2 Parallel Unlod', the LOAD utility will fail with a S0C4 abend because DISCARDDN is not specified correctly: DSNURWBF - INVALID COLUMN SPECIFICATION FOR col_name DSNURWBF - (RE)LOAD PHASE STATISTICS - NUMBER OF INPUT RECORDS PROCESSED=1 DSNUGSAT - UTILITY DATA BASE SERVICES MEMORY EXECUTION ABENDED, REASON=X'00E4032 DSNUGBAC - UTILITY BATCH MEMORY EXECUTION ABENDED, REASON=X'00E40347' This issue will be addressed in a follow-on APAR PM91177. This FIX requires that the ADB2UCUS skeleton be updated. See SADBSAMP(ADB2UC10) for details in DB2 Administration Tool for z/OS, Release 10, Version 1, and see SADBSAMP(ADB2UCU3) for details in DB2 Administration Tool for z/OS, Release 10, Version 2. INSTRUCTIONS: ------------ MODIFY BELOW LINE TO SHORTEN THE DATA SET NAME OF ASYRECHC BEFORE: -SET ASYRECHC = &PREFIX..&DB2SYS..&LEVEL..ULD. &TNAME..P&&PART..CLONE AFTER: -SET ASYRECHC = &PREFIX..&DB2SYS..&LEVEL..ULD. &TNAME..P&&PART..CL INSTRUCTIONS: ------------ APPEND BELOW LINES TO THE BOTTOM OF ISPSLIB MEMBER ADB2UCUS AND MODIFY THE VALUES OF ASYRECW AND ASYRECWC ACCORDING TO THE LOCAL ENVIRONMENT REQUIREMENT. -CM USED IN SKEL GOCTREL RELOAD (OBJECT COMPARE) -CM GOC27AC CONVERT STMTS (OBJECT COMPARE) -CM NOTE: THE FOLLOWING DSN IS USED IN A PARALLEL -CM RELOAD TEMPLATE AND SO MUST INCLUDE &&PART OR -CM &&PA. -CM BECAUSE THIS DSN IS USED IN A TEMPLATE, -CM ANY VARIABLE MUST END WITH A PERIOD, INCLUDING -CM THE LAST NODE -SET ASYRECW = &PREFIX..&DB2SYS..&LEVEL..ULC. &TNAME..P&&PART. -CM USED IN SKEL GOCTREL RELOAD (OBJECT COMPARE) -CM FOR CLONE -CM GOC27AC CONVERT STMTS (OBJECT COMPARE) FOR CLONE -CM NOTE: THE FOLLOWING DSN IS USED IN A PARALLEL -CM RELOAD TEMPLATE AND SO MUST INCLUDE &&PART OR -CM &&PA. BECAUSE THIS DSN IS USED IN A TEMPLATE, -CM ANY VARIABLE MUST END WITH A PERIOD, INCLUDING -CM THE LAST NODE -SET ASYRECWC = &PREFIX..&DB2SYS..&LEVEL..ULC. &TNAME..P&&PART..CL NOTE: Please replace leading dashes '-' with closing PARENTHESIS before adding the statements above.
Temporary fix
Comments
APAR Information
APAR number
PM62098
Reported component name
DB2 OBJECT COMP
Reported component ID
5697G6400
Reported release
A20
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-04-09
Closed date
2013-07-16
Last modified date
2013-08-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK95900 UK95901
Modules/Macros
ADBGAJOB ADBH5TUA ADBH5TU1 ADBS27AC ADBTHPU ADBTREL ADBTUNL ADB2CMF ADB2CMP ADB2CMR ADB2CMT ADB2PA ADB2PTPL ADB2UCU3 ADB2UC10 ADB25TL1 ADB27AC ADB27PAL
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
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":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.2.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
02 August 2013