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

Toad for DB2 on z/OS has a multi-database query facility that allows you to query across subsystems and have a single result set report back to you, which also includes custom cell formatting, which gives you the ability to create your own dashboards. Now I've got Toad up and running. And I'm going to invoke this facility via the Tools, Query Multiple Databases option. And this brings up the Multiple Database Query facility. We ship a few samples to get you going. You could start your own. Or you could actually use one of these and clone it. So I'm going to select the Z/OS Tablespace RTS Check report and click Next. And so I'm going to select the subsystems that I want this report to run against. So I'm going to select a couple subsystems just so you have an example of how things might work in a multi-subsystem environment. And I'm going to click Next here. And I'm going to edit this query. This is a canned query that we ship. It's basically going against the real-time statistics tablespace tables and allows you to do some custom formatting here. And to do custom formatting, it's very easy. You could just basically click on a column. I'm going to try to give it something that we might have. So we might be able to flag here-- we're going to go. So click OK. And then you could format the text of that column, and then the background of that column, if you want as well, so it will really stand out. I know this might not be a valid format. But I'm giving you the option, or the ability to see how some of these things are formatted. And you could see, below here, this is a preview screen. So as you're formatting the cells with colors, you could see how they will look on the report. So this is just a preview. I'm going to click OK. You could add additional reports here. You don't have to just have one query. You could have multiple queries. Then I'm going to click Finish. And this will bring up the multi-database query tab. And that query will be run against the subsystems that I have selected. I'm going to select the two. And I just highlighted this in there so you could see the formatting. But you could see that-- virtually, you could create your own dashboard here, where objects in rows will be highlighted however you would customize that. So it's a pretty handy facility for querying and reporting across of multiple databases. I'm just going to close this. I'm not going to save it because it was a bogus report. But I'm going to bring the facility up again. And this time, I'm going to create my own. So I could create my own custom report. And, again, I'm going to select a couple subsystems. And you have the ability of using fully qualified SQL or non. And if it's non, then we give you the facility of selecting the qualifiers, the creators, the schemas, that you might want to use when that query is run. But mine are fully qualified. And I'm just going to add a query. And I have a query, which I'm just going to enter quickly. And it's basically, again, reporting from SYSTABLEPART. I could hit this Refresh. And it's actually going to retrieve-- go out to the first subsystem that I select and retrieve those rows. And then I'll add some formatting. So I'm going to add some formatting that's going to say, if the extents are greater than 5, let's flag that as a red color text with a light-colored background. And I'm going to add another one where I'm going to just basically say where there the CARD, cardinality is greater than 1,000-- and you could roll your own, again-- and that's 10,000. And I'm going to change this to be that, with a light-colored background like that. And you could see, again, the preview area below. It's updated to reflect your cell format. And I'm going to click OK, click Finish. And so this query that I just entered, along with the cell formatting, that's being run. And you could see that those queries are running against the subsystems that I've selected. And as that information is coming back, this report is being populated. And you could see things are being highlighted. So it's like you're creating your own dashboard. And this facility works for DB2 z/OS, as well as LUW. But this is demonstration is for DB2 z/OS, the multi-database query facility in Toad for DB2.