锐客网

  1. 首页 > it技术 > >

linux|linux db2日志查看,DB2_获取诊断日志

linuxdb2日志查看

目的：
测试DB2获取诊断日志，本脚本摘录自DB2安装目录admin_scripts/getlogs.db2。
版本：Windows DB2 Express-C V9.7
操作步骤：
使用"db2cmd db2 -t"进入交互模式,执行后续操作。
-- Connect to sample database.
【linux|linux db2日志查看,DB2_获取诊断日志】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;

    推荐阅读


    上一篇：机器学习|机器学习笔记——逻辑回归

    下一篇：python日期函数引用_使用python中pandas的read_excel函数将日期保留为字符串