TSP Lab	Statistics Database Loader	Sga7N_GyDB_Loader_Stat

Statistics Database Loader
`("Sga7N_GyDB_Loader_Stat")`

Basic Operation

Periodically scans the working directory for Sga-7001.xxx files, created by the Monitor Poller module
Writes statistics into binary data files and closes them periodically (by default hourly)
Statistics contain the followings:
- timestamp (creation date and time on the monitor)
- ID of the monitor where this stat was created
- Signaling link ID and direction
- Statistics ID
- Value
Creates SNMP traps about its shut down and if any problem has been occured during opening input or writing output files

There are low level (or general) statistics (generated on the Sga47 cards, about the PCM, the signaling link, etc) and higher level statistics (counted in the monitor program by decoding messages, they are about messages and transactions and processes). For the full list of statistics in the Sga-7N monitoring system, please visit the statistics list page.
The low level statistics are being gererated for every five minutes and the higher level ones are being counted for every 15 minutes.

User Interface

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 )	Allow periodic scanning of the working directory for `Sga-7001.xxx` files
	Release files	(Ctrl-R)	Input and output files will be let off
[Options]
	Auto scroll	(ScrollLock, or )	Allow automatic scrolling of the log screen
	Save settings		Save actual settings into the configuration (`Sga7N_GyDB_Loader_Stat.INI`) file

The bottom status-line

Uptime: time elapsed since module has been started up
Name of stat file under processing (Reading)
Number of statistics records processed
Open DAT files, they are open till INI/[Advanced]/wOutFilePeriod is expired

Configuration (Sga7N_GyDB_Loader_Stat.INI) file settings

Section	Entry	Example	Meaning
[Position]
	iLeft	140	Position of the program module on the display screen
	iTop	72	Position of the program module on the display screen
	iWidth	995	Position of the program module on the display screen
	iHeight	694	Position of the program module on the display screen
[Options]
	bAutoScroll	True	(Refer to the `[OPTIONS]/Auto scroll` menuitem!)
[Advanced]
	wLogDetailLevel	3	(Equals to the listed order; refer to the `[LOG]/Details menuitem!)`
	wMaxCPUUsagePercent	25	Limit of CPU-usage for this module
	dwMaxLinesInLogWindow	1000	Number of lines in the log window on screen
	wOutFilePeriod	60	Period of closing statistical data file
	dwOutFilePreallocationSize	120000000	Preallocated size of CDR files, in bytes.
	sDataPath	d:\StatCDR	Path for statistical data files
	sLogFilesPath	d:\LogFiles	Path for the LOG files
	sTrapFilesPath	d:\TrapFiles	Path for SNMP trap files

Version history

v2.20

(c) Counters are now 64-bit long.
(c) Speed-up DAT file writing.
(n) Optional DAT file preallocation in order to reduce file fragmentation.
(n) INI/[Advanced]/dwOutFilePreallocationSize (loaded on-the-fly; defaults to 0, which means 'Off')

v2.03

(c) Close all open files if any of them fails to load.

v2.02

(f) Didn't recover correctly if output data path had become temporarily unavailable.

v2.01

(c) Icon is changed.

v2.00

(.) Based on "Sga-7TA Stat Generator v1.10".
(n) New menu "Actions", with new menu item: "Release files" (Ctrl-R).
(n) "Release files" releases input and output files as well; see input file trimming below.
(c) "Go on / Pause" menu item is also moved from menu "Options" to "Actions".
(n) SNMP Traps
- WAR: "'[MAINCAPTION]' module has been shut down by operator."
- CRI: "Could not open output file for writing! (YYYYMMDD.Stat\Stat_HHMM.dat)"
- CRI: "Failed to write into output file! (YYYYMMDD.Stat\Stat_HHMM.dat)"
(n) New INI file entry: INI/[Advanced]/sTrapFilesPath; defaults to "c:\TrapFiles".
(c) Output file writing error (e.g., network error or disk full) no longer causes data loss: data processing is stopped, and input file is rolled back if error occurs on output.
(c) Jammed input records are no longer processed on exit, input file is trimmed instead (by omitting the records that have already been processed).
(c) Log on start-up includes the section name for the particular INI settings.