
Historical database
CC MIS
CC MIS
D-2 297-2671-545
Release 5.2
A record is stored in the database for each unique key as determined from Table D-1. For example,
if an agent is moved to another supervisor within an interval, then two records exist for that agent
ID within the interval since the two supervisor IDs cause two distinct keys (with all other portions
of the key being identical).
A record only exists if there is data associated with the key. For example, if no calls are processed
in a particular group within an interval, then no i_accddn record will be stored in the database for
that group in that interval. This means that during periods where there is no switch activity or link is
down, no records are stored in the database. Reports generated will not contain data for this time
period.
The database is pre-allocated using the database storage calculator. It is allocated with enough
space to handle the storage parameters specified. Additionally, the database is compressed to max-
imize storage potential. The average compression ratio of 54% is reflected in storage calculator
values.
The overhead for a boot disk is 350 Mbytes. The overhead per partition is 50 Mbytes.
The database storage calculator pre-allocates disk storage for historical data based on parameters
supplied in the storage calculator screen. The values in Table D-2 are determined and are refer-
enced for computing disk storage requirements.
d_acddn
w_acddn
m_acddn
120
source ACD-DN, source group, day (or week or
month)
d_WALK
w_WALK
m_WALK
24
source group, day (or week or month), walk code
l_agent
16
agent ID, event (login, logout, walkaway, return
from walkaway), day, time
Table D-2: Historical database values
Value
Description
ACD_GROUPS
Number of ACD groups to store
SDNS
Number of primary and supplementary DNs to store
POSITIONS
Number of active positions
AGENTS
Number of agent IDs
Table D-1: Historical database tables
Table
# of bytes
Record key
Содержание CC MIS
Страница 4: ...iv Publication History CC MIS CC MIS 297 2671 545 Release 5 2 ...
Страница 12: ...viii Contents CC MIS CC MIS 297 2671 545 Release 5 2 ...
Страница 22: ...xviii Steps CC MIS CC MIS 297 2671 545 Release 5 2 ...
Страница 28: ...intr 6 297 2671 545 CC MIS Release 5 2 ...
Страница 38: ...1 10 297 2671 545 CC MIS Release 5 2 ...
Страница 72: ...4 8 297 2671 545 CC MIS Release 5 2 ...
Страница 102: ...6 18 297 2671 545 CC MIS Release 5 2 ...
Страница 142: ...7 40 297 2671 545 CC MIS Release 5 2 ...
Страница 168: ...8 26 297 2671 545 CC MIS Release 5 2 ...
Страница 212: ...10 4 297 2671 545 CC MIS Release 5 2 ...
Страница 224: ...12 4 297 2671 545 CC MIS Release 5 2 ...
Страница 232: ...13 8 297 2671 545 CC MIS Release 5 2 ...
Страница 236: ...14 4 297 2671 545 CC MIS Release 5 2 ...
Страница 238: ......
Страница 302: ...System Log Messages CC MIS CC MIS B 62 297 2671 545 Release 5 2 CHG_ORGANN CHG_TMDTHRTE CHG_TMDTHRTE_TIME ...
Страница 322: ...System Log Messages CC MIS CC MIS B 82 297 2671 545 Release 5 2 ...
Страница 332: ...Installing the operating system CC MIS CC MIS C 10 297 2671 545 Release 5 2 ...
Страница 340: ...Historical database CC MIS CC MIS D 8 297 2671 545 Release 5 2 ...
Страница 363: ...CC MIS Maintenance Guide E 23 CC MIS CC MIS Release 5 2 ...
Страница 364: ...E 24 297 2671 545 CC MIS Release 5 2 ...
Страница 369: ...CC MIS Maintenance Guide IN 5 CC MIS CC MIS Release 5 2 ...
Страница 370: ...CC MIS Maintenance Guide IN 6 CC MIS CC MIS Release 5 2 ...
Страница 371: ...CC MIS Maintenance Guide IN 7 CC MIS CC MIS Release 5 2 ...
Страница 372: ...IN 8 CC MIS CC MIS 297 2671 545 Release 5 2 ...
Страница 373: ......