Search

1 to 6 of 6
Sort by

Library Entry
SQL: Recent Util History for Tablespaces, including lack of backup

Catalog query identifying several data events for tablespaces, within the past n (31, in the example) days. Results are verbose.


Blog Entry
How to innovate your DB2 for z/OS utility environment

Self-managing DB2 databases The concept of automating routine database tasks is not new. It has been theorized, discussed and written about for several decades. But, true self-managing or autonomic capabilities have been slow to be developed and adopted and put into practice use. There...


Blog Entry
DB2 11 Utility Enhancements

Introduction Each new release of DB2 brings changes to the utilities suite, and new release DB2 11 is no exception. The importance of these changes can have a big impact on the work of a DBA. The changes and new options should be well understood and choices have to be made for your...

Kurt Struyf's profile image

Library Entry
[F10] Prepare to Repair

At least once during your career as a DBA, you will bei exposed to a situation where your well prepared recovery jobs fail. Better to have a “plan B” ready to execute rather than falling back to reading the manuals and the diagnosis guide. This presentation explains the usage of the Repair...

EU13F10.pdf


Library Entry
IBM DB2 RUNSTATS Utility and Real-Time Statistics

This presentation reviews the basics of the RUNSTATS utility (What it does; Why you need to run it; How DB2 uses the information), and explores new statistics collected on data and indexes, including: partition level information on Data Partitioned Secondary Indexes; non-uniform distributon...

EU07B05.flv


Library Entry
IBM DB2 RUNSTATS Utility and Real-Time Statistics

This presentation reviews the basics of the RUNSTATS utility (What it does; Why you need to run it; How DB2 uses the information), and explores new statistics collected on data and indexes, including: partition level information on Data Partitioned Secondary Indexes; non-uniform distributon...

EU07B05.flv