76 IBM Tivoli Netcool Service Quality Manager Data Mediation Gateway Development
A sample Motorola GGSN CSV file
Example A-1 lists a sample Motorola GGSN CSV file.
Example: A-1 Sample GGSN raw data
systemName,systemIPAddress,index,day,startTime,endTime,cgprsAccPtActive
Pdps,cgprsAccPtDestAddrViolTpdus,cgprsAccPtDhcpAddrReleases,cgprsAccPtD
hcpAddrRequests,cgprsAccPtDownstreamPacketCount,cgprsAccPtGgsnDeactivat
edPdps,cgprsAccPtIpv6DownstreamPackets,cgprsAccPtIpv6DownstreamTrafficV
olume,cgprsAccPtIpv6GgsnDeactivatedPdps,cgprsAccPtIpv6GgsnSuccDeactivat
edPdps,cgprsAccPtIpv6MsActivatedDynPdps,cgprsAccPtIpv6MsActivatedPdps,c
gprsAccPtIpv6MsDeactivatedPdps,cgprsAccPtIpv6MsSuccActivatedDynPdps,cgp
rsAccPtIpv6MsSuccActivatedPdps,cgprsAccPtIpv6MsSuccDeactivatedPdps,cgpr
sAccPtIpv6NetworkInitDeactPdps,cgprsAccPtIpv6NetworkInitDeactSuccPdps,c
gprsAccPtIpv6UpstreamPackets,cgprsAccPtIpv6UpstreamTrafficVolume,cgprsA
ccPtMsActivatedDynPdps,cgprsAccPtMsActivatedPdps,cgprsAccPtMsDeactivate
dPdps,cgprsAccPtNetworkInitPdps,cgprsAccPtRedirInterMobilTraffic,cgprsA
ccPtRevDownstrTrafficVol,cgprsAccPtRevUpstreamTrafficVol,cgprsAccPtSour
ceAddrViolTpdus,cgprsAccPtSuccDhcpAddrRequests,cgprsAccPtSuccGgsDeactiv
atedPdps,cgprsAccPtSuccMsActivatedDynPdps,cgprsAccPtSuccMsActivatedPdps
,cgprsAccPtSuccMsDeactivatedPdps,cgprsAccPtSuccNetworkInitPdps,cgprsAcc
PtUpstreamPacketCount
gs1-ggsn-3,212.47.101.248,3,07Oct2008,56420,57320,1826,0,0,0,5268959,14
7,,,,,,,,,,,,,,,762,762,636,0,0,4543225140,703822395,4012,0,148,763,763
,635,0,4923866
gs1-ggsn-3,212.47.101.248,1000,07Oct2008,56420,57320,0,0,0,0,0,0,,,,,,,
,,,,,,,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
gs1-ggsn-3,212.47.101.248,46,07Oct2008,56420,57320,0,0,0,0,0,0,,,,,,,,,
,,,,,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
gs1-ggsn-3,212.47.101.248,1,07Oct2008,56420,57320,0,0,0,0,0,0,,,,,,,,,,
,,,,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
gs1-ggsn-3,212.47.101.248,253,07Oct2008,56420,57320,66,0,0,0,63526,9,,,
,,,,,,,,,,,,34,34,31,0,0,39535903,15369164,0,0,9,35,35,31,0,93194
Sample first level PIF data file
A sample first level PIF is shown in Example A-2 on page 77.
Appendix A. Sample data and programs listing for gateways 77
Example: A-2 Sample first level PIF
## Parser Intermediate File
##START|HEADER
day|startTime|BLOCKNAME|endTime|FILENAME|systemName
14Oct2008|28800|cgprsAccPtStatisticsEntry|29700|PassiveCollector-IBM.pm
gw_cgprsAccPtStatisticsEntry_14_10_2008_08_25_23.csv|gs1-ggsn-3
##END|HEADER
##START|cgprsAccPtStatisticsEntry
|cgprsAccPtDownstreamPacketCount|cgprsAccPtIpv6MsSuccActivatedPdps|cgpr
sAccPtUpstreamPacketCount|cgprsAccPtDestAddrViolTpdus|cgprsAccPtDhcpAdd
rReleases|cgprsAccPtIpv6NetworkInitDeactSuccPdps|cgprsAccPtSourceAddrVi
olTpdus|cgprsAccPtGgsnDeactivatedPdps|cgprsAccPtNetworkInitPdps|cgprsAc
cPtRevUpstreamTrafficVol|cgprsAccPtIpv6DownstreamTrafficVolume|cgprsAcc
PtSuccDhcpAddrRequests|cgprsAccPtIpv6UpstreamPackets|cgprsAccPtIpv6MsSu
ccActivatedDynPdps|cgprsAccPtActivePdps|cgprsAccPtMsActivatedDynPdps|cg
prsAccPtMsActivatedPdps|cgprsAccPtIpv6MsActivatedDynPdps|cgprsAccPtIpv6
GgsnSuccDeactivatedPdps|cgprsAccPtSuccMsActivatedDynPdps|index|cgprsAcc
PtSuccGgsDeactivatedPdps|cgprsAccPtRedirInterMobilTraffic|cgprsAccPtIpv
6UpstreamTrafficVolume|cgprsAccPtIpv6MsSuccDeactivatedPdps|cgprsAccPtSu
ccNetworkInitPdps|cgprsAccPtDhcpAddrRequests|cgprsAccPtSuccMsDeactivate
dPdps|cgprsAccPtIpv6MsActivatedPdps|cgprsAccPtIpv6DownstreamPackets|cgp
rsAccPtIpv6GgsnDeactivatedPdps|cgprsAccPtRevDownstrTrafficVol|cgprsAccP
tIpv6MsDeactivatedPdps|cgprsAccPtSuccMsActivatedPdps|cgprsAccPtMsDeacti
vatedPdps|cgprsAccPtIpv6NetworkInitDeactPdps|systemIPAddress
212.47.101.248|1613949||1592838|0|0||1813|71|0|192505726||0|||803|402|4
02|||401|3|71|0|||0|0|289||||1548659852||401|289||212.47.101.248
212.47.101.248|0||0|0|0||0|0|0|0||0|||0|0|0|||0|1000|0|0|||0|0|0||||0||
0|0||212.47.101.248
212.47.101.248|0||0|0|0||0|0|0|0||0|||0|0|0|||0|46|0|0|||0|0|0||||0||0|
0||212.47.101.248
212.47.101.248|0||0|0|0||0|0|0|0||0|||0|0|0|||0|1|0|0|||0|0|0||||0||0|0
||212.47.101.248
212.47.101.248|95498||91918|0|0||0|3|0|4860942||0|||47|21|21|||21|253|3
|0|||0|0|15||||105111146||21|15||212.47.101.248
##END|cgprsAccPtStatisticsEntry

Get IBM Tivoli Netcool Service Quality Manager Data Mediation Gateway Development now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.