To determine whether a particular security service, such as “mutualauth” is enabled, use the function is_sec_service_on. The following is the syntax, where security_service_nm is a security service that is available:
is_sec_service_on(security_service_nm)
Use the name that is displayed when you query syssecmechs.
For example, to determine whether “mutualauth” is enabled, execute:
select is_sec_service_on("mutualauth")
----------- 1 (1 row affected)
A result of 1 indicates the security service is enabled for the session. A result of 0 indicates the service is not in use.
