Information required to diagnose Altibase problems#
About the content#
| Purpose | A list of information needed to diagnose Altibase problems. |
| Applies to | Altibase 4.3.9 or later |
| Prerequisites | Administrator's Manual |
List of diagnostics information to be gathered#
Altibase trace log#
Almost in all cases to analyze problems, the best place to start is Altibase trace logs. The default location of these logs is $ALTIBASE_HOME/trc folder.
When users have any issues in Altibase environment, they can archive and compress the entire folder structure and send it to Altibase Customer Support service to help to identify the root cause of the problems.
| File Name | Description |
|---|---|
| altibase_boot.log | The main trace log. It contains Altibase engine's start-up and shutdown log. |
| altibase_qp.log | The trace of Altibase QP (Query Processing) module. |
| altibase_sm.log | The trace log of Altibase SM (Storage Manage) module. |
| altibase_rp.log | The trace log of Altibase RP (Replication Processor) module. |
| altibase_xa.log | The trace log of Altibase XA module. |
It is advisable to send us all of these files above in order to minimize round-trip times.
altibase.properties file#
altibase.properties file is located in $ALTIBASE_HOME/conf folder.
If any part of this file is altered, it is advisable to send the result of following script along with the log files to Altibase Customer Support .
is <<EOF
spool property.txt
set linesize 200;
set colsize 60;
select name, value1 from v\$property;
quit;
EOF
List of OS Environment variables#
A text file containing the OS specific environment information listed below should also be submitted to Altibase Customer Service.
$ env
$ ulimit -a
Kernel value#
| OS | command |
|---|---|
| HP | # kctune |
| AIX | # vmo -a -F |
| # schedo -a -F | |
| # no -a -F | |
| Solaris | # cat /etc/project |
| Linux | # cat /proc/sys/kernel/sem |
| # cat /proc/sys/kernel/semall |
OS logs#
| OS | command |
|---|---|
| HP | # cat /var/adm/syslog/syslog.log |
| AIX | # errpt -a |
| Solaris | # cat /var/adm/messages |
| # dmesg | |
| Linux | # cat /var/log/messages |
| # dmesg |
System configuration information#
| OS | command |
|---|---|
| HP | # machinfo |
| AIX | # prtconf |
| Solaris | # prtconf |
| Linux | # cat /proc/cpuinfo |
| # cat /proc/meminfo |
Altibase process Stack trace#
The stack trace shows a snapshot of the state of the threads, and it is very useful information to solve the various types of problems - especially, process hanging situations.
| Platforms | Usage | |
|---|---|---|
| AIX | $ procstack [altibase_pid] | after AIX 6.1, procstack command to Altibase process does not work properly. |
| HP-UX | $ pstack [altibase_pid] | |
| Solaris | $ pstack [altibase_pid] | |
| Linux | $ pstack [altibase_pid] |
System resource utilization#
-
vmstat
$ vmstat -wt 1 5 -
CPU and memory utilization of Altibase process
$ ps -p [altibase_pid] -o pcpu -o vsz -o rssize
Problem symptoms and required diagnostics information#
Commons#
- Altibase trace log
- altibase.properties
- OS Environment variable list
Above information is required to analyze any Altibase problem.
Altibase Abnormal shutdown#
- Commons
- OS logs
Altibase Hang#
- Commons
- Altibase process Stack trace
Altibase Performance degradation#
- Commons
- Altibase process Stack trace during the System peak time.