Manuale d’uso / di manutenzione del prodotto DB2 del fabbricante Candle-lite
Vai alla pagina 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 . . . . . . . . . . . . . . . . . . . . . 8 9 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 : The Save Profi le Con firma tion pop-up w indow app ears.
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 : The Sub syst em Prof ile M aintena nce pan el a ppears.
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 titioned dat ase 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 : The Mod ify Descr iption wind ow a ppea rs.
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 tri gg 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 nd tra c e, OM E GAM O N II i nfo r 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 XPL AI N fu nction ali ty .
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 Detai l pa nel . If SQL calls are being executed 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 Pa n 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 Pa n 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 __ .
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 All ocat ion S umma r y 2. Obj ect Activity Su mmar y 3. V olum e Activi ty Summar y 4. Datas et Extend Ac tivity 5. Star t O bject Alloc ation 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 Lock I nfor mat io n 2. Cur ren t SQ L C oun 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 ibut ed De ta 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 Lock I nfor 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 .
Un punto importante, dopo l’acquisto del dispositivo (o anche prima di acquisto) è quello di leggere il manuale. Dobbiamo farlo per diversi motivi semplici:
Se non hai ancora comprato il Candle-lite DB2 è un buon momento per familiarizzare con i dati di base del prodotto. Prime consultare le pagine iniziali del manuale d’uso, che si trova al di sopra. Dovresti trovare lì i dati tecnici più importanti del Candle-lite DB2 - in questo modo è possibile verificare se l’apparecchio soddisfa le tue esigenze. Esplorando le pagine segenti del manuali d’uso Candle-lite DB2 imparerai tutte le caratteristiche del prodotto e le informazioni sul suo funzionamento. Le informazioni sul Candle-lite DB2 ti aiuteranno sicuramente a prendere una decisione relativa all’acquisto.
In una situazione in cui hai già il Candle-lite DB2, ma non hai ancora letto il manuale d’uso, dovresti farlo per le ragioni sopra descritte. Saprai quindi se hai correttamente usato le funzioni disponibili, e se hai commesso errori che possono ridurre la durata di vita del Candle-lite DB2.
Tuttavia, uno dei ruoli più importanti per l’utente svolti dal manuale d’uso è quello di aiutare a risolvere i problemi con il Candle-lite DB2. Quasi sempre, ci troverai Troubleshooting, cioè i guasti più frequenti e malfunzionamenti del dispositivo Candle-lite DB2 insieme con le istruzioni su come risolverli. Anche se non si riesci a risolvere il problema, il manuale d’uso ti mostrerà il percorso di ulteriori procedimenti – il contatto con il centro servizio clienti o il servizio più vicino.
