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

Toad for DB2 z/OS has many features that allow a DB2 z/OS DBA to keep track of their subsystem. On Toad, you could select a subsystem from your dropdown list of objects. And then, on the right-hand side, you'll see a series of tabs that display various information. The first tab is going to display your connection information. The second tab is going to display your Z-parameters and their values. The next tab will display the threads or the applications that are connected to your subsystem. And you could easily right-click and cancel a thread if you so wish to do that. We have a Utilities tab that will display currently executing or stopped utilities, and you could easily right-click and terminate those utilities as well, if you wish to. We have a Pending Objects tab that's going to show you objects that are in pending state, such as copy pending, REORG pending, et cetera, and allows you to view those objects in one report. There's a Pending DDL tab that shows you the changes that are still pending. So, for example, sometimes you'll make a modification to certain database objects, and those won't actually take account until reorganization has been done. So, you can see that, if there are some pending changes, that will show up in this report here. And we have a Dynamic Statement Cache tab as well, which will show you dynamic statement cache tables and their contents. And it will also allow you to create those if you do not have those. So, if you wanted to create a dynamic statement cache table, we'll generate the syntax for that. If you want to actually externalize information from DB2's memory into a dynamic statement cache table, you could do that as well, just by running this statement that will externalize the data. Then, once the data is externalized, you could view it on the bottom grid. And you can see information about that data. You can see the SQL statements that were captured in that dynamic statement cache table. You could do things like open that SQL in a SQL editor. So, we'll open up an editor. Quickly format that to see what it looks like. And you could do things like run that, set it to our query to be explained, check out the explain plan for it. So, a pretty powerful set of tools around the dynamic statement cache. You can also do things like display whether you have minor traces that are off, which affects how much data is going to be in the dynamic statement cache. And things like starting and stopping those monitors, as well. We also have an Administrative Authorities tab. And this tab is going to display the high-level authorities that users might have. For example, sysadmin authorities, install authority, syscontrol-- so, those higher-level authorities will be displayed on this control here. And you get things like automatically invoke our user privileges screen to automatically modify authorities for any given user that is showing up here. So, those are the things that are available in the DB2 zOS Subsystem tab.