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.

 

May 22, 2015


Ember Crooks

Ember Speaking at DB2 Symposium in Eindhoven on 11 June

For the 5th blogiversary of db2commerce.com, I’m taking a European trip. It has been more than decade since I’ve been overseas, so I’m very much looking forward to it. I’ll be...

...
 

May 21, 2015


Willie Favero

APAR Friday: A data scan with no data returned

(Posted Thursday May 21, 2015) I was attempting to move away from posting about fixes to issues in DB2. It felt like I was doing it way to often, almost like a easy why out of dreaming up my own content. However, with that said, I thought the following APAR was worth decimating to my readers. ...

(Read more)
 

May 20, 2015


Philip Carrington

Back to dangerous blogging

Looking at this I have not written a blog post on here in over two years! I think it is time for a change. First of all to let you guys know what I have been up too and then too let you in what I...

...

Leons Petrazickis

How I made my Android Galaxy S3 phone run faster

My primary phone is a Samsung Galaxy S3 running Android 4.4.2 Kit Kat. It’s a little old at this point, but I’m disinclined to upgrade for the sake of upgrading. It was getting slower, so...

(Read more)

Leons Petrazickis

Installing DB2 10.1 on Mac OS X

It’s incredibly useful to have a local installation of DB2 on your Mac workstation for development and test purposes. I have a local installation to develop DB2-backed Ruby on Rails...

(Read more)
 

May 19, 2015


Craig Mullins

The Importance of Using DB2 Functions

There are three basic types of built-in functions available to DB2 users: aggregate functions, scalar functions, and table functions.  It is important that you understand what functions are available – as well as what they do – in order to simplify program development and data access. Functions are invoked simply by specifying the function name and any required operands....

(Read more)

Ember Crooks

Generating Log Archive Activity Histograms

A few weeks ago, Ember posted a tweet mentioning that being able to see a histogram showing frequency of transaction log archive activity would be helpful. I had already done some work in this area...

...

Matthias Nicola

How to validate XML in a Stored Procedure?

Encapsulating database operations in stored procedures has a variety of potential benefits. For example, stored procedures allow you to code more complex data manipulation logic than what can be done with an individual SQL statement.  Also, combining multiple operations in a single stored procedure can improve performance because the operations are executed close to the […]

(Read more)

Data and Technology

DBA Excuses… and advice to programmers for overcoming them!

Let’s face it; sometimes it is easier to give an excuse than it is to take the time to answer a technical question. Especially if it’s the third time you’ve heard the same question in the last hour....

(Read more)
 

May 16, 2015


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)

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

My 10 Minute DB2 App on Bluemix

I needed some fun at the end of the workday today. Why not enhance my own skills, do some "coding", and try out Node-RED on Bluemix again (I performed a "phoney" test in October already). This time,...

(Read more)

Henrik Loeser

My DB2 pureScale / Parallel Sysplex Moment

Last week, members of the German union for train operators/engineers were on strike and only a fraction of trains were operating. I had to go to Zurich, Switzerland, but most of the trains on my...

(Read more)

Henrik Loeser

Using dashDB or DB2 with Apache OpenOffice (or LibreOffice)

Yesterday evening, I had some time on my own and didn't want to read. Why not surf in the Internet? That's why there are services like YouTube or Bluemix where you can spend hours without too much...

(Read more)

Henrik Loeser

Dealing with DB2 Security and my Stupidity...

Today I wanted to test some options around encrypting DB2 backups and restoring encrypted database backups. I can report that the security features work, only my stupidity (or call it "vacation...

(Read more)
 

May 15, 2015


DB2Night Replays

The DB2Night Show z58: Must knows about DB2 for z/OS Distributed - Part 2

Presented by: Cristian Molaro IBM Champion and Gold Consultant "The DB2Night Show z58: Must knows about DB2 for z/OS Distributed - Part 2" Replays available in WMV and M4V formats! 100% of our studio audience learned something!Cristian continued his excellent presentation on distributed configuration and many other topics. Watch the replay...

(Read more)

Kim May

Training Anyone?

The Fillmore Group 2H 2015 Class Schedule With all the challenges IBM’s move to the Global Skills Initiative (aka outsourcing education) has created for DB2 users, please remember IBM classes...

(Read more)
 

May 14, 2015


Robert Catterall

For a Large DB2 for z/OS Table, Should You Go With Partition-by-Range or Partition-by-Growth?

There are several aspects to this question: What do I mean by "large?" Is the table in question new, or does it exist already? What is the nature of the data in the table, and how will that data be accessed and maintained? I'll try to cover these various angles in this blog entry, and I hope that you will find the information provided to be useful. What is a "large" table? Why even ask this question? Because the relevance of the partition-by-range (PBR) versus partition-by-growth (PBG)...

(Read more)
 

May 13, 2015


Dave Beulke

IDUG Report: DB2 and Mainframe Continue Strong Performance

Years ago, before I started my career or gave my speech at the first IDUG conference, many declared the mainframe dead. When I was going to college, the uninformed were saying the mainframe was old technology. The new z13 mainframe is not old, IBM just continues to improve it with proven technology...

(Read more)

Ember Crooks

IDUG North American Technical Conference 2015

IDUG North America is over for another year. I enjoyed every minute of the conference this year, and was basically going solid from 7 AM to midnight every single day. I look forward to catching up on...

...
 

May 12, 2015


Craig Mullins

A Trip Report from the 2015 IDUG DB2 Tech Conference

Last week I attended, and spoke at, the annual North American IDUG DB2 Tech Conference in Philadelphia, PA. As usual, the event was busy and chock full of useful and interesting DB2 information. My week started on Sunday with the IBM gold consultant briefing, whereby IBM talks to the gold consultants about their upcoming plans and solicits feedback from us. I can’t really share with you what...

(Read more)

Triton Consulting

Top 10 DB2 Support Nightmares and How to Avoid Them #9

Number 9 in our Top 10 DB2 Support Nightmares series. This month we take a look at what happens when organisations are not able to keep up to date with the latest DB2 technology. 

(Read more)
 

May 08, 2015


Matthias Nicola

IDUG North America 2015: XML and more…

I spent this week in Philadelphia at the annual DB2 user group conference. The week was packed with excellent technical sessions, panel discussions, customer presentations, hands-on labs, seminars, and lots of networking opportunities. As you would expect from such a big event, a very large variety of DB2 and application development topics were on the […]

(Read more)

Willie Favero

May 2015 (RSU1504) service package has been tested and is now available

(Posted Friday May 8, 2015) Testing for RSU service package RSU1504 is now complete. This April 3, 2015 1st Quarter "1st quarter Quarterly Report, 1st Addendum" (55 KB PDF file) contains ALL service through the end of December 2014 not already marked RSU. This service also includes PE resolution...

(Read more)
 

May 07, 2015


Ember Crooks

DB2 Administrative SQL Cookbook: Identifying Dependent MQTs and Views

When you’re considering dropping and re-creating a table, view, or MQT, it is critical to ensure that you consider any dependencies. When dropping a table, any MQTs that rely on it will be...

...

Chris Gruber
Keep the CDN Content in the NHL Playoffs!

Chris Gruber
Keep the CDN Content in the NHL Playoffs!!!
 

May 06, 2015


Willie Favero

Cleaning up after RUNSTATS

(Posted Tuesday, May 6, 2015) RUNSTATS, one of the best tools in a DBA?s toolbox. the importance of accurate statistics in the DB2 catalog cannot be over emphasized. To quote a conversation with a good friend: ?When a customer reports a performance problem with a query or query performance...

(Read more)
 

May 05, 2015


Leons Petrazickis

Free Apache Spark course with Docker image

My friends over at Big Data University just launched a refresh of their Apache Spark course. Spark is an engine for processing and mining large amounts of data quickly. The course takes advantage of...

(Read more)
 

May 04, 2015


Willie Favero

Keeping up-to-date on the latest and greatest IBM technology

(Posted Monday, May 4, 2015) I guessing since you are reading this, you are in some way a fan of the Mainframe. Since you are a fan, then you have probably heard of, attending a teleconference, or read an article/book about the z13 next generation processor from IBM. However, if you have been...

(Read more)
 

May 01, 2015


DB2Night Replays

The DB2Night Show #157: DB2 LUW 10.5 FP5 New Encryption with George Baklarz

Special Guest: George Baklarz, IBM DB2 V10.5 FP5 New EncryptionWMV, MP4, & PDF Available! 100% of our audience learned something! By George, IBM got Encryption Right! Beginning in DB2 LUW 10.5.5, full instance, database, and related objects and files can be easily encrypted. 89% of our studio audience indicated that "We should give due consideration to using it!" when asked "After George's presentation, what do you think about using the...

(Read more)
 

April 30, 2015


Vincent McBurney

Informatica Going into Private Equity Hands and Unknown Territory for $5.3 billion

The news is a couple weeks old now but Informatica has long been the only serious competitor to the IBM Information Server suite of data integration and MDM products and it set to leave the stock market and going into private hands.

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