Tag: Index

2019-09 A DBA has got to know his limitations

Know the most important Space limitations in Db2 and how to check them to avoid being out of extent thanks to a real-time space monitor small tool

Tagged with: , ,

2019-08 FTB (Fast Traversal Block): Just another TLA?

Learn how FTB (Fast Traversal Block) supports Db2 Fast Index Traversal (FIT) to allow Index performance optimization and CPU saving since Db2 12

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: , , , , , , ,

GIVE and TAKE Program

Index Maintenance Costs, EXPLAIN Suppression, BIF Limited free-of-Charge Db2 Application This Program started in Europe, during our 30th anniversary was such a success, that it is now being Extended for the benefit of North American Db2 z/OS sites. SQL WorkloadExpert™ for

Tagged with: , , , , , , , , , , , , , ,

2015-09 A real CLUSTER Buster

Are you using the “default” clustering INDEX or are you defining the correct INDEX with the CLUSTER Attribute? This newsletter is dedicated to all DDL designers who do their best but then omit that last tiny bit. No-one really notices,

Tagged with: , , ,

2015-05 Top 10 Things to Ignore for DB2 z/OS

  This newsletter was inspired by a recent article I read in the “Enterprise Systems Magazine” called “Top 10 Ways to Waste Money on CPU”. Why not the Top 10 things to ignore?   DB2 z/OS things you could ignore

Tagged with: , , , , , , , , ,