怎么通过日志反馈中的内容找出相应的SQL语句
2010-07-16-04.34.51.105061+480 E6805430A696 LEVEL: Error
PID : 295074 TID : 1 PROC : db2agent (REM) 0
INSTANCE: db2inst1 NODE : 000 DB : REM
APPHDL : 0-775 APPID: C0A8726E.M112.118A85183330
FUNCTION: DB2 UDB, data protection, sqlpgResSpace, probe:560
MESSAGE : ADM1542W Application "QuestCentral.exe" with application handle "0"
and application id "C0A8726E.M112.118A85183330" executing under
authentication id "REMUSER " will be forced off of the database for
violating database configuration parameter MAX_LOG (current value
"80"). The unit of work will be rolled back.
各位大侠,如何能把相对应的SQL语句还有执行人的IP找出来呢`~~谢谢
PID : 295074 TID : 1 PROC : db2agent (REM) 0
INSTANCE: db2inst1 NODE : 000 DB : REM
APPHDL : 0-775 APPID: C0A8726E.M112.118A85183330
FUNCTION: DB2 UDB, data protection, sqlpgResSpace, probe:560
MESSAGE : ADM1542W Application "QuestCentral.exe" with application handle "0"
and application id "C0A8726E.M112.118A85183330" executing under
authentication id "REMUSER " will be forced off of the database for
violating database configuration parameter MAX_LOG (current value
"80"). The unit of work will be rolled back.
各位大侠,如何能把相对应的SQL语句还有执行人的IP找出来呢`~~谢谢
17同行回答
要快速可能要写个小脚本这只能显示两位的echo "obase=10; ibase=16; C0" | bc结果是192 ...cedarbird 发表于 2010-7-19 17:11
這樣更快echo $((16#C0))192浏览1025
高手能给介绍一下具体IP地址是怎么看的收起
浏览989
to qqdzyh 二位二位转换
SQL> select to_number('C0','XXX')||'.'||to_number('A8','XXX')||'.'||to_number('72','XXX')||'.'||to_number('6E','XXX') from dual;
TO_NUMBER('C0','XXX')||'.'||TO
--------------------------------------------------------------------------------
192.168.114.110
ps一下 db2 居然没有16进制 转换成10进制的函数收起
SQL> select to_number('C0','XXX')||'.'||to_number('A8','XXX')||'.'||to_number('72','XXX')||'.'||to_number('6E','XXX') from dual;
TO_NUMBER('C0','XXX')||'.'||TO
--------------------------------------------------------------------------------
192.168.114.110
ps一下 db2 居然没有16进制 转换成10进制的函数收起
浏览1002
浏览1131
C0A8726E对应的是ip地址收起
浏览1126