ca.portal.admin

Re:Re: SQL caching in local mode

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

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

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: <IDMS-L@listserv.iuassn.com>
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=3Dnnn"". 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
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
CAS Security Reports
"Hello All:

Are you aware of any listing of standard user / groups and the associated
transactions / privileges extended to that group for CAS? Any information would
be greatly appreciated.
Bill Allen
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: CAS Security Reports
"Bill -

I have some programs that will report who has access to a given
response, but I wrote them all (except for the ADSA decomposer that I
got from Gary Cherlet) and they're somewhat tailored to the security
setup we have here that is probably far from standard (I inherited it)
and a bona-fide disaster (to this I can personally attest), so I don't
know if they would be of any help to you, but I'm happy to answer any
questions. Didn't I email you the Bachman for the security database a
while back?

Outcomes