Skip to content

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.