Linux swap space and DB2

30 December,2014 by Jack Vamvas

To view the linux swap space and usage ,use one of these commands

 

Swapon –s

Cat /proc/swaps

 

Monitoring the Linux swap space is important as the usage levels are a good indicator more memory may be required.

The general rule of thumb for the Linux swap space sizing , based on the IBM DB2 database product  documentation, is 25% - 50% of physical RAM. It’s a guideline figure , and the DBA will need to do some  memory usage planning.

If you're seeing constant swapping , then organise some extra memory. To view swapping use this command:

vmstat 3 100

Focus on the si and so columns. This shows paged in and paged out on the disk.

One of the reasons for the relatively high % of swap space is to accommodate unanticipated memory over commitment.  In the modern database server environment, there are all sorts of DB2 features out-of-the-box requiring extra memory plus systems administrators like to install  various management agents and probes to manage systems .

 

Read more on Linux system management

Linux top greater than 100 percent - CPU - DBA DB2

Iometer and Linux - DBA DB2

DB2 and Linux IO testing tools

Linux Server OS information - DBA DB2 - DBA-DB2.com

 

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

Share:

Verify your Comment

Previewing your Comment

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

Working...
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.

Working...

Post a comment on Linux swap space and DB2

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