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
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.
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.
|RepAgent support for the sysimrslogs scanner||
The sysimrslogs scanner reads logs of IMRS-enabled databases.
|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.