bcp file size

[unknown]

Is there a limit on how big a file can be when bcping out
data? I'm trying to bcp out a large file and it keeps
failing. I get to 12356000 rows then I get the message:

successfully bulk-copied to host-file.
Error: Writing BCP file (0)!
bcp copy out partially failed

Disk space on my server looks fine. I'm running Sybase
12.0.

Thanks.

[Bret Halford]

How big is the file at that point?

I'd expect a 2- or 4-gb limit on the file size

It might also be limited by your OS settings (see "limit f" or "ulimit
-f")

Post by unknown
Is there a limit on how big a file can be when bcping out
data? I'm trying to bcp out a large file and it keeps
successfully bulk-copied to host-file.
Error: Writing BCP file (0)!
bcp copy out partially failed
Disk space on my server looks fine. I'm running Sybase
12.0.
Thanks.

[unknown]

I have a feeling it maybe a limit on the file size. Is
there a way to bcp out into multiple files?

Post by Bret Halford
How big is the file at that point?
I'd expect a 2- or 4-gb limit on the file size
It might also be limited by your OS settings (see "limit
f" or "ulimit -f")

Post by unknown
Is there a limit on how big a file can be when bcping
out data? I'm trying to bcp out a large file and it
keeps failing. I get to 12356000 rows then I get the

message: >

Post by unknown
successfully bulk-copied to host-file.
Error: Writing BCP file (0)!
bcp copy out partially failed
Disk space on my server looks fine. I'm running Sybase
12.0.
Thanks.

[SybaseNeal]

Hello,

If you are using bcp 12.0, that is very old and does not
support files greater than 2GB (on most platforms).
Please refer to this technote for details:
http://www.sybase.com/detail?id=1011375

p.s. The link also contains workarounds.

Thanks,
Neal

[Cory]

Hi,

If you are investigating higher releases - consider a 15.0 client with
ESD#5 - They reworked the BCP flat file io system. I've seen 20% better
performance in tests. I found this published at 2006 Techwave.

Post by SybaseNeal
Hello,
If you are using bcp 12.0, that is very old and does not
support files greater than 2GB (on most platforms).
http://www.sybase.com/detail?id=1011375
p.s. The link also contains workarounds.
Thanks,
Neal

[SybaseNeal]

Hello,

If you are using bcp 12.0, that is very old and does not
support files greater than 2GB. Please refer to this
technote for details:
http://www.sybase.com/detail?id=1011375

Thanks,
Neal