A fix is available
APAR status
Closed as program error.
Error description
Load fails with S0C4 abend, when ALT a table if column truncation = D- discard, and unload method = P in the WSL path.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Administration Tool * * for z/OS and DB2 Object Comparison * * Tool for z/OS who would like to use DB2 * * Parallel UNLOAD/LOAD for a dropped * * and recreated table during change * * processes like 'ALT Alter Table' (ALT), * * Object Compare and Change * * Management (CM). * **************************************************************** * PROBLEM DESCRIPTION: The DB2 Administration Tool for * * z/OS does not support specifying * * 'P - Parallel unload' in the * * 'Unload method' field on panel * * ADB2C11A 'Generate Analyze Job' * * to activate DB2 UNLOAD/LOAD in * * parallel when using Change * * Management. * * * * The DB2 Administration Tool for * * z/OS does not support specifying * * 'P' in the parameter 'unload_method' * * to activate DB2 UNLOAD/LOAD * * in parallel when using the Change * * Management batch (CM Batch) * * interface. * * * * The LOAD utility will fail with the * * error below if the data is discarded * * during the execution of Work * * Statement List (WSL) when specifying * * 'P - Parallel unload' in the 'Unload * * method' field to generate the WSL * * on panel GOC5 'Generate Compare * * Jobs' or panel ADBPALT 'ALTER - * * Build Analyze and Apply Job: * * * * - DSNU364I DSNURPPL - * * PARTITIONS WILL BE LOADED IN * * PARALLEL, NUMBER OF TASKS = >l< * * - DSNU364I DSNURPPL - MAXIMUM * * PARTITION PARALLELISM IS >l< * * BASED ON NUMBER OF INPUT FILES * * - DSNU338I DSNURWBF - INVALID * * COLUMN SPECIFICATION FOR * * >column_name< * * - DSNU302I DSNURWBF - (RE)LOAD * * PHASE STATISTICS - NUMBER OF * * INPUT RECORDS PROCESSED=>m< * * - DSNU338I DSNURWBF - INVALID * * COLUMN SPECIFICATION FOR * * >column_name< * * - DSNU302I DSNURWBF - (RE)LOAD * * PHASE STATISTICS - NUMBER OF * * INPUT RECORDS PROCESSED=>n< * * - DSNU017I DSNUGSAT - UTILITY * * DATA BASE SERVICES MEMORY * * EXECUTION ABENDED, * * REASON=X'00E40323' * * - DSNU016I DSNUGBAC - UTILITY * * BATCH MEMORY EXECUTION * * ABENDED, REASON=X'00E40347' * **************************************************************** * RECOMMENDATION: * **************************************************************** The DB2 Administration Tool for z/OS does not support specifying 'P - Parallel unload' in the 'Unload method' field on panel ADB2C11A 'Generate Analyze Job' to activate DB2 UNLOAD/LOAD in parallel when using Change Management. The DB2 Administration Tool for z/OS does not support 64 specifying 'P' in the parameter 'unload_method' to activate DB2 UNLOAD/LOAD in parallel when using the Change Management batch (CM Batch) interface. The LOAD utility will fail with the error below if the data is discarded during the execution of Work Statement List (WSL) when specifying 'P - Parallel unload' in the 'Unload method' field to generate the WSL on panel GOC5 'Generate Compare Jobs' or panel ADBPALT 'ALTER - Build Analyze and Apply Job': - DSNU364I DSNURPPL - PARTITIONS WILL BE LOADED IN PARALLEL, NUMBER OF TASKS = >l< - DSNU364I DSNURPPL - MAXIMUM PARTITION PARALLELISM IS >l< BASED ON NUMBER OF INPUT FILES - DSNU338I DSNURWBF - INVALID COLUMN SPECIFICATION FOR >column_name< - DSNU302I DSNURWBF - (RE)LOAD PHASE STATISTICS - NUMBER OF INPUT RECORDS PROCESSED=>m< - DSNU338I DSNURWBF - INVALID COLUMN SPECIFICATION FOR >column_name< - DSNU302I DSNURWBF - (RE)LOAD PHASE STATISTICS - NUMBER OF INPUT RECORDS PROCESSED=>n< - DSNU017I DSNUGSAT - UTILITY DATA BASE SERVICES MEMORY EXECUTION ABENDED, REASON=X'00E40323' - DSNU016I DSNUGBAC - UTILITY BATCH MEMORY EXECUTION ABENDED, REASON=X'00E40347'
Problem conclusion
The program has been modified to enable specifying 'P - Parallel unload' in the 'Unload method' field on panel ADB2C11A 'Generate Analyze Job' to activate DB2 UNLOAD/LOAD in parallel when using Change Management. The program has been modified to enable specifying 'P' in the parameter 'unload_method' to activate DB2 UNLOAD/LOAD in parallel when using the Change Management batch (CM Batch) interface. The program has been modified to resolve the LOAD utility error during the execution of Work Statement List (WSL) when specifying 'P - Parallel unload' in the 'Unload method' field to generate the WSL on panel GOC5 'Generate Compare Jobs' or panel ADBPALT 'ALTER - Build Analyze and Apply Job'. After applying this APAR, please note the following changes for using DB2 Parallel UNLOAD/LOAD: 1. DB2 Parallel UNLOAD/LOAD will be activated in the change processes 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. - For non CM Batch, the 'Unload method' field on panels GOC5 'Generate Compare Job' / ADBPALT 'Build Analyze and Apply Job' / ADB2C11A 'Generate Analyze Job' is set to 'P'. For CM Batch, the 'unload_method' parameter is set to 'P'. 2. When DB2 UNLOAD is requested to be done in parallel, if the user-defined template ALULD or ALULDC is specified in non CM Batch path or if the parameter 'util_template_unload_unlddn_name', 'util_template_unload_unlddnc_name', 'util_clone_template_unload_unlddn_name' or 'util_clone_template_unload_unlddnc_name' is specified to use user-defined template in CM Batch path, 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. TIP: Please consider the extended length of the resulting data set when specifying the maximum data set length for the template. 3. When DB2 UNLOAD is requested to be done in parallel, if the user-defined template ALULD or ALULDC is not used in non CM Batch path or if the parameter 'util_template_unload_unlddn_name', 'util_template_unload_unlddnc_name', 'util_clone_template_unload_unlddn_name' or 'util_clone_template_unload_unlddnc_name' is not used in CM Batch path, 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. When DB2 UNLOAD is requested to be done in parallel, if the user-defined template DISCARDDN is used in non CM Batch path or if the parameter 'util_template_discarddn_name' or 'util_clone_template_discarddn_name' is used in CM Batch path 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. TIP: Please consider the extended length of the resulting data set when specifying the maximum data set length for the template. 5. When DB2 UNLOAD is requested to be done in parallel, if the user-defined template DISCARDDN is not used in non CM Batch path or if the parameter 'util_template_discarddn_name' or 'util_clone_template_discarddn_name' is not used in CM Batch path, 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. TIP: Please consider the extended length of the resulting data set before running the job. Updates to the DB2 Administration Tool for z/OS, User's Guide and Reference, Version 11, Release 1 will be available in the following techdoc after 10/31/2014: http://www-01.ibm.com/support/docview.wss?uid=swg27041314
Temporary fix
Comments
APAR Information
APAR number
PM91177
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
A10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-06-17
Closed date
2014-10-17
Last modified date
2014-11-04
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
ADBCCM ADBGAJOB ADBHALT ADBHC11A ADBSCJCL ADBS27AC ADBTEP2 ADBTREL ADBTUNL ADB2C11A ADB2DSN ADB2PA4 ADB2PTPL ADB2W1 ADB2000 ADB27AC
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
RB10 PSY UI22282
UP14/10/22 P F410
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.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
04 November 2014