What do Db2 numeric Primary Keys have to do with space management ?
SMALLINT – INTEGER – DECIMAL – BIGINT…
How to find out which sequences are nearing their physical limit ?
In the Db2 world during a BIND/REBIND, while using the command EXPLAIN(ONLY), you may experience a LOCK problems in production: get rid of Db2 lock-timeout – Db2 bind lock with the exposed SQL queries.
With these sample queries, find out how to review your Db2 messages from a high level overview down to the details.
You can review the Db2 Console output from different perspectives and simply bypass the boring „J“ ones for Full Log and Log Offload to leave behind the interesting ones.
Now you have two possibilities to get the Console Messages from Db2, just write your own IFI program or buy our newly updated software (!)
Part six of my – everlasting – walk through of new Aggregate and Scalar functions. Following with : HASH & WRAP Previous “SOUNDEX” Newsletters Part 5: 2018-07: SOUNDEX and other „cool“ features – Part five All new for Db2 12 Part…
Part five of my – everlasting – walk through of new Aggregate and Scalar functions. This time I will start with the new AGGREGATE functions introduced in Db2 12. LISTAGG This is mainly of interest due to the fact that…
How to avoid timestamp problems while going from winter to summer time in a Db2 for z/OS system? Is the CHAR or Timestamp use, the safest timestamp procedure? How do you fix it? This year, as every year, the moment arrives for…
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…
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…
„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…
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…
