APAR status
Closed as program error.
Error 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 <======NOK 35 sysadmin DR Wait 5 0 0 - Off 34 sysadmin DR Wait 5 0 0 - Off 33 sysadmin DR Wait 5 0 0 - Off 32 sysadmin CR Not Wait 0 0 - Off 5 - stores CR Not Wait 0 0 9.24 Off As you can see onstat ouput does not show any session with error, even when last query on session 43 terminated with errors -244/-107. Running a select in syssqlstat also doesn't show the error: sqs_sessionid 38 sqs_dbname stores sqs_iso 2 sqs_lockmode 0 sqs_sqlerror 0 sqs_isamerror 0 sqs_feversion 9.03 sqs_statement SELECT * FROM customer WHERE customer_num=101
Local fix
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). * ****************************************************************
Problem conclusion
Fixed in Informix Server 12.10.xC15 and 14.10.xC6.
Temporary fix
Comments
APAR Information
APAR number
IT34818
Reported component name
INFORMIX SERVER
Reported component ID
5725A3900
Reported release
C10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-11-06
Closed date
2021-05-12
Last modified date
2021-05-12
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
INFORMIX SERVER
Fixed component ID
5725A3900
Applicable component levels
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10"}]
Document Information
Modified date:
13 May 2021