Oninit cdi / Archive
Talk to an expert →

Adding chunk using files with pre-allocated space

Posted in 2010

Topics: High Availability & Replication, Performance & Tuning, Storage & Space Management

KAMRAN HAQ — — source: IIUG Forums & Mailing Lists

Hi, We face slow transaction response while adding dbspace chunks. Performance degrades while newly added file is building up (capturing space) on HDR secondary and RSS nodes. We test in local test environment that this slow response can be avoided if we pre-allocate the space to files before adding as dbspace chunk using "dd" command like "dd if=/dev/zero of=file_to-create bs=2K count=102400" on all "Mach 11" nodes. We are hesitating to practice it on production. We need experts' opinion that there is no risk to add a dbspace chunk this way. regards, Kamran

↪ replying to KAMRAN HAQ
Art Kagel — — source: IIUG Forums & Mailing Lists

Preallocating the storage for the file is just fine for production chunks. No worries. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) 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, Nov 1, 2010 at 9:03 AM, KAMRAN HAQ <khaq@i2cinc.com> wrote: > Hi, > We face slow transaction response while adding dbspace chunks. Performance > degrades while newly added file is building up (capturing space) on HDR > secondary and RSS nodes. > We test in local test environment that this slow response can be avoided if > we > pre-allocate the space to files before adding as dbspace chunk using "dd" > command like "dd if=/dev/zero of=file_to-create bs=2K count=102400" on all > "Mach 11" nodes. > We are hesitating to practice it on production. We need experts' opinion > that > there is no risk to add a dbspace chunk this way. > > regards, > Kamran > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --00163630fab1d01fdd0493fdede2

Glossary