DB2 for Windows/Linux - Database Specific Support

 DbVisualizer Logo
DbVisualizer 6.0
July 2007 		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
Comment Schema, Drop Schema
Tables
Create Table References, Tables
Table
Alter Table, Comment Table, Create Index, Drop Table, Empty Table, Import Table Data, Rename Table, Script: CREATE TABLE, Script: DELETE, Script: INSERT, Script: SELECT, Script: UPDATE Columns, Constraints, DDL, Data, Grants, Indexes, Info, Navigator, Primary Key, References, Row Count, Row Id, Triggers
Views
Views
View
Comment View, Drop View, Script: CREATE VIEW, Script: DELETE, Script: INSERT, Script: SELECT, Script: UPDATE Columns, DDL, Data, Info, Row Count
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
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 Info, Parameters, Result
Procedures
Create Procedure Stored Procedures
Procedure
Drop Procedure Info, Interface
Packages
Packages
Package
Drop Package Info
Triggers
Triggers
Trigger
Comment Trigger, Drop Trigger 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 version 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