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 s
p_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:
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.
