Kategorie: News from the Labs

Each month, SEG sends out valuable technical DB2 z/OS information based on knowledge gained by the experienced developers and technicians in our product labs. We would like to share this newsletter with other DB2 users, like yourself.

2019-11 Db2 Existence checks: SELECT for DUMMIES

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

Getagged mit: ,

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.

Getagged mit:

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

Getagged mit: , ,

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

Getagged mit: ,

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.

Getagged mit:

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).

Getagged mit: ,

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

Getagged mit: , , , ,

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.

Getagged mit: ,

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.

Getagged mit: , ,

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

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“.

Getagged mit: