New Features

New features were introduced in SAP Sybase IQ 16.0.

• Sybase Control Center
  Sybase Control Center is a Web-based administrative console that replaces Sybase Central.
• Concealment of Sensitive Information in Output Requests
  Sensitive information - passwords and encryption keys - is now hidden when statements are printed to request level logs, are logged by diagnostic tracing, or when expressions containing sensitive information are used as column names.
• Connection Blocking
  Connection blocking blocks a statement until a server write-lock becomes available. The new connection blocking behavior enables competing write-transactions to establish their snapshot versions more efficiently and collaboratively, minimizing lock contention during table writes to the IQ main store and RLV store.
• Global Transaction Resiliency
  DML read-write transactions on multiplex writer nodes now survive temporary communication failures between coordinator and writer nodes and temporary failure of the coordinator due to server failure, shutdown or failover. Prior to SAP Sybase IQ 16.0 such failures guaranteed failure of the global transaction on the writer node and required the user to roll back the entire transaction.
• Login Redirection
  SAP Sybase IQ 16.0 provides load balancing when a user tries to log into an overloaded node by redirecting the attempted login to a node that is less loaded in the same logical server.
• RLV Data Store for Write-Optimized Storage
  Use the new row-level versioning (RLV) data store in your simplex database to perform row-level updates, inserts, and deletes, in real-time. When a table is registered for storage in the RLV data store, multiple users can write to different rows of the same table concurrently.
• Scale-Up and Scale-Out Performance Features
  Scale up features take advantage of multiple cores and high parallelism in a single servers to provide high load and query performance. Multiplex and logical servers scale-out to multiple servers to improve query performance.
• Security Management
  New features pertaining to security, user management, and LDAP user authentication.
• Shared System Temporary Store
  A multiplex configuration with shared temporary storage can use the IQ_SHARED_TEMP dbspace as a shared system temporary store instead of requiring a separate local store for each secondary server. The shared system temporary store simplifies multiplex configuration, improves performance, and supports distributed query processing.
• Table Partitioning
  Table partitioning can improve performance by dividing large tables into smaller, more manageable storage objects. SAP Sybase IQ 16.0 now supports range, hash, and hash-range partitioning schemes.
• System Secure Feature Keys
  The system secure feature key now allows you to create customized secure feature keys that are assigned to a specific users, limiting users' access to only the features secured by the administrator for that key.