ONBAR performance tuning
Hello All,
Is there any way to tune the performance of backup/restore using onbar and
ontape?
Hello.
Of course you could use onbar (recommended). I recommend the use of
paralel backups for your dbspaces (if you have a large instance),
and tune your tape parameters (block transfer size), according to your
backup server capacity.
Check the Information Center according to your Informix version, backup
parameters are there. (you didn´t mentioned)
Regards!
Em 07/06/2011 10:35, KHURRAM SHAHZAD escreveu:
> Hello All,
>
> Is there any way to tune the performance of backup/restore using onbar and
> ontape?
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--
Alexandre Marini
Tecnologia da Informação - DBA
msn: alexandre_marini@hotmail.com
SEFAZ-MS / SGI-UGSR / Sistemas IBM-Informix
Cert-Info-Mgmt_color <Cert-Info-Mgmt_color.jpg>
IBM Certified System Administrator - Informix Dynamic Server V10 / V11
The biggest issue is to make sure your aio/kaio is up to the test.
Archives
add a lot of I/O which does not typically exist during normal production.
Second look at the transfer block size and the number of buffers.
onbar
=====# BAR_NB_XPORT_COUNT - Specifies the number of data buffers that
# each onbar_d process uses to communicate
# with the database server
# BAR_XFER_BUF_SIZE - The size, in pages, of each data buffer.
# Acceptable values are 1 through 15 for
# 4 KB pages and 1 through 31 for 2 KB pages.
ontape
======TAPEBLK ==> onconfigARCHIVE_BUF_COUNT ==> environment variable set when starting ontape
default is 3
John F. Miller III
STSM, Embedability Architect
miller3@us.ibm.com
503-578-5645
IBM Informix Dynamic Server (IDS)
ids-bounces@iiug.org wrote on 06/07/2011 07:35:51 AM:
> [image removed]
>
> ONBAR performance tuning [23932]
>
> KHURRAM SHAHZAD
>
> to:
>
> ids
>
> 06/07/2011 07:37 AM
>
> Sent by:
>
> ids-bounces@iiug.org
>
> Please respond to ids
>
> Hello All,
>
> Is there any way to tune the performance of backup/restore using onbar
and
> ontape?
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>