Informix - Problem description
Problem IT30359 | Status: Closed |
WITH USELASTCOMMITTED SET TO "ALL" ONSTAT -K SHOW LOCKS WITH OWNER '0' | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
onstat -k shows lock with owner '0' when USELASTCOMMITTED set to "ALL". Sample onstat -k output IBM Informix Dynamic Server Version 12.10.FC9W1X2 -- On-Line -- Up 1 days 00:43:58 -- 5788336 Kbytes Locks address wtlist owner lklist type tblsnum rowid key#/bsiz 700000010282d70 0 0 70000001052c2b0 HDR+ 100245 2ba1c 0 D 70000001035fac8 0 70000002065f2b8 0 S 100002 204 0 70000001035fb50 0 70000002065f2b8 70000001035fac8 HDR+S 100002 201 0 700000010362190 0 0 700000010527520 HDR+ 100245 33912 0 D 700000010368f00 0 0 700000010600cd0 HDR+ 100245 71226 0 D 70000001036c640 0 0 70000001036ad48 HDR+ 100245 6310b 0 D 70000001043d018 0 70000002065fb88 0 S 100002 204 0 70000001043d678 0 0 70000001052af08 HDR+ 100245 31010 0 D 70000001043e118 0 0 700000010286e40 HDR+ 100245 2e827 0 D 70000001043ebb8 0 0 7000000105286a8 HDR+ 100245 2a104 0 D 70000001043f768 0 0 7000000101a61b0 HDR+ 100245 44a14 0 D 700000010441060 0 0 70000001043d458 HDR+ 100245 48c02 0 D 70000001051a568 0 700000020660458 0 HDR+S 100002 204 0 700000010520ae0 0 0 700000010539ae8 HDR+ 100245 38c0e 0 D 700000010523560 0 0 700000010522f88 HDR+ 100245 59c02 0 D 700000010523bc0 0 0 7000000105f9080 HDR+ 100245 2e91e 0 D 7000000105256d8 0 0 700000010601330 HDR+ 100245 30222 0 D 7000000105275a8 0 0 700000010362f60 HDR+ 100245 61620 0 D | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC14 and 14.10.xC3. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to Informix Server 12.10.xC14 or 14.10.xC3. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC14 and 14.10.xC3. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to Informix Server 12.10.xC14 or 14.10.xC3. * **************************************************************** | |
Comment | |
Fixed in Informix Server 12.10.xC14 and 14.10.xC3. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 23.09.2019 26.02.2020 26.02.2020 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC14, 14.10.xC3 | |
Problem solved according to the fixlist(s) of the following version(s) |