DB2 LUW - Database Specific Support

DbVis Software
DbVisualizer 7.0 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 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


Copyright © 2010 DbVis Software AB. All rights reserved.