Hi
To load huge volume of data , kindly suggest the preferred stage
1) DB2-Load
2) DB2-Enterprise Stage (Load method)
Thanx
Maharaj
DB2 Load
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 18
- Joined: Mon Jan 12, 2004 7:20 am
- Location: USA
Re: DB2 Load
[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
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
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.
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.
dnzl
"what the thinker thinks, the prover proves" - Robert Anton Wilson
"what the thinker thinks, the prover proves" - Robert Anton Wilson