Tag: ZPARM

2017-10 Db2 log size: How big is your LOG?

  How to validate that your Db2 LOGs are OK ? Sizing of LOGs changed quite a bit in Db2 11 and Db2 12, so I thought a little recap about the correct sizing and ZPARMS was in order this

Tagged with: , , , , ,

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

2015-11 z/OS Quick Security Audit – part 2

Which security values and security settings should never be left as default? Let’s list your ROLES and Authorization IDs with some SQL queries and check the security ZPARMs   To complete this two part series, I want to do a deep dive

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

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