IDUG EMEA Malta 2018 – Day 1

IDUG EMEA always provides interesting content. Whether it’s John Campbell’s greatest hits (INSERT ALGORITHM 2 disable / re-enable, enhanced dynamic workload placement in Connect 11.1 M4 FP4, real storage management fun), or our own Julian Stuhler (Cloudy With a Chance of DevOps – A Survival Guide) and Damir Wilder (SQL Tuning Basics: Simple Steps to SQL Sufficiency), there was plenty of good presentation material today.

The weather here is much warmer than back home in the UK – 23 Celsius rather than 3! Talking to a couple of customers, it seems that the beach – about 2 minutes walk from the hotel – has been established as the best place to hold meetings.

In previous years, Triton have run a large drinks (and a little food) party with DBI on the Monday evening. DBI decided not to come to Malta, so we tried something a bit different this year and took our customers and a few friends out to dinner at the Caviar and Bull restaurant a short walk around the harbour from the conference hotel. Good company and a wonderful meal – lots of sharing dishes, including some theatre with some dishes arriving with smoke (intentional!) under the lids, and another with liquid Nitrogen!

 

If you didn’t come this year, you missed a good venue and a lot of great content. One way to get to IDUG is to be a speaker at the conference. The committee would much rather hear presentations given by real customers, rather than vendors and consultants and the conference fee is waived for speakers, so put a few thoughts together and come and join us next year.

Share
Posted in DB2, IBM Champion, IDUG EMEA 2018, James Gill | Tagged , , , , , | Comments Off on IDUG EMEA Malta 2018 – Day 1

Malta, here we come!

Malta is an upcoming location for business and culture given that it held the Presidency of the Council of the European Union in 2017 and the City of Valetta, Malta has been selected as the European Capital of Culture 2018. A Blockchain conference with 8,000 attendees from across the Globe was held this week at the Intercontinental – IDUG conference hotel.

All roads lead to Malta this weekend for more than 450 IDUG members. I’m really excited about IDUG EMEA this year. The venue is fantastic and we have such a great line-up of speakers from users to IBM experts, long-time IDUG speakers and first-time attendees. And of course, we have a week of wonderful weather ahead of us.

The Triton team are attending in full force with presentations on various topics throughout the week. Be sure to check these out:

  • DevOps and Agile are hot topics this year and  on Monday Afternoon, Julian Stuhler will be talking about “Cloudy with a Chance of DevOps – A Survival Guide”.
  • Damir Wilder will be sharing SQL tuning experiences on Monday Afternoon in “SQL Tuning Basics: Simple Steps to SQL Sufficiency”.
  • Tuesday Afternoon, Paul Stoker will be co-speaking on “Modernizing the Mainframe – Making DB2 z/OS Agile” with Paul Whitmarsh, Lloyds Banking Group.
  • Hybrid Transactional and Analytical Processing (HTAP) is a topic of primary focus within IBM Analytics, and Mark Gillis will share his experiences in “HTAP : Are We There Yet?” on Wednesday.
  • On Thursday, James Gill will be discussing encryption in DB2 for z/OS in  “Encrypt or Die! How to Secure DB2 for z/OS DDF Traffic using SECPORT and AT-TLS”.

Additionally, there will also be three expert panels on DB2 for z/OS, DB2 for LUW and application development which take place on Wednesday. Julian Stuhler from Triton will be answering your DB2 for z/OS questions from 13:40 and I will be join the LUW expert panel from 14:50. You can submit your z/OS and LUW questions to the panel in advance.

The detailed agenda can be found at: https://www.idug.org/p/cm/ld/fid=1385

Looking forward to seeing and connecting with you all this week!

 

Share
Posted in IDUG, IDUG EMEA 2018, Iqbal Goralwalla | Tagged , , | Comments Off on Malta, here we come!

Six Reasons to Review your Database Availability – Part 3 Reputational Damage

From working with many customers to help keep their critical databases up and running we have come up with the top 6 reasons for putting Database Availability at the top of your priority list. In this blog we look at Reputational Damage:

Regardless of the old adage “No PR is bad PR” everyone wants to avoid a situation that could put their organisation in a position where they face customer complaints and damaging press coverage.

In May this year Visa had a major incident with card payment services across Europe. This caused major issues for millions of customers who were unable to pay for goods and services until the issues were resolved. It also generated thousands of column inches and Twitter posts:

Although this issue turned out to be a hardware failure rather than database related we can see how an unexpected outage can cause major reputational damage to an organisation.

In another high profile outage HSBC customers experienced issues with their online banking services in 2017. Once again we saw customers taking to social media to vent their frustration which caused major embarrassment for the banking giant.

After an outage in 2016, in order to repair some of the reputational damage, HSBC vowed to waive charges for customers affected.

In May 2014 Adobe experienced a 27-hour outage in it’s “Creative Cloud” suite, used by many organisations and individuals in the creative industry. The failure occurred during database maintenance activity. This left users unable to work and resulted in a backlash of bad PR for the company.

The last thing any organisation’s PR department wants is to have to deal with a media storm with angry customers and endless questions from journalists. The fallout can be hugely damaging to an organisations reputation. Reputational damage is a serious issue which can cost time and money to repair.

Find out more in our white paper or take a look at our Database Availability consultancy services.

Share
Posted in Database Availability, DB2 Support | Tagged , , | Comments Off on Six Reasons to Review your Database Availability – Part 3 Reputational Damage

Out of Support Database – A DB2 Support Nightmare!

The set-up

 

You have a mission critical database that uses DB2 V9.7 or 10.1 (or even earlier! We do have customers still running V8). It’s robust, reliable and gives little cause for concern. Upgrading to a new version is going to take your application off-line and is, perhaps, a business risk that is going to be hard to get any sanction from senior management. Best to just let things alone.

There are a number of problems with this scenario:

  • Even if you have competent and experienced DBAs to hand, there will eventually be a problem that is actually with the code base itself, rather than the implementation of DB2. If you’re out-of-support, then IBM will not provide an answer
  • You will eventually be trapped in a situation where your application needs to be upgraded and / or your OS needs to be, or some other component of your system and this dictates that you must upgrade DB2. You are then under time pressure and you may have to “bunny-hop” from one version to another to achieve the desired and supported level of DB2
  • If you do have to upgrade you may find that there are features and functions in the version of DB2 that you use that are deprecated or, worse still, obsolete in the version that you are being forced to upgrade to. You then have to squeeze some application rewrite into the timeframe for a critical database upgrade

 

The Moral

Don’t let yourself be lulled into a false sense of security; your database may be running without a hitch at the moment but that doesn’t mean it always will (see http://db2geek.triton.co.uk/aint-broke-dont-fix/ for further whinging). Just because the family motor has driven the last 12,000 miles without you looking under the bonnet, doesn’t mean it will do so indefinitely. And if it’s out of warranty….

Furthermore, the latest versions of DB2 include more and more features and functions, and include many performance improvements straight out of the box. Why not take advantage of this?

Share
Posted in DB2, DB2 Support, Mark Gillis, Remote DBA | Tagged , , | Comments Off on Out of Support Database – A DB2 Support Nightmare!

Total Recall: Exploiting In-Memory Features in DB2 z/OS on the DB2Night Show

We are pleased to confirm that Julian Stuhler, Solutions Delivery Director and IBM Gold Consultant will be the guest presenter on the forthcoming DB2Night Show. Julian will be presenting on Total Recall: Exploiting In-Memory Features in DB2 12 for z/OS. 

Episode #z90 of this popular show runs on the Friday 19th October at 4-5:15pm BST.

Synopsis

IBM has steadily expanded the in-memory capabilities of DB2 in recent releases, to the extent that DB2 12 for z/OS is now officially recognised by Gartner as a bona fide “In Memory Database”. This presentation provides 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).

Register here.

Share
Posted in DB2 12, Julian Stuhler | Tagged , , | Comments Off on Total Recall: Exploiting In-Memory Features in DB2 z/OS on the DB2Night Show

IBM Webcast – Tell Your Story & Earn Your Star: Become an IBM Champion

It’s IBM Champion nomination season! Join Libby Ingrassia, IBM Sr. WW Program Manager  on Monday 8th October for the webcast Tell Your Story & Earn Your Star: Become an IBM Champion.

IBM Champions are a community of experts across IBM technologies and around the world who are recognised by IBM for their extraordinary expertise and contributions to the technical community

Libby will provide further details of the IBM Champion program, the benefits of being a champion as well as the values the program brings to IBM and the community.  Libby will also share the all-important information on how to nominate yourself or someone else.

Click here to register.

Share
Posted in IBM | Tagged | Comments Off on IBM Webcast – Tell Your Story & Earn Your Star: Become an IBM Champion

5 Misconceptions about Outsourcing Database Support

1 – You have to outsource all of your IT support

This can be a key concern for many organisations. They can see the benefits of outsourcing or using a 3rd party provider for support but worry about whether they will have to outsource everything. With specialist or niche support providers it is possible to simply outsource one specific area of IT to that specialist provider. When it comes to DB2 Support, Triton can take over the maintenance and support of all or part of your DB2 infrastructure, you have total control over the coverage and levels of support.

2 – It’s all about cost cutting

This is one of the biggest myths about outsourcing database support. Whilst it can certainly be more cost effective to have an external support provider, this isn’t the only reason for considering whether to outsource database support.

An external DB2 support provider can back-up your in-house IT team with expert DB2 knowledge. Knowing where to go and who to ask when extra support is needed can be a huge benefit and can enable in-house IT teams to be more efficient, resolve issues more quickly and concentrate on core IT work.

During extra busy periods such as software upgrades or seasonal workload peaks an outsourcing or support agreement means that the day to day maintenance of critical DB2 databases will still be carried out.

3 – Outsourcing is only for big business

It’s a really common misconception that outsourcing is only for large enterprise organisations who want to lift and shift whole IT departments to an outsourcing provider, usually offshore. However, this is no longer the case. Many smaller organisations are now realising the benefits of outsourcing parts of their IT support functions. Smaller organisations can quickly see the benefits of improved efficiency and flexibility which outsourcing can offer.

4 – Security will be compromised

Security is a hot topic in all organisations, whether large or small. All outsourcing or external support providers should have robust security procedures in place and this is something which should be checked thoroughly before entering into a contract.

Triton’s RemoteDBA service connects to your systems via secure VPN. We are flexible and implement any remote access protocols required by your organisation.

5 – Loss of control

It’s very common for organisations to feel that any sort of outsourcing means a loss of control. However, a good outsourcing or external support provider should be able to alleviate these concerns with clear processes and good communication. Before you start working with a new provider, plan in time to speak to the team and get to know your key contacts. Help them to understand how your team works and what your expectations of the service are. Take a look at our “How to get the most out of your RemoteDBA service” blog for more tips on working with a remote database support provider.

Share
Posted in DB2, DB2 Support, Remote DBA | Tagged , | Comments Off on 5 Misconceptions about Outsourcing Database Support

Ooops I found some DB2

It might sound somewhat unusual but sometimes organisations stumble across DB2 in their IT estate which they didn’t realise existed or that they hadn’t planned for. There can be a variety of reasons for this. When an organisation purchases a new application, it is often the case that it is shipped alongside the application vendor’s preferred database. This may be a database which is not widely used within the organisation. Most of the time, the application and the DB2 database will be installed and used with no issues. In this case, support for the underlying database isn’t considered an issue.

However, sometimes it can become a problem. Sometimes we hear from organisations who are in this very position and are having issues with a database which their IT team has little or no experience of. All of a sudden they’re in the position of effectively running an unsupported database. If this database is underpinning a mission critical application then this can cause serious issues.

Acquisition can be another cause of an unexpected occurrence of DB2. If an organisation acquires another business there may be a small DB2 installation which they weren’t expecting, perhaps under the covers of another application as in the example above. This again can cause problems when it comes to supporting the database.

For organisations that are running another database such as Oracle or SQL Server then it’s simply not cost effective to bring in a DB2 DBA to look after one instance of DB2. A Consultancy on Demand contract may be the answer. Simply purchasing 20 hours of DB2 consultancy means that if any issues arise you can call Triton who will be able to provide a consultant, either onsite or remotely to get things resolved. This is a far more cost efficient way of dealing with this type of issue. Triton’s team of DB2 experts will definitely be able to pinpoint what’s going on in the DB2 database under the covers of your application.

Find out more about Consultancy on Demand and our Flexible IT Resourcing services.

Share
Posted in CoD, DB2, DB2 Support | Tagged , | Comments Off on Ooops I found some DB2

Six Reasons to Review your Database Availability– Part 2 Lost Customers

From working with many customers to help keep their critical databases up and running we have come up with the top 6 reasons for putting Database Availability at the top of your priority list. In this blog we look at Lost Customers:

If an organisation is experiencing an outage, whether planned or unplanned, it is all too easy for customers to get frustrated and take their business to a competitor. This is particularly relevant in an online retail environment. One click can have a customer abandoning their shopping basket and looking for an alternative.

Customers expect services to be available 24/7 whether they are accessing a mobile banking app, shopping website or searching for an insurance quote. Even outages caused by planned, routine maintenance have the ability to leave customers open to using an alternative supplier if they cannot access the service they want, when they want it.

In the age of social media it is all too easy for disgruntled customers to head to Twitter or Facebook to let the world know about their negative experience with your brand. A few recent examples from Twitter below:

Database outage

Companies are spending an increasing amount of time and budget on handling outages and customer communications via Twitter and other social platforms to make sure they keep customers informed and onside during both planned and unplanned outages:

 

This ties in very closely to our third reason for prioritising Database Availability – reputational damage (more on that in a later blog).

A common stat about customer retention is that it is around 5-6 times cheaper to retain an existing customer than to generate a new customer. With that in mind it is vital for organisations to put a value on what a lost customer means to their business. Planning for outages, whether expected or unexpected is essential to minimise loss of customers.

Find out more in our white paper or take a look at our Database Availability consultancy services.

 

Share
Posted in Database Availability | Tagged , , | Comments Off on Six Reasons to Review your Database Availability– Part 2 Lost Customers

What’s coming up at IDUG EMEA 2018

The countdown is on! IDUG EMEA 2018 is just around the corner and it is set to be a great event. With so many fantastic speakers this year it’s going to be tough to plan your diary so we thought we would pull out a few highlights from the agenda which we think look particularly interesting:

DevOps and Agile are hot topics this year and you’ve got a few choices of presentations:

Monday Afternoon – Cloudy with a Chance of DevOps – A Survival Guide Julian Stuhler, Triton Consulting

Tuesday Afternoon – Agile DB2 Deployment with Docker, Kubernetes and REST Mark Murnane, IBM

Wednesday Morning – Docker and DB2: Recipes for Uncontained Success Ian Bjorhovde, DataProxy LLC

“I’m really excited about IDUG EMEA this year. The venue is fantastic and we have such a great line-up of speakers from users to IBM experts, long-time IDUG speakers and first-time attendees. I think this could be our best event yet!” Iqbal Goralwalla, IDUG Board of Directors Vice President / EMEA CPC Liaison & Emerging Technologies and Triton Head of Midrange Services

IBM expert talks are always popular so make sure you grab a seat early for these three fascinating talks:

Monday Morning – DB2: Latest from the Lab and look into the Future Keri Romanufa, IBM

Monday Afternoon – Developer Services for the Next Generation of DB2 z Developers Patrick Bossman, IBM

Tuesday Afternoon – Build a Slack or Facebook Messenger Interface to DB2 Henrik Loeser, IBM

User stories are a great way to hear experiences and learnings from industry peers:

Tuesday Afternoon – Modernizing the Mainframe – Making DB2 z/OS Agile Paul Whitmarsh, Lloyds Banking Group Co-Speaker: Paul Stoker (Triton)

There will also be three expert panels on DB2 for z/OS, DB2 for LUW and application development which take place on Wednesday. Triton Director Julian Stuhler will be answering your DB2 for z/OS questions from 13:40 and Iqbal Goralwalla will be join the LUW expert panel from 14:50. You can submit your z/OS and LUW questions to the panel in advance.

Join us in Malta on 4th – 8th November to experience the latest in DB2 technologies, networking opportunities and technical content.

Share
Posted in IDUG EMEA 2018 | Tagged | Comments Off on What’s coming up at IDUG EMEA 2018