DB2 for Windows/Linux - Database Specific Support

 DbVisualizer Logo
DbVisualizer 6.5
October 2008 		http://www.dbvis.com
support@dbvis.com

[ Master documentation index ]

Introduction

In addition to the standard feature set in DbVisualizer this document briefly covers the database specific support in DbVisualizer for the DB2 on Windows/Linux 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
Create Table References, Tables
Table
Import Table Data, Create Trigger, Alter Table, Create Index, Comment Table, Drop Table, Empty Table, Rename Table, Script: CREATE TABLE, Script: DELETE, Script: INSERT, Script: SELECT, Script: UPDATE References, Navigator, Columns, Constraints, DDL, Data, Grants, Indexes, Info, Primary Key, Row Count, Row Id, Triggers
Columns

Columns
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
Drop Function Function Editor, Info, Parameters, Result
Procedures
Create Procedure Stored Procedures
Procedure
Drop Procedure 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
Locks1

Locks
Tablespaces

Table Spaces
1)DB2 8 or 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