Post-processing method for pending OnLine Process

When OnLine users complain that their processes are suspended or cannot interact with OnLine users, run onstat-a to obtain essential information about the problem. Onstat is a utility provided by OnLine and is used to monitor system commands. It provides similar but more detailed statistics to the tb_Monitoronmonitor utility.

The most obvious reason for OnLine suspension is that the logical log is full and needs to be backed up. Check the status of logical logs in the tbstat output. After the logic log is filled up, the backup log will let OnLine continue to process the transaction.

The process must wait for the checkpoint to complete. A Checkpoint request can prevent a process from entering a critical state or obtaining latches. Onstat displays the 1st behavior status line. It displays whether the checkpoint has been applied. If the condition is true, the checkpoint may be waiting for resources. Check the waiting queue in the user structure to find the resource address. Once a resource is located, the user Process status that owns the resource is determined. Processes that have entered a critical state or hold latches of resources can prevent the completion of checkpoints. For example, the archiving process keeps holding a latch during the change of tape and disallows checkpoints.
Utility for problem diagnosis

Usage of the utility name

Dbexport is used to unload the database into an ascii file to a disk or tape to generate a database. SQL file containing the table structure. The structure does not contain the extent size. The database is transplanted to other platforms.

Dbimport loads the database structure and ascii data generated by the ascii file from dbexport, generates and loads the database, and loads the database directly by disk or tape. Input data from other platforms

Tbunload is used to unload data images of databases or tables to disks or tapes. It is used to unload data in binary mode in an OnLine system with the same machine structure and the same page size.

Tbload is efficient for loading databases or tables on tape generated by tbunload loaded from binary files.

Tbinit initializes the shared memory and starts the background process tbmonitor.

Manage tbmode to make OnLine offline or OnLine and stop the OnLine process tbmonitor command line

Tbmonitor is managed by administrators to enable the OnLine system, report the OnLine system status, perform archiving, restore backup logic logs, and change the system status. Interactive full-featured management program

Tbparams management is used by administrators to add or delete logical logs and change the size and location of physical logs. tbmonitor command line

Tbspaces management is used by administrators to add or delete dbspace or blobspace, add chunks for them, and change the status of tbmonitor command lines.

Tbstat system Inspectors provide detailed information reports on OnLine status and shared memory resources/debug tools

Tbtape manages the system archive on tape, or backs up the logic log tbmonitor command line

Tblog system examiner provides detailed information report on logical log entries/debug tools

Tbcheck system examiner reports and checks OnLine system integrity, performs low-level checks on data, index pages, extent, and bitmap pages, and provides related retention pages, extent, and system information reports/debug tools