Schlagwort: REORG

DB2 z/OS REORG

2017-11 Db2 APAR list: An APAR a day keeps the bugs at bay

Posted on 19. Dezember 2017 by

vpinot Veröffentlicht in Db2 12, Db2 Continuous Delivery, News from the Labs

Db2 12 APAR – time saving list With all the talk about “agile” going on, and referring to one of my older 2017-09 newsletters* on APARs, I think it is time to tell you all about another little service that…

Getagged mit: APAR, Continuous Delivery, COPY, Db2 12, REORG, RTS, RUNSTATS, SQL access path

2017-02 Why SIZE still matters in Db2 12

Posted on 17. Februar 2017 by

vpinot Veröffentlicht in Db2 12, Db2 Space issue, News from the Labs

What has changed for space management in Db2 12? How to avoid SIZE limits in Db2 12 like in previous Db2 Releases? How to monitor the maximum possible SIZE of table and index spaces and table and index partitions? SIZE in…

Getagged mit: Db2 12, IFCID, Maximum SIZE, Partition, PBG, REORG, Tablespace

2017-01 Db2 12 technical overview: Roy’s first features review

Posted on 17. Januar 2017 by

vpinot Veröffentlicht in Db2 12, News from the Labs

This Db2 12 technical overview presents in an „easy to read“ table list a review of new Db2 12 features Have you encountered any other Db2 12 changes you’d like to discuss? Now that Db2 12 has gone GA…

Getagged mit: Arrays, Audit, data sharing, Db2 12, Db2 migration, Db2 Optimizer, REORG, RUNSTATS, SQL workload, Utilities

Rotten Results from RUNSTATS Require Rescue

Posted on 8. November 2016 by

vpinot Veröffentlicht in News from the Labs

Do you know the basic rules to ensure access path stability when using RUNSTATS? DB2 z/OS Access path stability: Time for another of my “I noticed something strange at a customer site recently” Newsletters. Enjoy! RUNSTATS are good aren’t they? At…

Getagged mit: Access path, dynamic SQL, Index, PLAN STABILITY, REORG, RUNSTATS, Static SQL, Tablespace

2016-03 DB2 z/OS Real Time Statistics (RTS) Revisited – Information missing (part 2)

Posted on 23. März 2016 by

vpinot Veröffentlicht in News from the Labs

DB2 z/OS Real Time Statistics (RTS) – NULL initialization made easy A second RTS query to set this time *all* of your RTS KPIs and counters to enable good DB2 Database Maintenance before a REORG, RUNSTAT or a DB2 Migration for DB2…

Getagged mit: Db2 migration, KPIs, NULL Initialization, REORG, ROWS UPDATE, ROWSUPDATE, RUNSTATS, TOTAL ENTRIES, TOTAL ROWS

2016-02 Real Time Statistics (RTS) Revisited – Information missing (part 1)

Posted on 15. Januar 2016 by

vpinot Veröffentlicht in News from the Labs

Easy Real Time Statistics (RTS) data initialization from DB2 9 to DB2 11: Special query to run before a REORG, RUNSTAT or a DB2 Migration. How many RTS rows did you find? Hands up who knows nothing about the…

Getagged mit: Db2 10, Db2 11, Db2 Database Maintenance, Db2 migration, Information missing for table space, Initialize, Null, Real Time Statistics, REORG, RTS

Schlagwort: REORG

Veranstaltungen

IDUG Db2 Tech Conference 2020 in Edinburgh

Neueste Webinar Aufzeichnungen:

"News from the Labs!"

mehr