2.3 pdaudatld (Control the facility for automatically loading audit trail table data)

Organization of this section
(1) Function
(2) Executor
(3) Format
(4) Options
(5) Rules
(6) Notes
(7) Output format

(1) Function

Controls the facility for automatically loading audit trail table data. The following control is available:

(2) Executor

HiRDB administrator and auditor

When the HiRDB administrator executes the command, a message requesting entry of a password is displayed. The auditor must then enter an authorization identifier and password.

(3) Format

pdaudatld [-U authorization-identifier] [-b|-t|-i]

(4) Options

(a) -U authorization-identifier

Specifies the auditor's authorization identifier. When this option is specified, a message requesting entry of the auditor's password is displayed.

Rules
  1. The command uses the authorization identifier specified in this option and the password that is entered to establish connection to HiRDB. It also checks if this authorization identifier has the audit privilege.
  2. You can specify this option only when you execute the pdaudatld command in an environment in which it is possible to enter responses to response-request messages.
  3. If you omit this option, you must have specified the PDUSER environment variable in advance. When this option is omitted, the pdaudatld command assumes the value that is set in the PDUSER environment variable at the time the command executes. If this option is omitted and the PDUSER environment variable has not been set, the pdaudatld command will not execute. The following shows an example:
    Example: C shell
    setenv PDUSER '"authorization-identifier"/"password"'
(b) -b

Specifies that the facility for automatically loading audit trail table data is to be restarted. The command loads data sequentially from the audit trail files that are in data loading wait status.

(c) -t

Specifies that the facility for automatically loading audit trail table data is to be terminated. Once you execute the pdaudatld command with this option specified, audit trail table data will no longer be loaded automatically even when audit trail file generations are swapped.

If audit trail table data is being loaded at the time the pdaudatld command is executed with this option specified, the command waits until that data loading session is completed and then terminates the automatic data loading facility. For details, see the HiRDB Version 9 System Operation Guide.

(d) -i

Specifies that the operating status of the facility for automatically loading audit trail table data is to be displayed, including display of a list of units that contain audit trail files subject to automatic data loading.

(5) Rules

  1. The pdaudatld command can be executed only while HiRDB is active. You cannot use this command when HiRDB was started by the pdstart -r command.
  2. The pdaudatld command must be executed at the server machine that contains the single server or where the system manager is located.
  3. The pdaudatld command results in a command error if the pd_aud_file_name operand was not specified in the system definition or a value other than Y was specified in the pd_aud_auto_loading operand.
  4. A command error results if you execute the pdaudbegin, pdaudend, pdaudrm, pdaudswap, pdaudatld -b, or pdaudatld -t command while the pdaudatld -b or pdaudatld -t command is executing.
  5. If you omit all options, the pdaudatld command assumes that the -i option is specified.

(6) Notes

  1. The following are the pdaudatld command's return codes:
    0: Normal termination
    4: Warning termination
    The pdaudatld -t command has terminated the automatic data loading facility under the assumption that automatic data loading was completed because an automatic data loading error occurred while the command was waiting for completion of automatic data loading processing.
    8: Abnormal termination

(7) Output format

Hostname : aa....aa (bb....bb)
Auto-Loading-Service-Status : cc....cc
unit  Status    Dataload-Request-Time  Count  Dataload-Start-Time
dddd  ee....ee  ffff/gg/hh ii:jj:kk      lll  mmmm/nn/oo pp:qq:rr
dddd  ee....ee  ffff/gg/hh ii:jj:kk      lll
  :                :           :         :
dddd  ee....ee  ffff/gg/hh ii:jj:kk      lll

Explanation
aa....aa:
Primary host name on the unit where the pdaudatld command was executed (32 characters)
bb....bb:
Command execution time (format: 4-digit-year/month/date hour:minute:second)
cc....cc:
Operating status of the facility for automatically loading audit trail table data (up to 16 characters):
ENABLE: Enabled
DISABLE (WAIT): Terminating
DISABLE: Stopped
dddd:
Unit identifier of a unit that contains audit trail files subject to automatic data loading (4 characters)
ee....ee:
Status of data loading by the facility for automatically loading audit trail table data:
loading: Automatic data loading is underway
standby: Waiting to load data
skip: Automatic data loading was skipped because the unit was not active
ffff/gg/hh ii:jj:kk:
Time of automatic data loading (format: 4-digit-year/month/date hour:minute:second)
lll:
Number of times an automatic data loading request was received (3 characters)
This value is 1 when automatic data loading has just been enabled. Each time an automatic data loading request is received from the same unit while ee....ee is standby or skip, the value is incremented by 1. When the unit where the system manager is located is terminated and then restarted, the value is reset to 1.
mmmm/nn/oo pp:qq:rr:
Time data loading was started by the automatic data loading facility (format: 4-digit-year/month/date hour:minute:second)
This information is displayed only when loading is displayed in ee....ee.
Note:
  • If there are no audit trail files subject to automatic data loading, only the first line is displayed.
  • The information from dddd through mmmm/nn/oo pp:qq:rr is displayed for each unit that is performing automatic data loading or is waiting to load data. When multiple lines are displayed, execution of automatic data loading is in the order displayed. Once automatic data loading is finished for a unit, these items are no longer displayed for that unit.
  • If a new swapping of audit trail files occurs at a unit that is waiting to load data, all data is loaded into the audit trail table when automatic data loading occurs.
  • If a new swapping of audit trail files occurs at a unit that is currently loading data, two lines might be displayed for that unit, one for loading and one for standby. If the KFPS05716-W message is displayed in such a case and the current data loading is retried, only one line will be displayed. Similarly, if the KFPS05713-E message is displayed in such a case and automatic data loading is terminated, only one line will be displayed. For the number of automatic data loading requests received (lll), the sum of the values on the two lines is displayed. The following shows an example.
    Example:
    Two lines, one for loading and one for standby, are displayed:

    unit  Status    Dataload-Request-Time  Count  Dataload-Start-Time
    unt1  loading   2007/03/01 12:34:56        2  2007/03/01 12:35:01
    unt1  standby   2007/03/01 12:38:02        1

    If the KFPS05716-W message is displayed and the current data loading is retried, one line is displayed, as shown below:

    unit  Status    Dataload-Request-Time  Count  Dataload-Start-Time
    unt1  standby   2007/03/01 12:34:56        3