论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2006-09-21 10:17 |只看该作者 |倒序浏览

db2有张非系统表，总是被删除。

我想查查是什么时间被那个连接ip删除的，想问问能不能通过日志查到。具体怎么做。
谢谢了！

文库|博客

nuoran

稍有积蓄

论坛徽章:: 0

2楼 [报告]

发表于 2006-09-21 10:46 |只看该作者

db2默认不记录这个的，开启db2audit

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

spouter

稍有积蓄

论坛徽章:: 0

3楼 [报告]

发表于 2006-09-21 12:13 |只看该作者

谢谢，db2audit 没用过。先学习以下

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

spouter

稍有积蓄

论坛徽章:: 0

4楼 [报告]

发表于 2006-09-21 14:48 |只看该作者

我开启db2audit 功能在
DB2 审计设置：

审计活动："TRUE "
日志错误："TRUE "
日志成功："FALSE "
日志审查事件："TRUE "
日志检查事件："TRUE "
日志对象维护事件："TRUE "
日志安全性维护事件："TRUE "
日志系统管理员事件："TRUE "
日志验证事件："TRUE "
日志上下文事件："FALSE "
返回关于审查错误的 SQLCA："FALSE "

AUD0000I  操作成功。
----------------------------------------------------------------------------------------------------------------------
在14：41建了表A但以下记录，没有记下建立表？请大家指点一下。

timestamp=2006-09-21-14.41.40.890000;category=VALIDATE;audit event=CHECK_GROUP_MEMBERSHIP;
  event correlator=2;event status=-1092;
  database=RHHRB01;userid=db2admin;authid=DB2ADMIN;execution id=DB2ADMIN;
  origin node=0;coordinator node=0;
  application id=*LOCAL.DB2.060921064141;application name=DB2HMON;
  auth type=NOT_SPEC;plugin name=IBMOSgroups;

timestamp=2006-09-21-14.41.40.890001;category=VALIDATE;audit event=CHECK_GROUP_MEMBERSHIP;
  event correlator=2;event status=-1092;
  database=RHHRB01;userid=db2admin;authid=DB2ADMIN;execution id=DB2ADMIN;
  origin node=0;coordinator node=0;
  application id=*LOCAL.DB2.060921064141;application name=DB2HMON;
  auth type=NOT_SPEC;plugin name=IBMOSgroups;

timestamp=2006-09-21-14.41.40.890002;category=VALIDATE;audit event=CHECK_GROUP_MEMBERSHIP;
  event correlator=2;event status=-1092;
  database=RHHRB01;userid=db2admin;authid=DB2ADMIN;execution id=DB2ADMIN;
  origin node=0;coordinator node=0;
  application id=*LOCAL.DB2.060921064141;application name=DB2HMON;
  auth type=NOT_SPEC;plugin name=IBMOSgroups;

timestamp=2006-09-21-14.41.40.921000;category=VALIDATE;audit event=CHECK_GROUP_MEMBERSHIP;
  event correlator=2;event status=-1092;
  database=RHHRC01;userid=db2admin;authid=DB2ADMIN;execution id=DB2ADMIN;
  origin node=0;coordinator node=0;
  application id=*LOCAL.DB2.060921064142;application name=DB2HMON;
  auth type=NOT_SPEC;plugin name=IBMOSgroups;

timestamp=2006-09-21-14.41.40.921001;category=VALIDATE;audit event=CHECK_GROUP_MEMBERSHIP;
  event correlator=2;event status=-1092;
  database=RHHRC01;userid=db2admin;authid=DB2ADMIN;execution id=DB2ADMIN;
  origin node=0;coordinator node=0;
  application id=*LOCAL.DB2.060921064142;application name=DB2HMON;
  auth type=NOT_SPEC;plugin name=IBMOSgroups;

timestamp=2006-09-21-14.41.40.921002;category=VALIDATE;audit event=CHECK_GROUP_MEMBERSHIP;
  event correlator=2;event status=-1092;
  database=RHHRC01;userid=db2admin;authid=DB2ADMIN;execution id=DB2ADMIN;
  origin node=0;coordinator node=0;
  application id=*LOCAL.DB2.060921064142;application name=DB2HMON;
  auth type=NOT_SPEC;plugin name=IBMOSgroups;