Manuals
/
Candle-lite
/
Computer Equipment
/
Network Card
Candle-lite
DB2
manual
Models:
DB2
1
13
132
132
Download
132 pages
16.76 Kb
10
11
12
13
14
15
16
17
<
>
Install
Flowchart Conventions
D61A$DEFAULT
Status indicators
Maintenance
Printing problems?
Accessing user authorities
Setting Up !DB/EXPLAIN
Stored procedures exceptions
Setting Logon Options
Page 13
Image 13
13
Page 12
Page 14
Page 13
Image 13
Page 12
Page 14
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
About This Book
Where to look for information
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
New IFCID-based reports
Historical Reporter redesign
Long name support
Bit addressing support
Unicode support
Enclave support
Distributed Thread display improvements
New Dsnzparm fields
Omegamon II for DB2 User’s Guide CUA Interface, Version
Introduction
Chapter Contents
Signing On
Where applid is the application name
Logging on to the application
Sign On panel
Sign On panel fields
Accessing Omegamon from Omegaview
Fields of the Sign On Panel are defined in the table below
Field Description
Logon Options panel fields
Setting Logon Options
Logical rows Number of logical rows
Returning to Omegaview from Omegamon
Signing Off
Panel features
Panel Features
Part Feature Description
Part Feature Description
Description
Data Panels
Highlighted data fields
Scrolling
Pushbuttons
Selecting from the action bar
Action Bar
Fast pathing from the action bar
Actions pull-down
View pull-down
GoTo pull-down
Tools pull-down
Options pull-down
Help pull-down
Action Codes
Using an action code
Available action codes
You can use these action codes in Omegamon
Function Keys
Default function key assignments are listed below
Function key assignments
Function Name Assignment Key
PA1
CUA/TSO
Omegaview
PA2 Omegaview
Help from a panel
Getting Help
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
Using the Preferences window
Accessing 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
Manual
Values for SQL Description Process Level
Auto
Save
Saving for current session
Saving Terminal Options
Saving to a profile
Accessing the Thresholds window
Setting Thresholds
Using the thresholds windows
Follow these steps to change threshold values
Saving threshold values
Assigning User Authorities
Accessing user authorities
Adding a user
Deleting a user
Maintaining Profiles
Accessing profile maintenance
Profile types
Omegamon II uses three different profiles
Copying a profile
D61A$DEFAULT
Exporting a Profile
Importing a Profile
Deleting a profile
Modifying a profile description
Using the Dynamic Profile Update Facility
Switching profiles
Example command for importing a profile
Example command for exporting a profile
MVS Modify command for exporting a profile is as follows
MVS Modify command for importing a profile is as follows
Accessing the Filter Options window
Setting Filtering Options for Near-Term Thread History
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
Set up the CUA options Set up the !DB/EXPLAIN options
Using the Callable Interface
Setting Up the CUA Options
Setting Up !DB/EXPLAIN
SQLID.PLANTABLE
Step Action Log onto CUA
Use the following procedure to set up the D2/EXPLAIN options
Setting 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
This chapter describes how to use Omegamon
Using Omegamon
DB2 subsystem components
Monitoring from the System Status Panel
Monitored objects
Alert notification
Status indicators
Investigating an alert
Color Status
Performing actions from the System Status panel
Cics exceptions
System Status Components and Related Exceptions
Description Code Explanation
TSO exceptions
IMS exceptions
Background exceptions
Utility exceptions
Following exceptions apply to active threads
Active thread exceptions
Buffer pool exceptions
Inactive thread exceptions
Following exceptions apply to buffer pool resources
Lock statistics exceptions
EDM pool exceptions
Log manager exceptions
DDF statistics exceptions
Lock exceptions
DB2 activity exceptions
Following exceptions apply to DB2 activity alerts
Following exceptions apply to lock alerts
Stored procedures exceptions
Volume activity exceptions
Active trace exceptions
User-defined functions exceptions
Triggers exceptions
Following exceptions apply to alerts relating to triggers
Following exceptions apply to user-defined functions
Active threads alert
Investigating an 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
Specifying background application trace options
Initiating a background application trace
Identifying the dataset to which trace data is written
Size Size of the dataset in megabytes Volume
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
Functions provided by !DB/EXPLAIN for DB2
Background about !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
Required fields for the SAVE/EXPLAIN option
SAVE/EXPLAIN
PDS
Using the D2/EXPLAIN Options Panel
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
Direction of access
Accessing Omegamon II Trace Information from !DB/EXPLAIN
Prerequisites for using the Omegamon II trace information
Procedure to obtain current trace information
Task You Want to Perform Source of Information
Sources of information
Page
Appendix Contents
Panel Navigation Flowcharts
System Status panel
Flowchart Conventions
Element Description
DB2
System Status
Workloads Panels
IMS
Cics
TSO
Cics IMS TSO
Workloads Panels Near-term history
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