Candle-lite DB2 User Manual

User’s Guide: CUA InterfaceOMEGAMON II ® for DB2Version 540G251246500August 2004Candle Corporation100 North Sepulveda Blvd.

Documentation Conventions10 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540Documentation ConventionsIntroductionCandle documentation adhe

Using the OMEGAMON II for DB2 Callable Interface100 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540EXPLAINing SQL CodeUse the following p

Using OMEGAMON II for DB2 with !DB/EXPLAIN 101Using the OMEGAMON II for DB2 Callable Interface3 Select the PLANNAME you want and press Enter.Result: T

Moving Interactively between !DB/EXPLAIN and OMEGAMON II102 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540Moving Interactively between !

Using OMEGAMON II for DB2 with !DB/EXPLAIN 103Moving Interactively between !DB/EXPLAIN and OMEGAMON II– To use the A (Application Trace Facility) Sele

Using the Copy-and-Paste Facility in OMEGAMON II104 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540Using the Copy-and-Paste Facility in O

Using OMEGAMON II for DB2 with !DB/EXPLAIN 105Using the Copy-and-Paste Facility in OMEGAMON IICapturing SQL using the ATFYou can use the OMEGAMON II A

Accessing OMEGAMON II Trace Information from !DB/EXPLAIN106 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540Accessing OMEGAMON II Trace In

Using OMEGAMON II for DB2 with !DB/EXPLAIN 107Accessing OMEGAMON II Trace Information from !DB/EXPLAINSources of informationRefer to the table for sou

Accessing OMEGAMON II Trace Information from !DB/EXPLAIN108 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540

109Panel Navigation FlowchartsIntroductionThe flowcharts in this appendix document the panels available for monitoring DB2. They provide an overview o

11Documentation Conventions[ ] Denotes optional arguments. Those arguments not enclosed in square brackets are required. Example:APPLDEST DEST [ALTDES

Flowchart Conventions110 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540Flowchart ConventionsThe following table describes elements in th

111Flowchart ConventionsFIGURE 1. OMEGAMON II for DB2 System Status PanelTo find out how to navigate to a particular panel or group of panels, start w

Workloads Panels112 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540Workloads PanelsThe next two figures show how you can access the realt

113Workloads PanelsFIGURE 2. Workloads Panels (Realtime)System Status__CICS__IMS__TSO__Background__Utilities__Distributed__Stored Procs__All Connectio

Workloads Panels114 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540FIGURE 3. Workloads Panels (Near-term history)System Status__CICS__IMS

115Resources PanelsResources PanelsThe next two figures show how you can access the realtime and near-term history panels for objects from the Resourc

Resources Panels116 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540FIGURE 4. Resources Panels (Realtime)System Status__Buffer Mgr__EDM Po

117Resources PanelsFIGURE 5. Resources Panels (Near-Term History)Buffer Pool Statistics Summary by Report EDM Pool Statistics by Report Lock Manager S

Alerts Panels118 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540Alerts PanelsYou can access the following panels by selecting a monitored

119Alerts PanelsFIGURE 6. Alerts PanelsSystem Status__DB2 Activity__Active Threads__Inactive Threads__Locks__Active Traces__Volume Activity__DB2 Messa

Candle Customer Service and Satisfaction12 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540Candle Customer Service and SatisfactionBackgro

Installation Parameters Panels120 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540Installation Parameters PanelsYou can access the followi

121Installation Parameters PanelsFIGURE 7. Installation Parameters PanelsSystem Status1. DSNZPARM Thread Parms2. DSNZPARM Trace Parms3. DSNZPARM Archi

Application Trace Facility Panels122 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540Application Trace Facility PanelsYou can access the f

123Application Trace Facility PanelsFIGURE 8. Application Trace Facility PanelsSystem Status1. Specify foreground trace collection options.2. Stop for

Object Analysis Panels124 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540Object Analysis PanelsYou can access the following panels by sel

125Object Analysis PanelsFIGURE 9. Object Analysis PanelsSystem Status1. Object Allocation Summary2. Object Activity Summary3. Volume Activity Summary

Thread Detail GoTo Panels126 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540Thread Detail GoTo PanelsYou can access the following realtim

127Thread Detail GoTo PanelsFIGURE 10. Thread Detail GoTo Panels (Realtime)1.Thread Lock Information2.Current SQL Counts3.SQL Call Being Executed4.Thr

Thread Detail GoTo Panels128 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540FIGURE 11. Thread History Detail GoTo Panels (Near-Term Histo

129Symbols!DB/EXPLAINsetting up CUA options 95setup CUA options 96setup for OMEGAMON II 95SQL process level 97Terminal Options pop-up 97!DB/EXPLAIN an

13

130 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540documentation conventions 10dynamic profile update facility 52EEDM pool exceptions 73e

131moving between !DB/EXPLAIN and OMEGAMON II 102Nnational language 41navigationfast pathing 29flow charts 109near-term history panels 115, 117Normal

132 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540colors 67definition 67specifying 43status wordsspecifying 43stopping IFCID trace facil

14 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540

15What’s NewThis section identifies the enhancements for Version 540 of OMEGAMON II for DB2. OMEGAMON II® for DB2 is a component of OMEGAMON XE for DB

16 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 54064-bit addressing supportVersion 8 of DB2 UDB for z/OS supports 64-bit virtual storage.

17IGETPAGESILOCK ESCALIPACKAGESee the OMEGAMON II for DB2 Reference Manual, Version 540, for descriptions of these new fields.New DSNZPARM fieldsThe D

18 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540

Getting Started 19Getting StartedIntroductionThis chapter is intended to help you get started using the CUA interface for OMEGAMON II for DB2 to monit

2 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540Registered trademarks and service marks of Candle Corporation: AF/OPERATOR, AF/REMOTE, A

Signing On20 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540Signing OnLogging on to the applicationYou access the CUA interface for OMEGA

Getting Started 21Signing OnSign On panel fieldsThe fields of the Sign On Panel are defined in the table below.Accessing OMEGAMON from OMEGAVIEWTo acc

Setting Logon Options22 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540Setting Logon OptionsThe Logon Options panel enables you to specif

Getting Started 23Setting Logon OptionsApplication ID The OMEGAMON II classic interface VTAM mode application identifier.DB2 subsystem The DB2 subsyst

Signing Off24 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540Signing OffTo sign off OMEGAMON II:1. Press F3 from the System Status panel.

Getting Started 25Panel FeaturesPanel FeaturesIOMEGAMON II panels share a number of common features. In the following section, we use the System Statu

Panel Features26 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 5404Action Codes Displays available action codes.Note: Action codes do not a

Getting Started 27Data PanelsData PanelsDescriptionUnlike the System Status panel, most OMEGAMON II full-screen panels present performance information

Data Panels28 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540PushbuttonsOMEGAMON II provides pushbuttons as a way to navigate to panels t

Getting Started 29Action BarAction BarThe action bar appears as the top line of every panel. It has an entry field on the left side and selectable key

3List of Figures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .5Preface .

Action Bar30 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540bypasses the GoTo menu and the DB2 Installation Parameters menu, and goes dir

Getting Started 31Action BarGoTo pull-downThe GoTo menu enables you to quickly move to panels that are related to the current panel, as well as to oth

Action Bar32 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540Options pull-downThe Options pull-down menu enables you to customize OMEGAMON

Getting Started 33Action CodesAction CodesAction codes let you easily analyze the performance of your DB2 subsystem by allowing you to get more inform

Function Keys34 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540Function KeysFunction keys enable you to perform certain tasks in OMEGAMON

Getting Started 35Function KeysNote: F5, F9, and F11 are assigned differently on Help panels. See “Help function keys” on page 38 for a description of

Getting Help36 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540Getting HelpHelp from a panelPanel help is available for all panels. To obt

Getting Started 37Getting HelpUsing the GlossaryThe glossary contains definitions of terms used in OMEGAMON II. The glossary is available from any hel

Getting Help38 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540Help function keysThe following table describes how function keys work with

Customizing OMEGAMON II 39Customizing OMEGAMON IIChapter Contents Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

4 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540Chapter 4. Using OMEGAMON II for DB2 with !DB/EXPLAIN . . . . . . . . . . . . . . . . .

Introduction40 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540Introduction You can adjust many features of the OMEGAMON environment to me

Customizing OMEGAMON II 41Specifying Panel PreferencesSpecifying Panel PreferencesUse the Preferences pop-up window to customize the appearance of inf

Specifying Panel Preferences42 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540Function Key AreaDisplays a list of the currently available

Customizing OMEGAMON II 43Specifying Terminal OptionsSpecifying Terminal OptionsUse the Terminal Options pop-up window to customize settings for the C

Specifying Terminal Options44 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540The following table provides a list of fields and valid valu

Customizing OMEGAMON II 45Specifying Terminal OptionsSaving Terminal OptionsWhen you finish entering your terminal preferences:IPress Enter.Result: Th

Setting Thresholds46 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540Setting ThresholdsUse the Set Thresholds option window to set perform

Customizing OMEGAMON II 47Setting ThresholdsSaving threshold valuesWhen you finish entering your threshold values:IPress Enter.Result: The Save Profil

Assigning User Authorities48 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540Assigning User AuthoritiesThe system administrator at your si

Customizing OMEGAMON II 49Maintaining ProfilesMaintaining ProfilesOMEGAMON II allows you to switch, copy, delete, and modify user profiles and subsyst

5FIGURE 1. OMEGAMON II for DB2 System Status Panel . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .111FIGURE 2. Workloads Panels (Realtim

Maintaining Profiles50 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540To access the Subsystem Profile Maintenance panel:ISelect Subsystem

Customizing OMEGAMON II 51Maintaining ProfilesImporting a ProfileYou can import a profile by copying the partitioned dataset member into the profile.

Maintaining Profiles52 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540To modify a profile description:1. Type M next to the profile whose

Customizing OMEGAMON II 53Maintaining ProfilesIUse importing to reverse the above process to recreate a profile based on the exported information.Exam

Setting Filtering Options for Near-Term Thread History54 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540Setting Filtering Options for Nea

Customizing OMEGAMON II 55Setting Filtering Options for Near-Term Thread HistoryRelative-Start The number of minutes or hours before the current time

Specifying Save Options for SQL Text56 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540Specifying Save Options for SQL TextUse the Save SQ

Customizing OMEGAMON II 57Using the Callable InterfaceUsing the Callable InterfaceThe callable interface feature of OMEGAMON II for DB2, Version 500,

Using the Callable Interface58 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540Setting Up !DB/EXPLAINUse the following procedure to set up

Customizing OMEGAMON II 59Using the Callable InterfaceSetting Up the D2/EXPLAIN OptionsUse the following procedure to set up the D2/EXPLAIN options.2

6 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540

Using the Callable Interface60 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540The following table provides a list of fields and valid val

Customizing OMEGAMON II 61Using the Callable InterfaceEXPLAINing SQL CodeUse the following procedure to EXPLAIN SQL.Type of Save Type of save to be ex

Using the Callable Interface62 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 5402 From the main CUA panel, select Active Threads and press

Customizing OMEGAMON II 63Using the Callable Interface5 Press the Process SQL key.Step Action GoTo Options Tools Help+-----------------------

Using the Callable Interface64 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540

Using OMEGAMON II 65Using OMEGAMON IIIntroduction This chapter describes how to use OMEGAMON II.Chapter ContentsMonitoring from the System Status Pane

Monitoring from the System Status Panel66 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540Monitoring from the System Status PanelThe Syste

Using OMEGAMON II 67Monitoring from the System Status PanelStatus indicatorsA status indicator is a color bar or a word (for example, Warn) that repre

Monitoring from the System Status Panel68 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540Performing actions from the System Status panelY

Using OMEGAMON II 69System Status Components and Related ExceptionsSystem Status Components and Related ExceptionsOMEGAMON II monitors your DB2 subsys

7PrefaceThis guide is an introduction to the CUA™ interface for OMEGAMON II® for DB2®, Version 540. The CUA interface is based on IBM's Common Us

System Status Components and Related Exceptions70 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540IMS exceptionsThe following exceptions a

Using OMEGAMON II 71System Status Components and Related ExceptionsActive thread exceptionsThe following exceptions apply to active threads.DDF bytes

System Status Components and Related Exceptions72 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540Inactive thread exceptionsThe following

Using OMEGAMON II 73System Status Components and Related ExceptionsEDM pool exceptionsThe following exceptions apply to EDM pool resources.Lock statis

System Status Components and Related Exceptions74 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540DB2 activity exceptionsThe following exc

Using OMEGAMON II 75System Status Components and Related ExceptionsActive trace exceptionsThe following exceptions apply to active trace alerts.Volume

System Status Components and Related Exceptions76 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540Triggers exceptionsThe following excepti

Using OMEGAMON II 77Investigating an Active Threads AlertInvestigating an Active Threads AlertIntroductionThis is an example of how you might investig

Evaluating and Modifying Thresholds78 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540Evaluating and Modifying ThresholdsWhen you investig

Using OMEGAMON II 79Evaluating and Modifying ThresholdsAdding or modifying rulesYou can specify rules for an exception condition to control how the th

About This Book8 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540About This BookWho should read this bookThis manual is intended for data

Reviewing Near-Term History Data80 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540Reviewing Near-Term History DataNear-term history panel

Using OMEGAMON II 81Reviewing Near-Term History DataThread activity for a report intervalYou also can view summarized information about thread activit

Using the OMEGAMON II for DB2 Background Application Trace Facility82 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540Using the OMEGAMON I

Using OMEGAMON II 83Using the OMEGAMON II for DB2 Background Application Trace FacilityIf you do not enter a start time for the background trace, OMEG

Using the OMEGAMON II for DB2 Background Application Trace Facility84 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540Activities you can p

Using OMEGAMON II 85Using the IFCID Trace FacilityUsing the IFCID Trace FacilityOverviewThe IFCID Trace facility provides the ability to start an IFCI

Using the IFCID Trace Facility86 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540At the point when you enter option S to select the IFCIDs

Using OMEGAMON II 87Using the IFCID Trace FacilityStopping an IFCID TraceTo stop the IFCID Trace facility, follow these steps: Ienter option T (Tools)

Using the IFCID Trace Facility88 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540

Using OMEGAMON II for DB2 with !DB/EXPLAIN 89Using OMEGAMON II for DB2 with !DB/EXPLAINIntroductionBy integrating the two Candle products, OMEGAMON II

9Adobe Portable Document FormatAdobe Portable Document FormatIntroductionCandle supplies documentation in the Adobe Portable Document Format (PDF). Th

Background about !DB/EXPLAIN for DB290 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540Background about !DB/EXPLAIN for DB2This section pr

Using OMEGAMON II for DB2 with !DB/EXPLAIN 91Using OMEGAMON II and !DB/EXPLAIN Complementary FunctionsUsing OMEGAMON II and !DB/EXPLAIN Complementary

Using OMEGAMON II and !DB/EXPLAIN Complementary Functions92 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540IIn a review of an application

Using OMEGAMON II for DB2 with !DB/EXPLAIN 93Using the OMEGAMON II for DB2 Callable InterfaceUsing the OMEGAMON II for DB2 Callable InterfaceThe calla

Using the OMEGAMON II for DB2 Callable Interface94 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 5402 Press Enter.Result: The system displa

Using OMEGAMON II for DB2 with !DB/EXPLAIN 95Using the OMEGAMON II for DB2 Callable InterfaceSetting Up !DB/EXPLAINUse the following procedure to set

Using the OMEGAMON II for DB2 Callable Interface96 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540Using the Terminal Options WindowThe fo

Using OMEGAMON II for DB2 with !DB/EXPLAIN 97Using the OMEGAMON II for DB2 Callable InterfaceValues for the SQL Process Level are described in the fol

Using the OMEGAMON II for DB2 Callable Interface98 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540Setting Up the D2/EXPLAIN OptionsUse th

Using OMEGAMON II for DB2 with !DB/EXPLAIN 99Using the OMEGAMON II for DB2 Callable InterfaceUsing the D2/EXPLAIN Options PanelThe following table pro