INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10

Certain types of SQL query that use an index self join on large
tables where the index pages are held in the buffer pool may not
yield frequently enough during their execution. This could
result in a blocked checkpoint request if another thread is in
critical section and waiting on the result of an I/O request and
that result needs to be processed by the kaio thread running on
the same CPU VP as the non-yielding query.

A stack of the running thread may be similar to:

btfind
btsearch
kposition
rsstart
fmstart
nextlkeyrg
startsubq
scan_next
getrow
fetchrow
exfetch
sql_nfetch
sq_nfetch
sqmain

As the thread is in a running state the top few functions may or
may not be present. The key indicator for this problem is the
function nextlkeyrg which may perform a loop operation.

****************************************************************
* USERS AFFECTED:                                              *
* Users of IDS prior to 12.10.xC13.                            *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* Queries performing index self join may not yield frequently  *
* enough leading to blocked checkpoint requests.               *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

27.12.2018
03.10.2019
03.10.2019

12.10.xC13