Table Of Contents

Database Usage

Database Usage

---

Revised: July 24, 2009, OL-3743-42

The Database Usage (db-usage) table can only be provisioned at installation. It provides maximum, licensed, and current database record statistics. The current number of records field is updated by the Element Management System (EMS) in real time. The db-usage command also uses the Database Threshold (db-thresholds) table, which contains default alarm threshold parameters that are preprovisioned during installation. A service provider can change and show these threshold parameters. The default threshold parameters are:

•80 percent minor

•85 percent major

•90 percent critical

---

Note After a new install or an upgrade, all provisioning is disabled unless the DB-LICENSE file is provisioned. See the Cisco BTS 10200 Softswitch Provisioning Guide for steps.

---

Table Name: DB-USAGE

Table Containment Area: EMS

Command Types

Show and change

Examples

show db-usage table-name=dial-plan;

change db-usage table-name=dial-plan; minor-threshold=70; major-threshold=80; 
critical-threshold=95;

Usage Guidelines

Primary Key Token(s): table-name

Change Rules:

•max-record-count must be greater than or equal to licensed-record-count.

•max-record-count must be greater than or equal to current-record-count.

•licensed-record-count must be greater than or equal to current-record-count.

•Major threshold must be less than Critical threshold and more than Minor threshold.

•Minor threshold must be less than Major threshold.

---

Note In this chapter, an asterisk preceding a token name means the token is mandatory. A token without an asterisk is optional.

---

Syntax Description

TABLE-NAME	Primary key. Table name. VARCHAR(32): 1-32 ASCII characters.
MAX-RECORD- COUNT (Not provisionable)	The size is specified in number of records. This field is populated during installation. INTEGER.
ALERT-LEVEL	Displays the status of record count for each table. VARCHAR(12): 1-12 ASCII characters. Permitted values are: NO-LICENSE—The DB size (license) is not installed. NORMAL—The current record count is lower than the minor threshold. MINOR—The current record count is higher than minor threshold and lower than major threshold. MAJOR—The current record count is higher than major threshold and lower than critical threshold. CRITICAL— The current record count is higher than critical threshold.
AUTO-REFRESH	Specifies whether to display cached data on the screen. Valid only for the show command. CHAR(1): Y/N (Default = Y). Y—Queries the database for the most current data. N—Queries the database for the most current data only if the cached data is unavailable.
CRITICAL- THRESHOLD	Threshold for critical alarm (in percent). INTEGER: 2-100 (Default = 90).
CURRENT-RECORD-COUNT (System generated)	Current number of records in the table. This field is 0 for new installations and is the current table size for existing systems. INTEGER.
DISPLAY	Specifies what token information to display on the screen. Valid only for the show command. VARCHAR(1024): 1-1024 (Default = all tokens are displayed). Permitted values are any valid token that can be shown for this command. Multiple tokens can be entered by separating with a comma.
LICENSED-RECORD-COUNT (Not provisionable)	Number of records authorized for the customer. This field is populated during installation. INTEGER.
LIMIT	Specifies the number of rows to display on the screen. Valid only for the show command. INTEGER: 1-100000000 (Default = 100000000). Note The actual maximum number of rows displayed is currently lower than 100000000 due to software limitations.
MAJOR-THRESHOLD	Threshold for major alarm (in percent). INTEGER: 1-99 (Default = 85).
MINOR-THRESHOLD	Threshold for minor alarm (in percent). INTEGER: 0-98 (Default = 80).
ORDER	Specifies whether to display data on the screen in a sorted order. Valid only for the show command. VARCHAR(1024): 1-1024 (Default = all rows are displayed). Permitted values are any valid token that can be shown for this command. Multiple tokens can be entered by separating with a comma.
SEND-ALERT	Indicates whether to turn the threshold alarm ON or OFF. If the table size is 10 records or less, the flag is automatically set to OFF. VARCHAR(16): 1-16 ASCII characters. Permitted values are: ON—Turn the threshold alarm on. OFF—Turn the threshold alarm off.
START-ROW	Specifies to begin displaying data on the screen at a specific row. Valid only for the show command. INTEGER: 1-100000000 (Default = 1).