Hitachi

Hitachi Advanced Database Command Reference

9.6 Notes

  1. The adbchgsrvmode command must be executed while the HADB server is running.

  2. When the HADB server is terminated with the adbstop command or terminates abnormally, the previous HADB server operation mode is inherited the next time the HADB server is started. For example, if the HADB server operation mode when the HADB server is terminated is the quiescence mode, the HADB server operation mode will be quiescence the next time the HADB server is started. However, if a different HADB server operation mode is specified in the adbstart command, the HADB server is started in the specified mode.

  3. The following table lists and describes the SQL statements and commands that can be executed while the adbchgsrvmode command is running (while the HADB server operation mode is being changed).

    Table 9‒2: SQL statements and commands that can be executed while the HADB server operation mode is being changed

    No.

    SQL statement or command

    From normal to quiescence

    From quiescence to normal

    From normal to offline

    From offline to normal

    From normal to maintenance

    From maintenance to normal

    Execution on the server machine#1

    Execution from a machine other than the server machine#2

    Execution on the server machine#1

    Execution from a machine other than the server machine#2

    1

    Retrieval SQL statement

    Y#3

    Y

    Y

    N#4

    Y

    N

    N#10

    N

    2

    Update SQL statement

    N#3

    N

    Y

    N#4

    Y

    N

    N#10

    N

    3

    Definition SQL statement

    N#3

    N

    Y

    N#4

    Y

    N

    N#10

    N

    4

    Control SQL statement

    Y#3

    Y

    Y

    N#4

    Y

    N

    N#10

    N

    5

    adbarchivechunk command

    N#5

    N

    Y

    --

    Y

    --

    N#10

    N

    6

    adbaudittrail command

    Y

    Y

    Y

    --

    Y

    --

    Y

    Y

    7

    adbcancel command

    Y

    Y

    Y

    --

    Y

    --

    Y

    Y

    8

    adbchgchunkcomment command

    N#5

    N

    Y

    --

    Y

    --

    N#10

    N

    9

    adbchgchunkstatus command

    N#5

    N

    Y

    --

    Y

    --

    N#10

    N

    10

    adbchgnodetype command

    N

    N

    N

    --

    N

    --

    N

    N

    11

    adbchgsqltrc command

    Y

    Y

    Y

    --

    Y

    --

    Y

    Y

    12

    adbchgsrvmode command#6

    N

    N

    N

    --

    N

    --

    N

    N

    13

    adbclientdefmang command

    Y

    Y

    Y

    --

    Y

    --

    Y

    Y

    14

    adbcolumnize command

    N

    N

    Y

    --

    Y

    --

    Y

    Y

    15

    adbconvertaudittrailfile command

    Y

    Y

    Y

    --

    Y

    --

    Y

    Y

    16

    adbdbstatus command

    Y

    Y

    Y

    --

    Y

    --

    N#10

    N

    17

    adbexport command

    Y

    Y

    Y

    --

    Y

    --

    N#10

    N

    18

    adbgetcst command

    N#5

    N

    Y

    --

    Y

    --

    N#10

    N

    19

    adbidxrebuild command

    N#5

    N

    Y

    --

    Y

    --

    N#10

    N

    20

    adbimport command

    N#5

    N

    Y

    --

    Y

    --

    N#10

    N

    21

    adbinfoget command

    Y

    Y

    Y

    --

    Y

    --

    Y

    Y

    22

    adbinfosweep command#7

    N

    N

    N

    --

    N

    --

    N

    N

    23

    adbinit command#7

    N

    N

    N

    --

    N

    --

    N#10

    N

    24

    adbinstall command#7

    N

    N

    N

    N

    N

    N

    N

    N

    25

    adbls command

    Y

    Y

    Y

    --

    Y

    --

    Y

    Y

    26

    adbmergechunk command

    N#5

    N

    Y

    --

    Y

    --

    N#10

    N

    27

    adbmodarea command

    N#5

    N

    Y

    --

    Y

    --

    Y

    Y

    28

    adbmodbuff command

    Y

    Y

    Y

    --

    Y

    --

    N#10

    N

    29

    adbmonitor command

    Y

    Y

    Y

    --

    Y

    --

    Y

    Y

    30

    adbreorgsystemdata command

    N#5

    N

    Y

    --

    Y

    --

    N#10

    N

    31

    adbsql command#8

    Y

    Y

    Y

    N

    Y

    N

    N#10

    N

    32

    adbstart command#7

    N

    N

    N

    --

    N

    --

    N

    N

    33

    adbstat command

    Y

    Y

    Y

    --

    Y

    --

    Y

    Y

    34

    adbstop command#9

    N

    N

    N

    --

    N

    --

    N

    N

    35

    adbsyndict command

    N#5

    N

    Y

    --

    Y

    --

    N#10

    N

    36

    adbunarchivechunk command

    N#5

    N

    Y

    --

    Y

    --

    N#10

    N
    Legend:

    Y: Can be executed while the HADB server operation mode is being changed.

    N: Cannot be executed while the HADB server operation mode is being changed (an error results).

    --: Not applicable because the command is executed on the server machine on which the HADB server is installed

    #1

    Execution on the server machine means that the SQL statement or command is executed on the server machine on which the HADB server is installed.

    #2

    Execution from a machine other than the server machine means that the SQL statement or command is executed on a machine other than the server machine on which the HADB server is installed.

    #3

    If the HADB server operation mode is changed to quiescence and there is a transaction that has executed an update SQL statement, that transaction is canceled and the connection being used to execute the transaction is closed.

    #4

    If the HADB server operation mode is changed to offline and there is a connection from a machine other than the server machine on which the HADB server is installed, the transaction using that connection is canceled and the connection is closed.

    #5

    If a command is running when the HADB server operation mode is changed to quiescence, that command is canceled.

    #6

    Only one adbchgsrvmode command can be executed at a time.

    #7

    This command cannot be executed while the HADB server is running.

    #8

    For details about the SQL statements that can be executed, see Nos. 1 through 4.

    #9

    The adbchgsrvmode and adbstop commands cannot be executed concurrently.

    #10

    If the operation mode changes to maintenance and there is a connection for commands that cannot be executed in maintenance mode, the transaction using that connection is canceled and the connection is closed.

To Page Top

All Rights Reserved. Copyright (C) 2012, 2020, Hitachi, Ltd.