How to use the space prediction feature in Toad for DB2

Hi, this is Jeff Podlasek with Toad DB2 development. Today I'm going to demonstrate some new features that we added to Toad for DB2 Version 6, in particular, the space prediction features for DB2 LUW, and DB2 for z/OS. I've got Toad up and running, and I've got several Database Explorers open. This first one here is connected to a DB2 LUW database, and these next two are connected to a DB2 z/OS subsystem. In this first tab for DB2 LUW, I'm going to select multiple tables, right click, and select Space Management, View Space History. And as you see, a new Space History tab opens up. We've redesigned this tab to have a Date Selection Controller on the top half. So if you want to limit the amount of data that you're viewing, you could use this Date Controller to do so. And now the bottom half displays the data of the objects that you've selected when you entered this tab. You could use the control button to select multiple objects, and/or the shift button as well. And when you select these multiple objects on the lower left hand side, you'll see the historical information is graphed on the lower right hand side. And when you select a single object with version 6.0 of Toad, you'll be able to select the Prediction check box. And what this does is allows you to predict out to a future date, or to a future size limit. If I choose date here, I could bring up a calendar and then scroll through and select a future date where I want Toad to predict the size of this table on that certain date. So you can see that the original history records end, and then the prediction graph or line is highlighted there. Another thing that we did to this control is we changed what objects you would want visible. So by default it brings up tables and indexes, because that's what you've entered this document with. But if you wanted to change the view to select Tablespace, you could do so. So now the Tablespace is total space, and free space is graphed. And you could predict that as well. We could display a regression line or not. And if you check Prediction, just like with Tables, you could select a custom date. The date will be a date to the future. So you could say I want to predict the Tablespace size up until that date, and you can see that the total space is increasing in the future, or the free space is decreasing in the future. Again, that's based off of historical records and then calculations that we make. Now, for DB2 z/OS we've added the same prediction features. So if you have a table, or an index, or a Tablespace selected, and you select the Space Usage tab on the right hand side, the Table Growth tab will display historical information as it has in past releases, however, here again, you'll see a prediction tab. So if you wish to predict the growth of a particular object out to the future, you could select a date and a future date. And you'll see that the graph gets updated to reflect the prediction of the amount of space that that object is going to consume on that future day. And the same holds true for DB2 z/OS Tablespaces. If you select a Tablespace , on the right hand side there's a Space Usage tab, you select Tablespace Growth, and you'll be able to see the historical growth of that Tablespace, as well as be able to predict out the growth of that Tablespace to a future date. Very handy tool for DBAs to see and analyze what their space requirements will be for the future.