Informix - Problem description
Problem IT34818 | Status: Closed |
ONSTAT -G SQL DOES NOT SHOW LAST ERROR ON SESSION | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
Nor onstat -g sql nor syssqlstat show the lock waiting expiring error: 1. In the first one connect to stores database and perform the following statements, leaving the transaction open: BEGIN WORK; UPDATE customer set lname='Smith' WHERE customer_num=101; 2. On a second one, connect to stores database and perform the following statement: SELECT * FROM customer WHERE customer_num=101; You will receive the -244/-107 error messages, which is expected. Keep this session opened, showing the error messages: 244: Could not do a physical-order read to fetch next row. 107: ISAM error: record is locked. 3. On a third session, having the other two sessions opened and connected, perfom "onstat -g sql": (09:38:58)-(informix)-(504)-> onstat -g sql IBM Informix Dynamic Server Version 12.10.FC14 -- On-Line -- Up 01:51:50 -- 149032 Kbytes Sess SQL Current Iso Lock SQL ISAM F.E. Id Stmt type Database Lvl Mode ERR ERR Vers Explain 38 - stores CR Not Wait 0 0 9.24 Off | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC15 and 14.10.xC6. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC15 (when available) or * * 14.10.xC6 (when available). * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC15 and 14.10.xC6. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC15 (when available) or * * 14.10.xC6 (when available). * **************************************************************** | |
Comment | |
Fixed in Informix Server 12.10.xC15 and 14.10.xC6. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 06.11.2020 12.05.2021 12.05.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |