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

Getagged mit: , ,

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

Getagged mit: ,

Rotten Results from RUNSTATS Require Rescue

Do you know the basic rules to ensure access path stability when using RUNSTATS? DB2 z/OS Access path stability: Time for another of my “I noticed something strange at a customer site recently” Newsletters. Enjoy!   RUNSTATS are good aren’t they? At

Getagged mit: , , , , , , ,

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

Getagged mit: , , ,

GIVE and TAKE Programme

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

Getagged mit: , , , , , , , , , , , , , , ,

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

Getagged mit: , , , , , , , , ,