Hitachi

Hitachi Advanced Database Command Reference


18.3 List of troubleshooting information items that are stored

The following table lists the troubleshooting information items that are stored in the mail version, the light version, the detailed version and the root version troubleshooting-information files.

Table 18‒3: Troubleshooting information that is stored

No.

Troubleshooting information

Mail version

Light version

Detailed version

root version

Classification

Description

1

Information that is collected by executing HADB commands

HADB server status

Y

Y

Y

N

2

Connection status

Y

Y

Y

N

3

Thread status

Y

Y

Y

N

4

Pseudo-thread information

Y

Y

Y

N

5

Error module trace information

Y

Y

Y

N

6

Memory usage status

Y

Y

Y

N

7

Shared memory information

Y

Y

Y

N

8

Global buffer information

Y

Y

Y

N

9

Local work table buffer information

Y

Y

Y

N

10

HADB server's version information

Y

Y

Y

N

11

Locked resource allocation request status

Y

Y

Y

N

12

Node information

Y

Y

Y

N

13

Client group and command group information

Y

Y

Y

N

14

Shared memory dumps

N

N

Y

N

15

Buffer trace

N

N

Y

N

16

HADB dumps

P

Y

Y

N

17

adbinfoget command's logs

Y

Y

Y

Y

18

Status of the updated-row columnizing facility

Y

Y

Y

N

19

Definition and output files that are referenced by the HADB server

All directories and files under $ADBDIR/conf

Y

Y

Y

N

20

Files under $ADBDIR/spool

P

P

Y

N

21

Files under the $DBDIR directory or core files under the directory specified in the adb_core_path server definition operand

P

P

Y

N

22

Statistics log file

P

P

Y

N

23

All directories and files under $ADBCLTDIR#/conf

Y

Y

Y

N

24

Files under $ADBCLTDIR#/spool

P

P

Y

N

25

SQL trace file

P

P

Y

N

26

Access path search information log file

N

Y

Y

N

27

List information of audit trail files

  • List of files under the directory specified for the adb_audit_log_path operand

Y

Y

Y

N

28

HADB library information

Y

Y

Y

N

29

Synonym dictionary information

  • List of files under the directory specified for the adb_syndict_storage_path operand

  • List of files under the directory specified for the adb_syndict_node_storage_path operand

Y

Y

Y

N

30

Information that is collected by executing OS commands

CPU usage rate

Y

Y

Y

N

31

Operational status of CPU by process

Y

Y

Y

N

32

Process information

Y

Y

Y

N

33

Memory status

Y

Y

Y

N

34

Shared memory status

Y

Y

Y

N

35

Disk information

Y

Y

Y

N

36

Disk status

Y

Y

Y

N

37

Network status information

Y

Y

Y

N

38

Network information

Y

Y

Y

N

39

Kernel parameters

Y

Y

Y

N

40

System information

Y

Y

Y

N

41

Package information

Y

Y

Y

N

42

Environment variable information

Y

Y

Y

N

43

Host name

Y

Y

Y

N

44

Backtrace information

Y

Y

Y

N

45

Kernel logs

Y

Y

Y

N

46

System resource limitation information

Y

Y

Y

N

47

libc.so version information

Y

Y

Y

N

48

Communication information

Y

Y

Y

N

49

User information

Y

Y

Y

N

50

Device configuration information

Y

Y

Y

N

51

LVM configuration information

N

N

N

Y

52

VG information

N

N

N

Y

53

Definition and output files that are referenced by the OS

Kernel information

Y

Y

Y

N

54

Processor information

Y

Y

Y

N

55

Memory information

Y

Y

Y

N

56

Disk information

Y

Y

Y

N

57

Map information

Y

Y

Y

N

58

ulimit information

Y

Y

Y

N

59

OS information

Y

Y

Y

N

60

syslog

Y

Y

Y

Y

Legend:

Y: Stored.

P: Part of the information is stored.

N: Not stored.

#

The directory path specified in the ADBCLTDIR environment variable for the server machine. If the ADBCLTDIR environment variable has not been specified, no information is stored.