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


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