DB2 bulk Load

[mcs_suman]

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

[kwwilliams]

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

[DSguru2B]

That rows you see transfered just indicates that you were successful in building the load file.

[mcs_suman]

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

[ArndW]

Suman - the link that kwwiliiams put in his post documents that you need more than just INSERT privileges in order to do a load.