vpinot - segus.com

Home › View all posts by vpinot

Author: vpinot

2020-04 Four Flavors of Db2 Audit

Posted on March 12, 2020 by

vpinot Posted in Db2 audit, Db2 z/OS Freeware, News from the labs

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?

Tagged with: Db2 audit, IFCIDS

2020-03 Db2 REORG SYSCOPY: DRAIN Delays are Despicable

Posted on February 12, 2020 by

vpinot Posted in News from the labs

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.

Tagged with: REORG, SYSCOPY, Tablespace

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

Posted on February 10, 2020 by

vpinot Posted in News from the labs

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

Tagged with: REORG, ROWS UPDATE, RTS, Tablespace

2020-01 How RUNSTATS causes an error SQLCODE

Posted on January 27, 2020 by

vpinot Posted in News from the labs

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

Tagged with: RUNSTATS, SQL performance, SQLCODES

2019-12 Fun with Db2 12 PBR RPN

Posted on November 28, 2019 by

vpinot Posted in Db2 12, Db2 space issue, News from the labs

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: Allter, Index, Partition, Space monitoring, Tablespace

2019-11 Db2 Existence checks examples: SELECT for DUMMIES

Posted on November 18, 2019 by

vpinot Posted in News from the labs

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

Tagged with: Existence check, select

2019-10 DECFLOAT examples: Fun with Numbers

Posted on October 28, 2019 by

vpinot Posted in News from the labs

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

Tagged with: SQLCODES

2019-09 A DBA has got to know his limitations

Posted on August 22, 2019 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

Tagged with: Index, Maximum SIZE, Space monitoring

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

Posted on August 20, 2019 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

Tagged with: Fast Index Traversal, Index

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

Posted on July 18, 2019 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.

Tagged with: SQLCODES

‹ Older posts