Data Movement Utilities Guide and Reference

Privileges, Authorities, and Authorization Required to Use Load

Privileges enable users to create or access database resources. Authority levels provide a method of grouping privileges and higher-level database manager maintenance and utility operations. Together, these act to control access to the database manager and its database objects. Users can access only those objects for which they have the appropriate authorization; that is, the required privilege or authority.

To load data into a table, you must have one of the following:

• SYSADM authority
• DBADM authority
• LOAD authority on the database and
  • INSERT privilege on the table when the load utility is invoked in INSERT mode, TERMINATE mode (to terminate a previous load insert operation), or RESTART mode (to restart a previous load insert operation)
  • INSERT and DELETE privilege on the table when the load utility is invoked in REPLACE mode, TERMINATE mode (to terminate a previous load replace operation), or RESTART mode (to restart a previous load replace operation)
  • INSERT privilege on the exception table, if such a table is used as part of the load operation.

Since all load processes (and all DB2 server processes, in general), are owned by the instance owner, and all of these processes use the identification of the instance owner to access needed files, the instance owner must have read access to input data files. These input data files must be readable by the instance owner, regardless of who invokes the command.

If DB2 for Windows NT has been defined as a Service to the Windows NT operating system, the Service must have a user account with the required read/write file permissions to use LAN resources (drives, directories, and files).