Chat now with support
Chat with Support

Spotlight on SAP ASE 2.11 - User Guide

Spotlight on SAP ASE
Background Information Desktop Features Connect to SAP ASE Spotlight® on SAP ASE Drilldowns Spotlight® on SAP ASE Alarms Glossary
Spotlight Basics
Spotlight Connections Monitor Spotlight Connections Alarms Charts, Grids And Home Page Components View | Options Troubleshooting
Spotlight History Spotlight on Windows
Connect to Windows Systems Background Information Home Page Alarms Drilldowns View | Options Troubleshooting
Spotlight on Unix About us Third-party contributions Copyright

Error Log drilldown

Using the 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 or press Ctrl + R.

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

Using the 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 or press Ctrl + M.

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

Using the 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 or press Ctrl + M.

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

Using the 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 or press Ctrl + Q.

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 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.

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating