What is using my Linux swap space?

Question: I'm familiar with how to monitor swap space usage for processes. There is more detail about the methods I've adopted for using vmstat to check swap in and swap out on Linux swap space and DB2 . How can I check what is currently in the Linux wasp space ? Answer: Sometimes out of curiosity I like to check what is consuming Linux swap space on a server . Various security type scans always appear to abound on servers and I like to differentiate between ad- hoc , regular processes. The more relevant information you've got - allows better... Read more →

DB2 LUW 11.1 product documentation available in PDF format

For a period of time the DB2 LUW 11.1 documentation was only available online. The good news is it's now available in PDF format and can be downloaded to read through . To download the documentation visit the Db2 Version 11.1 for Linux, UNIX, and Windows English Manuals Read more →

3 signs of low Linux memory

Question: I’ve received some monitoring alerts about low memory availability on a Linux server hosting a DB2 LUW installation. I’d like to be able to check myself. What are some indicators I can report on – giving me more detail on the low memory usage? Also, what are some of the signals that Linux memory health is good? Answer: Linux offers some commands which will allow you to assess the Linux memory usage. These suggestions are for general usage and it’s important to understand these figures in the context of the server. A deeper understanding is required to capacity plan... Read more →

ADM11001E DB2 did not create a memory segment for running fenced routines

Question:We are carrying out an application installation. The installation is failing with the following message in the .nfy file . ADM11001E DB2 did not create a memory segment for running fenced routines. This was specified by the use of DB2_FMP_COMM_HEAPSZ registry variable. How can I bypass these errors to allow the installation to finish? Answer: I’ve seen this problem plenty of times where a DBA has set the DB2 registry value : DB2_FMP_COMM_HEAPSZ=0. On many occasions , it is to force fenced routines such as the DB2 Health Monitor :Monitor health of instance and databases to not run. It is... Read more →

Linux swap space and DB2

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... Read more →