Checking Used Space

Description

The cubrid spacedb utility is used to check how much space of database volumes is being used. It shows a brief description of all permanent data volumes in the database. Information returned by the cubrid spacedb utility includes the ID, name, purpose and total/free space of each volume. You can also check the total number of volumes and used/unused database pages.

Syntax

cubrid spacedb options database_name

options : [{-o|--output-file=}file] [--size_unit=PAGE|M|G|T|H] [-S|--SA-mode | -C|--CS-mode]

• cubrid : An integrated utility for the CUBRID service and database management.
• spacedb : A command that checks the space in the database. It executes successfully only when the database is in a stopped state.
• options : The -o, -S, -C and --size_unit options are supported. For details about each option, refer to its description and the examples.
• database_name : The name of the database whose space is to be checked. The path-name to the directory where the database is to be created must not be included.

Option

Saving output messages to a file (-o)

The above example shows saving the result of checking the space information of testdb to a file named db_output.

cubrid spacedb -o db_output testdb

Executing in stand-alone mode (-S or --SA-mode)

The -S option is used to access a database in standalone, which means it works without processing server; it does not have an argument. If -S is not specified, the system recognizes that a database is running in client/server mode.

cubrid spacedb --SA-mode testdb

Executing in client/server mode (-C or --CS-mode)

The -C option is used to access a database in client/server mode, which means it works in client/server process respectively; it does not have an argument. If -C is not specified, the system recognize that a database is running in client/server mode by default.

cubrid spacedb --CS-mode testdb

Outputing in megabytes (--size_unit=M)

cubrid spacedb --size_unit=M testdb

Outputing in print-friendly version (--size_unit=H)

The unit is automatically determined as follows: M if 1MB = DB size < 1024MB, G if 1GB = DB size < 1024GB.

cubrid spacedb --size_unit=H testdb