Error Log drilldown
The Error Log drilldown provides access to details about error messages for the ASE you are diagnosing.
To display the Error Log drilldown
Click Event Log
Click Error Log Tab
Note: You can also select View | Go To | Error Log.
Data in the Error Log drilldown
The Error Log drilldown displays an Error Log grid.
Memory Summary drilldown
The Memory Summary drilldown provides access to details of memory usage for the Adaptive Server you are diagnosing.
To display the Memory Summary drilldown
Click Memory 
Note: You can also select View | Go To | Memory.
Data in the Memory Summary drilldown
The Memory Summary drilldown displays five pages, each of which can be opened by clicking on its associated tab.
Network drilldown
The Network drilldown provides access to information about the number of packets sent and received by the ASE.
To display the Network drilldown
Click Network 
Note: You can also select View | Go To | Network.
Data in the Network drilldown
The Network drilldown displays three charts and the Network Users grid:
In addition, this drilldown displays data in six fields below the three charts, including:
Server Configuration drilldown
The Server Configuration drilldown provides access to:
-
General ASE Server, login and machine information
-
Settings for Adaptive Server Enterprise configuration elements
-
Current Alarm Log, ASE Error Log and Spotlight Error Log messages
To display the Server Configuration drilldown
Click Server Configuration drilldown 
Note: You can also select View | Go To | Server Configuration drilldown.
Data in the Server Configuration drilldown
The Server Configuration drilldown displays as a single page with:
-
General ASE Server, login, and machine information in five fields at the top of the page
-
Three buttons at the bottom of the page to enable display of the Alert Log, ASE Error Log and Spotlight Error Log
General Information
The following table defines the five general information fields at the top of drilldown:
|
Field |
Description |
|
ASE Server Name |
Name of this Adaptive Server that is being monitored. |
|
ASE Version |
The full version of Adaptive Server that is being monitored. |
|
ASE Login |
The login account used to connect to this Adaptive Server. This account information is defined in the Spotlight connection. |
|
Host Machine Name |
Name (or IP address) of the host machine that Adaptive Server is running on. This is defined in the Spotlight connection. |
|
Port |
Port number the Adaptive Server is listening on. This information is defined in the Spotlight connection. |
Last Error field
The Last Error field displays the last error message encountered while collecting data from Adaptive Server.
Alert Log, ASE Error Log, and Spotlight Error Log buttons
-
Click the Alert Log button to view a list of alarms associated with your connection to Spotlight® on SAP ASE.
-
Click the ASE Error Log button to view a list of errors associated with your connection to the ASE Server.
-
Click the Spotlight Error Log button to view a list of errors associated with your connection to Spotlight® on SAP ASE.
ASE Server Configuration Parameters Grid Tab
This grid displays the configuration parameters needed by Spotlight to fully monitor an Adaptive Server.
The following table describes the columns on this grid:
|
Column |
Description |
| Parameter Name | The name of the configuration parameter corresponding to rows in the sysconfigures and syscurconfigs tables. |
|
Config Value |
The current configuration value from the sysconfigures table. |
|
Run Value |
The current run value from the syscurconfigs table. |
|
Baseline Config Value |
The user established baseline config value for comparison. |
|
Baseline Run Value |
The user established baseline run value for comparison. |
-
Click the Set Baseline Value button to establish the current config and run values as the new baseline values for the current adaptive server.
ASE Server Configuration Requirements Grid Tab
This grid displays the permissions, roles, and ASE configuration parameters needed by Spotlight to fully monitor an Adaptive Server.
The following table describes the columns on this grid:
|
Column |
Description |
|
Configuration |
Permissions and configuration parameters used by Spotlight |
|
Setting |
Current state of the permissions and configuration parameters. This will be either "Yes", "No," or a numeric value. |
|
OK |
A check mark indicates that a parameter or permission is set to allow Spotlight to fully monitor an ASE. An "x" indicates that Spotlight will have reduced functionality associated with the parameter or permission. |