Now, the Toad database and map feature, which supports DB2 for z/OS as well as the DB2 for LUW, can be invoked using this tool button on the top tool menu as well.
So if you click the database map tool button, you'll see that an empty database map gets opened. And you could use the Object Explorer. And you could drag and drop objects onto the database map control. And as you drag and drop objects, their relationships will be fetched. And if they are related to existing objects that are in the display, you can see that they will be tied together or associated with each other.
So what I'm doing now, I'm just dragging a set of tables in individually. I could have drug them all at the same time. But I'm doing this demonstration to show you that the database map is an interactive control, where if objects get added to a database map and there's already existing objects there, their relationships will be shown and depicted on the database map.
And so this is a pretty cool example here where it's showing-- I drug a bunch of tables. And each table has a set of indexes. If I wanted to just not display those indexes, this is actually going to show me the relationship between the tables. And we can see that they are related by a view and they live in the same tablespace.
So once again, a very cool example of how showing and understanding the relationships between your database objects is an important thing for a DBA or even a developer.