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

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

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

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

Next Page »

Tag Archives