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.
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
|
Y |
Y |
Y |
N |
|
28 |
HADB library information |
Y |
Y |
Y |
N |
|
29 |
Synonym dictionary information
|
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.