decor
 

planetDB2 logo

Planet DB2 is an aggregator of blogs about the IBM DB2 database server. We combine and republish posts by bloggers around the world. Email us to have your blog included.

 

November 14, 2018

Jack Vamvas

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 decision making.

I use this  little script - which lists out all the processes and the swap usage.  

 

SUM=0
OVERALL=0
for DIR in `find /proc/ -maxdepth 1 -type d | egrep "^/proc/[0-9]"` ; do
        PID=`echo $DIR | cut -d / -f 3`
        PROGNAME=`ps -p $PID -o comm --no-headers`
        for SWAP in `grep Swap $DIR/smaps 2>/dev/null| awk '{ print $2 }'`
        do
                let SUM=$SUM+$SWAP
        done
        echo "PID=$PID - Swap used: $SUM - ($PROGNAME )"
        let OVERALL=$OVERALL+$SUM
        SUM=0

done
echo "Overall swap used: $OVERALL"




 Thank you to Erik Ljungstrom for the script


Triton Consulting

How important is your organisations data?

If your answer wasn’t along the lines of “our data is absolutely vital to our business” then you can look away now, this blog isn’t for you! If, like most people you’re in agreement that your organisations data is of … Continue reading → The post How important is your organisations...

(Read more)
 

November 12, 2018


Craig Mullins

Data Masking: An Imperative for Compliance and Governance

For those who do not know, data masking is a process that creates structurally similar data that is not the same as the values used in production. Masked data does not expose sensitive data to those using it for tasks like software testing and user training. Such a capability is important to be in compliance with regulations like GDPR and PCI-DSS, which place restrictions on how personally...

(Read more)
 

November 09, 2018


Triton Consulting

IDUG EMEA Malta 2018 – Day 4

Another great IDUG conference has inevitably come to its end. Even though I will miss the networking, the evening parties, chit-chatting with other attendees and all other nice conference side-effects, I am by no means sad that it’s over. There … Continue reading → The post IDUG...

(Read more)
 

November 08, 2018


Triton Consulting

IDUG EMEA Malta 2018 – Day 3

After the usual hair-raising drive from the airport to the Intercontinental Hotel on Sunday, it was time to catch up with some old friends and colleagues. I was lucky enough to bump into an old mate; Tony Poole, who’s Director … Continue reading → The post IDUG EMEA Malta 2018 – Day 3...

(Read more)
 

November 07, 2018


Triton Consulting

IDUG EMEA Malta 2018 – Day 2

Day 2 of IDUG Europe 2018 is in the books, yet another day full of excellent education opportunities and networking here in Malta. While I was reflecting on the events of the day, I got to thinking about our host … Continue reading → The post IDUG EMEA Malta 2018 – Day 2 appeared...

(Read more)
 

November 06, 2018


Triton Consulting

IDUG EMEA Malta 2018 – Day 1

IDUG EMEA always provides interesting content. Whether it’s John Campbell’s greatest hits (INSERT ALGORITHM 2 disable / re-enable, enhanced dynamic workload placement in Connect 11.1 M4 FP4, real storage management fun), or our own Julian Stuhler (Cloudy With a Chance … Continue reading...

(Read more)
 

November 04, 2018


Triton Consulting

Malta, here we come!

Malta is an upcoming location for business and culture given that it held the Presidency of the Council of the European Union in 2017 and the City of Valetta, Malta has been selected as the European Capital of Culture 2018. … Continue reading → The post Malta, here we come! appeared...

(Read more)
 

November 01, 2018


Craig Mullins

30th Anniversary of the Platinum Db2 Tip of the Month

If you have worked with Db2 as long as I have you probably have fond memories of the Platinum Db2 Tip of the Month... but I know there are a lot of you out there who have no idea what I'm talking about. So let me explain. First of all, there used to be a software company called Platinum Technology, Inc. They were headquartered in Oak Brook Terrace, Illinois and made some of the earliest Db2 for...

(Read more)
 

October 31, 2018


Robert Catterall

Db2 for z/OS Buffer Pools: Clearing the Air Regarding PREFETCH DISABLED - NO READ ENGINE

Has this ever happened to you? You're looking at the output of a Db2 for z/OS -DISPLAY BUFFERPOOL(ACTIVE) DETAIL command, or maybe at a statistics report produced by your Db2 monitor, or maybe your Db2 monitor's online display of a subsystem's buffer pool activity, and you see for one of your buffer pools something like this: PREF.DISABLED-NO READ ENG   350.00 And you think, "Uh-oh. Prefetch is a good thing, so disabled prefetch must be a bad thing. And it happened 350 times for BP2 in...

(Read more)

Henrik Loeser

IBM Watson Assistant: Chatbot tool now supports testing client actions

Test your chatbot Are you (already) using the Watson Conversation Tool I wrote? There is good news because I added support for testing client side actions. As you might know, IBM Watson Assistant...

(Read more)
 

October 26, 2018


DB2Night Replays

The DB2Night Show #208: 10 Minute Triage: Troubleshooting Db2 Performance

@MKrafick Special Guest: Michael Krafick IBM Champion Senior DBA 10 Minute Triage: Troubleshooting Db2 LUW Production Issues 100% of our audience learned something!Per Michael's tweet this morning, "I will teach you how to say #holdmybeer while triaging #Db2 on production databases." Downtime is expensive. Most DBAs have been in the hot seat with management demanding rapid information and problem resolution. Michael shares his robust...

(Read more)

Triton Consulting

Six Reasons to Review your Database Availability – Part 3 Reputational Damage

From working with many customers to help keep their critical databases up and running we have come up with the top 6 reasons for putting Database Availability at the top of your priority list. In this blog we look at … Continue reading → The post Six Reasons to Review your Database...

(Read more)
 

October 24, 2018


Data and Technology

Teradata Analytics Universe 2018 and Pervasive Data Intelligence

I spent last week in Las Vegas at the Teradata Analytics Universe conference, Teradata’s annual user conference. And there was a lot to do and learn there.     The major message from...

(Read more)
 

October 22, 2018


Henrik Loeser

Automated reports with IBM Cloud Functions, Db2 and Slack

GitHub Traffic Analytics One of my (many) favorite IBM Cloud solution tutorials is about combining serverless and Cloud Foundry for data retrieval and analytics. I blogged about it and described how...

(Read more)
 

October 20, 2018


DB2Night Replays

The Db2Night Show #z90 - z/OS: Total Recall: Exploiting In-Memory Features

Presented by: Julian Stuhler Principal Consultant, Triton "The DB2Night Show #Z90: Total Recall: Exploiting In-Memory Features" Replays available in WMV and M4V formats! 100% of our studio audience learned something!Julian covered the important features relating to in-memory features and gave good recommendations on their use. Watch the replay...

(Read more)
 

October 19, 2018


Craig Mullins

Unboxing My Book: A Guide to Db2 Performance for Application Developers

Just a quick blog post today to show everybody that my latest book, A Guide to Db2 Performance for Application Developers, is published and ready for shipping!  I just got my author's copies as you can see in this video: Hope you all out there in Db2-land find the book useful. If you've bought a copyu and have any comments, please feel free to share them here on the blog.

(Read more)

Kim May

Starting to Think About Think

Last year Frank and I chose not to attend Think in Las Vegas.  While I missed the networking (socializing/fun) part of conference, it didn’t feel like a “must attend” event, as the...

(Read more)
 

October 16, 2018


Triton Consulting

Out of Support Database – A DB2 Support Nightmare!

The set-up   You have a mission critical database that uses DB2 V9.7 or 10.1 (or even earlier! We do have customers still running V8). It’s robust, reliable and gives little cause for concern. Upgrading to a new version is … Continue reading → The post Out of Support Database – A...

(Read more)

Triton Consulting

Total Recall: Exploiting In-Memory Features in DB2 z/OS on the DB2Night Show

We are pleased to confirm that Julian Stuhler, Solutions Delivery Director and IBM Gold Consultant will be the guest presenter on the forthcoming DB2Night Show. Julian will be presenting on Total Recall: Exploiting In-Memory Features in DB2 12 for z/OS.  … Continue reading → The post...

(Read more)
 

October 15, 2018


Craig Mullins

Published and Available to be Ordered: A Guide to Db2 Performance for Application Developers

The print version of my new book, A Guide to Db2 Performance for Application Developers, can now be ordered directly from the publisher. (If you want the ebook, it can be ordered from the same link below). Just click on the book cover below and you can order it right now! The link provides more details on the book as well as options for buying the book.   Quick information about...

(Read more)
 

October 11, 2018


Henrik Loeser

Impressions from Zeppelin flight

Zeppelin flight Recently, I had the opportunity to fly on a Zeppelin NT, the kind of Zeppelin I had blogged about before. The 6+ hour flight was a once in a lifetime opportunity because it could not...

(Read more)

Henrik Loeser

Use a custom domain, manage TLS certificates and apply e2e security to cloud app

End to end security for a cloud app on IBM Cloud Well, that title is a little bit long and ugly, but it basically describes what I wanted to tell you about today. A while ago, I blogged that my team...

(Read more)
 

October 10, 2018


Henrik Loeser

BYOK to encrypt Kubernetes secrets on IBM Cloud

Add Key Protect Few days ago, it was announced that IBM Cloud Key Protect integrates with the Kubernetes Service. It means that cluster secrets such as service credentials, TLS certificate...

(Read more)
 

October 05, 2018


Craig Mullins

What Do You Think of the New Design?

Regular readers should have noticed that the logo and basic design of the blog has been "spiffed" up a bit. I did this because the blog has been around for a long time now... my first post was in October 2005! So it was time for a bit of freshening. Generally speaking, I think blogs are mostly for conveying information, so perhaps I haven't paid as much attention as should have to the look and...

(Read more)

Triton Consulting

IBM Webcast – Tell Your Story & Earn Your Star: Become an IBM Champion

It’s IBM Champion nomination season! Join Libby Ingrassia, IBM Sr. WW Program Manager  on Monday 8th October for the webcast Tell Your Story & Earn Your Star: Become an IBM Champion. IBM Champions are a community of experts across IBM … Continue reading → The post IBM Webcast...

(Read more)
 

October 04, 2018


Henrik Loeser

Db2 Node.js and Python drivers and ORM

I am back from the Db2 Aktuell conference with my talk about Db2 app development and IBM Cloud. One of the many questions I received since then is about where to find the Db2 drivers for Node.js and...

(Read more)

Craig Mullins

Submit an Abstract to Speak at the IDUG Db2 Tech Conference 2019

Hey Db2 people, have you done something interesting with Db2? Have you worked on a cool application or figured out a nifty way of managing your databases? Do you want to share your experiences, know-how, and best practices with other Db2ers? Have you ever wanted to put together a presentation and deliver it to a bunch of like-minded Db2 folks? Well, there is still time to submit a proposal...

(Read more)
 

October 03, 2018


Frank Fillmore

Get #Db2 for FREE! New Db2 Developer Edition including #Docker and #DBaaS #IBMAnalytics

A customer came to me recently looking for Db2 Express-C which he had previously used to distribute to developers in his organization.  I couldn’t find Db2 Express-C v11.  Was there no longer a...

(Read more)
 

October 02, 2018


Craig Mullins

A Guide to Db2 Performance for Application Developers: Pre-order Now Available

I have blogged about my new book, A Guide to Db2 Performance for Application Developers here before, to let everybody know that I was writing the book. And I promised to keep you informed when it was available to order and pre-order. Well, this is one of those informative posts I promised. The ebook is available for order immediately at this link.   And you can pre-order the book...

(Read more)

Data and Technology

10 Rules for Succeeding as a DBA

Being a successful database administrator requires more than just technical acumen and deep knowledge of database systems. You also must possess a proper attitude, sufficient fortitude, and a...

(Read more)

Subscribe by email

 

About

planetDB2 is an aggregator of blogs about the IBM DB2 database server. We combine and republish posts by bloggers around the world. Email us to have your blog included.
 

Bloggers

decor