Re: oncheck performance issuest (fwd)
This was my reply to Joe, since I saw your response on the list, I thought
I better responed to the list also.
The following applies to my configuration that I mention below:
INFORMIX 5.02 UC9 on 580, RS6000 with AIX 3.2
INFORMIX 7.12 UC2 on 43P, RS6000 with AIX 4.1
The 43P is a single CPU machine, I'm not sure about the 580. Anyway...
if there is something I could execute to help you guys out let me know.
---------- Forwarded message ----------
Date: Thu, 18 Apr 1996 14:46:44 -0500 (CDT)
From: Cheryl Kendricks <cherylk@prod1.jcdc.doleta.gov>
To: Joe Lumbley <jlumbley@netcom.com>
Subject: Re: oncheck performance issuest
I run a pe every morning on my 7.10(now 7.12 as of yesterday) system
that is covering almost 3GB. Now mind you it does not have that
much data (if it has 1GB (being in development, I would be surprised)).
Yet it only take me 30 sec to run a tbcheck -pe. I think you may have something
wrong. You might want to check this out. Now for the tbcheck -cI and -cD
I haven't ran, but I am going to start. If you are interested in my times
let me know.
I am running this process off hours, even the pe (I created a cron to
do this). Anyway....
Even on my 10GB full of data on Informix 5.02 it does not take 5 minutes
to do a tbcheck -pe. I just ran one with 64 active process and it took 30
seconds. Something is up with your system (hum!!!)
-------------------------------------------------------------------------
Cheryl Kendricks
Internet:cherylk@prod1.jcdc.doleta.gov
OR
kendric@gwysmtp.jcdc.doleta.gov
OR
cherylk@spamis.jcdc.doleta.gov
DTSI, Inc. Voice: 1-800-598-5008
Database Administrator - DOL Job Corps San Marcos, Texas
------------------------------------------------------------------------
On Thu, 18 Apr 1996, Joe Lumbley wrote:
> >
> > Joe what are doing in the oncheck i.e. which command have you noticed
> > causing slower performce -pT, -pe, .........ci, cI
> >
> > Let me know and I can check it out on my 7.12 engines.
> >
> >
> The -pe, -cI and -cD seem much slower. I've gotten an expanation
> for the -cI slowdown..more work being done, but I can't see why the -pe
> went from about 5 minutes to over an hour from 5.X to 7.X.
>
> Joe
>
>
> --
> ---------------------------------------------------------------------------
> Joe Lumbley(jlumbley@netcom.com) Dallas, Texas
> ----------------------------------------------------------------------------
>