This example loads two data load waiting files (file names pdaudUNT1001.aud and pdaudUNT1002.aud) into the audit trail table (table name SQL_AUDIT_TRAIL). The following is the specification of the pdload command for this example:
Example pdload command specification
pdload -b -W SQL_AUDIT_TRAIL /pdload/control_file |
- Explanation
- The -b and -W options must be specified.
- Specify the audit trail table for the table name.
- The following explains the contents of the control information file:
Example of specifying the control information file
source bes1:(uoc)
srcuoc param='dir=/secarea,file=(pdaudUNT1001.aud,pdaudUNT1002.aud)' |
- Explanation
- source bes1:(uoc): Specifies the server name (bes1) for the HiRDB/Parallel Server. You can specify a server name in the unit where the audit trail files are located. You may specify any server name in the unit, but if you specify a back-end server, you can eliminate a communication bottleneck.
- dir: Specifies the HiRDB file system area that stores the audit trail files to be data loaded.
- file: Specifies the names of the audit trail files to be data loaded.
- If indexes have been defined for the audit trail table, use the idxwork statement and the sort statement.