DB2 Express-C (can not issue load statement)

jaimie85 · #1 (**permalink**) 10-26-09, 04:41

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".
SQLSTATE=42502

I urgently need help in sorting out this problem to finish my study. Thanks

azs0309 · #2 (**permalink**) 10-26-09, 07:36

try to give yourself load authority.

jaimie85 · #3 (**permalink**) 10-26-09, 09:07

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.

Cougar8000 · #4 (**permalink**) 10-26-09, 14:15

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.

Internet Services

Web Development

Digital Marketing

Consumer Tech