By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,589 Members | 2,276 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,589 IT Pros & Developers. It's quick & easy.

Any designs required to enhance PARALLEL load

P: n/a
All,

Running environment is non-partition database for datawarehouse with
DB2 V8.2 on AIX.

We have a few logical grouping of tables that we would like to load in
parallel to save time. Each grouping may load up more than 10 GB of
data.

Are there any (physical) designs that may enhance loading tables in
parallel?

Thanks!

Feb 2 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On Feb 3, 10:03 am, lambert...@gmail.com wrote:
All,

Running environment is non-partition database for datawarehouse with
DB2 V8.2 on AIX.

We have a few logical grouping of tables that we would like to load in
parallel to save time. Each grouping may load up more than 10 GB of
data.

Are there any (physical) designs that may enhance loading tables in
parallel?

Thanks!
Just want to clear one uncertainty: would placing tables to be loaded
in separate tablespaces help? Thanks!

Feb 5 '07 #2

P: n/a
la********@gmail.com wrote:
On Feb 3, 10:03 am, lambert...@gmail.com wrote:
>Running environment is non-partition database for datawarehouse with
DB2 V8.2 on AIX.

We have a few logical grouping of tables that we would like to load in
parallel to save time. Each grouping may load up more than 10 GB of
data.

Are there any (physical) designs that may enhance loading tables in
parallel?

Just want to clear one uncertainty: would placing tables to be loaded
in separate tablespaces help? Thanks!
Placing the data on multiple disks could take advantage of parallel I/O
operations for sure.

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany
Feb 6 '07 #3

P: n/a
Ian
la********@gmail.com wrote:
All,

Running environment is non-partition database for datawarehouse with
DB2 V8.2 on AIX.

We have a few logical grouping of tables that we would like to load in
parallel to save time. Each grouping may load up more than 10 GB of
data.
There's nothing in DB2 that *prevents* you from loading 2 tables at the
same time. Performance may not be great if all data is on the same
disks (regardless of whether the tables are in separate tablespaces), or
if you have CPU utilization issues. But it will work.


Feb 6 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.