Version 15.7 SP100

Adaptive Server version 15.7 SP100 introduces new features and enhancements.

• Adaptive Server 15.7 SP100 Feature and Platform Matrix
  The feature and platform matrix shows feature availability for supported operating systems in Adaptive Server 15.7 SP100. A “Y” indicates the feature is supported for that platform.
• Shrinking Databases
  In Adaptive Server versions 15.7 SP100 and later, use the alter database command to shrink databases, freeing unused space for reuse or deletion.
• Enhancements to Backup and Restore
  Adaptive Server 15.7 SP100 includes enhancements to the dump database and load database commands.
• Aggregating Metrics from Syntactically Similar Queries
  Adaptive Server 15.7 SP100 includes the show_condensed_text function, which lets you aggregate monitoring data for multiple statements in the statement cache that, although syntactically distinct (having individual comments or differences in their text format), represent semantically identical queries.
• Updates to Precomputed Result Sets
  Updates to the precomputed result sets include grant and revoke access permissions for precomputed result sets created with the immediate refresh parameter for the select, update statistics, and delete statistics commands. Also, sp_showoptstats and sp_depends display additional information about precomputed result sets.
• Improved Data Load Performance
  Adaptive Server 15.7 SP100 improves data load performance by enabling ins_by_bulk optimization criteria, which uses bulk-data row inserts for insert statements.
• Incremental Reorganization
  Adaptive Server 15.7 SP100 includes a new parameter—defrag—for the reorg command that lets you schedule and resume reorganization, and allows concurrent reads or writes on the data being reorganized.
• Creating Indexes Without Blocking Access to Data
  Adaptive Server 15.7 SP100 includes the create index ... online parameter, which allows you to create indexes without blocking access to the data you are indexing
• Query Plan and Execution Statistics in HTML
  In Adaptive Server versions 15.7 SP100 and later, you can generate a graphical query plan in HTML format that you can view in a Web browser.
• Gathering Hash-Based Statistics with create index
  Adaptive Server 15.7 SP100 extends the support of gathering hash-based statistics to the create index command.
• Query Plan Optimization with Bloom Filters
  Adaptive Server 15.7 SP100 introduces bloom filters, which optimize query plans by improving join performance.
• Support for Replication by Column Value
  Adaptive Server 15.7 SP100 extends Multi-Path Replication™ by including a new distribution model that provides support for distributing replicated rows based on the data values in one or more columns in a single table.
• Support for Multiple Scanner Threads
  The Adaptive Server monitoring tables support multiple scanner threads for RepAgent.
• Sybase Central Adaptive Server Plug-in
  Sybase® no longer maintains the Sybase Central Adaptive Server plug-in. In Adaptive Server versions 15.7 SP100 and later, use Sybase Control Center for Adaptive Server.
• Running Adaptive Server on VMware vSphere
  Adaptive Server version 15.7 SP100 supports VMware vSphere.
• Support for OData
  Adaptive Server version 15.7 SP100 supports SAP® Sybase OData Server which enables data services over RESTful HTTP, allowing you to perform operations through URIs (Universal Resource Identifiers) to access and modify information.
• Support for NTLM and MIT Kerberos on Windows 64-bit
  MIT Kerberos and NT Lan Manager security services are supported on Windows 64-bit.
• Properties Added to Responses File
  New properties have been added to the Adaptive Server responses file for all platforms.
• Automatic Physical Database Rearrangement
  When loading a dump of a database that had a segregated log and data segment, Adaptive Server 15.7 SP100 and later will now rearrange the physical layout of the target database to ensure physical separation of the log and data segments.
• System Changes for Adaptive Server Version 15.7 SP100
  Adaptive Server 15.7 SP100 includes changes to commands, functions, system procedures, configuration parameters, system tables, and monitoring tables.