DEV Community

mmllllzcn
mmllllzcn

Posted on

GBase Database: How to Read Instance Status with a Single `onstat -` Command

When troubleshooting GBase Database(GBase 8s), onstat - is one of the first commands I run.

It is short, requires little effort, and provides enough information to complete the first stage of database incident triage.

A single line can tell you the instance name, current state, uptime, and memory usage.

1. Understand the onstat - Output

A typical output looks like this:

gbase01: On-Line -- Up 3 days 06:13:19 -- 165364 Kbytes
Enter fullscreen mode Exit fullscreen mode

Read it from left to right:

Output Meaning
gbase01 Database instance name
On-Line Current instance state
Up 3 days 06:13:19 Instance uptime
165364 Kbytes Memory usage reported by the instance

For a single-instance GBase Database environment, this output provides a useful first snapshot of the database's operational status.

But the most important information is the instance state.

2. Four Instance States You Should Recognize

Different instance states require different troubleshooting actions.

On-Line: The Instance Is Running

On-Line indicates that the database instance is in its normal operational state.

This is when it makes sense to investigate:

  • Network listeners
  • sqlhosts configuration
  • User privileges
  • SQL execution
  • Application connectivity

If the instance is already On-Line, restarting it should not be the default troubleshooting response.

Quiescent: The Instance Is in Administrative Mode

Quiescent indicates that the instance is running in administrative mode rather than normal production mode.

To return it to multi-user mode, use:

onmode -m
Enter fullscreen mode Exit fullscreen mode

There is little value in investigating remote network connectivity before resolving the instance state.

Fast Recovery: The Instance Is Recovering

Fast Recovery indicates that the database is performing automatic recovery following an abnormal shutdown.

The correct response is to monitor recovery progress and inspect relevant logs if necessary.

Avoid repeatedly restarting the instance or interrupting recovery without understanding its current progress.

shared memory not initialized: Check the Target Instance First

This message is frequently misunderstood.

It may indicate that the instance is down or has not been initialized. However, it can also indicate that the current shell is pointing to a different instance.

On a host running multiple GBase Database instances, GBASEDBTSERVER determines which instance the environment targets.

If this variable is incorrect, onstat - may report that shared memory is not initialized even though another instance is running normally.

The key is to verify the target instance before concluding that the database is unavailable.

3. A Common Troubleshooting Mistake: Wrong Instance, Wrong Diagnosis

Consider a test environment where an application reports connection failures.

The on-call engineer runs onstat -, sees:

shared memory not initialized
Enter fullscreen mode Exit fullscreen mode

and immediately restarts the database.

But the problem is not necessarily the database.

The shell may have inherited an incorrect GBASEDBTSERVER value, pointing to an instance name that does not correspond to the intended database environment.

The actual database may have been running normally throughout the incident.

This is particularly relevant in containerized deployments.

Container images do not automatically inherit the host's environment variables. As a result, identical command lines can target different database instances depending on how the container environment is configured.

The lesson is simple: verify the target instance before interpreting its state.

4. My Three-Command Instance Troubleshooting Sequence

I use the following sequence during initial incident triage:

# 1. Confirm the target instance
echo $GBASEDBTSERVER

# 2. Check the instance state
onstat -

# 3. Check whether the instance process exists
ps -ef | grep oninit
Enter fullscreen mode Exit fullscreen mode

Each command answers a different question:

Command Question
echo $GBASEDBTSERVER Which instance does this shell target?
onstat - What is the current instance state?
`ps -ef \ grep oninit`

The sequence matters.

First confirm the target instance, then inspect its state, and finally verify the corresponding processes.

This prevents a wrong environment from being mistaken for a database failure.

5. Why onstat - Belongs at the Top of the Runbook

One reason onstat - is so useful is that it reads instance status information from shared memory without requiring a database connection or taking a database lock.

It is lightweight and suitable for repeated inspection during production troubleshooting.

That makes it an excellent first-line diagnostic command.

GBase Database monitoring can involve sophisticated dashboards, metrics, and alerting systems. But when an incident starts, the first question is often much simpler:

Am I looking at the correct instance, and what state is it in?

For GBase Database(GBase 8s), onstat - provides a fast answer.

If there is only one command worth remembering for the first stage of instance troubleshooting, this is a strong candidate.

And one rule is even more important:

Confirm which instance you are looking at before deciding whether that instance is healthy.

Top comments (0)