Posted by: Rein van Erkel
We are in the process of migrating our application from SqlBase 8.5 to
SqlBase 11.0.2 and are experiencing some strange locking problems. I started
a database audit to isolate the conflicting statements bud the contents of
this audit file puzzled me. Not only is the lock type of the first statement
"Unknown" bud more important is the fact that the two statements, that
caused the locking time out, are executed on different databases. The
problem however does not arise if the order by of the second statement is
ommited. I hope someone can shed light on this problem.
Rein van Erkel.
SELECT COUNT(*) FROM LICENTIEGEGEVENS
SELECT * FROM WF_CA_PARAM WHERE WF_CA_PARAM.CDCONACT = 'ACT' AND
WF_CA_PARAM.TAAL = 'NL' ORDER BY WF_CA_PARAM.PARAMNR