The Cell SMS Database module
("Sga-CellSMS_DB")

• Basic operation
• User interface
• Configuration
• Version history

• Processes incoming location information data from Sga-9009.NNN files.
• Builds a database of current location information in memory
• Provides a query interface for current location information
• Generates CDRs and IMSI and MSISDN indeces to store historical location information
• Creates cell usage statitics

Main screen

The main menu

Menu	Menuitem	Shortcut(s)	Meaning
[Log]
	Find line containing...	(Ctrl-F)	Finds text in log window
	Find next matching line	(F3)	Finds next occurrence of text in log window
	Details		Detail level of logging (Off, Normal, Detailed, or Debug)
[Actions]
	Go on / Pause	(Ctrl+P or )	Enables input data processing
	Re-enter client password		The password used for authentication can be re-entered
	Flush counters		Writes status line counters into the log
	Flush & reset counters		Writes the counters into the log and zeroes them
	Re-load cell names		Reloads cell names file
	Save PerCell list, excl. 4G cells.		Generates cell usage statistics, excluding 4G cells
	Save PerCell list, incl. 4G cells.		Generates cell usage statistics, including 4G cells
	Re-load IMSI prefix names		Reloads IMSI prefix names list
	Re-load operator prefix names		Reloads operator prefix names list
	Re-load ECI −−−> LAC table		Reloads ECI −−−> LAC conversion table
	Check all these tables above...		... for last 1/3/10/30/all days
	Save in-memory IMSI records		Dumps records from memory into a backup file
	Drop old in-memory IMSI records		currently not available option
	Drop very old in-memory IMSI records		currently not available option
	DEBUG: list in-memory IMSI records (first few)		Dumps records from memory onto the screen (and the log file)
[Options]
	Auto scroll	()	Allow automatic scrolling of the log screen
	Save settings		Save settings into INI file

The bottom status-line

• Uptime: Time elapsed from last start of program
• State
  • Loading... / Idle.: Indicates the state of input data processing
• IMSI
  • alloc'd: Number of in-memory IMSI records (usage of IMSI memory given in percentage)
  • (W+!W): Number of Telekom and non-Telekom subscribers
  • overflown: Number of dropped records due to the IMSI memory is full
  • forgotten: Number of records which are getting older than ...

• Input: Indicates input file name
• IMSI records
  • processed: Number of processed records
  • queried
    • hit: Number of successful location data queries
    • miss: Number of unsuccessful location data queries

• Clients: Number of clients currently connected
• Client queries: see hit/miss figure above

• Open output DAT files: CDR files currently opened for writing
• Records written total: Total number of written records
• with
  • CellInfo: Number of records containing Cell info
  • MSISDN: Number of records containing MSISDN
  • IMEI: Number of records containing IMEI
  • VLR: Number of records containing VLR address

Section	Entry	Example	Meaning
[Position]
	iLeft	132	The initial horizontal position of the Main screen, in pixel
	iTop	132	The initial vertical position of the Main screen, in pixel
	iWidth	770	The initial width of the Main screen, in pixel
	iHeight	558	The initial height of the Main screen, in pixel
[Options]
	bAutoscroll	True	If True, log list automatically scrolls to the last line when a new item added
[Subscribers in memory]
	dwIMSIMaxCount	6000000	Size of IMSI memory
	dwPeriodicBackupSec	900	Time period of regular IMSI record backup
	sPeriodicBackupPath	d:\Backup	Path for IMSI record backup files
	wLocalTCPPort	9010	Local TCP port for current location information qeuries (single)
	sClientPassword	pwd	Client password for current location information qeuries (if it is not given then it can be defined on the GUI)
[Kat-SMS query]
	wLocalTCPPort	9019	Local TCP port for current location information qeuries (mass)
	sTemporaryFilesPath = c:\GyCellInfoDB\TempFolderForKatSMS	d:\Backup	Path for temp files
[PerCell list]
	dwMaxTimeBehindSec	11400	...
	sOutputFileName	d:\PerCellList\PerCellList.csv	Path and name of cell usage list file triggered by operator on GUI
	dwPeriodicOutputSec	900	Time period of cell usage list generation
	sPeriodicOutputPath	d:\PerCellList_Periodic	Path for periodic cell usage list files
	bPeriodicOutputIncludes4Gcells	True	Whether periodic cell usage list would contain 4G cells (True) or not (False)
[PerCell query files]
	dwPeriodicInputCheckingSec	10	Time period for checking PerCell query files
	sInputPath	d:\PS_QueryInputFolder	Path for input query files
	sOutputPath	d:\PS_QueryOutputFolder	Path for result files
	sECILACtableFile	ECI_LAC_table.csv	Defines ECA-LAC table file
	sIMSIPrefFile	IMSIPref.lst	Path and name of the IMSI prefix file
	sOpPrefFile	OpPref.lst	Path and name of the operator prefix file
[Output DAT files]
	wOutFilePeriod	15	Defines period of CDR files
	dwOutFileUseCrypto	1	Enables encryption of CDR files; 0 means 'off', any other value means 'on'.
	byOutFilePathModulo	3	Defines the number of CDR file destinations
	sOutFilePathPrimary_N	e:\CDR\	Path(s) for CDR files. As many path should be defined as the value of byOutFilePathModulo. N runs from 0 to byOutFilePathModulo-1.
	dwOutFilePreallocationSize	500000000	Preallocated size of CDR files, in bytes
	sOutFilePathAlternate	g:\CDR_alternate\	Alternative path for location information CDRs when sOutFilePathPrimary_N is inaccessible.
[Output INDEX files]
	byOutFilePathModulo	3	Defines the number of index file destinations
	sOutFilePathPrimary_N	e:\CDR\	Path(s) for index files. As many path should be defined as the value of [Output INDEX files] / byOutFilePathModulo. N runs from 0 to byOutFilePathModulo-1.
	dwOutFilePreallocationSize	500000000	Preallocated size of index files, in bytes
[Advanced]
	wLogDetailLevel	3	(Equals to the listed order; refer to the [Log]/Details menu item!)
	wMaxCPUUsagePercent	90	Limit for CPU usage
	dwMaxLinesInLogWindow	500	Number of lines in the log window on screen
	sCellNamesFile	CellNames.csv	Path and filename of CellNames.csv file
	sLogFilesPath	D:\LogFiles\	Path of directory of log files
[Friendly IMSIs]
	216301234123455F	someone	...

v1.26
• (c) Modified disk writing strategy implemented to achive a more effective processing
• (n) The possibility of distinguishing between local and foreign subscribers when serving a mass query

v1.25
• (c) Enables measurements of output encryption and disk-writing speed separately. To put it another way: both features can be switched on and off, independently.
• (n) [Output DAT files] / dwOutFileUseCrypto (0 means no encryption)
• (n) [Output DAT files] / byOutFilePathModulo (0 means no output file)

v1.24
• (n) AES encryption instead of the earlier 3-DES
• (c) Keeps open the 9 last written DAT file instead of 2 ones.
• (n) Usage of read-ahead cache to increase processing speed.
• (n) New menu item: [Log] / Always include input file open/close actions
• (n) Status bar: Indication of the earliest and the latest data time stamp
• (n) Status bar: Indication of data load speed (record/sec) for the last second

v1.23
• (c) Handles 50-character long cell names instead of 10.

v1.22
• (c) Modified algorythm: If cell information data arrives in such a way that we already know the given subscriber but we do not yet have cell data for her, then we expand our knowledge about her with this newly received but previous cell information.
• (c) Encryption and writing of output files can be switched off by the byOutFilePathModulo=0 setting for perfomance tests.

v1.21
• (n) Processes KatSMS queries. [Kat-SMS query]

v1.20
• (n) TBA

v1.19
• (n) TBA

v1.18
• (c) Handling of MAP and Diameter events of inbound roamers changed: last cellID is kept, but cancelled state is indicated (in "bit5", which was previously spare)
• (f) In some cases uncertain MSISDNs (with a terminating '?') were written into the CDR files with a bad length (however, the corresponding Query Server compensated this behavior)