Tag: Index

2019-12 Fun with Db2 12 PBR RPN

Avoid runing out of extent during partition in production with the recently enhanced SAX – Space AssuranceExpert thanks to the new PBR – RPN for Db2 12

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

1,2,3 Give and Take 2020 Information on the Give and Take 4,5,6,7 Previous Give & Take We have “GIVEn” various free-of-charge Use Cases from our SQL WorkloadExpert for Db2 z/OS like: 1 Index Maintenance Costs 2 EXPLAIN Suppression 3 BIF

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

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