Version 15.7 ESD #2

Adaptive Server® version 15.7 ESD #2 introduces many new features and enhancements.

• Granular Permissions
  Granular permissions enable you to grant system privileges, allowing you to construct site-specific roles with privileges to match your requirements, and restrict system administrators and database owners from accessing user data.
• Predicated Privileges
  Predicated privileges provide a system of flexible row-level access controls, allowing you to grant select, update, and delete privileges to different users, groups, or roles based on a predicate Adaptive Server evaluates when it accesses the data. If the condition expressed by the predicate is not met for any row of data, Adaptive Server withholds that row from the result set.
• Deferred Table Creation
  create table...with deferred_allocation allows you defer the page allocation for a table.
• Online Utilities
  Adaptive Server versions 15.7 ESD # 1 and later include an online parameter for reorg rebuild that lets you reorganize data and perform maintenance on tables without blocking users data from users.
• Merging and Splitting Partitions
  Over time, a partition’s data distribution may become skewed, or the manner in which the data was originally partitioned may not suit current business requirements. Use alter table to merge, split, or move partitions to redistribute the data and revive the performance benefits of using partitions.
• Maximum Size of Query in the Statement Cache
  Adaptive Server versions 15.7 ESD #2 and later allow you to store very large SQL statements. You can save individual statements of up to 2MB (for a 64-bit machine) in the statement cache.
• Enhancements to show_cached_plan_in_xml
  Adaptive Server versions 15.7 ESD #2 and later include new information for show_cached_plan_in_xml.
• Fast-Logged Bulk Copy
  Adaptive Server version 15.7 ESD #2 and later allows you to fully log bcp in fast mode, which provides faster data throughput and full data recovery. Earlier versions logged only page allocations.
• Precomputed Result Sets
  Adaptive Server versions 15.7 ESD #2 and later allow you to create precomputed result sets.
• Concurrent dump database and dump transaction Commands
  Adaptive Server versions 15.7 ESD #2 and later allow a dump transaction command to run concurrently with a dump database command, reducing the risk of losing database updates for a longer period than that established by the dump policy.
• Hash-Based Update Statistics
  Adaptive Server versions 15.7 ESD #2 and later allow you to gather hash-based statistics on minor index attributes and unindexed columns instead of using sort-based statistics, significantly reducing elapsed time and resource usage. Using hash-based statistics improves performance by reducing the number of required scans, and avoiding disk-based sorting.
• Enhancements to dump and load
  Adaptive Server 15.7 ESD #2 includes enhancements to the dump and load commands, which make it easier for you to back up and restore your databases.
• alter table drop column without datacopy
  Adaptive Server versions 15.7 ESD #2 and later add the no datacopy parameter to the alter table ... drop column command, which allows you to drop columns from a table without performing a data copy, reducing the amount of time required for alter table ... drop column to run.
• Expanded Maximum Database Size
  Adaptive Server versions 15.7 ESD #2 and later expand the maximum size of a database to approximately 64 terabytes by converting the logical page number from a signed integer to an unsigned integer.
• User-Defined Optimization Goal
  Adaptive Server versions 15.7, ESD #2 and later allow you to create user-defined optimization goals.
• Shared Query Plans
  Adaptive Server versions 15.7 ESD #2 and later allow you to share query plans, which are cloned from primary query plans, avoiding the need for Adaptive Server to create or recompile query plans that are identical to existing plans.
• Initializing Databases Asynchronously
  Adaptive Server versions 15.7 ESD #2 and later include the async_init parameter for the alter database and create database commands, which allows you to asynchronously initialize a database while it is being used.
• In-Row Large Object Compression
  Adaptive Server versions 15.7 ESD #2 and later support in-row large object (LOB) compression.
• Configuring Shared Memory Dumps
  Adaptive Server versions 15.7 ESD #2 and later allow you to automatically perform compressed, shared memory dumps according to specific, configurable conditions.
• System Changes for Adaptive Server Version 15.7 ESD #2
  Adaptive Server 15.7 ESD #2 includes changes to commands, functions, system procedures, configuration parameters, system tables, and monitoring tables.