Team with the best
Db2® LUW Performance Tools
company in the World

The DB2Night Show #145: db2pd Party with Melanie Stopfer, IBM

January 9, 2015, 8:34 pm
Posted by Scott in DB2 LUW
Melanie Stopfer on LinkedIn

Special Guest: Melanie Stopfer, DB2 Brain Surgeon, IBM Software Group

db2pd Party! The Power of db2pd!

99% of our audience learned something! Who knew that there were so many options for the powerful and popular "db2pd" command? Not only did Melanie share dozens of db2pd command examples and tips, but she also compared and contrasted to various MON_GET function calls and SQL commands. Bonus! Melanie also talked about DB2 security, trusted contexts, HADR, locking, indexes, and more! Enjoy...

Show Host Scott Hayes Commentary

I will repeat from Episode #138 on Upgrading to DB2 10.5 Best Practices: Everyone in the DB2 for LUW community knows, or should know, Melanie Stopfer. I took DB2 Common Server classes from her back in 1992, then DB2 UDB (V5) upgrade classes, then DB2 LUW classes at every IBM and IDUG conference. Melanie has a warm, wonderful, and impactful way of teaching, and I think it'd be fair to say that SHE is one of the top three IBM people in the world that have most impacted DB2 LUW's success. She loves chocolate chip cookies too!

Here's just a few things you are going to learn about: db2pd -help, db2pd -mempools, db2pd -alldbs, -repeat N second, db2pd -applications, db2pd -tablespaces, using db2pd in DPF environments, db2pd -dbpartitionnum N, db2pd -logs, db2_all, rah command, db2pd security requirements, db2pd -edus, db2pd -db DBNAME -dbcfg, enhancements to db2pd in V10.5 FP4 Cancun, db2look -d DBNAME -printdbcfg, db2look -d DBNAME -createdb, admin_get_storage_paths, db2pd -db DBNAME -storagegroups, SYSCAT.TABLESPACES, mon_get_tablespaces, mon_tbsp_utilization, db2pd -db DBNAME -tablespaces, db2 luw temporary table compression with db2pd -temptable, mon_get_index, db2pd -db DBNAME -tcbstats index, SYSPROC.ADMIN_GET_MEM_USAGE, db2mtrk, mon_get_memory_set, mon_get_memory_pool, SYSIBMADM.MON_BP_UTILIZATION, mon_get_bufferpool, db2pd -db DBNAME -bufferpools, SYSIBMADM.MON_PKG_CACHE_SUMMARY, mon_get_pkg_cache_stmt, db2pd -db DBNAME -dynamic, Scan Sharing - monitoring this innovative technique with db2pd -db DBNAME -scansharing, db2pd -db DBNAME -locks, mon_get_workload, SYSIBMADM.MON_LOCKWAITS, db2pd -db DBNAME -wlock, mon_format_lock_name, db2pd -db DBNAME -transactions, load query, list utilities, db2pd -utilities, db2pd -db DBNAME -reorg, db2pd -reorgs index -db DBNAME, db2 trusted contexts, db2pd -db DBNAME -appl, db2pd -db DBNAME -logs, mon_get_transaction_log, lock isolation levels including the new currently committed (as of v9.7), db2pd -workclasssets -alldbs, db2pd -thresholds -alldbs, db2pd -db DBNAME -hadr, tuning DB2_HADR_BUF_SIZE, and more!

For all of the wonders and valuable information you can obtain from db2pd, remember that the data presented is only accumulated since the last db2start command or database activation. There is no history. There are no trends. There are no click-through integrations with other tools or diagnostic functionality. db2pd accesses DB2's memory directly without requiring a database connection, so sometimes it will work when other monitoring functions won't. SQL to MON_GET functions also access memory directly with very nominal overhead, but do require a database connection. If you want to know percentages or ratios, with db2pd you'll mostly likely need to do math as it merely dumps data.

A message from our sponsor:
DBI Software

Don't fast forward through today's educational commercial from DBI! Melanie talked about "db2pd -db DBNAME -tcbstats index" and index scans. Listen to the commercial to learn what this really means. DBI also demonstrated Lock Contention Analysis wherein you can see which connections are blocking other connections - functionality much more robust than db2pd with integrated option to terminate connections!

Magic Hat Money Working with DBI is like making money magically appear!

Typical customers enjoy 30-60% CPU utilization reductions in the first week, plus measurably faster transaction and query response times. More importantly, your time savings will be substantial! Read our newest SUCCESS STORY with HealthPlan Services, do your due diligence, and speak with as many references as you have time to call.

We saved a health care company $250,000 in one afternoon, solved a performance problem in two hours that two senior DBAs were unable to solve in six months, and we have helped top brand name retailers achieve top ranked e-Commerce performance on Black Friday multiple years in a row. 7 of the Top 25 Retailers, plus others, plus top Banks, State Governments, Manufacturers, Insurers, and more rely on DBI. How can we help you? Contact DBI

Join The DB2Night Show™ LinkedIn Group

The DB2Night Show™ has a LinkedIn Group. The "closed" group is open to any LinkedIn member. Join to receive LinkedIn group updates including future shows and replay information, and, if you like, start some discussions about the show! Join The DB2Night Show LinkedIn Group!


We've got GREAT PRIZES, wonderful, loving, kind, and helpful JUDGES, generous SPONSORS, and now we NEED YOU to BECOME A CONTESTANT! Don't be shy! Give it a try! You'll have over a 33% chance of winning a $50 Gift Certificate! Our Top 10 Finalists will be competing for a free IDUG Badge with $1500 travel allowance! Or a free seat at The DB2 Symposium with $1000 travel allowance! Or an Apple iPad!

But, never mind the prizes! As many of our former winners will tell you, do it for your career! Past participants have received raises, bonuses, promotions, invitations to speak at IDUG or write papers, made new friends and contacts, and, yes, some nearly doubled their income! Michael Krafick, DB2's GOT TALENT 2014 1st Place Winner, wrote about his participation experience in this humorous blog post!

2014 Top 20 Replays of DB2 LUW Shows

Did you see the list of our Top 20 DB2 LUW Shows in 2014? Did you notice that 6 of the Top 20 were DB2's GOT TALENT shows? Get involved and advance your career! Just sayin' icon_wink

Get the Download Replays

WMV Format - approximately 73MB

To download a recorded replay of Episode #145 in WMV format, right click on the link below and choose "Save As..."
Episode #145, 9 January 2015, The Power of db2pd with Melanie Stopfer, IBM!

MP4 Format - standard resolution - 116MB

Have an iLife, iDevice, iPod, iPad, or iPhone? Right click and download the MP4 ( M4V ) format!

BONUS!! PDF Handout!

We can't do this with all of our guests, but Melanie has given permission for us to make a PDF handout of her presentation available. Don't skip the replays!

We have to repeat that! Don't skip the replays! When Melanie presents, her slides are reference material! If you only look at the slides, you will only learn HALF of Melanie's wisdom and advice! Data requires context to become information!

Did you learn something from this show?

See that "Mail this" link below? Click it and do a friend a favor - share this blog post and show with one of your friends or peers. THANKS! icon_biggrin

Share a great show with your friends and followers! Let's get this tweeted and retweeted like crazy to celebrate Melanies's contributions to the DB2 LUW community! You know she likes followers at @mstopfer1. We humbly also suggest you follow @srhayes, @dbisoftware, @db2performance, @db2nightshow, and @ibm_db2!

Printer friendly