Cisco Systems 10200 Using Show and Change Commmands, Using Erac Commands, Subscriber-related, Spa

Chapter 4 Operating the BTS

Using Show and Change Commmands

Using Show and Change Commmands

Table 4-4 Using Show and Change Commands

Task	Sample Command
Viewing	show subscriber limit=1000; start_row=<next page
subscriber-related	value>;display=id,sub_service_profile; order=id;
batch data:	Where
subscribers,
terminations,	• limit—Page size for the maximum number of rows (or lines) to display
subscriber service	• start_row—Which page to display first
profiles
	• display=id—Sorts data by id column
	• order=id—Provides a key for ordering or sorting the data
Viewing database	show db-usage table-name=dial_plan;
usage statistics	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	change db-usage table-name=dial-plan;
usage statistics	minor-threshold=70;major-threshold=80; critical-threshold=95;

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.

Cisco BTS 10200 Softswitch Operations and Maintenance Guide, Release 6.0.x

OL-16000-07 4-9