Session database schema

The session database schema is provided so that you can use a structured query language (SQL) reporting tool to audit and sort data. The schema is also used to generate queries and produce usage reports. The default DB2 database name is wg.

ActvStat field

For the ActvStat field, the values and their corresponding meanings are:
  • 0 - IDLE
  • 1 - ACTIVE_WLP
  • 2 - ACTIVE_PPP
  • 4 - Reserved
  • 8 - ACTIVE_HTTP
  • 16 - ACTIVE
  • 32 - SHORT_HOLD

ActvKeyType and DevKeyType fields

For the ActvKeyType and DevKeyType fields, the values and their corresponding meanings are:
  • 0 - InvalidDT
  • 1 - DialDT
  • 2 - ArdisDT
  • 3 - MobitexDT
  • 4 - DataradioDT
  • 5 - DatatacDT
  • 6 - Rnc3000DT
  • 7 - IpDT
  • 8 - SmsDT
  • 9 - IpV6DT
  • 10 - RpaDT
  • 11 - HttpDT
  • 12 - Reserved

Additional information

The fields ActvKey, DevKey, MNC, and LoginTimeStamp relate directly to the trap variables as listed in the Troubleshooting Guide. When variable 2 is an IP address, it relates directly to the ActvKey field. The IP address (ActvKey) is the private (SafeLinx Server-assigned) IP address. When variable 3 is a device name, it relates directly to the DevKey field. The device name (DevKey) is the public (carrier's) IP address. When variable 4 is a network interface, it relates directly to the MNC field. When variable 5 is a timestamp, it relates directly to the LoginTimeStamp field.

The ActvStat field corresponds to the Current® Status field. The DevKeyType field corresponds to the Network type field when you are viewing the currently connected users. To display all currently connected users, by using SafeLinx Administrator:
  1. Click Find.
  2. In the Resource field, click Active session.
  3. In the Search in field, click All OUs, then click Find now.
Table 1. ActiveSessionAttribute - Stores the account active session attributes traffic.

ActiveSessionAttribute - Stores the account active session attributes traffic.

Field Name Type Field Size Value Required Zero Length Allowed Comments
ActvStat Small integer 2 Yes No Current session status
ActvKeyId Small integer 2 Yes No Active key ID
ActvKey Varchar[512] 5-516 Yes No Unique session table active key. Required field.
ActvKeyType Small integer 2 Yes No Active key type
BANDWIDTH Real 4 No Yes Device bandwidth.
DevKey Varchar[192] 5-196 Yes No Device key. Required field.
DevKeyId Small integer 2 Yes No Optional device key ID
DevKeyType Small integer 2 Yes No Active device type
DevLocation Varchar[256] 4-260 No Yes Reserved
DevName Varchar[256] 4-260 No Yes Contains the adapter name as provided by the client during login and roam.
DN Varchar[256] 5-259 Yes No Fully qualified distinguished name of a string of accounts. Required field.
GW Varchar[256] 5-259 Yes No SafeLinx Server's fully qualified distinguished name. Required field.
LoginTimeStamp TIMESTAMP / DATE 26 Yes No The value is a TIMESTAMP for DB2® installations or DATE for Oracle installations.
MNC Varchar[255] 4-259 Yes No MNCs fully qualified distinguished name.
SessData Varchar[1024] 4-1028 Yes No Optional session data
Total 69-2812
USERID Varchar[256] 5-259 Yes No User's short name. Required field.