HPL onpload unload 2gig limitation
I've read that the 2 gigabyte file limit for unloading data using the HPL utility is a result of the host file system. I'm running HP-UX 11.0.B and have set the "Allow Large Files" option to yes on the file system I'm unloading to. Still I'm running into the limitation. Below is the last few lines of my log file. Suggestions=3F =20 =20 18:26:08 Records Processed -> 17380000 18:26:10 Records Processed -> 17390000 Cannot write file /HPLTest/cost.unl - aio error code 27 Database Unload Completed -- Unloaded 17393357 Records Detected 0 Errors Tue Sep 21 18:26:12 2004 =20 Anthony Ojeda=20 Sr. Systems Administrator=20 =20 LATHAM & WATKINS LLP=20 555 W. 5th Street, Suite 800=20 Los Angeles, CA 90013-1010=20 Direct Tel: (213) 891-7211=20 =46ax: (213) 891-7123=20 E-mail: anthony.ojeda@lw.com=20 www.lw.com <http://www.lw.com/>; =20 =20 This email may contain material that is confidential, privileged and/or = attorney work product for the sole use of the intended recipient. Any = review, reliance or distribution by others or forwarding without express = permission is strictly prohibited. If you are not the intended recipient, = please contact the sender and delete all copies. Latham & Watkins LLP
What
version of Informix are you on, that 2 GB limit for utilities
doesn't go away till 9.4
-----Original Message-----
From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org] On
Behalf Of Anthony.Oje....
Sent: Tuesday, September 21, 2004 8:39 PM
To: ids@iiug.org
Subject: HPL onpload unload 2gig limitation [3454]
I've read that the 2 gigabyte file limit for unloading data using the
HPL utility is a result of the host file system. I'm running HP-UX
11.0.B and have set the "Allow Large Files" option to yes on the file
system I'm unloading to. Still I'm running into the limitation.
Below is the last few lines of my log file. Suggestions=3F =20 =20
18:26:08 Records Processed -> 17380000
18:26:10 Records Processed -> 17390000
Cannot write file /HPLTest/cost.unl - aio error code 27
Database Unload Completed -- Unloaded 17393357 Records Detected 0 Errors
Tue Sep 21 18:26:12 2004
=20
Anthony Ojeda=20
Sr. Systems Administrator=20
=20
LATHAM & WATKINS LLP=20
555 W. 5th Street, Suite 800=20
Los Angeles, CA 90013-1010=20
Direct Tel: (213) 891-7211=20
=46ax: (213) 891-7123=20
E-mail: anthony.ojeda@lw.com=20
www.lw.com <http://www.lw.com/>; =20
=20
This email may contain material that is confidential, privileged and/or
= attorney work product for the sole use of the intended recipient. Any
= review, reliance or distribution by others or forwarding without
express = permission is strictly prohibited. If you are not the
intended recipient, = please contact the sender and delete all copies.
Latham & Watkins LLP
-----------------------------------------
============================================================ The
information contained in this message may be privileged and confidential
and protected from disclosure. If the reader of this message is not the
intended recipient, or an employee or agent responsible for delivering
this message to the intended recipient, you are hereby notified that any
reproduction, dissemination or distribution of this communication is
strictly prohibited. If you have received this communication in error,
please notify us immediately by replying to the message and deleting it
from your computer. Thank you. Tellabs
============================================================