Tech Blog

The latest technical blogs from the Triton team.

2019
Client Experiences: How DB2 Migration Affects Decimal Type Conversion

Recently, I assisted a client migrating their DB2 databases from v9.7 to v11.1. I intentionally say “migrating” and not “upgrading”, even though three major releases were jumped, because the existing databases were located on Z-Linux servers (big endian) and the

2017
Time is running out! Plan your move

For organisations currently running DB2 LUW versions 9.7 or 10.1 time is running out. IBM will cease to support customers running either version from 30th September 2017, just 3 months away. For those organisations that haven’t begun their migration planning,

2016
Restore Transport option – mix and match your schemas (Part 1)

I recently had a request from a client to help them build a database with a set of objects from two physical databases and provide a third ‘merged’ database. They’d already established that using 2 successive RESTORE commands with the

2015
Pivoting and Unpivoting data with pureXML part 2

The previous blog (http://db2geek.triton.co.uk/pivoting-unpivoting-data-purexml ) was looking at how to ‘unpivot’ data: take a string of values stored in a single VARCHAR column and present them as a set of single values. This one is examining the flip-side of the problem:

2015
IDUG EMEA 2015 Day 2

I always enjoy a chat with the locals when we have an IDUG event so I spent the 30 minute taxi journey from the airport to the hotel in conversation with my driver. I think I actually understood about 3

Have a Question?

Get in touch with our expert team and see how we can help with your IT project, call us on +44(0) 870 2411 550 or use our contact form…