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

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

DSNWMSGS and IFCID 376

Published February 19th, 2014 - by

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

Accelerator Modelling in IFCID 3

Published February 19th, 2014 - by

For more years than I care to mention, I’ve been tinkering with bespoke DB2 monitoring. Wiser heads have always come back with the (not unreasonable) call that this is bonkers as:   a) We already have a monitor b) Who’s going to maintain mine if I fail the bus test   So, just when I’m beginning Continue Reading

Assembler : Getting DB2 Traces Started to OPn

Published July 29th, 2013 - by

In the previous post I talked about getting our assembler monitor connected to DB2 for z/OS with the intention of getting some statistics traces running and gathering the data cut by DB2. This time we’re going to look at how we actually got the traces running.   As you’ll know from your extensive reading of Continue Reading

Assembler : Getting Connected to DB2

Published May 7th, 2013 - by

At the end of another week of chasing my tail and trying not to get in too much trouble with Mrs DB2 Dinosaur, I’ve resolved to write a quick post about getting the assembler component of the DB2 monitor connected to DB2. Whilst this is fairly well documented in the manuals, we have a slightly Continue Reading

« Previous Page Next Page »

Tag Archives