MC Press Online

Monday, Feb 20th

Last updateSun, 19 Feb 2017 12pm

You are here: Home ARTICLES Analytics & Cognitive DB2

Database / DB2

TechTip: Node.js on Linux with JDBC Connection to DB2 for i

Aaron Bartell

Real-world needs demand real-world "what happens if I poke here?" solutions.

Written by Aaron Bartell

One thing I love about my job at Krengeltech is doing discovery work to determine if a collection of technologies can work together to accomplish a business need. Such was the case today. A business had the need to communicate from Node.js on CentOS to DB2 for i. There are many options available to accomplish this task and I've listed some of them below. I've included commentary concerning my thoughts about each.

Read more ...

Book Review: DB2 10.5 Fundamentals for LUW: Certification Study Guide (Exam 615)

Paul Turpin

DBAs who use the book will find it very helpful first in their test study and later as a reference book.

Reviewed by Paul Turpin

Roger Sanders has written many DB2 for LUW certification preparation guides, and I have read almost all of them. The books were my primary study resource in preparing for DB2 certification tests. His most recent study guide, DB2 10.5 Fundamentals for LUW: Certification Study Guide (Exam 615), came too late for me to use for preparing for exam 615, but I am certain that it will be extremely valuable to those who are still preparing to take this exam (test C2090-615: DB2 10.5 Fundamentals for LUW). In addition to helping me prepare for exams, I have found Sanders’ books to be most useful references in my job as a DB2 database administrator (DBA). I still have a number of his older guides at my desk.

Read more ...

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 ...