Home › News from the Labs › Archiv von Db2 Continuous Delivery
Kategorie: Db2 Continuous Delivery

db2-continuous-delivery; CD; Since DB2 12; IBM version 12

2019-08 FTB (Fast Traversal Block): Just another TLA?

Posted on by vpinot Veröffentlicht in Db2 12, News from the Labs

Learn how FTB (Fast Traversal Block) supports Db2 Fast Index Traversal (FIT) to allow Index performance optimization and CPU saving since Db2 12

Weiterlesen ›

Getagged mit: ,

2019-06 A little quote from Terry Purcell: It just takes one

Posted on by vpinot Veröffentlicht in Db2 Continuous Delivery, News from the Labs

One single SQL statement can bring your entire system to its knees: this quote from Terry Purcell is illustrated with a real case at one customer site.

Weiterlesen ›

Getagged mit:

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

Posted on by vpinot Veröffentlicht in Db2 12, Db2 Space issue, News from the Labs

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

Weiterlesen ›

Getagged mit: ,

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

Posted on by vpinot Veröffentlicht in Db2 12, Db2 Continuous Delivery, IBM Zowe, News from the Labs

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

Weiterlesen ›

Getagged mit: , , , ,

2019-03 EXPLAIN data review

Posted on by vpinot Veröffentlicht in Db2 12, News from the Labs

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

Weiterlesen ›

Getagged mit: ,

2019-02 Global Temporary Confusion

Posted on by vpinot Veröffentlicht in Db2 12, News from the Labs

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.

Weiterlesen ›

Getagged mit: , ,

2018-08 SOUNDEX and other „cool“ features – Part six All new for Db2 12

Posted on by vpinot Veröffentlicht in Db2 12, Db2 Continuous Delivery, News from the Labs

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…

Weiterlesen ›

Getagged mit: , , ,

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

Posted on by vpinot Veröffentlicht in Db2 12, Db2 Continuous Delivery, News from the Labs

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…

Weiterlesen ›

Getagged mit: , ,

2018-03 RTS RUNSTATS

Posted on by vpinot Veröffentlicht in Db2 12, Db2 Continuous Delivery, News from the Labs

„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…

Weiterlesen ›

Getagged mit: , , , ,

2018-02 Db2 Catalog Statistics revisited

Posted on by vpinot Veröffentlicht in Db2 12, Db2 z/OS freeware, News from the Labs

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…

Weiterlesen ›

Getagged mit: , , ,