1.2 Nodes on which commands can be executed when the multi-node function is used

1

Installation and environment setup

Install

adbinstall

Y

Y

2

Initialize the database

adbinit

Y

Y

3

Add and change DB areas

adbmodarea

Y

N

4

Change buffers

adbmodbuff

Y

N

5

Start and terminate the HADB server

Start the HADB server

adbstart

Y

Y

6

Terminate the HADB server

adbstop

Y

Y^#1

7

Database maintenance and backup

Change the HADB server operation mode

adbchgsrvmode

Y

N

8

Table data import and export

Import data to base tables

adbimport

Y

N

9

Export table data

adbexport

Y

N

10

Index maintenance

Rebuild indexes

adbidxrebuild

Y

N

11

Chunk maintenance

Merge chunks

adbmergechunk

Y

N

12

Archive chunks

adbarchivechunk

Y

N

13

Unarchive chunks

adbunarchivechunk

Y

N

14

Change chunk status

adbchgchunkstatus

Y

N

15

Set, change, and delete comments for chunks

adbchgchunkcomment

Y

N

16

System table (base table) maintenance

Reorganize the system table (base table)

adbreorgsystemdata

Y

N

17

HADB server status display

Display information on client groups and command groups

adbls -d cltgrp

Y

Y

18

Display the connection status

adbls -d cnct

Y

Y

19

Display global buffer information

adbls -d gbuf

Y

Y

20

Display local work table buffer information

adbls -d lbuf

Y

Y

21

Display the status of locked resources

adbls -d lock

Y

Y

22

Display the memory usage status

adbls -d mem

Y

Y

23

Display shared memory information

adbls -d shm

Y

Y

24

Display the HADB server status

adbls -d srv

Y

Y

25

Display the thread status

adbls -d thd

Y

Y

26

Display version information

adbls -d ver

Y

Y

27

Execution of SQL statements

Execute SQL statements from the standard input or a file

adbsql

Y

Y

28

Dictionary management

Perform operation such as registering and deleting a synonym dictionary

adbsyndict

Y

N

29

Information collection and analysis

Analyze the database status

adbdbstatus

Y

N

30

Collect cost information

adbgetcst

Y

N

31

Display the HADB server's operation information

adbstat

Y

Y

32

Start or stop output of SQL trace information

adbchgsqltrc

Y

Y

33

Trouble-shooting

Forcibly terminate transactions or commands

adbcancel

Y

Y

34

Collect trouble-shooting information

adbinfoget

Y

Y

35

Delete trouble-shooting information

adbinfosweep

Y

Y

36

Multi-node function

Display the HADB server status on each node

adbls -d node

Y

Y

37

Change node type

adbchgnodetype

N

Y

38

Monitor the HADB Server

adbmonitor

Y

Y

39

Centralized management of client definitions

Centralized management of client definitions

adbclientdefmang

Y

N

40

Audit trail facility

Manage the audit trail facility

adbaudittrail

Y

Y^#2

41

Conversion of audit trail files

adbconvertaudittrailfile

Y

Y

42

Updated-row columnizing facility

Manage the updated-row columnizing facility

adbcolumnize

Y

N