DB2 LUW - 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 on Linux/Unix/Windows RDBMS.

Database Objects Tree

The following table shows what objects DbVisualizer handles for a DB2 on Windows/Linux 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 Create Schema Schemas Schema Export Schema, Comment Schema, Drop Schema   Tables Import Table Data, Create Table References, Tables Table Export Table, Import Table Data, Create Trigger, Alter Table, Comment Table, Create Index, Drop Table, Empty Table, Rename Table, Script: CREATE TABLE, Script: DELETE, Script: INSERT, Script: SELECT, Script: UPDATE References, Navigator1, Columns, Constraints, DDL, Data, Grants, Indexes, Info, Primary Key, Row Count, Row Id, Triggers Columns   Columns Column Comment Column Column Indexes   Indexes Index Comment Index, Drop Index, Rename Index Columns, Index Triggers   Triggers Trigger Comment Trigger, Drop Trigger Trigger Editor, Info, Source Views   Views View Create Trigger, Comment View, Drop View, Script: CREATE VIEW, Script: DELETE, Script: INSERT, Script: SELECT, Script: UPDATE Columns, DDL, Data, Info, Row Count Triggers   Triggers Trigger Comment Trigger, Drop Trigger Trigger Editor, Info, Source Aliases Create Alias Aliases Alias Comment Alias, Drop Alias, Script: DELETE, Script: INSERT, Script: SELECT, Script: UPDATE Columns, Data, Info, Row Count Nicknames   Nicknames Nickname Comment Nickname, Drop Nickname, Script: DELETE, Script: INSERT, Script: SELECT, Script: UPDATE Columns, Data, Info, Row Count Indexes   Indexes Index Comment Index, Drop Index, Rename Index Columns, Index Sequences Create Sequence Sequences Sequence Drop Sequence Info SystemTables   SYSCAT, SYSFUN, SYSIBM, SYSSTAT MaterializedQueryTables   Materialized Query Tables MaterializedQueryTable Comment Materialized Query Table, Drop Materialized Query Table, Refresh Materialized Query Table, Script: DELETE, Script: INSERT, Script: SELECT, Script: UPDATE Columns, Data, Info, Row Count, Source Functions Create Function Functions Function Comment Function, Drop Function, Script: CALL Function Editor, Info, Parameters, Result Procedures Create Procedure Stored Procedures Procedure Comment Procedure, Drop Procedure, Script: CALL Procedure Editor, Info, Interface DB2Packages   Packages DB2Package Drop Package Info Triggers   Triggers Trigger Comment Trigger, Drop Trigger Trigger Editor, Info, Source DBA   DBA Users   Users User   Column Privilege, Index Privilege, Info, Package Privilege, Passthru Privilege, Schema Privilege, Table Privilege Groups   Roles Group   Column Privilege, Index Privilege, Info, Package Privilege, Passthru Privilege, Schema Privilege, Table Privilege Locks2   Locks Tablespaces   Table Spaces 1) DbVisualizer Personal 2) Version 8.0 and later

Explain Plan Explain Plan executes your query and records the plan that the database devises to execute it. By examining this plan, you can find out if the database is picking the right indexes and joining your tables in the most efficient manner. The explain plan feature works much the same as executing SQLs to present result sets, you may highlight statements, run a script or load from file. The explain plan results can easily be compared by using the pin feature in combination with window style presentation.

1 2

---