Triton Db2 Geek

Confessions of a DB2 geek

IBM Gold Consultant Program and IBM Premier business Partner

Category Archives: Mainframe

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

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

« Previous Page Next Page »