New Features in Sybase Control Center for SAP Sybase IQ

Role-based security administration – Perform user and role management for role-based users, user-extended roles, and standalone roles. Tasks include create, modify and delete, as well as grant and revoke system privileges and object permissions to users and roles.

Domain administration – Create, view and update domains. The Administration Console tree lists domains under schema objects.

External environment administration – In previous releases, only the Java external environment was supported. In SCC 3.2.7, you can administer these external environments: ODBC, ESQL, .NET, Java, Perl, PHP.

Table administration – Perform table management tasks such as creating/deleting a base table and moving a table to another dbspace.

Table column administration – Add, modify, and delete table columns.

Table constraint administration – Manage column check, foreign key, table check, and unique constraints.

Table index administration – Add, modify, delete, rebuild, validate, and move indexes on table columns.

Table partition administration – Create, modify, delete, unpartition, merge, split, and move table partitions.

Table trigger administration – Create, modify, and delete triggers on tables.

View administration – Perform view management tasks such as creating a view and recompiling a materialized view.

View trigger administration – Create, modify, and delete triggers on views.

LDAP server administration - Create, modify, and delete LDAP servers.

Sequence Generator administration - Create, modify, and delete sequence generators.

Row-level Versioning (RLV) – Use the new RLV data store in your simplex database to perform row-level updates, inserts, and deletes, in real-time. When a table is enabled for storage in the RLV data store, multiple users can write to different rows of the table concurrently.

Creating a Dbspace

Creating a Dbfile

Enabling RLV in a Table

Remote Access – Access data from other data sources by creating Remote Server definitions, Proxy Tables, Remote Procedures and External Logins.

Remote Servers

External Logins

Proxy Tables

Remote Procedures

Web service administration – Perform web service management tasks such as creating, modifying, and deleting web services.

Logical server administration – Logical server administration and monitoring and logical server policy administration have been enhanced.

Logical Servers

Key Performance Indicators for SAP Sybase IQ

Global transaction resiliency – Monitor the suspended, resumed, and rolled back status of INC (internode communication) connections for global transactions.

Viewing Multiplex Connection Statistics

Key Performance Indicators for SAP Sybase IQ

Spatial Data – Administer spatial reference systems, and spatial units of measure.

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.

Login mappings – Map a Windows user profile or a Kerberos principal to an existing user in the database to maintain a single user ID for database connections, operating system, and network logins.

Transport layer security – Configure transport layer security with RSA encryption in a multiplex environment.

Data retrieval options – you can set thresholds to improve performance of the Administration Console.

View and filter logs, copy and paste from log snapshots.

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.

Browsing and Managing Resources

Administration scripts – The scripts sync_server.sh (.bat) and stop_server.sh (.bat) now require your login and password. For example sync_server.sh <login> <password>.