Candle Network Adapter DB2 manuel d'utilisation

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.[...]

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[...]

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

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[...]

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) . . . . . . . . [...]

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

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[...]

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 [...]

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[...]

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.[...]

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[...]

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[...]

13[...]

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

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[...]

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[...]

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 [...]

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

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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 [...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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 [...]

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[...]

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[...]

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 [...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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 [...]

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[...]

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[...]

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[...]

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 [...]

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[...]

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 [...]

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[...]

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[...]

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 [...]

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[...]

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 . . . . . . . . . . . . . . . . . . . . . . .[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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 [...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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 , [...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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. [...]

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[...]

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.[...]

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[...]

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[...]

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[...]

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[...]

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 [...]

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[...]

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[...]

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, [...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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 [...]

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[...]

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[...]

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[...]

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[...]

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[...]

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.[...]

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[...]

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.[...]

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[...]

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 .[...]

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 [...]

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.[...]

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 [...]

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 [...]

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[...]

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 [...]

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 [...]

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[...]

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 [...]

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[...]