Geezer

I currently have 2.6 billon lock reqs with 0 ovlocks and
1080 lock waits in 3 1/2 days. Ssytem is running fine with
250,000 locks in config file. Sugest you lok elsewhere for
your performance problems.
Disk layout, type ?

Keith

-----Original Message-----
From: Geezer From The Freezer [mailto:Geezer@Freezer.com]
Sent: Wednesday, January 26, 2005 16:35
To: informix-list@iiug.org
Subject: Re: 1.6 billion lockreqs

Claus Samuelsen wrote:
>
> continued ...
>
> more interesting is the ovlock, which counts the number of times maximum
> number of locks has been reached, and the lockwts which counts counts
> the number of times sessions waited for a lock.
>
> Geezer From The Freezer wrote:
> > If I have 1.6 billion lockreqs is this going to create a major problem (lag etc)
> > if so does increasing the locks help?

ovlocks = 0
lokwaits = 0

System is grinding. In comparison to another server which has the same data and
is running fine.

Informix 7.31UC5 (up 6 days) on Solaris 8

************************************************** ********************************
This message is sent in strict confidence for the addressee only. It may
contain legally privileged information. The contents are not to be disclosed
to anyone other than the addressee. Unauthorised recipients are requested
to preserve this confidentiality and to advise the sender immediately of any
error in transmission.
This footnote also confirms that this email message has been swept for the
presence of computer viruses, however we cannot guarantee that this message
is free from such problems.
************************************************** ********************************

sending to informix-list

"Simmons, Keith" wrote:
>
> Geezer
>
> I currently have 2.6 billon lock reqs with 0 ovlocks and
> 1080 lock waits in 3 1/2 days. Ssytem is running fine with
> 250,000 locks in config file. Sugest you lok elsewhere for
> your performance problems.
> Disk layout, type ?
>
> Keith

hmmm good point, the disk layout is pretty basic - 1 internal disk only and
using large empty files
for dbspaces. BUT I am doing this on another system (a lot older system) and
that runs much better.

Geezer From The Freezer wrote:

So you're using COOKED files for chunks and all of your chunks live on the
same single spindle. And you wonder were the bottleneck is? I think you
found it and it's not locks.

Art S. Kagel

> "Simmons, Keith" wrote:
>
>>Geezer
>>
>>I currently have 2.6 billon lock reqs with 0 ovlocks and
>>1080 lock waits in 3 1/2 days. Ssytem is running fine with
>>250,000 locks in config file. Sugest you lok elsewhere for
>>your performance problems.
>>Disk layout, type ?
>>
>>Keith
>
>
> hmmm good point, the disk layout is pretty basic - 1 internal disk only and
> using large empty files
> for dbspaces. BUT I am doing this on another system (a lot older system) and
> that runs much better.