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 Sybase IQ database that contains its metadata. (Metadata describes the layout of the 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 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 a 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. Sybase IQ databases are specially indexed to take advantage of the query speed of Sybase IQ.
dbspace – a named collection of DB files 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 Sybase IQ (C/C++ or Java, for example) that you can use to create functions and procedures to run against 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 Sybase IQ main store is the portion of each Sybase IQ database that contains persistent database structures, such as backup metadata and rollback data for committed transactions.
managed resource
– a server, agent, or other entity monitored and administered by Sybase Control Center. Resources SCC can manage include Adaptive Server, Replication Server, Replication Agent, Mirror Replication Agent, and Sybase IQ.
multiplex – a powerful feature in Sybase IQ that provides application scalability through a clustered server configuration. A 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.
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 unique Sybase product component (such as a server) or a subcomponent.
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 Sybase Control Center agent that runs on a managed server and enables Sybase Control Center to manage it. 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 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 – a 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, Sybase IQ can control access to the data at the level where write operations occur, and where query results are focused.
temporary store – the Sybase IQ temporary store is the portion of each Sybase IQ database that stores temporary tables and temporary scratch space data structures. The 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 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 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
–
a window in a perspective that displays information about one or more managed resources. Some views also let you interact with managed resources or with Sybase Control Center 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.