Hi ,
I am using DB2 bulk load stage I am getting following error
1) does not have the privilege to perform operation "LOAD".
2)DB2_UDB_Load_289,0: Input 0 consumed 1744300 records.
In job it show 1744300 records has been passed but no Record is found in Target
The user has Access permission I dont know Why I an getting privilege
Nowhere I have mentioned the insert operation as Load
Does any one has any Idea about it..
Thanks
Suman
DB2 bulk Load
Moderators: chulett, rschirm, roy
DB2 bulk Load
suman
-
- Participant
- Posts: 437
- Joined: Fri Oct 21, 2005 10:00 pm
Re: DB2 bulk Load
Suman,
Talk to your DBA, while you may have insert privileges on the table, your user does not have privileges to load.
See DB2 documentation:
http://publib.boulder.ibm.com/infocente ... 004589.htm
Talk to your DBA, while you may have insert privileges on the table, your user does not have privileges to load.
See DB2 documentation:
http://publib.boulder.ibm.com/infocente ... 004589.htm
Keith Williams
keith@peacefieldinc.com
keith@peacefieldinc.com
Re: DB2 bulk Load
HI kwwilliams,
I have insert Privilege on the table..I am getting those message only when I use DB@ bulk load stage.While using rest of the stage it's fine.
Suman
I have insert Privilege on the table..I am getting those message only when I use DB@ bulk load stage.While using rest of the stage it's fine.
Suman
suman