Hello All,
How do I get the actual tablename from the "onlog -l -n <logical log number>" output ?
The INFORMIXSERVER went into a long transaction state and was hung. When we restarted it, again it went into a long transaction state and had to be restarted. We have found out that there is a lot of "ADDITEM" mentioned in the output of all the logical log records and the transaction id is 248. "ADDITEM" adds index entries and therefore we suspect that someone had made a heavy insert into a particular table due to which the index records were also generated. Therefore we wanted to get the tablename from the "onlog output. Following is the first few page output of "onlog -l -n 424".
> cat /tmp/424.log | more
IBM Informix Dynamic Server Logical Log display
Copyright IBM Corporation 1996, 2004 All rights reserved.
(c) Copyright HCL Technologies Ltd. 2018. All rights reserved.
log uniqid: 424.
addr len type xid id link
18 72 ADDITEM 248 1 31ff75c 401f6e 401f6d 72e11e 29772 1 12
48000000 01001c00 10000000 00000000 H....... ........
00000000 00000000 f8000000 5cf71f03 ........ ....\...
d24dc32c 6e1f4000 6e1f4000 6d1f4000 .M.,n.@. n.@.m.@.
1ee17200 4c740000 01000c00 56454e20 ..r.Lt.. ....VEN
800012fa 8000a9f8 ........
60 64 ADDITEM 248 0 18 50003d 401f6d 72e11e 4632 1 4
40000000 00001c00 10000000 00000000 @....... ........
00000000 00000000 f8000000 18000000 ........ ........
d34dc32c 3d005000 3d005000 6d1f4000 .M.,=.P. =.P.m.@.
1ee17200 18120000 01000400 8000a9f8 ..r..... ........
a0 68 ADDITEM 248 0 60 50003e 401f6d 72e11e 24570 1 8
44000000 00001c00 10000000 00000000 D....... ........
00000000 00000000 f8000000 60000000 ........ ....`...
d44dc32c 3e005000 3e005000 6d1f4000 .M.,>.P. >.P.m.@.
1ee17200 fa5f0000 01000800 800012fa ..r.._.. ........
8000a9f8 ....
e4 72 ADDITEM 248 0 a0 50003f 401f6d 72e11e 28372 1 10
48000000 00001c00 10000000 00000000 H....... ........
00000000 00000000 f8000000 a0000000 ........ ........
d54dc32c 3f005000 3f005000 6d1f4000 .M.,?.P. ?.P.m.@.
1ee17200 d46e0000 01000a00 800012fa ..r..n.. ........
8000a9f8 5020a9f8 ....P ..
addr len type xid id link
12c 64 ADDITEM 248 0 e4 500040 401f6d 72e11e 2163 1 4
40000000 00001c00 10000000 00000000 @....... ........
00000000 00000000 f8000000 e4000000 ........ ........
d64dc32c 40005000 40005000 6d1f4000 .M.,@.P. @.P.m.@.
1ee17200 73080000 01000400 800012fa ..r.s... ........
16c 64 ADDITEM 248 0 12c 500041 401f6d 72e11e 4532 1 2
40000000 00001c00 10000000 00000000 @....... ........
00000000 00000000 f8000000 2c010000 ........ ....,...
d74dc32c 41005000 41005000 6d1f4000 .M.,A.P. A.P.m.@.
1ee17200 b4110000 01000200 502012fa ..r..... ....P ..
1ac 96 HINSERT 248 0 16c 401f6d 72e11f 29
60000000 00002800 12010000 00000000 `.....(. ........
00000000 00000000 f8000000 6c010000 ........ ....l...
d94dc32c 6d1f4000 6d1f4000 1fe17200 .M.,m.@.
m.@...r.
1d000004 00000000 00000000 502012fa ........ ....P ..
534c2020 534c2020 000012fe 0000a9f8 SL SL ........
50200000 0000c714 13021509 1f00aac9 P ...... ........
20c 72 ADDITEM 248 0 1ac 401f6e 401f6d 72e11f 31393 1 12
48000000 00001c00 10000000 00000000 H....... ........
00000000 00000000 f8000000 ac010000 ........ ........
d94dc32c 6e1f4000 6e1f4000 6d1f4000 .M.,n.@. n.@.m.@.
1fe17200 a17a0000 01000c00 534c2020 ..r..z.. ....SL
800012fe 8000a9f8 ........
addr len type xid id link
254 64 ADDITEM 248 0 20c 50003d 401f6d 72e11f 4632 1 4
40000000 00001c00 10000000 00000000 @....... ........
00000000 00000000 f8000000 0c020000 ........ ........
da4dc32c 3d005000 3d005000 6d1f4000 .M.,=.P. =.P.m.@.
1fe17200 18120000 01000400 8000a9f8 ..r..... ........
294 68 ADDITEM 248 0 254 50003e 401f6d 72e11f 25749 1 8
44000000 00001c00 10000000 00000000 D....... ........
00000000 00000000 f8000000 54020000 ........ ....T...
db4dc32c 3e005000 3e005000 6d1f4000 .M.,>.P. >.P.m.@.
1fe17200 95640000 01000800 800012fe ..r..d.. ........
8000a9f8 ....
2d8 72 ADDITEM 248 0 294 50003f 401f6d 72e11f 25805 1 10
48000000 00001c00 10000000 00000000 H....... ........
00000000 00000000 f8000000 94020000 ........ ........
dc4dc32c 3f005000 3f005000 6d1f4000 .M.,?.P. ?.P.m.@.
1fe17200 cd640000 01000a00 800012fe ..r..d.. ........
8000a9f8 5020a9f8 ....P ..
320 64 ADDITEM 248 0 2d8 500040 401f6d 72e11f 2073 1 4
40000000 00001c00 10000000 00000000 @....... ........
00000000 00000000 f8000000 d8020000 ........ ........
dd4dc32c 40005000 40005000 6d1f4000 .M.,@.P. @.P.m.@.
1fe17200 19080000 01000400 800012fe ..r..... ........
addr len type xid id link
360 64 ADDITEM 248 0 320 500041 401f6d 72e11f 4532 1 2
40000000 00001c00 10000000 00000000 @....... ........
00000000 00000000 f8000000 20030000 ........ .... ...
de4dc32c 41005000 41005000 6d1f4000 .M.,A.P. A.P.m.@.
1fe17200 b4110000 01000200 502012fe ..r..... ....P ..
3a0 96 HINSERT 248 0 360 401f6d 72e120 29
60000000 00002800 12010000 00000000 `.....(. ........
00000000 00000000 f8000000 60030000 ........ ....`...
e04dc32c 6d1f4000 6d1f4000 20e17200 .M.,m.@. m.@. .r.
1d000004 00000000 00000000 502012fe ........ ....P ..
4d414f20 4d414f20 00001300 0000a9f8 MAO MAO ........
54520000 0000c714 13021509 1f00aac9 TR...... ........
400 72 ADDITEM 248 0 3a0 401f6e 401f6d 72e120 33255 1 12
48000000 00001c00 10000000 00000000 H....... ........
00000000 00000000 f8000000 a0030000 ........ ........
e04dc32c 6e1f4000 6e1f4000 6d1f4000 .M.,n.@. n.@.m.@.
20e17200 e7810000 01000c00 4d414f20 .r..... ....MAO
80001300 8000a9f8 ........
addr len type xid id link
448 64 ADDITEM 248 0 400 50003d 401f6d 72e120 4632 1 4
40000000 00001c00 10000000 00000000 @....... ........
00000000 00000000 f8000000 00040000 ........ ........
e14dc32c 3d005000 3d005000 6d1f4000 .M.,=.P. =.P.m.@.
20e17200 18120000 01000400 8000a9f8 .r..... ........
488 68 ADDITEM 248 0 448 50003e 401f6d 72e120 24461 1 8
44000000 00001c00 10000000 00000000 D....... ........
00000000 00000000 f8000000 48040000 ........ ....H...
e24dc32c 3e005000 3e005000 6d1f4000 .M.,>.P. >.P.m.@.
20e17200 8d5f0000 01000800 80001300 .r.._.. ........
8000a9f8 ....
4cc 72 ADDITEM 248 0 488 50003f 401f6d 72e120 29124 1 10
48000000 00001c00 10000000 00000000 H....... ........
00000000 00000000 f8000000 88040000 ........ ........
e34dc32c 3f005000 3f005000 6d1f4000 .M.,?.P. ?.P.m.@.
20e17200 c4710000 01000a00 80001300 .r..q.. ........
8000a9f8 5452a9f8 ....TR..
514 64 ADDITEM 248 0 4cc 500040 401f6d 72e120 346 1 4
40000000 00001c00 10000000 00000000 @....... ........
00000000 00000000 f8000000 cc040000 ........ ........
e44dc32c 40005000 40005000 6d1f4000 .M.,@.P. @.P.m.@.
20e17200 5a010000 01000400 80001300 .r.Z... ........
addr len type xid id link
554 64 ADDITEM 248 0 514 500041 401f6d 72e120 4473 1 2
40000000 00001c00 10000000 00000000 @....... ........
00000000 00000000 f8000000 14050000 ........ ........
e54dc32c 41005000 41005000 6d1f4000 .M.,A.P. A.P.m.@.
20e17200 79110000 01000200 54521300 .r.y... ....TR..
594 96 HINSERT 248 0 554 401f6d 72e121 29
60000000 00002800 12010000 00000000 `.....(. ........
00000000 00000000 f8000000 54050000 ........ ....T...
e74dc32c 6d1f4000 6d1f4000 21e17200 .M.,m.@. m.@.!.r.
1d000004 00000000 00000000 54521300 ........ ....TR..
41445649 41445649 00001302 0000a9f8 ADVIADVI ........
4e450000 0000c714 13021509 1f00aac9 NE...... ........
5f4 72 ADDITEM 248 0 594 401f6e 401f6d 72e121 33754 1 12
48000000 00001c00 10000000 00000000 H....... ........
00000000 00000000 f8000000 94050000 ........ ........
e74dc32c 6e1f4000 6e1f4000 6d1f4000 .M.,n.@. n.@.m.@.
21e17200 da830000 01000c00 41445649 !.r..... ....ADVI
80001302 8000a9f8 ........
addr len type xid id link
63c 64 ADDITEM 248 0 5f4 50003d 401f6d 72e121 4632 1 4
40000000 00001c00 10000000 00000000 @....... ........
00000000 00000000 f8000000 f4050000 ........ ........
e84dc32c 3d005000 3d005000 6d1f4000 .M.,=.P. =.P.m.@.
21e17200 18120000 01000400 8000a9f8 !.r..... ........
67c 68 ADDITEM 248 0 63c 50003e 401f6d 72e121 21603 1 8
44000000 00001c00 10000000 00000000 D....... ........
00000000 00000000 f8000000 3c060000 ........ ....<...
e94dc32c 3e005000 3e005000 6d1f4000 .M.,>.P. >.P.m.@.
21e17200 63540000 01000800 80001302 !.r.cT.. ........
8000a9f8 ....
6c0 72 ADDITEM 248 0 67c 50003f 401f6d 72e121 28398 1 10
48000000 00001c00 10000000 00000000 H....... ........
00000000 00000000 f8000000 7c060000 ........ ....|...
ea4dc32c 3f005000 3f005000 6d1f4000 .M.,?.P. ?.P.m.@.
21e17200 ee6e0000 01000a00 80001302 !.r..n.. ........
8000a9f8 4e45a9f8 ....NE..
708 64 ADDITEM 248 0 6c0 500040 401f6d 72e121 2164 1 4
40000000 00001c00 10000000 00000000 @....... ........
00000000 00000000 f8000000 c0060000 ........ ........
eb4dc32c 40005000 40005000 6d1f4000 .M.,@.P. @.P.m.@.
21e17200 74080000 01000400 80001302 !.r.t... ........
addr len type xid id link
748 64 ADDITEM 248 0 708 500041 401f6d 72e121 4519 1 2
40000000 00001c00 10000000 00000000 @....... ........
00000000 00000000 f8000000 08070000 ........ ........
ec4dc32c 41005000 41005000 6d1f4000 .M.,A.P. A.P.m.@.
21e17200 a7110000 01000200 4e451302 !.r..... ....NE..
788 96 HINSERT 248 0 748 401f6d 72e122 29
60000000 00002800 12010000 00000000 `.....(. ........
00000000 00000000 f8000000 48070000 ........ ....H...
ee4dc32c 6d1f4000 6d1f4000 22e17200 .M.,m.@. m.@.".r.
1d000004 00000000 00000000 4e451302 ........ ....NE..
4b484544 4b484544 0000130a 0000a9f8 KHEDKHED ........
50200000 0000c714 13021509 1f00aac9 P ...... ........
7e8 72 ADDITEM 248 0 788 401f6e 401f6d 72e122 29288 1 12
48000000 00001c00 10000000 00000000 H....... ........
00000000 00000000 f8000000 88070000 ........ ........
ee4dc32c 6e1f4000 6e1f4000 6d1f4000 .M.,n.@. n.@.m.@.
22e17200 68720000 01000c00 4b484544 ".r.hr.. ....KHED
8000130a 8000a9f8 ........
addr len type xid id link
104c 64 ADDITEM 248 0 7e8 50003d 401f6d 72e122 4632 1 4
40000000 00001c00 10000000 00000000 @....... ........
00000000 00000000 f8000000 e8070000 ........ ........
f04dc32c 3d005000 3d005000 6d1f4000 .M.,=.P. =.P.m.@.
22e17200 18120000 01000400 8000a9f8 ".r..... ........
108c 68 ADDITEM 248 0 104c 50003e 401f6d 72e122 22263 1 8
44000000 00001c00 10000000 00000000 D....... ........
00000000 00000000 f8000000 4c100000 ........ ....L...
f14dc32c 3e005000 3e005000 6d1f4000 .M.,>.P. >.P.m.@.
22e17200 f7560000 01000800 8000130a ".r..V.. ........
8000a9f8 ....
10d0 72 ADDITEM 248 0 108c 50003f 401f6d 72e122 26615 1 10
48000000 00001c00 10000000 00000000 H....... ........
00000000 00000000 f8000000 8c100000 ........ ........
f24dc32c 3f005000 3f005000 6d1f4000 .M.,?.P. ?.P.m.@.
22e17200 f7670000 01000a00 8000130a ".r..g.. ........
8000a9f8 5020a9f8 ....P ..
1118 64 ADDITEM 248 0 10d0 500040 401f6d 72e122 1539 1 4
40000000 00001c00 10000000 00000000 @....... ........
00000000 00000000 f8000000 d0100000 ........ ........
f34dc32c 40005000 40005000 6d1f4000 .M.,@.P. @.P.m.@.
22e17200 03060000 01000400 8000130a ".r..... ........
addr len type xid id link
1158 64 ADDITEM 248 0 1118 500041 401f6d 72e122 4532 1 2
40000000 00001c00 10000000 00000000 @....... ........
00000000 00000000 f8000000 18110000 ........ ........
f44dc32c 41005000 41005000 6d1f4000 .M.,A.P. A.P.m.@.
22e17200 b4110000 01000200 5020130a ".r..... ....P ..
1198 96 HINSERT 248 0 1158 401f6d 72e123 29
60000000 00002800 12010000 00000000 `.....(. ........
00000000 00000000 f8000000 58110000 ........ ....X...
f64dc32c 6d1f4000 6d1f4000 23e17200 .M.,m.@. m.@.#.r.
1d000004 00000000 00000000 5020130a ........ ....P ..
56425720 56425720 0000130c 0000a9f8 VBW VBW ........
50200000 011ec714 1303160e 1700aac9 P ...... ........
11f8 72 ADDITEM 248 0 1198 401f6e 401f6d 72e123 32187 1 12
48000000 00001c00 10000000 00000000 H....... ........
00000000 00000000 f8000000 98110000 ........ ........
f64dc32c 6e1f4000 6e1f4000 6d1f4000 .M.,n.@. n.@.m.@.
23e17200 bb7d0000 01000c00 56425720 #.r..}.. ....VBW
8000130c 8000a9f8 ........
addr len type xid id link
1240 64 ADDITEM 248 0 11f8 50003d 401f6d 72e123 4632 1 4
40000000 00001c00 10000000 00000000 @....... ........
00000000 00000000 f8000000 f8110000 ........ ........
f74dc32c 3d005000 3d005000 6d1f4000 .M.,=.P. =.P.m.@.
23e17200 18120000 01000400 8000a9f8 #.r..... ........
1280 68 ADDITEM 248 0 1240 50003e 401f6d 72e123 25119 1 8
44000000 00001c00 10000000 00000000 D....... ........
00000000 00000000 f8000000 40120000 ........ ....@...
f84dc32c 3e005000 3e005000 6d1f4000 .M.,>.P. >.P.m.@.
23e17200 1f620000 01000800 8000130c #.r..b.. ........
8000a9f8 ....
12c4 72 ADDITEM 248 0 1280 50003f 401f6d 72e123 28871 1 10
48000000 00001c00 10000000 00000000 H....... ........
00000000 00000000 f8000000 80120000 ........ ........
f94dc32c 3f005000 3f005000 6d1f4000 .M.,?.P. ?.P.m.@.
23e17200 c7700000 01000a00 8000130c #.r..p.. ........
8000a9f8 5020a9f8 ....P ..
130c 64 ADDITEM 248 0 12c4 500040 401f6d 72e123 3066 1 4
40000000 00001c00 10000000 00000000 @....... ........
00000000 00000000 f8000000 c4120000 ........ ........
fa4dc32c 40005000 40005000 6d1f4000 .M.,@.P. @.P.m.@.
23e17200 fa0b0000 01000400 8000130c #.r..... ........
addr len type xid id link
134c 64 ADDITEM 248 0 130c 500041 401f6d 72e123 4532 1 2
40000000 00001c00 10000000 00000000 @....... ........
00000000 00000000 f8000000 0c130000 ........ ........
fb4dc32c 41005000 41005000 6d1f4000 .M.,A.P. A.P.m.@.
23e17200 b4110000 01000200 5020130c #.r..... ....P ..
138c 96 HINSERT 248 0 134c 401f6d 72e124 29
60000000 00002800 12010000 00000000 `.....(. ........
00000000 00000000 f8000000 4c130000 ........ ....L...
fd4dc32c 6d1f4000 6d1f4000 24e17200 .M.,m.@. m.@.$.r.
1d000004 00000000 00000000 5020130c ........ ....P ..
4b542020 4b542020 00001311 0000a9f8 KT KT ........
52200000 0000c714 13021509 1f00aac9 R ...... ........
13ec 72 ADDITEM 248 0 138c 401f6e 401f6d 72e124 33054 1 12
48000000 00001c00 10000000 00000000 H....... ........
00000000 00000000 f8000000 8c130000 ........ ........
fd4dc32c 6e1f4000 6e1f4000 6d1f4000 .M.,n.@. n.@.m.@.
24e17200 1e810000 01000c00 4b542020 $.r..... ....KT
80001311 8000a9f8 ........
addr len type xid id link
1434 64 ADDITEM 248 0 13ec 50003d 401f6d 72e124 4632 1 4
40000000 00001c00 10000000 00000000 @....... ........
00000000 00000000 f8000000 ec130000 ........ ........
fe4dc32c 3d005000 3d005000 6d1f4000 .M.,=.P. =.P.m.@.
24e17200 18120000 01000400 8000a9f8 $.r..... ........
1474 68 ADDITEM 248 0 1434 50003e 401f6d 72e124 22646 1 8
44000000 00001c00 10000000 00000000 D....... ........
00000000 00000000 f8000000 34140000 ........ ....4...
ff4dc32c 3e005000 3e005000 6d1f4000 .M.,>.P. >.P.m.@.
24e17200 76580000 01000800 80001311 $.r.vX.. ........
8000a9f8 ....
14b8 72 ADDITEM 248 0 1474 50003f 401f6d 72e124 26661 1 10
48000000 00001c00 10000000 00000000 H....... ........
00000000 00000000 f8000000 74140000 ........ ....t...
004ec32c 3f005000 3f005000 6d1f4000 .N.,?.P. ?.P.m.@.
24e17200 25680000 01000a00 80001311 $.r.%h.. ........
8000a9f8 5220a9f8 ....R ..
1500 64 ADDITEM 248 0 14b8 500040 401f6d 72e124 1665 1 4
40000000 00001c00 10000000 00000000 @....... ........
00000000 00000000 f8000000 b8140000 ........ ........
014ec32c 40005000 40005000 6d1f4000 .N.,@.P. @.P.m.@.
24e17200 81060000 01000400 80001311 $.r..... ........
addr len type xid id link
1540 64 ADDITEM 248 0 1500 500041 401f6d 72e124 4531 1 2
40000000 00001c00 10000000 00000000 @....... ........
00000000 00000000 f8000000 00150000 ........ ........
024ec32c 41005000 41005000 6d1f4000 .N.,A.P. A.P.m.@.
24e17200 b3110000 01000200 52201311 $.r..... ....R ..
1580 96 HINSERT 248 0 1540 401f6d 72e125 29
60000000 00002800 12010000 00000000 `.....(. ........
00000000 00000000 f8000000 40150000 ........ ....@...
Now, how to get the tablename from the above output ?
Thanks & Regards,
Neville Monteiro.