TSP Lab SgaIC2OraLoader - The database loader SgaIC2OraLoader

The database loader module
("SgaIC2OraLoader")

Basic operation

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 input files
  Apply COMMIT now! (Ctrl-C) Sends COMMIT commands to the database for the latest uncommitted records.
  Disconnect from DB (Ctrl-D) Closes DB connection
  Release file (Ctrl-R) Close the actually read input file leaving remain data in it
[Options]
  Auto scroll (ScrollLock, or ) Allow automatic scrolling of the log screen
  Save setting   Saves actual settings into the configuration (SgaIC2OraLoader.ini) file

The bottom status-line

Configuration (SgaIC2OraLoader.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) menu item!)
[Database]
  UserName SgaIC_user User name for database access
  Password pwd Password of the user for database access
  Database SgaIC Host string for the database
  wWaitBeforeReconnect 10 Time between attempts to connect; defaults to 10; given is seconds; 0 means no delay; re-read during operation
[Advanced]
  wLogDetailLevel 3 (Equals to the listed order; refer to the ([Log]/Details menu item!)
  wMaxCPUUsagePercent 25 Limit of CPU-usage for this module
  dwMaxLinesInLogWindow 1000 Number of lines in the log window on screen
  bCeaseBeforeSwitchAlertLevel True Send a CEA SNMP trap before switching alert level (e.g., from WAR to CRI) for the very same error
  bAlternateTrapUID True Creation of alternate trap UID is enabled or disabled
  dw_WAR_NoDBUpdateTimeoutSec 15 Threshold for WARNING level SNMP traps indicating suspiciously low database traffic
  dw_ERR_NoDBUpdateTimeoutSec 60 Threshold for ERROR level SNMP traps indicating suspiciously low database traffic
  dw_CRI_NoDBUpdateTimeoutSec 180 Threshold for CRITICAL SNMP traps indicating suspiciously low database traffic
  sLogFilesPath d:\LogFiles Path for the LOG files
  sTrapFilesPath d:\TrapFiles Path for the SNMP Trap files

SNMP Traps

Version history