The schema is SYSIBMADM.
In a non-restrictive database, SELECT privilege is granted to PUBLIC when the view is automatically created.
SELECT SNAPSHOT_TIMESTAMP, SUBSTR(AUTHID,1,10) AS AUTHID,
SUBSTR(APPL_NAME,1,10) AS APPL_NAME,AGENT_ID,
PERCENT_ROWS_SELECTED, DBPARTITIONNUM
FROM SYSIBMADM.APPL_PERFORMANCE
SNAPSHOT_TIMESTAMP AUTHID APPL_NAME ...
-------------------------- ---------- ---------- ...
2006-01-07-17.01.15.966668 JESSICAE db2bp.exe ...
2006-01-07-17.01.15.980278 JESSICAE db2taskd ...
2006-01-07-17.01.15.980278 JESSICAE db2bp.exe ...
...
3 record(s) selected. ...
... AGENT_ID PERCENT_ROWS_SELECTED DBPARTITIONNUM
... --------...-- --------------------- --------------
... 67 - 1
... 68 - 0
... 67 57.14 0
...
Column name | Data type | Description or corresponding monitor element |
---|---|---|
SNAPSHOT_TIMESTAMP | TIMESTAMP | The date and time that the snapshot was taken. |
AUTHID | VARCHAR(128) | auth_id - Authorization ID |
APPL_NAME | VARCHAR(256) | appl_name - Application name |
AGENT_ID | BIGINT | agent_id - Application handle (agent ID) |
PERCENT_ROWS_SELECTED | DECIMAL(5,2) | The percent of rows read from disk that were
actually returned to the application. Note: The percentage shown will not be greater than 100.00 percent.
|
DBPARTITIONNUM | SMALLINT | dbpartitionnum - Database partition number monitor element |
MEMBER | SMALLINT | member - Database member monitor element |