Articles & Content

Archives

C21 - Your Idug takeaway: Collect and Report DB size history cleverly and easily

Topic: DB2 for LUW

Subtopic: 2015



The presentation shows a useful, practical and simple method for gathering and reporting DB2 database size history information. It consists of a few simple sql-scripts, which are easy to take away and start using in your own environment. The method is widely used in Finland. The method applies to both database and table size history collecting and reporting. Gathering the size information is easy enough. The clever part is reporting: How to provide a weekly/monthly/quarterly/yearly report with the basically the same report sql and all this regardless of how often you gather the size information.



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.