Catalog query identifying several data events for tablespaces, within the past n (31, in the example) days. Results are verbose.
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...
2 Comments - no search term matches found in comments.
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...
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
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