Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2004
    Posts
    4

    Unanswered: need help in DSNUTILB

    I'm trying to load a table using DSNUTILB.

    Its giving the following error

    "USER xxxxxxx NOT AUTHORIZED FOR LOAD UTILITY ON DATABASE yyyyyyy "

    I never had a problem before. Suddenly i'm getting this problem.
    How can i get my id authorized to load data into the database.

    TIA,
    Prathi

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    GRANT LOAD ON DATABASE xxxxxxxx TO authorization-name;

    This must be done by someone who is authorized to grant you access.

    Alternatively, you can be granted DBADM or other adminstrative authority that includes LOAD authority.
    Last edited by Marcus_A; 11-24-04 at 12:31.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Nov 2004
    Posts
    4
    Thx a lot Marcus

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •