System Changes for SAP ASE Version 16.0

Returns the name of the trigger that is currently executing

Returns the type of rollback encountered, if any.

Allows you to run alter table ... add | drop partition commands while Adaptive Server runs isolation level 0 scans.

Configures SAP ASE preallocate large amounts of memory for query execution, which reduces procedure cache contention

Allows you to modify the engine local cache as a percentage of procedure cache.

Enables large allocation in the engine local cache.

Sets the SAP ASE scheduler task stealing policy to aggressive.

Specifies how many levels deep SAP ASE peeks into a connections operating system receive buffer for a pending cancel.

Determines whether a queueing strategy is used for logging.

Enable or disable threshold-event recording.

Determines the number of events stores in the monThresholdEvent table.

Fully encrypt an existing database.

Change the compression state of future index inserts or updates using the index_compression clause.

For:

• Index compression – change the compression state of future index inserts or updates using the index_compression clause.
• Multiple triggers – the table owner can disable any or all of the multiple triggers defined on that table.
• Residual data removal – automatically remove residual data following delete operations.

Create a fully encrypted archive database.

Create a fully encrypted database.

Replace an object's definition using the or replace clause.

Create a database encryption key.

Replace an object's definition using the or replace clause.

Replace a user-defined SQLJ function's definition using the or replace clause.

Compress an index or index partition with the index_compression clause.

Replace an object's definition using the or replace clause.

Replace a SQLJ procedure definition using the or replace clause.

Replace an object's definition using the or replace clause.

For:

• Index compression – compress indexes on a specified table using the index_compression clause.
• Residual data removal – Create a new table that automatically removes residual data when deletions occur.

For:

• Multiple triggers – Create multiple triggers, as well as specify the order in which the triggers are fired after you execute a command.
• or replace – replace an object's definition using create trigger using the or replace clause.

Replace an object's definition using create view using the or replace clause.

Delete the database encryption key from the sysencryptkeys table in the master database

Use to remove or replace an existing trigger, or multiple triggers.

Adds a cyclic redundancy check for accidental changes to raw data for database or transaction dumps created with compression.

Adds the with force parameter if you cannot terminiate the process with the regular kill spid parameter.

Adds a cyclic redundancy check for accidental changes to raw data for compressed database or transaction dumps.

Issuing select statements that reference only @variables, @@global variables, and constants on SAP ASE version 16.0 and later in chained mode do not start new transactions.

Creates an index compressed table by selecting from an existing table.

For:

• Multiple Triggers – set show_trigger_execution prints to the error log the name of the trigger as it is fired, to help you identify where any processing problems are occurring.
• Residual data removal – set erase_residual_data {on | off} enables the ability to erase residual data.

Reports on the encryption/decryption status and progress of a database.

Creates the ch_events view and displays changes made to SAP ASE configuration.

Removes partition lock promotion values.

Removes row partition lock promotion threshold values from a database or table.

Use to:

• View a list of all the triggers for each of the DML actions against a table
• See the orders of those triggers that specified the order clause when created

Configures the Job Scheduler Agent.

Calculates the transaction log growth rate for the specified time period.

Sets page-lock promotion thresholds for partitions at the server, database, and the table.

Sets row-lock promotion thresholds for partitions at the server, database, and the table.

Adds these auditing options:

• config_history – enables or disables auditing for configuration history.
• sproc_auth – enables or disables auditing for authorization checks that are performed inside system stored procedures.

Adds the pnt_locking table attribute, which enables and disables partition-level locking.

Output enhanced to print cluster lock usage specific to partition lock information.

Removes residual data from delete operations in SAP ASE using the erase residual data parameter.

Lists the multiple triggers associated with the table.

Supports encrypted databases

Output enhanced to include the partitionid column.

Output enhanced to include information about encrypted databases

Output enhanced to include the partitionid column.

Contains one row for each configuration change event. ch_events is located in the sysmgmtdb database.

There are no new columns, however the encrypted database feature introduces 43, a new class that signifies database encryption.

There are no new columns, however now includes information about multiple triggers.

Changes what sysobjects saves for multiple triggers.

Includes one row for each event recorded by SAP ASE.

• Updates metrics for some columns in 5 second increments.
• Increments the UseCount column when statement begin execution
• Increments the value for columns that describe maximums for currently executing statements.

The partitionid column displays the unique identifier for the partition.

The partitionid column displays the unique identifier for the partition.

Adds a number of columns

Adds a number of columns

ClientDriverVersion column displays the connectivity driver used by the client program.

Require that you enable the activate monitoring configuration parameter to start collecting monitoring data.

Changes the Status column.

changes the name of the MRPBootstrapTime column to BootstrapTime.

(Cluster Edition only) The ExecutionTime column displays values for NetworkIO, DeviceIO, and CIPCIO.

The Description column in SAP ASE 16.0 and later supports 512 characters. Previous releases supported 255 characters.

• The Description column in SAP ASE version 16.0 and later supports 512 characters. Previous versions supported 255 characters.
• The Label column in SAP ASE version 16.0 and later supports 150 characters. Previous versions support 50 characters.

Supports encrypted databases

Supports encrypted databases

Supports restoring an SAP ASE after a master database corruption