What’s new in SAP Adaptive Server Enterprise 16.0 SP03 PL03
SAP Adaptive Server Enterprise (SAP ASE) version 16.0 SP03 PL03 contains several enhancements and new features.
In this blog we will talk about the following four major enhancements:
- A new parameter for the password_random function
- The new set statistics ioplan {on | off} command
- Three new system procedures for SAP ASE monitoring: sp_w, sp_p, sp_sp
- Customizing up to five file directories for database, transfer log, log, configuration, and backup files in both the HADR pair and the DR node
New parameter for the password_random function
The password_random function gets a new substring parameter.
You can use the substring parameter to specify a sub-string that is not to be used as part of a random password when the disallow simple passwords password complexity check is set to true.
For details, see password_random.
New set statistics ioplan {on | off} command
When set to On, this command displays the IO statistics per plan for each view.
For more details, see set.
New system procedures for SAP ASE monitoring
SAP ASE 16.0 SP03 PL03 introduces three new system procedures for ASE monitoring: sp_w, sp_p, and sp_sp.
These system procedures are the simplified versions of the existing sp_who and sp_showplan system procedures. sp_w returns information about all current SAP ASE users and processes; sp_p displays the concise output of the query plan while sp_sp displays the extended output of the query plan.
For details, see sp_w, sp_p, and sp_sp.
Customizing file directories in HADR pair and DR node
Both the HADR pair and DR node now support up to five customized directories for database, transfer log, log, configuration, and backup files.
Note: This functionality is available for Linux platforms only.
To customize the file directories, configure the following parameters in the response file:
| Parameter | Description | Sample Value |
| dm_database_file_directory | The database file directory | $SYBASE/<SID>/database |
| dm_translog_file_directory | The translog file directory | $SYBASE/<SID>/translog |
| dm_log_file_directory | The log file directory | $SYBASE/<SID>/log |
| dm_config_file_directory | The configuration file directory | $SYBASE/<SID>/cfg |
| dm_backup_file_directory_for_database | The backup file directory for database | $SYBASE/<SID>/backup |
For details, see Customizing File Directories.
Thank you for reading!
For more information, see documentation for SAP Adaptive Enterprise version 16.0 SP03 PL03 on the SAP Help Portal.