Triton Db2 Geek

Confessions of a DB2 geek

IBM Gold Consultant Program and IBM Premier business Partner

Category Archives: Mainframe

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

A Sysprog’s Perspective – DB2 11 Part 2

Published April 29th, 2014 - by

Join Julian Stuhler and James Gill as they take a look at DB2 11 from a Sysprog’s perspective.  This is part two in the series.  Click here to listen to part 1.

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

« Previous Page Next Page »