Stack trace messages are appearing in the sybase error log when launching SoSyB. ... Software\Spotlight\Console\Templates\ on your PC and rename the existing sosyb.stx to be sosyb.old ... 2) Place the sosyb.stx in the attached zip file within the
Datasource error in connection <connection>: Adaptive Server appears to be down. ... Please verify that Adaptive Server is running. ... Please verify you have completed the steps on page 48 of the Getting Started Guide attached (Creating a Spotlight User and Connection)
SQL Text is not available when we click on SQL Detail tab. ... For example, we ran a sample query against a Sybase database via isql. ... Then, on Spotlight for Sybase, we select Users | SQL Details tab.
Trying to register and getting an "Invalid authorization key" message ... trying to enter a key for another product will result in an "Invalid authorization key" message
SQL Optimizer can connect to the database outside of Spotlight ... Quest Central was installed in the past but has been removed ... The issue was resolved by removing All Quest Software client applications from the client PC, and then also removing the following directories manually through Windows Explorer before re-installing the software...
Spotlight on Sybase client shows: ct_cmd_alloc: user api layer:external error: The connection has been marked dead. ... The result of exec sp_sls_E_waits_by_engine_m 0 when execute against ASE 15 yields:
It is possible to send an email when an alarm condition is met?
After upgrade to TOAD DBA Suite 6.6 it installed a new version of Spotlight on DB2 6.9.223, but it does not have previous SQL connections and does not show up in the list of Modules in the Help section.
When connect to Sybase with ssh using non-root user, received the below error: ... The user must be a member of the "adm" group to be able to run the sar command ... 1. Make sure the user is in the adm group
The Network panel shows the logins, connections and movement of data on the Unix system: ... The number of users currently logged on to the machine you are diagnosing. ... Connections ... The number of external programs with which the machine is currently communicating.
<P>The total number of logical data and index page reads and writes that occurred in the database within the last monitoring interval.</P>
<P>The internal identifier of the buffer pool. This value matches the <SPAN style="FONT-WEIGHT: bold">Tablespace ID</SPAN> column value in the Tablespaces drilldown. Each ID is unique.</P>
<P>The total number of partitions used by all the databases within the current instance.</P>
This counter shows the number of writes that did not use the buffer pool. ... To calculate an average of direct database writes, use the following formula:
The R/s dataflow depicts the rate at which synchronous and asynchronous reads are occurring in the database or partition you are monitoring. ... None ... Displayed statistic ... At each refresh, Spotlight captures the number of reads—both synchronous and asynchronous—per second occurring in the database or partition that you are monitoring.
All columns available for the Databases tab are listed below in alphabetic order. ... Click the links provided to see column descriptions. ... Initially, the tab contains Spotlight's default column selection.
The Details tab on the Buffer Pools drilldown provides the following information about the selected buffer pool: ... The amount of time required to perform I/O that involved this buffer pool ... Extended storage utilization statistics
Spotlight on IBM ® DB2 ® LUW (Linux, Unix, and Windows) comes with some predefined alarms for the database or database partition home page and for the associated instance home page. ... For a list of these of alarms, click on the appropriate home page type.
The W/s dataflow depicts the rate at which database agents are writing pages from buffer pools to disk for the database or partition. ... These writes are synchronous because they are performed as part of the processing of program instructions.
A main feature of Spotlight is its user interface. ... This interface uses two major window types—home pages and drilldowns—to help you monitor performance on your IBM DB2 for LUW (Linux, Unix, and Windows) databases and database partitions.
<P>The unique identifier for the buffer pool currently used by a tablespace.
Description ... Name ... The display name of the component. ... Maximum value ... Some components on the Spotlight home page display metric data as positions on a bar or graph. ... You can say how much of this bar or graph to display by entering a value in the Maximum Value property.
<P>The number of OLAP functions that requested sort heap after the sort heap threshold had been reached.</P>
Use Windows Disks Metrics to configure how logical disks are represented in the Disks panel on the Spotlight home page. ... Note: If the monitored system contains only one logical drive then these options will not be displayed.
This is the status of the communication connection between the source partition and the target partition through the fast communication manager (FCM). ... Valid values for this field are: ... Active—The connection is active.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center