Filter
Top Products
Manually Configuring the Database Tables through Bulk Loading 305
Configuring
acct_server_list
The acct_server_list table creates a unique identifier for each accounting
server in the system. The billing support server uses this identifier to
identify the accounting server in related tables.
To edit the table:
1 Using a text editor, open one of the following files:
■ To load data into an empty table, open the
/opt/3com/VCX/bss/db/cwbss/bulkload/acct_server_list_data.txt file.
■ To append data, open the
/opt/3com/VCX/bss/db/cwbss/bulkload/custom/acct_server_list_data.t
xt file.
2 Add one row for each accounting server. For example:
|SERVER_ID_ACCT|SERVER_CONNECTION|DESCRIPTION
1|besdb1|testbed1, TORONTO |
2|besdb2|testbed2, Chicago |
3 Save and close the file.
Configuring
bss_acct_server_map
The bss_acct_server_map table associates a billing support server with an
accounting server.
Table 109 acct_server_list Fields
Column Name Description Value
SERVER_ID_ACCT A unique identifier for this accounting server. Integer
SERVER_CONNECTION The Oracle service name for the accounting
server database (also called the TNS string, net
service name, and service name).
String
DESCRIPTION A description of this accounting server. String
Table 110 bss_acct_server_map Fields
Column Name Description Value
DESCRIPTION A description of this relationship. String
SETUP_DATE The date this entry was entered. Date
dd-mm-yyyy
SERVER_ID_BSS A unique identifier for this billing support
server. The SERVER_ID_BSS in this table must
match a SERVER_ID_BSS in the bss_server_list
table.
Integer
(continued)