Triton Db2 Geek

Confessions of a DB2 geek

IBM Gold Consultant Program and IBM Premier business Partner

James Gill

Follow on Twitter LinkedIn

DB2 Dinosaur

Favourite topics – Data Sharing, DB2 pureScale, Sailing.

A multi-talented database consultant, James works with both DB2 for z/OS and DB2 for Midrange systems.

James is our resident DB2 pureScale expert having spent time in the IBM Boeblingen labs and running our own DB2 pureScale environment for R&D. Having worked with Data Sharing on the mainframe for many years James has been able to combine his knowledge of DB2 on Midrange and DB2 on z/OS to gain valuable skills in DB2 pureScale.

Most recently James has been working on a high profile DB2 z/OS data integration project for a major UK Financial Institution.

When he’s not sailing on the Norfolk Broads James can be found working on Triton’s zPDT carrying out various R&D projects.

James's Articles

DDF and DBAT Queuing

Published May 18th, 2015 - by

When working with a customer a couple of years ago, we observed what appeared to be an odd situation, where we were well short of the DDF CONDBAT limit, but new connections to DB2 for z/OS were failing. What could be causing this? What do you mean by…..? Some terminology, just to start off with Continue Reading

A Bit of Trace Data Using DSN1SDMP

Published February 23rd, 2015 - by

Hiding at the end of the stand-alone section in the DB2 Utilities Guide is a tool nominally documented for IBM Support guided use. It can be used to trigger a dump when traced conditions occur to help with targeted diagnostics. It can also start additional traces and capture specific IFCID data instead, and this can Continue Reading

Enumerating DB2 Subsystems

Published November 27th, 2014 - by

Introduction Every site has this challenge and we all find different ways around the problem: How can I generate a list of DB2 subsystems defined to my current LPAR and whether they are active or not? It may be that you want to know exactly that but more commonly this is the sort of thing that Continue Reading

DDF and Dynamic Workload Balancing

Published April 22nd, 2014 - by

Over in the dinosaur enclosure, we’ve been talking about Dynamic Workload Balancing and how it works. We think that there might be a missing link in the terminology, so read on and prepare to embrace “transaction routing”…   What is Dynamic Workload Balancing?   There are two levels of workload balancing implemented in client DDF Continue Reading

Mini-tip : DB2 V11, Arrays and Square Brackets

Published April 1st, 2014 - by

This has probably been around for ages and I just never noticed it, but have spotted (in a V11 manual and thought it was a typo, but it isn’t) that the square brackets can be replaced by the following:   ??(  =  [ ??)  =  ]   Possibly not of any interest until you start Continue Reading

« Previous Page Next Page »

Tag Archives