DSXchange

Can we load a 3 gig file using any of the stages? Please advice if any efficient way to load data in to target DB2 8.x tables.. like partitioning the file.

Thanks
Vikram

Hi And Welcome Aboard ,
You can load 3GB files, though most chances activating a bulk load utility if possible via command line might be the fastest way (especially if your row consists of many columns).

sequential file stage can read over 2GB files (as long as your FS is configured to be able to handle such large files).

what exactly do you need to acomplish? (knowing that might get a better answer)

IHTH,

No DataStage stage imposes any limit on the volume of data processed (except where some resource, such as memory or disk space or ulimit) is exhausted .

So any restriction will come from your target. This might be a maximum table space size imposed by a DBA, or a maximum file size imposed by an operating system configuration.

Without knowing exactly what you're trying to achieve it's not possible to provide more exact information.

The main point is that DataStage won't be the problem.