A fix is available
APAR status
Closed as program error.
Error description
The DB2 Administration Tool for z/OS created DB2 utility job fails with a message: DSNU1029I DSNUGDFL - INVALID KEYWORD SPACE FOR TAPE TEMPLATE
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Administration Tool * * for z/OS who use Work Statement List * * (WSL) to LOAD data into a table. * * In the WSL, the SYSREC template is * * defined on removable media, such * * as a tape device. * **************************************************************** * PROBLEM DESCRIPTION: When using WSL to LOAD data into a * * table and the user also uses WORKDDN, * * MAPDDN and ERRDDN user-defined * * templates which are defined on * * a removable media device, such * * as tape, to be used in the WSL, * * the DB2 utility job fails with the * * following error message: * * * * DSNU1029I DSNUGDFL - INVALID * * KEYWORD SPACE FOR TAPE * * TEMPLATE * **************************************************************** * RECOMMENDATION: * **************************************************************** When using WSL to execute the LOAD utility, the job fails with the following error message: DSNU1029I DSNUGDFL - INVALID KEYWORD SPACE FOR TAPE TEMPLATE.
Problem conclusion
Problem has been resolved. - If the user-defined templates WORKDDN, MAPDDN and ERRDDN are on removable media, there is no need to add the SPACE keyword. - The template table needs to be updated to add the new column DEVTYPE. The user can use the 'UT - Utility selections' command on panel ADB25 'Utility generation using LISTDEFs and TEMPLATEs' to update the user-defined template table. - Panel ADB25TE 'Utility Template' is updated to add new field 'Device type' to identify whether the UNIT is on a removable device: Common options: UNIT . . . . . (Device number, type or group name) Device type . (DASD or TAPE, default is DASD) The following text is added on Help panel ADBH5TE 'HELP: Utility Template': 'If the template will be created on removable media, then specify 'TAPE' in the 'Device type' field.' - If the user does not use a user-defined template but uses a system default template, the user need to add the '--#TEMPLATE' comment statement in the WSL manually. For example, if MAPDDN template is defined, add the '--#TEMPLATE' comment statement: --#TEMPLATE UTLMAP TYPE(TAPE) TEMPLATE UTLMAP DSN 'SYSADM.XXX.T001' UNIT TAPE - New parameters are added for the Change Management Batch (CM Batch) interface: util_template_workdd1_devtype The util_template_workdd1_devtype parameter specifies whether WORKDDN1 template is on removable media or DASD device. Values: TAPE, DASD, blank TAPE removable media device DASD DASD device Default: blank util_template_workdd2_devtype The util_template_workdd2_devtype parameter specifies whether WORKDDN2 template is on removable media or DASD device. Values: TAPE, DASD, blank TAPE removable media device DASD DASD device Default: blank util_template_mapddn_devtype The util_template_mapddn_devtype parameter specifies whether MAPDDN template is on removable media or DASD device. Values: TAPE, DASD, blank TAPE removable media device DASD DASD device Default: blank util_template_errddn_devtype The util_template_errddn_devtype parameter specifies whether ERRDDN template is on removable media or DASD device. Values: TAPE, DASD, blank TAPE removable media device DASD DASD device Default: blank
Temporary fix
Comments
APAR Information
APAR number
PI19110
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
A20
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2014-06-02
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 ADBH5TE ADBTEP2 ADBTREL ADB2U ADB2UTLX ADB2000 ADB25C ADB25TE ADB25TL1 ADB25TU ADB25TUP
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:
04 November 2014