Spotlight on SAP ASE 2.12 - User Guide

Engines Offline Alarm

This alarm is raised when Spotlight determines an engine is off-line.

Note: If you are using logical process management to bind particular logins or applications to engine groups, take note of the engine(s ) that are off-line.

If you take all engines for an engine group off-line, the login or application can then run on any engine.

A DBA can dynamically change the number of engines in use by Adaptive Server with the dbcc engine command.

The syntax for dbcc engine is:

• dbcc engine(off-line, [ enginenum ])

• dbcc engine( "online")

Error Log Alarm

The alarm is raised when Spotlight detects one or more lines written to the Error Log that match the configured patterns defined within Spotlight.

To view the configured patterns go to View | Options | Spotlight® on SAP ASE. Choose the Error Log button to display these patterns.

Go to the Error Log drilldown to see the messages added to the Error Log. You can sort the table in the drilldown on any of the columns to find specific messages or users that may have raised an error.

Use SAP Troubleshooting and Error Messages Guide to find information about specific error codes.

To add a string that Spotlight should look for while monitoring the Error Log, go to the main Spotlight® on SAP ASE menu bar and select:

View -> Options -> Spotlight® on SAP ASE

Choose the Error Log option, enter a string to match on the bottom of the form, and then click the "Add" button.

* Available only with ASE versions 12.5.0.3 or later

Fullest Database Alarm

Spotlight raises an alarm when any database exceeds the usage limits defined in the thresholds. The container and the percentage figures are for the database listed that has the highest level of used space.

There are several options:

• Run an "alter database" command and increase the size of the database. (Go to the Devices drilldown to see space available on each device.)

• Run "sp_extendsegment" to extend a segment to another device. (Go to the Devices drilldown to see space available on each device.)

• Run any application maintenance to reduce the size of the database.

• If any transaction log is on the same device as the data, consider dumping the transaction log (dump tran <database name> <options>).

Go to the Databases drilldown to see space and capacity metrics for each database.

Fullest Tempdb Alarm

Spotlight raises an alarm when any tempdb exceeds the usage limits defined in the thresholds.

The container and the percentage figure are for the tempdb database listed that has the highest level of used space.

There are several options:

• Run an "alter database" command and increase the size of the database. (Go to the Devices drilldown to see space available on each device.)

• Run "sp_extendsegment" to extend a segment to another device. (Go to the Devices drilldown to see space available on each device.)

• Run any application maintenance to reduce the size of the database.

• If the transaction log is on the same device as the data, consider dumping the transaction log (dump tran <database name> <options>).

Go to the Databases drilldown to see space and capacity metrics for each database.