Filter
Top Products
282 APPENDIX D: MANUALLY CONFIGURING THE ACCOUNTING SERVER
Configuring
bss_server_list
The bss_server_list table lists all of the billing support servers in the
system. This unique identifier is used to identify the billing support server
in other database tables.
Add one row for each billing support server. For example:
|SERVER_ID_BSS|SERVER_CONNECTION|DESCRIPTION
1|besdb2|testbed1,TORONTO|
Configuring
job_delete_cdrs
Use the job_delete_cdrs table to schedule the job that removes/deletes
data from the database. To execute the job immediately, the job only
needs a JOB_NUMBER.
Table 101 bss_server_list_data.txt Fields
Column Name Description Value
SERVER_ID_BSS A unique identifier for this billing support
server.
NOTE—Make sure you are consistent with
the SERVER_ID_BSS values found in the
“Configuring bss_acct_server_map” and
bss_server_config (on the billing support
server) tables.
Integer
SERVER_CONNECTION The database name or net service name
(Oracle database SID) for the billing support
server database (also called the TNS string).
Billing support and other accounting servers
use this name to access the database.
NOTE—3Com recommends using the
<dbname> as the SERVER_CONNECTION
value.
String
DESCRIPTION A description of this billing support server. String
Table 102 job_delete_cdrs_data.txt Fields
Column Name Description Value
JOB_ID The unique identifier for the job Integer
JOB_NUMBER This value is assigned by Oracle, not
by user assignment.
N/A
JOB_TO_SUBMIT The job name, usually a stored
procedure name, such as
CWDELETE.delcdr.
string
JOB_NEXT_RUN The next date/time the job will be run Date
(continued)