Candle-lite DB2 manuals

Candle lite DB2 User Manual (132 pages)

Brand: Candle-lite | Category: Hardware | Size: 1.02 MB |

English

Table of contents

User’s Guide: CUA Interface

1

Contents

3

List of Figures

5

About This Book

8

Printing problems?

9

Documentation Conventions

10

Background

12

What’s New

15

64-bit addressing support

16

Long name support

16

Unicode support

16

Enclave support

16

New DSNZPARM fields

17

Getting Started

19

Signing On

20

Sign On panel fields

21

Setting Logon Options

22

Signing Off

24

Panel Features

25

Data Panels

27

Pushbuttons

28

Action Bar

29

Actions pull-down

30

GoTo pull-down

31

View pull-down

31

Options pull-down

32

Tools pull-down

32

Help pull-down

32

Action Codes

33

Function Keys

34

Getting Help

36

Using the Glossary

37

Searching the glossary

37

Help function keys

38

Customizing OMEGAMON II

39

Introduction

40

Specifying Panel Preferences

41

Specifying Terminal Options

43

“EXPLAINing SQL

44

Code” on page 61

44

Saving Terminal Options

45

Saving for current session

45

Saving to a profile

45

Setting Thresholds

46

Saving threshold values

47

Assigning User Authorities

48

Maintaining Profiles

49

Copying a profile

50

Importing a Profile

51

Exporting a Profile

51

Deleting a profile

51

Switching profiles

52

Using the Callable Interface

57

Setting Up !DB/EXPLAIN

58

Setting Up the CUA Options

58

D2/EXPLAIN Options panel

60

Customizing OMEGAMON II 63

63

5 Press the Process SQL key

63

Step Action

63

Using OMEGAMON II

65

DB2 subsystem components

66

Monitored objects

66

Status indicators

67

Alert notification

67

Investigating an alert

67

CICS exceptions

69

IMS exceptions

70

TSO exceptions

70

Background exceptions

70

Utility exceptions

70

Distributed exceptions

70

Active thread exceptions

71

Inactive thread exceptions

72

Buffer pool exceptions

72

EDM pool exceptions

73

Lock statistics exceptions

73

Log manager exceptions

73

DDF statistics exceptions

73

DB2 activity exceptions

74

Lock exceptions

74

Active trace exceptions

75

Volume activity exceptions

75

Stored procedures exceptions

75

Triggers exceptions

76

Active threads alert

77

Exception recommendations

77

Displaying all exceptions

78

Modifying thresholds

78

Adding or modifying rules

79

Using OMEGAMON II 81

81

Overview

85

Starting an IFCID Trace

85

Displaying IFCID Trace Data

86

Stopping an IFCID Trace

87

Using OMEGAMON II for DB2

89

with !DB/EXPLAIN

89

Assumptions

91

EXPLAINing SQL Code

100

What functions can you use?

102

Modes of operation

102

Capturing SQL using the ATF

105

Direction of access

106

Procedure

106

Sources of information

107

Panel Navigation Flowcharts

109

Flowchart Conventions

110

System Status panel

110

System Status

111

Workloads Panels

112

Resources Panels

115

Alerts Panels

118

Buffer Pool

119

Snapshot

119

Pagesets

119

Application Trace Facility

123

Object Analysis Panels

124

Thread Detail GoTo Panels

126

, 57, 93

131

Candle-lite devices

Hardware