By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,851 Members | 1,133 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,851 IT Pros & Developers. It's quick & easy.

DB2 v7 FP14 on Windows2000 crashing

P: n/a
Hi,

We have a DB2 version 7 fixpack 14 installed on Windows 200 at a customer
site that is crashing at regular intervals.Everything was working fine for
over many years, now since about one month, these crashes have been cropping
up. What is really strange is, the crashes occur on two DB2 different
servers at the customer site, both running DB2 version 7 fixpack 14,
although ater uninstalling OO-Defrag from both servers, one of the servers
'seems' to be more stable, i.e. hasn't crashed in the last couple of days.
The other server is crashing more often now though, and the customer is not
very happy, rightly so. The only thing we can think of at the moment that in
some whay correlates to the start of the problem occuring is, the customer,
without being informed, had a new internet connection installed by their
internet provider. Most DB2 users access the databases on the DB2 server via
the internet using a DB2 runtime client. The new internet connection pools
two connections. There is a load pooling that takes place to share the load
when connecting to the main office. Does anyone know if this could cause DB2
to crash, when queries for an agent come via different IP routes? Perhaps we
are looking in the wrong direction. Perhaps someone could have a look at the
db2diag.log below. Analysing the log with the help of Google or the DB2 help
files is feeling like a futile crusade. Any help would be very much
appreciated. I have included all the log entrys applicable to the latest
crash.

Regards

Rudolf Bargholz
2006-08-07-16.56.17.015000 Instance:DB2 Node:000
PID:1312(db2syscs.exe) TID:2832 Appid:393303E7.9207.060807140852
base_sys_utilities sqleagnt_sigsegvh Probe:10 Database:LAT

Error in agent servicing application with coor_node:0000
...
2006-08-07-16.56.17.015001 Instance:DB2 Node:000
PID:1312(db2syscs.exe) TID:2832 Appid:393303E7.9207.060807140852
base_sys_utilities sqleagnt_sigsegvh Probe:10 Database:LAT

Error in agent servicing application with coor_agent_index:1a00
...
2006-08-07-16.56.17.015002 Instance:DB2 Node:000
PID:1312(db2syscs.exe) TID:2832 Appid:393303E7.9207.060807140852
base_sys_utilities sqleagnt_sigsegvh Probe:10 Database:LAT

Error in agent servicing application with CLIENT PID:3237 3230
2720
2006-08-07-16.56.17.031000 Instance:DB2 Node:000
PID:1312(db2syscs.exe) TID:2832 Appid:393303E7.9207.060807140852
base_sys_utilities sqleagnt_sigsegvh Probe:10 Database:LAT

Error in agent servicing application with INBOUND APPLICATION ID:3339 3333
3033 4537 2e39 3230 372e 3036 393303E7.9207.06
3038 3037 3134 3038 3532 0807140852
2006-08-07-16.56.17.031001 Instance:DB2 Node:000
PID:1312(db2syscs.exe) TID:2832 Appid:393303E7.9207.060807140852
base_sys_utilities sqleagnt_sigsegvh Probe:10 Database:LAT

Error in agent servicing application with INBOUND SEQUENCE NUMBER:3030 3031
0001
2006-08-07-16.56.17.031002 Instance:DB2 Node:000
PID:1312(db2syscs.exe) TID:2832 Appid:393303E7.9207.060807140852
base_sys_utilities sqleagnt_sigsegvh Probe:10 Database:LAT

Error in agent servicing application with OUTBOUND APPLICATION ID:

2006-08-07-16.56.17.046000 Instance:DB2 Node:000
PID:1312(db2syscs.exe) TID:2832 Appid:393303E7.9207.060807140852
base_sys_utilities sqleagnt_sigsegvh Probe:10 Database:LAT

Error in agent servicing application with OUTBOUND SEQUENCE NUMBER:

2006-08-07-16.56.17.046001 Instance:DB2 Node:000
PID:1312(db2syscs.exe) TID:2832 Appid:393303E7.9207.060807140852
base_sys_utilities sqleagnt_sigsegvh Probe:10 Database:LAT

Error in agent servicing application with AUTHORIZATION ID:4442 3241 444d
494e 0000 0000 0000 0000 DB2ADMIN........
0000 0000 0000 0000 0000 0000 0000 00 ...............
2006-08-07-16.56.17.046002 Instance:DB2 Node:000
PID:1312(db2syscs.exe) TID:2832 Appid:393303E7.9207.060807140852
base_sys_utilities sqleagnt_sigsegvh Probe:10 Database:LAT

Error in agent servicing application with PRODUCT SIGNATURE:5351 4c30 3730
3130 SQL07010
2006-08-07-16.56.17.046003 Instance:DB2 Node:000
PID:1312(db2syscs.exe) TID:2832 Appid:393303E7.9207.060807140852
base_sys_utilities sqleagnt_sigsegvh Probe:10 Database:LAT

Error in agent servicing application with APPLICATION NAME:4f4d 4e49 532e
4558 45 OMNIS.EXE
2006-08-07-16.56.17.062000 Instance:DB2 Node:000
PID:1312(db2syscs.exe) TID:2832 Appid:393303E7.9207.060807140852
base_sys_utilities sqleagnt_sigsegvh Probe:1 Database:LAT

value of ptr to db2ra_as_cb3040 2745
0@'E
2006-08-07-16.56.17.062001 Instance:DB2 Node:000
PID:1312(db2syscs.exe) TID:2832 Appid:393303E7.9207.060807140852
base_sys_utilities sqleagnt_sigsegvh Probe:2 Database:LAT

contents of db2ra_as_cb70fa 4645 7423 ab00 40f0 9444 40f0 9444
pFEt#.@"D@"D
0000 0000 3041 2745 0000 0000 0000 0000 ....0A'E........
0000 0000 0000 0000 3000 9444 0000 0000 ........0."D....
0000 0000 6840 2745 0000 0000 0000 0000 ....h@'E........
5351 4c44 4232 5241 0200 0900 0000 0000 SQLDB2RA.. .....
0000 1000 0001 0000 5351 4c44 4232 5241 ........SQLDB2RA
0100 0300 0501 0a23 0000 0000 1600 0000 .......#........
0200 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 c407 0000 0000 0000 0501 0112 ...............
0501 0a23 0000 0501 0000 0000 0000 0000 ...#............
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0200 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 ........
2006-08-07-16.56.17.078000 Instance:DB2 Node:000
PID:1312(db2syscs.exe) TID:2832 Appid:393303E7.9207.060807140852
base_sys_utilities sqleagnt_sigsegvh Probe:3 Database:LAT

value of ptr to ccb40f0 9444 @"D
2006-08-07-16.56.17.078001 Instance:DB2 Node:000
PID:1312(db2syscs.exe) TID:2832 Appid:393303E7.9207.060807140852
base_sys_utilities sqleagnt_sigsegvh Probe:4 Database:LAT

contents of ccb0000 0000 0000 0000 3c00 9444 c0f7 8445 ........<."D"E
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 ffff ffff 0000 0000 ............
0400 0000 0200 0000 0000 0000 5351 4c43 ............SQLC
4120 2020 8800 0000 0000 0000 0000 2020 A ^.........
2020 2020 2020 2020 2020 2020 2020 2020
2020 2020 2020 2020 2020 2020 2020 2020
2020 2020 2020 2020 2020 2020 2020 2020
2020 2020 2020 2020 2020 2020 2020 2020
2020 2020 5351 4c30 3730 3239 0000 0000 SQL07029....
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 2020 2020 2020 2020 2020 2020 ....
2020 2020 4e55 4c4c 4944 2020 0000 0000 NULLID ....
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0053 514c 4c46 3030 3000 6841 4463 ...SQLLF000.hADc
5161 4450 0001 0000 0001 0000 0000 0000 QaDP............
ffff 0000 fc02 0000 0e00 0000 .........
2006-08-07-16.56.17.093000 Instance:DB2 Node:000
PID:1312(db2syscs.exe) TID:2832 Appid:393303E7.9207.060807140852
base_sys_utilities sqleagnt_sigsegvh Probe:5 Database:LAT

contents of ccb->db2ra_ptr5351 4c44 4232 5241 e000 0000 0501 0200
SQLDB2RA.......
0600 0900 8800 0000 0900 0080 7cf0 9444 .. .^... ..?|"D
0000 0000 0400 0040 0000 0000 0b00 0000 .......@........
0400 0040 0401 9444 0200 0000 0300 0040 ...@.."D.......@
1001 9444 0800 0000 0100 0040 1401 9444 .."D.......@.."D
0800 0000 0100 0040 1c01 9444 0800 0000 .......@.."D....
0100 0040 2401 9444 0000 0000 0000 0000 ...@$."D........
0000 0000 b404 0000 0500 00c0 c0f7 8445 .........."E
0300 0000 0100 0040 6c07 9444 0400 0000 .......@l."D....
0700 0080 7007 9444 0000 0000 0700 0080 ...?p."D.......?
0000 0000 0400 0000 0500 0040 7407 9444 ...........@t."D
0000 0000 0700 0040 0000 0000 0400 0000 .......@........
0700 0080 7407 9444 0000 0000 0000 4100 ...?t."D......A.
0500 0000 0400 f001 5351 4c4c 4630 3030 .......SQLLF000
2006-08-07-16.56.17.109000 Instance:DB2 Node:000
PID:1312(db2syscs.exe) TID:2832 Appid:393303E7.9207.060807140852
base_sys_utilities sqleagnt_sigsegvh Probe:8 Database:LAT

contents of ccb->native_da5351 4c44 4120 2020 b404 0000 1b00 1b00
SQLDA .......
c001 1400 0000 0000 0000 0000 e404 0000 ..............
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 c101 3c00 .............<.
0000 0000 0000 0000 e404 0000 0000 0000 ...............
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 c101 1400 0000 0000 ...............
0000 0000 e404 0000 0000 0000 0000 0000 ...............
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 8101 0a00 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
c101 1400 0000 0000 0000 0000 e404 0000 ..............
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 c101 1400 ...............
0000 0000 0000 0000 e404 0000 0000 0000 ...............
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 8101 0a00 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 8101 0a00 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
f501 0200 0000 0000 0000 0000 0000 0000 ...............
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 f501 0200 ...............
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 8101 0a00 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 c101 1400 0000 0000 0000 0000 ...............
e404 0000 0000 0000 0000 0000 0000 0000 ...............
0000 0000 0000 0000 0000 0000 0000 0000 ................
8101 0a00 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 c101 1400 ...............
0000 0000 0000 0000 e404 0000 0000 0000 ...............
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 c101 3200 0000 0000 .........2.....
0000 0000 e404 0000 0000 0000 0000 0000 ...............
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 c101 1400 0000 0000 0000 0000 ...............
e404 0000 0000 0000 0000 0000 0000 0000 ...............
0000 0000 0000 0000 0000 0000 0000 0000 ................
c101 1e00 0000 0000 0000 0000 e404 0000 ..............
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 c001 0100 ...............
0000 0000 0000 0000 e404 0000 0000 0000 ...............
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 c001 0100 0000 0000 ...............
0000 0000 e404 0000 0000 0000 0000 0000 ...............
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 c101 0c00 0000 0000 0000 0000 ...............
e404 0000 0000 0000 0000 0000 0000 0000 ...............
0000 0000 0000 0000 0000 0000 0000 0000 ................
c101 1400 0000 0000 0000 0000 e404 0000 ..............
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 e101 0800 ...............
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 e101 0800 0000 0000 ...............
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 e101 0800 0000 0000 0000 0000 ...............
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
c101 1400 0000 0000 0000 0000 e404 0000 ..............
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 e101 0800 ...............
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 c101 1400 0000 0000 ...............
0000 0000 e404 0000 0000 0000 0000 0000 ...............
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 ....
2006-08-07-16.56.17.140001 Instance:DB2 Node:000
PID:1312(db2syscs.exe) TID:2832 Appid:393303E7.9207.060807140852
base_sys_utilities sqleagnt_sigsegvh Probe:6 Database:LAT

contents of comm_handle5041 2745 3040 3045 0000 0000 3000 9444
PA'E0@0E....0."D
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 ff7f 0000 ...............
5a05 0000 0000 0000 0000 0000 4007 0000 Z...........@...
0300 0000 0001 0000 ........
2006-08-07-16.56.17.140002 Instance:DB2 Node:000
PID:1312(db2syscs.exe) TID:2832 Appid:393303E7.9207.060807140852
base_sys_utilities sqleagnt_sigsegvh Probe:7 Database:LAT

contents of comm_handle buffer0000 0000 0000 0000 5351 4c44 4232 5241
.........SQLDB2RA
0200 0900 0000 4000 0000 0053 514c 4341 .. ...@....SQLCA
2020 2088 0000 0000 0000 0000 0000 0000 ^............
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0053 514c 3037 3032 3900 0000 0000 ...SQL07029.....
0000 0001 0000 0034 0100 0000 0000 0000 .......4........
0000 0020 2020 2020 2020 2020 2020 3030 ... 00
3030 3000 1b00 5351 4c44 4120 2020 c859 000...SQLDA Y
0000 0a02 1b00 c001 1400 e404 0000 0000 ..............
0000 0600 4841 5f53 4551 0000 0000 0000 ....HA_SEQ......
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 c101 3c00 e404 0000 0000 0000 0700 ...<..........
4841 5f54 4558 5400 0000 0000 0000 0000 HA_TEXT.........
0000 0000 0000 0000 0000 0000 0000 c101 ...............
1400 e404 0000 0000 0000 0900 4841 5f4e ......... .HA_N
554d 4d45 5200 0000 0000 0000 0000 0000 UMMER...........
0000 0000 0000 0000 0000 8101 0a00 0000 ................
0000 0000 0000 0800 4841 5f44 4154 554d ........HA_DATUM
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 c101 1400 e404 0000 0000 ..............
0000 0a00 4841 5f4b 5545 525a 454c 0000 ....HA_KUERZEL..
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 c101 1400 e404 0000 0000 0000 0600 ..............
4841 5f52 4546 0000 0000 0000 0000 0000 HA_REF..........
0000 0000 0000 0000 0000 0000 0000 8101 ................
0a00 0000 0000 0000 0000 0900 4841 5f44 .......... .HA_D
4550 5a52 4800 0000 0000 0000 0000 0000 EPZRH...........
0000 0000 0000 0000 0000 8101 0a00 0000 ................
0000 0000 0000 0c00 4841 5f46 494e 414c ........HA_FINAL
4441 5445 0000 0000 0000 0000 0000 0000 DATE............
0000 0000 0000 f501 0200 0000 0000 0000 ...............
0000 1200 4841 5f52 4543 484e 554e 4750 ....HA_RECHNUNGP
5249 4e54 4544 0000 0000 0000 0000 0000 RINTED..........
0000 f501 0200 0000 0000 0000 0000 1400 ...............
4841 5f47 5554 5343 4852 4946 5450 5249 HA_GUTSCHRIFTPRI
4e54 4544 0000 0000 0000 0000 0000 8101 NTED............
0a00 0000 0000 0000 0000 1000 4841 5f4c ............HA_L
4554 5a54 4552 4543 4847 5554 0000 0000 ETZTERECHGUT....
0000 0000 0000 0000 0000 c101 1400 e404 ..............
0000 0000 0000 0700 4841 5f52 5345 5100 ........HA_RSEQ.
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 8101 0a00 0000 0000 0000 ................
0000 0d00 4841 5f4f 5054 494f 4e44 4154 ....HA_OPTIONDAT
4500 0000 0000 0000 0000 0000 0000 0000 E...............
0000 c101 1400 e404 0000 0000 0000 0500 ..............
525f 5345 5100 0000 0000 0000 0000 0000 R_SEQ...........
0000 0000 0000 0000 0000 0000 0000 c101 ...............
3200 e404 0000 0000 0000 0700 525f 4e41 2..........R_NA
4d45 3100 0000 0000 0000 0000 0000 0000 ME1.............
0000 0000 0000 0000 0000 c101 1400 e404 ..............
0000 0000 0000 0a00 525f 564f 524e 414d ........R_VORNAM
4531 0000 0000 0000 0000 0000 0000 0000 E1..............
0000 0000 0000 c101 1e00 e404 0000 0000 ..............
0000 0500 525f 4f52 5400 0000 0000 0000 ....R_ORT.......
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 c001 0100 e404 0000 0000 0000 0200 ..............
3138 0000 0000 0000 0000 0000 0000 0000 18..............
0000 0000 0000 0000 0000 0000 00ff c001 ..............
0100 e404 0000 0000 0000 0200 3139 0000 ...........19..
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 00ff c101 0c00 e404 .............
0000 0000 0000 0200 3230 0000 0000 0000 ........20......
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 00ff c101 1400 e404 0000 0000 .............
0000 0900 4841 5f4e 554d 4d45 5200 0000 .. .HA_NUMMER...
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 e101 0800 0000 0000 0000 0000 0200 ...............
3232 0000 0000 0000 0000 0000 0000 0000 22..............
0000 0000 0000 0000 0000 0000 00ff e101 ..............
0800 0000 0000 0000 0000 0200 3233 0000 ............23..
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 00ff e101 0800 0000 ..............
0000 0000 0000 0200 3234 0000 0000 0000 ........24......
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 00ff c101 1400 e404 0000 0000 .............
0000 0700 4153 5f43 4f44 4500 0000 0000 ....AS_CODE.....
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 e101 0800 0000 0000 0000 0000 0200 ...............
3236 0000 0000 0000 0000 0000 0000 0000 26..............
0000 0000 0000 0000 0000 0000 00ff c101 ..............
1400 e404 0000 0000 0000 0700 4153 5f43 ...........AS_C
4f44 4500 0000 0000 0000 0000 0000 0000 ODE.............
0000 0000 0000 0000 0000 ..........
2006-08-07-16.56.17.187000 Instance:DB2 Node:000
PID:1312(db2syscs.exe) TID:2832 Appid:393303E7.9207.060807140852
base_sys_utilities sqleagnt_sigsegvh Probe:10 Database:LAT

size of receive request areac407 0000
...
2006-08-07-16.56.17.187001 Instance:DB2 Node:000
PID:1312(db2syscs.exe) TID:2832 Appid:393303E7.9207.060807140852
base_sys_utilities sqleagnt_sigsegvh Probe:11 Database:LAT

contents of receive request area0740 0000 c407 0000 3407 0000 5351 4c44
..@.....4...SQLD
4232 5241 e000 0000 0501 0200 0600 0900 B2RA......... .
8800 0000 0900 0080 7cf0 9444 0000 0000 ^... ..?|"D....
0400 0040 0000 0000 0b00 0000 0400 0040 ...@...........@
0401 9444 0200 0000 0300 0040 1001 9444 .."D.......@.."D
0800 0000 0100 0040 1401 9444 0800 0000 .......@.."D....
0100 0040 1c01 9444 0800 0000 0100 0040 ...@.."D.......@
2401 9444 0000 0000 0000 0000 0000 0000 $."D............
b404 0000 0500 00c0 c0f7 8445 0300 0000 ......"E....
0100 0040 6c07 9444 0400 0000 0700 0080 ...@l."D.......?
7007 9444 0000 0000 0700 0080 0000 0000 p."D.......?....
0400 0000 0500 0040 7407 9444 0000 0000 .......@t."D....
0700 0040 0000 0000 0400 0000 0700 0080 ...@...........?
7407 9444 0000 0000 0000 4100 0500 0000 t."D......A.....
0400 f001 5351 4c4c 4630 3030 4e55 4c4c ...SQLLF000NULL
4944 2020 6841 4463 5161 4450 5351 4c44 ID hADcQaDPSQLD
4120 2020 c859 0000 0a02 0000 7365 6c65 A Y......sele
6374 2064 6973 7469 6e63 7420 2048 4155 ct distinct HAU
5054 4645 4e53 5445 522e 4841 5f53 4551 PTFENSTER.HA_SEQ
2c48 4155 5054 4645 4e53 5445 522e 4841 ,HAUPTFENSTER.HA
5f54 4558 542c 4841 5550 5446 454e 5354 _TEXT,HAUPTFENST
4552 2e48 415f 4e55 4d4d 4552 2c48 4155 ER.HA_NUMMER,HAU
5054 4645 4e53 5445 522e 4841 5f44 4154 PTFENSTER.HA_DAT
554d 2c48 4155 5054 4645 4e53 5445 522e UM,HAUPTFENSTER.
4841 5f4b 5545 525a 454c 2c48 4155 5054 HA_KUERZEL,HAUPT
4645 4e53 5445 522e 4841 5f52 4546 2c48 FENSTER.HA_REF,H
4155 5054 4645 4e53 5445 522e 4841 5f44 AUPTFENSTER.HA_D
4550 5a52 482c 4841 5550 5446 454e 5354 EPZRH,HAUPTFENST
4552 2e48 415f 4649 4e41 4c44 4154 452c ER.HA_FINALDATE,
4841 5550 5446 454e 5354 4552 2e48 415f HAUPTFENSTER.HA_
5245 4348 4e55 4e47 5052 494e 5445 442c RECHNUNGPRINTED,
4841 5550 5446 454e 5354 4552 2e48 415f HAUPTFENSTER.HA_
4755 5453 4348 5249 4654 5052 494e 5445 GUTSCHRIFTPRINTE
442c 4841 5550 5446 454e 5354 4552 2e48 D,HAUPTFENSTER.H
415f 4c45 545a 5445 5245 4348 4755 542c A_LETZTERECHGUT,
4841 5550 5446 454e 5354 4552 2e48 415f HAUPTFENSTER.HA_
5253 4551 2c48 4155 5054 4645 4e53 5445 RSEQ,HAUPTFENSTE
522e 4841 5f4f 5054 494f 4e44 4154 452c R.HA_OPTIONDATE,
5245 4348 454d 5046 2e52 5f53 4551 2c52 RECHEMPF.R_SEQ,R
4543 4845 4d50 462e 525f 4e41 4d45 312c ECHEMPF.R_NAME1,
5245 4348 454d 5046 2e52 5f56 4f52 4e41 RECHEMPF.R_VORNA
4d45 312c 5245 4348 454d 5046 2e52 5f4f ME1,RECHEMPF.R_O
5254 2c20 2063 6173 6520 6368 6172 2848 RT, case char(H
4155 5054 4645 4e53 5445 522e 4841 5f52 AUPTFENSTER.HA_R
4543 484e 554e 4750 5249 4e54 4544 2920 ECHNUNGPRINTED)
2077 6865 6e20 2731 2720 7468 656e 2027 when '1' then '
5927 2020 656c 7365 2027 4e27 2020 656e Y' else 'N' en
642c 2020 6361 7365 2063 6861 7228 4841 d, case char(HA
5550 5446 454e 5354 4552 2e48 415f 4755 UPTFENSTER.HA_GU
5453 4348 5249 4654 5052 494e 5445 4429 TSCHRIFTPRINTED)
2020 7768 656e 2027 3127 2074 6865 6e20 when '1' then
2759 2720 2065 6c73 6520 274e 2720 2065 'Y' else 'N' e
6e64 2c20 2063 6173 6520 2077 6865 6e20 nd, case when
4841 5550 5446 454e 5354 4552 2e48 415f HAUPTFENSTER.HA_
5245 5649 5349 4f4e 4e42 523d 2d31 2074 REVISIONNBR=-1 t
6865 6e20 2730 3027 2020 7768 656e 2048 hen '00' when H
4155 5054 4645 4e53 5445 522e 4841 5f52 AUPTFENSTER.HA_R
4556 4953 494f 4e4e 4252 3c31 3020 7468 EVISIONNBR<10 th
656e 2027 3027 7c7c 6368 6172 2848 4155 en '0'||char(HAU
5054 4645 4e53 5445 522e 4841 5f52 4556 PTFENSTER.HA_REV
4953 494f 4e4e 4252 2920 2077 6865 6e20 ISIONNBR) when
4841 5550 5446 454e 5354 4552 2e48 415f HAUPTFENSTER.HA_
5245 5649 5349 4f4e 4e42 5220 6973 206e REVISIONNBR is n
756c 6c20 7468 656e 2027 3030 2720 2065 ull then '00' e
6c73 6520 6368 6172 2848 4155 5054 4645 lse char(HAUPTFE
4e53 5445 522e 4841 5f52 4556 4953 494f NSTER.HA_REVISIO
4e4e 4252 2920 2065 6e64 2c20 2048 4155 NNBR) end, HAU
5054 4645 4e53 5445 522e 4841 5f4e 554d PTFENSTER.HA_NUM
4d45 5220 202c 434f 414c 4553 4345 2848 MER ,COALESCE(H
4155 5054 4645 4e53 5445 522e 4841 5f41 AUPTFENSTER.HA_A
5a46 4145 4c4c 4947 2c30 292b 434f 414c ZFAELLIG,0)+COAL
4553 4345 2848 4155 5054 4645 4e53 5445 ESCE(HAUPTFENSTE
522e 4841 5f52 5a46 4145 4c4c 4947 2c30 R.HA_RZFAELLIG,0
2920 202c 434f 414c 4553 4345 2848 4155 ) ,COALESCE(HAU
5054 4645 4e53 5445 522e 4841 5f41 5a46 PTFENSTER.HA_AZF
4145 4c4c 4947 2c30 292c 434f 414c 4553 AELLIG,0),COALES
4345 2848 4155 5054 4645 4e53 5445 522e CE(HAUPTFENSTER.
4841 5f52 5a46 4145 4c4c 4947 2c30 2920 HA_RZFAELLIG,0)
202c 4153 5f43 4f44 4520 202c 2873 656c ,AS_CODE ,(sel
6563 7420 7375 6d28 636f 616c 6573 6365 ect sum(coalesce
2841 435f 4841 4245 4e2c 3029 2d63 6f61 (AC_HABEN,0)-coa
6c65 7363 6528 4143 5f53 4f4c 4c2c 3029 lesce(AC_SOLL,0)
2920 6672 6f6d 2041 4343 4f55 4e54 494e ) from ACCOUNTIN
4720 7768 6572 6520 4143 5f4f 5244 4552 G where AC_ORDER
5f49 443d 4841 5550 5446 454e 5354 4552 _ID=HAUPTFENSTER
2e48 415f 5345 5129 2c20 2041 535f 434f .HA_SEQ), AS_CO
4445 2020 6672 6f6d 2020 4841 5550 5446 DE from HAUPTF
454e 5354 4552 2048 4155 5054 4645 4e53 ENSTER HAUPTFENS
5445 5220 206c 6566 7420 6f75 7465 7220 TER left outer
6a6f 696e 2052 4543 4845 4d50 4620 5245 join RECHEMPF RE
4348 454d 5046 206f 6e20 4841 5550 5446 CHEMPF on HAUPTF
454e 5354 4552 2e48 415f 5253 4551 203d ENSTER.HA_RSEQ =
2052 4543 4845 4d50 462e 525f 5345 5120 RECHEMPF.R_SEQ
206c 6566 7420 6f75 7465 7220 6a6f 696e left outer join
2041 5546 5452 4147 5353 5441 5455 5320 AUFTRAGSSTATUS
6f6e 2041 535f 5345 513d 4841 5550 5446 on AS_SEQ=HAUPTF
454e 5354 4552 2e48 415f 4153 5345 5120 ENSTER.HA_ASSEQ
2077 6865 7265 2031 3d31 2020 616e 6420 where 1=1 and
636f 616c 6573 6365 2848 4155 5054 4645 coalesce(HAUPTFE
4e53 5445 522e 4841 5f44 4f53 5349 4552 NSTER.HA_DOSSIER
5459 5045 2c30 293c 3e32 2020 616e 6420 TYPE,0)<>2 and
2048 4155 5054 4645 4e53 5445 522e 4841 HAUPTFENSTER.HA
5f46 494e 414c 4441 5445 2069 7320 6e75 _FINALDATE is nu
6c6c 2020 616e 6420 2048 4155 5054 4645 ll and HAUPTFE
4e53 5445 522e 4841 5f4d 4153 4551 3d27 NSTER.HA_MASEQ='
4c41 545a 5248 3137 3734 3631 3238 2720 LATZRH17746128'
2061 6e64 2020 4841 5550 5446 454e 5354 and HAUPTFENST
4552 2e48 415f 4d41 5345 5120 696e 2020 ER.HA_MASEQ in
2820 2073 656c 6563 7420 7232 2e52 5f53 ( select r2.R_S
4551 2066 726f 6d20 5245 4348 454d 5046 EQ from RECHEMPF
2072 3220 2077 6865 7265 2072 322e 525f r2 where r2.R_
4d41 5052 4f46 4954 4345 4e54 4552 3d27 MAPROFITCENTER='
3134 3627 2020 616e 6420 7232 2e52 5f4d 146' and r2.R_M
413d 3120 2029 2020 6f72 6465 7220 6279 A=1 ) order by
2048 4155 5054 4645 4e53 5445 522e 4841 HAUPTFENSTER.HA
5f4e 554d 4d45 5220 6465 7363 0101 0101 _NUMMER desc....
ffff ffff 6c02 0000 7468 656e 2063 6f61 l...then coa
6c65 7363 6528 2873 656c 6563 7420 6d61 lesce((select ma
7828 5343 5f41 5546 5345 5129 2066 726f x(SC_AUFSEQ) fro
6d20 5343 4849 4646 2077 6865 7265 2053 m SCHIFF where S
435f 5345 513d 4c48 4c5f 4c45 4953 5453 C_SEQ=LHL_LEISTS
4551 292c 2727 2920 7768 656e 2038 2074 EQ),'') when 8 t
6865 6e20 2727 2077 6865 6e20 3920 7468 hen '' when 9 th
656e 2063 6f61 6c65 7363 6528 2873 656c en coalesce((sel
6563 7420 ect
2006-08-07-16.56.17.281000 Instance:DB2 Node:000
PID:1312(db2syscs.exe) TID:2832 Appid:393303E7.9207.060807140852
relation_data_serv sqlrr_signal_handler Probe:10 Database:LAT
DIA7107I Die Ausfhrung der Signalverarbeitung fr eine Komponente hat
begonnen.

2006-08-07-16.56.17.296003 Instance:DB2 Node:000
PID:1312(db2syscs.exe) TID:2832 Appid:393303E7.9207.060807140852
relation_data_serv sqlrr_dump_ffdc Probe:17 Database:LAT
DIA3816C Bei der internen Verarbeitung ist ein schwerwiegender Fehler
aufgetreten.

2006-08-07-16.56.17.296004 Instance:DB2 Node:000
PID:1312(db2syscs.exe) TID:2832 Appid:393303E7.9207.060807140852
relation_data_serv sqlrr_dump_ffdc Probe:17 Database:LAT
DIA9999E Ein interner Fehler ist aufgetreten. Folgenden Fehlercode
berichten:
"0xFFFFF707".

Data Title:SQLCA PID:1312 TID:2832 Node:000
sqlcaid : SQLCA sqlcabc: 136 sqlcode: 0 sqlerrml: 0
sqlerrmc:
sqlerrp : SQL07029
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:

Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:SQLCA
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:DB2RA

Data Title:CREATOR PID:1312 TID:2832 Node:000
4e55 4c4c 4944 2020 NULLID
Data Title:PACKAGE PID:1312 TID:2832 Node:000
5351 4c4c 4630 3030 SQLLF000

Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:CREATOR
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:PACKAGE
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:REQUEST TYPE
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:APM COMMON INFO
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:PACKAGE ENTRY
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:USED_IN_UOW BIT VECTOR
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:Recursive dump_sect
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:SECTION NUMBER
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:SECTION DIR ENTRY
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:cursor name
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:cache cb

Data Title:section stmt PID:1312 TID:2832 Node:000
7365 6c65 6374 2064 6973 7469 6e63 7420 select distinct
2048 4155 5054 4645 4e53 5445 522e 4841 HAUPTFENSTER.HA
5f53 4551 2c48 4155 5054 4645 4e53 5445 _SEQ,HAUPTFENSTE
522e 4841 5f54 4558 542c 4841 5550 5446 R.HA_TEXT,HAUPTF
454e 5354 4552 2e48 415f 4e55 4d4d 4552 ENSTER.HA_NUMMER
2c48 4155 5054 4645 4e53 5445 522e 4841 ,HAUPTFENSTER.HA
5f44 4154 554d 2c48 4155 5054 4645 4e53 _DATUM,HAUPTFENS
5445 522e 4841 5f4b 5545 525a 454c 2c48 TER.HA_KUERZEL,H
4155 5054 4645 4e53 5445 522e 4841 5f52 AUPTFENSTER.HA_R
4546 2c48 4155 5054 4645 4e53 5445 522e EF,HAUPTFENSTER.
4841 5f44 4550 5a52 482c 4841 5550 5446 HA_DEPZRH,HAUPTF
454e 5354 4552 2e48 415f 4649 4e41 4c44 ENSTER.HA_FINALD
4154 452c 4841 5550 5446 454e 5354 4552 ATE,HAUPTFENSTER
2e48 415f 5245 4348 4e55 4e47 5052 494e .HA_RECHNUNGPRIN
5445 442c 4841 5550 5446 454e 5354 4552 TED,HAUPTFENSTER
2e48 415f 4755 5453 4348 5249 4654 5052 .HA_GUTSCHRIFTPR
494e 5445 442c 4841 5550 5446 454e 5354 INTED,HAUPTFENST
4552 2e48 415f 4c45 545a 5445 5245 4348 ER.HA_LETZTERECH
4755 542c 4841 5550 5446 454e 5354 4552 GUT,HAUPTFENSTER
2e48 415f 5253 4551 2c48 4155 5054 4645 .HA_RSEQ,HAUPTFE
4e53 5445 522e 4841 5f4f 5054 494f 4e44 NSTER.HA_OPTIOND
4154 452c 5245 4348 454d 5046 2e52 5f53 ATE,RECHEMPF.R_S
4551 2c52 4543 4845 4d50 462e 525f 4e41 EQ,RECHEMPF.R_NA
4d45 312c 5245 4348 454d 5046 2e52 5f56 ME1,RECHEMPF.R_V
4f52 4e41 4d45 312c 5245 4348 454d 5046 ORNAME1,RECHEMPF
2e52 5f4f 5254 2c20 2063 6173 6520 6368 .R_ORT, case ch
6172 2848 4155 5054 4645 4e53 5445 522e ar(HAUPTFENSTER.
4841 5f52 4543 484e 554e 4750 5249 4e54 HA_RECHNUNGPRINT
4544 2920 2077 6865 6e20 2731 2720 7468 ED) when '1' th
656e 2027 5927 2020 656c 7365 2027 4e27 en 'Y' else 'N'
2020 656e 642c 2020 6361 7365 2063 6861 end, case cha
7228 4841 5550 5446 454e 5354 4552 2e48 r(HAUPTFENSTER.H
415f 4755 5453 4348 5249 4654 5052 494e A_GUTSCHRIFTPRIN
5445 4429 2020 7768 656e 2027 3127 2074 TED) when '1' t
6865 6e20 2759 2720 2065 6c73 6520 274e hen 'Y' else 'N
2720 2065 6e64 2c20 2063 6173 6520 2077 ' end, case w
6865 6e20 4841 5550 5446 454e 5354 4552 hen HAUPTFENSTER
2e48 415f 5245 5649 5349 4f4e 4e42 523d .HA_REVISIONNBR=
2d31 2074 6865 6e20 2730 3027 2020 7768 -1 then '00' wh
656e 2048 4155 5054 4645 4e53 5445 522e en HAUPTFENSTER.
4841 5f52 4556 4953 494f 4e4e 4252 3c31 HA_REVISIONNBR<1
3020 7468 656e 2027 3027 7c7c 6368 6172 0 then '0'||char
2848 4155 5054 4645 4e53 5445 522e 4841 (HAUPTFENSTER.HA
5f52 4556 4953 494f 4e4e 4252 2920 2077 _REVISIONNBR) w
6865 6e20 4841 5550 5446 454e 5354 4552 hen HAUPTFENSTER
2e48 415f 5245 5649 5349 4f4e 4e42 5220 .HA_REVISIONNBR
6973 206e 756c 6c20 7468 656e 2027 3030 is null then '00
2720 2065 6c73 6520 6368 6172 2848 4155 ' else char(HAU
5054 4645 4e53 5445 522e 4841 5f52 4556 PTFENSTER.HA_REV
4953 494f 4e4e 4252 2920 2065 6e64 2c20 ISIONNBR) end,
2048 4155 5054 4645 4e53 5445 522e 4841 HAUPTFENSTER.HA
5f4e 554d 4d45 5220 202c 434f 414c 4553 _NUMMER ,COALES
4345 2848 4155 5054 4645 4e53 5445 522e CE(HAUPTFENSTER.
4841 5f41 5a46 4145 4c4c 4947 2c30 292b HA_AZFAELLIG,0)+
434f 414c 4553 4345 2848 4155 5054 4645 COALESCE(HAUPTFE
4e53 5445 522e 4841 5f52 5a46 4145 4c4c NSTER.HA_RZFAELL
4947 2c30 2920 202c 434f 414c 4553 4345 IG,0) ,COALESCE
2848 4155 5054 4645 4e53 5445 522e 4841 (HAUPTFENSTER.HA
5f41 5a46 4145 4c4c 4947 2c30 292c 434f _AZFAELLIG,0),CO
414c 4553 4345 2848 4155 5054 4645 4e53 ALESCE(HAUPTFENS
5445 522e 4841 5f52 5a46 4145 4c4c 4947 TER.HA_RZFAELLIG
2c30 2920 202c 4153 5f43 4f44 4520 202c ,0) ,AS_CODE ,
2873 656c 6563 7420 7375 6d28 636f 616c (select sum(coal
6573 6365 2841 435f 4841 4245 4e2c 3029 esce(AC_HABEN,0)
2d63 6f61 6c65 7363 6528 4143 5f53 4f4c -coalesce(AC_SOL
4c2c 3029 2920 6672 6f6d 2041 4343 4f55 L,0)) from ACCOU
4e54 494e 4720 7768 6572 6520 4143 5f4f NTING where AC_O
5244 4552 5f49 443d 4841 5550 5446 454e RDER_ID=HAUPTFEN
5354 4552 2e48 415f 5345 5129 2c20 2041 STER.HA_SEQ), A
535f 434f 4445 2020 6672 6f6d 2020 4841 S_CODE from HA
5550 5446 454e 5354 4552 2048 4155 5054 UPTFENSTER HAUPT
4645 4e53 5445 5220 206c 6566 7420 6f75 FENSTER left ou
7465 7220 6a6f 696e 2052 4543 4845 4d50 ter join RECHEMP
4620 5245 4348 454d 5046 206f 6e20 4841 F RECHEMPF on HA
5550 5446 454e 5354 4552 2e48 415f 5253 UPTFENSTER.HA_RS
4551 203d 2052 4543 4845 4d50 462e 525f EQ = RECHEMPF.R_
5345 5120 206c 6566 7420 6f75 7465 7220 SEQ left outer
6a6f 696e 2041 5546 5452 4147 5353 5441 join AUFTRAGSSTA
5455 5320 6f6e 2041 535f 5345 513d 4841 TUS on AS_SEQ=HA
5550 5446 454e 5354 4552 2e48 415f 4153 UPTFENSTER.HA_AS
5345 5120 2077 6865 7265 2031 3d31 2020 SEQ where 1=1
616e 6420 636f 616c 6573 6365 2848 4155 and coalesce(HAU
5054 4645 4e53 5445 522e 4841 5f44 4f53 PTFENSTER.HA_DOS
5349 4552 5459 5045 2c30 293c 3e32 2020 SIERTYPE,0)<>2
616e 6420 2048 4155 5054 4645 4e53 5445 and HAUPTFENSTE
522e 4841 5f46 494e 414c 4441 5445 2069 R.HA_FINALDATE i
7320 6e75 6c6c 2020 616e 6420 2048 4155 s null and HAU
5054 4645 4e53 5445 522e 4841 5f4d 4153 PTFENSTER.HA_MAS
4551 3d27 4c41 545a 5248 3137 3734 3631 EQ='LATZRH177461
3238 2720 2061 6e64 2020 4841 5550 5446 28' and HAUPTF
454e 5354 4552 2e48 415f 4d41 5345 5120 ENSTER.HA_MASEQ
696e 2020 2820 2073 656c 6563 7420 7232 in ( select r2
2e52 5f53 4551 2066 726f 6d20 5245 4348 .R_SEQ from RECH
454d 5046 2072 3220 2077 6865 7265 2072 EMPF r2 where r
322e 525f 4d41 5052 4f46 4954 4345 4e54 2.R_MAPROFITCENT
4552 3d27 3134 3627 2020 616e 6420 7232 ER='146' and r2
2e52 5f4d 413d 3120 2029 2020 6f72 6465 .R_MA=1 ) orde
7220 6279 2048 4155 5054 4645 4e53 5445 r by HAUPTFENSTE
522e 4841 5f4e 554d 4d45 5220 6465 7363 R.HA_NUMMER desc

Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:section stmt
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:sentptr
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:sentptr->sectlen
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:sentptr->cache_cb
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000
Data:sentptr->cache_cb->cached_sectptr
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000
Data:sentptr->cache_cb->cached_sectptr->thread_list
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:calculated section size
(1): not including thread list
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:calculated section
size(2): including thread structure
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:thd_table
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:thd_table->size
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:calculated section
size(3): including thread list table
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:the_section
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:Relocated section
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:Section relocated;
reltables dumped
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:section ptr
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:section size
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:dynamic ptr
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:dynamic size
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:shared dynamic ptr
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:shared dynamic size
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:dynamic section header
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:offset in section
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:opcode
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:agg_mode
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:section1
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:dynamic buffer
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:RDS AGENT CB
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:RDS APPL CB

2006-08-07-16.56.17.765001 Instance:DB2 Node:000
PID:1312(db2syscs.exe) TID:2832 Appid:393303E7.9207.060807140852
relation_data_serv sqlrr_dump_ffdc Probe:902 Database:LAT
DIA3816C Bei der internen Verarbeitung ist ein schwerwiegender Fehler
aufgetreten.

ZRC=0xFFFFF707

2006-08-07-16.56.17.781000 Instance:DB2 Node:000
PID:1312(db2syscs.exe) TID:2832 Appid:393303E7.9207.060807140852
relation_data_serv sqlrr_dump_ffdc Probe:902 Database:LAT
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:SQLE_DBCB
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:SQLD_DBCB
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:SQLD_AGENT_CB
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:SQLD_TRAN_CB

Data Title:SQLD_AGENT_CB Pointer: PID:1312 TID:2832 Node:000
30c0 3345 03E
Data Title:SQLD_AGENT_CB PID:1312 TID:2832 Node:000
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0020 0000 d09a df45 ......... ..sE
0010 0000 6060 ca44 0010 0000 3080 ce44 ....``D....0?D
0000 0000 0000 0000 0080 0000 30c0 c944 .........?..0D
0010 0000 4040 ca44 0000 0000 0000 0000 ....@@D........
Data Title:SQLD_TRAN_CB Pointer PID:1312 TID:2832 Node:000
b080 3345 ?3E
Data Title:SQLD_TRAN_CB PID:1312 TID:2832 Node:000
60c0 c72b 0000 0000 0000 0000 0000 0000 `+............
0000 0000 0000 0000 0000 0000 0000 0000 ................
0100 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 d0f0 8045 00a0 1047 ........?E. .G
2500 0000 1600 0000 0000 0000 0000 0000 %...............
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 ............
String Title:>Begin CURSOR dump: PID:1312 Node:000
OPEN PERM CURSORS: >>

String Title:<< End CURSOR dump: PID:1312 Node:000
OPEN PERM CURSORS: <<
String Title:>Begin CURSOR dump: PID:1312 Node:000
OPEN TEMP CURSORS: >>

String Title:<< End CURSOR dump: PID:1312 Node:000
OPEN TEMP CURSORS: <<
String Title:>Begin CURSOR dump: PID:1312 Node:000
CLOSED CURSORS: >>

String Title:SQLD_CCB: PID:1312 Node:000
pool(TID)=2, obj(FID)=117, indexid(IID)=0, class=0
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:SQLD_CCB

String Title:SQLD_CCB: PID:1312 Node:000
pool(TID)=2, obj(FID)=149, indexid(IID)=0, class=0
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:SQLD_CCB

String Title:SQLD_CCB: PID:1312 Node:000
pool(TID)=2, obj(FID)=82, indexid(IID)=0, class=0
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:SQLD_CCB

String Title:SQLD_CCB: PID:1312 Node:000
pool(TID)=2, obj(FID)=104, indexid(IID)=0, class=0
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:SQLD_CCB

String Title:SQLD_CCB: PID:1312 Node:000
pool(TID)=2, obj(FID)=68, indexid(IID)=0, class=0
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:SQLD_CCB

String Title:SQLD_CCB: PID:1312 Node:000
pool(TID)=2, obj(FID)=68, indexid(IID)=0, class=0
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:SQLD_CCB

String Title:SQLD_CCB: PID:1312 Node:000
pool(TID)=2, obj(FID)=154, indexid(IID)=0, class=0
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:SQLD_CCB

String Title:SQLD_CCB: PID:1312 Node:000
pool(TID)=2, obj(FID)=159, indexid(IID)=0, class=0
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:SQLD_CCB

String Title:SQLD_CCB: PID:1312 Node:000
pool(TID)=2, obj(FID)=159, indexid(IID)=0, class=0
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:SQLD_CCB

String Title:SQLD_CCB: PID:1312 Node:000
pool(TID)=2, obj(FID)=12, indexid(IID)=0, class=0
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:SQLD_CCB

String Title:SQLD_CCB: PID:1312 Node:000
pool(TID)=2, obj(FID)=104, indexid(IID)=0, class=0
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:SQLD_CCB

String Title:SQLD_CCB: PID:1312 Node:000
pool(TID)=2, obj(FID)=164, indexid(IID)=0, class=0
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:SQLD_CCB

String Title:SQLD_CCB: PID:1312 Node:000
pool(TID)=2, obj(FID)=104, indexid(IID)=0, class=0
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:SQLD_CCB

String Title:SQLD_CCB: PID:1312 Node:000
pool(TID)=2, obj(FID)=104, indexid(IID)=0, class=0
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:SQLD_CCB

String Title:SQLD_CCB: PID:1312 Node:000
pool(TID)=2, obj(FID)=125, indexid(IID)=0, class=0
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:SQLD_CCB

String Title:SQLD_CCB: PID:1312 Node:000
pool(TID)=2, obj(FID)=104, indexid(IID)=0, class=0
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:SQLD_CCB

String Title:SQLD_CCB: PID:1312 Node:000
pool(TID)=2, obj(FID)=104, indexid(IID)=0, class=0
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:SQLD_CCB

String Title:SQLD_CCB: PID:1312 Node:000
pool(TID)=2, obj(FID)=104, indexid(IID)=0, class=0
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:SQLD_CCB

String Title:SQLD_CCB: PID:1312 Node:000
pool(TID)=2, obj(FID)=90, indexid(IID)=0, class=0
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:SQLD_CCB

String Title:SQLD_CCB: PID:1312 Node:000
pool(TID)=2, obj(FID)=104, indexid(IID)=0, class=0
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:SQLD_CCB

String Title:SQLD_CCB: PID:1312 Node:000
pool(TID)=2, obj(FID)=104, indexid(IID)=0, class=0
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:SQLD_CCB

String Title:SQLD_CCB: PID:1312 Node:000
pool(TID)=2, obj(FID)=104, indexid(IID)=0, class=0
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:SQLD_CCB

String Title:SQLD_CCB: PID:1312 Node:000
pool(TID)=2, obj(FID)=90, indexid(IID)=0, class=0
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:SQLD_CCB

String Title:SQLD_CCB: PID:1312 Node:000
pool(TID)=2, obj(FID)=90, indexid(IID)=0, class=0
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:SQLD_CCB

String Title:SQLD_CCB: PID:1312 Node:000
pool(TID)=4, obj(FID)=2, indexid(IID)=0, class=128
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:SQLD_CCB

String Title:SQLD_CCB: PID:1312 Node:000
pool(TID)=4, obj(FID)=3, indexid(IID)=0, class=128
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:SQLD_CCB

String Title:SQLD_CCB: PID:1312 Node:000
pool(TID)=4, obj(FID)=3, indexid(IID)=0, class=128
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:SQLD_CCB

String Title:SQLD_CCB: PID:1312 Node:000
pool(TID)=4, obj(FID)=3, indexid(IID)=0, class=128
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:SQLD_CCB

String Title:SQLD_CCB: PID:1312 Node:000
pool(TID)=4, obj(FID)=2, indexid(IID)=0, class=128
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:SQLD_CCB

String Title:SQLD_CCB: PID:1312 Node:000
pool(TID)=4, obj(FID)=2, indexid(IID)=0, class=128
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:SQLD_CCB

String Title:SQLD_CCB: PID:1312 Node:000
pool(TID)=4, obj(FID)=2, indexid(IID)=0, class=128
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:SQLD_CCB

String Title:SQLD_CCB: PID:1312 Node:000
pool(TID)=4, obj(FID)=2, indexid(IID)=0, class=128
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:SQLD_CCB

String Title:SQLD_CCB: PID:1312 Node:000
pool(TID)=4, obj(FID)=2, indexid(IID)=0, class=128
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:SQLD_CCB

String Title:SQLD_CCB: PID:1312 Node:000
pool(TID)=4, obj(FID)=2, indexid(IID)=0, class=128
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:SQLD_CCB

String Title:SQLD_CCB: PID:1312 Node:000
pool(TID)=4, obj(FID)=2, indexid(IID)=0, class=128
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:SQLD_CCB

String Title:SQLD_CCB: PID:1312 Node:000
pool(TID)=4, obj(FID)=2, indexid(IID)=0, class=128
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:SQLD_CCB

String Title:SQLD_CCB: PID:1312 Node:000
pool(TID)=4, obj(FID)=3, indexid(IID)=0, class=128
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:SQLD_CCB

String Title:<< End CURSOR dump: PID:1312 Node:000
CLOSED CURSORS: <<

Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:SQLI_CB
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:SQLE_ACB

2006-08-07-16.56.18.359001 Instance:DB2 Node:000
PID:1312(db2syscs.exe) TID:2832 Appid:393303E7.9207.060807140852
data_protection sqlpgdmp Probe:111 Database:LAT

Active Log Buffer is dumped to: D:\DB2\NODE0000\SQL00002\LOGBUFF.DMP

Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:SQLP_ACB
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:SQLP_DBCB
Dump File:C:\PROGRA~1\SQLLIB\DB2\13122832.000 Data:SQLP_TRTBL

String Title:locklist PID:1312 Node:000
Check C:\PROGRA~1\SQLLIB\DB2\l96872.000 for additional data.

2006-08-07-16.56.18.500000 Instance:DB2 Node:000
PID:1312(db2syscs.exe) TID:2832 Appid:393303E7.9207.060807140852
relation_data_serv sqlrr_signal_handler Probe:20 Database:LAT
DIA7108I Die Ausfhrung der Signalverarbeitung fr eine Komponente ist
abgeschlossen.

2006-08-07-17.01.24.484000 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.24.500000 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.24.750000 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.24.750001 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.24.750002 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.24.750003 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.24.765000 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.24.765001 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.24.765002 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.24.781000 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.24.796000 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.24.812000 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.24.812001 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.24.812002 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.24.828000 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.24.828001 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.24.843000 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.24.843001 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.24.859000 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.24.859001 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.24.875000 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.24.875001 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.24.875002 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.24.875003 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.24.890000 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.24.890001 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.24.906000 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.24.906001 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.24.921000 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.24.937000 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.24.953000 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.24.953001 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.24.953002 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.24.968000 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.24.968001 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.24.984000 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.24.984001 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.24.984002 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.25.000000 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.25.000001 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.25.000002 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.25.000003 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.25.015000 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.25.015001 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.25.015002 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.25.015003 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.25.031000 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.25.031001 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.25.031002 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.25.046000 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.25.046001 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.25.062000 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.25.062001 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.25.062002 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.25.078000 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.25.078001 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.25.078002 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.25.078003 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.25.093000 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.25.093001 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.25.140000 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.25.140001 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.25.140002 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.25.156000 Instance:DB2 Node:000
PID:2896(javaw.exe) TID:2492 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.51.484000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.51.500000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.51.609000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.51.609001 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.51.609002 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.51.625000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.51.625001 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.51.640000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.51.671000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.51.687000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.51.703000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.51.703001 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.51.703002 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.51.703003 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.51.703004 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.51.718000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.51.718001 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.51.734000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.51.734001 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.51.750000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.51.750001 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.51.765000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.51.781000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.51.781001 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.51.812000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.51.828000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.51.828001 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.51.843000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.51.859000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.51.859001 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.51.859002 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.51.859003 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.51.875000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.51.875001 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.51.875002 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.51.890000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.51.890001 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.51.890002 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.51.906000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.51.906001 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.51.906002 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.51.921000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.51.937000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.51.937001 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.51.937002 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.51.953000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.51.953001 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.51.968000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.51.968001 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.51.968002 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.51.984000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.51.984001 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.51.984002 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.51.984003 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.52.000000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.52.000001 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.58.656000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.58.656001 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.58.687000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.58.687001 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.58.703000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.58.703001 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.58.718000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.58.718001 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.58.718002 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.58.734000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:2792 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.58.734001 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.58.750000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.58.781000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.58.781001 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.58.781002 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.58.796000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.58.796001 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.58.812000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.58.812001 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.58.812002 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.58.828000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.58.828001 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.58.843000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.58.843001 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.58.843002 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.58.859000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.58.859001 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.58.859002 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.58.875000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.58.875001 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.58.875002 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.58.875003 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.58.890000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.58.890001 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.58.890002 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.58.890003 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.58.906000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.58.906001 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.58.906002 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.58.921000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.58.921001 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.58.921002 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.58.937000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.58.937001 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.58.937002 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.58.953000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.58.953001 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.58.953002 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.58.968000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.58.968001 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.58.968002 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.58.968003 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.58.984000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.58.984001 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.59.000000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.59.000001 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.59.000002 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.59.015000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.59.031000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.59.031001 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.59.031002 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.59.046000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.59.046001 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.59.046002 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.59.062000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.59.062001 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.59.062002 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.59.062003 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.59.078000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.59.078001 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.59.078002 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.59.078003 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.59.093000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.59.093001 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.59.093002 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.01.59.093003 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.02.11.828000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.02.11.828001 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.02.11.843000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.02.11.843001 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.02.11.859000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.02.11.859001 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.02.11.875000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.02.11.906000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.02.11.937000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.02.11.953000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.02.11.984000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.02.11.984001 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.02.12.000000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.02.12.000001 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.02.12.015000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.02.12.015001 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
oper_system_services sqlo_ssem_set_close Probe:1

0000 0000 ....
2006-08-07-17.02.15.890000 Instance:DB2 Node:000
PID:192(db2syscs.exe) TID:1876 Appid:none
base_sys_utilities startdbm Probe:911

Database manager is started.

2006-08-07-17.02.19.937000 Instance:DB2 Node:000
PID:192(db2syscs.exe) TID:2768 Appid:393303E7.C007.060807150219
base_sys_utilities sqledint Probe:0 Database:LAT

Crash Recovery is needed.

2006-08-07-17.02.20.109000 Instance:DB2 Node:000
PID:192(db2syscs.exe) TID:2768 Appid:393303E7.C007.060807150219
recovery_manager sqlpresr Probe:1 Database:LAT
DIA3908W Crash recovery has been initiated. Lowtran LSN is "0001608A000C",
Minbuff LSN is "0001608A000C".

2006-08-07-17.02.20.125000 Instance:DB2 Node:000
PID:192(db2syscs.exe) TID:2768 Appid:393303E7.C007.060807150219
recovery_manager sqlprecm Probe:125 Database:LAT

Using parallel recovery with 3 agents 5 QSets 35 queues and 2 chunks
2006-08-07-17.02.21.468000 Instance:DB2 Node:000
PID:192(db2syscs.exe) TID:2104 Appid:393303D2.4F07.060807150220
base_sys_utilities sqledint Probe:0 Database:KFILIALE

Crash Recovery is needed.

2006-08-07-17.02.21.515000 Instance:DB2 Node:000
PID:192(db2syscs.exe) TID:2768 Appid:393303E7.C007.060807150219
recovery_manager sqlprecm Probe:400 Database:LAT
DIA3916W Die Forward-Phase der Wiederherstellung nach einem Systemabsturz
ist
abgeschlossen. Nchste Protokollfolgenummer (LSN): "00016090C8D4".

2006-08-07-17.02.22.000000 Instance:DB2 Node:000
PID:192(db2syscs.exe) TID:2768 Appid:393303E7.C007.060807150219
recovery_manager sqlpresr Probe:170 Database:LAT
DIA3909W Wiederherstellung nach einem Systemabsturz wurde abgeschlossen.
Nchste Protokollfolgenummer (LSN): "00016090C8D4".

2006-08-07-17.02.22.281000 Instance:DB2 Node:000
PID:192(db2syscs.exe) TID:2104 Appid:393303D2.4F07.060807150220
recovery_manager sqlpresr Probe:1 Database:KFILIALE
DIA3908W Crash recovery has been initiated. Lowtran LSN is "000298FA6AA9",
Minbuff LSN is "000298FA6AA9".

2006-08-07-17.02.22.281001 Instance:DB2 Node:000
PID:192(db2syscs.exe) TID:2104 Appid:393303D2.4F07.060807150220
recovery_manager sqlprecm Probe:125 Database:KFILIALE

Using parallel recovery with 3 agents 5 QSets 35 queues and 2 chunks
2006-08-07-17.02.26.250000 Instance:DB2 Node:000
PID:192(db2syscs.exe) TID:2104 Appid:393303D2.4F07.060807150220
recovery_manager sqlprecm Probe:400 Database:KFILIALE
DIA3916W Die Forward-Phase der Wiederherstellung nach einem Systemabsturz
ist
abgeschlossen. Nchste Protokollfolgenummer (LSN): "0002990AAB89".

2006-08-07-17.02.26.937000 Instance:DB2 Node:000
PID:192(db2syscs.exe) TID:2104 Appid:393303D2.4F07.060807150220
recovery_manager sqlpresr Probe:170 Database:KFILIALE
DIA3909W Wiederherstellung nach einem Systemabsturz wurde abgeschlossen.
Nchste Protokollfolgenummer (LSN): "0002990AAB89".

2006-08-07-17.09.22.546000 Instance:DB2 Node:000
PID:1356(javaw.exe) TID:3160 Appid:
base_sys_utilities sqle_db2ra_ar_rstdet Probe:18
DIA9999E Ein interner Fehler ist aufgetreten. Folgenden Fehlercode
berichten:
"0x 36".
Aug 7 '06 #1
Share this Question
Share on Google+
5 Replies


P: n/a
news.cyberlink.ch wrote:
Hi,

We have a DB2 version 7 fixpack 14 installed on Windows 200 at a customer
site that is crashing at regular intervals.Everything was working fine for
over many years, now since about one month, these crashes have been
cropping up. What is really strange is, the crashes occur on two DB2
different servers at the customer site, both running DB2 version 7 fixpack
14, although ater uninstalling OO-Defrag from both servers, one of the
servers 'seems' to be more stable, i.e. hasn't crashed in the last couple
of days. The other server is crashing more often now though, and the
customer is not very happy, rightly so. The only thing we can think of at
the moment that in some whay correlates to the start of the problem
occuring is, the customer, without being informed, had a new internet
connection installed by their internet provider. Most DB2 users access the
databases on the DB2 server via the internet using a DB2 runtime client.
The new internet connection pools two connections. There is a load pooling
that takes place to share the load when connecting to the main office.
Does anyone know if this could cause DB2 to crash, when queries for an
agent come via different IP routes? Perhaps we are looking in the wrong
direction. Perhaps someone could have a look at the db2diag.log below.
Analysing the log with the help of Google or the DB2 help files is feeling
like a futile crusade. Any help would be very much appreciated. I have
included all the log entrys applicable to the latest crash.

Regards

Rudolf Bargholz
2006-08-07-16.56.17.015000 Instance:DB2 Node:000
PID:1312(db2syscs.exe) TID:2832 Appid:393303E7.9207.060807140852
base_sys_utilities sqleagnt_sigsegvh Probe:10 Database:LAT

Error in agent servicing application with coor_node:0000
..
You are running into a segmentation violation in the DB2 engine. If you
also have a file named t<xxxxx>.<yyyin your dump directory, that could be
helpful as well. Can you post it here?

If you don't have an extended support contract with IBM, I very much doubt
that you can resolve your problem easily. V7 is out of servic for almost a
year now. So you may want to consider moving to V8 or ever V9.
--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Aug 7 '06 #2

P: n/a
Hi Knut,

Thanks for looking into this.

I was not able to find a file created today that begins with a "t". Three
files were created in the DB2 directory at the time of the crash:

l96872.000
DB131228.TRP
13122832.000

"Knut Stolze" <st****@de.ibm.comschrieb im Newsbeitrag
news:<eb**********@lc03.rz.uni-jena.de>...
news.cyberlink.ch wrote:
Hi,

We have a DB2 version 7 fixpack 14 installed on Windows 200 at a
customer
site that is crashing at regular intervals.Everything was working fine
for
over many years, now since about one month, these crashes have been
cropping up. What is really strange is, the crashes occur on two DB2
different servers at the customer site, both running DB2 version 7
fixpack
14, although ater uninstalling OO-Defrag from both servers, one of the
servers 'seems' to be more stable, i.e. hasn't crashed in the last
couple
of days. The other server is crashing more often now though, and the
customer is not very happy, rightly so. The only thing we can think of
at
the moment that in some whay correlates to the start of the problem
occuring is, the customer, without being informed, had a new internet
connection installed by their internet provider. Most DB2 users access
the
databases on the DB2 server via the internet using a DB2 runtime client.
The new internet connection pools two connections. There is a load
pooling
that takes place to share the load when connecting to the main office.
Does anyone know if this could cause DB2 to crash, when queries for an
agent come via different IP routes? Perhaps we are looking in the wrong
direction. Perhaps someone could have a look at the db2diag.log below.
Analysing the log with the help of Google or the DB2 help files is
feeling
like a futile crusade. Any help would be very much appreciated. I have
included all the log entrys applicable to the latest crash.

Regards

Rudolf Bargholz
2006-08-07-16.56.17.015000 Instance:DB2 Node:000
PID:1312(db2syscs.exe) TID:2832 Appid:393303E7.9207.060807140852
base_sys_utilities sqleagnt_sigsegvh Probe:10 Database:LAT

Error in agent servicing application with coor_node:0000
..

You are running into a segmentation violation in the DB2 engine. If you
also have a file named t<xxxxx>.<yyyin your dump directory, that could
be
helpful as well. Can you post it here?

If you don't have an extended support contract with IBM, I very much doubt
that you can resolve your problem easily. V7 is out of servic for almost a
year now. So you may want to consider moving to V8 or ever V9.
--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Find the files below. I have included the "l96872.000" and "DB131228.TRP"
files in their entirity, but the third file "13122832.000" is 187kB. I have
only included the first few lines of this file.
Hope this gives you a little more data.

Would it help if I saved the databases using db2move, uninstalled DB2 and
recreated all the databases from scratch again?

Regards

Rudolf Bargholz

------------------------------------------------------------------------------------
--------l96872.000
------------------------------------------------------------------------------------
DB2/CS Lock List Formatter
Version 8.1
IBM Toronto Laboratory
------------------------------------------------------------------------------------
Run Timestamp: 08/07/2006 16:56:18
================================================== ==================================
HDR - Location of the Lock Header
LRB - Location of the Lock Request Block
Lock Modes - ...: None .IN: Intent None
..IS: Intent Share ..S: Share
..IX: Intent Exclusive SIX: Share with Intent Exclusive
..NS: Next Key Share NX: Next Key Exclusive
...U: Update ..X: Exclusive
...Z: Super Exclusive ..W: Weak Exclusive
..NW: Next Weak Exclusive
Lock States - F: Free H: Header
D: Deadlock Victim L: LRB
Lock Status - C: Converting G: Granted W: Waiting
Lock Durations - 0: Instant 1-254: Medium
255: Long
Transaction Wait Flags - C: Converting G: Granted
*: Not Waiting W: Waiting
Transaction States - F: Free R: Read W: Write
C: Commit A: Abort 1: Save1
2: Save2 3: Save3 4: Save4
P: Prepare X: Heur Commit Y: Heur Abort
Z: Huer Aborting U: Forget T: Repair
CMode - Conversion Mode
CDur - Conversion Duration
================================================== ==================================
>>Database Name: LAT
Lock Chain
Dump -------------------------------------------------------------------
HDR=2B18138C HashIndex=505 LockName=08251C1CF6F2D3D3301BE9E841
GroupMode=..S type=PACKAGE: id={471606536,3553882870,3907590960}, loading =
0
LRB State Status Mode Dur CMode CDur TranHandle HoldCount CursorBitmap
AppHandle
-------- ----- ------ ---- --- ----- ---- ---------- --------- ------------
--------
2B180EC4 L G ..S 1 ... 0 3 0 40000000 0-26

HDR=2B181E18 HashIndex=1727 LockName=04000000010000000100F30056
GroupMode=..S type=VARIATION: anchor,stmt,env,var={243,4,1,1}; loading = 0
LRB State Status Mode Dur CMode CDur TranHandle HoldCount CursorBitmap
AppHandle
-------- ----- ------ ---- --- ----- ---- ---------- --------- ------------
--------
2B181F5C L G ..S 1 ... 0 3 0 40000000 0-26

Number of Lock Request Blocks = 2
Transaction Chain
Dump -----------------------------------------------------------------
Transaction 3 Transptr=2B169518 Handle=3 State=1 ProcessID=1312
TID=0000000B8286 GXID= AppHandle= 0-26
NumLRBs=3 (info only, does not reflect # locks held by the transaction in
V3)
Locks Held by Transaction 3:
LRB Header Lock Name S ST Mod Dur CMod CDur Next LRB HldCt CurBits
-------- -------- -------------------------- - -- --- --- ---- ---- --------
----- -------
Locks under chain[0] : 2
2B181F5C 2B181E18 04000000010000000100F30056 L G ..S 1 ... 0 00000000 0
40000000
2B180EC4 2B18138C 08251C1CF6F2D3D3301BE9E841 L G ..S 1 ... 0 00000000 0
40000000
Transaction 3 Transptr=2B169518

Number of Transactions = 1
************************************************** ****
Statistics of the LOCK MANAGER
************************************************** ****
Max # of Transactions Requesting a Single Lock = 1 ,
For Lock 08251C1CF6F2D3D3301BE9E841
Max # of Locks Requested by a single Transaction = 2 , By Transaction = 3
Total number of waiting LRBs = 0
Median average of headers per hash table entry = 1.000000
************************************************** *******
************************************************** *******

------------------------------------------------------------------------------------
--------DB131228.TRP
------------------------------------------------------------------------------------
y7m ?   6Bcl FE?   6Bcl FE# ??
k_-? Xu#? OEᧁ 8
@ E-@ ?
@ 3@ 8 # # /E -D-DFEy7m F ԮFE#   6Bcl FE# ? ??
k_-? Xu#? OEᧁ 8
@ E-@ ?
@ 3@ % 6         f  H P '93       @,
$]$] RB % 6 .t`L   `1 H A3t w % x It(Jt
6 & ? p Al BBl >{C:\PROGRA~1\SQLLIB\bin\DB2ABIND.dll
  @-ܧFEExFE 4x_ tx Txvl    K x<FEj
xx>xFE=CxFE @  FEFE FET xX@_ LFE% x xxxFEFE
FExxFE@FEj x *l ]<l >{C:\PROGRA~1\SQLLIB\bin\DB2APP.dll
l
  @-ܧFEExFE 4x_ tx Txvl    K x<FEj
xx>xFE=CxFE @  FEFE FET xX@_ LFE% x xxxFEFE
FExxFE@FEj x l p"l j{C:\PROGRA~1\SQLLIB\bin\DB2CLI.dll
l
  @-ܧFEExFE 4x_ tx Txvl    K x<FEj
xx>xFE=CxFE @  FEFE FET xX@_ LFE% x xxxFEFE
FExxFE@FEj x l Sm
`{C:\PROGRA~1\SQLLIB\bin\DB2ENGN.dll
  @-ܧFEExFE 4x_ tx Txvl    K x<FEj
xx>xFE=CxFE @  FEFE FET xX@_ LFE% x xxxFEFE
FExxFE@FEj x  * B"{C:\PROGRA~1\SQLLIB\bin\DB2SQLIN.dll
  @-ܧFEExFE 4x_ tx Txvl    K x<FEj
xx>xFE=CxFE @  FEFE FET xX@_ LFE% x xxxFEFE
FExxFE@FEj x zl l
M{C:\PROGRA~1\SQLLIB\bin\DB2SQN.dll l
  @-ܧFEExFE 4x_ tx Txvl    K x<FEj
xx>xFE=CxFE @  FEFE FET xX@_ LFE% x xxxFEFE
FExxFE@FEj x \l ?0\l {C:\PROGRA~1\SQLLIB\bin\DB2SYS.dll
l
  @-ܧFEExFE 4x_ tx Txvl    K x<FEj
xx>xFE=CxFE @  FEFE FET xX@_ LFE% x xxxFEFE
FExxFE@FEj x  p? 
W{C:\PROGRA~1\SQLLIB\bin\DB2SYSP.dll
  @-ܧFEExFE 4x_ tx Txvl    K x<FEj
xx>xFE=CxFE @  FEFE FET xX@_ LFE% x xxxFEFE
FExxFE@FEj x 'm .'m
`{C:\PROGRA~1\SQLLIB\bin\DB2TCP.dll
  @-ܧFEExFE 4x_ tx Txvl    K x<FEj
xx>xFE=CxFE @  FEFE FET xX@_ LFE% x xxxFEFE
FExxFE@FEj x "m K"m
`{C:\PROGRA~1\SQLLIB\bin\db2tcpl.DLL
  @-ܧFEExFE 4x_ tx Txvl    K x<FEj
xx>xFE=CxFE @  FEFE FET xX@_ LFE% x xxxFEFE
FExxFE@FEj x Ol PWl
{C:\PROGRA~1\SQLLIB\bin\DB2UTIL.dll
  @-ܧFEExFE 4x_ tx Txvl    K x<FEj
xx>xFE=CxFE @  FEFE FET xX@_ LFE% x xxxFEFE
FExxFE@FEj x rm rm
`{C:\PROGRA~1\SQLLIB\bin\DB2WINT.dll
  @-ܧFEExFE 4x_ tx Txvl    K x<FEj
xx>xFE=CxFE @  FEFE FET xX@_ LFE% x xxxFEFE
FExxFE@FEj x sm! @tm
`{C:\PROGRA~1\SQLLIB\bin\DB2SUBA.dll
  @-ܧFEExFE 4x_ tx Txvl    K x<FEj
xx>xFE=CxFE @  FEFE FET xX@_ LFE% x xxxFEFE
FExxFE@FEj x # `
 {C:\PROGRA~1\SQLLIB\bin\db2pdbcf.DLL
  @-ܧFEExFE 4x_ tx Txvl    K x<FEj
xx>xFE=CxFE @  FEFE FET xX@_ LFE% x xxxFEFE
FExxFE@FEj x , & Z{C:\PROGRA~1\SQLLIB\bin\DB2NP.dll
LL
  @-ܧFEExFE 4x_ tx Txvl    K x<FEj
xx>xFE=CxFE @  FEFE FET xX@_ LFE% x xxxFEFE
FExxFE@FEj x - l Z{C:\PROGRA~1\SQLLIB\bin\db2npl.DLL
L
  @-ܧFEExFE 4x_ tx Txvl    K x<FEj
xx>xFE=CxFE @  FEFE FET xX@_ LFE% x xxxFEFE
FExxFE@FEj x zm0 J}m
`{C:\PROGRA~1\SQLLIB\bin\DB2DLNK.dll
  @-ܧFEExFE 4x_ tx Txvl    K x<FEj
xx>xFE=CxFE @  FEFE FET xX@_ LFE% x xxxFEFE
FExxFE@FEj x +2 O+
o{C:\PROGRA~1\SQLLIB\bin\db2sqnx.dll
  @-ܧFEExFE 4x_ tx Txvl    K x<FEj
xx>xFE=CxFE @  FEFE FET xX@_ LFE% x xxxFEFE
FExxFE@FEj x 3 a{C:\PROGRA~1\SQLLIB\bin\db2licm.DLL 
y7m    8  ?  @ C:\PROGRA~1\SQLLIB\bin\db2syscs.exe
  @-ܧFEExFE 4x_ tx Txvl    K x<FEj
xx>xFE=CxFE @  FEFE FET xX@_ LFE% x xxxFEFE
FExxFE@FEj x  4  0{C:\PROGRA~1\SQLLIB\bin\DB2QG.dll
L
  @-ܧFEExFE 4x_ tx Txvl    K x<FEj
xx>xFE=CxFE @  FEFE FET xX@_ LFE% x xxxFEFE
FExxFE@FEj xm<S< ?U?E.. <f <P?EJ?U<P"
B<Mff?B$FE
3m/El p lFE
Mm/E"Dp" ܯFEDNm/E/E< "DdFE7Nm>'E/E(  dFE,l(  < "D
dFEzl< "D|l tFEi!l< "DG'E\/E,FE}l< "D\/ElLFESl<
"D\/ElhFE8l< "DlxFEFEKl0@'E< "D lxFEDl0@'E< "D
FE4l0@'E< "DFE?FE5l0@'E< "D FEYl Yl FE]lXFE H
FE^W|H h 6 P]lH H /E  $"DL=]l0?3E|"D-D ` $FE
3m/El p B-E(FE,'allFE
Mm/E"Dp" " (FE ԯFE   tFE v-Ep3EB-E/E` ܯFEDNm/E/E<
"DtFE(FE"E /EFE E FEhMm/E̯FEP(  /E" ? /E(   l
"DdFE7Nm>'E/E(  FEB-Ep3ElFENULLID  SQLLF000 < "D@/E |FE N)m 
 FEz&m@D "D E4FEHC-E~(mE B-E p3E"E /EE /E
X?B8lFEL-m
-m/E@D  FE /EV @D  FE? dFEYJ;m"E FED NULLID 
SQLLF0000@+ lFE $"D /E QLR /E(  . |FE,FE.+Nm ,FE-Nm  FE
NULLID  SQLLF000  FE $"DF000  ԲFE "D SQLROUTINE_SAVEPOINT
SQLROUTINE_SAVEPOINT  @/E tFEGNm < "D@/E
NULLID  SQLLF000  |FE "D SQLROUTINE_SAVEPOINT fu ,FEHia 6 Hia OFE
P  OFEKt 6 ,FEHia PA'E > 6 XFEFEFEtLtFEu
ȿFE%uHia ,FE FE,.'m ȿFEؿFE  /E  P(  >'E  p" ?^3E,3E 
lx'E@/E x'E uNm<FEwl? fu ,FEHia 6 Hia FE P  FEKt 6
,FEHia PA'E > 6 ?FEFEFEtLtFEu FE%uHia ,FE
FE,.'m FE FE  /E /E P(  p3E >'E  p" ?^3E,3EB-E ?  <
"D(  uNmdFE,l(  < "D ? " P( ,FEHia 6 Hia FE  FEKt 6
,FEHia PA'EFE> 6 ?x'E y'E?  @FE4FE]|al`# @/E0@'E/
@/E@/E@/E>'E?  FE(   P( dFEzl< "D|l "D p"
?^3E,3EB-E l< "D@/E < "D(  uNmFEwl? < "D ? 0#  "DP( LCA ^
SQL07029 @/E0@'E @/E@/E@/E>'E?  FE(  FE"alFEzl< "D|l
"D p"al`# ?x'E? $.alx'E
tFE?x'E 0# 0@'E
@/E@/E@/E>'E?  hFE FE \/E G'E 'E
0A'E0@'E@/E@/E>'E^#ltFEi!l< "DG'E\/E< "D SQL07029 ?
/E,FE]|al`# @FE }alO
XFE|"D \/E @'EFE}l< "D\/E 0@'E ? ?x'E FE \/E x'EG'E`#
0A'E0@'E@/E@/E>'E FEi!l< "DG'E\/E< "D SQL07029 O
@'E^#lDFE!lx'EG'E\/E< "D @/E>'E FEFE \/ESQL0,FE}l<
"D\/El< "DXFE FEFE \/E "FE}l< "D FE|"D \/E  "D\/E
0@'E FE LFESl< "D\/El< "DXFE SQLCA ^ FE @ \/ESQL0|FE}l<
"D\/E < "DT+ < "D@/E FE \/E FE}l< DPFEFE A \/E\/EFE}l<
"D\/E< "D< "DG'E0@'E@/E@/E>'EFEFETloFESl< "D\/E <
"DT+Sl< "D\/E < "D@/E\/E lFE>'E FE FESl< D\/E < D FE
FEFESl< "D\/E< "D< "DG'E< "D>'E FE |FESl< "D\/E lFE>'E
>'E FE   \/E   p  0 "D 0 5l "D\/EOFETvl0
"D\/EFEWm>FE  FEFE=Sl0 "D\/EFEWm>FE
G8A \F  FEfsal@ B h @ & s
G\"D
s
G HFE"al s
G# # OFEFEp"al\"D s
G & @
G@"D0@'EL# al> t#   s
G
G   X FE>al0@'E
G|"D  "D 0@'E    @
G FEls
Gl , s
G FEL=]l 'E  HFE$l0@'EL#  l< "D l@"DXFEfsal   X"D\"D
FE"alP"DsG# (FEp"alsGP"D "D@"D0@'EL# FE  t# X"D\"D FE
"alP"D@ PF     @FE-al  @+ l0@'E"D s+ P"D
FE@/E>'EhFE8l< "DlxFEXFE?JlFEKl0@'E< "D lFE< "D t#
FE~al# Y FEFE,"D< "DY FE  FE @+SQLCA ^ SQL07029  4
00000T+ ? 0@0E  FE FE FE 0@'E  0@'E 0@+FE?<l0@'E< "D@/El
"D"D  "Dl @+ FE@0E0A'E >'E HFEFE xFEDl0@'E< "D  "D
FEFE @Bl4lFE>'EMl 0@+Y 0@+ @0 <"D  4  0@'E0@'E
FE4l0@'E< "DFE ?@? Tw$ FEFE  @zW|FE8u@u L
PFEgwFEm uu8uFE u FEFEFE ?'E ?'E? ? ?
"FE]|al^4/E ~FE }al   G'E ?'E &E FEFE]|al`#
FE }alA'EPA'EA'Erder uest I G'E0# @'E @zW| .u@uFExFE FELFE

,w a a
$FE a ia xa www{' -a ?F'EFE FETY| ?F'E
A'EFE+l" +l   FERTY|xa xa @a 0rm0rm~FEk'm lF'E 
WinSock 2.0 "FE x2 FE?FE H b xFFEFE x2 FEFE  b xFE
FEFE"D"D39
,w _ _ f_ xFE hFEd~wH1wxFEw _ 0e_ tIDtID  pia {'
pia hia ha FE-a FET\| "W|FEupia u?ia pia -u {'
pia FEq u upia -a nu-a yt FE  oFE Hia  > FE
HFEFE |FEFEFEtPt(FEbu FE 0FE kuHia 0@0E
0@0Epia XFEL3'm 0@0E 8FE?FEPA'E ?F'E ^FE$'lPA'E?FE0@'EFE 0@'EFE
FEl~FElPA'E0@0E 8FEy FE?FE FEWm@ FE8xFE 'mFE"D"D"DB
"D0123456789AB`FE['m"D'm@FELFEFEeWm"DPA'E060807140852 '93
393303E7 9207 ?F'E Wm@ Rl'mC A .  .  jlFE>~al ?
D\"D, D FE>D    D FE,'al\"D= D >D?  t#
@FE~al# = TFE\FE FE = Dt# D Y| ^FE  >'E  
fw FEL,W| hG'E?cX|FEY|^FE ]l FE hG'E FET\|?-W|  
Q]l FE< "D0@'E  "D < "D  pFEFEFEuplpFE< "D WmFEZflFE
?@? 8'm 0 "D ?F'E 8'm @ ,FE?FEPA'E  FE'alX"D "D 
@A'E  0# FE]|al# 
FEFE\FE ?@? DD@
A "Dt# "D8@ h h 8@ pFEal
A PZ I al D D T @ D 4 ?@? ^FEp "Dx "D F'Ep "D0 ( 
@/E?FE? < "D * >'E FE ?@?FE
..l0@'E\FE?FE5l0@'E< "D ? @/E \FE
,w e x e 4FE e 0@'E0A'E< "D PA'E0@0E 0 "D  Z @   t"ow >w ?FE >w rm
rm tFERw e @(e   SQLCA ^ SQL07029  4 00000 ?
FE/wtt t  :wHwR:w0FE 6 H  FE( d~w?4/E?'E
?
@ ?
@ xFE,'al<E @3/E@ ?4/E? ?
@ ~FE]|al<E@ FE }al $ h T^ @3/E .E &E 8 # h 6 H (


------------------------------------------------------------------------------------
--------13122832.000
------------------------------------------------------------------------------------
26~2006-08-07-16.56.17.3120008~4494F07C5~SQLCA136~SQLCA ^ SQL07029
26~2006-08-07-16.56.17.3120028~4494003C5~DB2RA128~SQLDB2RA   ^ ?|"D  @
 @"D  @"D  @"D  @"D  @$"D 
"E26~2006-08-07-16.56.17.3280008~4533C6B47~CREATOR8~NULLID
26~2006-08-07-16.56.17.3280018~4533C6D27~PACKAGE8~SQLLF00026~200 6-08-07-16.56.17.3430018~452F10C812~REQUEST
TYPE4~ 26~2006-08-07-16.56.17.3590008~4546A87C15~APM COMMON INFO284~

 SQL07029 DB2 v7.1.0.103 n050404 WR21345 NT      8    n? 
  Z )   26~2006-08-07-16.56.17.3590028~4533C57013~PACKAGE
ENTRY496~3E t3E`4=8p3E g g *HD 

  A A %0A    @ NULLID SQLLF000hADcQaDPYNN ADMINISTRATOR
( V ( V NYNND3B0N DDDDDD1 ADMINISTRATOR
BCR U 26~2006-08-07-16.56.17.3750008~4533C77022~USED_IN_UOW BIT VECTOR12~
26~2006-08-07-16.56.17.3900008~4546AA3419~Recursive dump_sect4~
26~2006-08-07-16.56.17.3900018~4533C89814~SECTION NUMBER2~
26~2006-08-07-16.56.17.4060008~4533C87017~SECTION DIR ENTRY56~ 3E ?i-E@D
tDB-E0 .    26~2006-08-07-16.56.17.4060018~4533D61511~cursor
name7~SQLCUR426~2006-08-07-16.56.17.4210008~452D42B08~cache
cb160~E1"E"E  
*HD         V     @ Y 
26~2006-08-07-16.56.17.4840008~452D698012~section stmt1584~select distinct
HAUPTFENSTER.HA_SEQ,HAUPTFENSTER.HA_TEXT,HAUPTFENS TER.HA_NUMMER,HAUPTFENSTER.HA_DATUM,HAUPTFENSTER.H A_KUERZEL,HAUPTFENSTER.HA_REF,HAUPTFENSTER.HA_DEPZ RH,HAUPTFENSTER.HA_FINALDATE,HAUPTFENSTER.HA_RECHN UNGPRINTED,HAUPTFENSTER.HA_GUTSCHRIFTPRINTED,HAUPT FENSTER.HA_LETZTERECHGUT,HAUPTFENSTER.HA_RSEQ,HAUP TFENSTER.HA_OPTIONDATE,RECHEMPF.R_SEQ,RECHEMPF.R_N AME1,RECHEMPF.R_VORNAME1,RECHEMPF.R_ORT,
case char(HAUPTFENSTER.HA_RECHNUNGPRINTED) when '1' then 'Y' else 'N' end,
case char(HAUPTFENSTER.HA_GUTSCHRIFTPRINTED) when '1' then 'Y' else 'N' end,
case when HAUPTFENSTER.HA_REVISIONNBR=-1 then '00' when
HAUPTFENSTER.HA_REVISIONNBR<10 then '0'||char(HAUPTFENSTER.HA_REVISIONNBR)
when HAUPTFENSTER.HA_REVISIONNBR is null then '00' else
char(HAUPTFENSTER.HA_REVISIONNBR) end, HAUPTFENSTER.HA_NUMMER
,COALESCE(HAUPTFENSTER.HA_AZFAELLIG,0)+COALESCE(HA UPTFENSTER.HA_RZFAELLIG,0)
,COALESCE(HAUPTFENSTER.HA_AZFAELLIG,0),COALESCE(HA UPTFENSTER.HA_RZFAELLIG,0)
,AS_CODE ,(select sum(coalesce(AC_HABEN,0)-coalesce(AC_SOLL,0)) from
ACCOUNTING where AC_ORDER_ID=HAUPTFENSTER.HA_SEQ), AS_CODE from HAUPTFENSTER
HAUPTFENSTER left outer join RECHEMPF RECHEMPF on HAUPTFENSTER.HA_RSEQ =
RECHEMPF.R_SEQ left outer join AUFTRAGSSTATUS on
AS_SEQ=HAUPTFENSTER.HA_ASSEQ where 1=1 and
coalesce(HAUPTFENSTER.HA_DOSSIERTYPE,0)<>2 and HAUPTFENSTER.HA_FINALDATE is
null and HAUPTFENSTER.HA_MASEQ='LATZRH17746128' and HAUPTFENSTER.HA_MASEQ in
( select r2.R_SEQ from RECHEMPF r2 where r2.R_MAPROFITCENTER='146' and
r2.R_MA=1 ) order by HAUPTFENSTER.HA_NUMMER
desc26~2006-08-07-16.56.17.4840018~4546AA307~sentptr4~p3E26~2006-08-07-16.56.17.5000008~4533C89016~sentptr->sectlen4~.
26~2006-08-07-16.56.17.5150008~4533C88817~sentptr->cache_cb4~B-E26~2006-08-07-16.56.17.5150018~452D42B433~sentptr->cache_cb->cached_sectptr4~126~2006-08-07-16.56.17.5310008~31C11B3446~sentptr->cache_cb->cached_sectptr->thread_list4~9
26~2006-08-07-16.56.17.5460008~4546A9A854~calculated section size (1): not
including thread list4~9
26~2006-08-07-16.56.17.5460018~4546A9A854~calculated section size(2):
including thread structure4~9
26~2006-08-07-16.56.17.5620008~4546A9AC9~thd_table4~hT126~2006-08-07-16.56.17.5620018~31C1546815~thd_table->size4~
26~2006-08-07-16.56.17.5780008~4546A9A855~calculated section size(3):
including thread list table4~
:
26~2006-08-07-16.56.17.5930008~4546A9A411~the_section4~0+26~20 06-08-07-16.56.17.5930018~4546A99817~Relocated
section4~ 26~2006-08-07-16.56.17.6090008~4546A99C35~Section relocated;
reltables dumped4~ 26~2006-08-07-16.56.17.6250008~4533C88011~section
ptr4~@D26~2006-08-07-16.56.17.6250018~4546A9A012~section size4~
: 26~2006-08-07-16.56.17.6400008~44CE906011~dynamic
ptr4~o-E26~2006-08-07-16.56.17.6560008~44CE90BC12~dynamic size4~f
26~2006-08-07-16.56.17.6560018~44CE909418~shared dynamic ptr4~
26~2006-08-07-16.56.17.6710008~44CE90C019~shared dynamic size4~
26~2006-08-07-16.56.17.6710018~45DFBE1022~dynamic section header192~  @
26~2006-08-07-16.56.17.6870008~4546A87817~offset in section4~^
26~2006-08-07-16.56.17.7030008~4546A8746~opcode4~6
26~2006-08-07-16.56.17.7030018~452F110C8~agg_mode2~
26~2006-08-07-16.56.17.7180008~2BCCC0308~section114860~n050404
~DDo-E"D D"DDجD\~D hDE . `7 9 P7 ~9 9 f 9  4 
 N ?'D"DD  CNST 'D CNST 'D CNST 'D CNST 'D CNST
0'D CNST H'D CNST `'D
 CNST x'D 0 CNST 'D
 CNST 'D 00  CNST 'D "DCNST  'D 1 CNST 'D
N p3ECNST "D Y CNST "D 146 CNST 8"D LATZRH17746128
CNST X"D CNST p"D  CNST ^"D  3E0,m  -D0-D TAO2 x"D
 ?"D
  H"D .D .D "D~D~D o.Do-E    
   DB2ADMINACCOUNTING CLBL "D   o-E     o-E    
   DMSVo"D"D"D DVAL "D       -D$,m
....
There is a lot more. Does it make sense to post all the data?
Aug 7 '06 #3

P: n/a
news.swissonline.ch wrote:
Hi Knut,

Thanks for looking into this.

I was not able to find a file created today that begins with a "t". Three
files were created in the DB2 directory at the time of the crash:

l96872.000
DB131228.TRP
13122832.000
Find the files below. I have included the "l96872.000" and "DB131228.TRP"
files in their entirity, but the third file "13122832.000" is 187kB. I
have only included the first few lines of this file.
Hope this gives you a little more data.

Would it help if I saved the databases using db2move, uninstalled DB2 and
recreated all the databases from scratch again?
This may help, may not...
------------------------------------------------------------------------------------
--------l96872.000
------------------------------------------------------------------------------------
DB2/CS Lock List Formatter
Version 8.1
IBM Toronto Laboratory
------------------------------------------------------------------------------------
Are you sure that you're running DB2 V7? I'm asking because the output
says "8.1" here. Run "db2level" on the command line and verify that this
is a V7 system.
------------------------------------------------------------------------------------
--------DB131228.TRP
------------------------------------------------------------------------------------
That is a binary file and probably the most interesting one of the three. I
believe there is a tool to format Windows trap files. But I don't know
which tool that is...

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Aug 7 '06 #4

P: n/a
Hi Knut,

"Knut Stolze" <st****@de.ibm.comschrieb im Newsbeitrag
news:eb**********@lc03.rz.uni-jena.de...
news.swissonline.ch wrote:
>Hi Knut,

Thanks for looking into this.

I was not able to find a file created today that begins with a "t". Three
files were created in the DB2 directory at the time of the crash:

l96872.000
DB131228.TRP
13122832.000
Find the files below. I have included the "l96872.000" and "DB131228.TRP"
files in their entirity, but the third file "13122832.000" is 187kB. I
have only included the first few lines of this file.
Hope this gives you a little more data.

Would it help if I saved the databases using db2move, uninstalled DB2 and
recreated all the databases from scratch again?

This may help, may not...
>------------------------------------------------------------------------------------
--------l96872.000
------------------------------------------------------------------------------------
DB2/CS Lock List Formatter
Version 8.1
IBM Toronto Laboratory
------------------------------------------------------------------------------------

Are you sure that you're running DB2 V7? I'm asking because the output
says "8.1" here. Run "db2level" on the command line and verify that this
is a V7 system.
This is the result of the db2level:

DB21085I Instance "DB2" uses DB2 code release "SQL07029" with level
identifier

"030A0105" and informational tokens "DB2 v7.1.0.111", "n050516" and
"WR21354".
>
>------------------------------------------------------------------------------------
--------DB131228.TRP
------------------------------------------------------------------------------------

That is a binary file and probably the most interesting one of the three.
I
believe there is a tool to format Windows trap files. But I don't know
which tool that is...
Thanks, I will try to find such tool.
>
--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Regards

Rudolf Bargholz
Aug 7 '06 #5

P: n/a
Hi Knut,
>>>
Would it help if I saved the databases using db2move, uninstalled DB2
and
recreated all the databases from scratch again?

This may help, may not...
Will try this this evening.
>>------------------------------------------------------------------------------------
--------DB131228.TRP
------------------------------------------------------------------------------------

That is a binary file and probably the most interesting one of the three.
I
believe there is a tool to format Windows trap files. But I don't know
which tool that is...

Thanks, I will try to find such tool.
I have found db2xprt as of DB2 version 8 fixpack 8 . We have a DB2 version 8
and DB2 version 9 installation in the office. I will try to parse the
version 7 file using db2xprt when I am in the office.

Regards

Rudolf Bargholz
Aug 8 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.