User ManualTable of ContentsContents3List of Figures5Preface7About This Book8Who should read this book8Documentation set information8Where to look for information8Adobe Portable Document Format9Introduction9Printing problems?9Documentation Conventions10Introduction10Panels and figures10Required blanks10Revision bars10Variables and literals in command syntax examples10Symbols10Candle Customer Service and Satisfaction12Background12Candle Customer Service and Satisfaction contacts12What’s New15Historical Reporter redesign15New IFCID-based reports1564-bit addressing support16Long name support16Unicode support16Enclave support16New filtering for Near Term History display16New DSNZPARM fields17Distributed Thread display improvements17Getting Started19Signing On20Logging on to the application20Sign On panel20Sign On panel fields21Accessing OMEGAMON from OMEGAVIEW21Setting Logon Options22Logon Options panel fields22Signing Off24Returning to OMEGAVIEW from OMEGAMON24Panel Features25Panel features25Data Panels27Description27Highlighted data fields27Scrolling27Pushbuttons28Action Bar29Selecting from the action bar29Fast pathing from the action bar29Actions pull-down30GoTo pull-down31View pull-down31Options pull-down32Tools pull-down32Help pull-down32Action Codes33Available action codes33Using an action code33Function Keys34Function key assignments34Getting Help36Help from a panel36Help from the action bar36Using the Glossary37Searching the glossary37Help function keys38Customizing OMEGAMON II39Introduction40Specifying Panel Preferences41Accessing the Preferences window41Using the Preferences window41Specifying Terminal Options43Accessing the Terminal Options window43Using the Terminal Options window43Saving Terminal Options45Saving for current session45Saving to a profile45Setting Thresholds46Accessing the Thresholds window46Using the thresholds windows46Saving threshold values47Saving for current session47Saving to a profile47Assigning User Authorities48Accessing user authorities48Adding a user48Deleting a user48Maintaining Profiles49Profile types49Accessing profile maintenance49Copying a profile50Importing a Profile51Exporting a Profile51Deleting a profile51Modifying a profile description51Switching profiles52Using the Dynamic Profile Update Facility52Example command for exporting a profile53Example command for importing a profile53Setting Filtering Options for Near-Term Thread History54Accessing the Filter Options window54Using the Filter Options window54Specifying Save Options for SQL Text56Accessing the Save SQL Text Parameters window56Using the Save SQL Text Parameters window56Using the Callable Interface57Customizing the Classic Started Task to Implement the OMEGAMON II for DB2 Interface57Setting Up !DB/EXPLAIN58Setting Up the CUA Options58Setting Up the D2/EXPLAIN Options59EXPLAINing SQL Code61Using OMEGAMON II65Monitoring from the System Status Panel66DB2 subsystem components66Monitored objects66Status indicators67Alert notification67Investigating an alert67Performing actions from the System Status panel68System Status Components and Related Exceptions69CICS exceptions69IMS exceptions70TSO exceptions70Background exceptions70Utility exceptions70Distributed exceptions70Active thread exceptions71Inactive thread exceptions72Buffer pool exceptions72EDM pool exceptions73Lock statistics exceptions73Log manager exceptions73DDF statistics exceptions73DB2 activity exceptions74Lock exceptions74Active trace exceptions75Volume activity exceptions75Stored procedures exceptions75Triggers exceptions76User-defined functions exceptions76Investigating an Active Threads Alert77Active threads alert77Exception recommendations77Investigating the exception condition77Evaluating and Modifying Thresholds78Displaying all exceptions78Modifying thresholds78Adding or modifying rules79Reviewing Near-Term History Data80Accessing near-term history data80Thread activity for a reporting period80Thread activity for a report interval81Using the OMEGAMON II for DB2 Background Application Trace Facility82Initiating a background application trace82Specifying background application trace options82Identifying the dataset to which trace data is written83Viewing the list of background traces83Activities you can perform in a background trace request84Using the IFCID Trace Facility85Overview85Starting an IFCID Trace85Displaying IFCID Trace Data86Stopping an IFCID Trace87Using OMEGAMON II for DB2 with !DB/EXPLAIN89Background about !DB/EXPLAIN for DB290Functions provided by !DB/EXPLAIN for DB290Using OMEGAMON II and !DB/EXPLAIN Complementary Functions91Assumptions91When to use the complementary functions91Using the OMEGAMON II for DB2 Callable Interface93Customizing the Classic started task to implement the OMEGAMON II for DB2 interface93Setting Up !DB/EXPLAIN95Setting Up the CUA Options95Using the Terminal Options Window96Setting Up the D2/EXPLAIN Options98Using the D2/EXPLAIN Options Panel99EXPLAINing SQL Code100Moving Interactively between !DB/EXPLAIN and OMEGAMON II102What functions can you use?102Modes of operation102Prerequisites for real time access103Procedure to use the full function of !DB/EXPLAIN103What happens when you cancel the OMEGAMON II session?103Using the Copy-and-Paste Facility in OMEGAMON II104Prerequisites to using the copy-and-paste facility104Capturing SQL from a running thread104Capturing SQL using the ATF105Accessing OMEGAMON II Trace Information from !DB/EXPLAIN106Direction of access106Prerequisites for using the OMEGAMON II trace information106Procedure to obtain current trace information106Procedure106Sources of information107Panel Navigation Flowcharts109Flowchart Conventions110Workloads Panels112Resources Panels115Alerts Panels118Installation Parameters Panels120Application Trace Facility Panels122Object Analysis Panels124Thread Detail GoTo Panels126Index129Size: 1.02 MBPages: 132Language: EnglishOpen manual