A fix is available
APAR status
Closed as program error.
Error description
This APAR addresses the following issues: 1. For Version 11, Release 1, Version 11, Release 2, and Version 12, Release 1: When the product libraries are pre-allocated via a logon procedure, and the product is invoked with the LIBDEF(NO) option, the LIBDEFs still occur. 2. For Version 12 Release 1 only: When setting parameter 'Change Management database' to 'NO' and 'Enable CM on DB2 Admin Tool primary menu' to 'YES' during the customization process, the option 'CM' appears on panel ADB2 'DB2 Administration Menu', which will result in SQLCODE = -204 / SQLCODEN204, because the CM objects do not exist: DSNT408I SQLCODE = -204, ERROR: >schema<.ADBCHG IS AN UNDEFINED NAME DSNT418I SQLSTATE = 42704 SQLSTATE RETURN CODE
Local fix
N/A
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 Administration Tool for * * z/OS. * **************************************************************** * PROBLEM DESCRIPTION: For DB2 Administration Tool * * for z/OS, Version 11, Release * * 1, Version 11, Release 2, * * and Version 12, Release 1: * * * * 1 - Option LIBDEF(NO) still * * produces LIBDEFs. * * For DB2 Administration Tool * * for z/OS, Version 12, Release * * 1 ONLY: * * * * 2 - The option 'CM' appears on * * panel ADB2 'DB2 Administration * * Menu' which will result in * * SQLCODE = -204 / SQLCODEN204. * **************************************************************** * RECOMMENDATION: * **************************************************************** 1 - When the product libraries are pre-allocated via a logon procedure and the product is invoked with the LIBDEF(NO) option, the LIBDEFs still occur. 2 - When setting parameter 'Change Management database' to 'NO' and 'Enable CM on DB2 Admin Tool primary menu' to 'YES' during the customization process, the option 'CM' appears on panel ADB2 'DB2 Administration Menu' which will result in SQLCODE = -204 / SQLCODEN204 because the CM objects do not exist: DSNT408I SQLCODE = -204, ERROR: >schema<.ADBCHG IS AN UNDEFINED NAME DSNT418I SQLSTATE = 42704 SQLSTATE RETURN CODE
Problem conclusion
Problems have been resolved. This APAR does not deliver an additional fix, this APAR is a DOC APAR to include the missing ++HOLD information.
Temporary fix
Comments
APAR Information
APAR number
PI88904
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
B20
Status
CLOSED PER
PE
YesPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-10-16
Closed date
2017-10-18
Last modified date
2017-11-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI51238 UI51239 UI51240
Modules/Macros
ADBFBVB
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
RB10 PSY UI51238
UP17/10/20 P F710 Ø
RB20 PSY UI51239
UP17/10/20 P F710 Ø
RC10 PSY UI51240
UP17/10/20 P F710 Ø
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":"11.2.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
01 November 2017