Triton Db2 Geek

Confessions of a DB2 geek

IBM Gold Consultant Program and IBM Premier business Partner

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

Jenkins and z/OS

Published April 2nd, 2019 - by

Introduction DevOps has been a driving force in accelerated development delivery and improved quality outcomes for a few years now. Our mid-range colleagues have been championing this approach for a while, and there’s lots of good reasons why the mainframe teams should be picking this up and running with it as well: Code quality verification 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

Using ansible to Setup Port Forwarding

Published February 22nd, 2019 - by

Introduction In its simplest form, ansible is a Python derived automation scripting tool, commonly used to install, configure and manage servers and services. It has a huge collection of modules available out of the box to support management of a wide variety of tasks. In this blog, we’re going to talk about using ansible to 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

Next Page »

Tag Archives