Category: Db2 12

Db2 12 New Features in this DB2 z/OS Newsletter issues

2020-04 Four Flavors of Db2 Audit

Four different ways to “Get a Db2 z/OS Audit Done”.

Which one ist the best way, so that you can process the gathered data?

Tagged with: ,

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

Machine Learning for Db2 z/OS: Artificial Intelligence – Hype or Reality?

Machine learning for db2 review, now that the Db2 Optimizer has gone all Artificial Intelligent (AI).

Tagged with: ,

2019-04 ZOWE for Continuous Delivery – It’s worse than that – he’s tested Jim!

With this Db2 12 testing checklist, be ready to navigate into the Db2 Continuous Delivery world, well supported by Zowe, the modern IBM z/OS GUI

Tagged with: , ,

2019-03 EXPLAIN data review

Db2 EXPLAIN example: a quick history of EXPLAIN and a new standard Db2 EXPLAIN Query to bring out the best and most underused columns.

Tagged with: ,

2019-02 Global Temporary Confusion

Learn, through examples, why CGTT (CREATEd Global Temporary Tables) are possibly better than DGTT (DECLAREd Global Temporary Tables) and how to use them to speed up performance.

Tagged with: , ,

SOUNDEX and other “cool” features – Part six All new for Db2 12

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

Tagged with: , , ,

2018-07 – SOUNDEX and other “cool” features – Part five All new for Db2 12

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

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