9.11 nppddbst command (check database usage status)

Function

This command checks the database's usage status.

Check this command's execution result to determine the database's usage status, and then extend the size of the database if necessary.

This command must be executed while the system is running. Open the command prompt as an administrator.

Format

nppddbst

Options

None.

Output format for database usage status

The database's usage status is output in the following format:

number-of-Operational-ContentsΔ[content-usage]%([number-of-contents]/[maximum-number-of-contents])
number-of-versionsΔ[version-usage]%([total-number-of-versions]/[maximum-value-for-the-total-number-of-versions])
usageΔ[usage-of-total-database-size]%
[message]
----------

Legend: Δ: Single-byte space

The following table provides the details of the items that are output.

Table 9‒6: Details of the database usage status that is output by the command
Item	Description
`content-usage`	Result obtained from the following formula, expressed as a percentage: `Number of contents` ÷ `maximum number of contents`
`number-of-contents`	Number of Operational Contents in existence at the time of command execution
`maximum-number-of-contents`	Maximum number of Operational Contents that can be created
`version-usage`	This is the result obtained from the following formula, expressed as a percentage: `Total number of versions` ÷ `maximum value for the total number of versions`
`total-number-of-versions`	Total number of Operational Content versions in existence at the time of command execution
`maximum-value-for-the-total-number-of-versions`	`Maximum number of Operational Contents that can be created` × `number of versions that can be created per Operational Content`^#
`usage-of-total-database-size`	Usage of the database's total size expressed as a percentage
`message`	Whether database extension is needed. If database extension is needed: The following message is output: `KDCZ10371-W` `Database` `extension` `is` `recommended.` If database extension is not needed: No message is output.

#

The maximum number of versions that can be created per Operational Content is 7. The breakdown is as follows:

Number of Published Versions: 5

Version Being Edited (editing has started or finished): 1

Version Being Edited (editing is currently underway): 1

Return value

Return value	Description
`0`	The command terminated normally.
`1`	The command terminated abnormally.
`2`	A lock error occurred on the command.
`9`	An execution permission error occurred.

Notes: The return value is undefined if the command is terminated by a cause beyond the command's control (such as when the command is terminated forcibly by pressing the Ctrl key and the C key at the same time).

Example

This example outputs the database's usage status:

> Navigation-Platform-installation-directory\bin\nppddbst

To Page Top