Triton Db2 Geek

Confessions of a DB2 geek

IBM Gold Consultant Program and IBM Premier business Partner

Category Archives: DB2 LUW

Table Partitioning: The Good, the Bad and the Ugly

Published April 10th, 2019 - by

Table (or Range) Partitioning has been around since V9.7. It’s a canny option and a useful tool from both a performance and a data archiving point of view, but we do occasionally see it mis-managed and then it can be more of a nuisance than a benefit. Overview Partitioned tables are organized into multiple storage Continue Reading

Dependent Tables in DB2

Published March 26th, 2019 - by

Have you ever had a need to quickly find out if a DB2 table has any dependencies, i.e. foreign key relationships to it and from it? The following SQL query will show all parent tables (tables that the table references with its foreign keys) as well as all child tables (tables that reference the table Continue Reading

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

Top 5 DB2 Support Nightmares 2018 No. 2

Published September 12th, 2018 - by

In part 2 of our new series of DB2 Support Nightmares we look at the implications of a “Suck it and See” development approach. This could be strongly related to the Support Nightmare #1, but not necessarily always. Sign-up to receive DB2 Support Nightmare updates or download our previous series ‘Top 10 DB2 Support Nightmares and How Continue Reading

Recovering from corrupt DB2 Storage Group Control Files

Published August 17th, 2018 - by

Recently, we received a distress call from a client who was unable to access their production database and the data within. Client’s main aim was to recover the data from the database by any possible means. The (short) description of the situation was: -there are two DB2 instances on the server, one TEST and one Continue Reading

Next Page »