New Features in Sybase Control Center for Sybase IQ

Brief descriptions of new and enhanced features with links to complete information.

New and enhanced features: Sybase Control Center for Sybase IQ
Feature Topics
Functions and procedures – create and manage functions and procedures written in a variety of SQL dialects and external environments.

Manage Functions

Manage Procedures

Java external environments – install, update, modify, or delete Java classes and JAR files.

Manage External Environments

SQL query execution – run ad hoc queries or stored procedures.

Executing a SQL Query

Text indexes and text configuration objects – create and manage text indexes for full-text searches and custom text configuration objects for your text indexes.

Manage Text Indexes

Manage Text Configuration Objects

Data collections – five new data collections allow you to improve performance and better manage alerts by avoiding the collection of duplicate statistics.

Sybase IQ Data Collections

Shared-disk mode – run multiple Sybase Control Center instances from a single installation on a shared disk.

Deploying an Instance from a Shared Disk Installation

Shared Disk Mode

Instances

Run collections without saving data – configure data collection jobs so they update monitoring views but do not add data to the repository.

Setting Up Statistics Collection

E-mail configuration for alerts – specify a domain name or change the sender name for e-mail alert notifications.

Configuring the E-mail Server

Resizing wizards – make windows larger or smaller by dragging the edges or corners.

(No new topic)
Authority management – grant database authorities to a user or group and revoke database authorities from a user or group.

Manage Authorities

Database management – create databases, view and modify database options, and view properties of a database.

Manage a Database

Dbspace and DB file management – add, modify, view properties, or delete a dbspace. Add, modify, view properties, or delete a DB file.

Manage a Dbspace

Manage DB Files

Logical server management – group a subset of physical hardware resources together as a logical entity that appears as a single multiplex server.

Logical Servers

Login policy management – manage the rules for user login.

Manage Login Policies

Multiplex management – change a multiplex server configuration, manage the secondary and failover nodes, and configure logical servers.

Manage a Multiplex Server

Server management – create, start, stop, view properties, change server configuration, and generate administration scripts.

Manage a Server

Shared temporary dbspace management – manage shared temporary stores to communicate and store temporary on-disk structures for distributed query processing.

Viewing Multiplex Dbspace Statistics

Adding a DB File

User and group management – add, change, and delete users, or groups containing users or other groups, as a prerequisite to managing user authorities.

Manage Users and Groups

Administration Console – manage existing resources and create new ones. Column-based filtering lets you display only the objects you are interested in.

Testing scripts – test the execution of alert-triggered scripts to make sure they work as expected.

Testing an Alert-triggered Script

Creating an Alert

Automatic logout – a Sybase Control Center administrator can configure the logout timer to end users’ login sessions after a specified period of idleness.

Configuring the Automatic Logout Timer

Logging out of Sybase Control Center

Multiple object selection – in the Perspective Resources view, Resource Explorer, and Administration Console, you can select and perform operations on several objects simultaneously.

Various topics, including Unregistering a Resource

Memory management – use environment variables to control Sybase Control Center’s memory use. A new console command, info -m, displays memory usage data.

Configuring Memory Usage

info Command

Related concepts
Accessibility Features
Sybase Control Center Accessibility Information
Related reference
User Interface Overview
Toolbar Icons
Status Icons
Common Display Options
Style and Syntax Conventions