Oninit cdi / Archive
Talk to an expert →

RE: onunload limit

Posted in 2006

Topics: Migration, Import/Export & Data Conversion, Platform-Specific Issues

Mike Badar — — source: Usenet: comp.databases.informix

Maybe the filesystem is limited to 2GB. Try creating a file > 2GB using 'dd': bobby:/bb1/pgaa> dd if=/dev/zero of=/bb1/pgaa/testfile bs=16k count=196608 196608+0 records in. 196608+0 records out. bobby:/bb1/pgaa> ls -l total 6291480 drwxrwxr-x 5 bobby gizadm 256 Oct 04 12:16 apps/ drwxrwxr-x 3 bobby gizadm 256 Dec 31 13:22 data/ drwxrwxr-x 2 bobby gizadm 256 Oct 29 12:15 maps/ drwxrwxr-x 2 bobby gizadm 256 Oct 25 15:08 prj_files/ drwxrwxr-x 43 bobby gizadm 8192 Jan 11 07:24 ref_data/ -rw-r--r-- 1 bobby gizadm 3221225472 Jan 18 14:29 testfile bobby:/bb1/pgaa> If 'dd' fails when the filesize reaches 2GB, your filesystem is incapable of supporting 2GB+ file sizes. Mike Badar ESRI Professional Services 1 International Ct. Broomfield, CO 80021 mbadar@esri.com 303-449-7779 www.esri.com > -----Original Message----- > From: informix-list-bounces@iiug.org > [mailto:informix-list-bounces@iiug.org] On Behalf Of rotor > Sent: Tuesday, November 07, 2006 8:34 AM > To: informix-list@iiug.org > Subject: onunload limit > > Good day. > > Description. > I have 80Gb DB on Linux, and want to onunload it to file. I've tried > command "onunload -t file_name -s 100000000 db_name" but have got an > error "Error writing to tape device, Error No. = 27." exactly when > file size become 2147483136 bytes. > > Question. > Does this mean that there is some limitations in onunload utility > and this is not possible to onunload DB with size more than 2Gb to a > regular OS file? > > Details. > onstat - > IBM Informix Dynamic Server Version 7.31.UD8 -- On-Line -- Up 12 > days 03:24:24 -- 986928 Kbytes > uname -a > Linux persey.dati.lv 2.4.21-4.ELsmp #1 SMP Fri Oct 3 17:32:58 EDT > 2003 x86_64 x86_64 x86_64 GNU/Linux > > Tanks. > --> Бесплатный почтовый ящик предоставлен http://pasts.delfi.lv > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >

↪ replying to Mike Badar
Doug Lawry — — source: Usenet: comp.databases.informix

Also check that the Linux "ulimit -f" command returns "unlimited". If not, try running as "root" after entering "ulimit -f unlimited". -- Regards, Doug Lawry www.douglawry.webhop.org "Mike Badar" <mbadar@esri.com> wrote in message news:mailman.219.1162913850.29126.informix-list@iiug.org... Maybe the filesystem is limited to 2GB. Try creating a file > 2GB using 'dd': bobby:/bb1/pgaa> dd if=/dev/zero of=/bb1/pgaa/testfile bs=16k count=196608 196608+0 records in. 196608+0 records out. bobby:/bb1/pgaa> ls -l total 6291480 drwxrwxr-x 5 bobby gizadm 256 Oct 04 12:16 apps/ drwxrwxr-x 3 bobby gizadm 256 Dec 31 13:22 data/ drwxrwxr-x 2 bobby gizadm 256 Oct 29 12:15 maps/ drwxrwxr-x 2 bobby gizadm 256 Oct 25 15:08 prj_files/ drwxrwxr-x 43 bobby gizadm 8192 Jan 11 07:24 ref_data/ -rw-r--r-- 1 bobby gizadm 3221225472 Jan 18 14:29 testfile bobby:/bb1/pgaa> If 'dd' fails when the filesize reaches 2GB, your filesystem is incapable of supporting 2GB+ file sizes. Mike Badar ESRI Professional Services 1 International Ct. Broomfield, CO 80021 mbadar@esri.com 303-449-7779 www.esri.com > -----Original Message----- > From: informix-list-bounces@iiug.org > [mailto:informix-list-bounces@iiug.org] On Behalf Of rotor > Sent: Tuesday, November 07, 2006 8:34 AM > To: informix-list@iiug.org > Subject: onunload limit > > Good day. > > Description. > I have 80Gb DB on Linux, and want to onunload it to file. I've tried > command "onunload -t file_name -s 100000000 db_name" but have got an > error "Error writing to tape device, Error No. = 27." exactly when > file size become 2147483136 bytes. > > Question. > Does this mean that there is some limitations in onunload utility > and this is not possible to onunload DB with size more than 2Gb to a > regular OS file? > > Details. > onstat - > IBM Informix Dynamic Server Version 7.31.UD8 -- On-Line -- Up 12 > days 03:24:24 -- 986928 Kbytes > uname -a > Linux persey.dati.lv 2.4.21-4.ELsmp #1 SMP Fri Oct 3 17:32:58 EDT > 2003 x86_64 x86_64 x86_64 GNU/Linux > > Tanks.

↪ replying to Doug Lawry
Ben Thompson — — source: Usenet: comp.databases.informix

Doug Lawry wrote: > Also check that the Linux "ulimit -f" command returns "unlimited". If not, try > running as "root" after entering "ulimit -f unlimited". On v7 (OP has 7.31.UD8) as another poster has kindly pointed out, you cannot access files larger than 2Gb with a 32-bit release. It's not an OS limitation so there's no point checking that 'dd' will create files bigger than 2Gb - it probably will. You can write more than 2Gb if it is to a real tape device though. It's a pain and is one of the reasons to upgrade to v9/10. Regards, Ben.

↪ replying to Mike Badar
Neil Truby — — source: Usenet: comp.databases.informix

"Mike Badar" <mbadar@esri.com> wrote in message news:mailman.219.1162913850.29126.informix-list@iiug.org... >> Maybe the filesystem is limited to 2GB. Try creating a file > 2GB using >> 'dd': >> If 'dd' fails when the filesize reaches 2GB, your filesystem is incapable >> of supporting 2GB+ file sizes. ... although as Superboer points out IDS v7 will still impose a 2g limit. As he's using Linux, he could unload to raw disk. He'd be OK then.

Glossary