Sybase Control Center Changes

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.

Brief descriptions of new and enhanced features in SCC 3.2.7:

Sybase Control Center Changes
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. Creating/deleting a base table Creating/deleting a global temporary table Creating/deleting a proxy table Modifying table properties Moving a table to another dbspace Managing table columns Managing table constraints Managing table indexes Managing table partitions Managing IQ catalog store (system store) table triggers Generating table DDL commands Viewing table data in the Execute SQL window
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. Creating a view Modifying a view Disabling a view Recompiling and enabling a view Deleting a view Generating view DDL commands Managing triggers on an IQ catalog store (system store) view Listing materialized views Creating a materialized view Modifying a materialized view Validating materialized view data Refreshing materialized view data Unloading materialized view data Truncating materialized view data Setting a clustered index on a materialized view Disabling a materialized view Recompiling a materialized view Generating materialized view DDL commands Managing triggers on a materialized view
Web Services	Web service administration – Perform web service management tasks such as creating, modifying, and deleting web services. Creating a Web service Enabling a Web service Disabling a Web service Modifying a Web service Deleting a Web service Generating Web service DDL commands
Logical Servers	Logical server support has been enhanced as follows: When you authenticate a multiplex server resource, SCC automatically generates one logical server resource per logical server, if one does not already exist. SCC sets the resource name to the multiplex name followed by a colon and the logical server name. For example, `myMPX1:MyLS1`. Create, edit, and delete logical server policies to control logical server access and context. Monitor logical servers from the Perspective Resources View, Heat Chart, or Administration Console. For better load balancing, SAP Sybase IQ can now redirect new multiplex logins to a node with a lighter load in the same logical server. Two generated administration scripts include new connection parameters in the connection string: Stop_server.sh (.bat) includes `LS=SERVER` Sync_server.sh (.bat) includes `LS=COORDINATOR`
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.