Candle Network Adapter DB2 manuel d'utilisation

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132

Aller à la page of

Un bon manuel d’utilisation

Les règles imposent au revendeur l'obligation de fournir à l'acheteur, avec des marchandises, le manuel d’utilisation Candle Network Adapter DB2. Le manque du manuel d’utilisation ou les informations incorrectes fournies au consommateur sont à la base d'une plainte pour non-conformité du dispositif avec le contrat. Conformément à la loi, l’inclusion du manuel d’utilisation sous une forme autre que le papier est autorisée, ce qui est souvent utilisé récemment, en incluant la forme graphique ou électronique du manuel Candle Network Adapter DB2 ou les vidéos d'instruction pour les utilisateurs. La condition est son caractère lisible et compréhensible.

Qu'est ce que le manuel d’utilisation?

Le mot vient du latin "Instructio", à savoir organiser. Ainsi, le manuel d’utilisation Candle Network Adapter DB2 décrit les étapes de la procédure. Le but du manuel d’utilisation est d’instruire, de faciliter le démarrage, l'utilisation de l'équipement ou l'exécution des actions spécifiques. Le manuel d’utilisation est une collection d'informations sur l'objet/service, une indice.

Malheureusement, peu d'utilisateurs prennent le temps de lire le manuel d’utilisation, et un bon manuel permet non seulement d’apprendre à connaître un certain nombre de fonctionnalités supplémentaires du dispositif acheté, mais aussi éviter la majorité des défaillances.

Donc, ce qui devrait contenir le manuel parfait?

Tout d'abord, le manuel d’utilisation Candle Network Adapter DB2 devrait contenir:
- informations sur les caractéristiques techniques du dispositif Candle Network Adapter DB2
- nom du fabricant et année de fabrication Candle Network Adapter DB2
- instructions d'utilisation, de réglage et d’entretien de l'équipement Candle Network Adapter DB2
- signes de sécurité et attestations confirmant la conformité avec les normes pertinentes

Pourquoi nous ne lisons pas les manuels d’utilisation?

Habituellement, cela est dû au manque de temps et de certitude quant à la fonctionnalité spécifique de l'équipement acheté. Malheureusement, la connexion et le démarrage Candle Network Adapter DB2 ne suffisent pas. Le manuel d’utilisation contient un certain nombre de lignes directrices concernant les fonctionnalités spécifiques, la sécurité, les méthodes d'entretien (même les moyens qui doivent être utilisés), les défauts possibles Candle Network Adapter DB2 et les moyens de résoudre des problèmes communs lors de l'utilisation. Enfin, le manuel contient les coordonnées du service Candle en l'absence de l'efficacité des solutions proposées. Actuellement, les manuels d’utilisation sous la forme d'animations intéressantes et de vidéos pédagogiques qui sont meilleurs que la brochure, sont très populaires. Ce type de manuel permet à l'utilisateur de voir toute la vidéo d'instruction sans sauter les spécifications et les descriptions techniques compliquées Candle Network Adapter DB2, comme c’est le cas pour la version papier.

Pourquoi lire le manuel d’utilisation?

Tout d'abord, il contient la réponse sur la structure, les possibilités du dispositif Candle Network Adapter DB2, l'utilisation de divers accessoires et une gamme d'informations pour profiter pleinement de toutes les fonctionnalités et commodités.

Après un achat réussi de l’équipement/dispositif, prenez un moment pour vous familiariser avec toutes les parties du manuel d'utilisation Candle Network Adapter DB2. À l'heure actuelle, ils sont soigneusement préparés et traduits pour qu'ils soient non seulement compréhensibles pour les utilisateurs, mais pour qu’ils remplissent leur fonction de base de l'information et d’aide.

Table des matières du manuel d’utilisation

  • Page 1

    User ’s Guide: CUA Inter f ace OMEGAM ON II ® f or DB2 V ers ion 5 40 G251246500 Augus t 2004 Ca ndle C or po ration 100 N or th S ep ulveda B lvd.[...]

  • Page 2

    2 OMEGA MON I I for DB 2 Use r’s Guide: C U A I nterface, V ersion 540 Reg istered trademarks and service marks of Candle Corporation: AF/OPERA TOR, AF/REMOTE, Availabili ty Command Ce nter , Candle, Candle CIRCUIT , Candle Co mmand Center , Candle Direct logo , Candle eDelivery , Candl e Electronic Custome r Support, C andle logo , Ca ndle M ana[...]

  • Page 3

    3 Li st of F igur es . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 P re f a ce . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 Ab out Thi s Book . . . . . . . . . . . . . . . . . . . . . . . .[...]

  • Page 4

    4 OMEGA MON I I for DB 2 Use r’s Guide: C U A I nterface, V ersion 540 Ch apte r 4. Usi ng OMEGAMON I I for DB2 wit h !DB/E XPLAIN . . . . . . . . . . . . . . . . . . . . . 89 Ba ckgr oun d a bo ut !DB /EXP L AIN fo r DB2 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 90 Usin g OM EG AMON I I a nd ! DB /EX PL A IN C om plem e[...]

  • Page 5

    5 FIG URE 1. O ME GAM O N I I fo r D B2 S ys tem S tatu s P a ne l . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 11 FIG URE 2. Workl oad s P a nel s ( Rea ltim e) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .1 13 FIG URE 3. Workl oad s P a nel s ( Ne ar - t er m h istor y) . . . . . . . . [...]

  • Page 6

    6 OMEGA MON I I for DB 2 Use r’s Guide: C U A I nterface, V ersion 540[...]

  • Page 7

    7 Preface Th is g uid e i s an in tro du c tio n to th e CU A™ inte r f ac e fo r OM E GAM O N II ® f or D B2 ® , V e rsi on 5 40 . Th e CU A int erfa ce is ba sed on I BM's Com mon U se r Acce ss™ s tan dard s des igned to facil itate eas e o f l earn i ng and use . OMEGAMON II® for D B2 is a compon ent of O MEGA MO N XE fo r D B2 on z[...]

  • Page 8

    Abou t This Book 8 OMEGA MON I I for DB 2 Use r’s Guide: C U A I nterface, V ersion 540 Ab out This B o ok Wh o should r ead this b o o k This m anua l is i ntend ed for d ata cent er personne l who are responsi ble for moni toring DB2 pe rf orm ance , s ys tems pro gramm ers and per fo rm ance an alysts who a re respon sible for a DB2 subsystem [...]

  • Page 9

    9 Ad o be P o r t able D ocu ment F o rmat Ad obe P ortab le Doc ument For mat In trod uction Ca ndl e suppli es docu mentati on in the A d o be P ortab le Docu ment F ormat (P DF) . The Ado b e Acr ob at Re ader pri nts PD F do cu me nt s w ith t he fon ts , fo rm at ti ng , an d gra ph ics i n the ori ginal do cum ent. T o prin t a Can dle doc um[...]

  • Page 10

    Documenta t io n Conventions 10 OMEGA MON II for DB 2 User ’s Guide: CUA Int e rface, V e rsi on 540 Do cumen tatio n Con venti ons In trod uction Can dle d ocum entati on ad heres to acce pted t ypogra phic al co nven tions f or com mand syntax . C onv entions spe cific to C andl e do cume ntat ion a r e di scu ssed in the fol lowing se ctio ns.[...]

  • Page 11

    11 Documentati on Conventions [ ] Denot es optional argu ments. Those a r g uments not enclosed in sq ua re brac ket s a re r eq uired. E xamp le: APPLDE ST DEST [AL TDEST] In t his e x amp le, DE ST is a required argu ment an d AL T DEST is opt i ona l. { } Some d ocuments use b r a ces to denote requir ed arguments, or to group arg uments for c l[...]

  • Page 12

    Candle Customer Service and Satisfa ction 12 OMEGA MON II for DB 2 User ’s Guide: CUA Int e rface, V e rsi on 540 Can dle Cu sto mer Ser vice and Sati sfact io n Bac kgr ound T o ass ist yo u in maki ng eff ectiv e use of our pro ducts, Ca ndl e of fers a var iet y of easy-to-use onl ine supp or t r es ources. T he C and le W e b site pro vides d[...]

  • Page 13

    13[...]

  • Page 14

    14 OMEGA MON II for DB 2 User ’s Guide: CUA Int e rface, V e rsi on 540[...]

  • Page 15

    15 Wh at ’ s Ne w This sect ion iden tifies the enhance ments f or V ersion 540 of OM EG AMON II for DB2. OMEGAM ON II® for DB2 is a compo nent of OMEGAMON X E for DB2 on z/OS, V ersion 300. The changes and additions in OMEGA MON II for DB2 provide new function in add iti on to r ef lec ting su p po r t fo r fea ture s i n IBM DB2 V ers ion 8 .1[...]

  • Page 16

    16 OMEGA MON II for DB 2 User ’s Guide: CUA Int e rface, V e rsi on 540 64 -bi t add ressing supp ort V ers ion 8 of DB2 UD B for z/OS suppor ts 64 -bit vir tua l s torage . The zSeries 64-bit archit ec ture allo ws D B2 U DB for z/O S to m o ve var iou s st orag e are as abo ve the 2- G B ba r . OMEGAM ON II for DB2 V ersion 540 now provides the[...]

  • Page 17

    17 I GETP AG ES I L OCK ESCAL I PA C K A G E See th e O MEG AM ON II for DB2 R eference Manual, V ersion 540 , f or de script ions of th ese ne w f iel ds . New DSNZP ARM fields The DS NZP A RM Thread P ara meter s panel now in clud es n umerou s new field s. Dist r i bute d Th read di spla y impr ove ments The Di st ribut ed Thr ead dis pla y imp [...]

  • Page 18

    18 OMEGA MON II for DB 2 User ’s Guide: CUA Int e rface, V e rsi on 540[...]

  • Page 19

    Ge tting S tar ted 19 Getting Started In troduc tio n This c hapte r is in tended to he lp yo u get s tart ed us ing the CUA inter fa ce fo r OMEGA MON II for DB 2 to monitor you r DB2 subsys tem. Cha pter Con ten ts Sig n in g On . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20 Se[...]

  • Page 20

    Si gnin g O n 20 OMEGA MON II for DB 2 User ’s Guide: CUA Int e rface, V e rsi on 540 Sig ning On Log ging on to the applica tion Y ou acce ss the CUA in ter face f or OM EGAM ON II by logging on t o a V T A M® appl ication. The na me of the appl ication (th e app lid ) is de fin ed at y our si te wh en th e pro du ct i s insta lled. D epen ding[...]

  • Page 21

    Ge tting S tar ted 21 Signing On Sign On p an el field s Th e field s of t he Si gn O n P an el are de fin ed in t he ta ble b el ow . Acc essing OMEGAMO N fr om OMEGA VIEW T o access OM EGA MON I I from OME GA VI EW, Cand le’s ce ntral ized status manag er , sele ct an O MEGAM ON II fo r D B2 CUA status ite m. The pan el that you zoom to will de[...]

  • Page 22

    Se tting Logon Op tion s 22 OMEGA MON II for DB 2 User ’s Guide: CUA Int e rface, V e rsi on 540 Set ting L ogon Options The Lo gon Opt ions pane l enab les you to spe cify ses sion charac teris tics that will be appl ied e a c h ti me yo u sig n o n to OMEGAM ON II . It appears automati cally the first time yo u si gn o n a s a n ew OM E G AM ON[...]

  • Page 23

    Ge tting S tar ted 23 Se tting Logon Op tion s Application ID The OMEGAMON II c lassic interface VT AM mode a pplication iden tifi er . D B2 s ub sy ste m Th e D B2 su bsy ste m ID tha t yo u wan t t o m o nito r . Lo gical rows The numbe r o f logical rows (100–9999). Mig rate P ro fil e from OMEGAMON Ent er Ye s if you want to migrate a c lassi[...]

  • Page 24

    Si gnin g O f f 24 OMEGA MON II for DB 2 User ’s Guide: CUA Int e rface, V e rsi on 540 Sig ning Off T o sign off OMEGAM O N II: 1. Press F 3 fro m t he S yst em S ta tus p an el. Resu lt : The E xit Confir ma tion pop -up windo w appe ars. 2. Exit OMEGA MON usin g any of these methods : I press E nter I press F3 I typ e x or 1 in the e ntry fi e[...]

  • Page 25

    Ge tting S tar ted 25 Pa n e l Fe a t u r e s P an el Fe atur es IOMEG AM ON II pan els s hare a nu mb er of comm on f eatures. I n th e fo llowi ng sect ion, w e use the Sys tem S tatus pane l to sho w t h e pane l features you w ill find throu gh out OMEGAM ON II. The Sys tem Stat us panel is th e first pan el you see whe n you sign on to OMEGA M[...]

  • Page 26

    P a nel F eatur e s 26 OMEGA MON II for DB 2 User ’s Guide: CUA Int e rface, V e rsi on 540 4 Action Co des Displays avai la ble a ct i on codes. Not e : Acti on codes do not apply to every pr oduct panel. 5 P anel Body Displays pe r form ance data or status information. Highlighting or colo r is used to in dicate stat us. 6 F unction Ke ys P rov[...]

  • Page 27

    Ge tting S tar ted 27 Dat a P anels Data Panels Description Unlike the System St atus pan el, most OM EGAM ON II full-s cr ee n pane ls pr e sent per for man ce in for mat ion in tabul ar f orm at. Be low , a sample dat a pa nel i s show n. Highlight ed d a t a fields I f a val ue in the da ta ar ea of a pan el e xce eds a t hr esho ld, OMEG A M O [...]

  • Page 28

    Dat a P anels 28 OMEGA MON II for DB 2 User ’s Guide: CUA Int e rface, V e rsi on 540 Push b u ttons OM EGAMON II provide s pushbu ttons as a wa y t o nav igate t o panels that a re clo sely r elate d to the curr ent panel. Push buttons a ppear betwee n brackets < > o r parenthese s ( ) a t the bottom of s ome panel s, d ir e c tly above th[...]

  • Page 29

    Ge tting S tar ted 29 Ac t ion Bar Action Bar The acti on bar a ppears as the to p line of eve r y panel . It has an entry fi eld on the left s ide an d selec tab le key word cho ices ac ros s the le ngth o f the line . W hen yo u selec t a choice from the a ction ba r , a pul l-down menu ap pears. Then yo u can sele ct a m enu item to naviga te to[...]

  • Page 30

    Action Bar 30 OMEGA MON II for DB 2 User ’s Guide: CUA Int e rface, V e rsi on 540 byp ass es the GoT o menu an d the DB2 In stal latio n P ar a met ers menu , and goes di rec tly to the DSNZP A RM P ara meters p an el. Th e mnem onic ch ara cter (G, D, R) f or eac h sele ction is unde rlined on the pane l or m enu on whic h it appea rs. Action s[...]

  • Page 31

    Ge tting S tar ted 31 Ac t ion Bar GoT o pull-d own Th e Go T o m enu e na bles yo u to qui ckly mo ve to pan els tha t are relat ed t o th e cur r ent pane l, as well as t o other prod uct areas. T he select ions on t his menu v ary f rom pane l to pane l. Y ou c an also use the G oT o m enu to I sele ct the pane l Index, which e nabl es you to mo[...]

  • Page 32

    Action Bar 32 OMEGA MON II for DB 2 User ’s Guide: CUA Int e rface, V e rsi on 540 Opt ion s p u ll-dow n The Opt ion s pull-dow n men u e nab les you to cust omiz e OMEGA MON II. Y o u can chang e t h e pan el dis pla y , sel ect a di ffer e n t s tartup pr ofi le, se t th resh ol ds , and as sign use r au thoritie s. Not e: Additional opti on s[...]

  • Page 33

    Ge tting S tar ted 33 Action C odes Ac tion C odes Acti on codes let yo u easi ly an alyz e the pe rformanc e of yo u r D B 2 su bsys tem by al lo wing you to g et more in for matio n abou t or per for m act io ns on pan el obje cts. Y ou can use ac tion c odes as an a lt ern at ive to u sing th e Ac tion s men u. A vai la ble ac ti on co d es Y ou[...]

  • Page 34

    F unction K eys 34 OMEGA MON II for DB 2 User ’s Guide: CUA Int e rface, V e rsi on 540 Func tio n K eys F unct ion k eys enabl e yo u to perform c e r t ain t asks i n OM EGAMON I I. Thes e keys ar e displa yed alon g the bot tom line of the pa ne l. Each pa nel list s the av aila ble fu nction keys and th eir assign ments f or the cur rent pane[...]

  • Page 35

    Ge tting S tar ted 35 F unction K eys Not e: F5 , F9, and F11 are ass igne d d ifferen tl y on H elp pa nel s. S e e “Help function keys” on page 38 fo r a desc rip ti on of th ese keys . F2 1 Process SQL Co pies SQL statem ents from the SQL C all Being Exe cuted panel or fr om the SQ L T ext pa n el an d past es the m into a speci fie d destin[...]

  • Page 36

    Getti ng Help 36 OMEGA MON II for DB 2 User ’s Guide: CUA Int e rface, V e rsi on 540 Getti ng He lp Help fr om a p anel P anel he lp is availa ble f or all pane ls. T o obt ain help for a pa ne l: I Mov e the cursor to a non -in put fie ld, and p ress F1. Re s u l t : Th e as so cia te d he lp pa nel a ppe ars. Th e wor d Mo re + , More- , or Mo[...]

  • Page 37

    Ge tting S tar ted 37 Ge tt in g H elp Using the Glo s sar y The gloss ar y conta ins defi n i tio ns of terms us ed in OMEGAMON II . Th e gl ossa r y i s ava ilable from any help windo w or from an y panel thro ugh the He lp men u. The re a re thr ee wa ys to a ccess the gl ossary . Sear c hing t he glos sary The glo ssary all ows you to sear ch f[...]

  • Page 38

    Getti ng Help 38 OMEGA MON II for DB 2 User ’s Guide: CUA Int e rface, V e rsi on 540 Help function keys The foll owing ta ble desc r ibe s how funct ion keys work with in the h e l p syste m. Func tion Ke y N ame Assig nment F1 F ie ld level help Displays f ie ld-level he lp if pr essed on an entr y field. Di spla y s panel-level help if pressed[...]

  • Page 39

    Customizing OMEG AM ON II 39 Customi zing OMEGAMO N II Cha pter Con ten ts I ntr oduct i o n . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 0 Spe c if ying P a nel Pr e fer ence s . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 41 Spe c if yin[...]

  • Page 40

    Introd uctio n 40 OMEGA MON II for DB 2 User ’s Guide: CUA Int e rface, V e rsi on 540 In troduc tio n Y ou ca n adjust many feat ur es of th e O M EG A MON envir o nm ent to me et you r wor k an d sy st em r equi remen ts. Al l custo mizati on opti ons ar e avai lable fr om the Opti o n s pull- dow n menu. To a c c e s s t h e O p t i o n s m e [...]

  • Page 41

    Customizing OMEG AM ON II 41 Spe cifying P anel Pr efer enc es Spe cifyin g Panel P referen ce s Use th e P refere n ces pop- up wind ow to cust omize th e appeara nce of infor ma tion on OMEGAM ON II panels. Acc essing the P ref erence s windo w T o access th e P re f erences pop -up w indow : I Sele ct Preferences fro m t he Op ti on s m e nu . R[...]

  • Page 42

    Sp eci fy ing P a nel Preference s 42 OMEGA MON II for DB 2 User ’s Guide: CUA Int e rface, V e rsi on 540 F unction Key Ar ea D isp lays a lis t of the cur rent ly a va ila ble fu nct ion keys a t th e bott om o f the panel. Imp licit Act ion A llows for an im pli cit action fo r select able it em s on a disp lay p anel. If you select On , a def[...]

  • Page 43

    Customizing OMEG AM ON II 43 Specif ying T ermin al Options Spec ifyi ng T ermi nal Opt ions Use the T e rm inal Opti ons pop-u p windo w to custo mize se ttings for th e CU A inter face . Acc essing the T erminal Op tions wind ow T o a cce ss t he T erm ina l O pti ons pop -up wi ndow : I Sele ct Controls fro m t he O pti on s m e nu . Re s u l t [...]

  • Page 44

    Specif ying T erm inal Options 44 OMEGA MON II for DB 2 User ’s Guide: CUA Int e rface, V e rsi on 540 Th e follo wi ng t abl e pro vid es a list of fiel ds a nd val id va lue s for c omp le tin g the S QL Proc es s L ev el fi eld on th e T er m in al O pti on s pa ne l. Idle Status Word W ord you want to appear when OMEGAMON I I is not monitorin[...]

  • Page 45

    Customizing OMEG AM ON II 45 Specif ying T ermin al Options Sa ving T erminal Op tions When y ou finish en tering your te rm inal preferences: I Press En te r . Re s u l t : T he S ave Pro file C onfir ma tion po p-up wind ow appea rs. Sa ving f or curr ent sess ion T o use t he new terminal opti ons o nl y fo r the curre nt ses sion: I Sele ct Sav[...]

  • Page 46

    Sett ing Thr esholds 46 OMEGA MON II for DB 2 User ’s Guide: CUA Int e rface, V e rsi on 540 Sett in g Th resh o lds Use t he Set T hres holds op tion w ind ow to set perf or ma nce stand ard s for your s ubsy stem . Acc essing the Threshold s windo w T o acces s the v arious threshold s wi ndow s using t he Se t Thresho lds opt ion , follo w the[...]

  • Page 47

    Customizing OMEG AM ON II 47 Sett ing Thr esholds Sa ving thresh old v a lu es When y ou finish en tering your threshold v alues : I Press En te r . Re s u l t : T he S ave Pro file C onfir ma tion po p-up wind ow appea rs. Sa ving f or curr ent sess ion T o us e th e new th resh ol d valu es o nly fo r th e cu rre nt ses si on: I Sele ct Sa ve v a[...]

  • Page 48

    As sign in g User A ut horit ies 48 OMEGA MON II for DB 2 User ’s Guide: CUA Int e rface, V e rsi on 540 As sign ing U ser A utho riti es The syst em admi nistr ator at yo ur si te ha s acc ess t o all user and s ubsys tem pr ofile main tenance fun ctions and can per for m prof ile ma inte nance functio ns f or ot her u sers. The sys tem adm inis[...]

  • Page 49

    Customizing OMEG AM ON II 49 M aintaining P rofiles Mai nta i n ing Pr ofile s OM EG AM ON II al low s y ou to sw it ch, c o py , de le te, a nd m od ify us er pro fil es and su bsyst em pr ofi les. Profi le ty pes OM EG AM ON I I us es three d iff erent pr ofile s. Acc essing pro file ma intenan ce Y ou c an pe rf orm pro file main tenance as foll[...]

  • Page 50

    Maintainin g Pr ofiles 50 OMEGA MON II for DB 2 User ’s Guide: CUA Int e rface, V e rsi on 540 T o access th e Subsys tem Profile M aintena nce pane l: I Sele ct S ubs ystem Prof iles from t he O pti ons m enu , an d press En ter . Re s u l t : T he S ubs ystem Profile Mai ntenance panel appe ars. Co pyin g a pr ofil e Y ou c an crea te a n ew us[...]

  • Page 51

    Customizing OMEG AM ON II 51 M aintaining P rofiles Importing a P ro f ile Y ou c an im por t a pro file by copying the par tition ed d atase t mem ber i nto t he p rofile . T he MV S M odify com ma nd fo r im por ting a p rof ile is as follo ws: /F OMII DB2,NTD KD2IMP ‘ PD SN AM E ME M BER P RO FI LE ’ Where PDSNAME is t he nam e of the source[...]

  • Page 52

    Maintainin g Pr ofiles 52 OMEGA MON II for DB 2 User ’s Guide: CUA Int e rface, V e rsi on 540 T o mod ify a profile de script ion: 1. T y p e M ne xt t o the pro fi le wh ose de sc ri pt ion yo u wa nt t o mod ify and pr ess En te r . Re s u l t : T he M odif y De script ion w indow app ears. 2. T ype the ne w descriptio n, and press Ent er . (Y[...]

  • Page 53

    Customizing OMEG AM ON II 53 M aintaining P rofiles I Use i mpo r t ing to rever se t he abo v e pro ce ss to rec reate a pro fil e bas ed o n the e x por ted inf orm ation. Exam ple com mand fo r ex porting a pr of ile Th e MVS M odify c omm and fo r e xpor ting a pro file is a s follo ws: /F OMIIDB2,NTD KD2EXP ‘ PDSNAME MEMB ER PRO FILE ’ Whe[...]

  • Page 54

    Set tin g Fi lt eri ng Opti o ns for Ne ar - T er m T h rea d H isto ry 54 OMEGA MON II for DB 2 User ’s Guide: CUA Int e rface, V e rsi on 540 Set ting Fi l t ering O pti ons fo r Near -T erm Th read H is tory Use the Ne ar - T er m T hr e ad Histor y Filter Opt ions pop -up to specif y the r e por ting p eriod an d filte ring cr iteria for dat [...]

  • Page 55

    Customizing OMEG AM ON II 55 Set tin g Fil terin g O pt ion s for N ea r - T erm T hre ad H ist ory Relative-Star t The number of minutes or hours bef or e t he curr ent ti me on whic h t he r epor ting period begins. Y ou can specify a relative star t instead of a n abs olu te sta r t dat e and ti me. Relative-End The number of minutes or hours af[...]

  • Page 56

    Specif ying Sa ve Options for SQL T ext 56 OMEGA MON II for DB 2 User ’s Guide: CUA Int e rface, V e rsi on 540 Sp eci fyi ng Sa ve Op tion s f or SQL T e xt Use the Sa ve SQL T e xt P ara meters pop-u p window t o sp ecify opti ons fo r savi ng SQ L te xt to a par titio ned d ata set. Acc essing the S a ve SQL T ext P aram eter s windo w T o acc[...]

  • Page 57

    Customizing OMEG AM ON II 57 Us ing th e Calla ble I nte r fa ce Using the Call able Inter face The callable inter face fe ature of OMEGAMON II for DB2, V er si o n 500, lets you make direct calls to th e.EXP com mand o n the OM EGAM ON II com mand s panel wi thout having t o first acc ess TS O . B efo re us i ng th is feat u r e, you shoul d do th[...]

  • Page 58

    Us ing th e Calla ble I nte r fa ce 58 OMEGA MON II for DB 2 User ’s Guide: CUA Int e rface, V e rsi on 540 Setting Up !DB/E XPLAIN Use t he f ollow ing proc ed ure to se t up !DB/ EXPLAIN o n the OMEGA MON II for DB2 Comman ds scr een. Setting Up the CU A Options Use the fol lowi ng pro c e d ur e to s e t up CUA optio ns a n d t o use the ne w [...]

  • Page 59

    Customizing OMEG AM ON II 59 Us ing th e Calla ble I nte r fa ce Sett ing Up the D2/EXPLAIN Options Use the fol lowing pro cedur e to set up the D2 /EXPLAI N optio ns. 2 Fr o m the ma in CU A pa nel , select Options from th e t ask bar a nd pr e ss Enter . The following pop-up appears. 3 Se lect Option 2, Controls, from the po p-up and pr ess Ent e[...]

  • Page 60

    Us ing th e Calla ble I nte r fa ce 60 OMEGA MON II for DB 2 User ’s Guide: CUA Int e rface, V e rsi on 540 Th e follo wi ng t abl e pro vid es a list of f iel ds an d val id va lue s for co mp le tin g the D2/ E XPLAIN Optio n s p anel. 3 S elec t Op tion 8, D2 /E xpl ain P a rame te rs, f ro m this pa ne l an d pre ss En ter . U se the D2/EXPL [...]

  • Page 61

    Customizing OMEG AM ON II 61 Us ing th e Calla ble I nte r fa ce EXPLAINing SQ L Code Use t he fo llow ing p roc ed ure to EXP LA IN S QL . T y pe of Sa ve T ype of s a ve t o b e exec u ted w he n sav ing S QL t ext to th e mem be r speci fie d w ith in t he SQL stat eme nt P D S. V a lues are R EPL AC E a nd APPEND . I REPL ACE writes over an exi[...]

  • Page 62

    Us ing th e Calla ble I nte r fa ce 62 OMEGA MON II for DB 2 User ’s Guide: CUA Int e rface, V e rsi on 540 2 From the m ain CUA p a nel , sele ct Acti ve Thre ads a nd p r e ss E nte r . T he Thread Co nne cted to D B2 panel appears. 3 Select the PL ANNA ME you want and pr ess Enter . The Thread Detail panel appears. If SQL calls ar e being e xe[...]

  • Page 63

    Customizing OMEG AM ON II 63 Us ing th e Calla ble I nte r fa ce 5 Pr e ss the Process SQ L key . Step Act ion GoTo Options Tools Help +------------------------------------------------------------ mm/dd/yy 8:47:27 | SQL Call Being Executed System: D41A | +--------------------------------------+--------------------------------------+ | Thread: Plan [...]

  • Page 64

    Us ing th e Calla ble I nte r fa ce 64 OMEGA MON II for DB 2 User ’s Guide: CUA Int e rface, V e rsi on 540[...]

  • Page 65

    Using OMEGAM ON II 65 Using OMEG AMON II In troduc tio n This chap ter de scr ibes how to use O MEGAMON II. Cha pter Con ten ts Moni toring from t he Sy stem Sta tus P anel . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 66 Syst em Statu s Co mpo n e n t s and R e lated Excep tio n s . . . . . . . . . . . . . . . . . . . . . . .[...]

  • Page 66

    Moni tor ing fr om th e Sys tem St atus P an el 66 OMEGA MON II for DB 2 User ’s Guide: CUA Int e rface, V e rsi on 540 Moni torin g fr om the Syste m Stat us P ane l The Sys tem Stat us panel pro vide s a central po int of contro l for monit oring you r D B2 su bsy ste m. T hro ugh th is pa nel , OME GAMON I I: I in forms y ou via st atus l ight[...]

  • Page 67

    Using OMEGAM ON II 67 Monito ring from the System Status P anel Stat us ind icators A status indica tor is a color b ar or a word (fo r e xam ple, W a rn) tha t r e pr e sents th e perf or ma n ce of you r DB2 su bsyste m. Color termin als c an di spl ay both c o l ors a n d wor d s ; nonco lor ter mina ls can displ ay only words. Th e mea nin g of[...]

  • Page 68

    Moni tor ing fr om th e Sys tem St atus P an el 68 OMEGA MON II for DB 2 User ’s Guide: CUA Int e rface, V e rsi on 540 P erf orming ac tions f ro m t h e S y stem Stat us panel Y ou c an in vestig ate a ch an ge in s tat us for a moni tored o bject by en terin g on e of the se act ion co des. Not e: Not al l acti on c odes appl y to ever y monit[...]

  • Page 69

    Using OMEGAM ON II 69 System St a tus C om ponent s and R e late d Exc e pti ons Sys tem Sta tus Co mponen ts and R elate d Except ions OMEGA M ON II monit ors your DB2 su bsyst em by com p ar ing the perfo rmance of yo u r s ubs ys tem agai nst a set of perfo rmance st anda rds. Th ese s tand a r ds ar e ca lled th r eshol ds. When t he per for ma[...]

  • Page 70

    System Status Component s and R el a ted Exc eptions 70 OMEGA MON II for DB 2 User ’s Guide: CUA Int e rface, V e rsi on 540 IMS e xcep tions The f ollow i ng e xceptio ns appl y to th rea d s re l a ted to IMS con n e ctions . TSO e xceptions The fo llowi ng e xce ption s apply to thread s r el ated to TSO conne ctions. Bac kgrou nd e xceptio ns[...]

  • Page 71

    Using OMEGAM ON II 71 System St a tus C om ponent s and R e late d Exc e pti ons Act ive thr ead excep tions The fo llowi ng e xce ption s apply t o active thr e ads. D D F b y t e s re c e i v e d T R C V T h e a m o u n t o f d a t a r e c e i v e d b y a r e q u e s t o r ( a l l i e d ) o r s e r v e r (dist ributed ) DB2 thread in response to [...]

  • Page 72

    System Status Component s and R el a ted Exc eptions 72 OMEGA MON II for DB 2 User ’s Guide: CUA Int e rface, V e rsi on 540 Inact ive thread exceptio ns The fol low ing e xcepti ons a pply to i nacti ve t h r ead s. A n i nacti ve t h r ead does not h o ld an y cursor s or da tabas e r e so ur c es, b ut r e mai ns co nnected to DB2 . Bu ffer po[...]

  • Page 73

    Using OMEGAM ON II 73 System St a tus C om ponent s and R e late d Exc e pti ons EDM pool exc ept ion s The follo wing e xce ption s apply to EDM pool resources. Loc k stat istics e xcept ions The follo wing exce ption appl ies to lock s tatistics resources. Log mana ger e xceptio n s The fo llowi ng e xce ption s apply t o log m anager r e sources[...]

  • Page 74

    System Status Component s and R el a ted Exc eptions 74 OMEGA MON II for DB 2 User ’s Guide: CUA Int e rface, V e rsi on 540 DB 2 ac t ivi ty ex cep ti ons The follo wing e xce ption s apply to DB2 a ctivity ale rt s. Loc k e xceptions The fo llowi ng e xce ption s apply t o lock aler ts. DDF send rate DSND The amount of data sent t o a requestor[...]

  • Page 75

    Using OMEGAM ON II 75 System St a tus C om ponent s and R e late d Exc e pti ons Act ive trace e xcepti ons The fo llowi ng e xce ption s apply t o active trace aler ts. V olu me ac ti vit y exce p tio ns The fo llowi ng e xce ption s apply to v olum e activit y aler ts. Stor ed proce d ures exc ept ion s The follo wing e x cept ions apply to store[...]

  • Page 76

    System Status Component s and R el a ted Exc eptions 76 OMEGA MON II for DB 2 User ’s Guide: CUA Int e rface, V e rsi on 540 T riggers e xceptions Th e fo ll owi n g exce pt ion s ap ply t o a ler ts rela tin g to tr igg er s. Use r-def ined fu nction s ex c eption s The fo llowi ng e xce ption s apply to us er -de fine d function s. Nu mber of s[...]

  • Page 77

    Using OMEGAM ON II 77 I nve stig ati ng a n Ac tive Thr eads Al er t In ve stig ating an A ctive Th read s Aler t In tro du cti onT h is i s an ex amp le o f ho w yo u m ig ht in ve st igat e a re d lig ht f rom th e S yste m Status pane l. Y ou can use this infor ma tion to he lp you u nde rstand h ow to use the f eatures of O MEG AMO N to r e sol[...]

  • Page 78

    Evalua t ing and Modifying Thr esholds 78 OMEGA MON II for DB 2 User ’s Guide: CUA Int e rface, V e rsi on 540 Ev aluat ing and Mod i f ying Thresh olds When y ou inve stigate a yellow or red stat us light from the System Statu s panel, you m ay det er mi ne th at the thr e s h o ld va l ues t h at c aused the e xceptio n to tri p d id not r eall[...]

  • Page 79

    Using OMEGAM ON II 79 Evalua ting and Modif ying Thr esholds Ad ding or mo dify in g rule s Y ou can sp ecify ru les for an e x ception con dition to c ontrol ho w t he th r es holds are ap plied. T o add o r modi f y a r ule f or an e xce p t ion: I Sele ct an e xc eptio n with the R (Rules ) action co de, an d pr e ss Ente r . Re s u l t : Th e R[...]

  • Page 80

    R eview ing Nea r - T erm His tory Dat a 80 OMEGA MON II for DB 2 User ’s Guide: CUA Int e rface, V e rsi on 540 Re v iewing Nea r -T erm Histor y Data Nea r -term his to r y panel s p rov ide i nforma tio n ab out D B2 s ubsys tem act ivi ty an d abo ut comp leted th re a d e x ecutio ns. Y ou can use ne ar -t erm histor y pane ls to quickly g a[...]

  • Page 81

    Using OMEGAM ON II 81 R e vie wi ng Ne ar - T erm Histo ry Da ta Thr ead act ivity f or a r eport interv al Y ou als o ca n vie w su mmar ized infor matio n abo ut t hr ead act ivity for a s ingle repor t inter v al. T o ac c e ss t h r ead act ivi ty fo r a singl e int erval: I Sel ect an in ter v al w ith the I (S ubi nt erval ) a ct ion c ode , [...]

  • Page 82

    Using t h e OM EG AMON II for DB2 Ba ckgro und Applicatio n T race F acility 82 OMEGA MON II for DB 2 User ’s Guide: CUA Int e rface, V e rsi on 540 Using the OMEGAM ON I I f or DB2 Bac kgr ound Application T race F acility T he ba ckg rou nd a ppl ic atio n t ra ce faci li ty pro vi des I the abil ity to sta rt a n ap plicat ion trac e to run in[...]

  • Page 83

    Using OMEGAM ON II 83 Using the OMEG AMON I I for DB2 Background A pplication T ra ce F a cil ity If y ou do n ot ent e r a star t tim e f or the b ac kg rou n d tr ac e, O ME GA MO N II i nf or ms y ou by mea ns of a pop-up pa nel tha t the trace w ill star t immed iately . Y ou ca n choos e to begin th e tr ac e o r to retu r n to th e p revi o u[...]

  • Page 84

    Using t h e OM EG AMON II for DB2 Ba ckgro und Applicatio n T race F acility 84 OMEGA MON II for DB 2 User ’s Guide: CUA Int e rface, V e rsi on 540 Act ivities y ou can perfo rm in a ba ckg round trace reque st Wh en you s elec t a tra ce fr om th e lis t of t rac es o n th e D efe r red A ppli cat io n T r aces p ane l, OM EGAMON II displa ys a[...]

  • Page 85

    Using OMEGAM ON II 85 Us ing th e IFC ID T race F a cili ty Usin g th e IFC ID T r ace Faci lity Overvie w The IF CID T race faci lity p rov ides th e abil ity to start an I FCID tr ace to ru n in the bac kgroun d asynchro nously t o y our O MEGAM ON I I session. Y ou can in itiat e t he IFC ID t race fr om the OMEGAMON II for DB2 System Sta tus pa[...]

  • Page 86

    Us ing th e IFCID T rac e F aci lit y 86 OMEGA MON II for DB 2 User ’s Guide: CUA Int e rface, V e rsi on 540 A t the poin t when you ente r option S to selec t the IFCIDs (w h eth er by t race type, t race cl a s s, or IFCID r eco rd) and to start the IFCI D t race, OMEGAMON II fo r DB2 asks yo u to con fir m your s electio n. If yo u choo se to[...]

  • Page 87

    Using OMEGAM ON II 87 Us ing th e IFC ID T race F a cili ty Stop pin g an IFCI D T ra ce T o sto p the IFCID T race fa cility , fol low thes e steps : I en ter option T (T ools ) to di splay t he T o ols pull- down me nu. I en ter option 3 (IF CI D T ra ce F ac ili ty) to d isp la y the IF CI D T rac e p ul l-do wn me nu. I en ter option 3 (Stop IF[...]

  • Page 88

    Us ing th e IFCID T rac e F aci lit y 88 OMEGA MON II for DB 2 User ’s Guide: CUA Int e rface, V e rsi on 540[...]

  • Page 89

    Us in g OM EGAM ON I I f or D B2 wi th !D B /E XP L AI N 89 Using OMEGAMON II f o r DB2 with !DB/EXPLAIN In troduc tio n By i nt egrati ng the two Ca ndle pro ducts, O M EG AMON II for DB 2 an d !DB/EXPLAIN, y ou crea te t he m os t co mpl ete vie w p os sib le fo r und er sta ndi n g an d op tim i zin g SQ L an d DB 2 ap plication s. The combina t[...]

  • Page 90

    Backgr ound about !DB/EXPLAI N for DB2 90 OMEGA MON II for DB 2 User ’s Guide: CUA Int e rface, V e rsi on 540 Backg r o und ab out !DB/ EXP LA IN for D B2 Th is se ction p rovid es a n over view of the !D B/E XP LAI N funct ionali ty . Func ti ons provided by !DB/ E XPLAI N for DB2 !D B/EXPL AIN prov ides a win dow into the op erati on of D B2. [...]

  • Page 91

    Us in g OM EGAM ON I I f or D B2 wi th !D B /E XP L AI N 91 Using OMEG AMON II and !DB/EXPLAIN Co mpl e mentary F unctions Us ing OMEGA M O N II a nd !DB/EXP LAIN Compl emen tary Fu nction s This secti on desc ribes the fu nc tions of ! DB/EX PL AIN a nd OMEGAMON II for D B2 t hat work tog ether to help im prove DB 2 per form ance, and sug gests wa[...]

  • Page 92

    Using OMEG AMON II and ! DB/EXPLAIN Complementary F unctions 92 OMEGA MON II for DB 2 User ’s Guide: CUA Int e rface, V e rsi on 540 I In a r e view of a n ap plication, !DB/EXP L AIN hi ghlig hts som e potent ially poorly-per fo rm ing acce ss p aths and you wa nt more detail abo ut a ctual execut ion.[...]

  • Page 93

    Us in g OM EGAM ON I I f or D B2 wi th !D B /E XP L AI N 93 Usi ng t he OMEG AMO N II for DB 2 Calla ble I nterfac e Using the OMEG AMON II for DB2 Ca lla ble Inter face The call able i nterface featur e o f OMEGAMON II f or D B2 lets yo u make d ir e ct call s to !DB/ EXPLAIN withou t fir st h avi n g to acc ess T SO . Bef o r e u s i ng this feat[...]

  • Page 94

    Us ing th e OMEG AM ON I I for DB 2 Cal lab le Inte r fa ce 94 OMEGA MON II for DB 2 User ’s Guide: CUA Int e rface, V e rsi on 540 2 Pre ss E nter . Re su l t : The system displays the Classic Inter face - DB/EXPL AIN panel. 3 Sp eci fy th e ap pro priat e inf or mat ion on th e Cl assic I nte r face - DB /EXP LA IN p an el an d press Enter . Re[...]

  • Page 95

    Us in g OM EGAM ON I I f or D B2 wi th !D B /E XP L AI N 95 Usi ng t he OMEG AMO N II for DB 2 Calla ble I nterfac e Setting Up !DB/E XPLAIN Use t he f ollo wing proc ed ure to se t up !DB /E XPL AI N fo r OM EGAMON II for DB2 . Setting Up the CU A Options Use the fol lowi ng pro c e d ur e to s e t up CUA optio ns a n d t o use the ne w !DB/EXPLAI[...]

  • Page 96

    Us ing th e OMEG AM ON I I for DB 2 Cal lab le Inte r fa ce 96 OMEGA MON II for DB 2 User ’s Guide: CUA Int e rface, V e rsi on 540 Usin g the T ermi nal O ptions Wind ow The follo wing tabl e de scribes the fie lds o n th e T erm in al Op tions pop-up win dow . 3 S elect option 2, Controls, from the pop-up and press Enter . U se the fields on th[...]

  • Page 97

    Us in g OM EGAM ON I I f or D B2 wi th !D B /E XP L AI N 97 Usi ng t he OMEG AMO N II for DB 2 Calla ble I nterfac e V a lues f or th e SQ L Proc es s Le vel a re desc rib ed i n the fol lowi ng ta b le. Th e follo wi ng t abl e pro vid es a list of fiel ds a nd val id va lue s for c omp le tin g the S QL Proc es s L ev el fi eld on th e T er m in [...]

  • Page 98

    Us ing th e OMEG AM ON I I for DB 2 Cal lab le Inte r fa ce 98 OMEGA MON II for DB 2 User ’s Guide: CUA Int e rface, V e rsi on 540 Sett ing Up the D2/EXPLAIN Options Use the fol lowing pro cedur e to set up the D2 /EXPLAI N optio ns. SA VE /EXPL AIN U se this opt ion to per for m SA V E and EX PLA IN functions. Co mplete the req uired fi eld s f[...]

  • Page 99

    Us in g OM EGAM ON I I f or D B2 wi th !D B /E XP L AI N 99 Usi ng t he OMEG AMO N II for DB 2 Calla ble I nterfac e Using th e D2/EXPLAIN Options Pan el Th e follo wi ng t abl e pro vid es a list of f iel ds an d val id va lue s for co mp le tin g the D2/ E XPLAIN Optio n s p anel. Field Des cription Ex trac t Id 1– to 8 –ch ara cter f iel d t[...]

  • Page 100

    Us ing th e OMEG AM ON I I for DB 2 Cal lab le Inte r fa ce 100 OMEGAMON II for DB2 User ’ s Guide: C UA Int er face, V ersion 540 EXPLAINing SQ L Code Use t he f ollow ing proc ed ure to pro ces s SQ L from th e Th r ead De tail p anel . Initi al Repo rt T ype th e nam e of t he init ial !DB /EXPL AIN repo r t to be displ ayed: E STMT , EP ATH, [...]

  • Page 101

    Using OMEG AMON II for DB2 with ! D B/EXPLAI N 101 Usi ng t he OMEG AMO N II for DB 2 Calla ble I nterfac e 3 Sel ec t th e P LA NN A ME y ou wan t a nd pres s E nte r . Re s u l t : The system displays the Thread Detail panel. If SQL calls are being exe cuted by the thr e ad, the me ssage (IN-SQL-CALL) also appears. The Th r e ad Detail panel show[...]

  • Page 102

    Moving I nteractive ly between !DB/EXPLAIN and OMEG AMON II 102 OMEGAMON II for DB2 User ’ s Guide: C UA Int er face, V ersion 540 Mo vi ng Int eract ivel y betw een ! DB/EXP LAIN and OM EGAMON I I Th is un it te lls y ou h ow to m o ve i nte ra c tive ly b et we en O MEG A M ON II f or DB 2 an d !DB/EXPL AI N using the co py -a nd-paste fa cilit[...]

  • Page 103

    Using OMEG AMON II for DB2 with ! D B/EXPLAI N 103 Moving I nterac tively be tween !DB/EXPLAIN and OMEGAM ON II – T o use th e A (Appl icati on T race F acil ity) Se lect, y ou must have p r evi o u sly run a n A T F t rac e fo r t he plan s of i nte rest a nd plac ed t he re su lts int o a data se t. – T o us e t he P ( Pla n Acc oun ting) S e[...]

  • Page 104

    Usin g t he Co py-a nd-P aste F ac ilit y in OM EG A M ON I I 104 OMEGAMON II for DB2 User ’ s Guide: C UA Int er face, V ersion 540 Using the Copy-and -P a ste Facil ity in OMEGAM ON I I This unit desc ribes h ow to use the co py -a nd -paste facility in O MEGA MON II to capt ur e static or dynam ic SQL a nd mov e it t o !DB/EX PL AIN fo r a nal[...]

  • Page 105

    Using OMEG AMON II for DB2 with ! D B/EXPLAI N 105 Us ing t he Copy -and - P ast e F aci lit y in OM EG AMON I I Cap turin g SQL using the A T F Y ou can use the O MEGAMON II A T F to captu re SQ L state ments and move them to !DB/EXPL AI N usin g t he copy-and-paste f acility . F o llow these summ ary steps. St e p Act ion 1 F rom t he Ap plicat i[...]

  • Page 106

    Accessing OMEG AM ON II T rac e In formation fr om !DB/EXPLAIN 106 OMEGAMON II for DB2 User ’ s Guide: C UA Int er face, V ersion 540 Accessing OME G AMON II T race Inf o r mation fr om !DB/EXPLAIN Th is unit desc ribes how you can o btain O MEGAM ON II Applica tion T r ace a nd Acco untin g Repor t info rm ation when yo u ar e working in !DB/EXP[...]

  • Page 107

    Using OMEG AMON II for DB2 with ! D B/EXPLAI N 107 Acce ss ing OM EG A MO N II T rac e I nfo rma tion from !DB /E XPLA IN Source s of info rmat ion Ref er to the ta bl e for sourc e s of info r ma tion abo u t the OMEG A MON II for DB2 App lication T race F acility and Acco unting Re por ts. A cce ss th e OME GA M ON II Accountin g Repor ts F ac il[...]

  • Page 108

    Accessing OMEG AM ON II T rac e In formation fr om !DB/EXPLAIN 108 OMEGAMON II for DB2 User ’ s Guide: C UA Int er face, V ersion 540[...]

  • Page 109

    109 P anel Na vigation Flo wcharts In troduc tio n The flowc harts in this appe ndix docu ment the pan e l s avai l a ble for mon itoring D B 2. They provi de a n ov er view o f the ma in navig ation paths in O MEG AMO N. Y ou can use these f lowc hart s to h el p yo u und ers ta nd ho w to a cce ss t he pane ls y ou n ee d in ord er to an al yze a[...]

  • Page 110

    Flo wchar t Conv ention s 110 OMEGAMON II for DB2 User ’ s Guide: C UA Int er face, V ersion 540 F lo wch art Con vent ion s The foll owing table des cribes el ements i n the naviga tion dia grams. Syst em S tatu s pane l The OM EGAM ON S ystem Status pan el show s perf orm ance fo r all m onito r ed DB 2 subs ystem compo n e nts and app l ic ati[...]

  • Page 111

    111 Flowc hart Conv enti ons FIGURE 1. OMEGA MON II f o r DB2 System St atus P anel T o find out how to nav igate to a par ti cular p anel or g rou p of panels , star t with t he Syst em Sta tus panel a nd then g o to the let ter r eprese nting the g roup of p anels you w ant . A cti on s G o T o O pti o ns T oo ls He lp Workloads Resources Aler ts[...]

  • Page 112

    Wo r k l o a d s Pan e l s 112 OMEGAMON II for DB2 User ’ s Guide: C UA Int er face, V ersion 540 W or kload s P an els The next two figures show how you can access the r ea ltime an d near-t er m histor y pa nels for the ob jects from t he W orklo ads por tio n of the Syst em Statu s pane l. F or realti me in fo r mation , us e the S ( Sh ow de [...]

  • Page 113

    113 W orkload s P anels FIGURE 2. W orkloads Panels (Realtime) System Status __C ICS __IMS __TS O __Background __U ti l ities __D istrib uted __Stored Pro cs __All Co nnections Workloads A X A ctions Acti ons GoT o GoT o GoT o GoT o GoT o Go T o GoT o GoT o CICS Connect ions CICS RCT Summar y CICS RCT Detai l CICS Thread Summar y IMS Connect ions I[...]

  • Page 114

    Wo r k l o a d s Pan e l s 114 OMEGAMON II for DB2 User ’ s Guide: C UA Int er face, V ersion 540 FIGURE 3. W orkloads Panels (Near -term history) System Status __CICS __IMS __TS O __Background __ Util ity __Distributed __All Co nnections Workloads Y T hre ad H ist or y by Repor t In terval Threa d Hi stor y by Su bint er v al Thr ead Hi story Su[...]

  • Page 115

    115 R esources P anels Re sour ces P a nels The next two figures show how you can access the r ea ltime an d near-t er m histor y pa nels f or o bje cts fro m the R esour ces p o r tion of th e Sys tem St atus p anel. F or r eal time infor ma tion, u se t he S (Sho w de tails ) act ion code . F or nea r -ter m his tor y in for mat ion, do th e fo l[...]

  • Page 116

    R esources P anels 116 OMEGAMON II for DB2 User ’ s Guide: C UA Int er face, V ersion 540 FIGURE 4. Resources P a nels (Realtime) System Status __Bu ff er Mg r __EDM P oo l __Lock St ats __Log Man ager __DDF Stats __Bi nd Stats __SSS Sta ts __SQ L Stats __Open/ Close Stats __Comm and S tats R esources B Buf f er P o ol Sn apsh ot Open Pa ge s e t[...]

  • Page 117

    117 R esources P anels FIGURE 5. Resources P a nels (Near-T erm Hi story) Buf f er P o ol Statis tics Su mmary by Repor t EDM Pool S tat istic s by Repor t L ock M ana ge r Statis tics Su mmary by Repor t Log Ma nage r Statis tics Su mmary by Repor t DDF Stati s tics Su mmary by Repor t Bind Stati stics Summa r y by Repor t Subs ystem Su ppor t Man[...]

  • Page 118

    Alert s P ane ls 118 OMEGAMON II for DB2 User ’ s Guide: C UA Int er face, V ersion 540 Aler ts Panels Y ou can acces s the fo llo wing pane ls by selec tin g a moni tor e d object fr om the Al erts por tion of the Sys tem Stat us panel.[...]

  • Page 119

    119 Aler ts P ane ls FIGURE 6. Alerts P anels Sy stem St at us __DB2 Activi ty __Active Threads __Inactive Threads __Locks __Active T races __V olum e Activity __DB2 Messag es __T rig gers __User functions __Stored P roc __Syspl ex P aral l el Ale r t s C X Lo ck Manager Statist i c s Buff er Manag er Buff er P ool Statist ics Detail B uffer P o ol[...]

  • Page 120

    Installation P a rameters P an els 120 OMEGAMON II for DB2 User ’ s Guide: C UA Int er face, V ersion 540 Insta llatio n Parame ters P ane ls Y ou c an a ccess t he f ollowing panels by s elect ing G oT o from th e S ystem Stat us p anel.[...]

  • Page 121

    121 Insta llat ion P aram eters P anels FIG URE 7. In stallati on P arameter s P anels Sy stem S tatus 1. DSNZP A RM Thread P ar ms 2. DSNZP A RM T race P arm s 3. DSNZP A RM Archiving and Logging P ar ms 4. DSNZP A RM Access, RLF , a nd D DF P ar ms 5. DSNZP A RM IRLM and Dat a Shari ng Parms 6. DSNZP A RM Storage P arm s 7. DSNZP A RM Dataset and[...]

  • Page 122

    Applica tion T ra ce F acility P anels 122 OMEGAMON II for DB2 User ’ s Guide: C UA Int er face, V ersion 540 Appli catio n T rac e F ac ility Panels Y ou c an a ccess t he f ollowing pa nels by s electing T ools , an d th en sel ecting Appl icatio n T rac e F ac ilit y f rom the Sys tem Stat us panel .[...]

  • Page 123

    123 Applica tion T race F a cility P ane ls FIGURE 8. Applicatio n T race Facility P anels Syst em St atu s 1. Spec ify foreground tr ace c ollection options. 2. Stop fore g r ound tr ace. 3. View foreground trace summa ry from stora ge. 4. View foreground trace summa ry from datase t. 5. Spec ify background tr ace colle ction option s. 6. Disp la [...]

  • Page 124

    Ob ject A nal ysis P ane ls 124 OMEGAMON II for DB2 User ’ s Guide: C UA Int er face, V ersion 540 Objec t A nalysis P anels Y ou can a ccess t he fo llowin g pa nels by s electing T oo ls, and the n se lecting Obje ct An alysis.[...]

  • Page 125

    125 Object Analysis P anels FIGURE 9. Object Analysis P an els System Status 1. Object A lloca tion Sum mary 2. Obj ect Activity Su mmar y 3. V olum e Activi ty Summar y 4. Da taset Ex tend Activity 5. S tar t Obj ect Allocatio n Collection 6. Stop O bject Al location Col lection 7. Displa y Opt ions Action Sel ection F Object Acti vity Sum mary D [...]

  • Page 126

    Thr e ad Detail GoT o P a nels 126 OMEGAMON II for DB2 User ’ s Guide: C UA Int er face, V ersion 540 Threa d Deta il GoT o P ane ls Y ou c an a ccess t he f ollowing realtim e th r e ad de tail pane ls by usin g the GoT o pull-do wn menu fr om ei t her the Thr ead Detai ls panel or the Di stribute d T hr e a d Deta il p a nel. Y ou c an a ccess [...]

  • Page 127

    127 Thre ad Det ail GoT o P anels FIGURE 1 0. Thread Detail GoT o P anels (Realtime) 1. Th rea d Lo ck Infor mat io n 2. Cur r ent SQ L Coun ts 3. S QL Ca ll Be ing Ex ecut ed 4. Threa d Buf f e r P o ol Acti vity 5. Thr ead Re source Li mits 6. Dis tr ibu ted D eta il 7. Th rea d Packag e Sum mar y 8. Uti lit y Deta il 9. Paralle l T ask Sum mar y[...]

  • Page 128

    Thr e ad Detail GoT o P a nels 128 OMEGAMON II for DB2 User ’ s Guide: C UA Int er face, V ersion 540 FIGURE 11. Thread History Deta il GoT o Panels (Near -T er m History) 1. Th rea d Lo ck Infor mat io n 2. Cur rent SQL Cou nts 3. S QL Ca ll Be ing Ex ecut ed 4. Threa d Buf f e r P o ol Acti vity 5. Thr ead Re source Li mits 6. Dis tr ibu ted D [...]

  • Page 129

    129 Sym bols !DB /E XPL A IN setting up CUA opt ions 95 setup CUA o pti ons 96 setup for OMEGAMON II 95 SQ L process level 97 T ermina l Options pop-up 97 ! DB/ EXPLAI N and OMEGAM ON II moving between products 10 2 ! DB/ EXPLAI N and OMEGAM ON II f o r DB2 91 comb ining f unction s 89 sample situations 91 !DB/EXPL AIN, functions 90 !DB /E XPL AIN [...]

  • Page 130

    130 OMEGAMON II for DB2 User ’ s Guide: C UA Int er face, V ersion 540 documentation conventions 10 dynamic pr of ile update facility 52 E EDM poo l e xceptions 73 e x cepti on recommendations 77 e xceptions 69 acti ve th re ad 71 acti ve tra ce 75 ana lyz ing 77 backgr ound 70 buffer pool 72 CICS 69 DB2 a ctivi ty 74 DDF statistics 73 distribute[...]

  • Page 131

    131 moving be t ween !DB/ EXPLA IN and OME GAMON II 102 N national language 41 navigation fas t pathi ng 29 flo w charts 109 near -term histor y panels 115 , 117 No r m al St atu s W ord 96 O object analysis panels 124 OMEGAMON II profil e to migrat e 22 OMEGA V IEW trig ger k ey 24 zooming to OMEGAMON II 21 optimizing SQL and D B2 applications 89 [...]

  • Page 132

    132 OMEGAMON II for DB2 User ’ s Guide: C UA Int er face, V ersion 540 col ors 67 de fi nitio n 67 specifying 43 status words specifying 43 stop pin g IF CID tr ace fa cili lty 87 subsystem profile 22 switc hing a pro file 52 system administrator 48 System St atus panel mon ito re d c ompo ne n t s 66 panel par ts 25 system status panel navigatin[...]