Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
This concerns IBM Informix Dynamic Server Version 11.70.TC3IE on Windows
Server 2008 sp2 .
I had some stored procedures that were using a "debug file" to write out a
few lines to the sqexpln folder for my own information.
These were mainly nightly tasks that were low-use and did not present any
performance issues ( IDS 9.4) .
They were usually something like
LET nrows = DBINFO('sqlca.sqlerrd2');
trace nrows || " rows purged";
But when we went to 11.70, these procs took the IDS down at night when they
ran.
There was always a file in the ids folder that stated that the service was
stopped from the outside (or some such verbiage).
I had to use the timestamp to figure out what it was. It took days because I
was astounded that IBM would leave a bug like that in a product.
I took out the debug file and recompiled all of the procs and the problem
went away.
Has anyone had any similar experiences?
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.