BLU Hits and Misses – the replay

Replay! If you missed the last DB2Night Show of 2017 then fear not, our partners over at DBI Software HQ have made the replay of Mark Gillis’ DB2 11 Performance: BLU Hits and Misses available as a replay.

Take a look, there’s nothing to lose, in fact 100% of the live audience learned something.

Download the replay.

Posted in DB2, DB2 11.1, DB2 BLU, DB2 LUW, Mark Gillis | Tagged , , , | Comments Off on BLU Hits and Misses – the replay

Have you got Christmas covered?

With Christmas just around the corner now is a good time to consider additional support over the holiday period. Perhaps you have a small in-house team or are struggling to find DB2 resources. Providing adequate cover for your DB2 databases over the holiday season can be difficult, especially with an increasing requirement for systems to be available 24×7 with DBA cover required at all times. This can put real pressure on already overstretched DBA teams.

With Triton’s RemoteDBA office service you can be assured that your DB2 Databases are left in capable hands whilst your DBAs take a well-earned break.

Available in personalised packages that suit you and your company you can choose from Remote DBA Office, or Remote DBA 24×7. Each package has an optional enhanced offering which allows customers to benefit from faster guaranteed response times and coverage for a larger number of databases.

We offer

  • Fixed price with no hidden extras guaranteed!
  • Unlimited support calls
  • Unlimited support hours
  • Unrivalled DB2 expertise
  • No performance monitoring tool costs
  • Database health check included

Details of the individual RemoteDBA packages can be found here

Not ready to commit to full-on Remote DB2 support?  We understand that it’s a big step, so why not try our Consultancy on Demand service which comes in smaller, bitesize pieces, ideal for training, development work or to provide specific skills where they are absent in the team.

Find out what our customers have to say about our RemoteDBA and CoD support services.



Posted in DB2 Support, Remote DBA | Tagged , , , | Comments Off on Have you got Christmas covered?

IBM Db2 12 for z/OS Technology Workshop & Migration Planning

Join Tom Crocker, Rob Gould and Karen Wilkins for a Db2 12 Technology Workshop and Migration Planning event. Run by IBM, the one day, face to face event will take place on Monday, 13th November at South Bank, London. Spaces are limited and offered on a first come, first serve basis.

Whilst focusing on how it is possible to quickly upgrade to Db2 12 for z/OS and how to exploit the new features and functions, the presenter’s main objectives for the day are as follows:

  • Technical Overview of Db2 12 for z/OS which will cover performance enhancements for traditional workloads, performance enhancements for modern workloads, application enablement enhancements, reliability, availability, scalability and security
  • Explanation of how you can exploit new features and functions quickly to save time and money
  • Explanation of DB2 12 migration process – The speakers will provide hints and tips, address some myths, provide additional planning information, and provide usage guidelines and positioning on new enhancements. The main objective is to help customers migrate as fast as possible, but safely and encourage version to version migration.

For further details of the event and registration click here.





Posted in DB2 12, IBM | Tagged , | Comments Off on IBM Db2 12 for z/OS Technology Workshop & Migration Planning

IDUG 2017: Best Bits and Geek Gallery

This gallery contains 25 photos.

It’s hard to believe that Bonfire Night is almost upon us and that it’s been a month since our trip to glorious, sunny Lisbon where some of the Triton team had the pleasure of attending another fantastic IDUG EMEA Technical … Continue reading

More Galleries | Comments Off on IDUG 2017: Best Bits and Geek Gallery

DB2 11 Performance: BLU Hits and Misses on the DB2Night Show

A forthcoming date for your diary that you won’t want to miss! On Friday 15th December, Mark Gillis, IBM Champion and Principal Consultant at Triton Consulting will be the guest presenter once again on DBI Software’s DB2Night Show.

Based on his popular IDUG Lisbon DB2 technical session Mark will be presenting Episode #200: DB2 11 Performance: BLU Hits and Misses.

During the show Mark will examine some ‘real’ workloads and a comparison between 10.5 and 11.1 on the processing done ‘under the covers’. Mark will also look at some of the inevitable gotchas and pitfalls.


  • Provide a brief overview of BLU columnar technology
  • Present examples of workload performance in V10.5
  • Explore the benefits of V11.1 for your workload
  • Produce examples of where the BLU savings are
  • Gotchas: Where you might not find the advertised benefits

Register for this DB2Night Show episode here

Mark has also written blogs on the latest version of DB2 LUW; In-Line Optimization with V 11.1 and his latest blog Finding the Access Path for Columnar Queries.

Posted in DB2 11.1, Mark Gillis | Tagged , , , | Comments Off on DB2 11 Performance: BLU Hits and Misses on the DB2Night Show

The IDUG Buzz

In the lead up to an IDUG EMEA Technical Conference the Triton office can seem a bit fraught. The technical team are usually tweaking their presentations whilst I’m finalising plans for the Triton and DBI Software drinks reception. This year was no exception. It was going to be my first year attending an IDUG Conference, which also meant the first time attending our event. So no pressure!

In keeping with tradition the main stress occurred prior to the event thanks again to our chosen despatch company, mention no names, of course.  Five out of six boxes containing all our party invitations and promotional gifts arrived safely in Portugal, the sixth landed in Poland! Thankfully the final box made an appearance the morning of the reception. We are yet to have a year when the Triton boxes (or suitcases) don’t go awry.

Once landed, the Sunday evening began with a few members of the Triton team exploring the streets of Lisbon, checking the Geocaching clues in preparation for the competition. The weather was hot and the temperature was forecast to rise. We began questioning how many delegates would actually leave the comfort of an air conditioned hotel to complete the DB2 geek quiz. How keen were the IDUG contingency on winning a Roomba robot hoover? Only time would tell. The following day was spent promoting the competition and event on social media and at the IDUG Welcome Reception.

The crowd started building in the foyer of the IDUG reception and there was a real buzz in the air.  I met with Scott and Chad from DBI Software, one of Triton’s business partners and set up the IDUG mobile app ready to start my scanning responsibilities. I was completely unaware that the majority of the people behind the ceremonial ribbon were planning on making a beeline to the DBI stand in order to pick up an invitation to our party later that evening; I knew we limited guest numbers but I didn’t realise invitations were in such high demand.

The drinks reception itself went down a storm. Everyone I talked to really enjoyed the evening, not only the food, drink and competition but also the networking. Congratulations to our competition winners, particularly Roland Schock who was crowned the Geocaching Champion and got to take home the Roomba robot.

So what were my first impressions of an IDUG conference? Well, they couldn’t have been more enjoyable. I thoroughly enjoyed the buzz of scanning delegate badges and what was so great about the whole IDUG experience was finally putting faces to all the names that I have connected with on the various social networking sites over the past six years.

It was also great to know that I wasn’t the only IDUG fresher at our party; there were quite a few fresh faces in the crowd and good to hear some young mainframers coming through the ranks too.

It’s amazing how quickly the days went. Before I knew it I was back on the plane to the UK. I’m already looking forward to planning next year’s event, so much so that we have already had our first planning session.

Thanks Lisbon, thanks Triton and thanks to the IDUG EMEA Conference Planning Committee for a fantastic few days.


Posted in IDUG, IDUG EMEA 2017 | Tagged , | Comments Off on The IDUG Buzz

Db2 Day – Db2 on Linux, Unix, and Windows. You’re invited!

IBM has just announced details of a complimentary event, Db2 day – Db2 on Linux, Unix and Windows. The face to face event, presented by George Baklarz, IBM Db2 Program Manager will cover the latest enhancements to Db2.

Attendees will have the opportunity to sharpen their knowledge and skills on the latest developments from the IBM labs which include:

  • Db2 V11 fp1/fp2
  • SQL V11 update
  • Db2 Open Data (OData)
  • Db2 JSON
  • Db2 Developer-C, Tools, and Docker support

Db2 Day will take place on Monday 13th November at IBM Southbank, London and will also include a number of Db2 developer sessions. Find the full agenda here.

Simply click to register for this must attend event. Spaces are limited, so be quick!

Additional info

George Baklarz is an IDUG Hall of Fame speaker. George won the best Overall Speaker award for his session Db2 11.1 SQL V11 update at IDUG Lisbon 2017. He will be presenting this session on the Db2 day on November 13th. George Baklarz presentation on Db2 JASON was also in the Top 10 Overall presentations at IDUG Lisbon 2017

Posted in DB2, DB2 11, IBM | Tagged , | Comments Off on Db2 Day – Db2 on Linux, Unix, and Windows. You’re invited!

Heads-up! DB2 Geek Geocaching Competition

With less than a week to go until IDUG EMEA conference in Lisbon we thought we’d give our fellow DB2 Geeks a heads-up on what they’ll need in advance of the Triton and DBI Software competition set to run from midday on Monday 2nd October.

This year’s quiz will be based on a “geocaching” theme, with contestants using a combination of the GPS in their phones and a series of clues to find certain locations in the area surrounding the IDUG conference hotel, the Epic Sana. As always, there will be an element of DB2 technical knowledge required to solve the clues and each clue will be individually posted on Twitter throughout the day on Monday.

Contestants will need the following:

  1. A GPS-enabled phone with an active data plan and the Google Maps app installed (or an equivalent app that allows GPS coordinates to be entered and shown on a map).
  2. Follow @DB2Geek on Twitter, to receive the clues. Don’t have a Twitter account? Set one up here.

@DB2Geek will begin tweeting clues at midday on Monday 2nd October. There will be four clues in total, and the answer to each one will be needed in order to solve the next. Solving the final clue will give you a numeric code that you’ll need to be in with a chance of winning one of our great prizes.

Our partners DBI Software will be handing out a limited number of invitations to the Triton/DBI drinks reception from booth 4 during the IDUG Expo reception on Monday evening. Simply enter the final numeric code on the reverse of the invitation along with your contact details. During the drinks reception, all cards with correct answers will be placed in a tub and randomly drawn for the prizes.

This year’s top prizes include:

  • 1st Prize – 1 x Roomba 650 Robotic Vacuum Cleaner
  • 2nd Prize – 3 x Lugloc Luggage Tracker
  • 3rd Prize – 5 x Tile Slim Item Tracker

So join us at La Trattoria restaurant, Rua Artilharia Um, 79, just a three minute walk from the Epic Sana hotel and don’t forget to pack your comfy shoes.

Keep up to date on our event and other IDUG EMEA updates by subscribing to our newsletter, or following us on Twitter and/or LinkedIn.


Some Geeky Technical Details

The answer to each of the quiz clues will be a numeric latitude/longitude, in Decimal Degrees (DD) format (e.g 52.5695, 1.3568). Please see the Wikipedia article here for more information on this format.

Once you have your answer, you can use Google maps to lead you to the next location. Not sure how to do that? More info can be found on Google’s support page, here.

Posted in IDUG EMEA 2017, Uncategorized | Tagged , | Comments Off on Heads-up! DB2 Geek Geocaching Competition

Geocaching with the Geeks at IDUG

It’s almost that time of year again! The Triton Consulting and DBI Software drinks reception at IDUG EMEA, which has become an annual event, is less than 2 months away. Join us on Monday 2nd October from 8:30pm and chat to fellow Geeks about the latest DB2 (aka Db2) developments. There have been quite a few changes since our last catch-up, so we’re sure they’ll be lots to discuss.

This year’s reception will take place at La Trattoria restaurant, Rua Artilharia Um, 79, just a three minute walk from the Epic Sana hotel. Don’t forget to pick up a party invitation from DBI Software’s booth (number 4). Invitations are limited, so be quick!

The DB2 Geek returns with a new, brain teasing challenge to test your skills (and legs). To be a winner you’ll need to pit your wits against fellow DB2 Geeks.  We’ll be running a Geocaching competition with a twist or should that be a Tweet? To participate you’ll need to follow the @DB2Geek on Twitter. Don’t have a Twitter account? It’s easy to set up. Watch out for the first clue (or create an alert), we’ll be tweeting at some point on the Monday. Winners of the competition will be announced on the night. Will you be crowned the geocache champion?

We’ll also be providing further information on the competition leading up to the event, as well as confirming this year’s prizes, so we suggest subscribing to our newsletter, or following us on Twitter and/or LinkedIn to keep up to date.

We look forward to seeing you soon for drinks, nibbles, prizes and more. Have a safe journey, oh and happy hunting!


Posted in IDUG EMEA 2017 | Tagged , , , | Comments Off on Geocaching with the Geeks at IDUG

Three is the Magic Number – Triton Trio to Present at IDUG EMEA 2017

We are delighted to announce that three members of the Triton Consulting team will be heading to Lisbon this year to present at Europe’s biggest and most prestigious DB2 technical conference, IDUG EMEA*. This year’s conference will take place at the Epic Sana Hotel from 1st – 5th October 2017 and will include five days of educational sessions, half and full day workshops and in excess of 100 one hour technical sessions.

“We are thrilled that all three members of the Triton team who submitted an abstract have been selected to present this year. It is always such a great privilege for us to be able to share our knowledge and recent experiences with fellow members of the DB2 Community at such a renowned event.” Carol Davis-Mann, Marketing Manager.

As in previous years Triton’s presentations will cover both DB2 LUW and DB2 z/OS topics.

Julian Stuhler, Solutions Delivery Director at Triton Consulting, is well known in the DB2 community for his excellent presentations and his status as an IBM Gold Consultant.  Julian will be presenting on Total Recall: Exploiting In-Memory Features in DB2 12 for z/OS. Julian will provide an overview of the ways in which DB2 is evolving to exploit more real memory, reduce CPU and deliver improved price/performance, with a specific emphasis on exploiting new DB2 12 in-memory features such as contiguous buffer pools and Fast Traverse Blocks (FTBs).

James Gill, Principal Consultant will share his vast knowledge of REST API to the IDUG audience. James’ presentation REST Easy with DB2 For z/OS – Services Made Simple will provide an overview of the new capabilities, how to create and consume REST services using it and what methods can be used to achieve this.

Mark Gillis, Senior Consultant at Triton Consulting will also be presenting this year. Mark’s session on DB2 11 Performance: BLU Hits and Misses will examine some ‘real’ workloads and a comparison between 10.5 and 11.1 on the processing done ‘under the covers’. Mark will also look at some of the inevitable gotchas and pitfalls.

Find out further information on this year’s IDUG EMEA agenda or benefit from the Early Registration discount here.Mark

*The International DB2 User Group (IDUG) is an independent organisation providing educational events, technical resources and peer-driven product training to its members.

Posted in IDUG EMEA 2017, James Gill, Julian Stuhler, Mark Gillis | Tagged , , , | Comments Off on Three is the Magic Number – Triton Trio to Present at IDUG EMEA 2017