IBM Tivoli Netcool Service Quality Manager Data Mediation Gateway Development

44 IBM Tivoli Netcool Service Quality Manager Data Mediation Gateway Development

3.1 Identifying the data source

The standard Motorola GGSN vendor subsystem v50 release gateway parses

raw performance data in the CSV file format. Refer to “A sample Motorola GGSN

CSV file” on page 76 for a sample of this raw performance data file.

The installed gateway configuration produces LIF files that are meant to be used

with Performance Manager for Wireless loaders. Hence, further changes to the

gateway configuration is necessary in order for it to produce the CSV file format

that is required by the Service Quality Manager adapters. The Service Quality

Manager adapters require the input file to be a CSV file with a name conforming

to the 3GPP standard for time stamp.

We discuss data source information in the following sections:

򐂰 “Input specification for GPRS Technology Pack” on page 44

򐂰 “GPRS Service Solution interface control guide” on page 47

򐂰 “Mapping of data from gateway and adapters” on page 50

3.1.1 Input specification for GPRS Technology Pack

To develop a gateway module, we must understand the input file format. You can

get the format from the customer or the technology vendor. As an example, we

are using the Motorola GGSN gateway configuration from the GPRS Technology

Pack. Apart from the gateway configuration, every Technology Pack also includes

a functional specification document. We extract the input file specification from

the functional specification, as shown in Table 3-1.

Table 3-1 Raw data field names

Number CSV field name Usage

0 systemName GGSN_ID

1 systemIPAddress Part of APN_ID

2 index Part of APN_ID

3 day Header date

4 startTime Header start time

5 endTime Header end time

6 cgprsAccPtActivePdps Not used

7 cgprsAccPtDestAddrViolTpdus Not used

Chapter 3. Gateway development 45

8 cgprsAccPtDhcpAddrReleases Not used

9 cgprsAccPtDhcpAddrRequests Not used

10 cgprsAccPtDownstreamPacketCount Not used

11 cgprsAccPtGgsnDeactivatedPdps Not used

12 cgprsAccPtIpv6DownstreamPackets Not used

13 cgprsAccPtIpv6DownstreamTrafficVolume Not used

14 cgprsAccPtIpv6GgsnDeactivatedPdps Not used

15 cgprsAccPtIpv6GgsnSuccDeactivatedPdps Not used

16 cgprsAccPtIpv6MsActivatedDynPdps Not used

17 cgprsAccPtIpv6MsActivatedPdps Not used

18 cgprsAccPtIpv6MsDeactivatedPdps Not used

19 cgprsAccPtIpv6MsSuccActivatedDynPdps Not used

20 cgprsAccPtIpv6MsSuccActivatedPdps Not used

21 cgprsAccPtIpv6MsSuccDeactivatedPdps Not used

22 cgprsAccPtIpv6NetworkInitDeactPdps Not used

23 cgprsAccPtIpv6NetworkInitDeactSuccPdps Not used

24 cgprsAccPtIpv6UpstreamPackets Not used

25 cgprsAccPtIpv6UpstreamTrafficVolume Not used

26 cgprsAccPtMsActivatedDynPdps The usage of these fields

are discussed in Table 3-2

on page 46.

27 cgprsAccPtMsActivatedPdps

28 cgprsAccPtMsDeactivatedPdps

29 cgprsAccPtNetworkInitPdps

30 cgprsAccPtRedirInterMobilTraffic Not used

31 cgprsAccPtRevDownstrTrafficVol Not used

32 cgprsAccPtRevUpstreamTrafficVol Not used

33 cgprsAccPtSourceAddrViolTpdus Not used

34 cgprsAccPtSuccDhcpAddrRequests Not used

Number CSV field name Usage

46 IBM Tivoli Netcool Service Quality Manager Data Mediation Gateway Development

Using the fields in Table 3-1 on page 44, the necessary calculation for producing

KPIs are listed in Table 3-2. The field names in Table 3-2 are truncated, as we

omit the prefix cgprsAccPt. Also, the data in Table 3-2 is put in the PIF data block

called cgprsAccPtStatisticsEntry. Table 3-2 lists the information that must be

produced from the raw file that will be processed by the Technology Pack

gateway. We will use this for our gateway mapping process to define KPI

attributes.

Table 3-2 Fields data related to GPRS Core GGSN for Motorola

35 cgprsAccPtSuccGgsDeactivatedPdps Not used

36 cgprsAccPtSuccMsActivatedDynPdps The usage of these fields

are discussed in Table 3-2

on page 46.

37 cgprsAccPtSuccMsActivatedPdps

38 cgprsAccPtSuccMsDeactivatedPdps

39 cgprsAccPtSuccNetworkInitPdps

40 cgprsAccPtUpstreamPacketCount Not used

Number CSV field name Usage

Field name Expression® or mapping Description

GGSN_ID systemName A unique identifier for the GGSN

APN_ID systemIPAdress&”:”&index A unique identifier for the APN

SuccessfulPDPActivation SuccMsActivatedPdps+

SuccMsActivatedDynPdps+

SuccNetworkInitPdps

The total successful PDP activations

SuccMsActivatedPdps SuccMsActivatedPdps The total number of successfully completed

PDP context activation procedures initiated by

MS® on this APN

SuccMsActivatedDynPdps SuccMsActivatedDynPdps The total number of successfully completed

dynamic PDP context activation procedures

initiated by MS on this APN

SuccNetworkInitPdps SuccNetworkInitPdps The total number of successfully completed

network initiated PDP context activation

procedures

AttemptsPDPActivation MsActivatedPdps+

MsActivatedDynPdps+

NetworkInitPdps

The total attempted PDP activations