Customer Testimonial:

I've been using DbVisualizer as a developer for about 5 years now. It has never failed to impress me as one of the most useful tools in my toolbox. ...

SUNY Learning Environments - Bernie Durfee

DB2 z/OS

Database Specific Support

The following table show the database specific support for DB2 z/OS 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 Type Actions Viewers
Schemas
  Schemas
Schema
   
Tables
Create Table, Import Table Data References, Tables
Table
Create Trigger, Export Table, Import Table Data, Comment Table, Create Index, Drop Table, Empty Table, Rename Table, Script: Script Table Navigator1, References, Columns, Constraints, DDL, Data, Grants, Indexes, Indexes Columns, Info, Primary Key, Row Count, Row Id, Triggers
Columns
  Columns
Column
Comment Column Column
TableIndexes
  Indexes
Index
Comment Index, Drop Index, Rename Index Columns, Index
Triggers
  Triggers
Trigger
Comment Trigger, Drop Trigger Info, Source
Views
  Views
View
Comment View, Drop View, Regenerate View Columns, Data, Indexes, Info, Row Count, Source
Columns
  Columns
Column
Comment Column Column
TemporaryTables
  Temporary Tables
TempTable
Drop Table, Script: Script Table Columns, Info
Aliases
Create Alias Aliases
Alias
Comment Alias, Drop Alias, Script: Script Alias Columns, Data, Info, Row Count
Synonyms
Create Synonym Synonyms
Synonym
Drop Synonym, Script: Script Synonym Info
Indexes
  Indexes
Index
Comment Index, Drop Index, Rename Index Columns, Index
Sequences
Create Sequence Sequences
Sequence
Comment Sequence, Drop Sequence Grants, Info
MaterializedQueryTables
  Materialized Query Tables
MaterializedQueryTable
Comment Materialized Query Table, Drop Materialized Query Table, Refresh Materialized Query Table, Script: Script Materialized Query Table Columns, Data, Indexes, Info, Row Count, Source
Functions
  Functions
Function
Comment Function, Drop Function Info, Parameters, Result
Procedures
  Stored Procedures
Procedure
Comment 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, Database Privilege, Info, Package Privilege, Plan Privilege, Resource Privilege, Routine Privilege, Schema Privilege, Table Privilege
Roles
  Roles
Role
  Column Privilege, Database Privilege, Info, Package Privilege, Plan Privilege, Resource Privilege, Routine Privilege, Schema Privilege, Table Privilege
Tablespaces
Create LOB Tablespace, Create Partitioned Tablespace, Create Segmented Tablespace, Create Simple TableSpace2, Create Universal partitioned-by-growth Tablespace, Create Universal partitioned-by-range Tablespace Table Spaces
Tablespace
Alter NON-PARTITIONED Tablespace, Drop Tablespace Info
Databases
Create Database Databases
Database
Alter Database, Drop Database Info
Storagegroups
Create Storage Group Storage Groups
Storagegroup
Alter Storage Group, Drop Storage Group Info
1) DbVisualizer Pro
2) Version 8.1 and earlier

We use cookies to ensure that we give you the best experience on our website. However you can change your cookie settings at any time in your browser settings.

Close