How to sum Linux directory disk allocated

Question: I need to report on the sum of disk allocated for Linux directories dedicated to DB2 LUW directories . How can I sum the directories disk allocated ? I've tried various procedures but the sums arent't adding to same totals that are displayed when df - h is printed Answer: There's a few different ways of getting to the same total . Here's a simple example of the sum of disk allocated for two directories. In the example below - I'm adding disk allocated for /mydir and /mydir/logs df -h /mydir/ /mydir/logs | awk '{ alloc += $1 }... Read more →

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 →

How to list Linux non-system local users

Question: I'd like to capture Linux local users who are not system users and also return the server name and group associated with the local user. What statement can I execute to create this list ? Answer: Linux offers a number of different methods to report on local users and other meta data associated with the user such as groups and permissions . This code snippet will return non-system users and exclude "user1" and "user2". I've added that predicate to give you some flexibility around how you construct the code. Based on the details - the hostname and the group... 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 →

The great Windows or Linux debate for DB2 LUW

I manage large DB2 servers on Windows and Linux , so I’m confident both OS platforms can support installations with large data sets and high end throughput. But believing DB2 will perform exactly the same on both Windows and Linux without some analysis is a recipe for problems. There are some considerations when planning switching or deciding between DB2 or Linux or Windows. Scriptability of DB2 on Linux versus Windows. If migrating from Linux – you may have a large shell script library which manage Linux and commit the flow control . There may be considerable work to adapt these... Read more →