The Query Server database consists of replicated copies of the LSMS LNP database tables listed in Table 1, Table 2, and Table 3.
Regional (<Region>) DB) LNP Database Tables | Fields | |||
---|---|---|---|---|
SubscriptionVersion | versionID | tn | lrn | newCurrentSp |
classDPC | classSSN | lidbDPC | lidbSSN | |
isvmDPC | isvmSSN | cnamDPC | cnamSSN | |
wsmscDPC | wsmscSSN | LnpType | billingId | |
endUserLocation Value | endUserLocation Type | activation Timestamp | downloadReason | |
SVType | alternativeSPID | |||
NumberPoolBlock | blockId | npanxx_x | lrn | newCurrentSP |
classDPC | classSSN | lidbDPC | lidbSSN | |
isvmDPC | isvmSSN | cnamDPC | cnamSSN | |
wsmscDPC | wsmscSSN | activationTimestamp | downloadReason | |
SVType | alternativeSPID | |||
ServiceProvLRN | serviceProviderId | id | lrn | creationTimeStamp |
downloadReason | ||||
ServiceProv NPA_NXX | serviceProviderId | id | npanxx | creationTimeStamp |
effectiveTimeStamp | downloadReason | |||
ServiceProv NPA_NXX_X | serviceProviderId | id | npanxx_x | creationTimeStamp |
effectiveTimeStamp | modifiedTime Stamp | downloadReason | ||
ServiceProvNetwork | serviceProvId | serviceProvName | serviceProvType | |
Where <Region> is one of the following: | Canada | MidAtlantic | Midwest | Northeast |
Southeast | Southwest | WestCoast | Western |
Supplemental (supDB) LNP Database Tables | Fields | |||
---|---|---|---|---|
DefaultGtt | groupName | npanxx | spid | |
ain_set | ain_tt | ain_dpc | ain_ssn | |
ain_xlat | ain_ri | ain_ngt | ain_rgta | |
in_set | in_tt | in_dpc | in_ssn | |
in_xlat | in_ri | in_ngt | in_rgta | |
class_set | class_tt | class_dpc | class_ssn | |
class_xlat | class_ri | class_ngt | class_rgta | |
lidb_set | lidb_tt | lidb_dpc | lidb_ssn | |
lidb_xlat | lidb_ri | lidb_ngt | lidb_rgta | |
isvm_set | isvm_tt | isvm_dpc | isvm_ssn | |
isvm_xlat | isvm_ri | isvm_ngt | isvm_rgta | |
cnam_set | cnam_tt | cnam_dpc | cnam_ssn | |
cnam_xlat | cnam_ri | cnam_ngt | cnam_rgta | |
wsmsc_set | wsmsc_tt | wsmsc_dpc | wsmsc_ssn | |
wsmsc_xlat | wsmsc_ri | wsmsc_ngt | wsmsc_rgta | |
OverrideGtt | groupName | lrn | spid | |
class_set | class_tt | class_dpc | class_ssn | |
class_xlat | class_ri | class_ngt | class_rgta | |
lidb_set | lidb_tt | lidb_dpc | lidb_ssn | |
lidb_xlat | lidb_ri | lidb_ngt | lidb_rgta | |
isvm_set | isvm_tt | isvm_dpc | isvm_ssn | |
isvm_xlat | isvm_ri | isvm_ngt | isvm_rgta | |
cnam_set | cnam_tt | cnam_dpc | cnam_ssn | |
cnam_xlat | cnam_ri | cnam_ngt | cnam_rgta | |
wsmsc_set | wsmsc_tt | wsmsc_dpc | wsmsc_ssn | |
wsmsc_xlat | wsmsc_ri | wsmsc_ngt | wsmsc_rgta | |
NpaSplit | oldNpa | newNpa | nxx | startPDP |
endPDP | region | status | ||
LsmsServiceProvider | spid | description | contactInfo |
Supplemental (supDB) LNP Database Tables | Fields | |||
---|---|---|---|---|
GttGroup | name | description | ||
ain_set | ain_tt | ain_dpc | ain_ssn | |
ain_xlat | ain_ri | ain_ngt | ain_rgta | |
in_set | in_tt | in_dpc | in_ssn | |
in_xlat | in_ri | in_ngt | in_rgta | |
class_set | class_tt | class_dpc | class_ssn | |
class_xlat | class_ri | class_ngt | class_rgta | |
lidb_set | lidb_tt | lidb_dpc | lidb_ssn | |
lidb_xlat | lidb_ri | lidb_ngt | lidb_rgta | |
isvm_set | isvm_tt | isvm_dpc | isvm_ssn | |
isvm_xlat | isvm_ri | isvm_ngt | isvm_rgta | |
cnam_set | cnam_tt | cnam_dpc | cnam_ssn | |
cnam_xlat | cnam_ri | cnam_ngt | cnam_rgta | |
wsmsc_set | wsmsc_tt | wsmsc_dpc | wsmsc_ssn | |
wsmsc_xlat | wsmsc_ri | wsmsc_ngt | wsmsc_rgta | |
EmsInterface | clli | emsType | primaryAddress | secondaryAddress |
mateClii | pointCode | matePointCode | capabilityPoint Code | |
gttGroup | tnFilter | ownerSpid | componentInfo | |
contactInfo | dcmAddress | retryinterval | retryCount | |
pingMethod | ||||
TnFilter | spid | name | description | filterType |
regions | npanxxType | npanxxs | ||
NpacRegion | region | npacSmsName | lsmsPsel | lsmsSsel |
lsmsTsel | lsmsNsap | primaryNpacPsel | primaryNpacSsel | |
primaryNpacTsel | primaryNpacNsap | primaryNpac FtpAddress | secondaryNpac Psel | |
secondaryNpacSsel | secondaryNpacTsel | secondaryNpac Nsap | secondaryNpac FtpAddress | |
active | componentInfo | contactInfo | lastChanged Timestamp | |
currentNpac | ||||
<Region>Npac Measurements | yyyydddhh | Binds | SuccessOps | FailedOps |
<Clii>Eagle Measurements | yyyydddhh | |||
updTnSuccess | updTnFail | DelTnSuccess | DelTnFail | |
updDGttSuccess | updDGttFail | DelDGttSuccess | DelDGttFail | |
updOGttSuccess | updOGttFail | DelOGttSuccess | DelOGttFail | |
updSplitSuccess | updSplitFail | DelSplitSuccess | DelSplitFail | |
Binds | LsmsRetries | NERetries | ||
<Region>PublicKey | id | listId | keyId | status |
exponent | modulus | |||
<Region>PrivateKey | id | listId | keyId | status |
keyval | ||||
LsmsUser | name | golden | groupName | inactivityTimeout |
LsmsUserSpid | lsmsUser | spid | ||
Where <Region> is one of the following: | Canada | MidAtlantic | Midwest | Northeast |
Southeast | Southwest | WestCoast | Western | |
Where <Clii> is the Common Language Location Indicator of the EMS/EAGLE to which that LSMS is connected. |
<Region>PublicKey
<Region>PrivateKey
LsmsUser
LsmsUserSpid
To replicate these tables, refer to the Note in Step 1 of the topic, “MySQL Replication Configuration for Query Servers” in Appendix A of the Configuration Guide.