Hitachi

Hitachi Advanced Database Setup and Operation Guide


A.2 Configuration of the server directory (for operation)

The following table shows the configuration of the server directory used in the operation of the HADB server.

Table A‒2: Configuration of the server directory (for operation)

No.

Directory name or file name

Description

Timing of creation

Timing of deletion

1

$ADBDIR/bin

Directory that stores various executable commands

When HADB server is installed

When HADB server is uninstalled

2

$ADBDIR/bin/adbarchivechunk

Command for archiving chunks

3

$ADBDIR/bin/adbaudittrail

Command for managing the audit trail facility

4

$ADBDIR/bin/adbcancel

Cancel command

5

$ADBDIR/bin/adbchgchunkcomment

Command for entering, changing, and deleting comments for chunks

6

$ADBDIR/bin/adbchgchunkstatus

Command for changing a chunk status

7

$ADBDIR/bin/adbchgnodetype

Command for changing an HADB server's node type

8

$ADBDIR/bin/adbchgsqltrc

Command for starting and stopping output of SQL trace information

9

$ADBDIR/bin/adbchgsrvmode

Command for changing the HADB server operation mode

10

$ADBDIR/bin/adbclientdefmang

Command for centrally managing client definitions

11

$ADBDIR/bin/adbcolumnize

Command for managing the updated-row columnizing facility

12

$ADBDIR/bin/adbconvertaudittrailfile

Command for converting audit trail files

13

$ADBDIR/bin/adbdbstatus

DB status analysis command

14

$ADBDIR/bin/adbexport

Data export command

15

$ADBDIR/bin/adbgetcst

Cost information collection command

16

$ADBDIR/bin/adbidxrebuild

Index rebuild command

17

$ADBDIR/bin/adbimport

Data import command

18

$ADBDIR/bin/adbinfoget

Troubleshooting information collection command

19

$ADBDIR/bin/adbinfosweep

Troubleshooting information deletion command

20

$ADBDIR/bin/adbinit

Database initialization command

21

$ADBDIR/bin/adbls

HADB server status display command

22

$ADBDIR/bin/adbmergechunk

Command for merging chunks

23

$ADBDIR/bin/adbmodarea

DB area addition/modification command

24

$ADBDIR/bin/adbmodbuff

Command for changing a buffer

25

$ADBDIR/bin/adbmonitor

Server-monitoring command

26

$ADBDIR/bin/adbreorgsystemdata

Command for reorganizing system tables

27

$ADBDIR/bin/adbshmdump

Shared memory dump command

28

$ADBDIR/bin/adbsrvd

Server daemon

29

$ADBDIR/bin/adbstart

HADB server startup command

30

$ADBDIR/bin/adbstat

Statistical analysis command

31

$ADBDIR/bin/adbstop

HADB server termination command

32

$ADBDIR/bin/adbsyndict

Command for managing synonym dictionaries

33

$ADBDIR/bin/adbsystoru

Command for getting ITRU troubleshooting information

34

$ADBDIR/bin/adbtdmpget

Used by the system

35

$ADBDIR/bin/adbtdmpview

36

$ADBDIR/bin/adbterrno

37

$ADBDIR/bin/adbtgetdef

38

$ADBDIR/bin/adbtgetsqltrc

39

$ADBDIR/bin/adbthdlinfo

40

$ADBDIR/bin/adbtmsglog

41

$ADBDIR/bin/adbtstat

42

$ADBDIR/bin/adbtsyslog

43

$ADBDIR/bin/adbtmk2

44

$ADBDIR/bin/adbunarchivechunk

Command for unarchiving chunks

45

$ADBDIR/bin/linaphx64

Used by the system

46

$ADBDIR/bin/patrol_sby_exe

HA Monitor slave monitor command (Start)

47

$ADBDIR/bin/patrol_sby_term

HA Monitor slave monitor command (Stop)

48

$ADBDIR/bin/stop_sby

HA Monitor slave stop command

49

$ADBDIR/client

Directory that stores commands and libraries used by HADB clients

50

$ADBDIR/client/bin

Directory that stores various executable commands used by HADB clients

51

$ADBDIR/client/bin/adbsql

SQL execution command

52

$ADBDIR/client/lib

Directory that stores various types of libraries used by HADB clients

53

$ADBDIR/client/lib/libadbclt.so

Client library

54

$ADBDIR/client/lib/adbjdbc8.jar

JDBC driver (JRE version 8)

55

$ADBDIR/conf

Directory that stores definition files

56

$ADBDIR/include

Directory that stores user-provided header files

57

$ADBDIR/include/adbcli.h

User-provided header files

58

$ADBDIR/include/adbtypes.h

59

$ADBDIR/include/adbcnv.h

60

$ADBDIR/include/adbodb.h

61

$ADBDIR/lib

Directory that stores various types of libraries

62

$ADBDIR/lib/libadb.so

Database access control library

63

$ADBDIR/lib/libadbrpcs.so

Communication library

64

$ADBDIR/lib/libadbsort.so

Sort library

65

$ADBDIR/lib/libtapa.so

Used by the system

66

$ADBDIR/lib/adbmsg.cat

Message catalog file

67

$ADBDIR/lib/sysdef

Directory that stores definition analysis information files

68

$ADBDIR/lib/sysdef/adb.def

Definition analysis information files

69

$ADBDIR/lib/sysdef/adbarchivechunk.def

70

$ADBDIR/lib/sysdef/adbclientdefmang.def

71

$ADBDIR/lib/sysdef/adbclt.def

72

$ADBDIR/lib/sysdef/adbexport.def

73

$ADBDIR/lib/sysdef/adbgetcst.def

74

$ADBDIR/lib/sysdef/adbidxrebuild.def

75

$ADBDIR/lib/sysdef/adbimport.def

76

$ADBDIR/lib/sysdef/adbimport_clm.def

77

$ADBDIR/lib/sysdef/adbimport_clm_csv.def

78

$ADBDIR/lib/sysdef/adbinit.def

79

$ADBDIR/lib/sysdef/adbmergechunk.def

80

$ADBDIR/lib/sysdef/adbmodarea.def

81

$ADBDIR/lib/sysdef/adbmodbuff.def

82

$ADBDIR/lib/sysdef/adbreorgsystemdata.def

83

$ADBDIR/lib/sysdef/adbunarchivechunk.def

84

$ADBDIR/sample

Directory that stores sample application programs and definition file templates

85

$ADBDIR/sample/cli_sample1.c

Sample application program (for CLI functions)

86

$ADBDIR/sample/create_sampledb.sh

Shell script for creating the table SAMPLE

87

$ADBDIR/sample/reorg_column_sample.sh

Shell script for reorganizing a column store table

88

$ADBDIR/sample/SAMPLE.txt

Data to be stored in the table SAMPLE

89

$ADBDIR/sample/SAMPLE_table.sql

File in which definition SQL statements for defining the table SAMPLE are coded

90

$ADBDIR/sample/Sample1.java

Sample application program (for JDBC)

91

$ADBDIR/sample/odbc_sample1.c

Sample application program (for ODBC)

92

$ADBDIR/sample/conf

Directory that stores a definition file template

93

$ADBDIR/sample/conf/adbarchivechunk.opt

Template file for the archive chunk option

94

$ADBDIR/sample/conf/adbclientdefmang.def

Template file for client-managing definitions

95

$ADBDIR/sample/conf/adbexport.opt

Export option template file

96

$ADBDIR/sample/conf/adbgetcst.opt

Template file for the cost-information collection option

97

$ADBDIR/sample/conf/adbidxrebuild.opt

Template file for the index rebuild option

98

$ADBDIR/sample/conf/adbimport.opt

Import option template file

99

$ADBDIR/sample/conf/adbinit.opt

Initialization option template file

100

$ADBDIR/sample/conf/adbmergechunk.opt

Template file for the merge chunk option

101

$ADBDIR/sample/conf/adbmodarea.opt

Template file for the DB area addition/modification option

102

$ADBDIR/sample/conf/adbmodbuff.opt

Template file for the buffer-modifying option

103

$ADBDIR/sample/conf/adbunarchivechunk.opt

Template file for the unarchive chunk option

104

$ADBDIR/sample/conf/client.def

Client definition template file

105

$ADBDIR/sample/conf/server.def

Server definition template file

106

$ADBDIR/sample/scripts

Directory that stores sample files for HA Monitor commands

107

$ADBDIR/sample/scripts/multinode.env

Environment variable definition file for HA Monitor commands (multi-node function)

108

$ADBDIR/sample/scripts/multinode_user.sh

Sample shell file for HA Monitor user commands (multi-node function)

109

$ADBDIR/sample/scripts/multinode_act.sh

Sample shell file for the HA Monitor startup command (multi-node function)

110

$ADBDIR/sample/scripts/multinode_term.sh

Sample shell file for the HA Monitor termination command (multi-node function) (for host reset)

111

$ADBDIR/sample/scripts/multinode_term_scsi.sh

Sample shell file for the HA Monitor termination command (multi-node function) (SCSI reservation for shared disk)

112

$ADBDIR/sample/scripts/multinode_patrol.sh

Sample shell file for the HA Monitor monitoring command (multi-node function)

113

$ADBDIR/sample/scripts/coldstandby.env

Environment variable definition file for HA Monitor commands (cold standby configuration)

114

$ADBDIR/sample/scripts/coldstandby_act.sh

Sample shell file for the HA Monitor startup command (cold standby configuration)

115

$ADBDIR/sample/scripts/coldstandby_term.sh

Sample shell file for the HA Monitor termination command (cold standby configuration)

116

$ADBDIR/sample/scripts/coldstandby_patrol.sh

Sample shell file for the HA Monitor monitoring command (cold standby configuration)

117

$ADBDIR/sample/jp1audit

Directory that stores the sample file of the definition file for JP1/Audit.

118

$ADBDIR/sample/jp1audit/admjevlog_HADB.conf

Sample file of the definition file for operational behavior for JP1/Audit

119

$ADBDIR/sample/jp1audit/HADB.conf

Sample file of the definition file for product behavior for JP1/Audit

120

$ADBDIR/spool

Directory that stores execution result logs

121

$ADBDIR/spool/adbdumpYYYYMMDDhhmmss.server-process-process-id #1

HADB dump file

When HADB server is started

  • When HADB server is terminated normally

  • When adbinfosweep command is executed

122

$ADBDIR/spool/adbdumperrorYYYYMMDDhhmmssSSSSSS_TTTTTTTTTTTTTTTTTTTT.server-process-process-id #1, #2

When an error occurs for which the KFAA60007-E message is output

When adbinfosweep command is executed

123

$ADBDIR/spool/adbmessageXX.log#3

Server message log file

When HADB server is started

124

$ADBDIR/spool/adbsqltrcXX.log#4

SQL trace file

When HADB server is uninstalled

125

$ADBDIR/spool/adbstatlogXX#3, #5

Statistics log file

126

$ADBDIR/spool/.defrslt

Server definition storage file

When adbinfosweep command is executed

127

$ADBDIR/spool/.adbmessage

Message log file number control file

128

$ADBDIR/spool/.adbshmid

Shared memory ID storage file

129

$ADBDIR/spool/.adbsemid

Semaphore set ID storage file

130

$ADBDIR/spool/.adbsqltrc

File for managing the file numbers of SQL trace files

When HADB server is uninstalled

131

$ADBDIR/spool/.adbstatlog#5

Statistics log file control file

132

$ADBDIR/spool/adbcolumnize01

File used by the updated-row columnizing facility

133

$ADBDIR/spool/.adbcolumnize

134

$ADBDIR/spool/adboptlogXX#6

Access path search information log file

135

$ADBDIR/spool/.adboptlog

Management file for the access path search information log

136

$ADBDIR/spool/.hadb_map

Used by the system

137

$ADBDIR/spool/.hadb_ulimit

#1

YYYYMMDDhhmmss in the file name indicates the time when the file was generated.

#2

SSSSSS in the file name indicates the microsecond portion of the time when the HADB dump file was generated. TTTTTTTTTTTTTTTTTTTT indicates the thread ID of the real thread in which the HADB server's internal conflict error was detected.

#3

XX in the file name is a sequential number between 01 and 04.

#4

XX in the file name is a sequential number between 01 and 08.

#5

If the adb_sta_log_path operand in the server definition is specified, the data is output to the directory specified in the adb_sta_log_path operand in the server definition.

For details about the adb_sta_log_path operand in the server definition, see the description of the adb_sta_log_path operand in 7.2.7 Operands related to statistical information (set format).

#6

XX in the file name is a sequential number that is either 01 or 02.