IDS Forum

Re: Onbar Block Size

Posted By: Informix DBA
Date: Monday, 24 June 2013, at 2:09 p.m.

In Response To: Re: Onbar Block Size (John Miller iii)

Thank you John. We are looking for the block size of the data getting
written to disk by Informix when doing an OnBar restore.

--Dave

On Mon, Jun 24, 2013 at 1:53 PM, John Miller iii <miller3@us.ibm.com> wrote:

> The blocksize upon which the informix server send/receives the data to/from
> the storage manager is defined by the onconfig BAR_XFER_BUF_SIZE. This
> is not the size the servers reads/writes data, but rather the buffer
> size the interacts with the storage manager.
>
> # 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.
> # If PSM is the storage manager, higher values
> # can be used.
>
> John F. Miller III
> STSM, Lead Architect
> miller3@us.ibm.com
> 503-747-1366
> IBM Informix Dynamic Server (IDS)
>
> ids-bounces@iiug.org wrote on 06/24/2013 10:19:17 AM:
>
> > From: "Informix DBA" <in4mixdba@gmail.com>
> > To: ids@iiug.org,
> > Date: 06/24/2013 10:26 AM
> > Subject: Re: Onbar Block Size [30622]
> > Sent by: ids-bounces@iiug.org
> >
> > Thank you. Though we are wondering what is the block size when doing an
> > onbar restore to the raw disks. The DB must be writing data to the disk
> in
> > certain block sizes. Our storage vendor has requested this information to
>
> > help properly tune the storage. Is the DB writing the onbar restore data
> > in 2k, 4k block sizes or a different size?
> >
> > --Dave
> >
> > On Mon, Jun 24, 2013 at 1:11 PM, Art Kagel <art.kagel@gmail.com> wrote:
> >
> > > As Alexandre tried to point out, onbar doesn't ever write to the
> archive
> > > output, that is the job of the storage manager, so look to how your
> storage
> > > manager is configured.
> > >
> > > As a side note: block size is rarely relevant when writing archives out
> to
> > > disk and reading them back in, only when writing to to tape.
> > >
> > > Art
> > >
> > > Art S. Kagel
> > > Advanced DataTools (www.advancedatatools.com)
> > > Blog: http://informix-myview.blogspot.com/
> > >
> > > Disclaimer: Please keep in mind that my own opinions are my own
> opinions
> > > and do not reflect on my employer, Advanced DataTools, the IIUG, nor
> any
> > > other organization with which I am associated either explicitly,
> > > implicitly, or by inference. Neither do those opinions reflect those of
>
> > > other individuals affiliated with any entity with which I am affiliated
> nor
> > > those of the entities themselves.
> > >
> > > On Mon, Jun 24, 2013 at 1:05 PM, Informix DBA <in4mixdba@gmail.com>
> wrote:
> > >
> > > > We have BAR_XFER_BUF_SIZE set to 31. We have 2,4 & 8 k page sizes for
> the
> > > > various DBSPACES. Though what size is onbar writing it to the disk?
> > > >
> > > > --Dave
> > > >
> > > > On Mon, Jun 24, 2013 at 12:51 PM, Alexandre Marini
> <alexandre@briug.org
> > > > >wrote:
> > > >
> > > > > Hello.
> > > > > You should look for the block size transfer generally, in your SM
> > > > software
> > > > > documentation.
> > > > > Informix is configurable, through BAR_XFER_BUF_SIZE onconfig
> variable
> > > you
> > > > > can
> > > > > adjust to your SM.
> > > > > 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.
> > > > >
> > > > > Paralel backups and restores are also configurable in Informix
> side,
> > > > which
> > > > > can
> > > > > speed up your backup/restore process.
> > > > >
> > > > > Also pay attention to your OFF_RECVRY_THREADS configuration. In
> case
> > > of a
> > > > > cold
> > > > > restore, it would also speed up your logical recovery process.
> > > > >
> > > > > More details can be obtained from your Informix Information Center
> > > > website.
> > > > >
> > > > > Hope it helps.
> > > > > Regards.
> > > > >
> > > > > Alexandre Marini
> > > > > IBM Informix Certified Professional v10 / v11.50 / v11.70
> > > > >
> > > > > IBM Information Management Informix Technical Professional
> > > > >
> > > > > IBM Infosphere DataStage Technical Professional
> > > > > Informix Senior DBA - Orizon Brasil
> > > > > BRIUG website administrator
> > > > > Informix independent consultant
> > > > >
> > > > > > To: ids@iiug.org
> > > > > > From: in4mixdba@gmail.com
> > > > > > Subject: Onbar Block Size [30613]
> > > > > > Date: Mon, 24 Jun 2013 11:51:44 -0400
> > > > > >
> > > > > > Hello,
> > > > > >
> > > > > > Running 11.50.FC6. Does anyone know what the block size is (of
> data
> > > > > > getting written to disk) when running an onbar restore?
> > > > > >
> > > > > > --Dave
> > > > > >
> > > > > > --001a11c32ed8e9e93d04dfe86248
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
>
>
> *******************************************************************************
>
> > > > > > Forum Note: Use "Reply" to post a response in the discussion
> forum.
> > > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
>
>
> *******************************************************************************
>
> > > > > Forum Note: Use "Reply" to post a response in the discussion forum.
>
> > > > >
> > > > >
> > > >
> > > > --001a11c36b307d3f5004dfe96afe
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
>
>
> *******************************************************************************
>
> > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > >
> > > >
> > >
> > > --089e0158acf057671e04dfe981b6
> > >
> > >
> > >
> > >
> >
>
>
> *******************************************************************************
>
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> > --001a11c3ecde8d2d6804dfe99b78
> >
> >
> >
>
>
> *******************************************************************************
>
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--001a11c32ed89d7ccb04dfea4f3c

Messages In This Thread

• Onbar Block Size
  Informix DBA -- Monday, 24 June 2013, at 11:51 a.m.
  • RE: Onbar Block Size
    Alexandre Marini -- Monday, 24 June 2013, at 12:51 p.m.
    • Re: Onbar Block Size
      Informix DBA -- Monday, 24 June 2013, at 1:05 p.m.
      • Re: Onbar Block Size
        Art Kagel -- Monday, 24 June 2013, at 1:11 p.m.
        • Re: Onbar Block Size
          Informix DBA -- Monday, 24 June 2013, at 1:19 p.m.
          • Re: Onbar Block Size
            Art Kagel -- Monday, 24 June 2013, at 1:22 p.m.
          • Re: Onbar Block Size
            John Miller iii -- Monday, 24 June 2013, at 1:53 p.m.
            • Re: Onbar Block Size
              Informix DBA -- Monday, 24 June 2013, at 2:09 p.m.
              • Re: Onbar Block Size
                John Miller iii -- Monday, 24 June 2013, at 4:13 p.m.
                • Re: Onbar Block Size
                  david@smooth1.co.uk -- Tuesday, 25 June 2013, at 4:29 p.m.
                  • Re: Onbar Block Size
                    JACQUES RENAUT -- Tuesday, 25 June 2013, at 4:53 p.m.
                    • Re: Onbar Block Size
                      Fernando Nunes -- Tuesday, 25 June 2013, at 7:00 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.