The DB2Night Show #202: Using Jupyter Notebook for Db2 Administration

@ember_crooks

Special Guest: Ember Crooks Director, Xtivia IBM DB2 GOLD Consultant Using Jupyter Notebook for Db2 Administration 100% of our audience learned something! If you like tools that help make your Db2 Administration tasks easier, then watch this replay and learn about Jupyter Notebook from IBM GOLD Consultant Ember Crooks! Ember teaches how to organize your favorite administrative SQLs, plus create graphs and reports, and more! The CLP is so yesterday! Watch and learn...

Show Host Scott Hayes Commentary

There is a PDF available, BUT YOU HAVE TO WATCH THE REPLAY! Over half of Ember's presentation was a live demonstration! Ember is truly a trail blazer who makes understanding, and working with, Db2 easier for all of us! I'm in awe of her creativity and helpfulness! After you watch what she's done with this Jupyter thing, you're going to want to try it out for yourself! Lots of helpful links provided below!

More shows Featuring Ember Crooks

Check out these replays of past shows:

• Episode #196: Db2 LUW Transaction Log Expedition
• Episode #194: Interviewing the Db2 LUW Optimizer ( Explains Explained in English! )
• Episode #164: 8 High-Impact Performance Tuning Tips for DB2 LUW
• Episode #133, Why Low Cardinality Indexes (STINK)
• Episode #143, HADR and TSAMP Advanced Topics
• Episode #66, Top 10 Tips for E-Commerce Databases

A message from our sponsor:
DBI Software

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 includingfuture shows and replay information, and, if you like, start some discussions about the show! Join The DB2Night Show LinkedIn Group!

Useful Links

• jupyter.org
• Anaconda (for Python): www.continuum.io/downloads
• http://landinghub.visualstudio.com/visual-cpp-build-tools
• https://github.com/ecrooks/db2_and_jupyter_notebooks
• Github for Db2 Extensions: https://github.com/DB2-Samples/db2jupyter
• Github of docker image including Db2 Client: https://github.com/ibmdbanalytics/dashdb_analytic_tools
• And, of course, Ember's Blog: http://db2commerce.com

Get the Download Replays

WMV Format - approximately 176MB

To download a recorded replay of Episode #202 in WMV format, right click on the link below and choose "Save As... "
Episode #202, 2 February 2018, Using Jupyter Notebook for Db2 Administration with Ember Crooks!

MP4 Format - standard resolution - 119MB

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

PDF Handout!

Ember generously agreed to share a PDF of her presentation with our Db2 community! Yay! The PDF makes good reference material, but do watch the video replay to see the power of Jupyter in action! Get the PDF!

Sharing is Caring!