SHOW SYSTEM DEFAULT

Use the SHOW SYSTEM DEFAULT command to display the session timeout, rowset limit, query timeout, default or maximum priority, materialized view refresh threshold, password policy or expiration, or data version retention time (for time travel).

Syntax

Syntax for showing system defaults:

SHOW SYSTEM DEFAULT
  [SESSIONTIMEOUT | ROWSETLIMIT | QUERYTIMEOUT]
  [DEFPRIORITY | MAXPRIORITY ] | [MATERIALIZE [REFRESH] THRESHOLD]
  [PASSWORDEXPIRY | PASSWORDPOLICY] |
  [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.
DATA_VERSION_RETENTION_TIME	Displays the system-wide default data version retention time, which is 0 if it was never explicitly set. For more information about data version retention time and time travel, see Getting started with Netezza Performance Server time travel.

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