Practical guide for DB2 snapshots using SQL

Once there were just snapshot command and a difficult API interface. But then IBM decided to wrap snapshots (and more!) into table functions. To make life easier these table function have been rolled into views. Nowadays you can retrieve every piece of information regarding performance, utilities, messages, space, environment etc. etc. from the many administrative views by IBM. Klaas will show how to obtain the best information from them and how to you can, with some simple procedures, create a history of performance and data growth.