Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Informix > Re: help with s...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 1 Topic 14089 of 15119
Post > Topic >>

Re: help with slow archive please

by Tilman Model-Bosch <tilleul17@[EMAIL PROTECTED] > May 21, 2008 at 04:41 PM

Floyd Wellershaus wrote:
> we have had some network issues.
> The sars don't look different or excessive.
> We are doing a full archive every night, and the database hasn't grown
> much since last week, so that's not it.
> 
> I am trying to be able to intrpret the onstat -g stq so that I can
> hopefully see if the tape drive may be the bottleneck or the server end.
> 
> Thanks,
> floyd

Haven't done it in a while (no backup performance problems to 
interprete) but If I recall it correctly:

full queue is where arcbackup1 has put data to get backed up . Empty 
queue is where there are backup buffers for arcbackup1 to get grabbed 
for additional pages.

So if you see almost always buffers in full queue (and waiters on empty 
queue) I'd assume that the storage manager (or XBSA interface) does not 
grab the data quick enough for IDS. --> search for problems downstream 
of onbar (i.e. , network , storage manager, tape library...).
If it is almost always empty queue which has all the buffers, arcbackup1 
does not deliver fast enough. --> IDS or chunk disk subsystem not fast 
enough.
If it is the later case, check read performance on all the chunks.

Here is a little UNIX command to help you doing a dd on all chunks.
It dumps the dd commands to a file called ddfile , assumes 2k pages size 
and you need to replace <chunk> with something that greps all and only 
your chnks in the onstat -d output.
(If you have other page sizes adjust bs, and the factor to calculate 
count and skip in the awk command)
NB! There are probably better and more sophisticated ways out there , 
but its a quick way to *****s disk speed for IDS.
!Disclaimer: AS-IS, no warranty, no liablibilty , not tested 
extensively! )

onstat -d | grep <chunk> | tr -s ' ' | cut -f 4,5,6,8 -d' ' | awk 
'{skip=$1/2; count=($2-$3)/2;  printf "dd if="$4" of=/dev/null bs=2k 
skip=%d count=%d",skip, count ; print ""}' >ddfile


HTH
Tilman
 




 1 Posts in Topic:
Re: help with slow archive please
Tilman Model-Bosch <ti  2008-05-21 16:41:29 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Tue Dec 2 23:31:54 CST 2008.