A fix is available
APAR status
Closed as program error.
Error description
The DB2 Administration Tool for z/OS' Store Procedure ADB2RE fails when in the SQL_DSNAME specifies a PDS member name that is 8 character long. Example parameters passed: SQL_OUTFLAG="PS",SQL_DSNAME="XXXXXX.XXXX.XXX(XXXXXXXX)"; In addition: The SQL_MEMBER option does not work.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Administration Tool * * for z/OS who call Reverse Engineering * * stored procedure ADB2RE 'Revoke * * Distinct Type Privileges'. * **************************************************************** * PROBLEM DESCRIPTION: When calling Reverse Engineering * * stored procedure ADB2RE, the * * following issues are observed: * * * * 1. When SQL_DSNAME or RPT_DSNAME * * specifies a PDS with a member name * * of 8 characters, DB2 Admin fails * * with return code 8 / RC=8. * * * * 2. When SQL_MEMBER or RPT_MEMBER is * * specified, ADB2RE fails with return * * code 8 / RC=8. * **************************************************************** * RECOMMENDATION: * **************************************************************** When calling Reverse Engineering stored procedure ADB2RE, the following issues are observed: 1. When SQL_DSNAME or RPT_DSNAME specifies a PDS with a member name of 8 characters, ADB2RE fails with RC=8. For example, SQL_DSNAME="ABC.DEF.GHI(TEST0001)" 2. When SQL_MEMBER or RPT_MEMBER is specified, ADB2RE fails with RC=8. For example, SQL_DSNAME="ABC.DEF.GHI",SQL_MEMBER='TEST01'
Problem conclusion
Problems have been resolved.
Temporary fix
Comments
APAR Information
APAR number
PI56821
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
B10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-02-08
Closed date
2016-06-17
Last modified date
2016-07-04
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI38780 UI38781
Modules/Macros
ADB2CDC ADB2DEP ADB2RE ADB2REE ADB2REG ADB2REH ADB2REM ADB2REP ADB2RER ADB2RES ADB2RET ADB2REU ADB2REY ADB2RS
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":"11.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
04 July 2016