PI61333: DB2 ADMIN TOOL MISSING EXECUTE ACCELERATOR SP GRANTS CAUSES SQLCODE=-525 (SQLCODEN525)

Obtain the fix for this APAR.

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 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

• RB10 PSY UI38330

     UP16/06/03 P F606

• RB20 PSY UI38331

     UP16/06/03 P F606

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.