A fix is available
APAR status
Closed as program error.
Error description
DB2 Admin Tool CM batch job failed w/ SQLCODE = -525 (SQLCODEN525) DSNT408I SQLCODE = -525, ERROR: THE SQL STATEMENT CANNOT BE EXECUTED BECAUSE IT WAS IN ERROR AT BIND TIME FOR SECTION = 40 PACKAGE = DGT3LOC.ADBL.ADB0 CONSISTENCY TOKEN =X'19E5FD21177F7918' DSNT418I SQLSTATE = 51015 SQLSTATE RETURN CODE ADB5258E Table(s) cannot be recreated on the accelerator. Sqlcode = -525 ADB5185E The run is ending due to errors. Missing execute auth on accelerator stored procedures.
Local fix
Do grants manually.
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Administration Tool for * * z/OS who use IBM Tools Customizer for * * z/OS. * **************************************************************** * PROBLEM DESCRIPTION: DB2 Admin Tool CM batch job failed * * with SQLCODE = -525 / SQLCODEN525 * * because the required authorization * * on the procedures and tables that are * * necessary for using IBM DB2 Analytics * * Accelerator (IDAA) were missing. * **************************************************************** * RECOMMENDATION: * **************************************************************** DB2 Admin Tool CM batch job failed with a SQLCODE = -525 / SQLCODEN525 because the required authorization on the procedures and tables that are necessary for using IBM DB2 Analytics Accelerator (IDAA) were missing: DSNT408I SQLCODE = -525, ERROR: THE SQL STATEMENT CANNOT BE EXECUTED BECAUSE IT WAS IN ERROR AT BIND TIME FOR SECTION = 40 PACKAGE = >location<.ADBL.ADB0 CONSISTENCY TOKEN = >token_name< DSNT418I SQLSTATE = 51015 SQLSTATE RETURN CODE ADB5258E Table(s) cannot be recreated on the accelerator. Sqlcode = -525 ADB5185E The run is ending due to errors.
Problem conclusion
The problem has been fixed. The following three new fields are added on the panel CCQPPRD 'Product Parameters' to support grants for IDAA related objects like procedures and tables: *IDAA . . . . . . . . . . . . . . . .YES (YES, NO) GRANT EXECUTE ON PROCEDURE TO . . . PUBLIC GRANT SELECT ON TABLE TO . . . . . .PUBLIC
Temporary fix
Comments
APAR Information
APAR number
PI61333
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
B20
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-04-25
Closed date
2016-06-01
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:
UI38330 UI38331
Modules/Macros
ADB$$PRM ADBCUST ADBSETUP ADB2CUST
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.2.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
04 July 2016