Re: [foxboro] 0% Idle Time on AW51B

So except for the fact that your informix database is now nicely organized,
it didn't solve your problem.

There is still another possible solution, but i need extra information for
this.

-How much messages are stored in each message group, and how many groups are
active?

greetings,

>               Rob de Groot
>               Senior system service engineer
>               Invensys Systems N.V.
>               Baarnsche dijk 10   P.O. Box 146   3740 AC Baarn   The
Netherlands
>               T: +31 (0)35 54 84 176   F: +31 (0)35 54 84 175 
> rdegroot@xxxxxxxxxxx   www.invensys-systems.nl


-----Original Message-----
From: Ajay_Tathgir@xxxxxxx [mailto:Ajay_Tathgir@xxxxxxx]
Sent: Wednesday, April 17, 2002 6:02 AM
To: foxboro@xxxxxxxxxxxxx
Subject: Re: [foxboro] 0% Idle Time on AW51B




I ultimately got the opportunity to do saveh50 & loadh50.
The message that Table xxxxx has more than 8 extends is no
more appearing.

But the rest of the scenario is still same, i.e. sqlturbo still
eats beyond 90% of cpu time, resulting in 0% idle time.

And the funny thing is that at height of frustration, i deleted
all the collection points, so I have a historian which has no
collection points, no reduction groups, only message groups.

What do I get, sqlturbo still eating away the cpu time like before.

Thanks & Regards



Ajay Tathgir
Reliance Industries Limited
Mumbai - India




"de Groot, Rob" <rdegroot@xxxxxxxxxxx>@freelists.org on 27-03-2002 17:03:31

Please respond to foxboro@xxxxxxxxxxxxx

Sent by:  foxboro-bounce@xxxxxxxxxxxx


To:   "'foxboro@xxxxxxxxxxxxx'" <foxboro@xxxxxxxxxxxxx>
cc:
Subject:  Re: [foxboro] 0% Idle Time on AW51B



Probably your informix database is very fragmented. Try the following:

cd /opt/informix/bin
tbcheck -ce

This will check your informix database. If you get messages like:

Table xxxx has more then 8 extends,

your database is fragmented, wich will make informix work (very) slow. The
tables reported will probably be reduction groups. You should know if they
are. If so, you can clean things up by running saveh50 followed by loadh50.
They are located in /opt/fox/hstorian/bin. loadh50 looks how much data is
in
the reduction data tables (and other tables as well), and will recreate the
tables in such a way that all the data fits in one extend.

When you do a saveh50 and loadh50 you historian will be offline, and
sometimes they can run for a very long time. (Many hours) So be carefull.

Read the B0193BL document about the historian before you do this, it will
provide with extra information. Look in the managing databases chapter. It
discribes saveh50 and loadh50 and more.
It's on the foxdoc CD.

I hope it will give you a solution for your problem.

Greetings and succes,

Rob de Groot

-----Original Message-----
From: Ajay_Tathgir@xxxxxxx [mailto:Ajay_Tathgir@xxxxxxx]
Sent: Wednesday, March 27, 2002 11:53 AM
To: foxboro@xxxxxxxxxxxxx
Subject: Re: [foxboro] 0% Idle Time on AW51B




Thanks a lot. I mention one process as such as I picked up from
output of ps -ef.


root      12312     1  0   Mar 22 ?        0:00
/opt/fox/hstorian/bin/reduction_ctl hist01
root      12313 12312  0   Mar 22 ?        0:01 /opt/informix/lib/sqlturbo
root 5.00.UD1


The other processes which have pid number same to that of ppid
of sqlturbo are as below:

hr_fetch, hist_srv, archiving_ctl, collect_mg, reduction_ctl

There are a total of 5 instances of sqlturbo running. I hope
this is the information that u asked for.


Thanks & regards




Ajay Tathgir
Reliance Industries Limited
Mumbai - India







"de Groot, Rob" <rdegroot@xxxxxxxxxxx>@freelists.org on 03 27 2002 15:14:46

Please respond to foxboro@xxxxxxxxxxxxx

Sent by:  foxboro-bounce@xxxxxxxxxxxxx


To:   "'foxboro@xxxxxxxxxxxxx'" <foxboro@xxxxxxxxxxxxx>
cc:
Subject:  Re: [foxboro] 0% Idle Time on AW51B



A sql_turbo process is being used by another process. You will first have
to
find out which one that is. So if you know the pid of the sql_turbo, find a
process which has this pid as ppid. It's in the field next to pid, when you
do a ps -ef. It's probably one of the historian processes. If you can tell
which process that is i'm more able to help you with this one.

Greetings:

Rob de Groot

          Invensys Process Systems
          Baarn.

-----Original Message-----
From: Ajay_Tathgir@xxxxxxx [mailto:Ajay_Tathgir@xxxxxxx]
Sent: Wednesday, March 27, 2002 5:19 AM
To: foxboro@xxxxxxxxxxxxx
Subject: [foxboro] 0% Idle Time on AW51B



Good Day


I have a AW51B running I/A Series software 6.1, with legacy Historian.

RAM on station is 96MB and swap space is 128MB.


Now the issue is that at certain times, the CPU idle time goes to 0% and
this phenomena is quite periodic, say around every 35-40 minutes for 10-15
minutes.

After going through the processes that were being executed at this instant
found that there is a process sql_turbo which eats upto 90% of the CPU
time.


Can anybody give me a idea what's going on.


Thanks & Regards



Ajay Tathgir
Reliance Industries Limited
Mumbai - India


 
 
_______________________________________________________________________
This mailing list is neither sponsored nor endorsed by Invensys Process
Systems (formerly The Foxboro Company). Use the info you obtain here at
your own risks. Read http://www.thecassandraproject.org/disclaimer.html
 
foxboro mailing list:             http://www.freelists.org/list/foxboro
to subscribe:         mailto:foxboro-request@xxxxxxxxxxxxx?subject=join
to unsubscribe:      mailto:foxboro-request@xxxxxxxxxxxxx?subject=leave
 
 
 
_______________________________________________________________________
This mailing list is neither sponsored nor endorsed by Invensys Process
Systems (formerly The Foxboro Company). Use the info you obtain here at
your own risks. Read http://www.thecassandraproject.org/disclaimer.html
 
foxboro mailing list:             http://www.freelists.org/list/foxboro
to subscribe:         mailto:foxboro-request@xxxxxxxxxxxxx?subject=join
to unsubscribe:      mailto:foxboro-request@xxxxxxxxxxxxx?subject=leave

Other related posts: