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