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 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
Published April 22nd, 2014 - by James Gill
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
Published April 1st, 2014 - by James Gill
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
Published February 19th, 2014 - by James Gill
IFCID 376 is new with DB2 V11, and provides a way for DB2 to tell us about SQL statement compatibility issues with applications running in V11 but in V10 compatibility mode (BIND with APPLCOMPAT(V10R1)). The first field of the returned IFCID data element – QW0376FN – is a full word reason ID, i.e. why the Continue Reading