SQL Capture - DB version 11.7.FC4
Posted in 2012
Hello All, We recently upgraded to version 11.7.FC4 (on AIX 6.1) and have run into an issue that appears to be related to the specific version. While trying to capture the SQL hitting one table on our primary server (we have an HDR pair) using Sentinel (Server Studio), the instance crashed. The folks at AGS believe it to be a bug in this Informix version and we have an outstanding IBM PMR connected to it. We also experienced a crash on Primary when running our own SQL Capture through crontab that executed every 5 minutes. This home grown script has been used on many prior Informix versions with no adverse impact. I have run the sql used in both processes manually through an editor and so far, it has not resulted in anything negative, so I am not sure if it might be load related or some other such thing. Is anyone else experiencing a similar issue? Below are the SQL's taken out of the assert failure files: #1)
Thanks much!