DB2 LUW

2018
Top 5 DB2 Support Nightmares 2018 No. 2

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

2018
Recovering from corrupt DB2 Storage Group Control Files

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

2018
Top 5 DB2 Support Nightmares 2018 – No. 1

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

2018
Finding the access path for Columnar queries #3

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

2018
Performance differences between upper-case (XQuery) and UPPER scalar function

I thought I’d share a recent performance issue I had with one of our customers. We’re in the Pre-Production testing stage of a project and our responsibility is a series of Stored Procedures to manage the INSERT, UPDATE and SELECT

Have a Question?

Get in touch with our expert team and see how we can help with your IT project, call us on +44(0) 870 2411 550 or use our contact form…