Triton Db2 Geek

Confessions of a DB2 geek

IBM Gold Consultant Program and IBM Premier business Partner

Client Connections in a TSA/HADR cluster – Part 1

Published February 17th, 2017 - by

Introduction TSA/HADR is a combination of (IBM’s) technologies that facilitates high availability and disaster recovery in a world of DB2 (“High Availability and Disaster Recovery” – that is what HADR stands for). Tivoli System Automation (for Multiplatforms) is the long for TSA(MP). HADR on its own provides mainly Disaster Recovery, by maintaining more than one Continue Reading

DB2 Native REST API – Creating Services

Published February 10th, 2017 - by

Introduction In the first blog in this series, we discussed how to enable the native REST API in DB2 for z/OS. In this edition, we’re going to focus on how we go about creating new services and what methods we used to do this. In doing so, we’re going to be using PHP – which 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

DB2 Native REST API – Getting Started

Published January 17th, 2017 - by

Introduction With DB2 for z/OS customers expanding their business presence into the mobile client world, solution developers are seeking more efficient ways to leverage existing data and business logic to support this. The REST (Representative State Transfer) native API implemented in DB2 is a light weight interface using HTTP POST / GET request handling to 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 »

Tag Archives