Top 10 DB2 Support Nightmares and How to Avoid Them #9

Number 9 in our Top 10 DB2 Support Nightmares series. This month we take a look at what happens when organisations are not able to keep up to date with the latest DB2 technology. 

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

IDUG EMEA 2015 – Call for Presentations

We are delighted to let you know that IDUG is now accepting presentation abstracts for the IDUG DB2 Tech Conference which will take place in Dublin from 15-20th November.

Being an IDUG presenter is a great opportunity to share your DB2 experiences and expertise with an audience of your peers.  If your presentation abstract is selected you will also receive one complimentary conference registration.

The Conference Planning Committee are looking for presentations on a range of DB2 related topics including:

  • New DB2 releases: migrating and effective usage
  • Analytics & Business Intelligence
  • New Technologies: Mobile Applications, Cloud….
  • Performance, Availability & Security
  • Application Development and Data Modelling
  • DB2 and Packaged Applications
  • User Experiences and Best-Practices; What did you achieve with DB2?

Visit the IDUG website to find out more

Posted in IDUG | Tagged | 1 Comment

Top 10 DB2 Support Nightmares and How to Avoid Them #8

Number 8 in our Top 10 DB2 Support Nightmares series. This month we take a look at what happens when organisations are not able to keep up to date with the latest DB2 technology. 

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

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 , , | 1 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 | 1 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