TAPESIZE parm on INS 9.4 FC2X1

Hello everyone. I have a IDS 9.4 database configured so that the backups (we use ontape) get written to a disk file. The TAPESIZE parm is currently set to 8192000 (IE: 8 gig). the database just exceeded that amount during a recent lev 0 so I need to increase this value. The server is AIX 5.2 I was thinking of doubling this parm to be 16384000 (16 gig). Does anyone know of any 'gotchas' either informix related or unix related to be necessarily concerned about? Thanks

Will - I am not sure if this applies on v9 - you'll need to check, but on v10 you can set TAPEDEV to 0 and it will allow the backup process to write as much data as the backup device will support - so if you had a giant file system to backup to you would not have to worry about tweaking TAPEDEV to keep up with an expanding data set - until it grew larger than the file system of course. MM

Two plus years ago, I migrated a 120GB database via that method (No tape drives on destination server).... I set the TAPESIZE to 150GB... Remember to adjust the Block size for performance... It wasn't the fastest due to network traffic, but it DID work.... -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of WILL LANDSTROM Sent: Tuesday, April 29, 2008 1:23 PM To: ids@iiug.org Subject: TAPESIZE parm on INS 9.4 FC2X1 [11923] Hello everyone. I have a IDS 9.4 database configured so that the backups (we use ontape) get written to a disk file. The TAPESIZE parm is currently set to 8192000 (IE: 8 gig). the database just exceeded that amount during a recent lev 0 so I need to increase this value. The server is AIX 5.2 I was thinking of doubling this parm to be 16384000 (16 gig). Does anyone know of any 'gotchas' either informix related or unix related to be necessarily concerned about? Thanks ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!! Please do not transmit orders or instructions regarding a UBS account by e-mail. The information provided in this e-mail or any attachments is not an official transaction confirmation or account statement. For your protection, do not include account numbers, Social Security numbers, credit card numbers, passwords or other non-public information in your e-mail. Because the information contained in this message may be privileged, confidential, proprietary or otherwise protected from disclosure, please notify us immediately by replying to this message and deleting it from your computer if you have received this communication in error. Thank you. UBS Financial Services Inc. UBS International Inc. UBS Financial Services Incorporated of Puerto Rico

On 29/04/2008, MIKE MAGIE <jmmagie@yahoo.com> wrote: > Will - > > I am not sure if this applies on v9 - you'll need to check, but on v10 you can > set TAPEDEV to 0 and it will allow the backup process to write as much data as > the backup device will support - so if you had a giant file system to backup > to you would not have to worry about tweaking TAPEDEV to keep up with an > expanding data set - until it grew larger than the file system of course. > > MM > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > See you at the IIUG Informix 2008 Conference > The Power Conference for Informix Professionals > April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas > http://www.iiug.org/conf > Registration Now Open!! > Will Tape Size of zero is not an option on IDS9, 16Gb should be OK provided the O/S ulimit setting for the running user allows files of this size. Keith

In my earlier response I mistakenly wrote TAPEDEV where I meant to write TAPESIZE - I understand that this feature (setting TAPESIZE to 0) is not available until 10.00 but I didn't want my typos to confuse anyone... MM > Will - > > I am not sure if this applies on v9 - you'll need to check, but on v10 you can > set TAPEDEV to 0 and it will allow the backup process to write as much data as > the backup device will support - so if you had a giant file system to backup > to you would not have to worry about tweaking TAPEDEV to keep up with an > expanding data set - until it grew larger than the file system of course. > > MM > > >

Mike. 9.4 does support TAPEISZE 0. Thanks, I'll give that a shot