Candle Lite Db2 Users Manual OMEGAMON II For User’s Guide

2015-02-05

• Contents
• List of Figures
• Preface
  • About This Book
    • Who should read this book
    • Documentation set information
    • Where to look for information
  • Adobe Portable Document Format
    • Introduction
    • Printing problems?
  • Documentation Conventions
    • Introduction
    • Panels and figures
    • Required blanks
    • Revision bars
    • Variables and literals in command syntax examples
    • Symbols
  • Candle Customer Service and Satisfaction
    • Background
    • Candle Customer Service and Satisfaction contacts
• What’s New
  • Historical Reporter redesign
  • New IFCID-based reports
  • 64-bit addressing support
  • Long name support
  • Unicode support
  • Enclave support
  • New filtering for Near Term History display
  • New DSNZPARM fields
  • Distributed Thread display improvements
• Getting Started
  • Signing On
    • Logging on to the application
    • Sign On panel
    • Sign On panel fields
    • Accessing OMEGAMON from OMEGAVIEW
  • Setting Logon Options
    • Logon Options panel fields
  • Signing Off
    • Returning to OMEGAVIEW from OMEGAMON
  • Panel Features
    • Panel features
  • Data Panels
    • Description
    • Highlighted data fields
    • Scrolling
    • Pushbuttons
  • Action Bar
    • Selecting from the action bar
    • Fast pathing from the action bar
    • Actions pull-down
    • GoTo pull-down
    • View pull-down
    • Options pull-down
    • Tools pull-down
    • Help pull-down
  • Action Codes
    • Available action codes
    • Using an action code
  • Function Keys
    • Function key assignments
  • Getting Help
    • Help from a panel
    • Help from the action bar
    • Using the Glossary
    • Searching the glossary
    • Help function keys
• Customizing OMEGAMON II
  • Introduction
  • Specifying Panel Preferences
    • Accessing the Preferences window
    • Using the Preferences window
  • Specifying Terminal Options
    • Accessing the Terminal Options window
    • Using the Terminal Options window
    • Saving Terminal Options
    • Saving for current session
    • Saving to a profile
  • Setting Thresholds
    • Accessing the Thresholds window
    • Using the thresholds windows
    • Saving threshold values
    • Saving for current session
    • Saving to a profile
  • Assigning User Authorities
    • Accessing user authorities
    • Adding a user
    • Deleting a user
  • Maintaining Profiles
    • Profile types
    • Accessing profile maintenance
    • Copying a profile
    • Importing a Profile
    • Exporting a Profile
    • Deleting a profile
    • Modifying a profile description
    • Switching profiles
    • Using the Dynamic Profile Update Facility
    • Example command for exporting a profile
    • Example command for importing a profile
  • Setting Filtering Options for Near-Term Thread History
    • Accessing the Filter Options window
    • Using the Filter Options window
  • Specifying Save Options for SQL Text
    • Accessing the Save SQL Text Parameters window
    • Using the Save SQL Text Parameters window
  • Using the Callable Interface
    • Customizing the Classic Started Task to Implement the OMEGAMON II for DB2 Interface
    • Setting Up !DB/EXPLAIN
    • Setting Up the CUA Options
    • Setting Up the D2/EXPLAIN Options
    • EXPLAINing SQL Code
• Using OMEGAMON II
  • Monitoring from the System Status Panel
    • DB2 subsystem components
    • Monitored objects
    • Status indicators
    • Alert notification
    • Investigating an alert
    • Performing actions from the System Status panel
  • System Status Components and Related Exceptions
    • CICS exceptions
    • IMS exceptions
    • TSO exceptions
    • Background exceptions
    • Utility exceptions
    • Distributed exceptions
    • Active thread exceptions
    • Inactive thread exceptions
    • Buffer pool exceptions
    • EDM pool exceptions
    • Lock statistics exceptions
    • Log manager exceptions
    • DDF statistics exceptions
    • DB2 activity exceptions
    • Lock exceptions
    • Active trace exceptions
    • Volume activity exceptions
    • Stored procedures exceptions
    • Triggers exceptions
    • User-defined functions exceptions
  • Investigating an Active Threads Alert
    • Active threads alert
    • Exception recommendations
    • Investigating the exception condition
  • Evaluating and Modifying Thresholds
    • Displaying all exceptions
    • Modifying thresholds
    • Adding or modifying rules
  • Reviewing Near-Term History Data
    • Accessing near-term history data
    • Thread activity for a reporting period
    • Thread activity for a report interval
  • Using the OMEGAMON II for DB2 Background Application Trace Facility
    • Initiating a background application trace
    • Specifying background application trace options
    • Identifying the dataset to which trace data is written
    • Viewing the list of background traces
    • Activities you can perform in a background trace request
  • Using the IFCID Trace Facility
    • Overview
    • Starting an IFCID Trace
    • Displaying IFCID Trace Data
    • Stopping an IFCID Trace
• Using OMEGAMON II for DB2 with !DB/EXPLAIN
  • Background about !DB/EXPLAIN for DB2
    • Functions provided by !DB/EXPLAIN for DB2
  • Using OMEGAMON II and !DB/EXPLAIN Complementary Functions
    • Assumptions
    • When to use the complementary functions
  • Using the OMEGAMON II for DB2 Callable Interface
    • Customizing the Classic started task to implement the OMEGAMON II for DB2 interface
    • Setting Up !DB/EXPLAIN
    • Setting Up the CUA Options
    • Using the Terminal Options Window
    • Setting Up the D2/EXPLAIN Options
    • Using the D2/EXPLAIN Options Panel
    • EXPLAINing SQL Code
  • Moving Interactively between !DB/EXPLAIN and OMEGAMON II
    • What functions can you use?
    • Modes of operation
    • Prerequisites for real time access
    • Procedure to use the full function of !DB/EXPLAIN
    • What happens when you cancel the OMEGAMON II session?
  • Using the Copy-and-Paste Facility in OMEGAMON II
    • Prerequisites to using the copy-and-paste facility
    • Capturing SQL from a running thread
    • Capturing SQL using the ATF
  • Accessing OMEGAMON II Trace Information from !DB/EXPLAIN
    • Direction of access
    • Prerequisites for using the OMEGAMON II trace information
    • Procedure to obtain current trace information
    • Procedure
    • Sources of information
• Panel Navigation Flowcharts
  • Flowchart Conventions
  • Workloads Panels
  • Resources Panels
  • Alerts Panels
  • Installation Parameters Panels
  • Application Trace Facility Panels
  • Object Analysis Panels
  • Thread Detail GoTo Panels
• Index