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
– an SAP 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
SAP 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
SAP 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 SAP 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 SAP 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), SAP Sybase Event Stream Processor, and SAP Sybase IQ.
repository
– a database in SAP 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
SAP Control Center. Resources SCC can manage include
Adaptive Server, Data Assurance Server, Replication
Server, Replication Agent, Mirror Replication Agent,
SAP Sybase Event Stream Processor, SAP 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
SAP Control Center by mapping appropriate
SAP 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
SAP Control Center or created in the operating system
or the LDAP directory service to which SAP Control Center
authentication is delegated. You must use an SCC-enabled account to log in
to SAP Control Center.
SCC agent – a remote command and control agent for
SAP 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
SAP 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
SAP 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 – an SAP 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 an SAP 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.