怎么通过日志反馈中的内容找出相应的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同行回答
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进制的函数收起
浏览1011
浏览1140
C0A8726E.M112.118A85183330
代表 192.168.114.110.24850,实例名)
APPC
Format
Network.LU Name.Application instance
Example
CAIBMTOR.OSFDBX0.930131194520
Details
This application ID is the displayable format of an actual SNA LUWID (Logical Unit-of-Work ID) that flows on the network when an APPC conversation is allocated. APPC-generated application IDs are made up by concatenating the network name, the LU name, and the LUWID instance number, which create a unique label for the client/server application. The network name and LU name can each be a maximum of 8 characters. The application instance corresponds to the 12-decimal-character LUWID instance number.
算自问自答了 ^_^收起
代表 192.168.114.110.24850,实例名)
APPC
Format
Network.LU Name.Application instance
Example
CAIBMTOR.OSFDBX0.930131194520
Details
This application ID is the displayable format of an actual SNA LUWID (Logical Unit-of-Work ID) that flows on the network when an APPC conversation is allocated. APPC-generated application IDs are made up by concatenating the network name, the LU name, and the LUWID instance number, which create a unique label for the client/server application. The network name and LU name can each be a maximum of 8 characters. The application instance corresponds to the 12-decimal-character LUWID instance number.
算自问自答了 ^_^收起
浏览581