A fix is available
APAR status
Closed as program error.
Error description
DB2 ADMINISTRATION TOOL FOR Z/OS. Executing stand-alone UNLOAD utility on table in classic partitioned or PBR tablespace by WSL using HPU-High Performance Unload results in RC=8 with error message: "INZC003E ERROR DDNAME ULD NOT ALLOCATED AND/OR NOT ROOT OF ANY ALLOCATED DDNAMES"
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Object Comparison Tool * * and DB2 Administration Tool for z/OS. * **************************************************************** * PROBLEM DESCRIPTION: When running an UNLOAD within a work * * statement list (WSL), using High * * Performance Unload for z/OS (HPU) as * * the unload method, and using a punch * * DD name other than SYSPUNCH or * * unload DD name other than SYSREC, * * the unload will fail because the DD's * * are not allocated. The job fails * * with a RC8 / Return Code 8 and the * * following HPU error will be produced: * * * * INZC003E ERROR DDNAME * * UTLREC NOT ALLOCATED * * AND/OR NOT ROOT OF ANY * * ALLOCATED DDNAMES * * * * INZU366I UTILITY RETURN CODE * * 8 (REASON CODE 0x107a002) * * ADBT015I Failure attempting * * to execute INZUTILB with parm * * ssid,TEST1,HIDDEN(YES) * * 8 * * ADB5184E The run is ending due to an * * error with a non-SQL command. * * Additional messages may have been * * sent to the DD SYSTSPRT * * Additional diagnostics * * NNNINYN * * commit_all_req=N * * asw_req =N * * asw_app =N * * asw_stmt_app =I * * chk_rec_found =N * * SQLCODE -626? =N * * * * If the table space is partitioned, * * this error will be produced: * * * * INZC003E ERROR DDNAME ULD * * NOT ALLOCATED AND/OR NOT * * ROOT OF ANY ALLOCATED * * DDNAMES * * * * The first error occurs because the DD * * is not allocated. The second occurs * * because the OUTDDN(>value<) is forced * * to OUTDDN(ULD) for partitioned object * * unloads. * **************************************************************** * RECOMMENDATION: * **************************************************************** When running an UNLOAD within a Work Statement List (WSL), using High Performance Unload for z/OS (HPU) as the unload method, and using a punch DD name other than SYSPUNCH or unload DD name other than SYSREC, the unload will fail because the DD's are not allocated. The job fails with a RC8 / Return Code 8 and the following HPU error will be produced: INZC003E ERROR DDNAME UTLREC NOT ALLOCATED AND/OR NOT ROOT OF ANY ALLOCATED DDNAMES INZU366I UTILITY RETURN CODE 8 (REASON CODE 0x107a002) ADBT015I Failure attempting to execute INZUTILB with parm ssid,TEST1,HIDDEN(YES) 8 ADB5184E The run is ending due to an error with a non-SQL command. Additional messages may have been sent to the DD SYSTSPRT Additional diagnostics NNNINYN commit_all_req=N asw_req =N asw_app =N asw_stmt_app =I chk_rec_found =N SQLCODE -626? =N If the table space is partitioned, this error will be produced: INZC003E ERROR DDNAME ULD NOT ALLOCATED AND/OR NOT ROOT OF ANY ALLOCATED DDNAMES The first error occurs because the DD is not allocated. The second occurs because the OUTDDN(>value<) is forced to OUTDDN(ULD) for partitioned object unloads.
Problem conclusion
Problem has been resolved.
Temporary fix
Comments
APAR Information
APAR number
PM76369
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
A10
Status
CLOSED PER
PE
YesPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-11-02
Closed date
2012-12-14
Last modified date
2013-01-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK90384 UK90385
Modules/Macros
ADBTTP
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.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
02 January 2013