Page 1 of 1
DB2 Load
Posted: Tue Sep 14, 2004 10:01 am
by Maharaj
Hi
To load huge volume of data , kindly suggest the preferred stage
1) DB2-Load
2) DB2-Enterprise Stage (Load method)
Thanx
Maharaj
Re: DB2 Load
Posted: Tue Sep 14, 2004 11:33 am
by 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
Posted: Wed Sep 15, 2004 1:47 am
by mandyli
We used DB2 native Loader for huge volume of data. Really it will give good performance. Please try DB2 Native Load.
Posted: Wed Sep 15, 2004 2:16 am
by 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.