HEALTH_DB_HI 表函数
HEALTH_DB_HI 表函数从数据库的运行状况快照返回运行状况指示器信息。
重要信息: 不推荐使用此表函数，在将来的发行版中可能会将其除去，因为在版本 9.7中已不推荐使用运行状况监视器。 它在 Db2® pureScale® 环境中不受支持。 有关更多信息，请参阅 已不推荐使用运行状况监视器。。
语法
模式为 SYSPROC。
表函数参数
- dbname
- 类型为 VARCHAR (255) 的输入参数，用于在调用此函数时指定与当前连接的数据库相同的实例中的有效数据库名称。 指定目录条目类型为 "Indirect" 或 "Home" 的数据库名称，如 LIST DATABASE DIRECTORY 命令所返回。 指定空值以从数据库实例下的所有数据库获取快照。
- 成员
- 类型为 INTEGER 的输入参数，用于指定有效的数据库成员编号。 对当前数据库成员指定 -1 ，或对所有活动数据库成员的聚集指定 -2 。 活动数据库成员是数据库可供应用程序连接和使用的成员。
权限
需要下列其中一项权限才能执行此例程：
- 对例程的 EXECUTE 特权
- DATAACCESS 权限
- DBADM 权限
- SQLADM 权限
缺省 PUBLIC 特权
在非限制性数据库中，当自动创建该功能时，将向 PUBLIC 授予 EXECUTE 特权。
示例
SELECT * FROM TABLE(HEALTH_DB_HI('',-1)) AS T下列是从此查询输出的示例。
SNAPSHOT_TIMESTAMP HI_ID DB_NAME HI_VALUE ...
-------------------------- -----...- -------...- -------- ...
2006-02-13-12.30.23.949888 1001 SAMPLE 0 ...
2006-02-13-12.30.23.949888 1002 SAMPLE 0 ...
2006-02-13-12.30.23.949888 1003 SAMPLE 0 ...
2006-02-13-12.30.23.949888 1005 SAMPLE 6 ...
2006-02-13-12.30.23.949888 1006 SAMPLE 53 ...
2006-02-13-12.30.23.949888 1008 SAMPLE 3 ...
2006-02-13-12.30.23.949888 1010 SAMPLE 0 ...
2006-02-13-12.30.23.949888 1014 SAMPLE 74 ...
2006-02-13-12.30.23.949888 1015 SAMPLE 1 ...
2006-02-13-12.30.23.949888 1018 SAMPLE 1 ...
2006-02-13-12.30.23.949888 1022 SAMPLE 1 ...
11 record(s) selected.
此查询的输出（继续）。
... HI_TIMESTAMP HI_ALERT_STATE HI_ALERT_STATE_DETAIL ...
... -------------------------- -------------- --------------------- ...
... 2006-02-13-12.26.26.158000 1 Normal ...
... 2006-02-13-12.26.26.158000 1 Normal ...
... 2006-02-13-12.26.26.158000 1 Normal ...
... 2006-02-13-12.26.26.158000 1 Normal ...
... 2006-02-13-12.26.26.158000 1 Normal ...
... 2006-02-13-12.26.26.158000 1 Normal ...
... 2006-02-13-12.26.26.158000 1 Normal ...
... 2006-02-13-12.26.26.158000 1 Normal ...
... 2006-02-13-12.30.25.640000 2 Attention ...
... 2006-02-13-12.30.25.640000 2 Attention ...
... 2006-02-13-12.29.25.281000 2 Attention ...
此查询的输出（继续）。
... HI_FORMULA ...
... ----------------------------------------...- ...
... 0 ...
... ((0 / 5000) * 100) ...
... ...
... ...
... ...
... ...
... ...
... ...
... ...
... (((0 - 0) / ((118 - 0) + 1)) * 100) ...
... ...
... ...
... ...
... ...
... ...
... ((1170384 / (1170384 + 19229616)) * 100) ...
... ...
... ...
... ...
... ...
... ...
... ((11155116032 / 21138935808) * 100) ...
... ...
... ...
... ...
... ...
... ...
... ...
... ...
... ((5264 / (50 * 4096)) * 100) ...
... ((0 / 5) * 100) ...
... ((4587520 / 6160384) * 100) ...
... - ...
... ...
... ...
... ...
... ...
... ...
... - ...
... ...
... ...
... ...
... ...
... ...
... ...
... ...
... - ...
... ...
... ...
此查询的输出（继续）。
... HI_ADDITIONAL_INFO
... ----------------------------------------
... -
... The high watermark for shared sort
... memory is "57". "99"% of the time
... the sort heap allocation is less
... than or equal to "246". The sort
... heap (sortheap) database
... configuration parameter is set
... to "256". The high watermark for
... private sort memory is "0".
... The sort heap (sortheap) database
... configuration parameter is set to
... "256". The high watermark for
... private sort memory is "57". The
... high watermark for shared sort
... memory is "0"
... The following are the related
... database configuration parameter
... settings: logprimary is "3",
... logsecond is "2", and logfilsiz
... is "1000". The application with
... the oldest transaction is "712".
... The following are the related
... database configuration parameter
... settings: logprimary is "3",
... logsecond is "2", and logfilsiz
... is "1000", blk_log_dsk_ful is
... "NO", logarchmeth1 is "OFF" and
... logarchmeth2 is "OFF".
... -
... -
... -
... The scope setting in the reorganization
... policy is "TABSCHEMA NOT LIKE 'SYS%'".
... Automatic reorganization (AUTO_REORG)
... for this database is set to "OFF".
... The longest estimated reorganization
... time is "N/A".
... The last successful backup was taken
... at "N/A". The log space consumed since
... this last backup has been "N/A" 4KB
... pages. Automation for database backup
... is set to "OFF". The last automated
... backup returned with SQLCODE = "N/A".
... The longest estimated backup time
... is "N/A".
... The scope is "N\A". Automatic
... statistics collection (AUTO_RUNSTATS)
... is set to "OFF".
返回的信息
| 列名 | 数据类型 | 描述或相应的监视元素 |
|---|---|---|
| snapshot_timestamp | TIMESTAMP | snapshot_timestamp - 快照时间戳记 |
| HI_ID | BIGINT | 唯一标识快照数据流中的运行状况指示器的数字。 |
| DB_NAME | VARCHAR(128) | db_name - 数据库名称 |
| HI_VALUE | SMALLINT | 运行状况指示器的值。 |
| HI_TIMESTAMP | TIMESTAMP | 生成警报的日期和时间。 |
| HI_ALERT_STATE | BIGINT | 警报的严重性。 |
| HI_ALERT_STATE_DETAIL | VARCHAR(20) | HI_ALERT_STATE 列的文本描述。 |
| (H) | VARCHAR(2048) | 用于计算运行状况指示器的公式。 |
| HI_ADDITIONAL_INFO | VARCHAR(4096) | 有关运行状况指示器的其他信息。 |