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 Type Actions Viewers
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 ↗