Before you configure and run a mapping, complete the required prerequisites.
Verify database authorities and privileges
To run a mapping that writes data to a DB2 Loader target table, you need to have the required database authorities and privileges on the DB2 database.
Before you write to the DB2 database, verify that you have the following database authorities and privileges:
•SYSADM authority or DBADM authority to fetch the metadata at design time.
•LOAD authority on the database to load the data at runtime. One of the following database privileges when the load utility is invoked in insert, terminate, or restart operation:
- Insert privilege on the table
- Insert and delete privileges on the table
For more information about these database authorities and privileges, see the IBM DB2 documentation.