470,810 Members | 878 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,810 developers. It's quick & easy.

DB2 Environment Setup

Hi all,
I have to setup a 450 GB staging area (database) for the data warehouse.
The System Admin has told me that the space will be made available.
What are all the steps and parameters that need to be considered while
beginning this activity?
I am new to DB2.


Feb 21 '06 #1
2 1163

just as a starting point you will need to think how are you going to
create your table spaces, whether or not to separate big tables, page
size for each table space ( there is a max size depending on the page
size), extent size for your table space and prefetch size.


Feb 22 '06 #2
What about the log files, temporary tables, indexes, system catalog
How do I divide and organize the 450 GB?
Some figures on the above would be helpful.
This database would be holding the dump of flat files and thus will be
having very low activity.



Feb 22 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

8 posts views Thread by Victor B. Berdin | last post: by
1 post views Thread by Bonj | last post: by
reply views Thread by Jesper | last post: by
1 post views Thread by darrel | last post: by
4 posts views Thread by Richard Levasseur | last post: by
3 posts views Thread by =?Utf-8?B?ZGF2aWQ=?= | last post: by
reply views Thread by mihailmihai484 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.