IBM Launches z13 Mainframe

IBM have recently announced the launch of the z13 Mainframe. The latest version of the iconic Mainframe has been designed to deliver scale and economics together with real-time encryption and analytics to help meet the expectations of consumers for speed and safety for trillions of transactions in the mobile economy.

The highlights:

- First system to process 2.5 billion transactions per day, built for the mobile economy

- Makes possible real-time encryption on all mobile transactions at scale

- First mainframe system with embedded analytics providing real time transaction insights 17x faster than compared to competitive systems at a fraction of the cost

Read more from IBM

Learn more in an IBM z13 Technical Workshop

Posted in mainframe, System Z | Tagged , , | Leave a comment

DB2’s Got Talent: The Search Returns

It has been almost a year since our partner DBI Software crowned the current DB2’s Got Talent Champion, Mike Krafick. Once again DBI are searching for participants to enter the hugely successful annual contest and we are thrilled to be sponsoring the competition again this year.

DB2’s Got Talent encourages contestants to share their recent DB2 LUW or z/OS experiences, challenges and successes encountered during the past 12 months in an educational, informative yet fun and entertaining way. If you think you fit the bill and wish to compete for this year’s crown* you can find out further information on how to enter the competition here.

Not only will you gain great respect from the DB2 community, there are also some top prizes up for grabs.

This year’s prizes are as follows:

  • 1st Prize: One FREE IDUG Conference Registration to any IDUG Conference in 2015 (North America, Europe, or Australia) provided by IDUG, plus up to $1,500 USD travel expense allowance provided by DBI. Approximate value of prize package: $3,500 USD
  • 2nd Prize: One FREE DB2 Symposium Registration (3 Days) to any Event in 2015 provided by KBCE, plus up to $1,000 USD travel expense allowance (sponsor pending).
  • 3rd Prize: Apple iPad (approximate value $500) provided by Responsive      Systems.
  • Finalist Prizes: Each of the top 10 Contestants that are invited by the judges to participate in Finals Shows will win $50 Gift Certificates provided by ourselves Triton Consulting.

*no crown included

Posted in Uncategorized | Leave a comment

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