IT34818: ONSTAT -G SQL DOES NOT SHOW LAST ERROR ON SESSION

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 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