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.
Published February 10th, 2017 - by James Gill
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
Published January 17th, 2017 - by James Gill
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
Published May 18th, 2015 - by James Gill
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
Published February 23rd, 2015 - by James Gill
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
Published November 27th, 2014 - by James Gill
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