Archive to disk to iSCSI device Answered: amber (solid confidence) — Two concrete, actionable answers given (the TAPESIZE onconfig setting to avoid the old 2GB archive-to-disk file limit, and checking ulimit/large-file filesystem support); the asker plans to test but the thread ends before reporting back.

Advisory only.

Posted in 2007

Summary

Pete asked whether anyone archived to disk over iSCSI on AIX 5.2 with Informix 9.4, worried that 2 GB file limits would mean 160 files for a 320 GB database. Art Kagel said 9.40 has no such limit and suggested TAPESIZE 400000000. David Link advised checking ulimit and that the filesystem is large-file enabled. Pete planned to test and report back; no result in the thread.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: Platform-Specific Issues

Pete — Fri, 21 Dec 2007 04:20:24 -0800 (PST) — source: Usenet: comp.databases.informix

Has anyone used an iSCSI connection on AIX 5.x to perform "archive to disk"? And if so, as far as I know, doing this still has to be in 2gb files due to limitations on disk. If that is the case, I would have 160 2gb files since our database is approx 320gb. Restore would be a nightmare! Anybody currently doing this? We are currently running Informix 9.4 (yeah, yeah, we're working on upgrading to IDS10 or maybe even IDS11, but it is what it is now) on a P550 running AIX 5.2. Thanks in advance, Pete

↪ replying to Pete

Art S. Kagel — Fri, 21 Dec 2007 06:14:03 -0800 (PST) — source: Usenet: comp.databases.informix

On Dec 21, 7:20 am, Pete <pete.dickson....@gmail.com> wrote: > Has anyone used an iSCSI connection on AIX 5.x to perform "archive to > disk"? Not I. > And if so, as far as I know, doing this still has to be in 2gb files > due to limitations on disk. If that is the case, I would have 160 2gb > files since our database is approx 320gb. Restore would be a > nightmare! Anybody currently doing this? AFAIK 9.40 does not have the 2GB file size limitation. You should be able to set TAPESIZE to 400000000 and be good to go. > We are currently running Informix 9.4 (yeah, yeah, we're working on > upgrading to IDS10 or maybe even IDS11, but it is what it is now) on a > P550 running AIX 5.2. > > Thanks in advance, > Pete Art S. Kagel

↪ replying to Pete

Link, David A — Fri, 21 Dec 2007 10:03:34 -0600 — source: Usenet: comp.databases.informix

Couple of things I can think of to check are what is your ulimit set to on the OS side of the fence and is your filesystem large file enabled (not sure about this one but I think that there is a different filesystem you can create to allow huge files to be created) -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Pete Sent: Friday, December 21, 2007 6:20 AM To: informix-list@iiug.org Subject: Archive to disk to iSCSI device Has anyone used an iSCSI connection on AIX 5.x to perform "archive to disk"? And if so, as far as I know, doing this still has to be in 2gb files due to limitations on disk. If that is the case, I would have 160 2gb files since our database is approx 320gb. Restore would be a nightmare! Anybody currently doing this? We are currently running Informix 9.4 (yeah, yeah, we're working on upgrading to IDS10 or maybe even IDS11, but it is what it is now) on a P550 running AIX 5.2. Thanks in advance, Pete _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list

↪ replying to Link, David A

Pete — Fri, 21 Dec 2007 08:53:35 -0800 (PST) — source: Usenet: comp.databases.informix

Thanks for the quick responses. Going to do some testing on Monday and I'll post back what I ran into, whether it's positive or negative. Going to be interesting since the iSCSI hardware is a windows server with a RAID. I'll proably get AIX support involved as well just to make sure the hdisk is setup/created correctly, large file enabled, etc. Pete