ITPub博客

首页 > Linux操作系统 > Linux操作系统 > DB2_获取诊断日志

DB2_获取诊断日志

原创 Linux操作系统 作者:redhouser 时间:2011-07-14 10:52:21 0 删除 编辑

目的:
测试DB2获取诊断日志,本脚本摘录自DB2安装目录admin_scripts/getlogs.db2。
版本:Windows DB2 Express-C V9.7

操作步骤:
使用"db2cmd db2 -t"进入交互模式,执行后续操作。

-- Connect to sample database.
CONNECT TO sample;

-- Retrieve all notification messages written after the specified
-- timestamp (for example '2006-02-22', '06.44.44')
-- If NULL is specified as the input timestamp to PD_GET_LOG_MSGS UDF,
-- then all the log entries will be returned.
SELECT dbname,
       msgseverity
  FROM TABLE (PD_GET_LOG_MSGS(TIMESTAMP('2006-02-22','06.44.44'))) AS t
  ORDER BY TIMESTAMP;

-- Retrieve all notification messages written in the last week from
-- all partitions in chronological order.
SELECT instancename,
       dbpartitionnum,
       dbname,
       msgtype
  FROM TABLE(PD_GET_LOG_MSGS(current_timestamp - 7 days)) AS t
  ORDER BY TIMESTAMP;

-- Get all critical log messages logged over the last 24 hours, order
-- by most recent
SELECT timestamp,
       instancename,
       dbname,
       appl_id,
       msg
  FROM SYSIBMADM.PDLOGMSGS_LAST24HOURS WHERE msgseverity = 'C'
  ORDER BY TIMESTAMP DESC;

-- Disconnect from database.
CONNECT RESET;

TERMINATE;

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/18922393/viewspace-702166/,如需转载,请注明出处,否则将追究法律责任。

上一篇: DB2_获取健康设置
下一篇: DB2_全局变量
请登录后发表评论 登录
全部评论

注册时间:2011-05-26

  • 博文量
    211
  • 访问量
    812039