Machine learning for db2 review, now that the Db2 Optimizer has gone all Artificial Intelligent (AI).
- Start
- Produkte
- Db2 z/OS Produkte
- Db2 z/OS Pocket tools
- Produkte für Verteilte Anwendungen
- Support
- Consulting
- Events
- Corporate
- Partner
- Karriere
Sie erreichen uns telefonisch unter der Nummer +49 211 96149-0
Kategorie: Db2 Continuous Delivery
db2-continuous-delivery; CD; Since DB2 12; IBM version 12
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
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.
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.
2018-08 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…
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…
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…
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…
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…
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…
