Overview of key DBA features in Toad for DB2 zOS Part VIII

DBAs for DB2 and z/OS have to be aware of the amount of space their database objects will require so they can plan to have enough resources available for future growth. And Toad for DB2 and z/OS has several features that will assist in this area. Now, I've got Toad for DB2 up and running, and I've got a list of tables here. And on the right-hand side, you'll notice that we have a space usage tab. And this tab can show the current space usage for a table in its tablespace along with information such as the volumes that the tablespace data sets reside on, and if there's any indexes on that table, information about those indexes as well. And you can see when you click on the volume, there's information about how many pages are used on that volume and how many pages are free on that volume. Now, also on the top hand side, there is a Table Growth tab. Now, when you click that, we will graph and show the historical growth of a table over time. And a feature in Toad-- you could actually use this prediction feature, which will allow you to predict out into the future given a future date, for example, of what your space usage would be for that object at a future date. So Toad will actually show you the actual history and then predict out to a future day the amount of growth for that object. So you could use this to predict out how far a table will grow in the future, and then adjust your tablespace allocation accordingly. And the same is true with tablespaces. If you have a list of tablespaces, we have a couple different things that could be displayed here. One is we have a data sets tab. And this tab will show the actual physical underlying data sets that support the tablespace. In this case, this is actually a partitioned tablespace. So you can see that we have four data sets since there's four partitions. And each data set, when you click on it on the top to bottom, volumes will actually update to reflect the volumes that that data set is allocated on. So it gives some high level information about allocated RBA and used RBA. We also have a Space Usage tab for a tablespace. And it will show you the current usage of that tablespace as well-- if there are partitions, it will show you the partition information on the bottom. And as you click on these partitions, if you multi-select them using the Control button as well-- you can see that we graph out the historical view of the partition allocation as well. And on the top tab, there's a Tablespace Growth tab. Again, it shows the historical growth of the tablespace over time. And if you want to predict that out to the future, you could easily select a future date and predict that out to the future as such. And you can see, again, we'll graph the historical information, and, then we'll predict out the future information. So you can see over time, over trending, the growth and the prediction of your space at a future date. And the same can be done on the bottom. If you have a partition that's on the bottom, you select a single partition, you can predict out by partition a future growth for that partition as well. So if I go to year 2017 and just pick a date, you can see that we've predicted out by that ending date what the value, what the allocated amount of space would be used for that partition. So it's a pretty handy prediction mechanism that we have for both tables, tablespaces, and indexes. And also for indexes, you'll see that we also have a Data Sets tab there. It shows you the underlying data set that is allocated and used-- allocated RBA, used RBA for that data set along with the volume information for that and the space usage information for the index as well. So Toad for DB2-- displaying space information, helping you as a DBA prepare for your space allocation needs in the future.