Table 2-1 Common Database Usage Defaults and Sizing Rules—All Configurations and Releases
EMS Filename
|
Split NPA
|
Audit Table
|
Maximum Record
Count (Old)
|
Diff (New-Old)
|
Display if <=10
|
Sizing Rules
|
AAA-SERVER-GRP
|
N
|
Y
|
50
|
0
|
|
10 percent of POPs.
|
ACTIVITY
|
N
|
Y
|
100
|
0
|
|
None.
|
ACTIVITY-BASE
|
N
|
N
|
100
|
0
|
|
Same as number in the Activity table.
|
AGGR
|
N
|
Y
|
1000
|
0
|
|
100 Embedded Media Terminal Adapters (MTAs) ( media gateways (MGWs)) per Cable Modem Termination System (CMTS).
|
AGGR-PROFILE
|
N
|
Y
|
0
|
100
|
|
No rules.
|
ANI
|
Y
|
Y
|
400000
|
0
|
|
None. If the Split NPA feature is invoked, not all ANI records are provisioned. Leave room for the split NPA feature.
|
ANI-SCREENING
|
Y
|
Y
|
12500
|
6300
|
|
10 entries per ANI screening profile.
|
ANI-SCREENING-PROFILE
|
N
|
Y
|
1000
|
500
|
|
Same as the number of PRI trunk groups.
|
ANI-WB-LIST
|
Y
|
Y
|
31250
|
0
|
|
Used for 800 service. 10 times the number of customer groups.
|
ANNC-TG-PROFILE
|
N
|
Y
|
100
|
0
|
|
None.
|
ANNC-TRUNK
|
N
|
Y
|
12000
|
0
|
|
24 times the number of POPs
|
ANNOUNCEMENT
|
N
|
Y
|
1000
|
0
|
|
None.
|
AOR2SUB
|
N
|
Y
|
50000
|
0
|
|
Number of SIP subscribers.
|
AUDIO-SEGMENT
|
N
|
Y
|
5000
|
0
|
|
5 segments per audio sequence.
|
AUDIO-SEQ
|
N
|
Y
|
1000
|
0
|
|
10 audio sequences per feature.
|
AUTH-CODE
|
N
|
Y
|
250000
|
0
|
|
None.
|
AUTH-CODE-GRP
|
N
|
Y
|
25000
|
0
|
|
Number of authorization codes divided by 10.
|
AUTH-REALM
|
N
|
Y
|
1000
|
0
|
|
Same as the number of serving domains
|
BACKHAUL-SET
|
N
|
Y
|
1500
2500 (Release 4.5.1)
|
0
|
|
Number of ISDN PRIs. In Release 4.5.1, for a medium configuration, throttling allows only 2000 active D-channels to process although the system supports 2500. Only 2000 D-channels are available for use.
|
CA-CONFIG
|
Y
|
Y
|
1000
|
0
|
|
None.
|
CALL-AGENT
|
N
|
Y
|
10
|
0
|
10
|
None.
|
CALL-AGENT-PROFILE
|
N
|
Y
|
10
|
0
|
10
|
None.
|
CALL-CTRL-ROUTE
|
N
|
Y
|
4096
|
0
|
|
2 times the number of DPCs.
|
CALL-SUBTYPE
|
|
|
|
|
|
|
CALL-TYPE
|
N
|
N
|
100
|
0
|
|
None.
|
CARRIER
|
N
|
Y
|
10000
|
0
|
|
Based on the 4-digit carrier ID.
|
CAS-TG-PROFILE
|
N
|
Y
|
100
|
0
|
|
None.
|
CASUAL-WB-LIST
|
N
|
Y
|
75000
|
0
|
|
10 entries for 10 percent of the COS restrict ids.
|
CAUSE-CODE-MAP
|
N
|
Y
|
2000
|
0
|
|
20 times the number of cause code map profiles.
|
CAUSE-CODE-MAP-
PROFILE
|
N
|
Y
|
100
|
0
|
|
None.
|
CENTREX-GRP
|
N
|
Y
|
500
|
0
|
|
Number of Centrex groups.
|
CHANGED-NUMBER
|
Y
|
Y
|
2000
|
0
|
|
1 percent of directory numbers (DNs) to save as changed numbers
|
CIPHERSUITE
|
N
|
Y
|
1000
|
0
|
|
Same as the number of QoSs.
|
CIPHERSUITE-PROFILE
|
N
|
N
|
1000
|
0
|
|
Same as the number of quality of services (QoSs).
|
CIRCUIT-CODE
|
N
|
Y
|
500
|
0
|
|
Circuit Code table is AT trunk group specific. Used to populate the Transit Network Selection (TNS) parameter in an SS7 message. Same as the number of POPs.
|
CLLI-CODE
|
N
|
Y
|
500
|
0
|
|
Same as number of POPs. One local (self) CLLI code is allowed per POP.
|
COS-RESTRICT
|
N
|
Y
|
75000
|
0
|
|
75percent of subscribers with individual COS restrict ids.
|
CPSG
|
N
|
Y
|
1000
|
0
|
|
2 times the number of Centrex groups.
|
CUST-GRP
|
N
|
Y
|
2500
|
0
|
|
100 DNs (800) per DN2customer group.
|
CUSTOM-DIAL-PLAN
|
N
|
Y
|
10000
|
0
|
|
20 custom dial plan entries per Centrex group.
|
CUSTOM-DIAL-PLAN-
PROFILE
|
N
|
N
|
500
|
0
|
|
Number of Centrex groups.
|
DB-THRESHOLDS
|
N
|
N
|
1000
|
0
|
|
None.
|
DB-USAGE
|
N
|
N
|
1000
|
0
|
|
None.
|
DESTINATION
|
N
|
Y
|
5000
|
0
|
|
10 destinations per POP.
|
DIAL-PLAN
|
N
|
Y
|
1000000
|
0
|
|
1000 records per dial plan profile.
|
DIAL-PLAN-PROFILE
|
N
|
Y
|
1000
|
0
|
|
Same as the number of POPs.
|
DIGIT-MAP
|
N
|
Y
|
1000
|
0
|
|
Number of digit maps. Calculated based on number of POPs plus the number of Centrex Groups.
|
DIGMAN
|
N
|
Y
|
13500
|
0
|
|
5 rules times the number of digman profiles.
|
DIGMAN-PROFILE
|
N
|
Y
|
2700
|
0
|
|
2 times the number of dial plan profiles plus 10 percent of the routes plus 10 percent of the destination ids.
|
DN2CUST-GRP
|
N
|
Y
|
250000
|
0
|
|
Number of supported 800 DNs.
|
DN2GN
|
N
|
Y
|
100
|
0
|
|
Number of DN2GN records. Used when the LNP database is local to the AIN Feature Server.
|
DN2SUBSCRIBER
|
N
|
Y
|
150000
|
0
|
|
Number of DNs. Calculated as 1.5 times the number of subscribers. Rule does not apply to Tandem deployments.
|
DOMAIN2ROUTE
|
N
|
Y
|
1000
|
0
|
|
None.
|
DPC
|
N
|
Y
|
2048
|
0
|
|
256 times the number of OPCs
|
DS1
|
N
|
Y
|
4200
|
0
|
|
Number of DS1s.
|
EMERGENCY-NUMBER-
LIST
|
N
|
Y
|
50
|
0
|
|
None.
|
ENUM-CALL-TYPE
|
N
|
Y
|
100
|
0
|
|
None.
|
ENUM-PROFILE
|
N
|
Y
|
50
|
0
|
|
10 percent of POPs.
|
ESS
|
N
|
Y
|
500
|
0
|
|
Same as number of POPs.
|
EXCHANGE-CODE
|
N
|
Y
|
50000
|
0
|
|
Number of exchange codes.
|
EXT2SUBSCRIBER
|
N
|
Y
|
25000
|
0
|
|
50 times the number of Centrex groups.
|
FEATURE
|
N
|
Y
|
1000
|
0
|
|
None.
|
FEATURE-CONFIG
|
N
|
Y
|
1000
|
0
|
|
Number of configurable parameters.
|
FEATURE-CONFIG-BASE
|
N
|
N
|
1000
|
0
|
|
None.
|
FEATURE-CONFIG-BASE-POS-VAL
|
N
|
N
|
1000
|
0
|
|
None.
|
FEATURE-PROFILE-BASE
|
|
|
|
|
|
|
FEATURE-SERVER
|
N
|
Y
|
10
|
0
|
10
|
None.
|
FS-AUDIT-PROFILE
|
N
|
Y
|
10
|
0
|
10
|
Same as number of Feature Servers .
|
GTD-PARM-VALUES
|
N
|
N
|
100
|
0
|
|
None.
|
H323-GW
|
N
|
Y
|
4
|
0
|
4
|
Fixed at 4 media gateways.
|
H323-GW2GK
|
N
|
Y
|
100
|
0
|
|
25times the number of gateways.
|
H323-TERM
|
N
|
Y
|
10000
|
0
|
|
Number of H323 endpoints (subscribers).
|
H323-TERM-PROFILE
|
N
|
Y
|
200
|
0
|
|
2 times the number of H323 trunk group profiles.
|
H323-TG-PROFILE
|
N
|
Y
|
100
|
0
|
|
None.
|
HTTP-FEATURE-SERVER
|
N
|
Y
|
1
|
0
|
1
|
None.
|
II-RESTRICT-LIST
|
N
|
Y
|
2500
|
0
|
|
10 times 10 percent times the number of customer groups.
|
II-WB-LIST
|
N
|
Y
|
9375
|
0
|
|
12.5 percent of the number of COS restricts. Used for Tandem applications.
|
INTL-DIAL-PLAN
|
N
|
Y
|
60000
|
0
|
|
300 times the number of international dial plan profiles.
|
INTL-DIAL-PLAN-PROFILE
|
N
|
Y
|
200
|
0
|
|
None.
|
INTL-WB-LIST
|
N
|
Y
|
75000
|
0
|
|
10 entries for 10 percent of COS restricts.
|
IPSEC-KERBEROS
|
N
|
Y
|
1
|
0
|
1
|
Only 1 entry is allowed.
|
IPSEC-KERBEROS-KEYS
|
N
|
Y
|
256
|
0
|
|
Based on the krb-max-old-srv-keys values defined in the IPSEC Kerberos table.
|
IPSEC-POLICY
|
N
|
Y
|
1000
|
0
|
|
Same as number of aggregations.
|
IPSEC-SA
|
N
|
Y
|
256
|
0
|
|
None.
|
ISDN-BCHAN
|
N
|
Y
|
36000
60000 (Release 4.5.1)
|
0
|
|
24 times the number of ISDN interfaces.
|
ISDN-DCHAN
|
N
|
Y
|
1500
2500 (Release 4.5.1)
|
0
|
|
Number of ISDN PRIs. In Release 4.5.1, for a medium configuration, throttling allows only 2000 active D-channels to process although the system supports 2500. Only 2000 d-channels are available for use.
|
ISDN-INTF
|
N
|
Y
|
1500
2500 (Release 4.5.1)
|
0
|
|
Number of ISDN PRIs. In Release 4.5.1, for a medium configuration, throttling allows only 2000 active D-channels to process although the system supports 2500. Only 2000 d-channels are available for use.
|
ISDN-TG-PROFILE
|
N
|
Y
|
250
|
0
|
|
Number of ISDN trunk group profiles.
|
IVR-SCRIPT-PROFILE
|
N
|
Y
|
100
|
0
|
|
100 features requiring IVR.
|
LANGUAGE
|
N
|
N
|
1000
|
0
|
|
None.
|
LATA
|
N
|
Y
|
1000
|
0
|
|
Number of LATAs.
|
LATA-MAP
|
N
|
Y
|
150000
|
0
|
|
150 NPAs divided by the number of NPANXXs per LATA.
|
LNP-PROFILE
|
N
|
Y
|
10
|
0
|
10
|
Number of LNP profiles.
|
LSA
|
Y
|
Y
|
30000
|
0
|
|
30 NPAs divided by the number of NXXs per LSA.
|
LSA-PROFILE
|
N
|
N
|
1000
|
0
|
|
Number of local serving areas.
|
MAC2SUB
|
N
|
Y
|
50000
|
0
|
|
Same as AOR2SUB.
|
MGCP-RETCODE-ACTION
|
N
|
Y
|
2000
|
0
|
|
10 codes per MGW profile.
|
MGW
|
N
|
Y
|
100000
|
0
|
|
Number of MTAs divided by the number of MGWs divided by the number of trunking gateways.
|
MGW-PROFILE
|
N
|
Y
|
100
|
0
|
|
Number of MGW profiles.
|
MLHG
|
N
|
Y
|
20000
|
0
|
|
Number of Multiline Hunt groups (MLHGs).
|
MLHG-PREF-LIST
|
N
|
Y
|
2000
|
0
|
|
10 percent of MLHGs.
|
MLHG-TERMINAL
|
N
|
Y
|
100000
|
0
|
|
5 terminals per MLHG.
|
NATIONAL-WB-LIST
|
Y
|
Y
|
94000
|
0
|
|
10 entries for 10 percent of the COS restricts.
|
NDC
|
N
|
Y
|
800
|
0
|
|
Number of supported local area codes.
|
NOA
|
N
|
N
|
0
|
0
|
0
|
Not used.
|
NOD
|
N
|
N
|
100
|
0
|
|
Nature of Dial table.
|
NOD-RESTRICT-LIST
|
N
|
Y
|
1000
|
0
|
|
10 NOD for 10 percent of the features.
|
NOD-WB-LIST
|
N
|
Y
|
7500
|
0
|
|
10 times the 1 percent of the COS restricts.
|
OCB-K-VALUE
|
N
|
Y
|
1350
|
0
|
|
Number of OCB profiles times the number of K-values (9) times the number of Call Types (3).
|
OCB-PROFILE
|
N
|
Y
|
50
|
0
|
|
10 percent of POPs.
|
OFFICE-CODE
|
Y
|
Y
|
50000
|
0
|
|
Number supported office codes.
|
OPC
|
N
|
Y
|
8
|
0
|
8
|
Number of supported OPCs.
|
POLICY-NXX
|
N
|
Y
|
400
|
0
|
|
Number of Policy NXX records.
|
POLICY-ODR
|
Y
|
Y
|
10000
|
0
|
|
Number of Policy ODR records.
|
POLICY-OLI
|
N
|
Y
|
100
|
0
|
|
Number of Policy OLI records.
|
POLICY-PERCENT
|
N
|
Y
|
400
|
0
|
|
Number of Policy Percent records
|
POLICY-POP
|
N
|
Y
|
12500
|
0
|
|
Number of Policy POP records.
|
POLICY-PREFIX
|
N
|
Y
|
10000
|
0
|
|
Number of Policy Prefix entries. 1 entry is allowed per carrier.
|
POLICY-REGION
|
N
|
Y
|
1100
|
0
|
|
Number of Policy Region records.
|
POLICY-TOD
|
N
|
Y
|
400
|
0
|
|
Number of Policy Time of Day records.
|
POP
|
N
|
Y
|
500
|
0
|
|
Number of POPs.
|
PORTED-OFFICE-CODE
|
Y
|
Y
|
640000
|
0
|
|
Number of area codes times 800 NXX codes.
|
QOS
|
N
|
Y
|
1000
|
0
|
|
One QOS record per 100 MTAs (same as number of AGGRs).
|
RADIUS-PROFILE
|
N
|
Y
|
20
|
0
|
|
2 per Call Agent—the primary divided by the secondary.
|
REGION-CODE
|
N
|
Y
|
0
|
800
|
|
Used in NANP installations that require EAOSS signaling.
|
REGION-PROFILE
|
Y
|
Y
|
25000
|
0
|
|
Number of Region Profile entries. Defines regions based on the NPA or the NPA-NXX or the NPA-NXX-X(X)(X)(X).
|
RELEASE-CAUSE
|
N
|
Y
|
10000
|
0
|
|
None.
|
ROUTE
|
N
|
Y
|
2000
|
0
|
|
Number of routes.
|
ROUTE-GUIDE
|
N
|
Y
|
1000
|
0
|
|
Number of route guides (required for Policy Routing).
|
ROUTING-KEY
|
N
|
Y
|
4096
|
0
|
|
2 times the number of DPCs.
|
RUDP-BACKHAUL-
SESSION
|
N
|
Y
|
6000
10000 (Release 4.5.1)
|
0
|
|
4 times the number of ISDN PRIs. In Release 4.5.1, for a medium configuration, throttling allows only 8000 sessions to process although the system supports 10000. Only 8000 sessions are available for use.
|
SC1D
|
N
|
Y
|
20000
|
0
|
|
20 percent of the subscribers with 1 digit speed call.
|
SC2D
|
N
|
Y
|
1000
|
0
|
|
1 percent of the subscribers with 2 digit speed call.
|
SCCP-NW
|
N
|
Y
|
255
|
0
|
|
None.
|
SCCP-ROUTE
|
N
|
Y
|
32768
|
0
|
|
Number of DPC times the number of subsystems.
|
SCRIPT
|
N
|
Y
|
1000
|
0
|
|
None.
|
SCTP-ASSOC
|
N
|
Y
|
240
|
0
|
|
2 times the number of SCTP association profiles.
|
SCTP-ASSOC-PROFILE
|
N
|
Y
|
120
|
0
|
|
3 times the number of SGPs (1 for each platform).
|
SERVICE
|
N
|
Y
|
2000
|
0
|
|
Number of services.
|
SERVICE-PROVIDER
|
N
|
Y
|
1000
|
0
|
|
Number of service providers. Used primarily for Tandem or route server configurations.
|
SERVICE-TRIGGER
|
N
|
Y
|
20000
|
0
|
|
10 triggers per service.
|
SERVING-DOMAIN-NAME
|
N
|
Y
|
1000
|
0
|
|
Number of supported serving domains.
|
SG
|
N
|
Y
|
20
|
0
|
|
None.
|
SG-GRP
|
N
|
Y
|
20
|
0
|
|
1 SG per pair.
|
SGP
|
N
|
Y
|
40
|
0
|
|
2 SGPs per SG.
|
SIPT-ISUP-VER-ALIAS
|
N
|
Y
|
200
|
0
|
|
None.
|
SLE
|
N
|
Y
|
20000
|
0
|
|
20 entries per feature (1 feature) for 1 percent of the subscribers.
|
SLHR
|
N
|
Y
|
96
|
32
|
|
Number of services times the number of OPCs.
|
SLHR-PROFILE
|
N
|
N
|
16
|
0
|
|
Number of SCCP based services.
|
SOFTSW-TG-PROFILE
|
N
|
Y
|
100
|
0
|
|
Number of SIP (Soft Switch) trunk group profiles.
|
SPECIAL-CALL-TYPE
|
N
|
Y
|
100
|
0
|
|
Number of special call type entries.
|
SPLIT-NPA
|
N
|
Y
|
1100
|
0
|
|
Number of Split NPA records.
|
SS7_Q761_TG_PROFILE
|
N
|
Y
|
100
|
0
|
|
None.
|
SS7_Q767_TG_PROFILE
|
N
|
Y
|
100
|
0
|
|
None.
|
SS7-ANSI-TG-PROFILE
|
N
|
Y
|
100
|
0
|
|
None.
|
SS7-CIC
|
N
|
Y
|
96000
|
0
|
|
Maximum number of supported SS7 CICs.
|
STATIC-CONTACT
|
N
|
Y
|
5000
|
0
|
|
10 percent of SIP subscribers configured with static contact.
|
SUBSCRIBER
|
N
|
Y
|
100000
|
0
|
|
Maximum number of supported subscribers.
|
SUBSCRIBER-FEATURE-DATA
|
N
|
Y
|
600000
|
0
|
|
3 feature data records per subscriber.
|
SUBSCRIBER-PROFILE
|
N
|
Y
|
5000
|
0
|
|
10 subscriber profiles per POP.
|
SUBSCRIBER-SERVICE-PROFILE
|
N
|
Y
|
500000
|
0
|
|
Number of service records based on number of subscribers.
|
SUBSCRIBER-TOD-SCHEDULE
|
N
|
Y
|
1000
|
0
|
|
1 percent of subscribers requiring a time of day (TOD) schedule.
|
SUBSYSTEM
|
N
|
Y
|
16
|
0
|
|
Number of supported subystems.
|
SUBSYSTEM-PROFILE
|
N
|
Y
|
16
|
0
|
|
Number of supported subystems.
|
TECH-PREFIX-GRP
|
N
|
Y
|
1000
|
0
|
|
Number of technical prefix records. Used in H323 networks.
|
TECH-PREFIX-GRP-
PROFILE
|
N
|
Y
|
4
|
0
|
4
|
Number of configurable H323 gateways on Cisco BTS 10200 Softswitch.
|
TERMINATION
|
N
|
Y
|
180000
|
0
|
|
Maximum number of supported terminations.
|
TIMEZONE
|
N
|
N
|
200
|
0
|
|
None.
|
TRIGGER-DETECTION-
POINT
|
N
|
N
|
50
|
0
|
|
None.
|
TRIGGER-ID
|
N
|
N
|
100
|
0
|
|
None.
|
TRIGGER-NOD-ESCAPE-
LIST
|
N
|
Y
|
100
|
0
|
|
None.
|
TRUNK
|
N
|
Y
|
100000
|
0
|
|
Number of supported trunks.
|
TRUNK-GRP
|
N
|
Y
|
10000
|
0
|
|
Number of trunk groups.
|
TRUNK-GRP-FEATURE-
DATA
|
N
|
Y
|
1000
|
0
|
|
10 percent times the number of trunk groups. Used in Tandem applications.
|
TRUNK-GRP-SERVICE-PROFILE
|
N
|
Y
|
1100
|
0
|
|
11percent times the number of trunk groups.
|
USER-AUTH
|
N
|
Y
|
50000
|
0
|
|
Same as number of AOR2SUB records
|
USER-PART-VARIANT
|
N
|
Y
|
200
|
0
|
|
None.
|
VAR-DEFAULT
|
N
|
N
|
1000
|
0
|
|
None.
|
VSC
|
N
|
Y
|
1000
|
0
|
|
Vertical Service Code table.
|
WIRETAP
|
Y
|
Y
|
2500
|
0
|
|
2 percent of subscribers.
|
ZZZ-CODE
|
N
|
Y
|
0
|
500
|
|
ZZZ Code table is used in NANP installations that require EAOSS signaling.
|
Common Database Usage Defaults and Sizing Rules