Db2
IBM Db2 z/OS
Overview Supported Objects Download

IBM Db2 z/OS

IBM Db2 z/OS object type support.

The following table shows the database specific support in DbVisualizer for IBM 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 TypeActionsViewers
Schemas
   Schemas
Schema
   References, Tables
Tables
 Create Table[1], Import Table Data[1] References, Tables
Table
 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, 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 Data, Columns, Indexes, Info, Row Count, Source
Columns
   Columns
Column
 Comment Column Column
TemporaryTables
   Temporary Tables
TempTable
 Script: Script Table, Drop Table Columns, Info
Aliases
 Create Alias Aliases
Alias
 Script: Script Alias, Comment Alias, Drop Alias Data, Columns, Info, Row Count
Synonyms
 Create Synonym Synonyms
Synonym
 Script: Script Synonym, Drop 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
 Script: Script Materialized Query Table, Comment Materialized Query Table, Drop Materialized Query Table, Refresh Materialized Query Table Data, Columns, 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 TableSpace[2], 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
Cookie policy

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. Please find our cookie policy here ↗