Getting an error while using DB2 Bulk stage as target

[sirisha]

We are facing issues while using DB2 bulk stage as target stage . ERROR occurred : loading table, SQLCODE -3015
SQL3015N An SQL error "-551" occurred during processing.We are facing the above errors .Please help me in solving in this issue , if any one has faced this before .Anpther thing is Job ran fine when we have used DB2 API stage as target , as we have huge data to process so we need to go wid bulk stage .

[ArndW]

If you check the DB2 documentation, the -551 means that the caller does not have privileges to perform the given action. I am not sure of what GRANTs are required for a load vs. an insert but guess that it has to do with dropping and re-recreating indices. Talk to your DBA to get this resolved.

[MT]

Hi

as Arnd already stated this is a security issue.

You can easily check DB2 error message by searching it in goolge or from the DB2 command line with db2 ? <errorcode> like db2 ? SQL0551.

There is a separte database priviledge for load in DB2.
You have to be granted the load right before you use it (grant load on database....)

See also following link for an overview of necessary rights:

https://publib.boulder.ibm.com/infocent ... 05522.html

regards
Michael

[sirisha]

Thanks Michael .We approached our DBA and it worked .

[MT]

Thanks Michael .We approached our DBA and it worked .

Hi

you are welcome!
Could you please mark the topic resolved

Thanks

Rregards
Michael