The Nightmare Before Christmas

Imagine the scene – a broken database on an unsupported version of DB2, with no backups or log files to recover the database.

Yes – this one really was the stuff of nightmares!


Posted in DB2, DB2 Support | Tagged , , , | Leave a comment

Top Five Reasons For Choosing Remote Database Support – Insecure Future

#5 Insecure Future

Over the last five months we have looked at the top five reasons why customers choose to engage with an external organisation to provide database support services as part of their overall IT infrastructure planning.

An “insecure future” may not be the most obvious reason but sometimes organisations are unsure of their strategic IT direction, particularly the choice of database platform. Investing in permanent staff to support and maintain a database that may not be in the long term plans for the business does not make financial sense. Finding a provider who can take control of ongoing database maintenance until a final decision has been made is a good way around this problem.

Organisations face many challenges in delivering a stable, efficient database infrastructure.  Budget pressures, demands for higher availability and increasing workloads can all mean that pressure is building on IT Management to find a cost effective and reliable way of managing the organisations’ DB2 infrastructure.

RemoteDBA from Triton Consulting provides the highest level of stability for business critical operations.  Our clients receive a superior level of personalised care – day or night – from our team of highly experienced DB2 professionals.

Find out more about RemoteDBA

Read the Top Five Reasons blog series

Posted in DB2, DB2 Administration, DB2 LUW, DB2 Monitoring, DB2 Support, Remote DBA | Tagged , | Leave a comment

Six Reasons to Love DBI Software’s pureFeat™ V6.1 Performance Management Suite

Our partners at DBI software have recently announced the release of the pureFeat™ V6.1 Performance Suite for IBM DB2 LUW. This tool makes it faster and easier than ever to fight the right fires fast. We think there are six top features which makes this the DB2 LUW tool to love:

1. Visual Lock Contention Map – makes it easy and fast to see which connections are blocking others, with the option to terminate either blocker or waiter.

2. SQL Activity – This display allows you to see what SQL statements are currently running and take steps to analyse and improve their performance. The information can be displayed in one of three ways – by CPU consumption, I/O resource usage and by execution time.

3. Last Used Default Schema – The default schema that was last specified by a user is now remembered and used in subsequent explains and physical design requests. A default schema is saved for each database and is unique to each user of the product.

4. New DBM & DB Configuration Displays – Two new tables have been added to the profile configuration panel to show current database manager and database configuration settings for a selected database.

5. Fast Path to Statement Compare from Database Compare – Users are now able to traverse from the “Database Compare Workload” panel directly to the “Statement Compare Workload” panel for the same timeframes. This is a great update because it eliminates the need to re-enter the before and after timeframes for the statement compare panel.

6. Multi-User Workspace Enhancement – Multiple employees sharing the same secure machine will have their user-specific settings respected. This is typically useful in environments using Citrix.

The pureFeat™ V6.1 Performance Suite for IBM DB2 LUW product was recently named as a DBTA trend-setting product for 2015 – find out more

Triton Consulting are exclusive providers of DBI Software products to the UK market, we recently helped Camelot implement the DBI Brother-Panther® product.

Find out more about DBI Software’s pureFeat™ V6.1 Performance Management Suite.

Posted in DB2, DB2 Monitoring, DB2 Tools | Tagged , , | Leave a comment

Tuning zIIPs for Fun and Profit with Julian Stuhler

If you were unable to attend IDUG EMEA in Prague this year you have another chance to learn from Julian’s presentation on “Tuning zIIPs for Fun and Profit”. Julian will be appearing on the DB2Night Show on Friday 5th December.

One attendee at Julian’s IDUG presentation said “One sentence in your presentation made my entire trip to Prague worthwhile” so this is a presentation not to be missed!


In the past few releases, DB2 for z/OS has steadily increased its exploitation of zIIP speciality processors. In addition to providing significant potential for mainframe cost reduction, zIIP offload can have a positive (or negative) impact on DB2 query performance. This presentation will review DB2 zIIP usage by release, and provide the attendee with some practical guidance on zIIP capacity planning and usage monitoring.

Click here to register for this popular webinar.


Posted in DB2, Julian Stuhler, mainframe | Tagged , , , , | Leave a comment

Top Five Reasons For Choosing Remote Database Support – Lack of Skills In-House

#4 Lack of skills in-house

In the fourth instalment of our “Top Five Reasons for Choosing Remote Database Support” blog series we look at DBA skills.

We work with organisations who do not have any DB2 skills in-house and organisations who have skills in-house but access to those skills is limited.

Some organisations may have inherited DB2 systems through expansion or acquisition and do not have the skills in-house to support it. Whilst their own IT team may be able to cope for a while, if any real issues come up, a support organisation with DB2 expertise will be needed.

We have also seen customers facing the need to replace a DBA quickly but who have struggled to find a new individual with the required level of skills. Bringing in a support organisation is a useful way to plug this gap fast with the assurance that you will be getting the highest level of DB2 skills.

Download the white paper – Top Five Reasons for Choosing Remote Database Support 

Find out more about RemoteDBA from Triton Consulting

Read the series so far

Posted in DB2, DB2 Support, DBA, Remote DBA | Tagged , , | Leave a comment

IDUG EMEA 2014 – Rogues Gallery

Firstly, we would like to say a big thanks to all those involved in organising IDUG EMEA 2014 in Prague; to all the hardworking committee members, speakers and of course to all the attendees for making it such a great event.  Thanks also to everyone who attended our drinks reception on the first night.  We had a great time and hope that you did too.  If you couldn’t make it this year then be sure to check the IDUG website for details of next year’s conference in Dublin.

In what is becoming an IDUG tradition we hosted a drinks reception on the first night at IDUG.  As usual our DB2 Geek colleagues were there but this year we had an extra team member!  Below are some photographs, kindly provided by IDUG, of the drinks reception and our Rogues Gallery of DB2 Geeks:

DB2 Geek

DB2 Geek DB2 Geek DB2 Geek IDUG_pics reception geek4 DB2 Geek


IDUG_pics reception geek7

We also ran a DB2 quiz this year which seemed to have a few of you scratching your heads!  Well done to our winners:

1st Prize

Jens Globisch from Datev

2nd Prizes

Olle Nyman from Handelsbanken

Philip Kallender from Handelsbanken

Frederik Engelen from Real Dolmen

3rd Prizes

Per Gustavsson from PG DB Konsult

Michael Tiefenbacher from ids-System

David Mercurio from SEB

DB prize winner

DB2 prize winner

DB2 prize winner

Hope to see you all again along with some new faces next year!


Posted in DB2, DB2 Geek, IDUG EMEA 2014 | Leave a comment

IDUG EMEA 2014 – Day 4

I’m sat in the departure lounge, steadying my nerves after the taxi ride across town. My driver had that fluid yet aggressive style of driving common to city taxi drivers across the globe, coupled with a fondness for Phil Collins easy-listening. I was going to suggest AC/DC might be more appropriate but I didn’t want to distract him any further.

It’s been a vintage IDUG this year; the technical content is always superb and this year was no exception. Highlights for me were the sessions on Query Performance and Optimization by John Hornibrook and the Advanced Diagnostics and BLU acceleration sessions from David Kalmuk. I’m also going to recommend, to both clients and colleagues alike, that they download Steve Rees’ session on “Getting Top Performance from DB2 pureScale” as it could serve as a step-by-step checklist for how to find and identify bottlenecks in a pureScale implementation. Maybe it’s unfair of me to single out just a few sessions as they’re all worthwhile; technical detail, user experience, analysis and R&D sessions alike. But there are over 100 available sessions (not including keynotes and seminars) and you can physically attend a maximum of 19. Some are bound to stick out more than others, but I’m taking home rafts of notes and action points from all the presentations I attended.

Beyond the presentations themselves it’s great to hook up with the wider DB2 community; to see faces you haven’t seen since last year and to meet new ones. I’ve been able to put a face to the name for a number of people with whom I‘ve been exchanging views on technical issues for months. I’ve also met techies and users who have given me a fascinating insight into how DB2 is being used in different industries, in Belgium, Italy, Sweden, New Zealand and all points in between. I’ve gained insights into how some of the bleeding-edge technology of DB2 is being rolled out and used in anger in different industries, right around the world.

And, of course, I was able to offer my thoughts on all of this in my presentation this morning. I’m a relative IDUG ‘newbie’ so I tend to get the slot where people are wheeling their luggage in and looking at their watches to see when they have to leave for the airport. As was I. But, plug adapter and laptop in hand, I ran to my session room and was gratified to find a pretty full house even at this late stage in proceedings. I’d like to once again thank my audience for their attention and interest at the end of what has been a very busy, but hugely informative week at IDUG. A safe trip home for you all, but check to see if your taxi driver has Phil Collins on the CD player.

See you all in Dublin next year!

Posted in DB2, IDUG EMEA 2014 | Tagged , | Leave a comment

IDUG EMEA 2014 – Day 3

This is my first attendance at an IDUG Technical conference. I have been reading and hearing a lot about IDUG over the years, but I have never had the opportunity to attend. I did however have some idea on the conference proceedings from my previous experience of attending a SQL PASS conference. DB2 is my key area of expertise, so I was waiting for the opportunity to attend an IDUG event. And, believe me, it is absolutely fascinating and well worth the wait, especially meeting and listening to all those well-known members of the DB2 community whose books, blogs, articles, white-papers kept me engrossed and helped me throughout my career.

The IDUG conference is the best possible DB2 education you can get anywhere, all the real-world tips and tricks directly from the architects and engineers in IBM and hands-on users around the globe and they are just an email away. I discussed a DB2 upgrade issue I encountered in HA environment with the lead HA architect of IBM. He was very kind to offer his help and shared his contact details for further communication on this issue. Hint and tips like these from fellow members of the IDUG community is what makes people recommend the conference to all other DB2 professionals who wish to enhance their DB2 skills and knowledge.

I arrived at the conference hotel in Prague on a foggy Sunday evening and now we are already on day three. The LUW keynote speech from Paul Z on day one was very exciting and encouraging. Paul’s message to all the DB2 LUW folks like me was to embrace all the new IBM data technologies without hesitation because ultimately DB2 is everywhere, so we should be able to apply our original skills in all the new technologies without much extra effort. Technical sessions are ongoing, moving from one room to another, chatting to other DB2 consultants in the UK and Europe. Overall it is a very refreshing experience.

One word of advice to all those who are planning to take a free certification exam at IDUG – try to take the exam as early as possible. There are lots of attendees all wishing to expand their DB2 knowledge, which may result in a queue for the certification room later in the day.

Posted in DB2, IDUG, IDUG EMEA 2014, Somu Chakrabarty, Uncategorized | Tagged , , | Leave a comment

IDUG EMEA 2014 – Day 2

The sun has been shining and the weather mild so far in Prague for IDUG EMEA 2014. (Who says the British only talk about the weather?) However last time I was in Prague the temperature was -20C and I was knee deep in snow. It just shows that nothing is certain. This was echoed by the excellent ex-poker player Caspar Berry during the opening keynote to IDUG EMEA 2014. The message I took from Caspar’s entertaining presentation was that we should embrace change. We cannot predict the outcome of events for certain, but we can plan to mitigate risk and plan what to do in the event of an unexpected event. Don’t expect for certain that a DB2 version upgrade or deployment of new application code will go exactly according to plan. Great if they do, but plan for the unexpected.

Following Caspar’s keynote and the news from IDUG CPC Chair Cristian Molaro that this year’s attendance is the largest for many years, attendees exited to the main conference hall and every direction I turned people were greeting their fellow IDUGers that they hadn’t seen for 12 months since IDUG EMEA 2013 in Barcelona. “Have you planned your DB2 11 z/OS upgrade yet?”, “Are you using DB2 BLU?” Lots of noise and lots of questions. With increasing numbers in attendance there is a real buzz about IDUG EMEA this year. There are also more First Time attendees than I have seen before, perhaps down to the successful Mentor programme.

Talking of numbers and buzz, there were also record numbers at the Triton Monday Evening event this year. Crowds of people were quickly taking on the DB2 Geek Geometric quiz, challenging even the most experienced of techies. A lot of head scratching and puzzled looks from every table. For some the quiz was too testing and so instead tried out the DB2 Geek life size cut out for size. Well done to all those that attempted the Geometric challenge and especially to our prize winners. There are a few sore heads around this morning but soon forgotten following some entertaining and insightful technical sessions. And more of the same tomorrow.

Hard to believe we’re nearly on day 3 of IDUG already and it will soon be over with everyone already looking forward to IDUG EMEA 2015 in Dublin. Nothing is certain of course, but I will certainly be doing my upmost to make IDUG again next year. The best DB2 education event there is.

Posted in IDUG, IDUG EMEA 2014, Paul Stoker | Tagged , , , | Leave a comment

IDUG EMEA 2014 – Day 1

So, that’s another IDUG EMEA conference opening day in the history books – my 16th since I attended my first conference in Barcelona back in 1997. I actually arrived in Prague yesterday morning after a VERY early flight from the UK. That gave me a few hours to re-acquaint myself with the Clarion Congress Hotel (IDUG was at the same hotel 3 years ago) and enjoy my first Staropramen of the week in Prague’s Old Town. There was no time for an extended sightseeing session though, as I wanted to attend the DB2 for z/OS Customer Advisory Council meeting on Sunday afternoon. I really enjoy these sessions, which provide a great opportunity for key DB2 customers and Gold Consultants to provide direct input into IBM’s plans for future releases of DB2. The “Cypress” release of DB2 for z/OS is shaping up nicely, and I’m looking forward to learning more about the exciting new features as they are finalised in the coming months.

Sunday evening was inevitably spent in the vicinity of the hotel bar, catching up with many old IDUG friends and making a few new ones. It was good to see several first-time IDUG attendees around in addition to the usual suspects who make the IDUG pilgrimage every year.

A combination of client work and IDUG Content Committee commitments meant I could only attend a few technical sessions today, but John Campbell’s Migration Planning presentations are always worth attending and the current DB2 11 iteration is no exception. The lunch and coffee breaks seemed to be very busy, and I’m guessing the numbers are well up on last year’s conference. The Triton DB2 Geeks have been busy mingling and giving out invites to this evening’s party, which has become a much-anticipated part of the IDUG social schedule in recent years. This year’s “geometric quiz” is one of the harder competitions we’ve run recently, and I’m looking forward to finding out how many people manage to crack it.

That’s it for today, I’m off to set up for tonight’s party before helping to man the Content Committee stand in tonight’s Exhibition Reception. One of my fellow DB2 Geeks will pick up the story tomorrow, but so far my 16th EMEA conference looks like it’s going to be every bit as valuable and enjoyable as the previous 15 have been.



Posted in DB2 Geek, IDUG, IDUG EMEA 2014, Julian Stuhler, Uncategorized | Tagged , , | Leave a comment