#8 Dbmaintain consider DB2 warnings as success script.

[Edo]

Hello,

Actually DB2 warnings are considered like a successful script exécution by dbmaintain (exit code 2), so it will be valuable de set the mininum exit code level in the dbmaintain.properties to asses the correct execution of the script and display command output again custom requirements.

If a create index generate warning it will be nice to notify the user to fix the script.
A simple thing will be to put the exit code at the end of the the exec statement in the logs and change the log level INFOS to WARN like this :

WARN: Executed newly added indexed script: incremental/01//01_init-ddl.sql (8073 ms) exit code : 2

Actually only exite code 4 & 8 generate an error and output command result.

Best regards,

Edo