alert
– a mechanism for notifying administrators when a managed
resource experiences a status change, or when a performance metric passes a
user-specified threshold.
alert notification
– an indication that an alert has fired. Alert notifications
appear in the Alert Monitor view. If e-mail notification is enabled, alert
notifications are also delivered to the specified e-mail address.
alert storm
– the result of issuing many redundant alerts associated with a
common or root occurrence. See also alert storm suppression.
alert storm suppression
– a Sybase Control Center feature that can be configured to
prevent alert storms by suppressing repeat alert notifications for a
specified period of time.
alert type
– the basis on which an alert fires: state or threshold. State
alerts are triggered by the state of their key performance indicator (for
example, running or stopped), while threshold alerts are triggered when
their KPI’s numerical value passes a specified threshold.
authenticate – when SCC authenticates with a managed resource, it logs in to
the resource with a user ID and password provided by you. SCC must log in to
managed resources in order to gather performance statistics and perform
management tasks. You can choose to have SCC use your current SCC login ID,
or you can provide different credentials.
availability
– indicates whether a resource is accessible and responsive.
catalog store – the portion of each SAP Sybase IQ database that contains its
metadata. (Metadata describes the layout of the SAP Sybase IQ tables,
columns, and indexes.) The catalog store contains the system dbspace and up
to 12 additional catalog dbspaces. The default name for this file is
<dbname>.db.
chart trend period – the period, in minutes, over which data is displayed in
historical charts. Set the chart trend period on the Settings screen of the
SAP Sybase IQ Monitoring View. Contrast with screen refresh interval.
collection repeat interval – the period, in seconds, minutes, hours, or days, between
successive repetitions of a statistics collection job. The collection repeat
interval determines how often new data on historical monitoring screens is
available to be refreshed. Set the collection repeat interval in the
scheduler. See also screen refresh interval.
collection
– a named, predefined set of key performance indicators for which
values are collected from monitored servers at the same time. Collections
supply the performance and availability data shown on Sybase Control Center
screens and charts. Use the scheduler to view a list of collections and to
control which collections run, how often they run, and the length of time
for which they run.
connection – a connection from an SAP Sybase IQ server to a database.
database – a collection of tables that are related by primary and foreign
keys. The tables hold the information in the database. The tables and keys
together define the structure of the database. SAP Sybase IQ databases are
specially indexed to take advantage of the query speed of SAP Sybase IQ.
dbspace – a named collection of dbfiles that provides space for data and
can be administered as a logical subset of the total storage. The main
store, catalog store, and temporary store consist of dbspaces.
event
– an activity in the system, such as a user logging in, a service
starting or stopping, or a condition changing. Use the alerts feature to
detect and notify you about system events.
external environment – a development environment external to SAP Sybase IQ (C/C++ or
Java, for example) that you can use to create functions and procedures to
run against SAP Sybase IQ databases.
heat chart
– a graphical view of resource availability and selected
performance and status metrics for all the registered resources in the
current perspective.
instance – an SCC agent or server run from a shared disk installation. See
also shared-disk mode.
job
– a task performed by the scheduler in Sybase Control
Center.
key performance indicator (KPI) –
a single metric used to evaluate the status or performance of a
monitored resource. A KPI value can be a state (such as running, error, or
stopped) or a numerical value. KPIs are grouped into collections (and also,
for some product modules, into key performance areas, or KPAs). KPI values
are collected by scheduled collection jobs and appear on monitoring screens
and in the statistics and heat charts. Examples of KPIs are resource state
and CPU usage.
key performance area (KPA) –
a group of related key performance indicators.
main store – the SAP Sybase IQ main store is the portion of each SAP Sybase
IQ database that contains persistent database structures, such as backup
metadata and rollback data for committed transactions.
managed
resource
– see resource.
message row – a row that appears in the right pane of the Administration
Console in place of a slow-responding request, a failed request, or a large
result set. Rows with slow-responding requests are populated as soon as the
data arrives. You can retry failed requests or expand large result
sets—select the row and click the drop-down arrow to see
options.
multiplex – a powerful feature in SAP Sybase IQ that provides application
scalability through a clustered server configuration. An SAP Sybase IQ
multiplex is made up of several multiplex servers, or nodes. Each node is
assigned a role: coordinator (one per multiplex), writer, or reader. Readers
and writers can serve as secondary nodes, backing up the coordinator node in
case of failure. The multiplex feature allows concurrent data loads and
queries via independent data processing nodes connected to a shared data
source. Each multiplex server has its own catalog store and IQ temporary
store; all the servers in the multiplex share a common IQ store. Contrast
with simplex.
node – a topology object representing a server or other entity type,
displayed in the form of an icon.
perspective
– a named tab in Sybase Control Center that displays information
related to a collection of managed resources (such as servers) and a set of
views associated with those resources. The views in a perspective are chosen
by users of the perspective. You can create as many perspectives as you
need, and customize them to monitor and manage your resources. Perspectives
allow you to group resources in ways that make sense in your environment—for
example by location, department, or project.
product module – a
plug-in component of Sybase Control Center that manages and monitors a
particular Sybase product. SCC product modules are available for Adaptive Server, Data Assurance (a Replication Server
option), replication (Replication Server, Replication Agent, and Mirror Replication
Agent), Sybase Event Stream Processor, and Sybase IQ.
repository
– a database in Sybase Control Center that stores information
related to managed resources, along with user preference data, operational
data, and performance statistics.
resource
–
a server,
agent, or other entity that can be monitored or administered by Sybase
Control Center. Resources SCC can manage include Adaptive Server, Data Assurance Server,
Replication Server, Replication Agent, Mirror Replication Agent, Sybase Event Stream
Processor, Sybase IQ, and certain subcomponents.
row-level version (RLV) – the unit of versioning is the row. Row-level versioning
structures data at the row level of an RLV-enabled table, provided that the
RLV dbspace has been created with at least one dbfile. RLV allows row-level
updates, inserts, and deletes, by multiple users, in real-time.
SCC-enabled login account
– a user account that has been granted privileges in Sybase
Control Center by mapping appropriate Sybase Control Center roles. (Roles
are typically mapped to a group to which the account belongs rather than to
the account itself.) The user account and group can be native to Sybase
Control Center or created in the operating system or the LDAP directory
service to which Sybase Control Center authentication is delegated. You must
use an SCC-enabled account to log in to Sybase Control Center.
SCC agent – a remote command and control agent for Sybase Control Center
that runs on a managed server. The SCC agent is installed automatically as
part of the Sybase server.
schedule
– the definition of a task (such as the collection of a set of
statistics) and the time interval at which Sybase Control Center executes
the task.
screen refresh interval – the period in seconds between refreshes of screens in the
monitor views (IQ Node Level Monitor and IQ Multiplex Level Monitor).
Refreshing a screen redraws it with the most recent available data. Set the
screen refresh interval on the Settings screen of either monitor view. See
also collection repeat interval.
shared-disk mode – a feature that enables multiple instances of Sybase Control
Center to execute from a single installation on a shared disk. Instances can
be SCC servers, agents, or a mixture of the two.
simplex – an SAP Sybase IQ implementation consisting of a single server
that is not part of a multiplex. Contrast with multiplex.
singleton
installation – a Sybase Control Center installation that runs a single SCC
agent or server. Contrast with instance; see also shared-disk mode.
store – a store is one or more dbspaces that store persistent or temporary data for a
special purpose. See catalog store, main store, or temporary store.
table version – the unit of versioning is the table. Table-level versioning
structures aggregate data for columns at the table level. With table-level
versioning, SAP Sybase IQ can control access to the data at the level where
write operations occur, and where query results are focused.
temporary store – the SAP Sybase IQ temporary store is the portion of each SAP
Sybase IQ database that stores temporary tables and temporary scratch space
data structures. The SAP Sybase IQ server uses temporary data structures to
sort and process data. Data in these tables persists only as long as you are
connected to the database.
text configuration object – associated with a text index to define the way the index breaks
text into terms, or searchable strings. You can create your own text
configuration object or use one of the defaults provided by Sybase. See also
text index.
text index – a mechanism to speed up full-text searching of tables. You must
create a text index for a table before full-text searches can be performed.
Each text index requires a text configuration object. See also text
configuration object.
topology – a graphical representation of how the servers in a multiplex
environment are connected to each other. Found in the IQ Multiplex Level
Monitor, it is a network diagram that provides a visual map of the
availability of the SAP Sybase IQ server environment.
transaction – a set of related SQL statements that are treated as a single unit of work. To ensure consistency, if all the statements in the set cannot be executed, the changes made by the query are rolled back. The tables queried during the transaction are locked until a transaction is completed.
transaction log – the SAP Sybase IQ transaction log records changes to the
database. The transaction log includes version information, free space, and
other information you can use to recover from a system failure. By default,
the transaction log is created in the same directory as the catalog store.
The default name for this dbfile is <dbname>.log.
trend period – See chart trend period.
view (SCC)
– a window in a Sybase Control Center perspective that displays
information about one or more managed resources. Some views also let you
interact with managed resources or with SCC itself. For example, the
Perspective Resources view lists all the resources managed by the current
perspective. Other views allow you to configure alerts, view the topology of
a replication environment, and graph performance statistics.