Filter
Top Products
Back-end Server Maintenance 211
If this is the first time exporting CDRs, make sure the UTL_FILE_DIR entry
in the oracle initialization file (init<SID>.ORA) is set correctly.
Deleting CDRs
This procedure is for deleting CDRs from the accounting server database.
Two configurations are affected by using this procedure: one is the
retention days, which is defined as the column of HOLD_DAYS in table
JOB_DELETE_CDRS; the other is BSS_SENSITIVE and upload range
PREV_ENDING_CDR and CURR_ENDING_CDR in table UPLOAD_HISTORY.
Default retention days is 7 if no value is configured. If there is billing
support server in the system, and BSS_SENSITIVE is set as 1, then once
CDRs are uploaded to billing support server, these CDRs are ready to be
removed from accounting server database when executing deletion
procedure, no matter what the retention period is.
Even though BSS_SENSITIVE is set 1, and the billing support server
uploads CDRs from the accounting server, those CDRs are not deleted
immediately after the upload action, they are marked as ready to be
deleted, but they will be deleted when the deletion procedure on
accounting server is called.
To delete CDRs from the accounting server database, from a SQL Plus
command line, login as the cwacct user and execute
CWDELETE.DELCDR as follows:
set serveroutput on
begin
cwdelete.delcdr;
end;
Monitoring
Accounting Server
Activity on the
Accounting Server
The Monitor State command opens the Monitor State window. Use this
window to monitor the operational state, usage state, or administration
state of the accounting server.
To monitor the activity of the accounting server using EMS:
1 In the explorer tree, right-click the accounting server.
2 From the pop-up menu, click Monitor State.
Refer to the Enterprise Management Suite User Guide for more
information.