Mohankumar Saraswatipura - IBM Db2 11.1 Certification Guide

Copyright 2018 Packt Publishing

All rights reserved. No part of this book may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, without the prior written permission of the publisher, except in the case of brief quotations embedded in critical articles or reviews.

Every effort has been made in the preparation of this book to ensure the accuracy of the information presented. However, the information contained in this book is sold without warranty, either express or implied. Neither the author(s), nor Packt Publishing or its dealers and distributors, will be held liable for any damages caused or alleged to have been caused directly or indirectly by this book.

Packt Publishing has endeavored to provide trademark information about all of the companies and products mentioned in this book by the appropriate use of capitals. However, Packt Publishing cannot guarantee the accuracy of this information.

Commissioning Editor: Amey Varangaonkar
Acquisition Editor: Divya Poojari
Content Development Editor: Eisha Dsouza
Technical Editor: Ishita Vora
Copy Editors: Safis Editing, Vikrant Phadkay
Project Coordinator: Shweta Birwatkar
Proofreader: Safis Editing
Indexer: Priyanka Dhadke
Graphics: Jisha Chirayil
Production Coordinator: Nilesh Mohite

First published: June 2018
Production reference: 1270618

Published by Packt Publishing Ltd.
Livery Place
35 Livery Street
Birmingham
B3 2PB, UK.

ISBN 978-1-78862-691-0

www.packtpub.com

Mapt is an online digital library that gives you full access to over 5,000 books and videos, as well as industry leading tools to help you plan your personal development and advance your career. For more information, please visit our website.

• Spend less time learning and more time coding with practical eBooks and Videos from over 4,000 industry professionals

• Improve your learning with Skill Plans built especially for you

• Get a free eBook or video every month

• Mapt is fully searchable

• Copy and paste, print, and bookmark content

Did you know that Packt offers eBook versions of every book published, with PDF and ePub files available? You can upgrade to the eBook version at www.PacktPub.com and as a print book customer, you are entitled to a discount on the eBook copy. Get in touch with us at service@packtpub.com for more details.

At www.PacktPub.com , you can also read a collection of free technical articles, sign up for a range of free newsletters, and receive exclusive discounts and offers on Packt books and eBooks.

It is my pleasure and honor to introduce this books authors, Mohankumar Mohan Saraswatipura and Robert Kent Collins. Since the late 1990s, my work and lifes mission has been to help grow, nurture, and support the community around IBM Db2 databases. Through presenting at the International Db2 User Group, helping worldwide Db2 customers and clients, and producing the ever-popular edutainment webinar series The Db2Night Show, I have come to know the best of the best in the Db2 industry. You are about to learn from, and enjoy, an excellent book written by two of the brightest minds in the Db2 world.

I first noticed Mohan in 2013 when he participated in Db2s GOT TALENT on The Db2Night Show. His presentations were brilliant, polished, professional, and helpful, and ultimately he won first place in this worldwide competition. I met him in person at IDUGs 25th Anniversary in Orlando later that year and was further impressed by his professionalism, articulate communication, and enthusiastic and polite demeanor. In recent years, Mohan also authored a DB2 9.7 Advanced Application Developer Cookbook, co-authored the DB2 10.1 and 10.5 Administration Certification Study Guide, and presented at IDUG several times. He has been a repeat popular guest on The Db2Night Show many times and has published several popular magazine articles. Seriously, we should all worry about his healthit seems this man never sleeps, or, if he does, his life revolves around Db2 24x7.

I first met Kent when IBM was launching DB2 V10.5 with BLU columnar capabilities at the Almaden Research Center. If youre an IBM groupie like many, Kents face might be more familiar to you because IBM has featured him at many of their roadshow events for emerging technologies. He has been featured as a talking head during keynotes at IBM IOD conferences, the Pure System Launch event in Boston, IBM Tech and Customer Briefings, and more. He has authored many TCP style documents on pre-release versions of Db2 that showcase new features, functionality, and Db2 performance breakthroughs. And like Mohan, Kent also co-authored the DB2 10.1 and 10.5 Administration Certification Study Guide. He has presented at several IBM and IDUG conferences, and hes been our guest many times on The Db2Night Show. Frankly, when it comes to IBM Db2 pureScale, I think Kent is absolutely on the top shelf, with very few peers if any.

As a key executive at a Db2 Performance Tools company, Ive long believed that it is critically important for people to first understand what is important to monitor, how to do it, and how to interpret and react to the Db2 performance data. Once people have this foundational understanding, then they can make smart choices about the processes and tools that they will use to automate analysis. This is why Ive taught technical sessions at IDUG every year since 1996, and it's also one of the reasons that I think you are going to love this book. Mohan and Kent have a gift for explaining the complex; making it simple; and leading with examples, samples, and illustrations. After you read Chapter 5 on monitoring Db2 activity and try out many of the sample monitoring SQLs provided, youll be torn between keeping this book at your desk and under your pillow. Maybe you should buy a second copy!

Finally, and not surprisingly, both Mohan and Kent have been awarded IBM Champion status from 2010 to 2018 (current). Because of their deep knowledge of and love for IBM Db2, their many devoted contributions to the worldwide Db2 community, and their professional, helpful demeanor, I recently nominated both Mohan and Kent to become IBM Db2 GOLD Consultants. I hope you enjoy this book and learn a lot from it, and that someday you might be blessed with the opportunity to meet these Db2 professionals in person at an IDUG conference, have the ability to work alongside them professionally, or both!

With kindest regards,

Scott Hayes

President and Founder of DBI Software, IBM Db2 GOLD Consultant, and IBM Champion