Maximum Records can be stored in a DataSet

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
uegodawa
Participant
Posts: 71
Joined: Thu Apr 27, 2006 12:46 pm

Maximum Records can be stored in a DataSet

Post by uegodawa »

Hi
Does any one knows about the storage limitation about a DataSet. I've designed a job for a Dataset with 398 columns and 1,000,000 source records. When I executed the job I can see only 521327 records stored in DataSet with 4,270,718,976 bytes.
So, What happened to rest of my source records ?
Is this because of a limitation of O/S or DataSet stage itself ?
Thanks
uegodawa
Thanks,
Upul
surendra.v
Participant
Posts: 6
Joined: Sat Jul 29, 2006 12:03 am

Post by surendra.v »

How many configuration nodes are being used to create this data set.

Based on the file size in bytes, it appears to me like it is running under 2 node configuration and created two 2GB files.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

How are you determining the number of records in the Data Set?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply