Previous Topic

Next Topic

Book Contents

Book Index

DB2 for z/OS

The Database Explorer window provides the following support for DB2 for z/OS objects.

AQT detects whether the database is running in New Function Mode and uses different system queries as appropriate.

Tables

Display

Actions

List Displays

  • List of Tables/Views etc including Description
  • List of Tables with Table Sizing
  • List of Tables/Views etc with Create / Alter date
  • List of Clones Tables
  • List of Tables with their Archived Tables

Details Display

  • Columns
  • Identity columns
  • Primary Key Columns
  • Indexes
  • Tablespace partitions
  • Check Constraints
  • Authorities on Table
  • Packages using Table
  • Views on Table
  • Local Aliases on Table
  • Synonyms on Table
  • Triggers on Table
  • Referenced Tables (Foreign Keys)
  • Dependent Tables
  • Auxiliary Tables
  • Create / Alter / Drop / Redefine Table
  • Create View on table
  • Create Alias on Table
  • Create Primary Key / Index / Unique Constraint on Table
  • Create Foreign Key on Table
  • Create Trigger on Table
  • Create Check Constraint on Table
  • Create Remote Alias on Table
  • Create Auxiliary Table
  • Create Partitioning Index
  • Generate DDL for Table and related indexes, keys, views, triggers, constraints, aliases
  • Administer Authorities for Table
  • Compare table definitions
  • Manage table comments
  • Manage table labels
  • Manage column comments
  • Manage column labels
  • Rename table/s
  • Rename columns

Views

Display

Actions

  • Columns
  • View Details
  • View Definition
  • Authorities on View
  • Dependent Packages
  • Views on View
  • Local Aliases on View
  • Synonyms on View
  • Objects used by View
  • Triggers on View
  • Create / Alter / Drop View
  • Create Trigger on View
  • Generate DDL for View
  • Administer Authorities for View
  • Compare View definitions
  • Manage view comments
  • Manage view labels
  • Manage view comments
  • Manage view labels

Aliases

Display

Actions

  • Columns
  • Base table/view (local aliases only)
  • Alias Detail
  • Dependent Packages
  • Create / Drop Alias
  • Create remote Alias
  • Generate DDL for Alias
  • Manage Alias comments

Synonyms

Display

Actions

  • Columns
  • Base table/view
  • Dependent Packages
  • Create / Drop Synonym
  • Generate DDL for Synonym

Materialized Query Tables

Display

Actions

  • Columns
  • Indexes
  • Tablespace Partitions
  • Full Detail
  • Access List
  • Dependent Packages
  • Views on MQT
  • Local Aliases on MQT
  • Synonyms on MQT
  • MQT Definition
  • Create / Alter / Drop MQT
  • Generate DDL for MQT
  • Administer Authorities for MQT
  • Refresh MQT
  • Manage MQT comments
  • Manage MQT labels
  • Manage MQT comments
  • Manage MQT labels

Auxiliary Tables

Display

Actions

  • Base table
  • Columns
  • Full Detail
  • Indexes
  • Create Auxiliary Table
  • Generate DDL for Aux Table
  • Manage Table comments
  • Manage Table labels

Indexes

Display

Actions

  • Columns in Index
  • Column Expressions
  • Index Details
  • Index Partitions
  • Packages using Index
  • Create / Alter / Drop Index
  • Generate DDL for Index
  • Manage Index comments

Tablespaces

Display

Actions

List of Tablespaces within Database

  • Tablespaces with Sizing
  • Tablespaces with Status
  • Tablespaces with Physical Info
  • Tablespaces with Tablespace Ids
  • Tablespaces with Other Details
  • Tablespaces with Last Image Copy

Tablespace Details

  • Tables within Tablespace
  • Table sizing info
  • Tablespace Details
  • Tablespace Partitions
  • Image Copies of Tablespace
  • Create / Alter / Drop Tablespace
  • Create standard or partitioned Tablespace
  • Generate DDL for Tablespace
  • Compare Tablespaces

Plans

Display

Actions

  • Plan Detail
  • Packages in Plan
  • Objects used by Plan
  • Statements
  • Authorities on Plan
  • Administer Authorities for Plan
  • Compare Plans

Packages

Display

Actions

  • Package Detail
  • Objects used by Package
  • Statements
  • Authorities on Package
  • Authorities on related Procedure / Function
  • Drop Package
  • Generate Bind Package statement
  • Administer Authorities for Package
  • Compare Packages

Triggers

Display

Actions

  • Trigger Detail
  • Trigger Text
  • Create / Redefine / Drop Trigger
  • Generate DDL for Trigger
  • Compare Triggers
  • Manager Trigger comments

Routines (Procedures and Functions)

Display

Actions

  • Routine Parms
  • Routine Detail
  • Routine Text (SQL Routine only)
  • User Authorities on Routine
  • Package Authorities on Routine
  • Create / Alter / Redefine / Drop Routine
  • Create External or SQL Routine
  • Generate DDL for Routine
  • Manage Routine comments
  • Manage authorities on Routine
  • Alter Procedure Options
  • Drop Procedure Version
  • Activate Procedure Version

Users

Display

Actions

  • Table Authorities
  • Plan Authorities
  • Package Authorities
  • Database Authorities
  • Procedure Authorities
  • Function Authorities
  • Sequence Authorities
  • Manage Table Authorities
  • Manage Plan Authorities
  • Manage Package Authorities
  • Manage Database Authorities
  • Manage Procedure Authorities
  • Manage Function Authorities
  • Manage Sequence Authorities

Databases

Display

Actions

  • Details of Database
  • Tablespaces within Database
  • Authorities on Database
  • Create / Alter Database
  • Generate DDL for Database (including Tablespaces and Tables)
  • Administer Authorities for Database
  • Compare Databases

Storage Groups

Display

Actions

  • Tablespace Partitions
  • Volumes
  •  

Sequences

Display

Actions

  • Sequence Properties
  • Full Details of Sequence
  • Authorities on Sequence
  • Create / Alter Sequence
  • Generate DDL for Sequence
  • Manage Sequnce comments
  • Administer Authorities for Sequence
  • Compare Sequences