Triton Db2 Geek

Confessions of a DB2 geek

IBM Gold Consultant Program and IBM Premier business Partner

Category Archives: DB2 LUW

ZLOAD – Mid-Range Data LOAD into DB2 for z/OS

Published March 13th, 2017 - by

Introduction Most customers will have to deliver external data to DB2 for z/OS from time to time. For some, this will be a daily feed of volume data from clients and business partners, whilst for others it might be smaller mid-range generated test data. All will have faced the usual challenges delivering data from mid-range Continue Reading

We’re Risk Averse

Published March 3rd, 2017 - by

Find the latest blog, Best Practice.  I’m in danger of sounding like an episode of Grumpy Old Men, but this is another of those expressions that grates a bit for a database support consultant. In my previous blog (If it ain’t broke, don’t fix it) I mentioned one expression that stores up problems in the Continue Reading

2017: A year for DB2 11.1

Published February 22nd, 2017 - by

If your databases are on DB2 9.7 or DB2 10.1, then September 30, 2017 is a date that should be at the forefront of your mind. Both DB2 9.7 and DB2 10.1 go out of support on this date. As you start thinking about your upgrade plans to either DB2 10.5 or better still DB2 Continue Reading

If it ain’t broke, don’t fix it

Published January 31st, 2017 - by

Ever heard this expression? One of my least favourites. Flip it over and express it the other way around: Wait until it breaks and then try and fix it I don’t think that is something you seriously want to consider in a Production environment and yet it is something we come across as database support Continue Reading

SQL Query Tuning Exercise

Published November 16th, 2016 - by

In this exercise we shall look at several different methods of tuning a poorly performing SQL query. The Problem The Original SQL Query The Original Access Path So, where is the problem? Looking at the Access Path chosen by the DB2 Optimizer, all looks well – all tables are either accessed via indexes, or not Continue Reading

« Previous Page Next Page »