Triton Db2 Geek

Confessions of a DB2 geek

IBM Gold Consultant Program and IBM Premier business Partner

Tag Archives: DB2 11.1

Client Experiences: How DB2 Migration Affects Decimal Type Conversion

Published February 12th, 2019 - by

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 target databases were to be placed on POWER Linux servers (little endian), so it was Continue Reading

In-Line Optimization with V11.1

Published April 7th, 2017 - by

Sometimes you might find that the Optimizer has chosen an access path with which you don’t concur. It’s not that likely, as the DB2 Optimizer is one of the most sophisticated of its ilk, but it’s possible that you may know something that the optimizer doesn’t: if, for instance, a table has just had some Continue Reading

2017: A year for DB2 11.1

Published February 22nd, 2017 - by

If your databases are on DB2 9.7 or DB2 10.1, then September 30, 2017 is a date that should be at the forefront of your mind. Both DB2 9.7 and DB2 10.1 go out of support on this date. As you start thinking about your upgrade plans to either DB2 10.5 or better still DB2 Continue Reading