DB2 Load

[Maharaj]

Hi

To load huge volume of data , kindly suggest the preferred stage

1) DB2-Load
2) DB2-Enterprise Stage (Load method)


Thanx
Maharaj

[alexysflores]

[quote="Maharaj"]Hi

To load huge volume of data , kindly suggest the preferred stage

1) DB2-Load
2) DB2-Enterprise Stage (Load method)


Thanx
Maharaj[/quote]




How big is your data in terms of rows not the native files systems?.

Do not use DataStage DB2 Plug-ins and Loader , they are very slooooow to load data in a tables and schema. The best way is to use DB2 native bulk loaders 'db2altd' stuff for a huge data. So far, my experience in loading huge stuff for DB2 is around 800 Million rows of data with 35 Columns.





Alexys Flores
Independent Consultant

[mandyli]

We used DB2 native Loader for huge volume of data. Really it will give good performance. Please try DB2 Native Load.

[denzilsyb]

It depends on the architecture as well.
One of our colleagues says they have no issues with speed if the DB2 server and DS server is on the same physical server.

But, if you research the forum, guys like ogmios and more are sceptical about the speed achieved using the bulk load. They use load scripts and execute the load scripts 'manually' after a run.