The SAP Sybase IQ plug-in for Sybase Control Center (SCC) 3.2.7 provides complete administration and management functionality. SCC replaces the Sybase Central administration tool.
For documentation on administering SAP Sybase IQ with SCC, see the Sybase Control Center for SAP Sybase IQ online help at http://sybooks.sybase.com/sybooks/sybooks.xhtml?prodID=10680.
New/Enhanced Feature | Description |
---|---|
External Environments |
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. |
Tables |
Table administration – Perform table management tasks such as creating/deleting a base table and moving a table to another dbspace.
|
SAP Sybase IQ server and SCC agent logs | View and filter logs, copy and paste from log snapshots. The log displays as a static snapshot that does not refresh automatically. |
Domains |
Domain administration – Create, view and update domains. The Administration Console tree lists domains under schema objects. |
Views |
View administration – Perform view management tasks such as creating a view and recompiling a materialized view.
|
Web Services |
Web service administration – Perform web service management tasks such as creating, modifying, and deleting web services.
|
Logical Servers |
Logical server support has been enhanced as follows:
|
Login Mappings |
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 for multiplex |
Transport layer security – Configure transport layer security with RSA encryption in a multiplex environment. |
Global Transaction Resiliency |
Global transaction resiliency – Monitor the suspended, resumed, and rolled back status of INC (internode communication) connections for global transactions. |
Row-level Versioning |
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. |
Remote Access |
Remote Access – Access data from other data sources by creating Remote Server definitions, Proxy Tables, Remote Procedures and External Logins. |
LDAP Server |
LDAP server administration - Create, modify, and delete LDAP servers. |
Role-Based Security |
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. |
Triggers on Views |
View trigger administration – Create, modify, and delete triggers on views. |
Sequence Generator |
Sequence Generator administration - Create, modify, and delete sequence generators. |