Example of Server Request Broker Log File
The following examples display log file entries in a sample Server
Request Broker log file. The name of this log file is SRBroker_TaskID.log and is found in the Siebel Server log directory. The first sample captures an event defined by the event
subtype GenericInfo, which belongs to the component event type General
Events (alias GenericLog). For a detailed description of this sample
output, see the following table. This event has a severity of 3 and
is recorded to the log file if the General Event log level is set
between 3 and 5.
GenericLog GenericInfo 3 0 2017-05-13 14:07:31 Set environment variable
DB2CODEPAGE=1252
| Log Detail | Description |
|---|---|
GenericLog |
Event Type alias |
GenericInfo |
Event Subtype |
3 |
Event Severity |
0 |
SARM ID |
2017-05-13 14:07:31 |
Date and time of log |
Set environment variable DB2CODEPAGE=1252 |
Log message |
The next two samples belong to the component event type SQL Parse and Execute. Events were recorded of the event subtype Statement and Prepare + Execute. For detailed descriptions of the sample output, see the following tables. Both of these event subtypes have a severity of 4 and are recorded to the log file if the SQL Parse and Execute event type is set to either 4 or 5.
Statement Event Subtype
The following table describes the output for a Statement event subtype for the following entry:
SQLParseAndExecute Statement 4 0 2017-05-13 14:07:38 select ROW_ID, NEXT_SESSION,
MODIFICATION_NUM from dbo.S_SSA_ID
| Log Detail | Description |
|---|---|
SQLParseAndExecute |
Event Type alias |
Statement |
Event Subtype |
4 |
Event Severity |
0 |
SARM ID |
2017-05-13 14:07:38 |
Date and time of log |
select ROW_ID, NEXT_SESSION, MODIFICATION_NUM from dbo.S_SSA_ID |
SQL statement |
Prepare + Execute Event Subtype
The following describes the output for a Prepare + Execute event subtype for the following entry:
SQLParseAndExecute Prepare + Execute 4 0 2017-05-13 14:07:38 Time: 0s, Rows: 0, Avg.
Time: 0s
| Log Detail | Description |
|---|---|
SQLParseAndExecute |
Event Type alias |
Prepare + Execute |
Event Subtype |
4 |
Event Severity |
0 |
SARM ID |
2017-05-13 14:07:38 |
Date and time of log |
Time: 0s, Rows: 0, Avg. Time: 0s |
SQL Execution statistics |