Unable to load dataset using IBM DB2 LOAD tool

0
votes

Error for batch element #1: "WQX79824" does not have the privilege to perform operation "IMPLICIT CREATE SCHEMA".. SQLCODE=-552, SQLSTATE=42502, DRIVER=4.26.14 Number of occurrences: 1

1
sqldb2load
Depending on what the LOAD command does, you need to have the right privileges. Without more context, there is no help - data_henrik
It's not a Db2 load utility problem. load does not create any tables itself. - Mark Barinstein

1 Answers

0
votes

This is not a programming issue, instead it is a configuration issue.

Either ask your DBA to grant the relevant authority and permissions to the authID you use (WQX79824) to connect to the database, or alternately connect to the database with a different authID which already has the required permissions and authorities to create objects and do loads etc.