DBizners presentation at IDUG DB2 Tech Conference in Malta 2018

20 November 2018

Db2 12 RTS Autonomics : a Gold Mine of Information

The first part of this presentation will provide a conceptual and theoretical introduction to temporal data management in DB2. We will then describe how to activate this option and evaluate the volume of data it can generate. Finally, we will go through the most valuable information available in the temporal RTS.

The second part will be applied and provide DBAs with examples of the value derived from these data. To do so, we will present skeleton SQL queries on RTS based on event date or counter value. Finally, we will share some use cases showing the meaningful information that can be extracted from temporal RTS.

The full presentation is available here : PDF iconEU18A14.pdf

All comments and remarks are welcome.