Re: SQL caching in local mode

Discussion created by ca.portal.admin on Oct 17, 2006

You can see a difference when you also use the sysidms parameter
Set once SQL_CACHE_ENTRIES=0 and look in the syslst in the buffer
statistics for the catalog.
Second job : set SQL_CACHE_ENTRIES=500.

Luc De Naeyer
Corporate System Database Administrator for IDMS Infoco
(InformaticsColruyt) T : +32 2 360 10 40
----- Original Message -----
From: ""Rozeboom, Kay [DAS]"" <KAY.ROZEBOOM@IOWA.GOV>
To: <>
Sent: maandag 16 oktober 2006 18:58
Subject: SQL caching in local mode

I am trying to test SQL caching in local mode by using the new SYSIDMS
parameter ""SQL_CACHE_ENTRIES=nnn"". I cannot see any difference in CPU
used, even when I execute the exact same query 10,000 times. Is there
something else I need to do to turn on SQL caching for local mode? Is
there any way to tell whether or not it is turned on in local mode?

Kay Rozeboom
State of Iowa
Information Technology Enterprise
Department of Administrative Services
Telephone: 515.281.6139 Fax: 515.281.6137
Email: Kay.Rozeboom@Iowa.Gov
IDMS Public Discussion Forum


Re: SQL caching in local mode
"Rats. I mean it's good that the SQL is already compiled and optimized
in the access module. But I was looking for something to improve batch
performance, and I guess SQL caching is not it.

I did get a further piece of information from Cal Domingue: SQL caching
is turned on by default in local mode. The only way to turn it off is
to explicitly code the SYSIDMS parm ""SQL_CACHE_ENTRIES=0"".