SHOW SYSTEM DEFAULT

Use the SHOW SYSTEM DEFAULT command to display the session timeout, rowset limit, and query timeout values.

Syntax

Syntax for showing system defaults:

SHOW SYSTEM DEFAULT
  [SESSIONTIMEOUT | ROWSETLIMIT | QUERYTIMEOUT]
  [DEFPRIORITY | MAXPRIORITY ] | [MATERIALZE [REFRESH] THRESHOLD]
  [PASSWORDEXPIRY | PASSWORDPOLICY] | [TIME_TRAVEL_ENABLED]
  [DATA_VERSION_RETENTION_TIME]

Inputs

The SHOW SYSTEM DEFAULT command takes the following inputs:

Table 1. SHOW SYSTEM DEFAULT inputs
Input	Description
DEFPRIORITY	The default priority for the system.
MATERIALIZE THRESHOLD	The refresh threshold for materialized views. Including the phrase REFRESH in this parameter is optional and has no effect.
MAXPRIORITY	The maximum priority for the system.
QUERYTIMEOUT	The amount of time a query can run before the system sends the administrator a message. A 0 indicates that there is no limit.
ROWSETLIMIT	The number of rows a query can return. A 0 indicates that there is no limit.
SESSIONTIMEOUT	The amount of time a session can be idle before the system terminates it. A 0 indicates that there is no limit.
PASSWORDEXPIRY	Displays the system global default settings for password expiration in `n` number of days. The `n` count begins with the date of the last password change. A 0 indicates that the passwords do not expire.
PASSWORDPOLICY	Displays the system default settings for the password policy parameter string.
TIME_TRAVEL_ENABLED	Displays whether time travel is enabled (1) or disabled (0). The default value of 0 is displayed if TIME_TRAVEL_ENABLED was never explicitly set.
DATA_VERSION_RETENTION_TIME	Displays the system-wide default data version retention time, which is 0 if it was never explicitly set.

Output

The SHOW SYSTEM DEFAULT command has the following output:

Table 2. SHOW SYSTEM DEFAULT output
Output	Description
`NOTICE <option> = <value>`	The command was successful.

Privileges

You must be an administrator, or you must be able to connect to the database and schema.

Usage

The following provides sample usage.

To show the query timeout:

SYSTEM.ADMIN(ADMIN)=> SHOW SYSTEM DEFAULT QUERYTIMEOUT;
NOTICE:  'query timeout' = '0'
SHOW VARIABLE