How it Works
Candle-lite
Loading...
D
Loading...
Loading...
DB2
User Manual
132 pgs1.07 Mb0
Table of contents
Loading...

Candle-lite DB2 User Manual

User’s Guide: CUA Interface
OMEGAMON II ® for DB2
Version 540
G251246500
August 2004
Candle Corporation
100 North Sepulveda Blvd.
Copyright © August 2004, Candle Corporation, a California corporation. All rights reserved. International rights secured.
Threaded Environment for AS/400, Patent No. 5,504,898; Data Server with Data Probes Employing Predicate Tests in Rule Statements (Event Driven Sampling), Patent No. 5,615,359; MVS/ESA Message Transport System Using the XCF Coupling Facility, Patent No. 5,754,856; Intelligent Remote Agent for Computer Performance Monitoring, Patent No. 5,781,703; Data Server with Event Driven Sampling, Patent No. 5,809,238; Threaded Environment for Computer Systems Without Native Threading Support, Patent No. 5,835,763; Object Procedure Messaging Facility, Patent No. 5,848,234; End-to-End Response Time Measurement for Computer Programs, Patent No. 5,991,705; Communications on a Network, Patent Pending; Improved Message Queuing Based Network Computing Architecture, Patent Pending; User Interface for System Management Applications, Patent Pending.
NOTICE: This documentation is provided with RESTRICTED RIGHTS. Use, duplication, or disclosure by the Government is subject to restrictions set forth in the applicable license agreement and/or the applicable government rights clause. This documentation contains confidential, proprietary information of Candle Corporation that is licensed for your internal use only. Any unauthorized use, duplication, or disclosure is unlawful.
2 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540

Contents

List of Figures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .5
Preface . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .7
About This Book . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .8
Adobe Portable Document Format . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .9
Documentation Conventions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .10
Candle Customer Service and Satisfaction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .12
What’s New . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .15
Chapter 1. Getting Started. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .19
Signing On . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .20
Setting Logon Options. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .22
Signing Off . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .24
Panel Features . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .25
Data Panels . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .27
Action Bar . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .29
Action Codes. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .33
Function Keys . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .34
Getting Help . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .36
Chapter 2. Customizing OMEGAMON II . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .39
Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .40
Specifying Panel Preferences . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .41
Specifying Terminal Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .43
Setting Thresholds . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .46
Assigning User Authorities . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .48
Maintaining Profiles. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .49
Setting Filtering Options for Near-Term Thread History . . . . . . . . . . . . . . . . . . . . . . . . .54
Specifying Save Options for SQL Text . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .56
Using the Callable Interface . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .57
Chapter 3. Using OMEGAMON II . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .65
Monitoring from the System Status Panel . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .66
System Status Components and Related Exceptions . . . . . . . . . . . . . . . . . . . . . . . . . . .69
Investigating an Active Threads Alert . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .77
Evaluating and Modifying Thresholds . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .78
Reviewing Near-Term History Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .80
Using the OMEGAMON II for DB2 Background Application Trace Facility . . . . . . . . . .82
Using the IFCID Trace Facility . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .85
3
Chapter 4. Using OMEGAMON II for DB2 with !DB/EXPLAIN . . . . . . . . . . . . . . . . . . . . .89
Background about !DB/EXPLAIN for DB2 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .90
Using OMEGAMON II and !DB/EXPLAIN Complementary Functions . . . . . . . . . . . . . .91
Using the OMEGAMON II for DB2 Callable Interface . . . . . . . . . . . . . . . . . . . . . . . . . .93
Moving Interactively between !DB/EXPLAIN and OMEGAMON II . . . . . . . . . . . . . . .102
Using the Copy-and-Paste Facility in OMEGAMON II . . . . . . . . . . . . . . . . . . . . . . . . .104
Accessing OMEGAMON II Trace Information from !DB/EXPLAIN. . . . . . . . . . . . . . . .106
Appendix A. Panel Navigation Flowcharts. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .109
Flowchart Conventions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .110
Workloads Panels . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .112
Resources Panels . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .115
Alerts Panels . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .118
Installation Parameters Panels . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .120
Application Trace Facility Panels . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .122
Object Analysis Panels. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .124
Thread Detail GoTo Panels . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .126
Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .129
4 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540

List of Figures

FIGURE 1. OMEGAMON II for DB2 System Status Panel . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .111
FIGURE 2. Workloads Panels (Realtime) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .113
FIGURE 3. Workloads Panels (Near-term history) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .114
FIGURE 4. Resources Panels (Realtime) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .116
FIGURE 5. Resources Panels (Near-Term History) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .117
FIGURE 6. Alerts Panels . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .119
FIGURE 7. Installation Parameters Panels . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .121
FIGURE 8. Application Trace Facility Panels . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .123
FIGURE 9. Object Analysis Panels. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .125
FIGURE 10. Thread Detail GoTo Panels (Realtime). . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .127
FIGURE 11. Thread History Detail GoTo Panels (Near-Term History) . . . . . . . . . . . . . . . . . . . . . . .128
5
6 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540
P
This guide is an introduction to the CUA™ interface for OMEGAMON II® for DB2®, Version 540. The CUA interface is based on IBM's Common User Access™ standards designed to facilitate ease of learning and use. OMEGAMON II® for DB2 is a component of OMEGAMON XE for DB2 on z/OS.
This manual is intended for data center personnel who are responsible for monitoring DB2 performance, systems programmers and performance analysts who are responsible for a DB2 subsystem, application programmers who wish to monitor their programs, and database administrators.
This document covers basic information you need to get started using OMEGAMON, including signing on and off, getting help, and customizing OMEGAMON II to meet the requirements of your installation. It also provides an overview of the main navigation paths in OMEGAMON in “Panel Navigation Flowcharts” on page 109.

Preface

Note: OMEGAMON II for DB2 also supports the classic interface, which allows you to
navigate in OMEGAMON using a menu system. If you are interested in learning about the classic interface, refer to the OMEGAMON II for DB2 Tuning Guide, Version 540.
7

About This Book

About This Book

Who should read this book

This manual is intended for data center personnel who are responsible for monitoring DB2 performance, systems programmers and performance analysts who are responsible for a DB2 subsystem, application programmers who wish to monitor their programs, and database administrators.

Documentation set information

I
OMEGAMON II for DB2 Users Guide: CUA Interface, Version 540
I
OMEGAMON II for DB2 Reference Manual: Classic Interface, Version 540
I
OMEGAMON II for DB2 Tuning Guide, Version 540
I
OMEGAMON II for DB2 Historical Reporting Guide, Version 540
I
OMEGAMON II for DB2 Configuration and Customization Guide, Version 540
I
Installation and Configuration of Candle Products on OS/390 and z/OS, Version 350
I
!DB/Tools Installation and Customization Guide, Version 510
I
Candle Products Messages Manual

Where to look for information

For more information related to this product, please see the
I
technical documentation CD-ROM that came with your product
I
technical documentation information available on the Candle Web site at www.candle.com
I
online help provided with this product
8 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540

Adobe Portable Document Format

Introduction

Candle supplies documentation in the Adobe Portable Document Format (PDF). The Adobe Acrobat Reader prints PDF documents with the fonts, formatting, and graphics in the original document. To print a Candle document, do the following:
1. Specify the print options for your system. From the Acrobat Reader Menu bar, select
File > Print Setup... and make your selections. A setting of 300 dpi is highly recommended as is duplex printing if your printer supports it.
2. To start printing, select File > Print on the Acrobat Reader Menu bar.
3. On the Print popup, select one of the Print Range options for
– a single page –a range of pages –all of the document
4. (Optional) To fit oversize pages to the paper size currently loaded on your printer,
select the Shrink to Fit option.
Adobe Portable Document Format

Printing problems?

Your printer ultimately determines the print quality of your output. Sometimes printing problems can occur. If you experience printing problems, potential areas to check are:
I
settings for your printer and printer driver. (The dpi settings for both your driver and printer should be the same. A setting of 300 dpi is recommended.)
I
the printer driver you are using. (You may need a different printer driver or the Universal Printer driver from Adobe. This free printer driver is available at www.adobe.com.)
I
the halftone/graphics color adjustment for printing color on black and white printers. (Check the printer properties under Start > Settings > Printer. For more information, see the online help for the Acrobat Reader.)
I
the amount of available memory in your printer. (Insufficient memory can cause a document or graphics to fail to print.)
For additional information on printing problems, refer to the documentation for your printer or contact your printer manufacturer.
9

Documentation Conventions

Documentation Conventions

Introduction

Candle documentation adheres to accepted typographical conventions for command syntax. Conventions specific to Candle documentation are discussed in the following sections.

Panels and figures

The panels and figures in this document are representations. Actual product panels may differ.

Required blanks

The slashed-b (!) character in examples represents a required blank. The following example illustrates the location of two required blanks.
!!!!eBA*ServiceMonitor!!!!0990221161551000

Revision bars

Revision bars (|) may appear in the left margin to identify new or updated material.

Variables and literals in command syntax examples

In examples of command syntax for the OS/390, VM, OS/400, and NonStop Kernel platforms, uppercase letters indicate actual values (literals) that the user should type; lowercase letters indicate variables that represent data supplied by the user:
LOGON APPLID (cccccccc)
However, for the Windows and UNIX platforms, variables are shown in italics:
-candle.kzy.instrument.control.file=
-candle.kzy.agent.parms=
agent_control_file_name
instrumentation_control_file_name
Note: In ordinary text, variable names appear in italics, regardless of platform.

Symbols

The following symbols may appear in command syntax:
Table 1. Symbols in Command Syntax
Symbol Usage
| The “or” symbol is used to denote a choice. Either the argument
on the left or the argument on the right may be used. Example:
YES | NO
In this example, YES or NO may be specified.
10 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540
Table 1. Symbols in Command Syntax
Symbol Usage
[ ] Denotes optional arguments. Those arguments not enclosed in
square brackets are required. Example:
APPLDEST DEST [ALTDEST]
In this example, DEST is a required argument and ALTDEST is optional.
{ } Some documents use braces to denote required arguments, or to
group arguments for clarity. Example:
COMPARE {workload} -
The workload variable is required. The REPORT keyword must be specified with a value of SUMMARY or HISTOGRAM.
_ Default values are underscored. Example:
COPY infile outfile - [COMPRESS={YES
In this example, the COMPRESS keyword is optional. If specified, the only valid values are YES or NO. If omitted, the default is YES.
Documentation Conventions
REPORT={SUMMARY | HISTOGRAM}
| NO}]
11

Candle Customer Service and Satisfaction

Candle Customer Service and Satisfaction

Background

To assist you in making effective use of our products, Candle offers a variety of easy-to-use online support resources. The Candle Web site provides direct links to a variety of support tools that include these services:
eSupport allows you to create and update service requests opened with Customer
Service and Satisfaction (CSS).
eDelivery allows you to download products, documentation, and maintenance 24
hours a day, 7 days a week.
eNotification notifies you of product updates and new releases.
In addition, you can find information about training, maintenance plans, consulting and services, and other useful support resources. Refer to the Candle Web site at
www.candle.com

Candle Customer Service and Satisfaction contacts

for detailed customer service information.
You will find the most current information about how to contact Candle CSS by telephone or email on the Candle Web site. Go to the www.candle.com support section, and choose the link to Support Contacts to locate your regional support center.
12 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540
13
14 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540
W
This section identifies the enhancements for Version 540 of OMEGAMON II for DB2. OMEGAMON II® for DB2 is a component of OMEGAMON XE for DB2 on z/OS, Version
300. The changes and additions in OMEGAMON II for DB2 provide new function in addition to reflecting support for features in IBM DB2 Version 8.1. OMEGAMON II for DB2 enables you to obtain additional information about the performance of your systems. This additional information allows you more flexibility in managing various types of threads. An overview of each new or changed function follows.
Note: With this version, OMEGAMON II for DB2 no longer supports IBM DB2 Version
5.

Historical Reporter redesign

What’s New

With OMEGAMON II for DB2, significant enhancements were made to the historical reporting component. Some of these new features are:
I
Sequential output files are produced from the online collector.
I
All record types can be loaded into DB2 tables using either the LOAD utility or using SQL INSERT.
I
Near term history collector for displays is configured separately from long term history for reports.
I
New fields have been added to the Summarizer.

New IFCID-based reports

I
Numerous new IFCID-based reports are provided. See the OMEGAMON II for DB2 Historical Reporting Guide, Version 540, for a list of the supported IFCIDs. See the
README provided with this product for instructions on generating the IFCID-based reports.
I
You can generate your own reports, based on the IFCIDS selected, using the product-provided COBOL, C, and SAS record layouts. All instrumentation record types (IFCIDs) are supported. The data are extracted from SMF, GTF or from the Online Collector input.
15

64-bit addressing support

Version 8 of DB2 UDB for z/OS supports 64-bit virtual storage. The zSeries 64-bit architecture allows DB2 UDB for z/OS to move various storage areas above the 2-GB bar. OMEGAMON II for DB2 Version 540 now provides the ability to display information from above the 2-GB bar structures.
64-bit addressing support applies to the:
I
EDM pool
I
buffer pools
I
sort pools
I
RID pools

Long name support

OMEGAMON II for DB2 Version 540 includes support for long object names. New displays are provided in support of this feature.

Unicode support

Unicode support includes character conversion from Unicode to EBCDIC for online displays and batch reports.

Enclave support

New displays for stored procedures using Work Load Manager (WLM) enclaves include:
I
Enclave Token
I
Service Class Period
I
Performance Index
I
Service Class
I
WLM Environment Name
Stored procedure Address Spaces is being phased out in DB2 Version 8. All stored procedures now use WLM.

New filtering for Near Term History display

These keywords are added to the Near Term History display:
I
COMMIT
I
CORRID
I
DB2 CPU TIME
I
DB2 ELAP TIME
I
DEADLK/TIMEOUT
I
I/O ELAP TIME
16 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540
I
GETPAGES
I
LOCK ESCAL
I
PACK AGE
See the OMEGAMON II for DB2 Reference Manual, Version 540, for descriptions of these new fields.

New DSNZPARM fields

The DSNZPARM Thread Parameters panel now includes numerous new fields.

Distributed Thread display improvements

The Distributed Thread display improvements include the addition of these fields:
I
Host Name
I
Workstation identifier
I
End user ID on workstation
I
Transaction ID on workstation
17
18 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540
1
Introduction
This chapter is intended to help you get started using the CUA interface for OMEGAMON II for DB2 to monitor your DB2 subsystem.
Chapter Contents
Signing On . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20
Setting Logon Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22
Signing Off . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24
Panel Features . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25
Data Panels . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27
Action Bar . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29
Action Codes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33
Function Keys. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34
Getting Help. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 36

Getting Started

Getting Started 19

Signing On

Signing On

Logging on to the application

You access the CUA interface for OMEGAMON II by logging on to a VTAM® application. The name of the application (the applid) is defined at your site when the product is installed. Depending on the system configuration at your site, you may be required either to select the application from a menu, or issue a command.
To log on to the application: Select the application from the menu or issue the following command from a VTAM terminal:
LOGON APPLID(
where applid is the application name.
Note: The Candle logo panel appears. The logo panel identifies the product by name

Sign On panel

To begin the sign-on, from the logo panel:
I
Press Enter Result: The Sign On panel appears.
OMEGAMON II for DB2 - V540
Type the requested information, and press Enter.
Identification
Userid . . . . . .______
Password . . . . .
Change Password. . No + Yes/No
Additional Information
Group . . . . . .______
Account . . . . ._____________________________________________
F1=Help F3=Exit F4=Prompt F6=panel ID F11=Logon Options
applid
)
and version, and presents copyright information. Use this panel to verify that you have logged on to the correct application.
D203-0330
Sign On panel
You are required by OMEGAMON II to enter information for only two fields on the Sign-On Panel: Userid and Password. Other fields may be optional or required depending on the security system at your site. Contact your security administrator for more information.
When you complete your sign-on information, press Enter to display the System Status panel. If this is the first time you are signing on to OMEGAMON, the Logon Options panel will appear instead of the System Status panel.
Note: During the sign-on, you can display help by pressing F1. You can stop the sign-on
at any time by pressing F3.
20 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540

Sign On panel fields

The fields of the Sign On Panel are defined in the table below.
Field Description
Userid Your 1–8 character user ID, which authorizes your access to
Password Your 1–8 character private password, which authorizes your access to
Change Password This field enables you to change your password.
Group Your product administrator may assign users who need to do the same
Account For auditing or security purposes, your product administrator may assign
Signing On
OMEGAMON II.
OMEGAMON II.
To leave your password unchanged, accept the default, No. To change your password, type Yes . You are prompted for a new
password.
tasks or have the same authorization to a particular group. If you have a group identifier, enter it here.
users to a particular account. If you have an account identifier, enter it here.

Accessing OMEGAMON from OMEGAVIEW

To access OMEGAMON II from OMEGAVIEW, Candle’s centralized status manager, select an OMEGAMON II for DB2 CUA status item. The panel that you zoom to will depend on which status item you selected within OMEGAVIEW.
For information about creating a status item under OMEGAVIEW and defining zoom destinations, see the OMEGAVIEW Configuration and Customization Guide.
Getting Started 21

Setting Logon Options

Setting Logon Options
The Logon Options panel enables you to specify session characteristics that will be applied each time you sign on to OMEGAMON II. It appears automatically the first time you sign on as a new OMEGAMON II user. To modify your logon options at any time, press F11 from the Sign On panel.
Logon Options
Type the correct values, then press Enter.
User Profile . . . . . . . . . $DEFAULT +
Subsystem Profile . . . . . . . $DEFAULT +
Application ID . . . . . . . .
DB2 Subsystem . . . . . . . . .
Logical Rows . . . . . . . . . 255 100-999
Migrate Profile from OMEGAMON . No + (Yes/No) OMEGAMON Profile to Migrate . .
User Data . . . . . . . . . . .
ENTER F1=Help F4=Prompt F12=Cancel
Note: If you are zooming to OMEGAMON from OMEGAVIEW, this panel will not
appear. To specify these logon options, you must log on to the OMEGAMON for CUA interface directly.

Logon Options panel fields

The following table describes the fields you can change on the Logon Options panel.
Field Description
User Profile The name of the user profile to be used for this session.
Subsystem Profile The name of your subsystem profile to be used for this session. Press
If you select $DEFAULT, OMEGAMON II uses the user profile named with your user ID. Press F4 to view a list of available user profiles.
If you enter the name of a nonexistent user profile, OMEGAMON II creates the profile, using the name you specified and Candle’s default settings.
F4 to view a list of available subsystem profiles. If you select $DEFAULT, OMEGAMON II uses the subsystem profile
that has the same name as the DB2 subsystem ID you are monitoring. You must select $DEFAULT in order to activate automatic profile switching. This feature allows the subsystem profile to switch automatically to one that matches the new DB2 subsystem whenever you change the subsystem you are monitoring.
If you enter the name of a non-existent subsystem profile, OMEGAMON II creates the profile, using the name you specified and Candle’s default settings.
22 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540
Setting Logon Options
Field Description
Application ID The OMEGAMON II classic interface VTAM mode application
identifier.
DB2 subsystem The DB2 subsystem ID that you want to monitor.
Logical rows The number of logical rows (100–9999).
Migrate Profile from OMEGAMON
OMEGAMON Profile to Migrate
User Data Additional classic interface options, such as USER=cc.
Enter Yes if you want to migrate a classic interface user profile to a CUA subsystem profile. Use this feature only to provide a set of values to use as a starting point for customizing the CUA subsystem profile.
When you migrate classic threshold values, they become CUA critical values.
If a CUA exception is set to trip when it exceeds its threshold, then the warning threshold is set to 80% of the critical threshold. If a CUA exception is set to trip when it falls below its threshold, then the warning threshold is set to 125% of the critical threshold.
For exceptions that are not associated with threshold values, the CUA critical value is set to on, and the warning value is set to off. If the classic STATE= value is ON, the CUA monitor value is YES. If the value for STATE= is OFF, the monitor value is NO.
The suffix of the profile you want to migrate from the classic OMEGAMON II system.
Note:
During normal operations, this field should be left blank.
Getting Started 23

Signing Off

Signing Off
To sign off OMEGAMON II:
1. Press F3 from the System Status panel.
2. Exit OMEGAMON using any of these methods:
I
I
I
Result: The Exit Confirmation pop-up window appears.
Exit Confirmation
Select one of the following, then press ENTER.
_ 1. Ex
2. R
F12=Cancel
it from OMEGAMON II for DB2 F3
eturn to OMEGAMON II for DB2
press Enter press F3 type x or 1 in the entry field, and press Enter

Returning to OMEGAVIEW from OMEGAMON

To return to OMEGAVIEW from OMEGAMON, use the trigger key you defined in OMEGAVIEW. The default trigger key is PA2 and can be used from any panel.
24 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540

Panel Features

IOMEGAMON II panels share a number of common features. In the following section, we use the System Status panel to show the panel features you will find throughout OMEGAMON II.
1___ Actions GoTo Options Tools Help
------------------------------------------------------------ mm/dd/yy 16:13:49 OMEGAMON II for DB2 System Status
Select one component with a “/” or an action code.
4 S=Show details A=Analyze problems H=Near-term history L=Control
+-----------------------------------------------------------------------------+
5 Workloads | Resources | Alerts |
|-------------------------+-------------------------+-------------------------| | _ CICS ==== | _ Buffer Mgr ==== | _ DB2 Activity ==== | | _ IMS ==== | _ EDM Pool ==== | _ Active Threads ==== | | _ TSO ==== | _ Lock Stats ==== | _ Inact. Threads ==== | | _ Background ==== | _ Log Manager ==== | _ Locks ==== | | _ Utility ==== | _ DDF Stats ==== | _ Active Traces ==== | | _ Distributed ==== | | _ Volume Activity ==== | | | _ Bind Stats ==== | _ Stored Procs ==== | | _ All Connections ==== | _ SSS Stats ==== | _ Functions ==== | | | _ SQL Stats ==== | _ Triggers ==== | | | _ Open/Close Stat ==== | | | | _ Command Stats ==== | _ DB2 Messages ==== | +-----------------------------------------------------------------------------+
6 F1=Help F2=Keys F3=Exit F4=Prompt F5=Refresh F6=Console F10=Action Bar
F24=CUA/TSO

Panel Fe at ures

2 System: D41A+
3 N-T History
The System Status panel is the first panel you see when you sign on to OMEGAMON II.
Panel features
This table describes features common to all OMEGAMON II panels.
Part Feature Description
1 2
3
Action Bar Provides access to OMEGAMON II functions.
System Field Displays the DB2 subsystem that you are monitoring.
Collector Status Field
Note:
Displays the status of the online data collector.
I
I
To begin monitoring a different DB2 subsystem, type the new DB2 subsystem into the System field, and press Enter. To display a selectable list of available DB2 subsystems, put the cursor in this field, and press F4.
N-T History indicates the collector is active and near-term history data is available.
.Realtime indicates the collector is not active and near-term history data is not available.
Getting Started 25
Panel Features
Part Feature Description
4 5
6
Action Codes Displays available action codes.
Note: Action codes do not apply to every product panel.
Panel Body Displays performance data or status information. Highlighting or
color is used to indicate status.
Function Keys Provide navigation and various functions.
26 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540

Data Panels

Description

Unlike the System Status panel, most OMEGAMON II full-screen panels present performance information in tabular format. Below, a sample data panel is shown.
Data Panels
____ Actions GoTo Tools Help +----------------------------------------------------------- mm/dd/yy 8:01:00 | Log Manager Statistics System:D41B | +----------------------------------------------------------------------------+ | Collection Interval . . : REALTIME | Start . . . : 10/20 11:50:29 |
| Report Interval . . . . : 7 sec | End . . . : 10/20 11:50:36 |
+---------------------------------------------------------------------------+ | | +----------------------------------------------------------------------------+
| Logging Mode . . . . : DUAL Archive Mode . . . . . : DUAL |
| No of Logs Defined . : 3 Number of Logs Available : 2 | | Checkpoint Frequency : 5000 Records Until Checkpoint : 4329 | | Input Buffer Size . . : 28K Output Buffer Size . . . : 400K | | Write Thresholds . . : 20 Current Log Record RBA . :000035DC696C | | | | Primary Active Log . : TDDB241A.LOGCOPY1.DS02 | | Secondary Active Log : TDDB241A.LOGCOPY2.DS02 | +----------------------------------------------------------------------------+ ( Stats ) < Reads > < Write > < Log > < Log DS > F1=Help F2=Keys F3=Exit F5=Refresh F6=DB2 Console **=Bkwd **=Fwd F10=Action Bar F15=System Status F24=CUA/TSO

Highlighted data fields

If a value in the data area of a panel exceeds a threshold, OMEGAMON II highlights that value.
This feature allows you to identify the source of a performance problem without having to read every line of data.
Note: This does not apply to the data panels that appear when you select Active Threads
from the System Status panel.

Scrolling

You can scroll from one panel of data to the next by using function keys, or scroll to a specific line of data by specifying a beginning line number.
You can use F7 to scroll backward one panel and F8 to scroll forward. You also can scroll through the data using the scroll indicator, which appears in the upper
right corner of the panel. For example:
Lines __23 to 51 of 117
The first two numbers show the beginning and ending lines currently displayed on the panel; the third number shows the total number of lines available for display. You can scroll through the data by entering the desired beginning line number in the field following Line.
Getting Started 27
Data Panels

Pushbuttons

OMEGAMON II provides pushbuttons as a way to navigate to panels that are closely related to the current panel.
Pushbuttons appear between brackets < > or parentheses ( ) at the bottom of some panels, directly above the function keys. Only selections in brackets < > are selectable. The pushbutton for the current panel appears in parentheses ( ) and is not selectable.
To use a pushbutton, place the cursor on the phrase or word in brackets, and press Enter.
28 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540

Action Bar

The action bar appears as the top line of every panel. It has an entry field on the left side and selectable keyword choices across the length of the line. When you select a choice from the action bar, a pull-down menu appears. Then you can select a menu item to navigate to other panels in the product.
The action bar keyword choices are as follows:
I
Actions
I
GoTo
I
View
I
Options
I
To ol s
I
Help

Selecting from the action bar

To select a keyword choice from the action bar:
Action Bar
1. Type the first letter of the choice in the action bar entry field, and press Enter.
Result: A pull-down menu appears from which you can make a selection. (When selecting Actions from the action bar, you must first select an object on the panel body by typing (/) in the entry field of the object.)
2. Type the number of the menu selection in the entry field, and press Enter.
Result: The selected panel appears.

Fast pathing from the action bar

Fast pathing is a method of quickly navigating to OMEGAMON II panels from the action bar without using menus and submenus.
For example, using fast pathing, you can access the DSNZPARM IRLM Parameters panel directly by entering GDR on the action bar entry field of the System Status panel. This
Getting Started 29
Action Bar
bypasses the GoTo menu and the DB2 Installation Parameters menu, and goes directly to the DSNZPARM Parameters panel.
Enter GDR in the entry field on the action bar of the System Status panel.
GDR Actions Goto Options Tools Help
System Status
DSNZPARM IRLM
Parameters
Using the fast path mnemonic brings you directly to the DSNZPARM IRLM Parameters panel.
The mnemonic character (G, D, R) for each selection is underlined on the panel or menu on which it appears.

Actions pull-down

The Actions pull-down menu allows you to display more information about the selected object on the panel body.
_ 1. Show details
2. Analyze Problems
3. Near term H
4. Control
5. Exit from OMEGAMON II for DB2 F3
F1=Help F12=Cancel
istory
30 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540
Loading...
+ 102 hidden pages
Buy Points How it Works FAQ Contact Us Questions and Suggestions Privacy Policy Cookie Policy Terms of Use