Db2
Db2 Tested for version 8.2+
Overview JDBC Drivers Features Supported Objects Download

Db2

Db2 object type support.

The following table shows the database specific support in DbVisualizer for Db2 organized per database object type.

  • Object Type - show what object types are listed in the Databases tab
  • Actions - show what actions are available for the object type
  • Viewers - show what viewers are available for the object type
Object TypeActionsViewers
Schemas
 Create Schema Schemas
Schema
 Export Schema[1], Comment Schema, Drop Schema References, Tables
Tables
 Create Table[1], Import Table Data[1] References, Tables
Table
 Alter Table[1], Create Trigger, Export Table[1], Import Table Data[1], Script: Script Table, Comment Table, Create Index, Drop Table, Empty Table, Rename Table Navigator[1], References, Data, Columns, Constraints, DDL[1], Grants, Indexes, Info, Primary Key, Row Count, Row Id, Triggers
Columns
   Columns
Column
 Comment Column Column
Indexes
   Indexes
Index
 Script: Script Index, Comment Index, Drop Index, Rename Index DDL[1], Index
Triggers
   Triggers
Trigger
 Export Trigger[1], Comment Trigger, Drop Trigger Trigger Editor[1], Info, Source
Views
   Views
View
 Create Trigger, Export View[1], Script: Script View, Comment View, Drop View Data, Columns, DDL[1], Grants, Info, Row Count, Triggers
Columns
   Columns
Column
 Comment Column Column
Triggers
   Triggers
Trigger
 Export Trigger[1], Comment Trigger, Drop Trigger Trigger Editor[1], Info, Source
Temporary Tables
   Temporary Tables
Temporary Table
 Script: Script Table, Drop Table Columns, Info
Aliases
 Create Alias Aliases
Alias
 Script: Script Alias, Comment Alias, Drop Alias Info
Nicknames
   Nicknames
Nickname
 Script: Script Nickname, Comment Nickname, Drop Nickname Data, Columns, Info, Row Count
Indexes
   Indexes
Index
 Script: Script Index, Comment Index, Drop Index, Rename Index DDL[1], Index
Sequences
 Create Sequence Sequences
Sequence
 Comment Sequence, Drop Sequence Grants, Info
System Tables
   SYSCAT, SYSFUN, SYSIBM, SYSSTAT
Materialized Query Tables
   Materialized Query Tables
Materialized Query Table
 Script: Script Materialized Query Table, Comment Materialized Query Table, Drop Materialized Query Table, Refresh Materialized Query Table Data, Columns, Indexes, Info, Row Count, Source
Indexes
   Indexes
Index
 Script: Script Index, Comment Index, Drop Index, Rename Index DDL[1], Index
Functions
 Create Function Functions
Function
 Export Function[1], Script: Script Function, Comment Function, Drop Function Function Editor[1], Info, Parameters, Result
Stored Procedures
 Create Procedure Stored Procedures
Procedure
 Export Procedure[1], Script: Script Procedure, Comment Procedure, Drop Procedure Procedure Editor[1], Info, Interface
Packages
   Packages
DB2 Package
 Drop Package Info
Triggers
   Triggers
Trigger
 Export Trigger[1], Comment Trigger, Drop Trigger Trigger Editor[1], Info, Source
DBA Views
   DBA
Users
   Users
User
   Column Privilege, Index Privilege, Info, Package Privilege, Passthru Privilege, Roles, Schema Privilege, Table Privilege
Groups
   Roles
Group
   Column Privilege, Index Privilege, Info, Package Privilege, Passthru Privilege, Roles, Schema Privilege, Table Privilege
Roles[2]
 Create Role Roles
Role
 Drop Role Column Privilege, Groups, Index Privilege, Info, Package Privilege, Passthru Privilege, Schema Privilege, Table Privilege, Users
Locks[3]
   Locks
Table Spaces
   Table Spaces
[1] DbVisualizer Pro
[2] Version 9.5 and later
[3] Version 8.0 to 9.6