title="Nailah Bissoon on LinkedIn">
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:
title="New Window: Watch a replay of Episode #177 - What's New in V11.1 - Overview"
target="NEW">Part 1: What's New in DB2 LUW V11
title="New Window: Part 2: DB2 LUW V11.1 Deep Dive on BLU and Analytics">Part 2: DB2 LUW V11.1 Deep Dive on BLU and Analytics
title="New Window: Part 3: DB2 LUW V11.1 Deep Dive on OLTP and pureScale">Part 3: DB2 LUW V11.1 Deep Dive on OLTP and pureScale
title="New Window: Part 4: Upgrading to DB2 LUW 11.1 Best Practices!">Part 4: Upgrading to DB2 LUW 11.1 Best Practices!
A message from our sponsor:
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
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
title="Press Release: DBI and HealthPlan Services celebrate DB2 LUW successes!">SUCCESS STORY with
HealthPlan Services, do your
target="NEW" title="Learn about the high cost of 'free' tools and do your due diligence">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?
target="NEW" title="Let's have a conversation - Contact DBI">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!
href="http://www.linkedin.com/groupRegistration?gid=2761037" target="NEW" title="New Window: Join The DB2Night Show LinkedIn Group">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!
Post from : http://www.dbisoftware.com/blog/db2nightshow.php
Printed from : http://www.dbisoftware.com/blog/db2nightshow.php?id=703