Triton Db2 Geek

Confessions of a DB2 geek

IBM Gold Consultant Program and IBM Premier business Partner

DB2 Geek

Follow on Twitter

Top Geek

Favourite Topics – All things DB2 with a special love for DB2 Performance Tuning, DB2 10.5 LUW, DB2 11 z/OS, Flying Helicopters, Canoeing and Travel.

I’m Triton’s top DB2 Geek. Ask me anything DB2!

DB2's Articles

Confession of the Month

DB2 z/OS Quick Tuning Tip

Published May 27th, 2011 - by

Anyone who has spent any time tuning DB2 for z/OS applications will know how painful the occasional dataset open/close process can be – there’s even a specific accounting class 3 suspend counter for it. The problem is even worse when large numbers of datasets have to be opened or closed all at once, such as Continue Reading

Sathy’s SECADM Secrets

Published April 4th, 2011 - by

In the recent post – SECADM Musings, Iqbal discussed the RESTORE scenario in 9.7 where the privileges will be ‘lost’ when restoring the database to a different instance and a work around for the situation. There are other ways to tackle the same issue and here are two of them.   a) Consider that a Continue Reading

Make sure your tools are up to the job

Published March 14th, 2011 - by

We had a customer who had a COGNOS 8/BI development environment running against DB2 AIX V9.5. They were having issues with extremely long elapsed times for COGNOS-generated queries (over 30 minutes!). Temp space was being exceeded and users were increasing it but still experiencing the same problem. The users checked COGNOS which seemed fine and Continue Reading

« Previous Page Next Page »

Tag Archives