The schema is SYSPROC.
The SNAPSHOT_QUIESCERS function returns information about quiescers from a table space snapshot.
If the null value is specified, -1 is set implicitly.
The function returns a table as shown in the following section.
Column name | Data type | Description or corresponding monitor element |
---|---|---|
SNAPSHOT_TIMESTAMP | TIMESTAMP | snapshot_timestamp - Snapshot timestamp |
TABLESPACE_NAME | VARCHAR(128) | tablespace_name - Table space name |
QUIESCER_TBS_ID | BIGINT | quiescer_ts_id - Quiescer table space identification |
QUIESCER_OBJ_ID | BIGINT | quiescer_obj_id - Quiescer object identification |
QUIESCER_AUTH_ID | BIGINT | quiescer_auth_id - Quiescer user authorization identification |
QUIESCER_AGENT_ID | BIGINT | quiescer_agent_id - Quiescer agent identification |
QUIESCER_STATE | BIGINT | quiescer_state - Quiescer state |