Filter
Top Products
4-9
Cisco BTS 10200 Softswitch Operations and Maintenance Guide, Release 6.0.x
OL-16000-07
Chapter 4 Operating the BTS
Using Show and Change Commmands
Using Show and Change Commmands
Using ERAC Commands
Using prepared SQL statements Extended Read Access Commands (ERAC) commands perform a
complex read against the BTS database. This SQL optimization and multitable and nested SELECT(s)
quickly return data that would otherwise take several database dips and a lot of back end data post
processing. Use the following interfaces to access ERAC:
• CLI and MAINT shells
• CORBA/XML adapters
• EPOM (uses CORBA/XML)
• SPA
Directory number (DN) and telephone number (TN) refer to the same BTS entity but with different
sources:
• TN—EC database value + the Office Code table’s NDC field
• DN—DN2 Subscriber table’s DN field
The TN/DN is a concatenation of 14 (or less) digits. Commands fail if a partial TN is supplied.
Note Commands allow for wild card support. When you enter a subscriber, subscriber account code, or DN ,
the value can have the wild card percent (%) search criteria.
Table 4-4 Using Show and Change Commands
Task Sample Command
Viewing
subscriber-related
batch data:
subscribers,
terminations,
subscriber service
profiles
show subscriber limit=1000; start_row=<next page
value>;display=id,sub_service_profile; order=id;
Where
• limit—Page size for the maximum number of rows (or lines) to display
• start_row—Which page to display first
• display=id—Sorts data by id column
• order=id—Provides a key for ordering or sorting the data
Viewing database
usage statistics
show db-usage table-name=dial_plan;
Note Do not use hyphens in table names; instead use underscores.
or
1. Go to http://www.cisco.com/iam/BTSCLI/BTS.html
.
2. From the first drop-list, select "Table Sizing Configuration".
Changing database
usage statistics
change db-usage table-name=dial-plan;
minor-threshold=70;major-threshold=80; critical-threshold=95;