Triton Db2 Geek

Confessions of a DB2 geek

IBM Gold Consultant Program and IBM Premier business Partner

RUNSTATS versus Actuals

Published June 10th, 2015 - by

Now and again we get a slightly panicky call from one of our clients as they attempt to execute some part of their application and it takes far longer to run than it should, or than it did the last time it was executed. Our first question is usually “have you run REORGs and RUNSTATS Continue Reading

DDF and DBAT Queuing

Published May 18th, 2015 - by

When working with a customer a couple of years ago, we observed what appeared to be an odd situation, where we were well short of the DDF CONDBAT limit, but new connections to DB2 for z/OS were failing. What could be causing this? What do you mean by…..? Some terminology, just to start off with Continue Reading

Pivoting and Unpivoting data with pureXML

Published May 15th, 2015 - by

I am sometimes presented with data that, although stored in the relational database, still needs some ‘massaging’ to be meaningful. An issue that would fall into that category would be where a set of values has been stored in a string; in order for this to be usable I really need to “unpivot” it so Continue Reading

Next Page »

Tag Archives