Limitation ON Bteq Export

UDA
N/A

Limitation ON Bteq Export

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
5 REPLIES

Re: Limitation ON Bteq Export

Are you hitting the MP-RAS 2GB file limit ?
N/A

Re: Limitation ON Bteq Export

erroring out after 4.5GB size(24 M). what is MP-RAS ?

Re: Limitation ON Bteq Export

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 !

N/A

Re: Limitation ON Bteq Export

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

Re: Limitation ON Bteq Export

Sorry mate, no idea.