Db2 Tools

 View Only
  • 1.  How to give access on FAST LOAD to particular user

    Posted Aug 20, 2018 11:08 AM

    Post r19 upgrade, Few fast load jobs were failing with PFL0099E - User lacks the required LOAD authority.

    Kindly suggest how to give only LOAD Auth to that user.

     

    Regards,

    Ajay Sharma



  • 2.  Re: How to give access on FAST LOAD to particular user
    Best Answer

    Broadcom Employee
    Posted Aug 21, 2018 10:08 AM

    Hi Ajay,

     

    We see that you opened a case with Support regarding this question and received the answer.

     

    The CA Fast Load for DB2 for z/OS plans must be bound and the user
    must have EXECUTE authority on the plans.

     

    User must have one of the following DB2 authorizations: 
    - SYSADM or SYSCTRL authority
    - DBADM or DBCTRL authority for the database containing the table to be indexed
    - LOAD authority for the database containing the tablespace to be loaded

     

    Regards,

    Matt Krumholz