Data Protection Software

 View Only
Expand all | Collapse all

KSY agent failing due to insufficient privilege

  • 1.  KSY agent failing due to insufficient privilege

    Posted Mon June 14, 2021 08:21 AM

    KSY agent is failing due to the error below:

    == 61 t=Thread-1 SQL IN ERROR : statement name : TD.Ins1 SQL : CALL IBM_TRAM.CREATE_TIME_DIMENSION(?, ?, ?) template SQL : == 62 t=Thread-1 SQLException occured. SQL State = 42501 , SQL Error Code = -551 == 63 t=Thread-1 com.ibm.db2.jcc.am.SqlSyntaxErrorException: The statement failed because the authorization ID does not have the required authorization or privilege to perform the operation. Authorization ID: "ITMADMIN". Operation: "EXECUTE". Object: "IBM_TRAM.CREATE_TIME_DIMENSION".. SQLCODE=-551, SQLSTATE=42501, DRIVER=4.19.77



    #Support
    #SupportMigration
    #Tivoli


  • 2.  RE: KSY agent failing due to insufficient privilege

    Posted Mon June 14, 2021 08:24 AM

    The issue is due to TRAM table permissions.

    We suspect that the WAREHOUS has been in use for a long time, and therefore the reasonable change would be for the customer to correct their TRAM table permissions.

    So the customer needs to execute the following commands :

    =======

    Connect to Warehouse database using user DB2ADMIN -

    db2 connect to (database name) user DB2ADMIN using (password)

    AND then

    db2 "GRANT ALTERIN, CREATEIN, DROPIN ON SCHEMA IBM_TRAM TO USER ITMADMIN"

    ===========

    Then restart the SY agent to resolve the issue.



    #Support
    #SupportMigration
    #Tivoli