Skip to end of metadata
Go to start of metadata

About the content

Purpose

A list of information needed to diagnose ALTIBASE HDB problems.

Applies to

HDB versions 4.3.9 or later

Prerequisites

Administrator's Manual

List of diagnostics information to be gathered

ALTIBASE HDB trace log

Almost in all cases to analyze problems, the best place to start is ALTIBASE HDB trace logs. The default location of these logs is is $ALTIBASE_HOME/trc folder.

When users have any issues in ALTIBASE HDB 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 HDB engine's start-up and shutdown log.

altibase_qp.log

The trace of  ALTIBASE HDB QP (Query Processing) module.

altibase_sm.log

The trace log of ALTIBASE HDB SM (Storage Manage) module.

altibase_rp.log

The trace log of ALTIBASE HDB RP (Replication Processor) module.

altibase_xa.log

The trace log of ALTIBASE HDB 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.

Icon

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 .

List of OS Environment variables

A text file containing the OS specific environment information listed below should also be submitted to Altibase Customer Service.

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 HDB 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 HDB process does not work properly.

HPUX

$ pstack [altibase_pid]

 

Solaris

$ pstack [altibase_pid]

 

Linux

$ pstack [altibase_pid]

 

System resource utilization

  • vmstat
  • CPU and memory utilization of ALTIBASE HDB process

Problem symptoms and required diagnostics information

Commons

  • ALTIBASE HDB trace log
  • altibase.properties
  • OS Environment variable list
    Above information is required to analyze any ALTIBASE HDB problem.

ALTIBASE HDB abnormal shutdown

  • Commons
  • OS logs

ALTIBASE HDB hang

  • Commons
  • ALTIBASE HDB process stack trace

ALTIBASE HDB performance degradation

  • Commons
  • ALTIBASE HDB process stack trace during the system peak time.
  • No labels