Published May 18th, 2015 - by James Gill
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
Published May 15th, 2015 - by Mark Gillis
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
Published March 23rd, 2015 - by DB2 Geek
When DB2 BLU columnar architecture was introduced in DB2 10.5 GA, it was not possible to create a columnar table in a database which is the primary database in an actively connected HADR pair. This prevented a true DR solution. However, from Fixpack 4 HADR now supports columnar tables. A column-organized table created in an Continue Reading
Published February 26th, 2015 - by Paul Stoker
20 years ago, the Mainframe was the operating system of choice to host applications critical for business operation. And 20 years ago, for the minority of people who had a mobile phone, functionality was limited to, well phone calls (and maybe the Snake game). Even SMS texting was years away for the majority of people. Continue Reading
Published February 23rd, 2015 - by James Gill
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