Category: DB2

Focusing on IBM DB2 platform for Linux, UNIX and Windows (IBM DB2 LUW)

self-control 1

Automatic Table Maintenance Self-controlled

Using DB2 automatic table maintenance and want to get more control or simply control it yourselves? Still manually checking if a table or index is in need of reorganization and getting tired of it?...


Runstats on data change percentage

As always I like to be in control of stuff, just to know what is happening and thereby preventing unexpected behavior. Same goes for maintenance tasks. Collecting statistics on your tables for example. I...

safety first 0

Safety first with BLOCKNONLOGGED

Upgrades of software often comes with upgrading the database. But what if your only allowed downtime during a certain time span? Can you complete all your upgrades within this time? When you have to...