Autor: vpinot

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