ࡱ> jliM bjbj== h>WW l 4 hLj< [nt&1HO[Q[Q[Q[Q[Q[Q[$>] ^_u[ yyyu[q [qqqy  O[qyO[qZq" R [Z 3  pX[Z[0[oY`q`[Zq nhShowElementInfo Functional Specification Create Date:  CREATEDATE \@ "MMMM d yyyy" \* MERGEFORMAT October 31 2002 Last Modified Date:  DATE \@ "MMMM d yyyy" \* MERGEFORMAT October 31 2002 Version  DOCPROPERTY "Version" \* MERGEFORMAT 1.0 Prepared By: Joe W. Kuefler AUTHOR\* Caps \* MERGEFORMAT  Copyright  DATE \@ "yyyy" \* MERGEFORMAT 2002 Concord Communications, Inc. 600 Nickerson Rd. Marlborough, MA 01752 All Rights Reserved Legal Copyright  DATE \@ "yyyy" \* MERGEFORMAT 2002 Concord Communications, Inc. All rights reserved. The information provided in this document is the proprietary and confidential information of Concord Communications, Inc. (Concord). You may use this information solely for your internal evaluation as requested by Concord. This information is subject to change at any time without notice, and Concord makes no representation, warranty or covenant regarding this information or any software or other products related thereto. Revision History DateAuthorComments CREATEDATE \@ "M/d/yyyy" \* MERGEFORMAT 10/31/2002Joe KueflerVersion 1.0Related Documents  HYPERLINK "http://janeway.concord.com/CS/sol/23597/NH_MANAGE_STAT_DUPS.html" http://janeway.concord.com/CS/sol/23597/NH_MANAGE_STAT_DUPS.html  TOC \o "3-3" \h \z \t "Heading 1,1,Heading 2,2"  HYPERLINK \l "_Toc23836490" 1 Introduction  PAGEREF _Toc23836490 \h 4  HYPERLINK \l "_Toc23836491" 1.1 Glossary of Terms  PAGEREF _Toc23836491 \h 4  HYPERLINK \l "_Toc23836492" 1.2 Intended Audience  PAGEREF _Toc23836492 \h 4  HYPERLINK \l "_Toc23836493" 1.3 Overview  PAGEREF _Toc23836493 \h 4  HYPERLINK \l "_Toc23836494" 2 Product Requirements Summary  PAGEREF _Toc23836494 \h 5  HYPERLINK \l "_Toc23836495" 2.1 Product Requirements  PAGEREF _Toc23836495 \h 5  HYPERLINK \l "_Toc23836496" 2.2 Gets  PAGEREF _Toc23836496 \h 5  HYPERLINK \l "_Toc23836497" 2.3 Dont Gets  PAGEREF _Toc23836497 \h 5  HYPERLINK \l "_Toc23836498" 3 Testing Requirements  PAGEREF _Toc23836498 \h 6  HYPERLINK \l "_Toc23836499" 3.1 System Requirements  PAGEREF _Toc23836499 \h 6  HYPERLINK \l "_Toc23836500" 3.2 Data Requirements  PAGEREF _Toc23836500 \h 6  HYPERLINK \l "_Toc23836501" 3.3 Key Areas for Testing  PAGEREF _Toc23836501 \h 6  HYPERLINK \l "_Toc23836502" 3.4 Performance and Scalability Issues  PAGEREF _Toc23836502 \h 6  Introduction Reporting tool for Poller Team, SWAT Team and DB Team to research poller data in the STATS tables. Glossary of Terms TermDefinition$NH_MANAGE_STAT_DUPSNew feature that insulates customers from duplicate stats data by creating non-unique indexes where our rollup (or indexing) jobs would normally have failed. This feature leverages the same CDB libraries extensions that make nhShowElementInfo possible. Thus, nhShowElementInfo can be used to validate the reporting aspects of $NH_MANAGE_STAT_DUPS.nhiIndexStatseHealth jobs that creates indexes on the NH_STATS0 sushi table that hold raw poller datanhiRollupDbeHealth jobs that rolls NH_STATS data into higher numbered NH_STATS tables. Intended Audience The audience for this document includes : Technical Support to direct customers to run this reporting utility. Poller Team to understand the output and help refine their needs. SWAT Team to avoid having to request large dumps of STATS data. Database Team who usually deal with STATS data problems, since they are typically data-integrity related. Overview We have a problem analyzing STATS data at customer sites because we are typically only interested in aa few hundred rows out of potentially millions. In order for the STATS data to be meaningful, we typically also need their poller config data, too. Duplicate stats data is an epidemic problem with eHealth. Tools like nhShowElementInfo is one step towards solving the root causes to duplicate stats data. Product Requirements Summary Product Requirements Ability to run this utility while eHealth is running and without impairing the performance or uptime of eHealth. Cannot produce any side-effects to eHealth. Gets ASCII-style report to standard output. Ability to specify any elementId in the system Ability to specify any relevant time period for which we want to examine the stats data. Easy way for QA (or developers) to test the report, without having to determine a valid elementId and valid time range for which we have poller data on that element. Dont Gets CSV or SILK output for easy loading into Excel (future enhancement) Testing Requirements System Requirements Feature is needed on all platforms and should be tested (see below) on all platforms accordingly. Data Requirements Should be runnable on any system that has poller data in NH_STATS0 sushi tables. Key Areas for Testing Sanity check of this report should be done with each major release, to make sure that it does not core dump and to make sure it produces intelligible output. Beyond that, no testing is really needed. Performance and Scalability Issues Since indexes get created on the stats tables dynamically (by nhiIndexStats and nhiRollupDb jobs) the nhShowElementInfo utility should be smart about which indexes exist (if any) and smart about avoiding WHERE clauses that would force an non-indexed ordering of the stats data.  TIME \@ "MMMM d, yyyy" October 31, 2002 nhShowElementInfo Functional Spec  TIME \@ "MMMM d, yyyy" October 31, 2002 Concord Company Confidential  PAGE \* Arabic \* MERGEFORMAT 30 of  NUMPAGES \* Arabic \* MERGEFORMAT 6 Functional Spec nhShowElementInfo  TIME \@ "MMMM d, yyyy" October 31, 2002  PAGE \* Arabic \* MERGEFORMAT 6 of  NUMPAGES \* Arabic \* MERGEFORMAT 6 Concord Company Confidential Concord Company Confidential  PAGE \* Arabic \* MERGEFORMAT 5 of  NUMPAGES \* Arabic \* MERGEFORMAT 6 Concord Company Confidential  TIME \@ "MMMM d, yyyy" October 31, 2002 Concord Company Confidential  PAGE \* Arabic \* MERGEFORMAT 30 of  NUMPAGES \* Arabic \* MERGEFORMAT 6 ,9:hipqstxy;<IJijno12<=ij  4 5 6 λj0J*UmHnHu 5:;j5:;U0J*jU>* mHnHu jU CJOJQJCJOJQJmHnHujCJOJQJUmH sH CJOJQJmH sH ;+,z=5 $If^ `$If$a$ >JVWi  0 @"  ! ! !  & FJ$IfX$$IflFjR  t    4 la6 7 R S T U V W c d e ~  ƹƱйwiwjUmHnHu:CJaJmHnHu&jo>*B*UmHnHphujUmHnHujUmHnHumHnHu5;CJaJmHnHu0J*aJmHnHuj0J*UmHnHu&jy>*B*UmHnHphu mHnHu0J*mHnHu'    * + , - . / 0 1 2 M N O P S T \ ] ^ w x y z { | } ~  ÷é÷ף׏÷Á÷ףm&jQ>*B*UmHnHphujUmHnHu&j[>*B*UmHnHphu mHnHujUmHnHujUmHnHumHnHu:CJaJmHnHu0J*mHnHuj0J*UmHnHu&je>*B*UmHnHphu&0 } 5 ~ $ | , ($If@^@^! ! "  !     / 0 1 2 3 4 5 6 7 R S T U X Թ蹱}Թi_0J*hmHnHu&j=>*B*UmHnHphujUmHnHu:CJaJmHnHu&jG>*B*UmHnHphu mHnHu0J*mHnHuj0J*UmHnHujUmHnHujUmHnHumHnHu5;CJaJmHnHu0J*aJmHnHu%X Y ] ^ _ x y z { | } ~  ֻֻwm`5;CJaJmHnHu0J*aJmHnHu&j) >*B*UmHnHphujUmHnHu&j3>*B*UmHnHphu mHnHu0J*mHnHuj0J*UmHnHujUmHnHujUmHnHumHnHu0J*hmHnHu:CJaJmHnHu%      ! " # $ % & A B C D G H [ \ ] v w x y z { | } ~ ƹƱƱ}ƋƱiƱ&j >*B*UmHnHphuj UmHnHu:CJaJmHnHu&j >*B*UmHnHphu mHnHu0J*mHnHu5;CJaJmHnHuj0J*UmHnHuj UmHnHujUmHnHumHnHu0J*aJmHnHu( & ' ( ) * + , - . I J K L O P r s t ѽѽŽޕѽѽŽsj| UmHnHu&j >*B*UmHnHphuj UmHnHu&j >*B*UmHnHphu mHnHu0J*mHnHu:CJaJmHnHuj0J*UmHnHumHnHujUmHnHuj UmHnHu* ("3EVw&7TY2?DOZk &'78^_wx56FGIJijklpq !"#JKcdtu mHnHu jU6]6h 56\]5j5:;UV()> abcdvwd@^@$Ifi$$Ifl0,"LL04 la-o}~(TY & FQ & FP & FO'  [\HI$%( h$dN]h@^@ ()GHvw  mHnHu jU &P/ =!"#$% 0/ =!"#$%# 0&P/ =!"#$%yDyK Ahttp://janeway.concord.com/CS/sol/23597/NH_MANAGE_STAT_DUPS.htmlyK http://janeway.concord.com/CS/sol/23597/NH_MANAGE_STAT_DUPS.html{DyK  _Toc23836490{DyK  _Toc23836490{DyK  _Toc23836491{DyK  _Toc23836491{DyK  _Toc23836492{DyK  _Toc23836492{DyK  _Toc23836493{DyK  _Toc23836493{DyK  _Toc23836494{DyK  _Toc23836494{DyK  _Toc23836495{DyK  _Toc23836495{DyK  _Toc23836496{DyK  _Toc23836496{DyK  _Toc23836497{DyK  _Toc23836497{DyK  _Toc23836498{DyK  _Toc23836498{DyK  _Toc23836499{DyK  _Toc23836499{DyK  _Toc23836500{DyK  _Toc23836500{DyK  _Toc23836501{DyK  _Toc23836501{DyK  _Toc23836502{DyK  _Toc23836502. i0@0 Normal_HmH sH tH X@X Heading 1 $$ & F<&d@&5CJKHOJQJN@N Heading 2$ & F<@&56CJOJQJH@H Heading 3$ & F<@& CJOJQJL@L Heading 4$ & F<@&5CJOJQJ<@< Heading 5 & F<@&CJ@@@ Heading 6 & F<@&6CJ@@@ Heading 7 & F<@&OJQJD@D Heading 8 & F<@& 6OJQJJ @J Heading 9 & F<@&56CJOJQJ<A@< Default Paragraph Font*B@* Body Textx21@2 List Number  & F66@6 List Bullet 2  & F67@"6 List Bullet 3  & F20@22 List Bullet  & FD>@BD Title$@ <@&a$5CJ(KHOJQJ>J@R> Subtitle$<@&a$ CJ OJQJBOQbB Title Text5CJKHmHnHu:Oar: Title Subtextx5CJBOB Copyright $a$5KHmHnHuDOD Heading$x@&5CJKHOJQJ$X@$ Emphasis64"@4 Caption$xxa$50Z@0 Plain TextOJQJ<@< Header$d&d !5&)@& Page Number> @> Footer$d ! 5OJQJ2O2 First Header &d,`, TOC 1 !xx5;*`* TOC 2 "^:*`* TOC 3 #^6*`* TOC 4 $X^XCJ*`* TOC 5 % ^ CJ*`* TOC 6 &^CJ*`* TOC 7 '^CJ*`* TOC 8 (x^xCJ*`* TOC 9 )@^@CJ(U@( Hyperlink>*B*8V@8 FollowedHyperlink>*B* @R@@ Body Text Indent 2 ,^8O8 H2-$dd@&5CJ$htH u">"">"C>+,z=5>JVWi0}5~$|,     ( ) >   a b c d v w - o }~(TY' 0000+0000000`00000000000000J 0W0W0W0W0W`0W!0"0"0"0!0"0"0"0!0"0"0"0"0"0W 00  0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0  0 0d 0d 0d O 0d O 0d O 0d O 0d 0d  0 0 0 0 0 0 0 0  0 0P 0P 0 0Q 0TQ 0TQ 0TQ 0T 0Q 00 0 00 000 000 000OOOO~<;;;;;j6 X 0 ((9hx;Iin1<i45Td+-.0O]xz{}0235T^y{|~!"$C\wyz| ' ) * , K s UtX X%X%X%X%X%X%X%X%X%X%X%X%X%̕*Qj{(9<\^c=Vg  ! !! !8@0(  B S  ? _Toc465587485 _Toc465587486 _Toc465587488 _Toc465587491 _Toc23836490 _Toc23836491 _Toc23836492 _Toc23836493 _Toc23836494 _Toc23836495 _Toc23836496 _Toc23836497 _Toc23836498 _Toc23836499 _Toc23836500 _Toc23836501 _Toc23836502  d T    u X&" 3 E V JL&7`iZk 9J     JL;G 33333333Joseph KueflerZC:\WINNT\Profiles\jkuefler\Temporary Internet Files\OLK8F\DB_56_func_nhShowElementInfo.docJoseph KueflerpC:\WINNT\Profiles\jkuefler\Application Data\Microsoft\Word\AutoRecovery save of DB_56_func_nhShowElementInfo.asdJoseph KueflerpC:\WINNT\Profiles\jkuefler\Application Data\Microsoft\Word\AutoRecovery save of DB_56_func_nhShowElementInfo.asdJoseph KueflerpC:\WINNT\Profiles\jkuefler\Application Data\Microsoft\Word\AutoRecovery save of DB_56_func_nhShowElementInfo.asdJoseph KueflerpC:\WINNT\Profiles\jkuefler\Application Data\Microsoft\Word\AutoRecovery save of DB_56_func_nhShowElementInfo.asdJoseph KueflerpC:\WINNT\Profiles\jkuefler\Application Data\Microsoft\Word\AutoRecovery save of DB_56_func_nhShowElementInfo.asdJoseph KueflerpC:\WINNT\Profiles\jkuefler\Application Data\Microsoft\Word\AutoRecovery save of DB_56_func_nhShowElementInfo.asdJoseph Kuefler0U:\jkuefler\doc\DB_56_func_nhShowElementInfo.docO|\%}R~ƺj3qβ":/KD{?K6 x &;p&-Ai;xy2Zb( ժOL X~5  o\afRWX~="Zp&-XRf<?X~ hR2  8D!=8! 7B"X~?#p&-!$p(p&-)p&-s*p&-I+T .6v{M.~>E 0 -0p&-s1TDSn1p&-*3>J5 Mp88 {8 NW> ?p&-ZsA  B55(BX~;Df?,H^o(I&kuOp&-{<|Q %fT LyU KV 4RzZhB2]p&-ap&-wbf-d "d JVW   ( ) >   a b  H@@{ @UnknownGz Times New Roman5Symbol3& z Arial?5 z Courier New;" Helvetica;Wingdings#qhjjj [%1Vh!20dPz2Q"U:\jkuefler\doc\FunctionalSpec.dotTitleSubjectJoseph KueflerJoseph KueflerOh+'0H ,8 T ` l xTitlefSubjectJoseph KuefleroseoseFunctionalSpec.dotJoseph Kueflerd2seMicrosoft Word 9.0@@$F@ @  [G VT$mU >5&WordMicrosoft Word  System    -Y@"Arialf Uwwgwf U - %2 nhShowElementInfoffofco-\]f8.f8f 2   \{@"ArialY wwgwY -/2 5Functional SpecificationQJJC%JJJ%YJJC%CJ%JJ 2   F 2   G@"Arial0 wwgw0  -2 G W Create Date: oH!888H882 G OctoberrN1878! 2 G   2 G ) 3188 2 G  12 G 20027888 2 G  15)2 Last Modified Date: 882S7888G88"2 > October 31 2002N1888!888878 2 '  15@"Arial0 Twwgw0 T -2 W Version HA.@!GG!2 W 1.02@!A 2 W *  @ 2 "  A 2   A2  Prepared By:N.AD@.AG!U>' 2 _  B- 2 Joe W. Kuefler288bB878! 2 >  5@Times New Romanwgw -2 D Copyright <*.*%*.>2 D 2002**)* 2 D4  J52 Concord Communications, Inc.<*.%*%.<+ED./%**. !.% 2 $  K%2 600 Nickerson Rd.***<%-%% *.<. 2 =  L+2 c8Marlborough, MA 01752O*%.*%*.*.P<)**)* 2 c  J 2   K(2 #All Rights Reserved5<<*. <% %%*%. 2 #W  .-                    ՜.+,D՜.+,L px  ManagerConcord Communications%P TitlenhShowElementInfo Functional Specification  Version 1.0   Prepared By: Joe W. KueflerLegalRevision HistoryRelated Documents Introduction Glossary of Terms Intended Audience OverviewProduct Requirements Summary Product Requirements Gets Dont GetsTesting Requirements System Requirements Data Requirements Key Areas for Testing( Performance and Scalability Issues Title Headings8(PX, _PID_HLINKSVersionAT<a _Toc23836502<[ _Toc23836501<U _Toc238365005O _Toc238364995I _Toc238364985C _Toc238364975= _Toc2383649657 _Toc2383649551 _Toc238364945+ _Toc238364935% _Toc238364925 _Toc238364915 _Toc23836490qAhttp://janeway.concord.com/CS/sol/23597/NH_MANAGE_STAT_DUPS.html1.0 !"#$%&')*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXZ[\]^_`bcdefghkRoot Entry F mData  1Table(`WordDocumenth>SummaryInformation(YDocumentSummaryInformation8aCompObjjObjectPool    FMicrosoft Word Document MSWordDocWord.Document.89q