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.

GIVE and TAKE Programs 4, 5, 6, 7

Limited free of charge Db2 Applications for 90 days to US & European sites:
– Db2 11,12 Audit+SIEM,
– Access Path Recovery,
– Space Assurance,
– ZOWE+SQLWorkload Performance

Getagged mit: , , , , ,

2020-04 Four Flavors of Db2 Audit

Four different ways to “Get a Db2 z/OS Audit Done”.

Which one ist the best way, so that you can process the gathered data?

Getagged mit: ,

2020-03 Db2 REORG SYSCOPY: DRAIN Delays are Despicable

REORG and missing SYSCOPY: delays on a Db2 site caused from a DRAIN SQL and a badly timed RUNSTATS. How to identify the bad SQLs thanks to z/OS tools.

Getagged mit: , ,

2020-02 Db2 UPDATE column: UPDATEs for nothing and CPU ain’t free!

Db2 UPDATE column: what happens “under the covers” when the column value you are updating is exactly the same as the new value?

Getagged mit: , , ,

2020-01 How RUNSTATS causes an error SQLCODE

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

Getagged mit: , ,

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

Getagged mit: , , , ,

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: ,