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 on 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 of which internal information is to be diagnosed.
Options

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

The following example shows how to display 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

Displays all database information.

1

Displays file table information.

2

Displays file capacity information.

3

Displays heap capacity information.

4

Displays index capacity information.

5

Displays class name information.

6

Displays disk bitmap information.

7

Displays catalog information.

8

Displays log information.

9

Displays hip information.