decor
 

planetDB2 logo

Planet DB2 is an aggregator of blogs about the IBM DB2 database server. We combine and republish posts by bloggers around the world. Email us to have your blog included.

 

February 27, 2015


Susan Visser

New DB2 DBA Certification Guide

Coming in time for the IDUG conference in Philadelphia is the latest DB2 certification guide:
 

DB2 10.1/10.5 for Linux, UNIX, and Windows Database Administration: Certification Study Guide

I'm very pleased to congratulate first time authors Mohankumar Saraswatipura, Robert Collins on the great work they did on this book.  They worked with the content that was originally created and published by the certification master, Roger Sanders, and updated it to include the knowledge you need to know to pass the 10.1 (C2090-611) and 10.5 (C2090-311) certification exams.
 
Before I go further on the book, let me tell you a bit about these new authors.  If you pay attention to the rising stars of the DB2 community, then you've certainly noticed these two before.  Mohankumar is the winner of the 2013 DB2's Got Talent Competition via The DB2Night Show hosted by Scott Hayes.  Watch the replay of Mohan's winning presentation: DB2 9.7 Performance Tuning for Siebel 8.1 Application - A Complete Success Story.
 
Robert Collins aka Kent Collins has also been a guest on The DB2Night Show.  Watch the replay: DB2 BLU Experiences at ****
You can also see Kent in videos about DB2 with BLU Acceleration: IBM Big Data Solutions power BNSF Railways.
 
I haven't seen an early copy of the book, but Mohan and Kent gave us a preview when they were guests on Episodes 148 and 150 of The DB2Night Show that you can watch in replay:  The DB2Night Show #148: DB2 LUW 10.1/10.5 Certification Crammer Part 1.  From this show, you'll get experienced-based advice from the authors as well as sample test questions.
 
 
As in the Roger Sanders' versions of the Study Guides, you'll find that Mohan and Kent have continued the established traditions:
  1. The book is organized to match the exam objectives which you can find on the IBM Certification Site.
  2. There are sample questions in the book that are different than the official sample test
  3. The correct answers to each question are provided in the book.  You do not get the answers on the official sample test.
  4. Reasons for why the correct answer is correct are provided for each question.  You will not get this information in any other place.
  5. The authors have created "flash cards" to help you study for the exam and the publisher is looking for ways to deliver this to readers.
 
As we noticed in the show today (episode 150) many people need to read this book to pass!
 
Susan
 

 


DB2Night Replays

The DB2Night Show #150: DB2 LUW 10.1/10.5 Certification Crammer Part 2

See the book on Amazon.com Special Guests: Mohan Saraswatipura & Kent Collins, Authors DB2 LUW 10.1/10.5 Certification Crammer, Part 2 No surprise! Again, 100% of our audience learned something! Mohan and Kent did a great job introducing their new forthcoming DB2 Certification book, plus they taught various topics from the book! The book will be available 24 April 2015, but you can pre-order it now and save money! Watch today's show...

(Read more)

Henrik Loeser

DB2 Battle: Optimization Profile vs. Statement Concentrator (Part 1)

DB2 explain output Today I wanted to try using a DB2 Optimization Profile for a statement impacted by the DB2 Statement Concentrator. It turned out to be a longer exercise than thought, but also...

(Read more)

Henrik Loeser

DB2 Battle: Optimization Profile vs. Statement Concentrator (Part 2)

Today I wanted to try out using DB2 optimization profiles for a statement impacted by the statement concentrator. In part 1 I gave the background, showed how I created an optimization profile and...

(Read more)
 

February 26, 2015


Frank Fillmore

IBM DB2 Analytics Accelerator #IDAA #DB2z Hands-on Workshop Returns in 2015

Thanks to Kim May and Saghi Amirsoleymani of IBM for the successful two-day IBM DB2 Analytics Accelerator (IDAA) Workshop with hands-on lab exercises.  Five large financial services enterprises sent...

(Read more)

Ember Crooks

DB2 Administrative SQL Cookbook: Looking at How Current Statistics Are

Current statistics are vital to performance. If I’m encountering a database I haven’t regularly been supporting, and don’t know the maintenance plans and schedules, I frequently...

...
 

February 25, 2015


Dave Beulke

DB2 Security Definitions

With the all the hacking stories getting a lot of news coverage, security of a company’s information will definitely be on everyone’s mind. There are many DB2 security options and features that can be used within the system, database, and application environments. As I have written before, DB2...

(Read more)
 

February 24, 2015


Ember Crooks

DB2 Basics: Administrative Commands

I had been in conversation with a respected DBA who is a well known speaker and author. I had mentioned how difficult it is to come up with advanced topics to write and speak about. That is when he...

...
 

February 20, 2015


DB2Night Replays

The DB2Night Show #149: DB2's GOT TALENT - z/OS Auditions

It's the International DB2 Olympics! Today's Finalist Winners: Cristian, Leila, Akshat, & Rajesh 100% of our studio audience learned something! Today's presentations were again very good considering that we had contestants from Austria, Iran, and India! It fascinates me that we can gather around our computers and learn from industry peers all over the world. You will learn about inline UDFs in DB2 V10/V11, Performance Optimization on...

(Read more)

Robert Catterall

Of DB2 Connect "Gateway" Servers and DB2 for z/OS DSNL030I Authentication Messages

A few days ago I received a note in which a DBA reported strange and inconsistent information in some DSNL030I messages that were generated periodically by a DB2 for z/OS subsystem in his charge. The messages in question were tied to authentication failures associated with DDF-using applications (i.e., applications that access DB2 via network connections). Such a failure could occur if an application used an invalid password on a DB2 for z/OS connection request (and that could be the result of...

(Read more)
 

February 19, 2015


Data and Technology

A Couple of Database Predictions

I usually try to avoid predicting the future because humans, as a general rule, are not very good at it. But when things look repetitive or cyclical, then sometimes a “bold” prediction...

(Read more)

Ember Crooks

DB2 Administrative SQL Cookbook: Listing the Columns of a Table in a Comma Separated List

I mentioned this SQL in my article on LISTAGG, but since I made use of it myself recently, I thought it would be worth listing in my DB2 Administrative SQL Cookbook series. Purpose To list the...

...
 

February 18, 2015


Willie Favero

Why and How you should be using the DB2 Analytics Accelerator modeling feature

(Posted Wednesday, February 18, 2015) The IBM DB2 Analytics Accelerator has been available for over 3 years. The technology has achieved ?Triple Status? with a triple digit number for both customers and units deployed. Customers that are reaping the benefits of blazing fast business insi...

(Read more)

Omer Brandis

In memory data cache for db2 on z/os

quickselect basically stores query result sets in memory...A few customers have reported savings of ~ 10% cpu during peak hours.

DB2Night Show News

20 FEB 10am CST: DB2 z/OS Contestants Compete on DB2's GOT TALENT!

The international Olympics of DB2 continue Friday 20 FEB 2015 10am CST with DB2 z/OS contestants from Austria, India, Iran, and Japan! Have you registered yet? Here's what you will...

...
 

February 17, 2015


Willie Favero

An updated DSNWMSGS file is now available

(Posted Tuesday, February 17, 2015) Sometimes I feel like I am a waling advertisement for DB2 maintenance, like it?s the only thing I blog about.   Although it may seem like that (and I actually hope it doesn't), I do try to publish blog entries that cover general information...

(Read more)

Ember Crooks

Introduction to Using the PowerShell Command Line with DB2 on Windows

I have worked with DB2 on Windows on and off over the years and have largely not enjoyed it all that much. Most likely because the vast majority of my time is spent on UNIX and Linux systems, so when...

...

IBM Press Room

IBM Accelerates Data Science Success for the Enterprise

IBM shifts data science into high gear today with the announcement of new In-Hadoop analytics technologies to accelerate the conversion of data into valuable insight for the business. IBM is delivering machine learning, R, and many new features that can run over large-scale data in the new IBM BigInsights for Apache Hadoop.
E-mail this page Save to del.icio.us Digg this
 

February 16, 2015


Craig Mullins

Choosing Between DECIMAL and FLOAT Data Types

DB2 can use both DECIMAL and FLOAT data types to store non-integer numeric data. But the two are not equivalent. In general, use DECIMAL instead of FLOAT whenever you can. The main problem with floating point numbers is that they are not precise. DECIMAL values are precise. In other words, a FLOAT value will be an approximate value whereas a DECIMAL value will be an exact value. At times, if 100...

(Read more)
 

February 13, 2015


DB2Night Replays

The DB2Night Show #148: DB2 LUW 10.1/10.5 Certification Crammer Part 1

See the book on Amazon.com Special Guests: Mohan Saraswatipura & Kent Collins, Authors DB2 LUW 10.1/10.5 Certification Crammer, Part 1 No surprise! 100% of our audience learned something! Mohan and Kent did a great job introducing their new forthcoming DB2 Certification book, plus they taught various topics from the book! The book will be available 24 April 2015, but you can pre-order it now and save money! Watch today's show and...

(Read more)

Subscribe by email

 

About

planetDB2 is an aggregator of blogs about the IBM DB2 database server. We combine and republish posts by bloggers around the world. Email us to have your blog included.
 

Bloggers

decor