Triton Db2 Geek

Confessions of a DB2 geek

IBM Gold Consultant Program and IBM Premier business Partner

Category Archives: Damir Wilder

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

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