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

dn (optional)
Dialed Number.
Range:
5 - 15 digits
entity (optional)
Network Entity.
Range:
1 - 15 digits
entitytype (optional)
Entity Type.
Range:
sp
Service Provider: Any 10-digit TN
rn
Routing Number: Any 10-digit TN
vmsid
Voice Mail Server ID: Any 1-15 digit hexadecimal number
grn
Generic Routing Number: Any 1-15 digit hexadecimal number
imei (optional)
International Mobile Equipment Identity.
Range:
14 digits
imsi (optional)
International Mobile Subscriber Identity.
Range:
5 - 15 digits
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
lrn (optional)
Location Routing Number.
Range:
10 digits
npanxx (optional)
Numbering Plan Area.
Range:
6 digits
tn (optional)
Telephone Number.
Range:
10 digits

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