
15-53
Cisco BTS 10200 Softswitch Troubleshooting Guide, Release 5.0.x
OL-8723-19
Chapter 15 Diagnostic Tests
Fast Audit and Sync Tool
Fast Audit and Sync Tool
The bts_audit and bts_sync process tools consists of running two commands, bts_audit and bts_sync.
The bts_audit and bts_sync tools are designed to improve speed and integrity. The tools can audit and
synchronize all mismatches between network elements.
These tools are not a part of the CLI, but are unix programs that are run by the root user. They bypass
the platform messaging paths and access the EMS, CA, FSPTC, and FSAIN databases directly using
database tools. The data is manipulated and updates are applied directly to synchronize the databases.
The bts_audit tool is able to:
•
Find tables with mismatches
•
Find rows missing in application database
•
Find rows missing in EMS database
•
Find rows with data mismatches between two databases
•
Generate a report that lists these mismatches
•
Generate the SQL to be used to correct the mismatches
The bts_sync tool is used to send the generated SQL statements to the appropriate destination to bring
the databases into synchronization.
The BTS 10200 Fast Audit and Sync Tools feature consists of two expect shell scripts that use other unix
scripts and utilities to perform full-database and table audits of the databases on the various network
elements of the system, and synchronize the mismatches found. The bts_audit tool determines the tables
when performing full database audit by analyzing the catalog of the CA, FSPTC and FSAIN databases.
The scripts will create copies of the data from the tables in a standardized format. The data files are used
to generate a checksum for each table. The check sums are compared, and if they are not equal, the
network element data file will be transferred to the EMS. On the EMS, the data is compared row by row,
and mismatches are printed to a file that may be used by the bts_sync tool to restore synchronization of
the table on the network element
Restrictions and Limitations
The BTS 10200 Fast Audit and Sync Tools feature described in this document has the following
restrictions and limitations:
•
The bts_audit/bts_sync tools are unable to audit and synchronize certain scenarios, such as when a
termination record points to an invalid mgw.
•
The bts_sync tool should only be run to synchronize the data mismatches between the active
platforms.
•
If audit is given a list of tables, and a table references a missing row in another table, the mismatch
will not be resolved by the sync.
Using the bts_audit Tool
To use the bts_audit tool, log in at the unix root prompt and execute the
bts_audit
command.