Is there a limit for sequential file size ??

weiven · Post by **weiven** » Mon Oct 25, 2004 2:15 am

Im trying to load a 23,222KB of sequential source file to the Oracle9i.
While running, it prompt me an error:

oraS_AGNTPF_VEN3,0: Export failed
oraS_AGNTPF_VEN3,0: write() failed: Broken pipe APT_CombinedOperatorController(1),0: Operator's runLocally() failed
APT_CombinedOperatorController(1),0: Operator terminated abnormally: runLocally did not return APT_StatusOk

**(which is not the connection problem)

so for tat, i try to minimize the file size 10 KB and it can load but i wanted to load a bigger file size.

Can anyone tell me about this?

tonystark622 · Post by **tonystark622** » Mon Oct 25, 2004 8:28 am

The only limit for file sizes with DataStage the operating system file size limit.

Tony

ogmios · Post by **ogmios** » Mon Oct 25, 2004 3:02 pm

And it's usually 2Gb, 4Gb or even larger on the newer systems.

Maybe you're passing data that is larger than the defined lengths in DataStage?

Ogmios

sushanth · Post by **sushanth** » Tue Oct 26, 2004 3:31 am

Check the datatype size at source and target file

mandyli · Post by **mandyli** » Tue Oct 26, 2004 11:05 pm

HI

what is OS unix or NT. b'cus file size some time differ based on OS.

or if use Dataset for large no of Data.

please try it.

Thanks
Man

DSXchange

Is there a limit for sequential file size ??

Is there a limit for sequential file size ??

Re: Is there a limit for sequential file size ??