Instruction/ maintenance manual of the product Network Adapter DB2 Candle
Go to page of 132
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.
3 Li st of F igur es . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 P re f a ce . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
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 . . . . . . . . . . . . . .
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) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
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 .
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.
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.
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.
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.
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 .
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 .
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.
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 . . . . . . . . . . .
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.
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.
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 .
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).
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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 .
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.
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 .
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.
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 . . .
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.
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 .
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.
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 .
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.
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 .
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 .
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.
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.
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.
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.
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 .
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.
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.
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 re.
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.
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.
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 .
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.
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 .
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 .
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.
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 .
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/.
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.
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.
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.
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.
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.
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.
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 .
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.
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.
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.
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.
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.
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 u.
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 .
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.
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.
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 App.
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 .
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 t.
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.
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.
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.
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.
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 sect.
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 .
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 .
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 .
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 .
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.
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.
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.
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 .
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.
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 .
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.
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 .
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 .
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 .
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.
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.
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.
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 .
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.
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 .
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 __ U.
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 .
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 a.
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 Rep.
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 func.
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.
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.
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.
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.
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.
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.
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 betwee.
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 .
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 a.
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 .
An important point after buying a device Candle Network Adapter DB2 (or even before the purchase) is to read its user manual. We should do this for several simple reasons:
If you have not bought Candle Network Adapter DB2 yet, this is a good time to familiarize yourself with the basic data on the product. First of all view first pages of the manual, you can find above. You should find there the most important technical data Candle Network Adapter DB2 - thus you can check whether the hardware meets your expectations. When delving into next pages of the user manual, Candle Network Adapter DB2 you will learn all the available features of the product, as well as information on its operation. The information that you get Candle Network Adapter DB2 will certainly help you make a decision on the purchase.
If you already are a holder of Candle Network Adapter DB2, but have not read the manual yet, you should do it for the reasons described above. You will learn then if you properly used the available features, and whether you have not made any mistakes, which can shorten the lifetime Candle Network Adapter DB2.
However, one of the most important roles played by the user manual is to help in solving problems with Candle Network Adapter DB2. Almost always you will find there Troubleshooting, which are the most frequently occurring failures and malfunctions of the device Candle Network Adapter DB2 along with tips on how to solve them. Even if you fail to solve the problem, the manual will show you a further procedure – contact to the customer service center or the nearest service center
