Home › View all posts by vpinot
Author: vpinot

2019-09 A DBA has got to know his limitations

Posted on by vpinot Posted in Db2 space issue, News from the labs

Know the most important Space limitations in Db2 and how to check them to avoid being out of extent thanks to a real-time space monitor small tool

Read more ›

Tagged with: , ,

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

Posted on by vpinot Posted 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

Read more ›

Tagged with: ,

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

Posted on by vpinot Posted in Db2 12, 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.

Read more ›

Tagged with:

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

Posted on by vpinot Posted 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).

Read more ›

Tagged with: ,

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

Posted on by vpinot Posted 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

Read more ›

Tagged with: , ,

2019-03 EXPLAIN data review

Posted on by vpinot Posted in Db2 12, Db2 Continuous Delivery, 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.

Read more ›

2019-02 Global Temporary Confusion

Posted on by vpinot Posted 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.

Read more ›

2019-01: Regular Expressions in Db2 SQL – Regulate this!

Posted on by vpinot Posted in News from the labs

Impress your JAVA colleagues with Regular Expressions in Db2 SQL – Become a regex specialist with these samples (regex usage in the TSO Editor & regex as a predicate).
The references to blogs focusing on this topic (advanced pattern matching, regex testing and REGEXP_LIKE usage) will help round out your knowledge all about “Regular Expressions in Db2 SQL”.

Read more ›

Tagged with:

2018-12: Db2 Checklist – SQLCODEs as never seen before

Posted on by vpinot Posted in News from the labs

With this SQLCODE list, from the “bad guys” through to the “odd guys” – e.g. the SQLCODE 100 – and then onto the “not so bad guys”, you can see a practical list of current SQLCODEs in production from around the globe, including their meaning. This review also analyzes the behaviour of some SQLCODEs and proposes some solutions to get your Db2 z/OS programs correctly processing these SQLCODEs.

Read more ›

Tagged with:

2018-11 db2 Numeric Primary Keys: Space, the final frontier?

Posted on by vpinot Posted in Db2 space issue, News from the labs

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 ?

Read more ›

Tagged with: