SYSCS_UTIL.SYSCS_GET_GLOBAL_DATABASE_PROPERTY Function

The SYSCS_UTIL.SYSCS_GET_GLOBAL_DATABASE_PROPERTY function fetches the value of the specified property of the database.

Syntax

VARCHAR(32672) SYSCS_UTIL.SYSCS_GET_GLOBAL_DATABASE_PROPERTY(
  IN Key VARCHAR(128)
  )

Key

The key for the property whose value you want.

An error occurs if Key is null.

Results

Returns the value of the property. If the value that was set for the property is invalid, the SYSCS_UTIL.SYSCS_GET_GLOBAL_DATABASE_PROPERTY function returns the invalid value, but Splice Machine uses the default value.

Execute Privileges

If authentication and SQL authorization are both enabled, only the database owner has execute privileges on this function by default. The database owner can grant access to other users.

SQL Example

Retrieve the value of the splicemachine.locks.deadlockTimeout property:

splice> VALUES SYSCS_UTIL.SYSCS_GET_GLOBAL_DATABASE_PROPERTY( 'splicemachine.locks.deadlockTimeout' );
1
-------------------------------------------------------------
10

1 row selected

See Also