The SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY function fetches the value of the specified property of the database on the current connection.
If the value that was set for the property is invalid, the SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY function returns the invalid value, but Derby uses the default value.
VARCHAR(32672) SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY(IN KEY VARCHAR(128))
An error will be returned if KEY is null.
If authentication and SQL authorization are both enabled, only the database owner has execute privileges on this function by default. See "Configuring user authentication" and "Configuring user authorization" in the Derby Security Guide for more information. The database owner can grant access to other users.
Retrieve the value of the derby.locks.deadlockTimeout property:
VALUES SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('derby.locks.deadlockTimeout');