The SNAPAGENT administrative view and the SNAP_GET_AGENT table function return information about agents from an application snapshot, in particular, the agent logical data group.
This administrative view allows you to retrieve agent logical data group application snapshot information for the currently connected database.
Used with the SNAPAGENT_MEMORY_POOL, SNAPAPPL, SNAPAPPL_INFO, SNAPSTMT and SNAPSUBSECTION administrative views, the SNAPAGENT administrative view provides information equivalent to the GET SNAPSHOT FOR APPLICATIONS ON database-alias CLP command, but retrieves data from all database partitions.
The schema is SYSIBMADM.
Refer to Table 1 for a complete list of information that can be returned.
SELECT * FROM SYSIBMADM.SNAPAGENT
SNAPSHOT_TIMESTAMP DB_NAME AGENT_ID ...
-------------------------- -------...- ---------...--- ...
2005-07-19-11.03.26.740423 SAMPLE 101 ...
2005-07-19-11.03.26.740423 SAMPLE 49 ...
...
2 record(s) selected. ...
... AGENT_PID LOCK_TIMEOUT_VAL DBPARTITIONNUM
... -------------------- -------------------- --------------
... 11980 -1 0
... 15940 -1 0
...
...
The SNAP_GET_AGENT table function returns the same information as the SNAPAGENT administrative view, but allows you to retrieve the information for a specific database on a specific database partition, aggregate of all database partitions or all database partitions.
Used with the SNAP_GET_AGENT_MEMORY_POOL, SNAP_GET_APPL_V95, SNAP_GET_APPL_INFO_V95, SNAP_GET_STMT and SNAP_GET_SUBSECTION table functions, the SNAP_GET_AGENT table function provides information equivalent to the GET SNAPSHOT FOR ALL APPLICATIONS CLP command, but retrieves data from all database partitions.
Refer to Table 1 for a complete list of information that can be returned.
>>-SNAP_GET_AGENT--(--dbname--+------------------+--)---------->< '-, dbpartitionnum-'
The schema is SYSPROC.
If both dbname and dbpartitionnum are set to NULL, an attempt is made to read data from the file created by SNAP_WRITE_FILE procedure. Note that this file could have been created at any time, which means that the data might not be current. If a file with the corresponding snapshot API request type does not exist, then the SNAP_GET_AGENT table function takes a snapshot for the currently connected database and database partition number.
SELECT * FROM TABLE(SNAP_GET_AGENT(CAST(NULL AS VARCHAR(128)), -1)) AS T
SNAPSHOT_TIMESTAMP DB_NAME AGENT_ID ...
-------------------------- -------...- --------...-- ...
2006-01-03-17.21.38.530785 SAMPLE 48 ...
2006-01-03-17.21.38.530785 SAMPLE 47 ...
2006-01-03-17.21.38.530785 SAMPLE 46 ...
2006-01-03-17.21.38.530785 TESTDB 30 ...
2006-01-03-17.21.38.530785 TESTDB 29 ...
2006-01-03-17.21.38.530785 TESTDB 28 ...
6 record(s) selected.
... AGENT_PID LOCK_TIMEOUT_VAL DBPARTITIONNUM
... ---------...---- -------------------- --------------
... 7696 -1 0
... 8536 -1 0
... 6672 -1 0
... 2332 -1 0
... 8360 -1 0
... 6736 -1 0
...
Column name | Data type | Description or corresponding monitor element |
---|---|---|
SNAPSHOT_TIMESTAMP | TIMESTAMP | snapshot_timestamp - Snapshot timestamp monitor element |
DB_NAME | VARCHAR(128) | db_name - Database name |
AGENT_ID | BIGINT | agent_id - Application handle (agent ID) |
AGENT_PID | BIGINT | agent_pid - Engine dispatchable unit (EDU) |
LOCK_TIMEOUT_VAL | BIGINT | lock_timeout_val - Lock timeout (seconds) |
DBPARTITIONNUM | SMALLINT | The database partition from which the data for the row was retrieved. |