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

The DB2Night Show #185: Monitoring IBM BigSQL - Similarities to DB2 LUW

October 10, 2016, 12:45 pm
Posted by Scott in DB2 LUW
Nailah Bissoon, Performance Architect, IBM BigSQL, IBM Canada

Special Guest: Nailah Bissoon, Performance Architect, IBM BigSQL

Monitoring IBM BigInsights BigSQL
How does it compare to monitoring DB2 LUW?

100% of our audience learned something! Your cheese is moving! Someday, if not already, you may be asked to monitor the performance of IBM BigSQL. As you'll learn in this replay, there are a few differences and many similarities to monitoring DB2 LUW. Nailah provided a fantastic comparison of DB2 LUW and BigSQL, their architectures, how they work, and how to monitor both- complete with examples and useful SQL! Enjoy...


Show Host Scott Hayes Commentary

As with show #184 on the future of DB2 LUW, again 100% of our audience learned something! That tells you something right there! These are exciting times to be a DB2 professional! DB2 technology, the CAE, is invading (or being embraced by) many new IBM offerings including BigInsights BigSQL. This makes brilliant sense!

After learning from Nailah, I found myself thinking "No problem, I've got this! Monitoring BigSQL will be easy!" So, if you know DB2 LUW monitoring, fear not! Your knowledge is highly transferrable to BigSQL!

Buzzword Bingo - Here are some things you'll learn about!

Review of DB2 LUW concepts, Hadoop overview, BigSQL Architecture Overview, BigSQL Performance Monitoring, type of tablespaces, use of bufferpools, STMM, runstats, the ANALYZE command, DPF database partitioning, HDFS the Hadoop File System, HDFS Name Nodes, HDFS Data Nodes, IBM Open Platform (IOP), Hive, How BigSQL uses DB2 DPF alongside HDFS, use of tempspaces, BigSQL Scheduler, BigSQL I/O Engines, Native I/O FMP, Java I/O FMP, Analyze utility is the "runstats" of BigSQL, use db2exfmt for Explains, Hash Joins preferred over Nested Loop joins, new MON_GET Hadoop metrics begin with "ext_table_", eight new "ext_table_" metrics, most MON_GET table functions work with BigSQL, INSTANCE_MEMORY, DB2_CPU_BINDING, and more. IBM Knowledge Center Reference

One Stop Shopping for ALL your DB2 V11.1 Knowledge Needs!

Check out these replays covering hot DB2 LUW V11.1 Topics:

  1. Part 1: What's New in DB2 LUW V11
  2. Part 2: DB2 LUW V11.1 Deep Dive on BLU and Analytics
  3. Part 3: DB2 LUW V11.1 Deep Dive on OLTP and pureScale
  4. Part 4: Upgrading to DB2 LUW 11.1 Best Practices!


A message from our sponsor:
DBI Software

During today's quick educational 3 minute commercial, DBI announced pureFeat™ Performance Management Suite for IBM DB2 LUW V6.3. The crown jewel of this release is Predictive Index Impact Analysis - the ability to ascertain performance impacts (good, bad, or otherwise) before creating new indexes! Now you can accelerate through the Change Control process with knowledge and confidence! A demonstration was provided. Learn What's New in Release 6.3

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

Typical customers enjoy 40-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. 8 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!

Get the Download Replays

WMV Format - approximately 56MB

To download a recorded replay of Episode #185 in WMV format, right click on the link below and choose "Save As..."
Episode #185, 7 October 2016, Monitoring IBM BigSQL - Similarities and Differences from IBM DB2 LUW, guest Nailah Bissoon

MP4 Format - 96MB

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

Sharing is Caring!

Share a great show with your friends and followers!

Printer friendly