Db2 Tools

 View Only
Expand all | Collapse all

CA Fast Recover need access to SYSLGRNX table

Jump to Best Answer
  • 1.  CA Fast Recover need access to SYSLGRNX table

    Posted Feb 27, 2018 09:53 AM

    We migrated from DB2 V11 CM to DB2 V11 NFM. Now job are failing with -551

    xxxxxxx DOES NOT HAVE THE PRIVILEGE TO

             PERFORM OPERATION SELECT ON OBJECT SYSIBM.SYSLGRNX

    Anyone else had this issue?



  • 2.  Re: CA Fast Recover need access to SYSLGRNX table
    Best Answer

    Posted Feb 27, 2018 11:02 AM

    Hello, 

     

    in order to obtain information on log ranges CA Fast Recover (USERID executing CA Fast Recover) needs READ/SELECT authority on the SYSIBM.SYSLGRNX directory table. 

    Please, review the webpage to find out more about the authorization needed. 

     

    Thank you for your question! 

    Jacek Rafalak

    Product Owner