Triton Db2 Geek

Confessions of a DB2 geek

IBM Gold Consultant Program and IBM Premier business Partner

In-Line Optimization with V11.1

Published April 7th, 2017 - by

Sometimes you might find that the Optimizer has chosen an access path with which you don’t concur. It’s not that likely, as the DB2 Optimizer is one of the most sophisticated of its ilk, but it’s possible that you may know something that the optimizer doesn’t: if, for instance, a table has just had some Continue Reading

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

Client Connections in a TSA/HADR cluster – Part 2

Published March 7th, 2017 - by

In Part 1 I showed how to setup a simple TSA/HADR cluster, consisting of two servers, and what happens to an active client connection in case of a failover. You can read Part 1 here. In this part we will first reconfigure the TSA/HADR cluster to use ACR and then retry the failover and observe Continue Reading

We’re Risk Averse

Published March 3rd, 2017 - by

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 long run. This often strikes me Continue Reading

DB2 Native REST API – A Sample REST Application

Published February 27th, 2017 - by

Introduction In previous blogs in this series, we’ve seen how to install and configure the REST API, and how to create and delete services within it using PHP. This blog will focus on a simple REST application that displays information based on the IBM supplied sample data. Application Overview The Spiffy Computer Company (blame IBM Continue Reading

« Previous Page Next Page »

Tag Archives