39.3 SQL statements and commands that can be executed in each HADB server operation mode
The SQL statements and commands that can be executed depend on the HADB server operation mode. The following table lists and explains the SQL statements and commands that can be executed in each HADB server operation mode.
|
No. |
SQL statement or command |
Normal mode |
Quiescence mode |
Offline mode |
Maintenance mode |
|
|---|---|---|---|---|---|---|
|
Execution on the server machine#1 |
Execution from a machine other than the server machine#2 |
|||||
|
1 |
Retrieval SQL statement |
Y |
Y |
Y |
N |
N |
|
2 |
Update SQL statement |
Y |
N |
Y |
N |
N |
|
3 |
Definition SQL statement |
Y |
N |
Y |
N |
N |
|
4 |
Control SQL statement |
Y |
Y |
Y |
N |
N |
|
5 |
adbarchivechunk command |
Y |
N |
Y |
-- |
N |
|
6 |
adbaudittrail command |
Y |
Y |
Y |
-- |
Y |
|
7 |
adbcancel command |
Y |
Y |
Y |
-- |
Y |
|
8 |
adbchgchunkcomment command |
Y |
N |
Y |
-- |
N |
|
9 |
adbchgchunkstatus command |
Y |
N |
Y |
-- |
N |
|
10 |
adbchgnodetype command |
Y |
Y |
Y |
-- |
Y |
|
11 |
adbchgsqltrc command |
Y |
Y |
Y |
-- |
Y |
|
12 |
adbchgsrvmode command |
Y |
Y |
Y |
-- |
Y |
|
13 |
adbclientdefmang command |
Y |
Y |
Y |
-- |
Y |
|
14 |
adbcolumnize command |
Y |
N |
Y |
-- |
Y |
|
15 |
adbconvertaudittrailfile command |
Y |
Y |
Y |
-- |
Y |
|
16 |
adbdbstatus command |
Y |
Y |
Y |
-- |
N |
|
17 |
adbexport command |
Y |
Y |
Y |
-- |
N |
|
18 |
adbgetcst command |
Y |
N |
Y |
-- |
N |
|
19 |
adbidxrebuild command |
Y |
N |
Y |
-- |
N |
|
20 |
adbimport command |
Y |
N |
Y |
-- |
N |
|
21 |
adbinfoget command |
Y |
Y |
Y |
-- |
Y |
|
22 |
adbinfosweep command#3 |
N |
N |
N |
-- |
N |
|
23 |
adbinit command#3 |
N |
N |
N |
-- |
N |
|
24 |
adbinstall command#3 |
N |
N |
N |
N |
N |
|
25 |
adbls command |
Y |
Y |
Y |
-- |
Y |
|
26 |
adbmergechunk command |
Y |
N |
Y |
-- |
N |
|
27 |
adbmodarea command |
Y |
N |
Y |
-- |
Y |
|
28 |
adbmodbuff command |
Y |
Y |
Y |
-- |
N |
|
29 |
adbmonitor command |
Y |
Y |
Y |
-- |
Y |
|
30 |
adbreorgsystemdata command |
Y |
N |
Y |
-- |
N |
|
31 |
adbsql command#4 |
Y |
Y |
Y |
N |
N |
|
32 |
adbstart command#3 |
N |
N |
N |
-- |
N |
|
33 |
adbstat command |
Y |
Y |
Y |
-- |
Y |
|
34 |
adbstop command |
Y |
Y |
Y |
-- |
Y |
|
35 |
adbsyndict command |
Y |
N |
Y |
-- |
N |
|
36 |
adbunarchivechunk command |
Y |
N |
Y |
-- |
N |
- Legend:
-
Y: Can be executed.
N: Cannot be executed (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
-
The command cannot be executed while the HADB server is running.
- #4
-
For details about the SQL statements that can be executed, see Nos. 1 through 4.