Author: vpinot

2020-01 How RUNSTATS causes an error SQLCODE

How can a RUNSTATS *cause* an SQL error code? Well, my gentle readers, read the explanation and find two examples in SPUFI

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-11 Db2 Existence checks examples: SELECT for DUMMIES

Find your Db2 backend on any hardware platform with this Db2 Existence checks SQL query examples: SELECT COUNT() FROM SYSIBM.SYSDUMMY1

Tagged with: ,

2019-10 DECFLOAT examples: Fun with Numbers

Find Db2 Decfloat examples (SNAN, NAN, INF), invalid DECFLOAT and some solutions as CAST or capturing the SQL workload / capturing SQLCODES.

Tagged with:

2019-09 A DBA has got to know his limitations

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

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 saving since Db2 12

Tagged with: ,

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

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.

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.