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.
- Click Find.
- In the Resource field, click Active session.
- In the Search in field, click All OUs, then click Find now.
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. |