Tag: Tablespace

2018-01 Db2 GETPAGES by Insert

  Troubleshooting on site : how a simple Db2 SQL INSERT statement causes a high GETPAGES rate and how to fix it. One shop I visit had an interesting problem the other day.  I thought I would share it with

Tagged with: , ,

2017-02 Why SIZE still matters in Db2 12

What has changed for space management in Db2 12? How to avoid SIZE limits in Db2 12 like in previous Db2 Releases? How to monitor the maximum possible SIZE of table and index spaces and table and index partitions? SIZE in Db2

Tagged with: , , , , ,

Rotten Results from RUNSTATS Require Rescue

Do you know the basic rules to ensure access path stability when using RUNSTATS? Time for another of my “I noticed something strange at a customer site recently” newsletters. Enjoy!   RUNSTATS are good aren’t they? At this particular site, the RUNSTATS

Tagged with: , , , , , , ,