Re: KAIO and PDQ PRIORITY

Alexander V.Didytch wrote: > > Hi! > > Here is the problem: > we were using no pdq queries for some period of time (MAXPDQPRIORITY was > > set to 0) but when we decided to use it (we have a lot of stored proc > with SET > PDQPRIORITY HIGH inside of it) we set it (MAXPDQPRIORITY) to 40. > > And when 2 queries (in different session) with the PDQPRIORITY HIGH > start working in parallel one of it stop working (previously it works 2 > sec and I was > waiting for 2 minutes) -> had seen the log and saw the following: > > 10:43:47 Checkpoint Completed: duration was 0 seconds. > 10:53:47 dynamically allocated new shared memory segment (size 8388608) > > 10:53:50 dynamically allocated new shared memory segment (size 8388608) > > 10:53:53 KAIO: out of OS resources, errno = 11, pid = 4120 > 10:53:53 KAIO: out of OS resources, errno = 11, pid = 4121 > 10:53:58 KAIO: out of OS resources, errno = 11, pid = 4120 There are a number of kernel parameters to do with kernel AIO (KAIO). Check your release notes, typically $INFORMIXDIR/release/*/*/ONLINE_7.2 for details of these parameters. Check you have all patches loaded as specified in these notes. Also check these notes for details of shared memory and semaphore kernel parameter values. Cheers, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com http://www.iiug.org |///// / //| | +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+