Author: vpinot

2018-05 Audit 2.0 – GDPR Audit guide and checklist for Db2 z/OS

Or: How I Learned to Stop Worrying and Love the Auditor A guideline in 5 big Steps to Audit for Personal Data Protection First up, this is not another Audit review and health check sell! We, and I mean especially

Tagged with: , ,

2018-04 Negative DBIDs: Something new something old

Or: „Even Roy learns things from Listserv!“ While discussing negative DBIDs on Listserv the other day, another poster commented on my SQL Code snippet and said that it could well be better changing from LOCATE and HEX to using the

Tagged with: ,

2018-03 RTS RUNSTATS

 „Breaking the rules is often fun, although we cannot condone it. But breaking the rules of Real Time Statistics (RTS) in Db2 12 can really land you in hot water. We provide two queries that may give you a Get

Tagged with: , , , ,

2018-02 Db2 Catalog Statistics revisited

Db2 Optimizer & access path selection for Db2 11 & Db2 12 : Db2 Catalog data | Problematic default values | Correlations in the Db2 Catalog  It has been six years since the last update so I thought, after Terry Purcell’s excellent

Tagged with: , , ,

2018-01 Db2 GETPAGES by Insert

  Troubleshooting on site : how a simple Db2 SQL INSERT statement causes a high GETPAGES rate and how to fix it. One shop I visit had an interesting problem the other day.  I thought I would share it with

Tagged with: , ,

2017-11 Db2 APAR list: An APAR a day keeps the bugs at bay

Db2 12 APAR – time saving list With all the talk about “agile” going on, and referring to one of my older 2017-09 newsletters* on APARS, I think it is time to tell you all about another little service that

Tagged with: , , , , , , ,

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-09 Db2 12 SQL Access path: Death by APAR

We recently held one of our Design Councils, this one was all about Db2 12 and going Agile. I was asked the following question after one of my presentations about verifying Db2 Code/Catalog/Function Levels: “How many APARs really can affect

Tagged with: , , , , , ,

2017-08 Anomalies detected in MERGECOPY and MODIFY Recovery

Db2 z/OS Utilities: Identify and avoid some MERGECOPY or MODIFY Recovery anomalies Just a little note this month about a strange anomaly in the way MERGECOPY and MODIFY RECOVERY seem to work. Let’s begin with MERGECOPY. 1 – MERGECOPY to

Tagged with: , ,

2017-07 Let’s make DB2 z/OS IMAGE COPY great again!

War story : Why is Db2 z/OS IMAGE COPY very useful in the current Db2 z/OS world? Please excuse the heading, I simply could not resist… This month is another war story from the trenches of Production DBAs fighting the

Tagged with: , ,