IT31484: ONSTAT -G SQL DOESN'T SHOW ERROR ISAM ERROR: -100 WHEN TRAPPED USING ONMODE -I 100

APAR status

• Closed as suggestion for future release.

Error description

• When ISAM error : -100 is trapped using onmode -I 100, onstat -g
  sql section of the af file doesn't list the error
  
  /informix/bin/onstat -g sql 604646:
  
  IBM Informix Dynamic Server Version 12.10.FC12 -- On-Line -- Up
  30 days 13:54:25 -- 12591104 Kbytes
  
  Sess     SQL               Current            Iso Lock      SQL
  ISAM  F.E.
  Id         Stmt type      Database         Lvl Mode       ERR
  ERR   Vers  Explain
  604646     INSERT             test          CR  Wait 5     0
  0      9.28  Off
  

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

• The trapping of ISAM error code works as designed. The SQL layer
  is not involved at that point in time and will received the ISAM
  error only after the error trapping already jumped in. That is
  the reason the SQL control blocks do not reflect the error at
  the time of the trap.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels