Brief descriptions of new and enhanced features with links to complete information.
This guide assumes you are connected to the most recent Adaptive Server version. Which Sybase Control Center features are available depends on which version of Adaptive Server you are connected: Later versions of Sybase Control Center may include features not available in earlier versions of Adaptive Server.
The sections below list new and enhanced features for recent Sybase Control Center for Adaptive Server versions and how they correlate with connected Adaptive Server versions. For earlier versions not listed, refer to the New Features section in your version of Sybase Control Center documentation.
The following new and enhanced Sybase Control Center for Adaptive Server version 3.2.8 features are available with Adaptive Server version 15.7 SP100.
Feature | Topics |
---|---|
Reorganization – reorganizes tables, table partitions, indexes, and index partitions incrementally or in one transaction. Reorganization improves performance by reclaiming unused page space, removing row forwarding, or rewriting all table rows to new pages, depending on the option used. | Manage Reorganization |
Split and Merge Partitions – Over time, a partition’s data distribution may become skewed, or the manner in which the data was originally partitioned may not suit current business requirements. Splitting and moving partitions allows you to redistribute the data and revive the performance benefits of using partitions | |
Enhancement to Dump and Load – allows you to create a new database using data-definition language (DDL) from another database, allowing you to back up and restore a database to a different database altogether. | |
Incremental Dump – allows you to perform a cumulative dump (back-up), a type of incremental dump in which only the changes since the last full database dump are backed up. | |
Enhancement to Backup and Restore Management – allows you to specify disk device stripes for back-up and restore, as well as the ability to specify a point of time from which to restore a database. | |
Create Index Online – allows you to create indexes without blocking access to the data you are indexing. | |
Shrink Database – allows you to shrink databases, releasing unused space for reuse or deletion. | |
Long Running Transaction Execution Time alert - this new key performance indicator (KPI) allows you to specify thresholds and receive alerts in Alert Monitor for long running Adaptive Server transactions. |
The following new and enhanced Sybase Control Center for Adaptive Server version 3.2.7 features are available with Adaptive Server version 15.7, ESD #2.
Feature | Topics |
---|---|
Common Security Infrastructure – updates to the CSI improve SCC security and provide consistency across Sybase products. |
— |
Find a resource in the Administration Console – use new search and filter tools to locate objects of interest. |
|
Data retrieval options – you can set thresholds to improve performance of the Administration Console. |
Configuring Retrieval Thresholds for the Administration Console |
Granular permissions – grant system privileges to construct site-specific roles with privileges to match your requirements and restrict system administrators and database owners from accessing user data. | |
Predicated privileges – use predicated privileges to provide a system of flexible row-level access controls, allowing you to grant, select, update, and delete privileges to different users, groups, or roles based on a predicate Adaptive Server evaluates when it accesses the data. |
— |
Precomputed result set – a precomputed result set
improves performance in databases where queries have common
sub-expressions resulting in repetitive operations on base tables.
The precomputed result set feature lets you:
|
|
Update statistics – updates include:
|
|
Diagnostic data wizard – use the Adaptive Server Field Diagnostic Utility and Optimizer Diagnostic Utility to collect diagnostic data for Adaptive Server. The generated diagnostic data package is used by the Sybase customer support organization. | |
Adaptive Server alerts – control how certain log
entries are flagged by setting an alert based on the number of flags
received or the severity of the flags. Flag definitions are
available based on these log-related KPIs (key performance indicators):
|
|
Database backup and restore – the database dump and load mechanism is provided to define, update, delete, and view multiple dump configurations. | |
Error logs – viewing server messages written to
the error log has been updated. The updates include:
|
|
Message rows – the status of each object retrieval request is provided in a message row in the Administration Console. Message rows provide details for slow-responding requests, large result sets, and failed requests. |