IT30035: HARD TO INTERPRET ONSTAT -G HIS FOR TRIGGERS AND STORED PROCEDURES AS WE JUST SEE "COMPILED STATEMENT" & "EXEC PROCEDURE"

APAR status

• Closed as program error.

Error description

• When enabling SQLTRACES, it is then possible to view the SQL
  statements that have been run in "onstat -g his".   If there are
  U/D/I triggers on a table that run SPL's then it is not easy to
  see the trigger / SPL especially on a busy system with lots of
  users as the statements can be far apart.  Here are a few
  examples â ¦
  
  Statement # 350:     @ 700000020fc0b30
   Statement text:
    Compiled Statement
   Statement information:
    Sess_id  User_id  Stmt Type        Finish Time    Run Time
  TX Stamp   PDQ
    407      1002     EXEC PROCEDURE   16:22:06       0.0002
  1f8a03ab   0
  
  Statement # 349:     @ 700000020fc0b28
   Procedure Call Stack:
    ts002495910:rob1_spl1()
    UPDATE using table [ state ]
   Statement information:
    Sess_id  User_id  Stmt Type        Finish Time    Run Time
  TX Stamp   PDQ
    407      1002     UPDATE           16:22:06       0.0001
  1f8a03ab   0
  
  and
  
  Statement # 368:     @ 700000020fc0bc0
   Statement text:
    Compiled Statement
    UPDATE using table [ rob2 ]
   Statement information:
    Sess_id  User_id  Stmt Type        Finish Time    Run Time
  TX Stamp   PDQ
    407      1002     UPDATE           16:27:27       0.0000
  1f8a04db   0
  
  Statement # 367:     @ 700000020fc0bb8
   Statement text:
    Compiled Statement
   Statement information:
    Sess_id  User_id  Stmt Type        Finish Time    Run Time
  TX Stamp   PDQ
    407      1002     EXEC PROCEDURE   16:27:27       0.0001
  1f8a04db   0
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of Informix Server prior to 12.10.xC14 and 14.10.xC4.  *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to Informix Server 12.10.xC14 or 14.10.xC4 (when      *
  * available).                                                  *
  ****************************************************************
  

Problem conclusion

• Fixed in Informix Server 12.10.xC14 and 14.10.xC4.
  

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