Manuals
/
Candle-lite
/
Computer Equipment
/
Network Card
Candle-lite
manual Omegamon II for DB2 User’s Guide CUA Interface, Version
Models:
DB2
1
14
132
132
Download
132 pages
16.76 Kb
11
12
13
14
15
16
17
18
<
>
Install
Flowchart Conventions
Maintenance
Printing problems?
Setting Up !DB/EXPLAIN
Stored procedures exceptions
D61A$DEFAULT
Setting Logon Options
Status indicators
How to
Page 14
Image 14
14 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540
Page 13
Page 15
Page 14
Image 14
Page 13
Page 15
Contents
User’s Guide CUA Interface
Omegamon II for DB2 User’s Guide CUA Interface, Version
Contents
Index 129
List of Figures
Omegamon II for DB2 User’s Guide CUA Interface, Version
Preface
Who should read this book
Where to look for information
About This Book
Documentation set information
Introduction
Printing problems?
Adobe Portable Document Format
Documentation Conventions
REPORT=SUMMARY Histogram
Background
Candle Customer Service and Satisfaction
Candle Customer Service and Satisfaction contacts
Page
Omegamon II for DB2 User’s Guide CUA Interface, Version
Historical Reporter redesign
New IFCID-based reports
Unicode support
Bit addressing support
Long name support
Enclave support
New Dsnzparm fields
Distributed Thread display improvements
Omegamon II for DB2 User’s Guide CUA Interface, Version
Chapter Contents
Introduction
Logging on to the application
Where applid is the application name
Signing On
Sign On panel
Fields of the Sign On Panel are defined in the table below
Accessing Omegamon from Omegaview
Sign On panel fields
Field Description
Setting Logon Options
Logon Options panel fields
Logical rows Number of logical rows
Signing Off
Returning to Omegaview from Omegamon
Part Feature Description
Panel Features
Panel features
Part Feature Description
Highlighted data fields
Data Panels
Description
Scrolling
Pushbuttons
Fast pathing from the action bar
Action Bar
Selecting from the action bar
Actions pull-down
GoTo pull-down
View pull-down
Help pull-down
Options pull-down
Tools pull-down
Available action codes
Using an action code
Action Codes
You can use these action codes in Omegamon
Function key assignments
Default function key assignments are listed below
Function Keys
Function Name Assignment Key
Omegaview
CUA/TSO
PA1
PA2 Omegaview
Help from the action bar
Getting Help
Help from a panel
Help menu provides the following selections
If you are
Using the Glossary
Searching the glossary
Help function keys
Customizing Omegamon
Introduction
To access the Preferences pop-up window
Accessing the Preferences window
Using the Preferences window
Specifying Panel Preferences
Action to occur
Specifying Terminal Options
Accessing the Terminal Options window
Using the Terminal Options window
Auto
Values for SQL Description Process Level
Manual
Save
Saving to a profile
Saving Terminal Options
Saving for current session
Using the thresholds windows
Setting Thresholds
Accessing the Thresholds window
Follow these steps to change threshold values
Saving threshold values
Adding a user
Accessing user authorities
Assigning User Authorities
Deleting a user
Profile types
Accessing profile maintenance
Maintaining Profiles
Omegamon II uses three different profiles
D61A$DEFAULT
Copying a profile
Deleting a profile
Importing a Profile
Exporting a Profile
Modifying a profile description
Switching profiles
Using the Dynamic Profile Update Facility
MVS Modify command for exporting a profile is as follows
Example command for exporting a profile
Example command for importing a profile
MVS Modify command for importing a profile is as follows
Using the Filter Options window
Setting Filtering Options for Near-Term Thread History
Accessing the Filter Options window
To access the Filter Options pop-up window
Time
Specifying Save Options for SQL Text
Accessing the Save SQL Text Parameters window
Using the Save SQL Text Parameters window
Using the Callable Interface
Set up the CUA options Set up the !DB/EXPLAIN options
SQLID.PLANTABLE
Setting Up !DB/EXPLAIN
Setting Up the CUA Options
Step Action Log onto CUA
Setting Up the D2/EXPLAIN Options
Use the following procedure to set up the D2/EXPLAIN options
Text and invokes the Explain function
Append
Use the following procedure to Explain SQL
EXPLAINing SQL Code
CPU %
Press the Process SQL key
Page
Using Omegamon
This chapter describes how to use Omegamon
Monitored objects
Monitoring from the System Status Panel
DB2 subsystem components
Investigating an alert
Status indicators
Alert notification
Color Status
Performing actions from the System Status panel
Description Code Explanation
System Status Components and Related Exceptions
Cics exceptions
Background exceptions
IMS exceptions
TSO exceptions
Utility exceptions
Active thread exceptions
Following exceptions apply to active threads
Following exceptions apply to buffer pool resources
Inactive thread exceptions
Buffer pool exceptions
Log manager exceptions
EDM pool exceptions
Lock statistics exceptions
DDF statistics exceptions
Following exceptions apply to DB2 activity alerts
DB2 activity exceptions
Lock exceptions
Following exceptions apply to lock alerts
Active trace exceptions
Volume activity exceptions
Stored procedures exceptions
Following exceptions apply to alerts relating to triggers
Triggers exceptions
User-defined functions exceptions
Following exceptions apply to user-defined functions
Exception recommendations
Investigating an Active Threads Alert
Active threads alert
Investigating the exception condition
Modifying thresholds
Evaluating and Modifying Thresholds
Displaying all exceptions
Adding or modifying rules
Thread activity for a reporting period
Accessing near-term history data
Reviewing Near-Term History Data
Thread activity for a report interval
Initiating a background application trace
Specifying background application trace options
Viewing the list of background traces
Size Size of the dataset in megabytes Volume
Identifying the dataset to which trace data is written
Name of the dataset you want to create
Activities you can perform in a background trace request
Starting an Ifcid Trace
Using the Ifcid Trace Facility
Overview
Displaying Ifcid Trace Data
Stopping an Ifcid Trace
Page
Using Omegamon II for DB2
Background about !DB/EXPLAIN for DB2
Functions provided by !DB/EXPLAIN for DB2
Assumptions
Using Omegamon II and !DB/EXPLAIN Complementary Functions
When to use the complementary functions
Using Omegamon II and !DB/EXPLAIN Complementary Functions
Using the Omegamon II for DB2 Callable Interface
Testc
Current Sqlid is determined by the DB2 security exit
Fields for Terminal Description Options
SQL Text ATF. You can access the SQL Text panel through
SAVE/EXPLAIN
Required fields for the SAVE/EXPLAIN option
Using the D2/EXPLAIN Options Panel
PDS
From the other !DB/EXPLAIN report sections that follow
Press the Process SQL key
Modes of operation
Moving Interactively between !DB/EXPLAIN and Omegamon
What functions can you use?
What happens when you cancel the Omegamon II session?
Prerequisites for real time access
Procedure to use the full function of !DB/EXPLAIN
Capturing SQL from a running thread
Using the Copy-and-Paste Facility in Omegamon
Prerequisites to using the copy-and-paste facility
Capturing SQL using the ATF
Prerequisites for using the Omegamon II trace information
Accessing Omegamon II Trace Information from !DB/EXPLAIN
Direction of access
Procedure to obtain current trace information
Sources of information
Task You Want to Perform Source of Information
Page
Panel Navigation Flowcharts
Appendix Contents
Element Description
Flowchart Conventions
System Status panel
System Status
DB2
Workloads Panels
TSO
Cics
IMS
Workloads Panels Near-term history
Cics IMS TSO
Resources Panels
Resources Panels Realtime
Resources Panels Near-Term History
Alerts Panels
Alerts Panels
Installation Parameters Panels
Installation Parameters Panels
Application Trace Facility Panels
Application Trace Facility Panels
Object Analysis Panels
Object Analysis Panels
Thread Detail GoTo Panels
Thread Detail GoTo Panels Realtime
Thread History Detail GoTo Panels Near-Term History
Index
Omegamon II for DB2 User’s Guide CUA Interface, Version
131
Omegamon II for DB2 User’s Guide CUA Interface, Version