Re: Dbexport
David Williams wrote:
>
> In article <63ku36$6e1@cssun.mathcs.emory.edu>,
> mbaumgartner@cardhealth.com writes
> >
> >Last week there was a thread that asked how long it would take to dbexport a 28
> >Gig db. Well this past weekend we were trying to dbexport a 68 Gig db only to
> >have it blow up when one of the .unl files reached 2 Gig.
> >
> >We are running on HP/UX 10.20, ODS 7.14 UC1. The Unix ulimit is set to
> >unlimited and we are able to create a file on the file system larger than 2 Gig
> >using Unix utilities.
> >
> But not with Informix. Informix does not support files/devices > 2Gig.
>
> [...]
> >
> >Has anyone experienced this problem before? As with most of us, we are on a very
> >tight time frame to migrate off our existing drives.
> >
> >Thanks In Advance,
> >
> >Mark
> >Cardinal Health
> >
> >
>
> --
> David Williams
This seems to be a general problem: when doing dbexport to tape (under
5.03), Informix wraps the tape length around 2GB (I discovered this
when I specified that my 4-something gig tape has 4000000 k; dbexport
asked for another tape very soon; I dumped original one and found 854272
k written in the header.)
BTW, you just might be able to export your database to tapes (a lot of
them), since it will split long unload files between volumes. However,
be sure to have a good, 'normal' level 0 backup, just in case...
Regards,
Dragi "Bonzi" Raos
+--------------------------------------------------------+
| 4-MATE Information Engineering Inc. |
+--------------------------+-----------------------------+
| 4-MATE | Tel: +385 (1) 242-116 |
| Kosa bb | +385 (1) 242-126 |
| 10000 Zagreb | Fax: +385 (1) 242-121 |
| Hrvatska (Croatia) | e-mail: bonzi@4mate.hr |
| | URL: http://www.4mate.hr |
+--------------------------+-----------------------------+