|
|
|
Junior Member
 
Group: Forum Members
Last Login: 3/27/2008 11:31:18 AM
Posts: 19,
Visits: 25
|
|
Hello,
i am trying to export 34M records into a flat file of record length 97 using BTEQ export.
I am getting error after exporting 24M records and says "output FIle is to large"
Please let me know if there is any limitation on bteq export and also any alternative for this.
thanks,
Sparan
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 10/11/2006 6:05:00 AM
Posts: 23,
Visits: 1
|
|
|
Are you hitting the MP-RAS 2GB file limit ?
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 3/27/2008 11:31:18 AM
Posts: 19,
Visits: 25
|
|
|
erroring out after 4.5GB size(24 M). what is MP-RAS ?
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 10/11/2006 6:05:00 AM
Posts: 23,
Visits: 1
|
|
MP-RAS is the 'flavour' of UNIX used on the Teradat box. It's a bit old and has a 2GB limitation on the size of any files.
Quick bit of maths makes me think you may indeed have hit the 2GB limit...
24,000,000 * 97 = 2,328,000,000 (to give the number of exported bytes).
2,328,000,000 / 1,073,741,824 = 2.2 (to give the number of exported GBs)
You could try breaking your export job into 2 or 3 parts, or run your script from, say, a LINUX box connected to the Teradata box, or if you're also channel-attached, you could export to an MVS dataset.
Having said all that, if you're certain you've got up to 4.5GB output, then I'm stumped 
Good luck !
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 3/27/2008 11:31:18 AM
Posts: 19,
Visits: 25
|
|
you are correct. it seems we have MP-RAS.
i used fastexport to solve this problem.
one more, is there any chance to get octal delimiter "\001" in the fastexport script.
thanks a lot,
Sparan
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 10/11/2006 6:05:00 AM
Posts: 23,
Visits: 1
|
|
|
|
|