DB2 extend database server capacity

19 January,2011 by Tom Collins

A quick solution for extending capacity on a database server  is normally  a)add more memory b)add disk space and expand containers. C)additional processors d)add partitions

If adding more procesors  and system is SMP  the processors will automatically share storage resources and memory. Consider any changes that may need to occur to the following parameters:

Default degree (dft_degree)

Default degree configuration parameter  Default value =1 and is equivalent to no intra-partition parallelism. If -1  , the optimizer decides n level of intra-partition parallelism


Maximum degree of parallelism (max_querydegree)

(Maximum degree of intra-partition parallelism )If -1 , the optimizer decides  otherwise set relevant value


Enable intra-partition parallelism (intra_parallel)

Defiines whether the database manager can use intra partition parallelism


Dont necessarily make changes to the parameters prior to a proper review and testing of the impact of these changes.

If adding more partitions  and the database manager is currently on a partitioned database environment  then storage resources# memory can be increased by adding either single or multi processor partitions.. Each partition manages its own resources. The main advantage of this approach is that data and user audit can be balanced over different systems. Keep in mind that this could cause other problems  so some planning and testing is required



 Ref:Jack Vamvas(http://www.dba-db2.com)


Author: Rambler(http://www.dba-db2.com)


Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.


Post a comment on DB2 extend database server capacity

Comments are moderated, and will not appear until the author has approved them.

dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright