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 Tables with Reorg Pending flag
• List of MDC tables, partitioned tables, column-organized tables

Details Display

• Columns
• Column sizing
• Table Details
• Primary Key Columns
• Unique Constraint Columns
• Indexes and Index Sizing
• Authorities on Table
• Views on Table
• Aliases on Table
• Packages using Table
• Compiled Routines using Table
• Other objects using Table
• Triggers on/using Table
• Referenced Tables (Foreign Keys)
• Dependent Tables
• Hash Partitioning Key
• Range Partitions and Partitioning Expressions
• MDC Dimensions

• Create / Alter / Drop / Redefine Table
• Create View / Summary Table 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 Alias on Table
• Generate DDL for Table and related indexes, keys, views, triggers, constraints, aliases
• Administer Authorities for Table
• Compare tables definitions
• Manage table descriptions
• Manage column descriptions
• Rename table/s
• Rename columns
• Reset check pending on table/s
• Set integrity off for Tables
• Runstats on Table/s
• Reorg Table/s
• Activate not logged
• Delete contents of Table/s (truncate)
• Rebind dependent packages for Table

Display

Actions

• Columns
• View Details
• View Definition
• Authorities on View
• Views on View
• Aliases on View
• Packages using View
• Routines using View
• Triggers on View
• Other objects using View
• Objects used by View

• Create / Alter / Drop View
• Generate DDL for View
• Administer Authorities for View
• Compare View definitions
• Manage View comments
• Manage column comments

Display

Actions

• Columns
• Alias Details
• Authorities on Alias
• Views on Alias
• Aliases on Alias
• Packages using Alias
• Other objects using Alias

• Create / Alter / Drop Alias
• Generate DDL for Alias

Display

Actions

• Columns
• Column sizing
• Summary Table Definition
• Table Details
• Indexes and Index Sizing
• Authorities on View
• Views on Table
• Aliases on Table
• Packages using Table
• Compiled Routines using Table
• Other objects using Table
• Hash Partitioning Key
• Range Partitions and Partitioning Expressions
• MDC Dimensions

• Create / Drop Summary Table
• Create View / Alias / Index on Summary Table
• Generate DDL for Table and related indexes, views, aliases
• Administer Authorities for Summary Table
• Manage table descriptions
• Manage column descriptions
• Rename Summary Table/s
• Rename columns
• Runstats on table/s
• Reorg table/s
• Refresh Summary Table
• Set Definition Only
• Activate not logged

Display

Actions

• Columns
• Nickname Options
• Nickname Column Mappings
• Nickname Details
• Authorities on Nickname
• Packages using Nickname

• Create / Drop Nickname
• Generate DDL for Nickname
• Administer Authorities for Nickname
• Manage Nickname descriptions

Display

Actions

List Displays

• List of Indexes with Index Type and indexed Table
• List of Indexes with Index Sizing
• List of Indexes with Last Used Date
• List of Indexes with Descriptions

Details Displays

• Index Columns
• Index Details
• Authorities on Index
• Dependent Packages

• Create / Drop Index
• Generate DDL for Index
• Administer Authorities for Index
• Manage Index descriptions
• Rename Index
• Runstats on Index

Display

Actions

List Displays

• List of Tablespaces with Tablespace Type and Description
• List of Tablespaces with physical details (page size, bufferpool, partition group, storage group)
• List of Tablespaces with Sizing Info
• List of Tablespaces with Snapshot Info (current sizing)

Details Displays

• Tables in Tablespace
• Range Partitions in Tablespace
• Indexes in Tablespace
• Authorities on Tablespace
• Tablespace Containers
• Tablespace Utilization
• Tablespace Snapshot detail

• Create / Alter Tablespace
• Generate DDL for Tablespace including tables in Tablespace
• Administer Authorities for Tablespace
• Compare Tablespaces
• Rename Tablespace
• Set Tablespace/s online
• Extend Containers

Display

Actions

• Package Detail
• Objects used by Package
• Routines used by Package
• Package Statements
• Authorities for Package

• Drop Package
• Rebind Package/s
• Explain Package/s
• Administer Authorities for Package

Display

Actions

• Trigger Text
• Trigger Detail
• Objects used by Trigger

• Create / Alter / Drop Trigger
• Generate DDL for Trigger
• Compare Trigger
• Manage Trigger descriptions

Display

Actions

• Routine Parameters
• Routine Text
• Routine Detail
• Object used by Routine
• Views using Routine
• Packages using Routine
• Routines using Routine
• Authorities for Routine

• Create SQL or External Routine
• Alter / Drop Routine
• Generate DDL for Routine
• Compare Routine
• Manage Routine descriptions

Display

Actions

• Routines in Module
• Module Text
• Module Detail
• Module Parameters
• Modules Variables
• Objects used by Module
• Routines using Module
• External Routines detail

Display

Actions

• Tables in Bufferpool
• Indexes in Bufferpool

• Create / Alter / Drop Bufferpool
• Generate DDL for Bufferpool

Display

Actions

• Partitions in Partition Group
• Tablespaces in Partition Group
• Partition-Group specific Bufferpools

• Generate DDL for Partition Group

Display

Actions

• Details of Storage Group
• Tablespaces using Storage Group
• Sizing of Tablespaces using Storage Group

Display

Actions

• Details of Sequence
• Tables using Sequence
• Authorities for Sequence

• Create / Alter / Drop Sequence
• Generate DDL for Sequence
• Compare Sequences
• Manage Authorities for Sequence

Display

Actions

• Roles for User / Group
• Authids with have this Role
• Table Authorities
• Table Authorities (with Grantor)
• Package Authorities
• Schema Authorities
• Tablespace Authorities
• Database Authorities
• Index Authorities
• Function Authorities
• Procedure Authorities
• Sequence Authorities

• Create / Alter Role
• Manage Role Membership
• Manage Table Authorities
• Manage Package Authorities
• Manage Schema Authorities
• Manage Tablespace Authorities
• Manage Database Authorities
• Manage Index Authorities
• Manage Function Authorities
• Manage Procedure Authorities
• Manage Sequence Authorities

Display

• System and User Data Types
• Servers with Nicknames and Type Mappings
• Column Name
• XSR Objects
• Security Labels