Hi,
Running IDS10.0.FC5 on Aix5.3, P570 server with FastT900 San and Tivoli 5..3.3.
Backed up terabyte database with onbar.
Restoring to different server.

Lately, the restore is taking an extraordinary amount of time, in the order of 48 hours. Only takes about 4 hours to back it up.
Tivoli support has been little help.
I notice running Sar on the restore box, that the cpu is hardly taxed, and the Io doesn't appear to be bogged either.

Just seeking advice on which onstats to use to help determine if Informixshould have more resources assigned to help restore go faster, or at least to help determine if Informix is the bottleneck for this restore.

Thanks,
Floyd

========================
email: floyd (AT) fwellers (DOT) com
Home: 703-430-0805
Cell: 703-477-6045
========================

www.one.org
www.myspace.com/onepriority

onstat -Dr will tell you how much is being written or one of the
onstats -g ioa

Superboer.


On 27 jun, 16:06, f... (AT) fwellers (DOT) com wrote:

An onstat -g iov shows the inverted pyramid. But aren't these io's per second really low ? Does this indicate a bottleneck somewhere ?

class/vp s io/s totalops dskread dskwrite dskcopy wakeups io/wup errors
kio 0 s 38.4 193890 53 193837 0 479123 0.4 0
kio 1 i 50.6 255670 7 255663 0 642746 0.4 0
kio 2 i 5.5 27535 0 27535 0 86517 0.3 0
kio 3 i 2.5 12730 0 12730 0 34760 0.4 0
kio 4 i 0.9 4690 0 4690 0 12548 0.4 0
kio 5 i 2.8 14042 0 14042 0 44586 0.3 0
msc 0 i 0.0 11 0 0 0 10 1.1 0
aio 0 i 0.1 623 34 2 0 624 1.0 0
aio 1 i 0.0 1 0 0 0 1 1.0 0
aio 2 i 0.0 1 0 0 0 1 1.0 0
aio 3 i 0.0 1 0 0 0 1 1.0 0
aio 4 i 0.0 1 0 0 0 1 1.0 0
aio 5 i 0.0 0 0 0 0 1 0.0 0
pio 0 i 0.0 0 0 0 0 1 0.0 0
lio 0 i 0.0 0 0 0 0 1 0.0 0


-----Original Message-----
From: Superboer [mailto:superboer7 (AT) t-online (DOT) de]
Sent: Wednesday, June 27, 2007 10:26 AM
To: informix-list (AT) iiug (DOT) org
Subject: Re: question about monitoring restore performance

onstat -Dr will tell you how much is being written or one of the
onstats -g ioa

Superboer.


On 27 jun, 16:06, f... (AT) fwellers (DOT) com wrote:

_______________________________________________
Informix-list mailing list
Informix-list (AT) iiug (DOT) org
http://www.iiug.org/mailman/listinfo/informix-list

Hello Floyd,

these numbers do not seems to be much...

onstat -D -r 60 will give you the writes on a chunk.
so you can calculate how much it does and see if your disks are fully
occupied or not.

However:
50*(16 pages ) = 3.2 MB /sec writing.

i have seen disks do much better then that!!!!

thing a broken controler made the machine
perform worse then a floppy disk unfortunatly the aix folks decided to
upgrade firmware etc
instead of replacing that controler... the problems were gone when
they received a kick in the ass
and the did replace the controler


Superboer.

BTW aix: have a look at topas it will tell you how busy your disks
are.


On 27 jun, 16:42, f... (AT) fwellers (DOT) com wrote: