Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2009

    Unanswered: DB2 Express-C (can not issue load statement)

    Hi, I really arrpreciate if someone can help me
    I installed DB2 Express-C (OS is windows vista) and connect to sample
    database. I can issue create table statement without any problem but can not issue load statement. I got the following error message:

    SQL0552N "DB2ADMIN" does not have the privilege to perform operation "LOAD".

    I urgently need help in sorting out this problem to finish my study. Thanks
    Last edited by jaimie85; 10-26-09 at 04:45.

  2. #2
    Join Date
    Jan 2008
    try to give yourself load authority.

  3. #3
    Join Date
    Oct 2009


    i am looking at db2 information center how to give myself load authority but still can not figure out. Since i am using db2 with my personal PC, i am quite confused with this system administrator stuff. Would you mind showing me a bit more details how to give necessary authority? I think I need The SYSADM authority to myself.

  4. #4
    Join Date
    Nov 2005
    DB2 Database for Linux, UNIX, and Windows

    in the search type "grant load" you should be able to follow. While at it down load some manuals.
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os

Posting Permissions

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