Tag: static SQL

2017-04 DB2 ZPARM : Small ZPARM – Big effect!

Do you know how important it is to check the ZPARM EDM SKELETON POOL size to improve your I/O rate and lower your CPU? Do you know how to set it? From the frontline I was checking and verifying our WorkLoadExpert (WLX)

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

BIF HealthCheck Licensed Freeware for DB2 11

Detect static and dynamic SQL and match to the relevant collection, packages,… BIF HealthCheck overview (Built-in Function Checker for DB2 z/OS) BIF HealthCheck reports the following BIF incompatibilities in DB2 11 Execution of the DB2 9 for z/OS version of

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

BIF HealthCheck licensed Freeware for DB2 10

Detect static and dynamic SQL and match to the relevant collection, packages,… BIF HealthCheck overvew (Built-in Function Checker for DB2 z/OS) BIF HealthCheck reports the following BIF incompatibilities in DB2 10 Execution of the DB2 9 for z/OS version of

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

GIVE and TAKE Program

1,2,3 Give and Take 2020 Information on the Give and Take Programs 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

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