4.470 rtrv-data-rtdb
This command retrieves data from the RTDB on an active Service Module card. If the loc parameter is specified and the target card is an active Service Module card, the RTDB data is retrieved from that card. If the loc parameter is not specified, the data is retrieved on the active Service Module card that has the lowest IMT address. The RTDB status on the active Service Module card can be coherent or incoherent.
For LNP database items (TN) all Service Module cards are queried for the existence of the specified item. Either the Service Module card specified by the loc parameter or the Service Module card with the lowest IMT address returns full item information. Any remaining Service Module cards return either COHERENT or INCOHERENT if the item is found in the RTDB on the card.
Parameters
- loc (optional)
- The card location as stenciled on the shelf of the system.
- Range:
- 1101 - 1108, 1111 - 1117, 1201 - 1208, 1211 - 1218, 1301 - 1308, 1311 - 1318, 2101 - 2108, 2111 - 2118, 2201 - 2208, 2211 - 2218, 2301 - 2308, 2311 - 2318, 3101 - 3108, 3111 - 3118, 3201 - 3208, 3211 - 3218, 3301 - 3308, 3311 - 3318, 4101 - 4108, 4111 - 4118, 4201 - 4208, 4211 - 4218, 4301 - 4308, 4311 - 4318, 5101 - 5108, 5111 - 5118, 5201 - 5208, 5211 - 5218, 5301 - 5308, 5311 - 5318, 6101 - 6108, 6111 - 6118
Example
rtrv-data-rtdb:tn=9194663133
rtrv-data-rtdb:npanxx=919466
rtrv-data-lrn=9194460000
rtrv-data-rtdb:imsi=12345
rtrv-data-rtdb:dn=12345
rtrv-data-rtdb:entity=abcdefabcdefabc
Retrieve DN information from a specific Service Module card.rtrv-data-rtdb:dn=19195554444:loc=1107
Retrieve entity data from a specific Service Module card.rtrv-data-rtdb:entity=12345:loc=1107
Dependencies
The specified card location must be equipped in the database.
At least one of the imsi, dn, entity, imei, entitytype, npanxx, lrn, or tn parameters must be specified.
Only one of the tn, lrn, or npanxx parameters can be specified in the command.
If the npanxx, lrn, or tn parameter is specified, the LNP ELAP Configuration feature must be on.
If the AINPQ, EIR, G-Flex, G-Port, INP, Prepaid IDP Relay Query, Prepaid SMS Intercept Ph1 (PPSMS), or V-Flex feature is turned on, or the ATINP feature is enabled, then the imsi, dn, entity, imei, or entitytype parameter must be specified.
If the imsi parameter is specified, then the G-Flex, EIR, or S13 feature must be turned on.
The G-Flex, G-Port, or V-Flex feature must be turned on, or the ATINP feature must be enabled before the entity parameter can be specified.
If the entitytype parameter is specified, the entity parameter must be specified.
If the imei parameter is specified, the EIR or S13 feature must be turned on.
The destination specified by the loc parameter must correspond to a Service Module card running the VSCCP application.
The destination specified by the loc parameter must correspond to a Service Module card that is IS-NR.
A primary Service Module card must be provisioned.
An EPAP-related feature must be turned on before the entity, entitytype, or dn parameter can be specified.
The value specified by the loc parameter must indicate a DN or IMSI card before the dn or imsi parameter can be specified, respectively.
Notes
For DN and DN Block entries, whichever entity is provisioned in the order of SP/RN, VMSID, GRN, will become EntIdx1.
MTT 2376 DELETED. M Buckland
Output
Note:
A value of "---" in the TT column indicates that the service does not have a translation type defined in the EAGLE and that call processing will ignore the override data displayed.This example retrieves LRN Data:
rtrv-data-rtdb:lrn=1111111111
tekelecstp 09-08-30 15:23:45 EST EAGLE 41.1.0
Card Loc : 1103 Status:Coherent
Card Loc: 1103
LRN SP
1111111111 tklc
SERV TT XLAT RI PCA SSN NGT RGTA
CLASS 10 DPCSSN GT 002-002-002 2 --- yes
WSMSC 11 DPCSSN SSN 010-010-010 10 --- no
;
This example retrieves NPANXX Data:
rtrv-data-rtdb:npanxx=919225
tekelecstp 09-08-30 15:37:36 EST EAGLE 41.1.0
Card Loc : 1103 Status:Coherent
Card Loc: 1103
NPANXX MR LRN
919225 yes yes LA LI
SERV TT XLAT RI PCA SSN NGT RGTA
AIN --- DPC GT -------------- --- --- no
IN --- DPC GT -------------- --- --- no
CLASS 10 DPCSSN SSN 007-007-007 7 --- no
;
This example retrieves TN Data:
rtrv-data-rtdb:tn=9192252645
tekelecstp 09-08-30 15:38:56 EST EAGLE 41.1.0
Card Loc : 1103 Status:Coherent
Card Loc: 1103
TN SP LRN PTYPE
9192252645 tklc 1111111111 none LA LI
SERV TT XLAT RI PCA SSN NGT RGTA
LIDB --- DPCSSN SSN 003-003-003 3 --- no
ISVM --- DPCSSN SSN 004-004-004 4 --- no
;
This example retrieves IMSI Data:
rtrv-data-rtdb:imsi=12345
tekelecstp 08-05-11 07:55:28 EST EAGLE5 39.0.0
Card Loc : 1105 Status : Coherent
IMSI EntIdx IMEI Index
12345 H'00000002 H'00000006
Entity Address Type PC(NATL-gg) RI SSN TT NP NAI DA
abcdef123456abc SP 02000 SSN 122 000 00 000 prefix
SRFIMSI NSSN CCGT NTT NNP NNAI
1234567890abcde yes no no no no
IMEI VERSION BLACK GRAY WHITE
12345678901234 0 yes yes yes
;
This example retrieves Entity data:
rtrv-data-rtdb:entity=abcdef123456abc
tekelecstp 09-08-30 07:53:00 EST EAGLE5 41.1.0
INFO: Default value of Entity Type is : SP
;
tekelecstp 06-03-30 07:53:00 EST EAGLE5 35.0.0
Card Loc : 1105 Status : Coherent
Entity Address Type PC(NATL-gg) RI SSN TT NP NAI DA SRFIMSI
abcdef123456abc SP 02000 SSN 122 000 00 000 prefix 1234567890abcde
NSSN CCGT NTT NNP NNAI
yes no no no no
;
This example retrieves IMEI data:
rtrv-data-rtdb:imei=12345678abcdef
tekelecstp 06-03-30 07:54:55 EST EAGLE5 35.0.0
Card Loc : 1105 Status : Coherent
IMEI VERSION BLACK GRAY WHITE
12345678abcdef 0 yes no yes
;
This example retrieves data for a DN associated with two NEs:
rtrv-data-rtdb:dn=111111111111111
tekelecstp 08-08-11 07:56:48 EST EAGLE5 39.1.0
Card Loc : 1103 Status:Coherent
DN Portability Type (255)
111111111111111 No portability type
EntIdx1 EntIdx2
H'00000007 H'00000005
Entity Address Type PC(INTL ) RI SSN TT NP NAI DA
bcda4321 RN 5-005-5 GT 000 000 00 000 none
SRFIMSI NSSN CCGT NTT NNP NNAI
no no no no no
Entity Address Type PC(ANSI ) RI SSN TT NP NAI DA
abcd1234 VMSID -------------- GT 000 000 00 000 none
SRFIMSI NSSN CCGT NTT NNP NNAI
no no no no no
ASD Address: 1234567890
;
This example retrieves DN data from a specific Service Module card:
rtrv-data-rtdb:dn=19195554444:loc=1107
tekelecstp 08-08-26 14:03:15 EST EAGLE5 39.1.0
Card Loc : 1107 Status:Coherent
DN Portability Type ( 1) Entity Index
19195554444 Own Number ported out H'0000513d
Entity Address Type PC(ANSI ) RI SSN TT NP NAI DA
1234 RN -------------- GT 000 000 00 000 none
SRFIMSI NSSN CCGT NTT NNP NNAI
no no no no no
ASD Address: 1234567890
;
This example retrieves DN data associated with one NE:
rtrv-data-rtdb:dn=12345
tekelecstp 08-08-18 07:56:48 EST EAGLE5 39.1.0
Card Loc : 1101 Status:Coherent
DN Portability Type (255)
12345 No portability type
EntIdx1 EntIdx2
------- -------
ASD Address: 1234567890
;
This example retrieves DN data when the data is non-ported:
rtrv-data-rtdb:dn=d1000
tklc1090203 08-10-20 10:57:33 EST EAGLE 40.0.0
Card Loc : 1215 Status:Coherent
DN Portability Type ( 36)
d1000 Not Identified to be ported
EntIdx1 EntIdx2
------- -------
ASD Address: abcd0
;
This example retrieves data for a DN associated with one NE, one ASD and one NS:
rtrv-data-rtdb:dn=2324567893
tekelecstp 09-04-11 07:56:48 EST EAGLE5 41.0.0
Card Loc : 1103 Status:Coherent
DN Portability Type (255) Category
2324567893 No portability type Private
EntIdx
H'00000007
Entity Address Type PC(INTL ) RI SSN TT NP NAI DA
bcda4321 RN 5-005-5 GT 000 000 00 000 none
SRFIMSI NSSN CCGT NTT NNP NNAI
no no no no no
ASD Address: 1234567890
NS Address NS Category
2312457895 Public
;
This example retrieves data for a non-ported DN associated with one ASD and one NS:
rtrv-data-rtdb:dn=1347823456
tekelecstp 09-04-11 07:56:48 EST EAGLE5 41.0.0
Card Loc : 1105 Status:Coherent
DN Portability Type ( 36) Category
1347823456 Not Identified to be ported Public
EntIdx
-------
ASD Address: 1234545367
NS Address NS Category
1345692324 Private
;
This example retrieves data for a DN located in a non-ranged entry and listed as an A-Party Blacklisted private number:
rtrv-data-rtdb:dn=123456
tekelecstp 09-06-18 07:56:48 EST EAGLE5 41.1.0
Card Loc : 1101 Status:Coherent
DN Portability Type (255) Category
123456 No portability type Private
A-Pty Blk
This example retrieves data for a DN located in a ranged entry and listed as an A-Party Blacklisted public number:
rtrv-data-rtdb:dn=123456
tekelecstp 09-06-18 07:56:48 EST EAGLE5 41.1.0
Card Loc : 1101 Status:Coherent
BEG DNBLK END DNBLK Portability Type (255) Category
112233 4455667 No portability type Public
A-Pty Blk
This example retrieves NPANXX split data:
rtrv-data-rtdb:npanxx=919111
tekelecstp 09-08-30 15:37:36 EST EAGLE 41.1.0
Card Loc : 1103 Status:Coherent
Card Loc: 1103
NPANXX MR LRN
OLD 919111 yes no LA LI
NEW 918111 yes yes LA LI
Default Data
SERV TT XLAT RI PCA SSN NGT RGTA
LIDB --- DPC GT 001-001-001 --- --- no
;
Legend
- Card Loc—Location of the card that contains the retrieved information
- Status—RTDB database status; Coherent or Incoherent
- IMSI—International Mobile Subscriber Identity
- EntIdx, EntIdx1, EntIdx2—Hexadecimal index where the Network Entity data is stored in the Entity Bucket on the Service Module card
- IMEI Index—Hexadecimal index at which the IMEI data is stored in the IMEI Bucket on the Service Module card or S13 card running DEIRHC GPL.
- Entity Address—Hexadecimal Network Entity address
- Type—Network Entity type; Service Provider (SP), Routing Number (RN), Voice Mail Server ID (VMSID) or Generic Routing Number (GRN)
- PC (type of PC)—Point code and type of point code (ANSI; NATL - ITU National with or without group code (-gg)
- RI—Routing Indicator
- SSN—Subsystem Number
- TT—Translation Type
- NP—Numbering Plan
- DA—Digits action (Prefix, Suffix, or none)
- SRFIMSI—Signaling Relay Function IMSI
- IMSI—International Mobile Subscriber Identity.
- NSSN—New Subsystem Number (yes or no)
- CCGT—Cancel GT (yes or no)
- NTT—New Translation Type
- NNP—New Numbering Plan
- NNAI—New Nature of Address Indicator.
- IMEI—International Mobile Equipment Identity
- VERSION—IMEI data version
- BLACK, WHITE, GRAY—Equipment Identity Register search lists
- DN—Dialed Number
- ASD Address—Additional Subscriber Data address
- Portability Type (number)—
- 0—Not known to be ported
- 1—Own number ported out
- 2—Foreign number ported to Foreign network
- 3—Prepaid Short Message Service (PPSMS) subscriber on server #1
- 4—PPSMS subscriber on server #2
- 5—IS41 to GSM migrated subscriber with only GSM handset active
- 6—PPSMS subscriber on server #3
- 7—PPSMS subscriber on server #4
- 8—PPSMS subscriber on server #5
- 9—PPSMS subscriber on server #6
- 10—PPSMS subscriber on server #7
- 11—PPSMS subscriber on server #8
- 12—PPSMS subscriber on server #9
- 13—PPSMS subscriber on server #10
- 14—PPSMS subscriber on server #11
- 15—PPSMS subscriber on server #12
- 16—PPSMS subscriber on server #13
- 17—PPSMS subscriber on server #14
- 18—PPSMSsubscriber on server #15
- 19—PPSMS subscriber on server #16
- 20—PPSMS subscriber on server #17
- 21—PPSMS subscriber on server #18
- 22—PPSMS subscriber on server #19
- 23—PPSMS subscriber on server #20
- 24—PPSMS subscriber on server #21
- 25—PPSMS subscriber on server #22
- 26—PPSMS subscriber on server #23
- 27—PPSMS subscriber on server #24
- 28—PPSMS subscriber on server #25
- 29—PPSMS subscriber on server #26
- 30—PPSMS subscriber on server #27
- 31—PPSMS subscriber on server #28
- 32—PPSMS subscriber on server #29
- 33—PPSMS subscriber on server #30
- 34—PPSMS subscriber on server #31
- 35—PPSMS subscriber on server #32
- 36—Not Identified to be ported
- 255—No portability type
- NS Address—Address of the associated DN, used for Number Substitution
- NS Category—Category of the associated DN, used for Number Substituion
- NPA—Number Planning Area (Area Code)
- NXX—Exchange Code