MC Press Online

Wednesday, Jan 18th

Last updateTue, 17 Jan 2017 5pm

You are here: Home ARTICLES Analytics & Cognitive DB2

Database / DB2

TechTip: DB2 for IBM i Services - The Practical

About six months ago, I talked about the relatively new DB2 for i Service tool and why it was pretty nifty. Now, let’s take a closer look at it and see how you actually use it.

david shireyWritten by David Shirey  

As I said in the previous tip on this topic, the DB2 for i Services developed by Scott Forstie’s team and being enhanced with every new technology refresh is another way to investigate what’s happening on your IBM i. Although we’re accustomed to doing this using a variety of very powerful system commands, the DB2 for i Service package provides a fresh, more flexible, and more sophisticated way of digging out this information.

Read more ...

TechTip: DB2 for i Optimization Strategies, Part 6

Avoid common SQL programming mistakes that can drag application performance.

Written by Michael Sansoterra

In this final installment of this DB2 for i coding series, I’ll discuss two items. First, I’ll examine a reason why a query that once performed well when it was first written might become lethargic as time passes. Second, I’ll discuss a way to potentially improve the performance of multi-row update statements. In the end, the lessons are how to avoid some common coding flaws that can take the wind out of your database sails.

 

Read more ...

Book Review: DB2 11 for z/OS Database Administration—Certification Study Guide

This is a well-written DB2 11 book that could easily stand on its own as a reference manual, not just a certification guide.

willie faveroReviewed by William (Willie) Favero

Are you thinking about taking the IBM certification test C2090-312—IBM Certified Database Administrator - DB2 11 DBA for z/OS? After all, it is being offered at no charge at the IBM World of Watson 2016 conference (formerly Insight) and IDUG EMEA 2016, both just around the corner, and at IDUG North America 2017 next spring, also only months away. If you are, you might be facing a bit of test anxiety, even if you know the exam topics well. For many people, the prospect of taking a test can cause them to start questioning their skills.

Read more ...

Practical DB2: Database Field-Naming Conventions

The good thing about naming conventions is that there are so many of them, and database field naming is just one of those areas of convention contention.

joe plutaWritten by Joe Pluta

Put three programmers in a room to define a database and you'll end up with at least four different sets of naming conventions. And it won't be quick, either, no matter how much experience you have. I can't count the number of databases I've helped design over the years, yet I still find myself in a room sitting for hours every time I have to work on another one. Each database has its own idiosyncrasies, but a few areas are relatively common among all databases. This article will address one of the fundamental issues: field names.

Read more ...

TechTip: DB2 11 for z/OS Performance and Tuning Tips

Raise or lower the priority of a workload as needed to meet user-specified goals.

susan lawsonWritten by Susan Lawson

This article is an excerpt from chapter 6, “Performance and Tuning,” of DB2 11 for z/OS Database Administration: Certification Study Guide (Exam 312).

 

Using z/OS Workload Manager (WLM), you can set z/OS performance options for DB2. With WLM, you define performance goals and assign a business importance to each goal. The goals for work are defined in business terms, and the system decides how much resource, such as CPU and storage, to give to the work to meet its goal.

 

WLM controls the dispatching priority based on the user-supplied goals. It raises or lowers the priority as needed to meet the specified goal. Thus, you need not fine-tune the exact priorities of every piece of work in the system and can focus instead on business objectives.

Read more ...

TechTip: DB2 for i Optimization Strategies, Part 5

Learn how to take an ax to common suboptimal SQL programming practices.

Written by Mike Sansoterra

This series is almost done, yet there are so many illustrations of potential code improvements to offer to the DB2 for i development community. This tip discusses possible performance improvements when replacing legacy cursors with set operations and when using temporary tables. See the references at the end of this tip for links to prior tips in this series.

Read more ...

TechTip: How to Prepare for the DB2 10.5 DBA for LUW Upgrade from DB2 10.1 Certification Exam

One of the best ways to prepare for any DB2 certification exam is by answering practice questions that are similar to, and that are presented in the same format as, the questions you are likely to encounter when you take the actual exam.

roger sandersWritten by Roger E. Sanders

Editor’s note: This article is adapted from DB2 10.5 DBA for LUW Upgrade from DB2 10.1: Certification Study Notes (Exam 311) by Roger E. Sanders.

 A few months after the “IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1” certification exam (Exam 311) was announced, I spent several weeks developing training material that I could use to help individuals prepare for the 311 certification exam. I used the same technique to develop material for that course that I have used to develop my other DB2 certification exam preparation courses and study guides: I carefully reviewed notes I had taken during the exam development process, as well as the questions I wrote for that particular test, and I made sure I covered, in detail, all the objectives that had been defined for that certification exam.

Read more ...

KPK-TechTip: How to Prepare for the DB2 10.5 DBA for LUW Upgrade from DB2 10.1 Certification Exam (2)

One of the best ways to prepare for any DB2 certification exam is by answering practice questions that are similar to, and that are presented in the same format as, the questions you are likely to encounter when you take the actual exam.

roger sandersWritten by Roger E. Sanders

Editor’s note: This article is adapted from DB2 10.5 DBA for LUW Upgrade from DB2 10.1: Certification Study Notes (Exam 311) by Roger E. Sanders.

 A few months after the “IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1” certification exam (Exam 311) was announced, I spent several weeks developing training material that I could use to help individuals prepare for the 311 certification exam. I used the same technique to develop material for that course that I have used to develop my other DB2 certification exam preparation courses and study guides: I carefully reviewed notes I had taken during the exam development process, as well as the questions I wrote for that particular test, and I made sure I covered, in detail, all the objectives that had been defined for that certification exam.

Read more ...