Scalable Database Server, HiRDB Version 8 System Operation Guide

[Contents][Index][Back][Next]

3.6 Status changes of system log files

Tables 3-4 to 3-7 list the status changes for system log files while HiRDB is operating.

Remarks
  • The status transitions listed in these tables assume that the relevant events were processed normally.
  • HiRDB manages the status of system log files only while it is operating.
  • The status of system log files displayed by the pdlogls command does not change even if the pdlogunld or pdlogchg command is executed on reserved files. To view the status of the system log files, execute the pdlogopen command then execute the pdlogls command.

    Table 3-4 Status changes of system log files while HiRDB is operating (part 1)

    Event Status of system log files
    Current Standby (unload wait)
    Overwrite enabled Overwrite disabled
    Enable Disable Enable Disable
    C I C I C I C I
    1 2 3 4 5 6 7 8 9
    Swapping occurred when system log file area was full [Figure]9 [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure]
    Error in current file caused file swapping to occur Error occurred during nonduplexing, or error occurred in A and B systems during duplexing [Figure]25 [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure]
    Error occurred in one system during duplexing Single system can operate [Figure]9 [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure]
    Single system cannot operate [Figure]25 [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure]
    pdlogswap command was executed [Figure]9 [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure]
    Validation of synchronization point dump [Figure] [Figure] [Figure] [Figure] [Figure] [Figure]2 [Figure]3 [Figure]4 [Figure]5
    Unloading by the automatic log unloading facility was completed [Figure] [Figure]10 [Figure]11 [Figure]12 [Figure]13 [Figure]14 [Figure]15 [Figure]16 [Figure]17
    All data extraction by HiRDB Datareplicator was completed [Figure] [Figure] [Figure]2 [Figure] [Figure]4 [Figure] [Figure]6 [Figure] [Figure]8
    Reading of all data in system log files by update processing of updatable online reorganization was completed (pd_log_org_reflected_logpoint=release is specified) [Figure] [Figure] [Figure] [Figure]2 [Figure]3 [Figure] [Figure] [Figure]6 [Figure]7
    Update processing of updatable online reorganization was completed [Figure] [Figure] [Figure] [Figure]2 [Figure]3 [Figure] [Figure] [Figure]6 [Figure]7
    Overwriting denied status for online reorganization was released by full detection of a system log file (pd_log_org_no_standby_file_opr=continue is specified) [Figure] [Figure] [Figure] [Figure]2 [Figure]3 [Figure] [Figure] [Figure]6 [Figure]7
    pdlogunld command was executed [Figure] [Figure]10 [Figure]11 [Figure]12 [Figure]13 [Figure]14 [Figure]15 [Figure]16 [Figure]17
    pdlogchg command was executed [Figure] [Figure]10 [Figure]11 [Figure]12 [Figure]13 [Figure]14 [Figure]15 [Figure]16 [Figure]17
    pdlogchg -R was executed [Figure] [Figure] [Figure]2 [Figure] [Figure]4 [Figure] [Figure]6 [Figure] [Figure]8
    pdlogchg -G was executed [Figure] [Figure] [Figure] [Figure]2 [Figure]3 [Figure] [Figure] [Figure]6 [Figure]7
    pdlogopen command was executed* [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure]
    pdlogcls command was executed* [Figure] [Figure]18 [Figure]19 [Figure]20 [Figure]21 [Figure]22 [Figure]23 [Figure]24 [Figure]25

Legend:
Enable: Overwriting permitted status for online reorganization
Disable: Overwriting denied status for online reorganization
C: Extraction complete
I: Extraction incomplete
[Figure]: Does not apply, or status does not change.
[Figure]n: Status to which system log file changes after occurrence of the event.
For example, [Figure]1 indicates that after the event occurs, the status of the system log file changes to current (status No. 1).

Note: See Tables 3-5 to 3-7 for system log file status Nos. 10 and higher.

* Applies when the -a or -b option is not specified.

Table 3-5 Status changes of system log files while HiRDB is operating (part 2)

Event Status of system log files
Standby (unload wait)
Overwrite enabled Overwrite disabled
Enable Disable Enable Disable
C I C I C I C I
10 11 12 13 14 15 16 17
Swapping occurred when system log file area was full [Figure]1 [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure]
Error in current file caused file swapping to occur Error occurred during nonduplexing, or error occurred in A and B systems during duplexing [Figure]1 [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure]
Error occurred in one system during duplexing Single system can operate [Figure]1 [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure]
Single system cannot operate [Figure]1 [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure]
pdlogswap command was executed [Figure]1 [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure]
Validation of synchronization point dump [Figure] [Figure] [Figure] [Figure] [Figure]10 [Figure]11 [Figure]12 [Figure]13
Unloading by the automatic log unloading facility was completed [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure]
All data extraction by HiRDB Datareplicator was completed [Figure] [Figure]10 [Figure] [Figure]12 [Figure] [Figure]14 [Figure] [Figure]16
Reading of all data in system log files by update processing of updatable online reorganization was completed (pd_log_org_reflected_logpoint=release is specified) [Figure] [Figure] [Figure]10 [Figure]11 [Figure] [Figure] [Figure]14 [Figure]15
Update processing of updatable online reorganization was completed [Figure] [Figure] [Figure]10 [Figure]11 [Figure] [Figure] [Figure]14 [Figure]15
Overwriting denied status for online reorganization was released by full detection of a system log file (pd_log_org_no_standby_file_opr=continue is specified) [Figure] [Figure] [Figure]10 [Figure]11 [Figure] [Figure] [Figure]14 [Figure]15
pdlogunld command was executed [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure]
pdlogchg command was executed [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure]
pdlogchg -R was executed [Figure] [Figure]10 [Figure] [Figure]12 [Figure] [Figure]14 [Figure] [Figure]16
pdlogchg -G was executed [Figure] [Figure] [Figure]10 [Figure]11 [Figure] [Figure] [Figure]14 [Figure]15
pdlogopen command was executed* [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure]
pdlogcls command was executed* [Figure]26 [Figure]27 [Figure]28 [Figure]29 [Figure]30 [Figure]31 [Figure]32 [Figure]33

Legend:
Enable: Overwriting permitted status for online reorganization
Disable: Overwriting denied status for online reorganization
C: Extraction complete
I: Extraction incomplete
[Figure]: Does not apply, or status does not change.
[Figure]n: Status to which system log file changes after occurrence of the event.
For example, [Figure]1 indicates that after the event occurs, the status of the system log file changes to current (status No. 1).

Note: See Table 3-4 for system log file status Nos. 1-9 and Tables 3-6 and 3-7 for system log file status Nos. 18 and higher.

* Applies when the -a or -b option is not specified.

Table 3-6 Status changes of system log files while HiRDB is operating (part 3)

Event Status of system log files
Reserved and unload wait state
Overwrite enabled Overwrite disabled
Enable Disable Enable Disable
C I C I C I C I
18 19 20 21 22 23 24 25
Swapping occurred when system log file area was full [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure]
Error in current file caused file swapping to occur Error occurred during nonduplexing, or error occurred in A and B systems during duplexing [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure]
Error occurred in one system during duplexing Single system can operate [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure]
Single system cannot operate [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure]
pdlogswap command was executed [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure]
Validation of synchronization point dump [Figure] [Figure] [Figure] [Figure] [Figure]18 [Figure]19 [Figure]20 [Figure]21
Unloading by the automatic log unloading facility was completed [Figure]26 [Figure]27 [Figure]28 [Figure]29 [Figure]30 [Figure]31 [Figure]32 [Figure]33
All data extraction by HiRDB Datareplicator was completed [Figure] [Figure]18 [Figure] [Figure]20 [Figure] [Figure]22 [Figure] [Figure]24
Reading of all data in system log files by update processing of updatable online reorganization was completed (pd_log_org_reflected_logpoint=release is specified) [Figure] [Figure] [Figure]18 [Figure]19 [Figure] [Figure] [Figure]22 [Figure]23
Update processing of updatable online reorganization was completed [Figure] [Figure] [Figure]18 [Figure]19 [Figure] [Figure] [Figure]22 [Figure]23
Overwriting denied status for online reorganization was released by full detection of a system log file (pd_log_org_no_standby_file_opr=continue is specified) [Figure] [Figure] [Figure]18 [Figure]19 [Figure] [Figure] [Figure]22 [Figure]23
pdlogunld command was executed [Figure]26 [Figure]27 [Figure]28 [Figure]29 [Figure]30 [Figure]31 [Figure]32 [Figure]33
pdlogchg command was executed [Figure]26 [Figure]27 [Figure]28 [Figure]29 [Figure]30 [Figure]31 [Figure]32 [Figure]33
pdlogchg -R was executed [Figure] [Figure]18 [Figure] [Figure]20 [Figure] [Figure]22 [Figure] [Figure]24
pdlogchg -G was executed [Figure] [Figure] [Figure]18 [Figure]19 [Figure] [Figure] [Figure]22 [Figure]23
pdlogopen command was executed* [Figure]2 [Figure]3 [Figure]4 [Figure]5 [Figure]6 [Figure]7 [Figure]8 [Figure]9
pdlogcls command was executed* [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure]

Legend:
Enable: Overwriting permitted status for online reorganization
Disable: Overwriting denied status for online reorganization
C: Extraction complete
I: Extraction incomplete
[Figure]: Does not apply, or status does not change.
[Figure]n: Status to which system log file changes after occurrence of the event.
For example, [Figure]1 indicates that after the event occurs, the status of the system log file changes to current (status No. 1).

Note: See Tables 3-4 and 3-5 for system log file status Nos. 1-17 and Table 3-7 for system log file status Nos. 26 and higher.

* Applies when the -a or -b option is not specified.

Table 3-7 Status changes of system log files while HiRDB is operating (part 4)

Event Status of system log files
Reserved and unload wait state
Overwrite enabled Overwrite disabled
Enable Disable Enable Disable
C I C I C I C I
26 27 28 29 30 31 32 33
Swapping occurred when system log file area was full [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure]
Error in current file caused file swapping to occur Error occurred during nonduplexing, or error occurred in A and B systems during duplexing [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure]
Error occurred in one system during duplexing Single system can operate [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure]
Single system cannot operate [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure]
pdlogswap command was executed [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure]
Validation of synchronization point dump [Figure] [Figure] [Figure] [Figure] [Figure]26 [Figure]27 [Figure]28 [Figure]29
Unloading by the automatic log unloading facility was completed [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure]
All data extraction by HiRDB Datareplicator was completed [Figure] [Figure]26 [Figure] [Figure]28 [Figure] [Figure]30 [Figure] [Figure]32
Reading of all data in system log files by update processing of updatable online reorganization was completed (pd_log_org_reflected_logpoint=release is specified) [Figure] [Figure] [Figure]26 [Figure]27 [Figure] [Figure] [Figure]30 [Figure]31
Update processing of updatable online reorganization was completed [Figure] [Figure] [Figure]26 [Figure]27 [Figure] [Figure] [Figure]30 [Figure]31
Overwriting denied status for online reorganization was released by full detection of a system log file (pd_log_org_no_standby_file_opr=continue is specified) [Figure] [Figure] [Figure]26 [Figure]27 [Figure] [Figure] [Figure]30 [Figure]31
pdlogunld command was executed [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure]
pdlogchg command was executed [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure]
pdlogchg -R was executed [Figure] [Figure]26 [Figure] [Figure]28 [Figure] [Figure]30 [Figure] [Figure]32
pdlogchg -G was executed [Figure] [Figure] [Figure]26 [Figure]27 [Figure] [Figure] [Figure]30 [Figure]31
pdlogopen command was executed* [Figure]10 [Figure]11 [Figure]12 [Figure]13 [Figure]14 [Figure]15 [Figure]16 [Figure]17
pdlogcls command was executed* [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure]

Legend:
Enable: Overwriting permitted status for online reorganization
Disable: Overwriting denied status for online reorganization
C: Extraction complete
I: Extraction incomplete
[Figure]: Does not apply, or status does not change.
[Figure]n: Status to which system log file changes after occurrence of the event.
For example, [Figure]1 indicates that after the event occurs, the status of the system log file changes to current (status No. 1).

Note: See Tables 3-4 to 3-6 for system log file status Nos. 1-25.

* Applies when the -a or -b option is not specified.

[Contents][Back][Next]

[Trademarks]

All Rights Reserved. Copyright (C) 2007, Hitachi, Ltd.