Version 16.0

SAP^® Adaptive Server^® Enterprise version 16.0 introduces new features and enhancements.

• Increased Data Availability with Partition Locking
  The new partition-level locking feature increases data availability by providing locking to a finer granularity, which allows access to other partitions for concurrent DDL and DML statements.
• CIS Support for HANA Server
  SAP ASE version 16.0 adds the native ODBC interface to the Component Integration Services (CIS) so you can connect directly to a Hana server from SAP ASE.
• Relaxed Query Limits
  SAP ASE 16.0 increases some column and table restrictions.
• Query Plan Optimization with Star Joins
  SAP ASE 16.0 introduces the use fact_table abstract plan hint, which specifies the central fact table in a star join query and triggers special query plan optimization strategies for the star join query.
• Query Performance Improvements
  SAP ASE version 16.0 adds query performance improvements.
• Full-Text Auditing
  SAP ASE versions 16.0 and later support full-text DML auditing, printing parameter names and values with sensitive parameters masked for DML when you enable the DML auditing options (including table_access and view_access).
• Auditing for Authorization Checks Inside Stored Procedures
  The audit option sproc_auth enables auditing for authorization checks that are performed inside system stored procedures.
• Replacing Object Definitions
  Replace existing object definitions with new definitions while preserving the original name, object ID, auditing options, and permissions.
• Query Plan and Execution Statistics in HTML
  A new Dynamic Thread Assignment model has been introduced to enhance the use of worker threads.
• Index Compression
  Compression in a relational database allows more efficiently storage of data, reduced memory consumption, and improve performance due to lower I/O demands.
• SAP JVM Support
  SAP ASE versions 16.0 and later use SAP JRE to support Java applications.
• Full Database Encryption
  SAP ASE version 16.0 introduces the ability to encrypt entire databases, providing protection for an entire database without affecting existing applications.
• Scalability Enhancements and Features
  SAP ASE version 16.0 improves scalability by improving run-time logging and lock, metadata, and latch management.
• Monitoring Threshold-Based Events
  SAP ASE version 16.0 and later include the ability to configure, record, and list threshold events.
• Multiple Triggers
  Create multiple triggers, as well as specify the order in which the triggers are fired after statement execution.
• Residual Data Removal
  Remove residual data, which strengthens the security of database data.
• Configuration History Tracking
  SAP ASE version 16.0 add the sp_confighistory system procedure, which allows you to track changes to the server configuration.
• Cyclic Redundancy Checks for dump database
  SAP ASE adds a cyclic redundancy check for accidental changes to raw data for database or transaction dumps created with compression to check and for verification that the compression blocks can be correctly read and decompressed.
• Calculating the Transaction Log Growth Rate
  SAP ASE version 16.0 adds the sp_logging_rate system procedure, which calculates the transaction log growth rate for a specified time period.
• System Changes for SAP ASE Version 16.0
  SAP ASE 16.0 contains system changes.