2447907 - EWA report for SAP ASE database is recommending that Database Options are not set correctly

You are getting the following alert on the EWA report:

12.1.7 Database Options
The session was unable to read your current system settings, these are the default settings.

Recommendation: One or more database options are not set correctly. We strongly recommend that you set the following database options for the SAP ASE database. The current settings can be checked using the stored procedure
sp_helpdb 'DEV'.

Database options are an important feature of any database. Options control the behavior of the database and must be set for each database individually. The database option settings for a database are determined by the needs of the application.

Database options are set using the stored procedure 'sp_dboption'; you have to be in the master database to set a database option. For details, also see SAP Note 1749935. (Configuration Guide for SAP ASE 15.7), 'Database Options' section.

For example: sp_dboption <SID>,'ddl in tran','true'
The following important database options are required for an SAP ASE database.
<SID> -> ddl in tran
<SID> -> allow nulls by default
<SID> -> allow wide dol rows
<SID> -> enforce dump tran sequence
<SID> -> full logging for all
saptools -> ddl in tran
saptools -> allow nulls by default
saptools -> allow wide dol rows

The following important database options are recommended for an SAP ASE database.
<SID> -> deallocate first text page
<SID> -> abort tran on log full
<SID> -> page compression
sybsystemdb -> trunc log on chkpt

SAP ASE database

KBA , SV-SMG-SER-EWA , EarlyWatch Alert , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem