Hi, this is Jeff Podlasek with Toad DB2 development. In Toad for DB2, version 6.2, we've introduced a new dashboard feature. This dashboard feature can be used by DB2 LUW DBAs to get high level, important information about their database and database objects in one control.
I've got Toad up and running. And new in this 6.2 release, you can see that we have this dashboard menu item. And if you click on it, on the drop down area, you can see that we have the ability to create a new dashboard, a summary dashboard, or manage any existing dashboards. You can also get to that dashboard feature from the tools menu as well.
So what I'm going to do, is I'm going to just create a new dashboard from my existing connection by clicking this new dashboard. And this dashboard tab opens up. And inside the dashboard tab you'll see a set of controls, and we call each one of these controls widgets.
And each widget is specifically reporting on a feature of DB2 LUW. You can see, for example, the number of open connections you have. If you have any invalid objects. If there's a monitoring tab where you can monitor your amount of applications. You can monitor your buffer pool hit rates, et cetera.
So there is a set of default widgets that we display when you create your initial dashboard. And these widgets can be removed, you can add other widgets to this control as well. So if you wanted to remove a widget you would just click the X button, and remove the widget. If you wanted to add another widget to this display, you would just click this plus here, on the add widget control, and you could select any additional widgets that you might want to have being shown on your dashboard. So I selected that new additional one.
And some of these widgets, you can see they all have refresh buttons on them. So if you wanted to refresh a display, you would just click this little refresh button. And some widgets are tied together, in that we fetch background information and populate a couple widgets at once. So if you refresh one widget, others may be refreshed as well.
So that's information about high level important database information. And some of these widgets you can drill down to obtain further information. So for example, on this invalid objects widget, we're showing the schemas. If you click on a schema here, you can actually see the object that is invalid for that schema. And then you can right click and take corrective actions on that.
Same with non-enforced constraints. We show you the schemas of non-enforced constraints. Then you can drill down to get to the constraints themselves and alter them to make them enforced, if you so wish.
Another thing to point out here is there's a quick notes thing, that you could keep your own notes in this section. So add anything you want there, if you wanted to. And we also have the ability to roll your own queries and use those. So if I click on the add widgets button, and if I select the simple select widget and click add. You can see that the new widget shows up, and it has a settings control.
So if you click on the widget settings button, the settings control comes up. And we give you four different views, or four different manners that data can be displayed. Either via grid, a bar, a line, or a pie chart. In the first example here I'm just going to show you what a grid chart can look like. So I'm going to just type in some canned SQL and click apply. And the SQL that I entered, in essence, counts up the amount of tables and displays those by schema. So you can see that my JPODLAS schema has 111 tables.
Just an example report. You could roll your own, you could query you know the IBM catalog. You could query your own application, tables, it really doesn't matter. I mean whatever is important to you, whatever you want shown on this dashboard. So I'm going to add another widget and this time I'm going to choose the simple select. And this time I'm going to say I want it to be a bar chart. And I'm going to enter some data from my selecting, from my sales table. Type it in here, and click apply. And you can see that my sales by regions of my sample sales table shows the amount of sales per region.
So very easy to customize your own widgets. Again, if you didn't want them, you could just x them to close them. And one thing to note is that each one of these widgets that are canned, pre-canned, can only be added once. So you can't have multiple open connections, or multiple invalid objects. It doesn't make sense. So we'll only allow you to add widgets that are not shown on your display. Or you can add multiple of the simple select widgets as well.
And then, if you go to close this, it's going to ask if you want to save it. So I'm going to save it, and it basically saves it by default to the name of my connection profile. And so next time I come back, if I ever wanted to open up that dashboard, I could just go to my dashboards. See all my dashboards that I've saved there, and click open. And the dashboard will open with all the widgets in it that I had saved.
So that is an example of creating a dashboard for DB2 LUW. And again, I'm going to connect to another DB2 LUW database. And I'm just going to connect and create another dashboard for it so you can see that. By default it takes my current connection, and it says create a
07:45