Manuals
/
Candle-lite
/
Computer Equipment
/
Network Card
Candle-lite
DB2
manual
Models:
DB2
1
88
132
132
Download
132 pages
16.76 Kb
85
86
87
88
89
90
91
92
<
>
Install
Flowchart Conventions
D61A$DEFAULT
Status indicators
Maintenance
Printing problems?
Accessing user authorities
Setting Up !DB/EXPLAIN
Stored procedures exceptions
Setting Logon Options
Page 88
Image 88
Using the IFCID Trace Facility
88 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540
Page 87
Page 89
Page 88
Image 88
Page 87
Page 89
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
Where to look for information
About This Book
Who should read this book
Documentation set information
Adobe Portable Document Format
Printing problems?
Introduction
Documentation Conventions
REPORT=SUMMARY Histogram
Candle Customer Service and Satisfaction contacts
Candle Customer Service and Satisfaction
Background
Page
Omegamon II for DB2 User’s Guide CUA Interface, Version
Historical Reporter redesign
New IFCID-based reports
Bit addressing support
Long name support
Unicode support
Enclave support
New Dsnzparm fields
Distributed Thread display improvements
Omegamon II for DB2 User’s Guide CUA Interface, Version
Chapter Contents
Introduction
Where applid is the application name
Signing On
Logging on to the application
Sign On panel
Accessing Omegamon from Omegaview
Sign On panel fields
Fields of the Sign On Panel are defined in the table below
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
Data Panels
Description
Highlighted data fields
Scrolling
Pushbuttons
Selecting from the action bar
Action Bar
Fast pathing from the action bar
Actions pull-down
GoTo pull-down
View pull-down
Tools pull-down
Options pull-down
Help pull-down
Using an action code
Action Codes
Available action codes
You can use these action codes in Omegamon
Default function key assignments are listed below
Function Keys
Function key assignments
Function Name Assignment Key
CUA/TSO
PA1
Omegaview
PA2 Omegaview
Getting Help
Help from a panel
Help from the action bar
Help menu provides the following selections
Searching the glossary
Using the Glossary
If you are
Help function keys
Customizing Omegamon
Introduction
Accessing the Preferences window
Using the Preferences window
To access the Preferences pop-up window
Specifying Panel Preferences
Action to occur
Using the Terminal Options window
Accessing the Terminal Options window
Specifying Terminal Options
Values for SQL Description Process Level
Manual
Auto
Save
Saving for current session
Saving Terminal Options
Saving to a profile
Setting Thresholds
Accessing the Thresholds window
Using the thresholds windows
Follow these steps to change threshold values
Saving threshold values
Accessing user authorities
Assigning User Authorities
Adding a user
Deleting a user
Accessing profile maintenance
Maintaining Profiles
Profile types
Omegamon II uses three different profiles
D61A$DEFAULT
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
MVS Modify command for exporting a profile is as follows
MVS Modify command for importing a profile is as follows
Setting Filtering Options for Near-Term Thread History
Accessing the Filter Options window
Using the Filter Options window
To access the Filter Options pop-up window
Time
Using the Save SQL Text Parameters window
Accessing 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
Setting Up !DB/EXPLAIN
Setting Up the CUA Options
SQLID.PLANTABLE
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
EXPLAINing SQL Code
Use the following procedure to Explain SQL
Append
CPU %
Press the Process SQL key
Page
Using Omegamon
This chapter describes how to use Omegamon
DB2 subsystem components
Monitoring from the System Status Panel
Monitored objects
Status indicators
Alert notification
Investigating an alert
Color Status
Performing actions from the System Status panel
Cics exceptions
System Status Components and Related Exceptions
Description Code Explanation
IMS exceptions
TSO exceptions
Background exceptions
Utility exceptions
Active thread exceptions
Following exceptions apply to active threads
Buffer pool exceptions
Inactive thread exceptions
Following exceptions apply to buffer pool resources
EDM pool exceptions
Lock statistics exceptions
Log manager exceptions
DDF statistics exceptions
DB2 activity exceptions
Lock exceptions
Following exceptions apply to DB2 activity alerts
Following exceptions apply to lock alerts
Stored procedures exceptions
Volume activity exceptions
Active trace exceptions
Triggers exceptions
User-defined functions exceptions
Following exceptions apply to alerts relating to triggers
Following exceptions apply to user-defined functions
Investigating an Active Threads Alert
Active threads alert
Exception recommendations
Investigating the exception condition
Displaying all exceptions
Evaluating and Modifying Thresholds
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
Initiating a background application trace
Specifying background application trace options
Size Size of the dataset in megabytes Volume
Identifying the dataset to which trace data is written
Viewing the list of background traces
Name of the dataset you want to create
Activities you can perform in a background trace request
Overview
Using the Ifcid Trace Facility
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
When to use the complementary functions
Using Omegamon II and !DB/EXPLAIN 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
What functions can you use?
Moving Interactively between !DB/EXPLAIN and Omegamon
Modes of operation
Procedure to use the full function of !DB/EXPLAIN
Prerequisites for real time access
What happens when you cancel the Omegamon II session?
Prerequisites to using the copy-and-paste facility
Using the Copy-and-Paste Facility in Omegamon
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
Sources of information
Task You Want to Perform Source of Information
Page
Panel Navigation Flowcharts
Appendix Contents
System Status panel
Flowchart Conventions
Element Description
System Status
DB2
Workloads Panels
IMS
Cics
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