A fix is available
APAR status
Closed as program error.
Error description
The DB2 Administration Tool for z/OS' discover EXEC requires the DB2 Administration Tool for z/OS Version 10.1 SADBTLIB members ADB2PARM and ADB2DB2D to be copied to the Version 10.2 SADBTLIB library for the discovery process to work. Symptom: The error was : "CCQO071W The ADB member could not be found in the hlq.mlq.DISCOVER Discover data set."
Local fix
Work around 1: Copy the ISPTLIB members ADB2DB2D and ADB2PARM from Version 10.1 to Version 10.2 ISPTLIB Work around 2: Amend SADBEXEC(ADB2CUST) to include an "ISPEXEC TBEND" dtab as shown in line 314: 000311 if debugl > 0 then say 'cjesidd='cjesid 'csysmeth='csysmeth 000312 000313 /* Ensure table ADBTPARM is not left open. */ 000314 "ISPEXEC TBEND" dtab <=== Add this line 000315
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Administration Tool and * * IBM Tools Customizer (TCz) for z/OS. * **************************************************************** * PROBLEM DESCRIPTION: The following issues have been fixed: * * * * 1. The TCz DISCOVER process required * * the DB2 Administration Tool for z/OS * * Version 10.1 SADBTLIB members ADB2PARM * * and ADB2DB2D to be copied to the * * Version 10.2 SADBTLIB library for the * * discovery process to work. With this * * fix, this is no longer required. * * * * 2. Description/order to input fields * * for DISCOVER panel CCQPDSC 'Discover * * Customized Product Information' * * are not clear. The following changes * * have been implemented to promote * * clarification and better guidance. * * Context-sensitive help to input * * fields has also been improved: * * * * Before: * * DB2 Admin tool high-level qualifier . * * DB2 Group Attach Name . . . . . . . . * * Customized parameters table library . * * Debug . . . . . . . . . . . . . . . . * * * * After: * * Source Customized table library . . . * * Target Customized table library . . . * * DB2 Group Attach Name . . . . . . . . * * Trace . . . . . . . . . . . . . . . . * * * * Usage notes: * * The 'Target Customization table * * library' input field is generally * * used when upgrading from a prior * * release of DB2 Administration Tool. * * * * For example, when upgrading from DB2 * * Administration Tool Version 10.1 to * * Version 10.2, do the following: * * * * Source Customized table library . . . * * <--- Specify the DB2 Administration * * Tool Version 10.1 tables library that * * contains the Customization tables * * ADB2DB2D and ADB2PARM. * * * * Target Customized table library . . . * * <--- Specify the DB2 Administration * * Tool Version 10.2 tables library of * * which the DISCOVER process will write * * to. * * * * Note: * * If installing DB2 Administration Tool * * for the first time (no prior release), * * the DISCOVER process can be skipped * * since there are no prior Customized * * tables to discover. * * * * * * 3. DISCOVER process did not provide * * informational guidance as to what is * * taking place, nor proper error * * handling. This area has been enhanced * * to provide a DISCOVER Processing * * Report. * * The DA('>SYSUID<.TCZ.DISCOVER.REPORT') * * is displayed during the DISCOVER * * process with captured information * * that an installer can use to inspect * * migrated settings. * * * * 4. When customizing TCz on panel * * CCQPDB2, 'DB2 Parameter' or panel * * CCQPPRD 'Product Parameters', * * and specifying a value for the 'DB2 * * Table Editor CLIST dsname(member)' * * field, and YES to enable the DB2 * * Table Editor Tool, the ADBCUSAA job * * reports the following error: * * * * subsys keyword pos dataset name * * error description * * -------------------------------------- * * * ADBTECL 1 >hlq<.SETISAMP(ETI)' * * Member name not allowed * * >ssid< ADBTECL 1 >hlq<.SETISAMP(ETI)' * * Member name not allowed * * -------------------------------------- * * * * 5. If user enables InfoSphere Optim * * Configuration Manager (OCM) tasks and * * steps through panel CCQPPRD 'Product * * Parameter', it then enables the hidden * * OCM options in panel CCQPDB2 'DB2 * * Parameters', and the 'Action to take * * on error' field is pre-filled with the * * LOCAL value. The jobs are incorrectly * * built with the default value of * * LOCAL instead of the option specified * * in the '(Global) Action to take on * * error' field, which was OVERRIDE. * **************************************************************** * RECOMMENDATION: * **************************************************************** The following issues have been fixed: 1. The TCz DISCOVER process required the DB2 Administration Tool for z/OS Version 10.1 SADBTLIB members ADB2PARM and ADB2DB2D to be copied to the Version 10.2 SADBTLIB library for the discovery process to work. With this fix, this is no longer required. 2. Description/order to input fields for DISCOVER panel CCQPDSC 'Discover Customized Product Information' are not clear. The following changes have been implemented to promote clarification and better guidance. Context-sensitive help to input fields has also been improved: Before: DB2 Admin tool high-level qualifier . . . . DB2 Group Attach Name . . . . . . . . . . . Customized parameters table library . . . . Debug . . . . . . . . . . . . . . . . . . . After: Source Customized table library . . . . . . Target Customized table library . . . . . . DB2 Group Attach Name . . . . . . . . . . . Trace . . . . . . . . . . . . . . . . . . . Usage notes: The 'Target Customization table library' input field is generally used when upgrading from a prior release of DB2 Administration Tool. 3. DISCOVER process did not provide informational guidance as to what is taking place, nor proper error handling. This area has been enhanced to provide a DISCOVER Processing Report. The Report file DD($DRPT$n) DA('>SYSUID<.TCZ.DISCOVER.REPORT') is displayed during the DISCOVER process with captured information that an installer can use to inspect migrated settings. 4. When customizing TCz on panel CCQPDB2, 'DB2 Parameter' or panel CCQPPRD 'Product Parameters', and specifying a value for the 'DB2 Table Editor CLIST dsname(member)' field, and YES to enable the DB2 Table Editor Tool, the ADBCUSAA job reports the following error: subsys keyword pos dataset name error description --------------------------------------------------------------- * ADBTECL 1 >hlq<.SETISAMP(ETI)' Member name not allowed >ssid< ADBTECL 1 >hlq<.SETISAMP(ETI)' Member name not allowed --------------------------------------------------------------- 5. If user enables InfoSphere Optim Configuration Manager (OCM) tasks and steps through panel CCQPPRD 'Product Parameter', it then enables the hidden OCM options in panel CCQPDB2 'DB2 Parameters', and the 'Action to take on error' field is pre-filled with the LOCAL value. The jobs are incorrectly built with the default value of LOCAL instead of the option specified in the '(Global) Action to take on error' field, which was OVERRIDE.
Problem conclusion
Problem has been resolved.
Temporary fix
Comments
APAR Information
APAR number
PM77364
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
2012-11-19
Closed date
2013-02-05
Last modified date
2013-03-04
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK91432
Modules/Macros
ADB$$DSC ADB$$PRM ADB$$SEQ ADBBIND ADBCATVT ADBCFGBD ADBCFGPM ADBCHANG ADBCHG01 ADBCHKPT ADBCHU01 ADBCUST ADBCX ADBCX10 ADBGC ADBGC10 ADBLIM ADBMCMA ADBPRHIS ADBREST ADBRUNSV ADBTEP2R ADB2CUST ADB2RCPC
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
RA20 PSY UK91432
UP13/02/08 P F302
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 March 2013