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 →

Powershell grep and awk

I use grep for exploring data sets and awk for text processing on Linux. They are very powerful utilities which simplify extracting and processing text. For example , I have a CRON job running on command a Linux server which does something like: Example 1 db2pd -d mydb -logs |grep 'Method 1 Archive Status' | awk '{print " JackV@myserver - MYDB "$3" "$4": "$5}' This command uses the db2pd utility to extract information from the db2pd logs output and process to return certain information from the data extracted The output is : JackV@myserver MYDB Archive Status: Success A question that... Read more →

DB2 performance monitoring with db2pd

For ease of use and accessibility db2pd in DB2 LUW is my favourite for DB2 performance troubleshooting Here are some approaches on gathering data from DB2 LUW to assist root cause analysis. This is the first post – I’ll keep adding more information over the next few days If you want to read on a wider range of db2pd capabilities read db2pd troubleshooting guide (DBA DB2) A typical situation is sustained high CPU – and query response times begin to degrade. Check vmstat and get an overall picture of the CPU. Focus on the difference between sys and usr CPU.... Read more →