Informix - Problem description
Problem IT30035 | Status: Closed |
HARD TO INTERPRET ONSTAT -G HIS FOR TRIGGERS AND STORED PROCEDURES AS WE JUST SEE "COMPILED STATEMENT" & "EXEC PROCEDURE" | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem 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 | |
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). * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * 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). * **************************************************************** | |
Comment | |
Fixed in Informix Server 12.10.xC14 and 14.10.xC4. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 19.08.2019 03.03.2020 03.03.2020 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC14, 14.10.xC4 | |
Problem solved according to the fixlist(s) of the following version(s) |