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
Kommentare zu diesen Handbüchern