Previous Topic

Next Topic

Book Contents

Book Index

DB2 LUW

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

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 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

Views

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

Aliases

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

Summary Tables

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

Nicknames

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

Indexes

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

Tablespaces

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

Packages

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

Triggers

Display

Actions

  • Trigger Text
  • Trigger Detail
  • Objects used by Trigger
  • Create / Alter / Drop Trigger
  • Generate DDL for Trigger
  • Compare Trigger
  • Manage Trigger descriptions

Routines (Functions and Procedures)

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

Modules

Display

Actions

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

Bufferpools

Display

Actions

  • Tables in Bufferpool
  • Indexes in Bufferpool
  • Create / Alter / Drop Bufferpool
  • Generate DDL for Bufferpool

Database Partition Groups

Display

Actions

  • Partitions in Partition Group
  • Tablespaces in Partition Group
  • Partition-Group specific Bufferpools
  • Generate DDL for Partition Group

Storage Groups

Display

Actions

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

 

Sequences

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

Authids (Users, Groups and Roles)

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

Other Displays

Display

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