Triton Db2 Geek

Confessions of a DB2 geek

IBM Gold Consultant Program and IBM Premier business Partner

Category Archives: DB2 LUW

Top 5 DB2 Support Nightmares 2018 No. 2

Published September 12th, 2018 - by

In part 2 of our new series of DB2 Support Nightmares we look at the implications of a “Suck it and See” development approach. This could be strongly related to the Support Nightmare #1, but not necessarily always. Sign-up to receive DB2 Support Nightmare updates or download our previous series ‘Top 10 DB2 Support Nightmares and How Continue Reading

Recovering from corrupt DB2 Storage Group Control Files

Published August 17th, 2018 - by

Recently, we received a distress call from a client who was unable to access their production database and the data within. Client’s main aim was to recover the data from the database by any possible means. The (short) description of the situation was: -there are two DB2 instances on the server, one TEST and one Continue Reading

Top 5 DB2 Support Nightmares 2018 – No. 1

Published August 3rd, 2018 - by

Single User Access In part 1 of our new series of DB2 Support Nightmares we look at the implications of only having one userid for all users to use and the frighteningly consequences.   Sign-up to receive DB2 Support Nightmare updates or download our previous series ‘Top 10 DB2 Support Nightmares and How to Avoid Them‘ here.

Finding the access path for Columnar queries #3

Published March 13th, 2018 - by

In the first blog in this series ( Finding the access path for Columnar queries ) I was griping about not being able to see any detail in the explain plans for what DB2 is doing when you see a table scan (TBSCAN) of a column-organized table. I mention that each columnar table will have Continue Reading

Next Page »