A fix is available
APAR status
Closed as program error.
Error description
The DB2 Administration Tool for z/OS' ADB2GEN function used by the DB2 Object Comparison Tool for z/OS issues a message: "Object definitions extracted from <ssid> (DB2 version nnnn)." based on the values in the first found DSNDECP rather than from the subsystem it is being executed upon which can result in the DB2 subsystem and/or the version information being incorrect ( non-existent subsystem id or the version being shown at the local subsystem level rather than the remote subsystem level.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Administration Tool for * * z/OS who use Generate (GEN) to generate * * the object DDL on the local DB2 subsystem * * when the SSID value in DSNHDECP is * * different than the DB2 subsystem name. * * * * Users of the DB2 Object Comparison Tool * * for z/OS who select the source or * * target from the DB2 catalog on a * * remote DB2 subsystem and the remote * * DB2 subsystem's DB2 version is * * different than the local DB2 * * subsystem's DB2 version. * **************************************************************** * PROBLEM DESCRIPTION: 1- The DB2 Administration Tool for * * z/OS' ADB2GEN program displays an * * invalid DB2 subsystem name in the * * error message when the local DB2 * * subsystem name is different than * * the SSID value in DSNHDECP. * * * * For example, when performing GEN * * on local DB2 subsystem ABC and * * the DB2 version is 1015, and the * * SSID value in DSNHDECP is XXX, * * the following message is * * observed: * * * * 'Object definitions extracted * * from XXX (DB2 version 1015).' * * * * The message uses the SSID value * * in the DSNHDECP, but this SSID * * is not the DB2 subsystem name * * that it is being executed upon. * * * * 2- In the DB2 Object Comparison * * Tool for z/OS, when selecting * * the source or target from the DB2 * * catalog on a remote DB2 subsystem * * and the remote DB2 subsystem's * * DB2 version is different than the * * local DB2 subsystem's DB2 version, * * GEN reports an invalid DB2 version. * * * * For example, if the local DB2 * * subsystem version is 1015, and the * * remote DB2 subsystem is YYY and its * * DB2 version is 915, GEN issues the * * following message: * * * * 'Object definitions extracted from * * YYY 915 (DB2 version 1015)' * * * * The correct DB2 version 915 should be * * reported in the DB2 version. * **************************************************************** * RECOMMENDATION: * **************************************************************** 1- The DB2 Administration Tool for z/OS' ADB2GEN program displays an invalid DB2 subsystem name in the error message when the local DB2 subsystem name is different than the SSID value in DSNHDECP. For example, when performing GEN on local DB2 subsystem ABC and the DB2 version is 1015, and the SSID value in DSNHDECP is XXX, the following message is observed: 'Object definitions extracted from XXX (DB2 version 1015).' The message uses the SSID value in the DSNHDECP, but this SSID is not the DB2 subsystem name that it is being executed upon. 2- In the DB2 Object Comparison Tool for z/OS , when selecting the source or target from the DB2 catalog on a remote DB2 subsystem and the remote DB2 subsystem's DB2 version is different than the local DB2 subsystem's DB2 version, GEN reports an invalid DB2 version. For example, if the local DB2 subsystem version is 1015, and the remote DB2 subsystem is YYY and its DB2 version is 915, GEN issues the following message: 'Object definitions extracted from YYY 915 (DB2 version 1015)' The correct DB2 version 915 should be reported in the DB2 version.
Problem conclusion
Problems have been resolved. 1- When performing GEN on the local DB2 subsystem ABC and DB2 version is 1015, and the SSID value in DSNHDECP is XXX, the following message will be displayed: 'Object definitions extracted from ABC (DB2 version 1015).' The correct SSID displayed is the DB2 subsystem name that it is being executed upon, not the DSNHDECP value. 2- If the local DB2 subsystem version is 1015, and the remote DB2 subsystem is ZZZ and the DB2 version is 915, GEN will now issue the following message: 'Object definitions extracted from ZZZ 915 (DB2 version 915)'. The correct DB2 version 915 will now be reported.
Temporary fix
Comments
APAR Information
APAR number
PI21783
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
A20
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2014-07-10
Closed date
2014-11-26
Last modified date
2015-01-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI23458 UI23459
Modules/Macros
ADB2RE ADB2REE
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.
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.2.0"}]
Document Information
Modified date:
31 March 2021