Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.3.0 |  CUBRID 8.3.1 |  CUBRID 8.4.0 |  CUBRID 8.4.1 |  CUBRID 8.4.3 |  CUBRID 9.0.0 | 

Outputting Internal Database Information

Description

You can check various pieces of internal information about the database with the cubrid diagdb utility. Information provided by cubrid diagdb is helpful in diagnosing the current status of the database or figuring out a problem.

Syntax

cubrid diagdb options database_name

options : [{-d | --dump-type=} type]

  • cubrid : An integrated utility for the CUBRID service and database management.
  • diagdb : A command that is used to check the current storage state of the database by outputting the information contained in the binary file managed by CUBRID in text format. It normally executes only when the database is in a stopped state. You can check the whole database or the file table, file size, heap size, class name or disk bitmap selectively by using the provided option.
  • options : The -d option is provided.
  • database_name : The name of the database to be diagnosed.
Option

Specifying the output range (-d or --dump-type)

The following example displays the information of all files in the testdb database. If any option is not specified, the default value of 1 is used.

cubrid diagdb -d 1 myhost testdb

The utility has 9 types of -d options as follows:

Type

Description

-1

Outputs all database information.

1

Outputs file table information.

2

Outputs file capacity information.

3

Outputs heap capacity information.

4

Outputs index capacity information.

5

Outputs class name information.

6

Outputs disk bitmap information.

7

Outputs catalog information.

8

Outputs log information.

9

Outputs hip information.