4.2.2 Estimating the size of the server directory
The table below shows the estimate sizes of the files under the server directory based on the input data. The sum total of the values estimated for rows from row 1 to row 6 will be the total size of the server directory.
|
No. |
Directory name and file name |
Description |
Estimated value (gigabytes) |
|---|---|---|---|
|
1 |
$ADBDIR/spool/adbmessageXX.log#1 |
Server message log file#5 |
0.064 |
|
2 |
$ADBDIR/spool/adbstatlogXX#1, #2 |
Statistics log file#5 |
16 |
|
3 |
$ADBDIR/spool/adbdumpYYYYMMDDhhmmss.server-process-process-ID#3 |
HADB dump file#5 |
100 |
|
4 |
$ADBDIR/spool/adbsqltrcXX.log#4 |
SQL trace file#5 |
2 |
|
5 |
$ADBDIR/spool/adbcolumnize01 |
Log file used by the updated-row columnizing facility#5 |
0.1 |
|
6 |
$ADBDIR/spool/adboptlogXX#6 |
Access path search information log file#5 |
0.2 |
- #1
-
XX in the file name is a sequential number between 01 and 04.
- #2
-
If the adb_sta_log_path operand is specified in the server definition, data is output to the directory specified for 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).
- #3
-
YYYYMMDDhhmmss in the file name indicates the time when the file was generated.
- #4
-
XX in the file name is a sequential number between 01 and 08.
- #5
-
When using the multi-node function, the size of this file must be estimated for all nodes.
- #6
-
XX in the file name is a sequential number that is either 01 or 02.