Triton Db2 Geek

Confessions of a DB2 geek

IBM Gold Consultant Program and IBM Premier business Partner

Category Archives: DB2 z/OS

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

DDF and Dynamic Workload Balancing

Published April 22nd, 2014 - by

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

A Sysprog’s Perspective – DB2 11

Published March 24th, 2014 - by

In a new podcast series we take a look at the world of DB2 from a Sysprog’s perspective.  We have recorded two podcasts specifically about DB2 11 with Julian Stuhler and James Gill. Click on the podcast below to listen or download 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 »