Chat now with support
Chat with Support

SQL Optimizer for DB2 LUW 4.3.1 - User Guide

SQL Optimizer for IBM® DB2® LUW
About SQL Optimizer for IBM DB2 LUW Getting Started Options SQL Scanner SQL Optimizer SQL Formatter SQL Inspector Database Explorer SQL Repository Index Impact Analyzer Index Usage Analyzer User-Defined Temp Table Editor Functions SQL Functions SQL Information and Functions Activity Log
Tutorials About us Copyright

Database Explorer Window

ClosedView the Database Explorer

The Database Explorer window is divided into two sections:

Database Objects

Displays a tree diagram of the database objects these include schemas, tables, views, aliases, procedures, functions, triggers, packages, nicknames and user-defined types.

Object Information

Displays relevant information of the selected database object.



User privileges within the database server are directly reflected in the Database Explorer. Schema with full access will be able to view all database objects within the catalog. Otherwise, those granted to the schema will be viewable.


Opening Database Explorer

To open the Database Explorer window

  1. Click image\B_DatabaseExplorer.gif.


Sort Criteria

The current schema is presented as the first item of the Database Objects tree followed by the remaining names in alphabetical order.


Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating