Re: speed up onspaces utility

Art and Neil, It took about 20 minutes to initialize a 10 Gig dbspace. I just talked to SysAdmin. He thinks that the stripped raw disks may be the reason. Since it only takes 5 minutes to initialize the same size of disk with the UNstripped disks. It also sounds that if we use the stripped ones, the dbimport also VERY slow. So he is considering to remake the disks(DDN.....), i.e., not stripe them. Do we have similar experience? Thanks, Frank Art S. Kagel wrote: >Neil Truby wrote: > > >>"Art S. Kagel" <kagel@bloomberg.net> wrote in message >>news:4514133B.2090901@bloomberg.net... >> >> >> >>>Yunyao (Frank) Qu wrote: >>> >>> >>> >>>>We use raws stripped disk. IDS10 UC5, AIX 5.3 >>>> >>>>onspaces utility runing very slow, how can we speed it up? >>>> >>>>example, >>>>onspaces -c -d dbphylog -p /usr/informix/dev-links/int1/DBPHYLOG_INT1 -o >>>>4 -s 896000 -m /usr/informix/dev-links/int1/MDBPHYLOG_INT1 4>>>> >>>> >>>Pretty much the only useful answer is: "Get faster disks." To create a >>>dbspace onspaces has to initialize a large portion of the disk chunk being >>>presented. That just takes time dependent on how fast your disk farm is. >>> >>> >>Do you think so? Initialisation of raw disk should be more-or-less >>instantaneous, because IDS doesn't have to write all the binary zeros that >>it would to a cooked chunk. >> >>But even with a cooked chunk you'd not expect 900m to take more than a >>minute or two ... >> >> > >Frank doesn't say "it's taking hours". He said it's 'slow'. Is a minute or >two 'slow'? > >Besides for 10.00 there's a larger default tablespace tablespace to write >out in the first chunk of a new dbspace. > >Art S. Kagel >_______________________________________________ >Informix-list mailing list >Informix-list@iiug.org >http://www.iiug.org/mailman/listinfo/informix-list > > >

"Yunyao (Frank) Qu" <Yunyao.Qu@noaa.gov> wrote in message news:mailman.544.1158950128.20706.informix-list@iiug.org... > Art and Neil, > > It took about 20 minutes to initialize a 10 Gig dbspace. > > I just talked to SysAdmin. He thinks that the stripped raw disks may > be the reason. > Since it only takes 5 minutes to initialize the same size of disk with > the UNstripped disks. > > It also sounds that if we use the stripped ones, the dbimport also VERY > slow. > > So he is considering to remake the disks(DDN.....), i.e., not stripe > them. > > Do we have similar experience? Has he initialised the aio module? It isn't enabled by default in AIX 5. Can you send the output from onstat -g iov please?

informix@erika $ onstat -g iov IBM Informix Dynamic Server Version 10.00.UC4 -- On-Line -- Up 04:22:38 -- 1974544 Kbytes AIO I/O vps:class/vp s io/s totalops dskread dskwrite dskcopy wakeups io/wup errors kio 0 i 0.2 3468 1133 2335 0 12232 0.3 0 kio 1 i 0.0 153 16 137 0 2024 0.1 0 kio 2 s 197.2 3108094 1553355 1554739 0 5765026 0.5 0 kio 3 i 0.0 1 0 1 0 4 0.2 0 msc 0 i 0.0 33 0 0 0 32 1.0 0 aio 0 i 0.1 1699 1464 2 0 1700 1.0 0 aio 1 i 0.0 0 0 0 0 1 0.0 0 pio 0 i 0.0 1 0 0 0 2 0.5 0 pio 1 i 0.0 0 0 0 0 1 0.0 0 lio 0 i 0.0 1 0 0 0 2 0.5 0 lio 1 i 0.0 0 0 0 0 1 0.0 0 Neil Truby wrote: >"Yunyao (Frank) Qu" <Yunyao.Qu@noaa.gov> wrote in message >news:mailman.544.1158950128.20706.informix-list@iiug.org... > > >>Art and Neil, >> >>It took about 20 minutes to initialize a 10 Gig dbspace. >> >>I just talked to SysAdmin. He thinks that the stripped raw disks may >>be the reason. >>Since it only takes 5 minutes to initialize the same size of disk with >>the UNstripped disks. >> >>It also sounds that if we use the stripped ones, the dbimport also VERY >>slow. >> >>So he is considering to remake the disks(DDN.....), i.e., not stripe >>them. >> >>Do we have similar experience? >> >> > >Has he initialised the aio module? It isn't enabled by default in AIX 5. >Can you send the output from onstat -g iov please? > > >_______________________________________________ >Informix-list mailing list >Informix-list@iiug.org >http://www.iiug.org/mailman/listinfo/informix-list > > > -