REORG SHRLEVEL CHANGE – aiming at 24x7 – Part I

As I have seen in sites where I worked, there is some confusion regarding the parameters of the REORG utility. Everybody would like to have true 24x7 systems using online REORG SHRLEVEL CHANGE, but in order to be on the safe side, they used SHRLEVEL REFERENCE instead. When DB2 performs a REORG with SHRLEVEL CHANGE, it builds the shadow files the same way as it does with REORG SHRLEVEL REFERENCE, … Continue

DB2 for z/OS Version 8 product publications have been refreshed (Oct 2009)

We (or maybe just me) spend so much time talk DB2 9 for z/OS, we often forget that we (IBM) still have customers running DB2 Version 8. With that in mind, I want to let all of my DB2 V8 friends know that 6 of your DB2 V8 product publications have been updated. … Continue

DB2 9 for z/OS product publications have been refreshed (Oct 2009)

DB2 land has stated on many occasions that you can always find the most current and up-to-date DB2 information in the web. Holding true to that statement, the entire DB2 9 for z/OS product library on the web has been updated as of October 2009. My thanks to Perry for catching the update and notifying me so I could make this post in a timely fashion. … Continue

Patent Reexamination Hurdle Remains For Data Integration Patent

The JuxtaComm ETL patent will not be challenged in court after all defendants settled but it will face reexamination from the patent board. … Continue

Watch The DB2Night Show episode 5 Nov 12 11am EST

Watch The DB2Night Show episode #5 Nov 12 11am EST " SQL Snapshot Potluck Party " with special IBM guest Chris Eaton In this episode of The DB2Night Show , special guest Chris Eaton from IBM will share his TOP 10 Favorite SQL...

IBM Reveals the First Fourteen InfoSphere Information Champions

I was fortunate to be included in the list of the first IBM Information Champions for contributions to the InfoSphere software community. … Continue

DB2 for zOS Webcasts on Demand

DB2 for z/OS Webcasts on Demand Join this group created by Surekha Parekh to catch up on any webcasts that you may have missed. This group will list all DB2 for z/OS webcasts & teleconferences available to you FREE on demand all year ! Susan

Top 10 Ways to Save Money on the Cloud with DB2

One of the main benefits of Cloud Computing is cost savings. With a credit card and less than a dollar an hour, you can provision compute resources within minutes. But once inside the Cloud microcosm, there are even more ways to save money. Here are some of the best practices for saving money with DB2 on the Cloud: 1) DB2 Express-C This is DB2, the real product, for free (as in beer). DB2 Express-C has the same code base that is used in enterprises world-wide. You can get DB2 Express-C on Cloud …

Updated draft MySQL to DB2 migration guide

Whei-Jen Chen and Angela Carlson have prepared an updated and more comprehensive draft of the venerable MySQL to DB2 Conversion Guide to cover migrations from MySQL 5.1 to DB2 9.7. The original version of this IBM Redbook published five years ago looked at migrating database applications from MySQL 4.0 to DB2 8.1. Chapter 6 [...] … Continue

How much does Google know (officially)?

Earlier this week I asked "How much data do I generate?", now I saw that Google is adding another service, the "Google account dashboard", that let's you see what Google is knowing about you. Supposedly. It's interesting to see statistics about your account activities in one place. The interesting question is how do you interpret, how do you analyze it (from Google's perspective)? What does … Continue