EZDBA-Applications Menu
The EZDBA menu is one of the primary menus. It is designed for application analysis for one or multiple Db2s.
The left column is for working with a single Db2. The right column is for working with multiple Db2s. From either column, you can set a target or SSI context. The middle column provides access to other important functions that work for either one or multiple Db2s.
DB2 DBA Easy Menu
Analyze One DB2 Analyze Multiple DB2s
. Set Context to DB2 +----------------------+ . Set SSI Context
> DB2 Easy Menu (EZDB2) | Place cursor on | > SSI Easy Menu (EZDSSI)
Current Status | menu item and | Current Status
. DB2 Status Detail | press ENTER | . DB2 Status List
. DB2 Storage - Detail +----------------------+ . DB2 Health Overview
. Buffer Pool / Pool . DB2 Storage / DB2
. EDM Pool Analyze One or More DB2s . IRLM Stor Use (V11+)
. Dynamic SQL Cache . Exceptions . Buffer Pool Totals/DB2
> Static SQL Cache . Monitors: Active/Admin . EDM Pool Wizard
. Journal (Messages) > Page Set Menu . Data Sharing Wizard
> ZPARM Menu . DB2 Dashboard
Traces Current Thread Activity > DDF Menu
. Thread History / Query . Active Threads Tools and Menus
. Traces - Current / ST > Thread Menu > DB2 Topic Index
. Traces - DB2 IFCID . Suspended Threads/Lock > MAIN Menu
. Traces - History Admin > Locking Menu . BBI-SS PAS Info
> Event Traces . Summary by Accelerator . BBI-SS Parm Info
Catalog / Explain Workload Analysis
. CATALOG MANAGER Local . Workload Objectives . What's New
. CATALOG MANAGER-Remote . Lockout Events (SSI) . Return...
. MVDB2/DC Admin/Explain . Lockout Events (DB2) . QUIT (Unstack)
> FullScreen Menu . Lock Contention Wizard
Analyze One DB2 Analyze Multiple DB2s
. Set Context to DB2 +----------------------+ . Set SSI Context
> DB2 Easy Menu (EZDB2) | Place cursor on | > SSI Easy Menu (EZDSSI)
Current Status | menu item and | Current Status
. DB2 Status Detail | press ENTER | . DB2 Status List
. DB2 Storage - Detail +----------------------+ . DB2 Health Overview
. Buffer Pool / Pool . DB2 Storage / DB2
. EDM Pool Analyze One or More DB2s . IRLM Stor Use (V11+)
. Dynamic SQL Cache . Exceptions . Buffer Pool Totals/DB2
> Static SQL Cache . Monitors: Active/Admin . EDM Pool Wizard
. Journal (Messages) > Page Set Menu . Data Sharing Wizard
> ZPARM Menu . DB2 Dashboard
Traces Current Thread Activity > DDF Menu
. Thread History / Query . Active Threads Tools and Menus
. Traces - Current / ST > Thread Menu > DB2 Topic Index
. Traces - DB2 IFCID . Suspended Threads/Lock > MAIN Menu
. Traces - History Admin > Locking Menu . BBI-SS PAS Info
> Event Traces . Summary by Accelerator . BBI-SS Parm Info
Catalog / Explain Workload Analysis
. CATALOG MANAGER Local . Workload Objectives . What's New
. CATALOG MANAGER-Remote . Lockout Events (SSI) . Return...
. MVDB2/DC Admin/Explain . Lockout Events (DB2) . QUIT (Unstack)
> FullScreen Menu . Lock Contention Wizard
You can access EZDBA from EZDB2 or EZDSSI, or by entering EZDBA on the COMMAND line. To display EZDBA as your default initial view, specify the MVDB2DBA screen definition as the initial screen on the Parameter Confirmation panel when you enter windows mode. MVDB2DBA displays EZDBA instead of EZDSSI as the initial screen.
Related topic
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*