互联网服务
数据库实例HANG住了，具体是什么原因啊？
前台程序执行查询SQL，导致数据实例hang住，导致数据库无法连接，并自动关闭，各位大侠原因是为什么？2012-07-20-08.58.07.337761+480 E159829454A528 LEVEL: WarningPID : 696424 ...显示全部
前台程序执行查询SQL，导致数据实例hang住，导致数据库无法连接，并自动关闭，各位大侠原因是为什么？
2012-07-20-08.58.07.337761+480 E159829454A528 LEVEL: Warning
PID : 696424 TID : 32220 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25382 APPID: 192.168.1.53.40815.120720005701
AUTHID : DBREAD
EDUID : 32220 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, data management, sqldBeginIndexCreate, probe:1
MESSAGE : ADM5540W Beginning index rebuild of "1" index(es) on table "DBREAD
.DIM_RETAILER_PUBLIC".
2012-07-20-08.58.07.338405+480 E159829983A557 LEVEL: Warning
PID : 696424 TID : 32220 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25382 APPID: 192.168.1.53.40815.120720005701
AUTHID : DBREAD
EDUID : 32220 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, data management, sqldIndexCreate, probe:1
MESSAGE : ADM5541W Rebuilding index with IID "1" in object with ID "5" and
table space ID "4" on table "DBREAD .DIM_RETAILER_PUBLIC".
2012-07-20-08.58.07.573343+480 E159830541A535 LEVEL: Warning
PID : 696424 TID : 32220 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25382 APPID: 192.168.1.53.40815.120720005701
AUTHID : DBREAD
EDUID : 32220 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, data management, sqldEndIndexCreate, probe:1
MESSAGE : ADM5542W Index rebuild of index(es) on table "DBREAD
.DIM_RETAILER_PUBLIC" completed successfully.
2012-07-20-08.58.07.941395+480 I159831077A479 LEVEL: Warning
PID : 696424 TID : 23078 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25409 APPID: 192.168.1.53.40820.120720005707
AUTHID : DBREAD
EDUID : 23078 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, database utilities, sqluvtld_route_in, probe:837
DATA #1 :
Starting LOAD operation (Q) (6) (I).
2012-07-20-08.58.08.456973+480 I159831557A502 LEVEL: Warning
PID : 696424 TID : 32662 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25409 APPID: 192.168.1.53.40820.120720005707
AUTHID : DBREAD
EDUID : 32662 EDUNAME: db2lrid 0
FUNCTION: DB2 UDB, database utilities, DIAG_NOTE, probe:0
DATA #1 : String, 79 bytes
LOADID: 23078.2012-07-20-08.58.07.941385.0 (9;10)
Load CPU parallelism is: 7, 0
2012-07-20-08.58.08.519012+480 I159832060A572 LEVEL: Warning
PID : 696424 TID : 3214 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25409 APPID: 192.168.1.53.40820.120720005707
AUTHID : DBREAD
EDUID : 3214 EDUNAME: db2lfrm0 0
FUNCTION: DB2 UDB, database utilities, sqlulPrintPhaseMsg, probe:311
DATA #1 : String, 137 bytes
LOADID: 23078.2012-07-20-08.58.07.941385.0 (9;10)
Starting LOAD phase at 2012-07-20 08:58:08.511154. Table DBREAD .DIM_RETAILER_PUBLIC
2012-07-20-08.58.08.698302+480 I159832633A537 LEVEL: Warning
PID : 696424 TID : 32662 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25409 APPID: 192.168.1.53.40820.120720005707
AUTHID : DBREAD
EDUID : 32662 EDUNAME: db2lrid 0
FUNCTION: DB2 UDB, database utilities, sqlulPrintPhaseMsg, probe:311
DATA #1 : String, 103 bytes
LOADID: 23078.2012-07-20-08.58.07.941385.0 (9;10)
Completed LOAD phase at 2012-07-20 08:58:08.690265.
2012-07-20-08.58.08.706238+480 I159833171A537 LEVEL: Warning
PID : 696424 TID : 32662 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25409 APPID: 192.168.1.53.40820.120720005707
AUTHID : DBREAD
EDUID : 32662 EDUNAME: db2lrid 0
FUNCTION: DB2 UDB, database utilities, sqlulPrintPhaseMsg, probe:311
DATA #1 : String, 103 bytes
LOADID: 23078.2012-07-20-08.58.07.941385.0 (9;10)
Starting BUILD phase at 2012-07-20 08:58:08.698536.
2012-07-20-08.58.08.849694+480 I159833709A538 LEVEL: Warning
PID : 696424 TID : 32662 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25409 APPID: 192.168.1.53.40820.120720005707
AUTHID : DBREAD
EDUID : 32662 EDUNAME: db2lrid 0
FUNCTION: DB2 UDB, database utilities, sqlulPrintPhaseMsg, probe:311
DATA #1 : String, 104 bytes
LOADID: 23078.2012-07-20-08.58.07.941385.0 (9;10)
Completed BUILD phase at 2012-07-20 08:58:08.836427.
2012-07-20-08.58.08.854129+480 I159834248A547 LEVEL: Error
PID : 696424 TID : 23078 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25409 APPID: 192.168.1.53.40820.120720005707
AUTHID : DBREAD
EDUID : 23078 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 112 bytes
LOADID: 23078.2012-07-20-08.58.07.941385.0 (9;10)
Marking index OK , 0, 0, Detected in file:sqluvld.C, Line:5715
2012-07-20-08.58.09.505171+480 I159834796A479 LEVEL: Warning
PID : 696424 TID : 23078 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25406 APPID: 192.168.1.53.40823.120720005711
AUTHID : DBREAD
EDUID : 23078 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, database utilities, sqluvtld_route_in, probe:837
DATA #1 :
Starting LOAD operation (Q) (6) (I).
2012-07-20-08.58.09.994890+480 I159835276A502 LEVEL: Warning
PID : 696424 TID : 32713 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25406 APPID: 192.168.1.53.40823.120720005711
AUTHID : DBREAD
EDUID : 32713 EDUNAME: db2lrid 0
FUNCTION: DB2 UDB, database utilities, DIAG_NOTE, probe:0
DATA #1 : String, 79 bytes
LOADID: 23078.2012-07-20-08.58.09.505160.0 (9;10)
Load CPU parallelism is: 7, 0
2012-07-20-08.58.10.180583+480 I159835779A572 LEVEL: Warning
PID : 696424 TID : 3265 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25406 APPID: 192.168.1.53.40823.120720005711
AUTHID : DBREAD
EDUID : 3265 EDUNAME: db2lfrm0 0
FUNCTION: DB2 UDB, database utilities, sqlulPrintPhaseMsg, probe:311
DATA #1 : String, 137 bytes
LOADID: 23078.2012-07-20-08.58.09.505160.0 (9;10)
Starting LOAD phase at 2012-07-20 08:58:10.167226. Table DBREAD .DIM_RETAILER_PUBLIC
2012-07-20-08.58.32.414883+480 I159836352A570 LEVEL: Error
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:1
MESSAGE : Error in agent servicing application with coor_node:
DATA #1 : Hexdump, 2 bytes
0x070000019FC09770 : 0000 ..
2012-07-20-08.58.32.440441+480 I159836923A577 LEVEL: Error
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:2
MESSAGE : Error in agent servicing application with coor_agent_index:
DATA #1 : Hexdump, 2 bytes
0x070000019FC09772 : 634C cL
2012-07-20-08.58.32.440648+480 I159837501A572 LEVEL: Error
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:3
MESSAGE : Error in agent servicing application with CLIENT PID:
DATA #1 : Hexdump, 3 bytes
0x070000019FC09790 : 3431 32 412
2012-07-20-08.58.32.440838+480 I159838074A678 LEVEL: Error
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:4
MESSAGE : Error in agent servicing application with INBOUND APPLICATION ID:
DATA #1 : Hexdump, 31 bytes
0x0780000000FDEAA4 : 3139 322E 3136 382E 3135 2E31 362E 3136 192.168.15.16.16
0x0780000000FDEAB4 : 3833 352E 3132 3037 3230 3030 3538 33 835.12072000583
2012-07-20-08.58.32.441052+480 I159838753A584 LEVEL: Error
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:5
MESSAGE : Error in agent servicing application with INBOUND SEQUENCE NUMBER:
DATA #1 : Hexdump, 2 bytes
0x0780000000FDE5E8 : 0002 ..
2012-07-20-08.58.32.441243+480 I159839338A490 LEVEL: Error
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:6
MESSAGE : Error in agent servicing application with OUTBOUND APPLICATION ID:
2012-07-20-08.58.32.441427+480 I159839829A491 LEVEL: Error
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:7
MESSAGE : Error in agent servicing application with OUTBOUND SEQUENCE NUMBER:
2012-07-20-08.58.32.441670+480 I159840321A1226 LEVEL: Error
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:8
MESSAGE : Error in agent servicing application with AUTHORIZATION ID:
DATA #1 : Hexdump, 129 bytes
0x0780000000FDD9A1 : 4442 5245 4144 2020 0000 0000 0000 0000 DBREAD ........
0x0780000000FDD9B1 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0780000000FDD9C1 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0780000000FDD9D1 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0780000000FDD9E1 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0780000000FDD9F1 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0780000000FDDA01 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0780000000FDDA11 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0780000000FDDA21 : 00 .
2012-07-20-08.58.32.441898+480 I159841548A584 LEVEL: Error
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:9
MESSAGE : Error in agent servicing application with PRODUCT SIGNATURE:
DATA #1 : Hexdump, 8 bytes
0x0780000000FDEB50 : 5351 4C30 3930 3730 SQL09070
2012-07-20-08.58.32.442089+480 I159842133A593 LEVEL: Error
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:10
MESSAGE : Error in agent servicing application with APPLICATION NAME:
DATA #1 : Hexdump, 16 bytes
0x0780000000FDEB26 : 5175 6573 7443 656E 7472 616C 2E65 7865 QuestCentral.exe
2012-07-20-08.58.32.469307+480 I159842727A520 LEVEL: Event
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, trace services, pdInvokeCalloutScript, probe:10
START : Invoking /home/db2admin/sqllib/bin/db2cos_trap from oper system services sqloEDUCodeTrapHandler
2012-07-20-08.58.39.956251+480 I159843248A481 LEVEL: Event
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, trace services, pdInvokeCalloutScript, probe:20
STOP : Completed invoking /home/db2admin/sqllib/bin/db2cos_trap
2012-07-20-08.58.39.956619+480 E159843730A1352 LEVEL: Critical
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler, probe:10
MESSAGE : ADM14001C An unexpected and critical error has occurred: "Trap". The
instance may have been shutdown as a result. "Automatic" FODC (First
Occurrence Data Capture) has been invoked and diagnostic information
has been recorded in directory
"/home/db2admin/sqllib/db2dump/FODC_Trap_2012-07-20-08.58.32.237814/"
. Please look in this directory for detailed evidence about what
happened and contact IBM support if necessary to diagnose the
problem.
DATA #1 : Signal Number Recieved, 4 bytes
11
DATA #2 : Siginfo, 64 bytes
0x070000019FC09DC0 : 0000 000B 0000 0000 0000 0033 0000 0000 ...........3....
0x070000019FC09DD0 : 0000 0000 0000 0000 0000 0000 0000 00D8 ................
0x070000019FC09DE0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x070000019FC09DF0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
2012-07-20-08.58.39.980134+480 I159845083A501 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, DRDA Application Server, sqljsSignalHandler, probe:10
MESSAGE : DIA0505I Execution of a component signal handling function has begun.
2012-07-20-08.58.40.078342+480 I159847419A514 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, DRDA Application Server, sqljsSignalHandler, probe:20
MESSAGE : DIA0506I Execution of a component signal handling function is
complete.
2012-07-20-08.58.40.094906+480 I159847934A493 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, Query Gateway, sqlqg_signal_handler, probe:10
MESSAGE : DIA0505I Execution of a component signal handling function has begun.
2012-07-20-08.58.40.140574+480 I159849071A616 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_string (secondary logging fu, probe:0
MESSAGE : SQQG SERVER INFO
DATA #1 : String, 127 bytes
SQQG Server Information is dumped into
/home/db2admin/sqllib/db2dump/FODC_Trap_2012-07-20-08.58.32.237814/qg69642422608.000.me
2012-07-20-08.58.40.188842+480 I159850121A506 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, Query Gateway, sqlqg_signal_handler, probe:20
MESSAGE : DIA0506I Execution of a component signal handling function is
complete.
2012-07-20-08.58.40.217011+480 I159850628A499 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_signal_handler, probe:100
MESSAGE : DIA0505I Execution of a component signal handling function has begun.
2012-07-20-08.58.40.238291+480 I159851128A703 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:25
MESSAGE : MASTER TIME INFO
DATA #1 : Hexdump, 40 bytes
0x07000000D5BDE710 : 0000 0000 4FFC F636 034A 0000 000C DC7B ....O..6.J.....{
0x07000000D5BDE720 : 0009 A329 477C 1665 0000 0000 004D 46DA ...)G|.e.....MF.
0x07000000D5BDE730 : 8009 A329 477C 1664 ...)G|.d
2012-07-20-08.58.40.256230+480 I159852921A656 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging func, probe:0
MESSAGE : RDS UCINTFC: pCurrentPID->rdbname =
DATA #1 : Hexdump, 18 bytes
0x0000000114C11D88 : 4441 5441 4952 5353 2020 2020 2020 2020 DATAIRSS
0x0000000114C11D98 : 2020
2012-07-20-08.58.40.256426+480 I159853578A578 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging func, probe:0
MESSAGE : RDS UCINTFC: pCurrentPID->rdbcolidLen =
DATA #1 : Hexdump, 2 bytes
0x0000000114C11D68 : 0008 ..
2012-07-20-08.58.40.256617+480 I159854157A591 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging func, probe:0
MESSAGE : RDS UCINTFC: pCurrentPID->pkgnamcsn.rdbcolid =
DATA #1 : Hexdump, 8 bytes
0x0000000114C11D9A : 4E55 4C4C 4944 2020 NULLID
2012-07-20-08.58.40.256819+480 I159854749A577 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging func, probe:0
MESSAGE : RDS UCINTFC: pCurrentPID->pkgnameLen =
DATA #1 : Hexdump, 2 bytes
0x0000000114C11D78 : 0008 ..
2012-07-20-08.58.40.257009+480 I159855327A589 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging func, probe:0
MESSAGE : RDS UCINTFC: pCurrentPID->pkgnamcsn.pkgname=
DATA #1 : Hexdump, 8 bytes
0x0000000114C11DAC : 5359 5353 4832 3030 SYSSH200
2012-07-20-08.58.40.257234+480 I159855917A582 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging func, probe:0
MESSAGE : RDS UCINTFC: pCurrentPID->pkgcnstkn =
DATA #1 : Hexdump, 8 bytes
0x0000000114C11DBE : 5359 534C 564C 3031 SYSLVL01
2012-07-20-08.58.40.257429+480 I159856500A572 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging func, probe:0
MESSAGE : RDS UCINTFC: pCurrentPID->pkgsn =
DATA #1 : Hexdump, 2 bytes
0x0000000114C11DC6 : 0004 ..
2012-07-20-08.58.40.257619+480 I159857073A3580 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging func, probe:0
MESSAGE : RDS UCINTFC: pStatementText =
DATA #1 : Hexdump, 607 bytes
0x0000000124515880 : 7365 6C65 6374 2061 2E73 6D65 6D5F 6964 select a.smem_id
0x0000000124515890 : 2C61 2E73 6E6F 6465 2C61 2E73 6E61 6D65 ,a.snode,a.sname
0x00000001245158A0 : 2C61 2E62 6D65 6D5F 6964 2C61 2E62 6E6F ,a.bmem_id,a.bno
0x00000001245158B0 : 6465 2C61 2E62 6E61 6D65 2C63 2E63 6967 de,a.bname,c.cig
0x00000001245158C0 : 5F63 6F64 6562 6172 2C63 2E63 6967 5F74 _codebar,c.cig_t
0x00000001245158D0 : 7261 6465 6D61 726B 2C63 2E63 6967 5F6D rademark,c.cig_m
0x00000001245158E0 : 6172 6B6E 616D 652C 612E 7375 626B 696E arkname,a.subkin
0x00000001245158F0 : 642C 7375 6D28 5155 414E 5449 5459 292F d,sum(QUANTITY)/
0x0000000124515900 : 3520 5155 414E 5449 5459 2066 726F 6D20 5 QUANTITY from
0x0000000124515910 : 4442 3241 444D 494E 2E4E 4943 4B5F 5A4A DB2ADMIN.NICK_ZJ
0x0000000124515920 : 5F43 5F58 594F 5244 4552 2061 2C44 4232 _C_XYORDER a,DB2
0x0000000124515930 : 4144 4D49 4E2E 4E49 434B 5F5A 4A5F 435F ADMIN.NICK_ZJ_C_
0x0000000124515940 : 5859 4F52 4450 525F 4649 4E41 4C20 6220 XYORDPR_FINAL b
0x0000000124515950 : 2C44 4232 4144 4D49 4E2E 4E49 434B 5F53 ,DB2ADMIN.NICK_S
0x0000000124515960 : 544D 415F 4349 4741 5245 5454 4520 6320 TMA_CIGARETTE c
0x0000000124515970 : 7768 6572 6520 6465 6C69 5F64 6174 653D where deli_date=
0x0000000124515980 : 2732 3031 32C4 EAC9 CFB0 EBC4 EA27 2061 '2012........' a
0x0000000124515990 : 6E64 2061 2E6F 7264 6572 5F69 643D 622E nd a.order_id=b.
0x00000001245159A0 : 6F72 6465 725F 6964 2061 6E64 2063 2E63 order_id and c.c
0x00000001245159B0 : 6967 5F63 6F64 6562 6172 3D73 7562 7374 ig_codebar=subst
0x00000001245159C0 : 7228 622E 5052 4F44 5543 545F 4944 2C31 r(b.PRODUCT_ID,1
0x00000001245159D0 : 2C31 3329 2020 2061 6E64 2064 656C 5F64 ,13) and del_d
0x00000001245159E0 : 6174 6520 6973 206E 756C 6C20 616E 6420 ate is null and
0x00000001245159F0 : 632E 6369 675F 7072 6F64 7563 6572 3D27 c.cig_producer='
0x0000000124515A00 : 3230 3434 3030 3031 2720 616E 6420 7375 20440001' and su
0x0000000124515A10 : 626B 696E 643D 27B9 BACF FA27 2061 6E64 bkind='....' and
0x0000000124515A20 : 2073 6E6F 6465 3D27 B9E3 B6AB CAA1 2720 snode='......'
0x0000000124515A30 : 2067 726F 7570 2062 7920 612E 736D 656D group by a.smem
0x0000000124515A40 : 5F69 642C 612E 736E 6F64 652C 612E 736E _id,a.snode,a.sn
0x0000000124515A50 : 616D 652C 612E 626D 656D 5F69 642C 612E ame,a.bmem_id,a.
0x0000000124515A60 : 626E 6F64 652C 612E 626E 616D 652C 632E bnode,a.bname,c.
0x0000000124515A70 : 6369 675F 636F 6465 6261 722C 632E 6369 cig_codebar,c.ci
0x0000000124515A80 : 675F 7472 6164 656D 6172 6B2C 612E 7375 g_trademark,a.su
0x0000000124515A90 : 626B 696E 642C 632E 6369 675F 6D61 726B bkind,c.cig_mark
0x0000000124515AA0 : 6E61 6D65 206F 7264 6572 2062 7920 6369 name order by ci
0x0000000124515AB0 : 675F 6D61 726B 6E61 6D65 2061 7363 2C62 g_markname asc,b
0x0000000124515AC0 : 6D65 6D5F 6964 2061 7363 2C73 756D 2851 mem_id asc,sum(Q
0x0000000124515AD0 : 5541 4E54 4954 5929 2F35 2064 6573 63 UANTITY)/5 desc
2012-07-20-08.58.40.259169+480 I159862650A578 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:250
RETCODE : ZRC=0x87120007=-2028863481=SQLR_SEVERE_PGM_ERROR
"Severe programming error"
DIA8516C A severe internal processing error has occurred.
2012-07-20-08.58.40.288378+480 I159863229A704 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:275
MESSAGE : MASTER TIME INFO
DATA #1 : Hexdump, 40 bytes
0x07000000D5BDE710 : 0000 0000 4FFC F636 034A 0000 000C DC7B ....O..6.J.....{
0x07000000D5BDE720 : 0009 A329 477C 1665 0000 0000 004D 46DA ...)G|.e.....MF.
0x07000000D5BDE730 : 8009 A329 477C 1664 ...)G|.d
2012-07-20-08.58.40.288739+480 I159864156A1180 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:300
MESSAGE : SQLCA
DATA #1 : Hexdump, 136 bytes
0x0780000001193A60 : 5351 4C43 4120 2020 0000 0088 0000 0000 SQLCA ........
0x0780000001193A70 : 0000 2020 2020 2020 2020 2020 2020 2020 ..
0x0780000001193A80 : 2020 2020 2020 2020 2020 2020 2020 2020
0x0780000001193A90 : 2020 2020 2020 2020 2020 2020 2020 2020
0x0780000001193AA0 : 2020 2020 2020 2020 2020 2020 2020 2020
0x0780000001193AB0 : 2020 2020 2020 2020 5351 4C30 3930 3530 SQL09050
0x0780000001193AC0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0780000001193AD0 : 0000 0000 0000 0000 2020 2020 2020 2020 ........
0x0780000001193AE0 : 2020 2020 2020 2020
2012-07-20-08.58.40.289094+480 I159865548A532 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:400
MESSAGE : CREATOR
DATA #1 : Hexdump, 8 bytes
0x0700000011012FD8 : 4E55 4C4C 4944 2020 NULLID
2012-07-20-08.58.40.289285+480 I159866081A532 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:450
MESSAGE : PACKAGE
DATA #1 : Hexdump, 8 bytes
0x0700000011012FD0 : 5359 5353 4832 3030 SYSSH200
2012-07-20-08.58.40.388647+480 I159869249A3546 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_sibling, probe:200
MESSAGE : section stmt
DATA #1 : Hexdump, 607 bytes
0x07000000D601EC60 : 7365 6C65 6374 2061 2E73 6D65 6D5F 6964 select a.smem_id
0x07000000D601EC70 : 2C61 2E73 6E6F 6465 2C61 2E73 6E61 6D65 ,a.snode,a.sname
0x07000000D601EC80 : 2C61 2E62 6D65 6D5F 6964 2C61 2E62 6E6F ,a.bmem_id,a.bno
0x07000000D601EC90 : 6465 2C61 2E62 6E61 6D65 2C63 2E63 6967 de,a.bname,c.cig
0x07000000D601ECA0 : 5F63 6F64 6562 6172 2C63 2E63 6967 5F74 _codebar,c.cig_t
0x07000000D601ECB0 : 7261 6465 6D61 726B 2C63 2E63 6967 5F6D rademark,c.cig_m
0x07000000D601ECC0 : 6172 6B6E 616D 652C 612E 7375 626B 696E arkname,a.subkin
0x07000000D601ECD0 : 642C 7375 6D28 5155 414E 5449 5459 292F d,sum(QUANTITY)/
0x07000000D601ECE0 : 3520 5155 414E 5449 5459 2066 726F 6D20 5 QUANTITY from
0x07000000D601ECF0 : 4442 3241 444D 494E 2E4E 4943 4B5F 5A4A DB2ADMIN.NICK_ZJ
0x07000000D601ED00 : 5F43 5F58 594F 5244 4552 2061 2C44 4232 _C_XYORDER a,DB2
0x07000000D601ED10 : 4144 4D49 4E2E 4E49 434B 5F5A 4A5F 435F ADMIN.NICK_ZJ_C_
0x07000000D601ED20 : 5859 4F52 4450 525F 4649 4E41 4C20 6220 XYORDPR_FINAL b
0x07000000D601ED30 : 2C44 4232 4144 4D49 4E2E 4E49 434B 5F53 ,DB2ADMIN.NICK_S
0x07000000D601ED40 : 544D 415F 4349 4741 5245 5454 4520 6320 TMA_CIGARETTE c
0x07000000D601ED50 : 7768 6572 6520 6465 6C69 5F64 6174 653D where deli_date=
0x07000000D601ED60 : 2732 3031 32C4 EAC9 CFB0 EBC4 EA27 2061 '2012........' a
0x07000000D601ED70 : 6E64 2061 2E6F 7264 6572 5F69 643D 622E nd a.order_id=b.
0x07000000D601ED80 : 6F72 6465 725F 6964 2061 6E64 2063 2E63 order_id and c.c
0x07000000D601ED90 : 6967 5F63 6F64 6562 6172 3D73 7562 7374 ig_codebar=subst
0x07000000D601EDA0 : 7228 622E 5052 4F44 5543 545F 4944 2C31 r(b.PRODUCT_ID,1
0x07000000D601EDB0 : 2C31 3329 2020 2061 6E64 2064 656C 5F64 ,13) and del_d
0x07000000D601EDC0 : 6174 6520 6973 206E 756C 6C20 616E 6420 ate is null and
0x07000000D601EDD0 : 632E 6369 675F 7072 6F64 7563 6572 3D27 c.cig_producer='
0x07000000D601EDE0 : 3230 3434 3030 3031 2720 616E 6420 7375 20440001' and su
0x07000000D601EDF0 : 626B 696E 643D 27B9 BACF FA27 2061 6E64 bkind='....' and
0x07000000D601EE00 : 2073 6E6F 6465 3D27 B9E3 B6AB CAA1 2720 snode='......'
0x07000000D601EE10 : 2067 726F 7570 2062 7920 612E 736D 656D group by a.smem
0x07000000D601EE20 : 5F69 642C 612E 736E 6F64 652C 612E 736E _id,a.snode,a.sn
0x07000000D601EE30 : 616D 652C 612E 626D 656D 5F69 642C 612E ame,a.bmem_id,a.
0x07000000D601EE40 : 626E 6F64 652C 612E 626E 616D 652C 632E bnode,a.bname,c.
0x07000000D601EE50 : 6369 675F 636F 6465 6261 722C 632E 6369 cig_codebar,c.ci
0x07000000D601EE60 : 675F 7472 6164 656D 6172 6B2C 612E 7375 g_trademark,a.su
0x07000000D601EE70 : 626B 696E 642C 632E 6369 675F 6D61 726B bkind,c.cig_mark
0x07000000D601EE80 : 6E61 6D65 206F 7264 6572 2062 7920 6369 name order by ci
0x07000000D601EE90 : 675F 6D61 726B 6E61 6D65 2061 7363 2C62 g_markname asc,b
0x07000000D601EEA0 : 6D65 6D5F 6964 2061 7363 2C73 756D 2851 mem_id asc,sum(Q
0x07000000D601EEB0 : 5541 4E54 4954 5929 2F35 2064 6573 63 UANTITY)/5 desc
2012-07-20-08.58.40.400391+480 I159873014A578 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:550
RETCODE : ZRC=0x87120007=-2028863481=SQLR_SEVERE_PGM_ERROR
"Severe programming error"
DIA8516C A severe internal processing error has occurred.
2012-07-20-08.58.40.400715+480 I159873593A414 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:550
2012-07-20-08.58.40.401561+480 I159874445A566 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging func, probe:0
MESSAGE : SQLD_AGENT_CB Pointer:
DATA #1 : Hexdump, 8 bytes
0x070000019FC09190 : 0000 0001 2451 4380 ....$QC.
2012-07-20-08.58.40.401905+480 I159875231A564 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging func, probe:0
MESSAGE : SQLD_TRAN_CB Pointer
DATA #1 : Hexdump, 8 bytes
0x070000019FC091A0 : 0700 0000 1012 6000 ......`.
2012-07-20-08.58.40.402227+480 I159876014A563 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging func, probe:0
MESSAGE : SQLD_APP_CB Pointer
DATA #1 : Hexdump, 8 bytes
0x070000019FC09198 : 0700 0000 101B F900 ........
2012-07-20-08.58.40.402546+480 I159876795A514 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_string (secondary logging fu, probe:0
MESSAGE : >> Begin CURSOR dump:
DATA #1 : String, 21 bytes
OPEN PERM CURSORS: >>
2012-07-20-08.58.40.402763+480 I159877310A512 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_string (secondary logging fu, probe:0
MESSAGE : << End CURSOR dump:
DATA #1 : String, 22 bytes
OPEN PERM CURSORS: <<
2012-07-20-08.58.40.402951+480 I159877823A514 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_string (secondary logging fu, probe:0
MESSAGE : >> Begin CURSOR dump:
DATA #1 : String, 21 bytes
OPEN TEMP CURSORS: >>
2012-07-20-08.58.40.403168+480 I159878338A512 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_string (secondary logging fu, probe:0
MESSAGE : << End CURSOR dump:
DATA #1 : String, 22 bytes
OPEN TEMP CURSORS: <<
2012-07-20-08.58.40.415008+480 I159878851A512 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_string (secondary logging fu, probe:0
MESSAGE : >> Begin CURSOR dump:
DATA #1 : String, 19 bytes
CLOSED CURSORS: >>
2012-07-20-08.58.40.415247+480 I159879364A509 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_string (secondary logging fu, probe:0
MESSAGE : << End CURSOR dump:
DATA #1 : String, 19 bytes
CLOSED CURSORS: <<
2012-07-20-08.58.40.650092+480 I159882056A598 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_string (secondary logging fu, probe:0
MESSAGE : locklist
DATA #1 : String, 117 bytes
Check /home/db2admin/sqllib/db2dump/FODC_Trap_2012-07-20-08.58.32.237814/931727.000.locklist.txt for additional data.
2012-07-20-08.58.40.791315+480 I159883527A461 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:650
DATA #1 : String, 19 bytes
XML components dump
2012-07-20-08.58.40.955186+480 I159884422A591 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, access plan manager, sqlra_sqlC_raw_dump, probe:150
MESSAGE : Context info dumped! Check
/home/db2admin/sqllib/db2dump/FODC_Trap_2012-07-20-08.58.32.237814/696
424.22608.000.apm.bin for additional data.
2012-07-20-08.58.40.955454+480 I159885014A709 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, access plan manager, sqlra_sqlC_raw_dump, probe:175
MESSAGE : MASTER TIME INFO
DATA #1 : Hexdump, 40 bytes
0x07000000D5BDE710 : 0000 0000 4FFC F636 034A 0000 000C DC7B ....O..6.J.....{
0x07000000D5BDE720 : 0009 A329 477C 1665 0000 0000 004D 46DA ...)G|.e.....MF.
0x07000000D5BDE730 : 8009 A329 477C 1664 ...)G|.d
2012-07-20-08.58.40.977081+480 I159885946A593 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, access plan manager, sqlra_sqlW_raw_dump, probe:150
MESSAGE : Workspace info dumped! Check
/home/db2admin/sqllib/db2dump/FODC_Trap_2012-07-20-08.58.32.237814/696
424.22608.000.apm.bin for additional data.
2012-07-20-08.58.40.977317+480 I159886540A709 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, access plan manager, sqlra_sqlW_raw_dump, probe:175
MESSAGE : MASTER TIME INFO
DATA #1 : Hexdump, 40 bytes
0x07000000D5BDE710 : 0000 0000 4FFC F636 034A 0000 000C DC7B ....O..6.J.....{
0x07000000D5BDE720 : 0009 A329 477C 1665 0000 0000 004D 46DA ...)G|.e.....MF.
0x07000000D5BDE730 : 8009 A329 477C 1664 ...)G|.d
2012-07-20-08.58.41.060954+480 I159887472A598 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, access plan manager, sqlra_cache_full_dump, probe:25
MESSAGE : Package Cache info dumped! Check
/home/db2admin/sqllib/db2dump/FODC_Trap_2012-07-20-08.58.32.237814/696
424.22608.000.apm.bin for additional data.
2012-07-20-08.58.41.109273+480 I159888071A512 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_signal_handler, probe:350
MESSAGE : DIA0506I Execution of a component signal handling function is
complete.
2012-07-20-09.47.32.925505+480 I159913687A512 LEVEL: Event
PID : 569784 TID : 3342 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-7 APPID: *LOCAL.db2admin.120720014732
AUTHID : DB2ADMIN
EDUID : 3342 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:20
CHANGE : CFG DB DATAIRSS: "Database_memory" From: "1035318" To: "1052064"
2012-07-20-09.47.34.854200+480 I159914601A441 LEVEL: Warning
PID : 569784 TID : 3342 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-7 APPID: *LOCAL.db2admin.120720014732
AUTHID : DB2ADMIN
EDUID : 3342 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:30
MESSAGE : Crash Recovery is needed.
2012-07-20-09.47.40.694143+480 I159915043A504 LEVEL: Warning
PID : 569784 TID : 3342 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-7 APPID: *LOCAL.db2admin.120720014732
AUTHID : DB2ADMIN
EDUID : 3342 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:410
MESSAGE : Crash recovery started. LowtranLSN 000007140030FDCA MinbuffLSN
00000713A1012CB9
2012-07-20-09.47.40.696866+480 E159915548A458 LEVEL: Warning
PID : 569784 TID : 3342 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-7 APPID: *LOCAL.db2admin.120720014732
AUTHID : DB2ADMIN
EDUID : 3342 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:410
MESSAGE : ADM1530E Crash recovery has been initiated.
2012-07-20-09.47.40.708112+480 I159916007A499 LEVEL: Warning
PID : 569784 TID : 3342 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-7 APPID: *LOCAL.db2admin.120720014732
AUTHID : DB2ADMIN
EDUID : 3342 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, recovery manager, sqlprecm, probe:2000
DATA #1 :
Using parallel recovery with 9 agents 11 QSets 88 queues and 5 chunks
2012-07-20-09.48.41.270473+480 I159917417A514 LEVEL: Warning
PID : 569784 TID : 3342 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-7 APPID: *LOCAL.db2admin.120720014732
AUTHID : DB2ADMIN
EDUID : 3342 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, recovery manager, sqlprecm, probe:4000
MESSAGE : DIA2051W Forward phase of crash recovery has completed. Next LSN is
"0000071400312FDA".
2012-07-20-09.48.41.433346+480 E159917932A467 LEVEL: Warning
PID : 569784 TID : 3342 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-7 APPID: *LOCAL.db2admin.120720014732
AUTHID : DB2ADMIN
EDUID : 3342 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:3170
MESSAGE : ADM1531E Crash recovery has completed successfully.
2012-07-20-09.48.41.433948+480 I159918400A469 LEVEL: Warning
PID : 569784 TID : 3342 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-7 APPID: *LOCAL.db2admin.120720014732
AUTHID : DB2ADMIN
EDUID : 3342 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:3170
MESSAGE : Crash recovery completed. Next LSN is 0000071400314304
2012-07-20-09.48.42.666829+480 E159918870A476 LEVEL: Event
PID : 569784 TID : 3342 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-7 APPID: *LOCAL.db2admin.120720014732
AUTHID : DB2ADMIN
EDUID : 3342 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, Self tuning memory manager, stmmLog, probe:1008
DATA #1 :
Starting STMM log from file number 532
2012-07-20-09.48.42.680184+480 I159919347A585 LEVEL: Warning
PID : 569784 TID : 3342 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-7 APPID: *LOCAL.db2admin.120720014732
AUTHID : DB2ADMIN
EDUID : 3342 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, Self tuning memory manager, stmmStartSortDbMonitorIfNecessary, probe:1489
MESSAGE : STMM Sort Memory Tuning cannot be activated because the Database
Manager Configuration Parameter SHEAPTHRES is not set to 0.
2012-07-20-09.51.42.880566+480 I159925506A511 LEVEL: Event
PID : 569784 TID : 15421 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-8 APPID: *LOCAL.DB2.120720014842
AUTHID : DB2ADMIN
EDUID : 15421 EDUNAME: db2stmm (DATAIRSS) 0
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:20
CHANGE : STMM CFG DB DATAIRSS: "Database_memory" From: "1052064" To: "1096151"
2012-07-20-09.52.13.014528+480 I159926018A510 LEVEL: Info
PID : 569784 TID : 15421 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-8 APPID: *LOCAL.DB2.120720014842
AUTHID : DB2ADMIN
EDUID : 15421 EDUNAME: db2stmm (DATAIRSS) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbAlterBufferPoolAct, probe:90
MESSAGE : Altering bufferpool "IRSBP" From: "76101" To: "70393"
2012-07-20-09.52.43.096005+480 I159927025A511 LEVEL: Event
PID : 569784 TID : 15421 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-8 APPID: *LOCAL.DB2.120720014842
AUTHID : DB2ADMIN
EDUID : 15421 EDUNAME: db2stmm (DATAIRSS) 0
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:20
CHANGE : STMM CFG DB DATAIRSS: "Database_memory" From: "1096151" To: "1038901"
2012-07-20-09.58.13.190838+480 I159927537A510 LEVEL: Info
PID : 569784 TID : 15421 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-8 APPID: *LOCAL.DB2.120720014842
AUTHID : DB2ADMIN
EDUID : 15421 EDUNAME: db2stmm (DATAIRSS) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbAlterBufferPoolAct, probe:90
MESSAGE : Altering bufferpool "IRSBP" From: "70393" To: "69625"
收起
2012-07-20-08.58.07.337761+480 E159829454A528 LEVEL: Warning
PID : 696424 TID : 32220 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25382 APPID: 192.168.1.53.40815.120720005701
AUTHID : DBREAD
EDUID : 32220 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, data management, sqldBeginIndexCreate, probe:1
MESSAGE : ADM5540W Beginning index rebuild of "1" index(es) on table "DBREAD
.DIM_RETAILER_PUBLIC".
2012-07-20-08.58.07.338405+480 E159829983A557 LEVEL: Warning
PID : 696424 TID : 32220 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25382 APPID: 192.168.1.53.40815.120720005701
AUTHID : DBREAD
EDUID : 32220 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, data management, sqldIndexCreate, probe:1
MESSAGE : ADM5541W Rebuilding index with IID "1" in object with ID "5" and
table space ID "4" on table "DBREAD .DIM_RETAILER_PUBLIC".
2012-07-20-08.58.07.573343+480 E159830541A535 LEVEL: Warning
PID : 696424 TID : 32220 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25382 APPID: 192.168.1.53.40815.120720005701
AUTHID : DBREAD
EDUID : 32220 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, data management, sqldEndIndexCreate, probe:1
MESSAGE : ADM5542W Index rebuild of index(es) on table "DBREAD
.DIM_RETAILER_PUBLIC" completed successfully.
2012-07-20-08.58.07.941395+480 I159831077A479 LEVEL: Warning
PID : 696424 TID : 23078 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25409 APPID: 192.168.1.53.40820.120720005707
AUTHID : DBREAD
EDUID : 23078 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, database utilities, sqluvtld_route_in, probe:837
DATA #1 :
Starting LOAD operation (Q) (6) (I).
2012-07-20-08.58.08.456973+480 I159831557A502 LEVEL: Warning
PID : 696424 TID : 32662 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25409 APPID: 192.168.1.53.40820.120720005707
AUTHID : DBREAD
EDUID : 32662 EDUNAME: db2lrid 0
FUNCTION: DB2 UDB, database utilities, DIAG_NOTE, probe:0
DATA #1 : String, 79 bytes
LOADID: 23078.2012-07-20-08.58.07.941385.0 (9;10)
Load CPU parallelism is: 7, 0
2012-07-20-08.58.08.519012+480 I159832060A572 LEVEL: Warning
PID : 696424 TID : 3214 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25409 APPID: 192.168.1.53.40820.120720005707
AUTHID : DBREAD
EDUID : 3214 EDUNAME: db2lfrm0 0
FUNCTION: DB2 UDB, database utilities, sqlulPrintPhaseMsg, probe:311
DATA #1 : String, 137 bytes
LOADID: 23078.2012-07-20-08.58.07.941385.0 (9;10)
Starting LOAD phase at 2012-07-20 08:58:08.511154. Table DBREAD .DIM_RETAILER_PUBLIC
2012-07-20-08.58.08.698302+480 I159832633A537 LEVEL: Warning
PID : 696424 TID : 32662 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25409 APPID: 192.168.1.53.40820.120720005707
AUTHID : DBREAD
EDUID : 32662 EDUNAME: db2lrid 0
FUNCTION: DB2 UDB, database utilities, sqlulPrintPhaseMsg, probe:311
DATA #1 : String, 103 bytes
LOADID: 23078.2012-07-20-08.58.07.941385.0 (9;10)
Completed LOAD phase at 2012-07-20 08:58:08.690265.
2012-07-20-08.58.08.706238+480 I159833171A537 LEVEL: Warning
PID : 696424 TID : 32662 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25409 APPID: 192.168.1.53.40820.120720005707
AUTHID : DBREAD
EDUID : 32662 EDUNAME: db2lrid 0
FUNCTION: DB2 UDB, database utilities, sqlulPrintPhaseMsg, probe:311
DATA #1 : String, 103 bytes
LOADID: 23078.2012-07-20-08.58.07.941385.0 (9;10)
Starting BUILD phase at 2012-07-20 08:58:08.698536.
2012-07-20-08.58.08.849694+480 I159833709A538 LEVEL: Warning
PID : 696424 TID : 32662 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25409 APPID: 192.168.1.53.40820.120720005707
AUTHID : DBREAD
EDUID : 32662 EDUNAME: db2lrid 0
FUNCTION: DB2 UDB, database utilities, sqlulPrintPhaseMsg, probe:311
DATA #1 : String, 104 bytes
LOADID: 23078.2012-07-20-08.58.07.941385.0 (9;10)
Completed BUILD phase at 2012-07-20 08:58:08.836427.
2012-07-20-08.58.08.854129+480 I159834248A547 LEVEL: Error
PID : 696424 TID : 23078 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25409 APPID: 192.168.1.53.40820.120720005707
AUTHID : DBREAD
EDUID : 23078 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 112 bytes
LOADID: 23078.2012-07-20-08.58.07.941385.0 (9;10)
Marking index OK , 0, 0, Detected in file:sqluvld.C, Line:5715
2012-07-20-08.58.09.505171+480 I159834796A479 LEVEL: Warning
PID : 696424 TID : 23078 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25406 APPID: 192.168.1.53.40823.120720005711
AUTHID : DBREAD
EDUID : 23078 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, database utilities, sqluvtld_route_in, probe:837
DATA #1 :
Starting LOAD operation (Q) (6) (I).
2012-07-20-08.58.09.994890+480 I159835276A502 LEVEL: Warning
PID : 696424 TID : 32713 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25406 APPID: 192.168.1.53.40823.120720005711
AUTHID : DBREAD
EDUID : 32713 EDUNAME: db2lrid 0
FUNCTION: DB2 UDB, database utilities, DIAG_NOTE, probe:0
DATA #1 : String, 79 bytes
LOADID: 23078.2012-07-20-08.58.09.505160.0 (9;10)
Load CPU parallelism is: 7, 0
2012-07-20-08.58.10.180583+480 I159835779A572 LEVEL: Warning
PID : 696424 TID : 3265 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25406 APPID: 192.168.1.53.40823.120720005711
AUTHID : DBREAD
EDUID : 3265 EDUNAME: db2lfrm0 0
FUNCTION: DB2 UDB, database utilities, sqlulPrintPhaseMsg, probe:311
DATA #1 : String, 137 bytes
LOADID: 23078.2012-07-20-08.58.09.505160.0 (9;10)
Starting LOAD phase at 2012-07-20 08:58:10.167226. Table DBREAD .DIM_RETAILER_PUBLIC
2012-07-20-08.58.32.414883+480 I159836352A570 LEVEL: Error
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:1
MESSAGE : Error in agent servicing application with coor_node:
DATA #1 : Hexdump, 2 bytes
0x070000019FC09770 : 0000 ..
2012-07-20-08.58.32.440441+480 I159836923A577 LEVEL: Error
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:2
MESSAGE : Error in agent servicing application with coor_agent_index:
DATA #1 : Hexdump, 2 bytes
0x070000019FC09772 : 634C cL
2012-07-20-08.58.32.440648+480 I159837501A572 LEVEL: Error
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:3
MESSAGE : Error in agent servicing application with CLIENT PID:
DATA #1 : Hexdump, 3 bytes
0x070000019FC09790 : 3431 32 412
2012-07-20-08.58.32.440838+480 I159838074A678 LEVEL: Error
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:4
MESSAGE : Error in agent servicing application with INBOUND APPLICATION ID:
DATA #1 : Hexdump, 31 bytes
0x0780000000FDEAA4 : 3139 322E 3136 382E 3135 2E31 362E 3136 192.168.15.16.16
0x0780000000FDEAB4 : 3833 352E 3132 3037 3230 3030 3538 33 835.12072000583
2012-07-20-08.58.32.441052+480 I159838753A584 LEVEL: Error
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:5
MESSAGE : Error in agent servicing application with INBOUND SEQUENCE NUMBER:
DATA #1 : Hexdump, 2 bytes
0x0780000000FDE5E8 : 0002 ..
2012-07-20-08.58.32.441243+480 I159839338A490 LEVEL: Error
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:6
MESSAGE : Error in agent servicing application with OUTBOUND APPLICATION ID:
2012-07-20-08.58.32.441427+480 I159839829A491 LEVEL: Error
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:7
MESSAGE : Error in agent servicing application with OUTBOUND SEQUENCE NUMBER:
2012-07-20-08.58.32.441670+480 I159840321A1226 LEVEL: Error
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:8
MESSAGE : Error in agent servicing application with AUTHORIZATION ID:
DATA #1 : Hexdump, 129 bytes
0x0780000000FDD9A1 : 4442 5245 4144 2020 0000 0000 0000 0000 DBREAD ........
0x0780000000FDD9B1 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0780000000FDD9C1 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0780000000FDD9D1 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0780000000FDD9E1 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0780000000FDD9F1 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0780000000FDDA01 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0780000000FDDA11 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0780000000FDDA21 : 00 .
2012-07-20-08.58.32.441898+480 I159841548A584 LEVEL: Error
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:9
MESSAGE : Error in agent servicing application with PRODUCT SIGNATURE:
DATA #1 : Hexdump, 8 bytes
0x0780000000FDEB50 : 5351 4C30 3930 3730 SQL09070
2012-07-20-08.58.32.442089+480 I159842133A593 LEVEL: Error
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:10
MESSAGE : Error in agent servicing application with APPLICATION NAME:
DATA #1 : Hexdump, 16 bytes
0x0780000000FDEB26 : 5175 6573 7443 656E 7472 616C 2E65 7865 QuestCentral.exe
2012-07-20-08.58.32.469307+480 I159842727A520 LEVEL: Event
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, trace services, pdInvokeCalloutScript, probe:10
START : Invoking /home/db2admin/sqllib/bin/db2cos_trap from oper system services sqloEDUCodeTrapHandler
2012-07-20-08.58.39.956251+480 I159843248A481 LEVEL: Event
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, trace services, pdInvokeCalloutScript, probe:20
STOP : Completed invoking /home/db2admin/sqllib/bin/db2cos_trap
2012-07-20-08.58.39.956619+480 E159843730A1352 LEVEL: Critical
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler, probe:10
MESSAGE : ADM14001C An unexpected and critical error has occurred: "Trap". The
instance may have been shutdown as a result. "Automatic" FODC (First
Occurrence Data Capture) has been invoked and diagnostic information
has been recorded in directory
"/home/db2admin/sqllib/db2dump/FODC_Trap_2012-07-20-08.58.32.237814/"
. Please look in this directory for detailed evidence about what
happened and contact IBM support if necessary to diagnose the
problem.
DATA #1 : Signal Number Recieved, 4 bytes
11
DATA #2 : Siginfo, 64 bytes
0x070000019FC09DC0 : 0000 000B 0000 0000 0000 0033 0000 0000 ...........3....
0x070000019FC09DD0 : 0000 0000 0000 0000 0000 0000 0000 00D8 ................
0x070000019FC09DE0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x070000019FC09DF0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
2012-07-20-08.58.39.980134+480 I159845083A501 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, DRDA Application Server, sqljsSignalHandler, probe:10
MESSAGE : DIA0505I Execution of a component signal handling function has begun.
2012-07-20-08.58.40.078342+480 I159847419A514 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, DRDA Application Server, sqljsSignalHandler, probe:20
MESSAGE : DIA0506I Execution of a component signal handling function is
complete.
2012-07-20-08.58.40.094906+480 I159847934A493 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, Query Gateway, sqlqg_signal_handler, probe:10
MESSAGE : DIA0505I Execution of a component signal handling function has begun.
2012-07-20-08.58.40.140574+480 I159849071A616 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_string (secondary logging fu, probe:0
MESSAGE : SQQG SERVER INFO
DATA #1 : String, 127 bytes
SQQG Server Information is dumped into
/home/db2admin/sqllib/db2dump/FODC_Trap_2012-07-20-08.58.32.237814/qg69642422608.000.me
2012-07-20-08.58.40.188842+480 I159850121A506 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, Query Gateway, sqlqg_signal_handler, probe:20
MESSAGE : DIA0506I Execution of a component signal handling function is
complete.
2012-07-20-08.58.40.217011+480 I159850628A499 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_signal_handler, probe:100
MESSAGE : DIA0505I Execution of a component signal handling function has begun.
2012-07-20-08.58.40.238291+480 I159851128A703 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:25
MESSAGE : MASTER TIME INFO
DATA #1 : Hexdump, 40 bytes
0x07000000D5BDE710 : 0000 0000 4FFC F636 034A 0000 000C DC7B ....O..6.J.....{
0x07000000D5BDE720 : 0009 A329 477C 1665 0000 0000 004D 46DA ...)G|.e.....MF.
0x07000000D5BDE730 : 8009 A329 477C 1664 ...)G|.d
2012-07-20-08.58.40.256230+480 I159852921A656 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging func, probe:0
MESSAGE : RDS UCINTFC: pCurrentPID->rdbname =
DATA #1 : Hexdump, 18 bytes
0x0000000114C11D88 : 4441 5441 4952 5353 2020 2020 2020 2020 DATAIRSS
0x0000000114C11D98 : 2020
2012-07-20-08.58.40.256426+480 I159853578A578 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging func, probe:0
MESSAGE : RDS UCINTFC: pCurrentPID->rdbcolidLen =
DATA #1 : Hexdump, 2 bytes
0x0000000114C11D68 : 0008 ..
2012-07-20-08.58.40.256617+480 I159854157A591 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging func, probe:0
MESSAGE : RDS UCINTFC: pCurrentPID->pkgnamcsn.rdbcolid =
DATA #1 : Hexdump, 8 bytes
0x0000000114C11D9A : 4E55 4C4C 4944 2020 NULLID
2012-07-20-08.58.40.256819+480 I159854749A577 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging func, probe:0
MESSAGE : RDS UCINTFC: pCurrentPID->pkgnameLen =
DATA #1 : Hexdump, 2 bytes
0x0000000114C11D78 : 0008 ..
2012-07-20-08.58.40.257009+480 I159855327A589 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging func, probe:0
MESSAGE : RDS UCINTFC: pCurrentPID->pkgnamcsn.pkgname=
DATA #1 : Hexdump, 8 bytes
0x0000000114C11DAC : 5359 5353 4832 3030 SYSSH200
2012-07-20-08.58.40.257234+480 I159855917A582 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging func, probe:0
MESSAGE : RDS UCINTFC: pCurrentPID->pkgcnstkn =
DATA #1 : Hexdump, 8 bytes
0x0000000114C11DBE : 5359 534C 564C 3031 SYSLVL01
2012-07-20-08.58.40.257429+480 I159856500A572 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging func, probe:0
MESSAGE : RDS UCINTFC: pCurrentPID->pkgsn =
DATA #1 : Hexdump, 2 bytes
0x0000000114C11DC6 : 0004 ..
2012-07-20-08.58.40.257619+480 I159857073A3580 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging func, probe:0
MESSAGE : RDS UCINTFC: pStatementText =
DATA #1 : Hexdump, 607 bytes
0x0000000124515880 : 7365 6C65 6374 2061 2E73 6D65 6D5F 6964 select a.smem_id
0x0000000124515890 : 2C61 2E73 6E6F 6465 2C61 2E73 6E61 6D65 ,a.snode,a.sname
0x00000001245158A0 : 2C61 2E62 6D65 6D5F 6964 2C61 2E62 6E6F ,a.bmem_id,a.bno
0x00000001245158B0 : 6465 2C61 2E62 6E61 6D65 2C63 2E63 6967 de,a.bname,c.cig
0x00000001245158C0 : 5F63 6F64 6562 6172 2C63 2E63 6967 5F74 _codebar,c.cig_t
0x00000001245158D0 : 7261 6465 6D61 726B 2C63 2E63 6967 5F6D rademark,c.cig_m
0x00000001245158E0 : 6172 6B6E 616D 652C 612E 7375 626B 696E arkname,a.subkin
0x00000001245158F0 : 642C 7375 6D28 5155 414E 5449 5459 292F d,sum(QUANTITY)/
0x0000000124515900 : 3520 5155 414E 5449 5459 2066 726F 6D20 5 QUANTITY from
0x0000000124515910 : 4442 3241 444D 494E 2E4E 4943 4B5F 5A4A DB2ADMIN.NICK_ZJ
0x0000000124515920 : 5F43 5F58 594F 5244 4552 2061 2C44 4232 _C_XYORDER a,DB2
0x0000000124515930 : 4144 4D49 4E2E 4E49 434B 5F5A 4A5F 435F ADMIN.NICK_ZJ_C_
0x0000000124515940 : 5859 4F52 4450 525F 4649 4E41 4C20 6220 XYORDPR_FINAL b
0x0000000124515950 : 2C44 4232 4144 4D49 4E2E 4E49 434B 5F53 ,DB2ADMIN.NICK_S
0x0000000124515960 : 544D 415F 4349 4741 5245 5454 4520 6320 TMA_CIGARETTE c
0x0000000124515970 : 7768 6572 6520 6465 6C69 5F64 6174 653D where deli_date=
0x0000000124515980 : 2732 3031 32C4 EAC9 CFB0 EBC4 EA27 2061 '2012........' a
0x0000000124515990 : 6E64 2061 2E6F 7264 6572 5F69 643D 622E nd a.order_id=b.
0x00000001245159A0 : 6F72 6465 725F 6964 2061 6E64 2063 2E63 order_id and c.c
0x00000001245159B0 : 6967 5F63 6F64 6562 6172 3D73 7562 7374 ig_codebar=subst
0x00000001245159C0 : 7228 622E 5052 4F44 5543 545F 4944 2C31 r(b.PRODUCT_ID,1
0x00000001245159D0 : 2C31 3329 2020 2061 6E64 2064 656C 5F64 ,13) and del_d
0x00000001245159E0 : 6174 6520 6973 206E 756C 6C20 616E 6420 ate is null and
0x00000001245159F0 : 632E 6369 675F 7072 6F64 7563 6572 3D27 c.cig_producer='
0x0000000124515A00 : 3230 3434 3030 3031 2720 616E 6420 7375 20440001' and su
0x0000000124515A10 : 626B 696E 643D 27B9 BACF FA27 2061 6E64 bkind='....' and
0x0000000124515A20 : 2073 6E6F 6465 3D27 B9E3 B6AB CAA1 2720 snode='......'
0x0000000124515A30 : 2067 726F 7570 2062 7920 612E 736D 656D group by a.smem
0x0000000124515A40 : 5F69 642C 612E 736E 6F64 652C 612E 736E _id,a.snode,a.sn
0x0000000124515A50 : 616D 652C 612E 626D 656D 5F69 642C 612E ame,a.bmem_id,a.
0x0000000124515A60 : 626E 6F64 652C 612E 626E 616D 652C 632E bnode,a.bname,c.
0x0000000124515A70 : 6369 675F 636F 6465 6261 722C 632E 6369 cig_codebar,c.ci
0x0000000124515A80 : 675F 7472 6164 656D 6172 6B2C 612E 7375 g_trademark,a.su
0x0000000124515A90 : 626B 696E 642C 632E 6369 675F 6D61 726B bkind,c.cig_mark
0x0000000124515AA0 : 6E61 6D65 206F 7264 6572 2062 7920 6369 name order by ci
0x0000000124515AB0 : 675F 6D61 726B 6E61 6D65 2061 7363 2C62 g_markname asc,b
0x0000000124515AC0 : 6D65 6D5F 6964 2061 7363 2C73 756D 2851 mem_id asc,sum(Q
0x0000000124515AD0 : 5541 4E54 4954 5929 2F35 2064 6573 63 UANTITY)/5 desc
2012-07-20-08.58.40.259169+480 I159862650A578 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:250
RETCODE : ZRC=0x87120007=-2028863481=SQLR_SEVERE_PGM_ERROR
"Severe programming error"
DIA8516C A severe internal processing error has occurred.
2012-07-20-08.58.40.288378+480 I159863229A704 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:275
MESSAGE : MASTER TIME INFO
DATA #1 : Hexdump, 40 bytes
0x07000000D5BDE710 : 0000 0000 4FFC F636 034A 0000 000C DC7B ....O..6.J.....{
0x07000000D5BDE720 : 0009 A329 477C 1665 0000 0000 004D 46DA ...)G|.e.....MF.
0x07000000D5BDE730 : 8009 A329 477C 1664 ...)G|.d
2012-07-20-08.58.40.288739+480 I159864156A1180 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:300
MESSAGE : SQLCA
DATA #1 : Hexdump, 136 bytes
0x0780000001193A60 : 5351 4C43 4120 2020 0000 0088 0000 0000 SQLCA ........
0x0780000001193A70 : 0000 2020 2020 2020 2020 2020 2020 2020 ..
0x0780000001193A80 : 2020 2020 2020 2020 2020 2020 2020 2020
0x0780000001193A90 : 2020 2020 2020 2020 2020 2020 2020 2020
0x0780000001193AA0 : 2020 2020 2020 2020 2020 2020 2020 2020
0x0780000001193AB0 : 2020 2020 2020 2020 5351 4C30 3930 3530 SQL09050
0x0780000001193AC0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0780000001193AD0 : 0000 0000 0000 0000 2020 2020 2020 2020 ........
0x0780000001193AE0 : 2020 2020 2020 2020
2012-07-20-08.58.40.289094+480 I159865548A532 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:400
MESSAGE : CREATOR
DATA #1 : Hexdump, 8 bytes
0x0700000011012FD8 : 4E55 4C4C 4944 2020 NULLID
2012-07-20-08.58.40.289285+480 I159866081A532 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:450
MESSAGE : PACKAGE
DATA #1 : Hexdump, 8 bytes
0x0700000011012FD0 : 5359 5353 4832 3030 SYSSH200
2012-07-20-08.58.40.388647+480 I159869249A3546 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_sibling, probe:200
MESSAGE : section stmt
DATA #1 : Hexdump, 607 bytes
0x07000000D601EC60 : 7365 6C65 6374 2061 2E73 6D65 6D5F 6964 select a.smem_id
0x07000000D601EC70 : 2C61 2E73 6E6F 6465 2C61 2E73 6E61 6D65 ,a.snode,a.sname
0x07000000D601EC80 : 2C61 2E62 6D65 6D5F 6964 2C61 2E62 6E6F ,a.bmem_id,a.bno
0x07000000D601EC90 : 6465 2C61 2E62 6E61 6D65 2C63 2E63 6967 de,a.bname,c.cig
0x07000000D601ECA0 : 5F63 6F64 6562 6172 2C63 2E63 6967 5F74 _codebar,c.cig_t
0x07000000D601ECB0 : 7261 6465 6D61 726B 2C63 2E63 6967 5F6D rademark,c.cig_m
0x07000000D601ECC0 : 6172 6B6E 616D 652C 612E 7375 626B 696E arkname,a.subkin
0x07000000D601ECD0 : 642C 7375 6D28 5155 414E 5449 5459 292F d,sum(QUANTITY)/
0x07000000D601ECE0 : 3520 5155 414E 5449 5459 2066 726F 6D20 5 QUANTITY from
0x07000000D601ECF0 : 4442 3241 444D 494E 2E4E 4943 4B5F 5A4A DB2ADMIN.NICK_ZJ
0x07000000D601ED00 : 5F43 5F58 594F 5244 4552 2061 2C44 4232 _C_XYORDER a,DB2
0x07000000D601ED10 : 4144 4D49 4E2E 4E49 434B 5F5A 4A5F 435F ADMIN.NICK_ZJ_C_
0x07000000D601ED20 : 5859 4F52 4450 525F 4649 4E41 4C20 6220 XYORDPR_FINAL b
0x07000000D601ED30 : 2C44 4232 4144 4D49 4E2E 4E49 434B 5F53 ,DB2ADMIN.NICK_S
0x07000000D601ED40 : 544D 415F 4349 4741 5245 5454 4520 6320 TMA_CIGARETTE c
0x07000000D601ED50 : 7768 6572 6520 6465 6C69 5F64 6174 653D where deli_date=
0x07000000D601ED60 : 2732 3031 32C4 EAC9 CFB0 EBC4 EA27 2061 '2012........' a
0x07000000D601ED70 : 6E64 2061 2E6F 7264 6572 5F69 643D 622E nd a.order_id=b.
0x07000000D601ED80 : 6F72 6465 725F 6964 2061 6E64 2063 2E63 order_id and c.c
0x07000000D601ED90 : 6967 5F63 6F64 6562 6172 3D73 7562 7374 ig_codebar=subst
0x07000000D601EDA0 : 7228 622E 5052 4F44 5543 545F 4944 2C31 r(b.PRODUCT_ID,1
0x07000000D601EDB0 : 2C31 3329 2020 2061 6E64 2064 656C 5F64 ,13) and del_d
0x07000000D601EDC0 : 6174 6520 6973 206E 756C 6C20 616E 6420 ate is null and
0x07000000D601EDD0 : 632E 6369 675F 7072 6F64 7563 6572 3D27 c.cig_producer='
0x07000000D601EDE0 : 3230 3434 3030 3031 2720 616E 6420 7375 20440001' and su
0x07000000D601EDF0 : 626B 696E 643D 27B9 BACF FA27 2061 6E64 bkind='....' and
0x07000000D601EE00 : 2073 6E6F 6465 3D27 B9E3 B6AB CAA1 2720 snode='......'
0x07000000D601EE10 : 2067 726F 7570 2062 7920 612E 736D 656D group by a.smem
0x07000000D601EE20 : 5F69 642C 612E 736E 6F64 652C 612E 736E _id,a.snode,a.sn
0x07000000D601EE30 : 616D 652C 612E 626D 656D 5F69 642C 612E ame,a.bmem_id,a.
0x07000000D601EE40 : 626E 6F64 652C 612E 626E 616D 652C 632E bnode,a.bname,c.
0x07000000D601EE50 : 6369 675F 636F 6465 6261 722C 632E 6369 cig_codebar,c.ci
0x07000000D601EE60 : 675F 7472 6164 656D 6172 6B2C 612E 7375 g_trademark,a.su
0x07000000D601EE70 : 626B 696E 642C 632E 6369 675F 6D61 726B bkind,c.cig_mark
0x07000000D601EE80 : 6E61 6D65 206F 7264 6572 2062 7920 6369 name order by ci
0x07000000D601EE90 : 675F 6D61 726B 6E61 6D65 2061 7363 2C62 g_markname asc,b
0x07000000D601EEA0 : 6D65 6D5F 6964 2061 7363 2C73 756D 2851 mem_id asc,sum(Q
0x07000000D601EEB0 : 5541 4E54 4954 5929 2F35 2064 6573 63 UANTITY)/5 desc
2012-07-20-08.58.40.400391+480 I159873014A578 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:550
RETCODE : ZRC=0x87120007=-2028863481=SQLR_SEVERE_PGM_ERROR
"Severe programming error"
DIA8516C A severe internal processing error has occurred.
2012-07-20-08.58.40.400715+480 I159873593A414 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:550
2012-07-20-08.58.40.401561+480 I159874445A566 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging func, probe:0
MESSAGE : SQLD_AGENT_CB Pointer:
DATA #1 : Hexdump, 8 bytes
0x070000019FC09190 : 0000 0001 2451 4380 ....$QC.
2012-07-20-08.58.40.401905+480 I159875231A564 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging func, probe:0
MESSAGE : SQLD_TRAN_CB Pointer
DATA #1 : Hexdump, 8 bytes
0x070000019FC091A0 : 0700 0000 1012 6000 ......`.
2012-07-20-08.58.40.402227+480 I159876014A563 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging func, probe:0
MESSAGE : SQLD_APP_CB Pointer
DATA #1 : Hexdump, 8 bytes
0x070000019FC09198 : 0700 0000 101B F900 ........
2012-07-20-08.58.40.402546+480 I159876795A514 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_string (secondary logging fu, probe:0
MESSAGE : >> Begin CURSOR dump:
DATA #1 : String, 21 bytes
OPEN PERM CURSORS: >>
2012-07-20-08.58.40.402763+480 I159877310A512 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_string (secondary logging fu, probe:0
MESSAGE : << End CURSOR dump:
DATA #1 : String, 22 bytes
OPEN PERM CURSORS: <<
2012-07-20-08.58.40.402951+480 I159877823A514 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_string (secondary logging fu, probe:0
MESSAGE : >> Begin CURSOR dump:
DATA #1 : String, 21 bytes
OPEN TEMP CURSORS: >>
2012-07-20-08.58.40.403168+480 I159878338A512 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_string (secondary logging fu, probe:0
MESSAGE : << End CURSOR dump:
DATA #1 : String, 22 bytes
OPEN TEMP CURSORS: <<
2012-07-20-08.58.40.415008+480 I159878851A512 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_string (secondary logging fu, probe:0
MESSAGE : >> Begin CURSOR dump:
DATA #1 : String, 19 bytes
CLOSED CURSORS: >>
2012-07-20-08.58.40.415247+480 I159879364A509 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_string (secondary logging fu, probe:0
MESSAGE : << End CURSOR dump:
DATA #1 : String, 19 bytes
CLOSED CURSORS: <<
2012-07-20-08.58.40.650092+480 I159882056A598 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_string (secondary logging fu, probe:0
MESSAGE : locklist
DATA #1 : String, 117 bytes
Check /home/db2admin/sqllib/db2dump/FODC_Trap_2012-07-20-08.58.32.237814/931727.000.locklist.txt for additional data.
2012-07-20-08.58.40.791315+480 I159883527A461 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:650
DATA #1 : String, 19 bytes
XML components dump
2012-07-20-08.58.40.955186+480 I159884422A591 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, access plan manager, sqlra_sqlC_raw_dump, probe:150
MESSAGE : Context info dumped! Check
/home/db2admin/sqllib/db2dump/FODC_Trap_2012-07-20-08.58.32.237814/696
424.22608.000.apm.bin for additional data.
2012-07-20-08.58.40.955454+480 I159885014A709 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, access plan manager, sqlra_sqlC_raw_dump, probe:175
MESSAGE : MASTER TIME INFO
DATA #1 : Hexdump, 40 bytes
0x07000000D5BDE710 : 0000 0000 4FFC F636 034A 0000 000C DC7B ....O..6.J.....{
0x07000000D5BDE720 : 0009 A329 477C 1665 0000 0000 004D 46DA ...)G|.e.....MF.
0x07000000D5BDE730 : 8009 A329 477C 1664 ...)G|.d
2012-07-20-08.58.40.977081+480 I159885946A593 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, access plan manager, sqlra_sqlW_raw_dump, probe:150
MESSAGE : Workspace info dumped! Check
/home/db2admin/sqllib/db2dump/FODC_Trap_2012-07-20-08.58.32.237814/696
424.22608.000.apm.bin for additional data.
2012-07-20-08.58.40.977317+480 I159886540A709 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, access plan manager, sqlra_sqlW_raw_dump, probe:175
MESSAGE : MASTER TIME INFO
DATA #1 : Hexdump, 40 bytes
0x07000000D5BDE710 : 0000 0000 4FFC F636 034A 0000 000C DC7B ....O..6.J.....{
0x07000000D5BDE720 : 0009 A329 477C 1665 0000 0000 004D 46DA ...)G|.e.....MF.
0x07000000D5BDE730 : 8009 A329 477C 1664 ...)G|.d
2012-07-20-08.58.41.060954+480 I159887472A598 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, access plan manager, sqlra_cache_full_dump, probe:25
MESSAGE : Package Cache info dumped! Check
/home/db2admin/sqllib/db2dump/FODC_Trap_2012-07-20-08.58.32.237814/696
424.22608.000.apm.bin for additional data.
2012-07-20-08.58.41.109273+480 I159888071A512 LEVEL: Severe
PID : 696424 TID : 22608 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-25420 APPID: 192.168.15.16.16835.12072000583
AUTHID : DBREAD
EDUID : 22608 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_signal_handler, probe:350
MESSAGE : DIA0506I Execution of a component signal handling function is
complete.
2012-07-20-09.47.32.925505+480 I159913687A512 LEVEL: Event
PID : 569784 TID : 3342 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-7 APPID: *LOCAL.db2admin.120720014732
AUTHID : DB2ADMIN
EDUID : 3342 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:20
CHANGE : CFG DB DATAIRSS: "Database_memory" From: "1035318"
2012-07-20-09.47.34.854200+480 I159914601A441 LEVEL: Warning
PID : 569784 TID : 3342 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-7 APPID: *LOCAL.db2admin.120720014732
AUTHID : DB2ADMIN
EDUID : 3342 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:30
MESSAGE : Crash Recovery is needed.
2012-07-20-09.47.40.694143+480 I159915043A504 LEVEL: Warning
PID : 569784 TID : 3342 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-7 APPID: *LOCAL.db2admin.120720014732
AUTHID : DB2ADMIN
EDUID : 3342 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:410
MESSAGE : Crash recovery started. LowtranLSN 000007140030FDCA MinbuffLSN
00000713A1012CB9
2012-07-20-09.47.40.696866+480 E159915548A458 LEVEL: Warning
PID : 569784 TID : 3342 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-7 APPID: *LOCAL.db2admin.120720014732
AUTHID : DB2ADMIN
EDUID : 3342 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:410
MESSAGE : ADM1530E Crash recovery has been initiated.
2012-07-20-09.47.40.708112+480 I159916007A499 LEVEL: Warning
PID : 569784 TID : 3342 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-7 APPID: *LOCAL.db2admin.120720014732
AUTHID : DB2ADMIN
EDUID : 3342 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, recovery manager, sqlprecm, probe:2000
DATA #1 :
Using parallel recovery with 9 agents 11 QSets 88 queues and 5 chunks
2012-07-20-09.48.41.270473+480 I159917417A514 LEVEL: Warning
PID : 569784 TID : 3342 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-7 APPID: *LOCAL.db2admin.120720014732
AUTHID : DB2ADMIN
EDUID : 3342 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, recovery manager, sqlprecm, probe:4000
MESSAGE : DIA2051W Forward phase of crash recovery has completed. Next LSN is
"0000071400312FDA".
2012-07-20-09.48.41.433346+480 E159917932A467 LEVEL: Warning
PID : 569784 TID : 3342 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-7 APPID: *LOCAL.db2admin.120720014732
AUTHID : DB2ADMIN
EDUID : 3342 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:3170
MESSAGE : ADM1531E Crash recovery has completed successfully.
2012-07-20-09.48.41.433948+480 I159918400A469 LEVEL: Warning
PID : 569784 TID : 3342 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-7 APPID: *LOCAL.db2admin.120720014732
AUTHID : DB2ADMIN
EDUID : 3342 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:3170
MESSAGE : Crash recovery completed. Next LSN is 0000071400314304
2012-07-20-09.48.42.666829+480 E159918870A476 LEVEL: Event
PID : 569784 TID : 3342 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-7 APPID: *LOCAL.db2admin.120720014732
AUTHID : DB2ADMIN
EDUID : 3342 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, Self tuning memory manager, stmmLog, probe:1008
DATA #1 :
Starting STMM log from file number 532
2012-07-20-09.48.42.680184+480 I159919347A585 LEVEL: Warning
PID : 569784 TID : 3342 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-7 APPID: *LOCAL.db2admin.120720014732
AUTHID : DB2ADMIN
EDUID : 3342 EDUNAME: db2agent (DATAIRSS) 0
FUNCTION: DB2 UDB, Self tuning memory manager, stmmStartSortDbMonitorIfNecessary, probe:1489
MESSAGE : STMM Sort Memory Tuning cannot be activated because the Database
Manager Configuration Parameter SHEAPTHRES is not set to 0.
2012-07-20-09.51.42.880566+480 I159925506A511 LEVEL: Event
PID : 569784 TID : 15421 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-8 APPID: *LOCAL.DB2.120720014842
AUTHID : DB2ADMIN
EDUID : 15421 EDUNAME: db2stmm (DATAIRSS) 0
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:20
CHANGE : STMM CFG DB DATAIRSS: "Database_memory" From: "1052064"
2012-07-20-09.52.13.014528+480 I159926018A510 LEVEL: Info
PID : 569784 TID : 15421 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-8 APPID: *LOCAL.DB2.120720014842
AUTHID : DB2ADMIN
EDUID : 15421 EDUNAME: db2stmm (DATAIRSS) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbAlterBufferPoolAct, probe:90
MESSAGE : Altering bufferpool "IRSBP" From: "76101"
2012-07-20-09.52.43.096005+480 I159927025A511 LEVEL: Event
PID : 569784 TID : 15421 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-8 APPID: *LOCAL.DB2.120720014842
AUTHID : DB2ADMIN
EDUID : 15421 EDUNAME: db2stmm (DATAIRSS) 0
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:20
CHANGE : STMM CFG DB DATAIRSS: "Database_memory" From: "1096151"
2012-07-20-09.58.13.190838+480 I159927537A510 LEVEL: Info
PID : 569784 TID : 15421 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-8 APPID: *LOCAL.DB2.120720014842
AUTHID : DB2ADMIN
EDUID : 15421 EDUNAME: db2stmm (DATAIRSS) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbAlterBufferPoolAct, probe:90
MESSAGE : Altering bufferpool "IRSBP" From: "70393"