DSNU326I csect-name - USER NOT AUTHORIZED FOR LOAD REPLACE ON TABLESPACE

Explanation

The user attempted to use the REPLACE option of LOAD, and it will reset to empty all tables in the table space before loading data. This option requires load authorization on each table in the table space, but the user did not have authority for one or more tables. In addition, if a table in the table space has a security label column, the user must have the write-down privilege when write-down is in effect.

System action

When LOAD REPLACE validation encounters the first non-authorized table in the table space, the job step is terminated.

User response

Obtaining the LOAD on DATABASE privilege for the database will allow you to proceed using the REPLACE option. If the table space is an implicit database, then obtain the appropriate authorization privileges on the implicit database or DSNDB04. If a table in the table space has a security label column, ensure that the user has write-down privilege when write-down is in effect before using the REPLACE option. The other alternative is to first delete all rows from the tables which are to be loaded, and then use the RESUME option instead of the REPLACE option.

Severity

12 (severe error)