Skip to Content
Author's profile photo April Luo

SAP Adaptive Server Enterprise 16.0 SP03 PL04 New Features

SAP Adaptive Server Enterprise 16.0 SP03 PL04 releases quite a number of valuable new features. We will introduce the following major enhancements to you in this blog:

  • aseuserstore utility
  • backup server with SSL
  • automatic memory management in HADR
  • IMRS enabled for HADR


Secure user store allows you to automate database administration tasks without compromising data confidentiality by connecting to an SAP ASE server without entering a username and password in the command line. With secure user store, you can establish the connection between a client application and an SAP ASE server using a user-generated key that retrieves the connection information (username, password, host, and port number) from the secure store.

You can use the aseuserstore utility to insert, list, and delete the connection information in the form of user keys in the secure store. The utility supports ADO.NET, ODBC, jConnect, and SAP ASE native client applications, as well as the SAP ASE utilities isql, bcp, and defncopy.

The following properties are added to each client to support this feature:

  • For CT-Library – Connection property CS_SECSTOREKEY
  • For JDBC/jConnect – Connection property SECURE_STORE_KEY
  • For ODBC – Connection property SecStoreKey
  • For ADO.NET – Connection property SecStoreKey

See Securely Automate Database Administration Tasks Using Secure User Store.

Backup Server with SSL

Backup server supports SSL for communication with SAP ASE, and for data transfer with other backup servers, when using remote dumps and/or loads.

See Enabling SSL in the Backup Server, and backupserver.

Automatic Memory Management in HADR

With SAP Replication Server automatic memory management, you can replicate multiple databases (certificated with 20) at the same time with low total cost of ownership (TCO) and simple configuration steps, which makes it easier to deploy and manage multiple pairs of databases in the HADR environment.

See Automatic Memory Management for more details.

IMRS Enabled for HADR

HADR supports the replication of databases enabled for in-memory row storage (IMRS). The following changes are introduced to support IMRS.

Feature Description
RepAgent support for the sysimrslogs scanner

The sysimrslogs scanner reads logs of IMRS-enabled databases.

See Monitoring the Scanners.

System table support for the sysimrslogs scanner The following system tables provide diagnostic data for the sysimrslogs scanner:


Want to know about more features in SAP ASE 16.0 SP03 PL04 release? Take a look at our What’s New guide on the SAP Help Portal.

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.