DB2 z/OS - Database Specific Support

Introduction

In addition to the standard feature set in DbVisualizer this document briefly covers the database specific support in DbVisualizer for the DB2 z/OS RDBMS.

Database Objects Tree

The following table shows what objects DbVisualizer handles for a DB2 z/OS database. The first column list the structure and the object types. The actions column lists all actions that are associated with the object types and the last column shows all viewers that appear when selecting an object in the tree.

The screenshots illustrates the visual representation of the objects tree.

Object Type Actions Viewers Schemas   Schemas Schema     Tables Create Table References, Tables Table Import Table Data, Create Index, Drop Table, Empty Table, Rename Table, Script: DELETE, Script: INSERT, Script: SELECT, Script: UPDATE References, Navigator1, Columns, Data, Grants, Indexes, Info, Primary Key, Row Count, Row Id, Triggers Columns   Columns Column   Column Indexes   Indexes Index Drop Index Columns, Index Views   Views View Drop View, Script: DELETE, Script: INSERT, Script: SELECT, Script: UPDATE Columns, Data, Indexes, Info, Row Count, Source Aliases Create Alias Aliases Alias Drop Alias Info Indexes   Indexes Index Drop Index Columns, Index SummaryTables   Summary Tables SummaryTable   Columns, Data, Indexes, Info, Row Count, Source Functions   Functions Function Drop Function Info, Parameters, Result Procedures   Procedures, Stored Procedures Procedure Drop Procedure Info, Interface Packages   Packages Package   Info Triggers   Triggers Trigger Drop Trigger Info, Source DBA   DBA Users   Column Privilege, Database Privilege, Package Privilege, Plan Privilege, Resource Privilege, Routine Privilege, Schema Privilege, Table Privilege, User Privilege Tablespaces   Table Spaces 1) DbVisualizer Personal

---