Manuals
/
Candle-lite
/
Computer Equipment
/
Network Card
Candle-lite
manual
Omegamon II for DB2 User’s Guide CUA Interface, Version
Models:
DB2
1
18
132
132
Download
132 pages
16.76 Kb
15
16
17
18
19
20
21
22
<
>
Install
Flowchart Conventions
D61A$DEFAULT
Status indicators
Maintenance
Printing problems?
Accessing user authorities
Setting Up !DB/EXPLAIN
Stored procedures exceptions
Setting Logon Options
Page 18
Image 18
18 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540
Page 17
Page 19
Page 18
Image 18
Page 17
Page 19
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
Printing problems?
Adobe Portable Document Format
Introduction
Documentation Conventions
REPORT=SUMMARY Histogram
Candle Customer Service and Satisfaction
Candle Customer Service and Satisfaction contacts
Background
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
Panel Features
Panel features
Part Feature Description
Part Feature Description
Highlighted data fields
Data Panels
Description
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
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
Using the Glossary
Searching the glossary
If you are
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
Accessing the Terminal Options window
Using the Terminal Options window
Specifying Terminal Options
Auto
Values for SQL Description Process Level
Manual
Save
Saving Terminal Options
Saving for current session
Saving to a profile
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
Accessing the Save SQL Text Parameters window
Using the Save SQL Text Parameters window
Specifying Save Options for SQL Text
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
Use the following procedure to Explain SQL
EXPLAINing SQL Code
Append
CPU %
Press the Process SQL key
Page
Using Omegamon
This chapter describes how to use Omegamon
Monitoring from the System Status Panel
DB2 subsystem components
Monitored objects
Investigating an alert
Status indicators
Alert notification
Color Status
Performing actions from the System Status panel
System Status Components and Related Exceptions
Cics exceptions
Description Code Explanation
Background exceptions
IMS exceptions
TSO exceptions
Utility exceptions
Active thread exceptions
Following exceptions apply to active threads
Inactive thread exceptions
Buffer pool exceptions
Following exceptions apply to buffer pool resources
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
Volume activity exceptions
Stored procedures exceptions
Active trace 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
Evaluating and Modifying Thresholds
Displaying all exceptions
Modifying thresholds
Adding or modifying rules
Accessing near-term history data
Reviewing Near-Term History Data
Thread activity for a reporting period
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
Using the Ifcid Trace Facility
Overview
Starting an Ifcid Trace
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
Using Omegamon II and !DB/EXPLAIN Complementary Functions
When to use the complementary functions
Assumptions
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
Moving Interactively between !DB/EXPLAIN and Omegamon
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
Prerequisites to using the copy-and-paste facility
Capturing SQL from a running thread
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
Flowchart Conventions
System Status panel
Element Description
System Status
DB2
Workloads Panels
Cics
IMS
TSO
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
Top
Page
Image
Contents