Tagged: db2

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?...

statement performance 0

JDBC Statement Cache

Introduction Java Database Connectivity (JDBC) is an application programming interface (API) that Java applications use to access local or remote relational databases. The JDBC API consists of a set of interfaces and classes written...

2

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...