ࡱ> nE%uNt*HGCs/PNG  IHDRx^%sRGB$IDATx^ E?wJBB I I#$(Gu/EA("AapEY]]ȮAqrBr3If2羞>iO_z[uuWw>   +L9g*A@@,Y|DnBÀ   4y`D=;RҾ7ݓ*6TtH`Eyz}V?}H L~ Z8h|He_4 I]3mr,M:-Fޠȍߍ1!rE)FR#FsyZ(RT M89"[cdFHīotch(qd_B,1Z]OUʣ Sǘa"cF;@AIhC$q`<w;tc]*Yhr}$A@NV2lI'U=y'o-j۵|f/?S(,䞀h/o=P*8m-[hk|_ۖ'gϦ7oZqSJ֮ ^Wo>Ossy[JC-5w>mr0VεeEo=RQg >or`@@"$r-bo kZNmy؁\OڎqgN;ϼzϺ]߽kBՄSᫌv=bs>I kvE{NO_UB]r-InF&,[57C C Ќ x^i9Jb(iVβ~P']{?ϲ-'LN ;ϲcg\E)6!@YYS?A}ٵ˯khSiFK]Ɇްa ɧOЫb:(F3ڹ_^kWb8"4C@9ulw1Z:uf_#\gS?u3Z:oL{%Ӗv]  @uYzo8;o\z׃heZlPYt'\1z/R>.^5苷jΧk4mW \7+yJ+c/z7F_ \姎7>%?ৎ-F{"o^燯M/xv݃]/PJ⧎|~L2r]Vߣ(#dБki1{>_tvF}ձ_v]u9ϣ eP;f3A|w7ۄ~R*kCa׀bF[#уr--c-!0d`{q ~P41Tx{O4n(   hÕ4_p!DB 2   mDp(  .h](A@@"@@@@ %Ȁ@DH@uH6"8H.    Fb   B D[Uuu.uC@@rO D[[8vuSСッ   `'d-z:]]mjnY>p/WD̚;h~j#cR6ӜPAIי/aq-I&o7W.0֒'y٥3NwW">"ZE} GKBqD*WXD(w p1&^wbJprQDb,(+c pc=Q*-1ne0"\%]FZ:1PF`c(_Ev6UUZVgꉌ[ky[-4Mc%2FנOCg(T|Sίj"Ll e\-żXBl|TM ?J)l GkZc:)YV<Ɓ(QbǍ^wac+YibAwa|L+݋8R/+2W!&. Ge-#'^)J ae]q U6SV:%.)zktSvU.#wF&.o ?dx_qP.&W78V! :.XZZS)ӲC=(V{]{wlΝc^h"@+a$ n,w y .*;msg( ^]/:PVI>~)p# `ؐ06!m r;?Ԏ˘}E]"{]>T4 +)2q20Å !H6AUIu[٤dacoa 5N:_oz/p *,*1S.ȄRdY"8G|1%T8 ~)â,(lAEWe4ϱuDڕ(މ\ t7]%CRX=(Z 5>Cc iKDmoM]t¸氵]>Hjw3jJ>w++;v)'{-3cq(l+ kݗL;aF6F%r4X~;$+] U|/^7"8(ٌT &hǵ|Ʀ/w[J͛a/t?ًzbQnRf3mZJ>A۬\0y p6GPpL6`^fYڂ.Բ(UFo:{54u]]+>ѓwI- qs4E9{Cr0H}O@( ~CYS+rSi#Gn6B',,Ͷ# <].a2^;[c(C;lJ| T7Zw"s1 4X{7 k0  T"q6O?#v(T+{/|q ;R=M8q֟=ѹ]Y=̻bOʟ!,#cF(RqX'smmOlc75P^X߱iI]mTj؇+mT W5Vr JdZ&CYD`ՈP$ O2#֌vlҪ7aGzVE{/mѲ4{mº:zvias|mo]`Ry;B $0fuoaͻSwS?a=ޝ>YݸZtϮ;;i@UǭuKzjK~Fe}ؽ^zXggi Աk>{r_飨+oVs_—"/H@DZs_wg{mk,ێC̕(mggS6N9ǻ@K{x޳ՍGgxM}RRLȧ"S;RA[<.@bqs-[V=  ihtײFv{ٔ_fuL9>->ݯK'z@  J tmZ۹74RK;N{Mjwbu͵zw޿cCowy&j^\/3gR@rI tm8pkk*St OgiFKOjC{gL~:G蟵lק}6TFv/i:뒒CaQ$.Ѷe]޽M RBmfO˖}k?eEgU6,Cbm[9Ek{o=/Hghkwtz w߶mٿ}6eW6W7OK7}3ٴmNKeߺQYEtն=zJSCߚu[2@C,ead`-vߘ+ǟA r׾J}vavuؚ ?wayzBmmU7~̇p\4]FE܉RJG~L |C?Ǎj]! 5kQv-17.dr9̲]CA,q4b @UT?nwy& Z(A@@@ @{UC =9ȳU/4@@ܶ  @ }L PVJ1  )@M.T-b@@R$D"\$ZH6EP   HHmp@@h   "$B5 "@@@ EH)…jgߴMKSUKfc|ڵkj#I'T <$ZĖ=z> _z; {q9BZs<1Bs|U5n3(B y%D+қqk*=IAs"~W_n[:j/ R3眵nJg' ye!O?9UwejkM1ۨE{jGOH)֢x'6҉_rKdIRmޕ`?@R˗aFk$gbum@@(Ps%iُ=ωZԯR9.erQ$YXa.qlCeA*@yΥ" &2s8~>/LOh4SXDMa<@(J#)ߔdWe=fQt @,h"fWkU)21{v<ۢB)Ϫ)iYRɁ i#~Ȁ@Wg@ܪ𛳖@ E(5 '~ȃD D+$ZWRh#@Cp%DJ r   mh(  h]IA@@"@ E@@@+)ȁ@H@u%9@64WH    F"   J֕@@@ &ZZ,PB A dXuXSr*)=;Jad&H9dS!ъeEKsN7ZR2džRO9DY]1d8\eN,AUEH]>hc/R^g95!/ Sb쨔Cwe8D(Ut2Cw;|$Btl rUqbyH ťqee (bg09n֋kƩB8:V!Ot;E2FcOZR8q 0p(&D_)ly~/In8v++O؀UED@2r[8XЅ4g@&:28 dwPW8BzB'jkWBѯ*eUr#BRNKB6ëiP^!)_x(-.`HVd$ J&u#P~2P {5 hXr8ux< (?cU=KvwOxđ)EtE#|NQRhDKWhk䠍N#دAJq Wx:@!8&K2 ʷ)Pvݰ@-5) rXl (`g, *bz)9vlzb^&Zy.ho{yQ'Oʱǜ2)e8_ny||)G? OX=a',YcA{G0y# LB E9g[rgd&qё\J"`-hmĊBM? eGfsA(gqfRr `i=N,AeDRZA x&Ȟj?H H@>"F"M66B(!iE3ZD4$KoI'^^& LAD'%K 7- 2#DjTgh.\Whڲ+HpF-9'C<^hӤ  '-V>@@ MHi҅n@-|@hӤ  'D[4 ѦIA@ O!  i@M.tmC@@$D&](<$‡I{M=1*@@ J{mUV  DܛqIENDB`F)$ x;JFIFC  !"$"$Cg" }!1AQa"q2#BR$3br %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz w!1AQaq"2B #3Rbr $4%&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz ?$ij8''٤/Z}mC@>.߻8ϘIi=c42EF|!}wu !m!eIޢȮ^;N(zh4ݷN>2uS2,#<Q)yo۩YmnVRa@>'ƏI_:~פKZG| vc׌ܐ; &f,"X"tY{Hz~'Ɨ-k>ZlO&siH\_ 22$3\5gK%fKx/&Cx 3@٤/қIR|0t֭beq6Ѻ!\z vOw]"JK*J0٤/i=c5|G>[٬6- UYV=vF;d&hn)GHϱ;U= kziVfm]ku&&}Y5ҋ~lgv9*߁m+^]*{.MAf0=7j#$(}~.o!nH1oh=~sO>qcHYBS`^w\u EM7\bEa* ӟJ~'ƏI_O.}Y@C,v<`Pw:zݾijShQ^#L a`Nx@鵔O4f?]b|?ŚX\iwHFBJ~DrCU 6lژ6W61[[]$SX0sҀ0Um]hKi7}oxN{}n[29&UQ*S _kO &" i@J+l䌁܊:?U4/>KkF3v8&nf ))glI ;;i5E.8$}ҪY4(5$B_h0sh3+qL${u6=ꬒ+>c.玆,qA>ӣL 0=Eyw[@%VYS1$~8fЭTp{KZa0_z$ A(7G9d]<*oȀϲog5n ܟcXgj!|~ǚ7Cq:*\ $`=*ͼ$abbSbBABqVcv8qE:OsaՎoY &9oBH 8>(#soj*soje%Ưn lXx?Qў2^+vdz~U4R@}iogh՗z̵76ѤƱ6G^o"ӵ'&iax1W$-fƏLz+^+"DdDTDPs.KqӁ^ucM@Mw֭Eco"ԛM[Qh 5"n f:gzguɵM7TK;wD x=zל\{Oh74x7_]B[/t2E 9+oJVV &4tD^k#+yuή__ ^|o:cEty%Nq4HvHAu[[moZpj2{O1de% +??jj xþ cQIf[c][\C=@s4on.OKKoYī[8v/;ORMq2Ǭ?VuzC7 1MFK1}v[^b-K;bt&5_20dE&U V$l=5:=hxohb[>y.bT(RCy$\ZXyn4bcNajҝR/hU~734fd)t~U/j͝;O_zmfƀ?ѢƷmP4Dķw5ŋSN?)0;? :^~P}mB+#MN'n//3z^KVBѫ1z;gh\鞗.tKhaTM3?y}/T>l?ѣ͇}46tK*3xޙj>}yd{9vĩ^?y}/T7x}6=o/?K}ݼ*;jjҜEE6_j,Λ?ľڪǽB4_CX7Όwe_.-]eS_k>[a#UUOڀ&=aY:&*$Wr& ۣ/9>Ib?ѐs@?)s^X?5W͇}4w_BօywXAGUo6O]f?W1o4[}=B0E)l5>:}EwKE/d9t".%k|d.+17dcR=[i,|5m?CPR2rfjZZMs(%! @p; 8c۷jBOĒEiu`A0啊kF5;+nLuiѦ:]6u; Q{g!( RAWA}oh;ܙWB@zt?)dI`-L5xeH,'jaaN:;yW/ 'jZɷnՏye~_GqkE֨i,SmBr8k7VVn3 ʅz^?ysZ3 RUƤq 'ҩid`_ tvUVL3=%Ӫi[[\֌MZ=B+6dUeHh,On0+ZMVC4Nt<٥ݸA6>o5WFT}JH*2f,=,-/ilv`3gw4YYi^60yEy1Z˒H&$r;h7c[ mERmE_`.Հ}ifT?#P~7٥ƏKLCQPf>/35G@}_gWi&]yu*47P5<oFk[B4XuP>ǵB4Y4Me+?-usZf޵-]eA~?~b?F X~*_΢ wv4:F_}%|!Q'__:1-Wj٥Ƥ?)q^GuIU/34W_BP{iwu/Cb.ȝpսm&ۄq?I^y z0'G^? \ ^  |惔Y-~Y$uD̙^6Kp}qNvdprLx\A"= E~t$[q AS\j[yXLem !WV;@S*gU]@;Rk'Ax ^yvbPj|ws3; 3ۥe%VKk]NSMnIX Jw}klHܘ'Y^'ӡ{Ua7?ۨ=ۆqJQ4cֺ=?A[}VHb@D@Q*hrmvi3nxУ.ԂA#4RB%u%Z_;w{9MB;܁ny3olf_^XA'9`Fr1Z:>o4if4=6=QR\|8Ez4Ijb}_Ϳ[_ͿC e&z;g/iFYHg3u4yϰdQi>7W@/yϲmG٧ch4_dS#Y˲ uZg٦ciSg.]1ޔZ=oqҮ:ֶdnV_?o&AXnGQZm?-~Oe+?Ԓ}>`#>_^sN\)埱 x:Y3Po~~Z v ߫@,??jjj-_f埱ooנ=aʢG.>nq^-Inp9}FC/_> ^rF0?z b[MIU4kW;/?S̃}j[LuK~15Wu4fH|u?_̓}jo._'W,_(ﶫP.-8"}l}%.ѧEvq8H~nr?xv_]LJu-ei ]Ӛgy &HrGώ+ӮТ'iiYRj+_, c}KnT*>jT 98N*lq2Lr؈[&O5Uă=ã :'u*]*(H uc#:!1ǹ[4W1jXʆZْgͶM{¾ޢ#LPZswF3׊~j h4߰zz3hf?pN~o}?LF4 4ϧ>o}?LF4 4ϧ>o}? ?y|э7 Uw>Sш A?9@ƙƧig>?|ҴѲN`|g?\i߼j=ϧ>o}?LS 7 wt?ު}?4q4%t{^;2ZTuoOx~'>.h܏V6 V2A6]A?m@KCW\cU8)}j>X{*$RI f\R!pGQڀ cB?wTPcUZӳ0l?\?ﶠ MtHO3OS$-n}m"]s-C^?s ̬( >v (* I?Z6>I5(F{B~!G_ִc$L0FEx2 &.6:?kym9=f5#Qm}P?'.3^b5|]Zr:?jWƏ4[wXZH#}qss&ogl&áS97-a?7\Ϟj'jq$r&9[oqZ*d0 V"[6 )%XgI~Ъx4OŁQǪ(ZSX8qީ⧋=&I~ЩeVFFnVo`"7#=~?=\]>?7lW.Q>T[O3?3OEy生)?@^si Z%`3;-,@~?ؓoV\?)㷽\[!³ ?_O"'hS?5f)?Ao'h\/5Y,p ?~)?R*Ѱ[rTPЩdVB3}Tke\];)$p|j(q黏UC,G֛q~GEcw=)x7(O/M?Ə/L?ƢȐ+jK`B]Pzo\ߑ5f 5.Ү>USzjn\wޠbMyQ>q0Ս@X-۱#_^X =j]RWBq@ Aۿףn^ oQ1@?PxQ1@?_PxQ1@?PxQ1@#k[gz}̶3O$lض6tU>wx|#_dJϵ/u_ \C__K]ԮnxfU?K}畿_ k<lo~((Zc+Gy[ߥ 1VQ+Wb}Oo~W(c+@qF*y[ߥ >P\Q/$VɃPj{<"9Q*oIx;~7d(q9hg vvҼ\Ypa'e6oMkc(EׇtF]_7Y j3qW{'~|*V׊&Km#y2@ w=X8vb>(ͫ Jϔ}'WgFJ>*h}଑N# yfߎگ#xnmX5㖁cv&vCpEaK;`('tkF\sՇ=ou\k>>6i}\yd&^3ׁvo}'m6quX>xC2! yā~v3\y.k &GK{H\dGMW~1֛šnW-SC ~|/ M_#=ȠF8䌏ν<}GʜںRVg5\&M {CQ6rDn lE C'{m}&zŚՖYmV٤XW?n"XnnJA%ܨqE1_C}g*M3vw35[ Yq/b)}Ѽ̍Cg%}9 9YE Su>O?I?vݟGڧGQ?vMlЯy$cC?bIn%hYhۢL=h,Z>ty$~T2 ˢ Rľ!0PjWVteM`\&~ϟuz6aYe.;W'J~>7 gǡy,>"7UsČZ>#/~u%Id͊TORU:QV)֌F* E=9_KwV~[KH#Oի?bǗ͓R:nA0VF}@'S^ZIu9W??or[B0җ9?K~z/ہγl&acVb^G$A*|EFAITpgXī ʹUdw~6X)so';mu%ϤxLf1\E:Fe {Er-퐰[Vi0?ڌMu%ɥxQe>L VU$?:壼K!f?وA_{=}yQп~K^i{Sx46z$HP]Uyɯ0~_Jwˋ}O*L4 wGʲT݂9wO;>}ުv:Պ#ͼ;xAvv $V ЮdAׇZ펏kmdOypFM5|j|ixŏwpʐm@%s{zKաWNQi׫&-퇙ue#ڝ^;]ceu YX".?u־!2u#` #~7ORՇmt\M|'%+N:xN ɻ07.Lqٯ.߳is/Ȅ?q[|mg55;+,W+|,s\69lxWRay7獎ҭ3cjOA̛Jw%Rq*/JԿ BJ❧ђVJu^R\zWW$V褯|w#ƽa+W$V?o8Ƽ?%qZJknAt1۶1MB( bxX+Txj(f2s'_D7 'wcRHE390P8^H8\3 5}#hh/u!w?*F9u OקvTP!,Sh 9uuaGg/~k^5xž &{^\ZC=dnAy4(8p?Z%O݈9_j)0RVv5VTf迴/|5M7V(rkο=.5 OOᡅ0*ԨMokkwE͜D ،K^o%%z闐rFh䈟U 5Øq!UPv]ކ.tbigڧŏ<xᕼU`n>¾_~.5\=3{.$ ~`~ >???ƌKөy9NNu*/n]}S :w"3$ya>1? [Gd!ff_2}Xa^u>J7oYFI&Sdb}~\k~2xe"X!nooݹwR نA 8Zx}扩XA\!u".x<<}Ίevwٞ\c/6U?fF؏ᗉ47⶙}n#KǸlɮ33h׽0*UiŹ:n*ڕeJ;%?ߏムa\]N%-1?t?;xq,zp ܎rpkH"`'hۃ ZO,uN{0XOK<7[oiw/[_,&уk8|IaMV"˸}y'4me "OQb>)ʤҲrwA[*i(#߂4-3ðxW|vhp9qtf? ˿~ҕϯ~[+YK'JifRc%nNҩ:n[!TPQTA|rkwa(#.O p9",>iXn,#^Ǹ5 ]";t̀s0fdx:9`r[w~3UUUQ.?gk-[Q[!Fyb20'æA^G&3'DS9ᚯg~mJXTIϓRwQ'8}=oV/l͔XW R~-|e}Wmuh v 0W?^V0{/|P,-ė/gos:A?Ρ`A#9:=焍!Ye(dRr\@^ EqBR=ק}I Q^R,@PI=L!Ho=(y/ai=?6Yb<ҤICӎOP]rǠt C[8uj6v#"Vn^aIvz9tl͎ :}:77'dd?0 RQȻԇO/O:kv\nW֢WGhT!tG,RDpFz{(J?{=G_Rz@XЪ>i&9r ¬j^Q~)F}=_ 4ê^Ukj^Q~(FM]ԽQ{=G_ Y{=G_Nz@hj^Q~(ԽP0M5sRzG€X^jaOus (׫1+^t4<{8@X rFX5~vRjo Țm:-xzqZW}'m {_$=v9/aȒ攖I*XwdSOihB??|/PEVmwo;$+e?_Z|OHTt dU,a&#ZڃPx;OG,+?=dJl7V>w}kb/Ox)d.[ٔ@*B uS7f<#)ceJW.[Y]Uk 5xZHoh)۫gqQc|u  1ʘ`\Q< RTT;6JtEH(揖y r2I޻It=]2(F^:WikG|}gs&*5A`ٮbjM(={1OϹy@UnE"!vGQ_H_5ٸ@?2 r"B~OēZ`ak)q 7<%Ѧ4FkC>2|炾xOukє;T5E#RyF堯?]81repy<1ԭOd}]B#n ]Q׈8$!mƼo%w\wj\dK ~.JjJ#(Ihy_{mcYQ3D~4R +$yzm7[ȲF~ZG,uhbٻ6Vd&-#, 6x.OpֻOږQ+nOW^6V|$ʰB+욖mae-I4qo IYoEݵ~|QX{?|4Ҿ%^kأ۔,w_DmĿdQQzpH9fM A?]FEZjvmwԏӆ62Կ's B9X乷R>jfxdZ#WrCvOedʸ/b/'X  @ITuWRuK'h8͈kaGn-+ko4qV턚mֺ4W9H?X}+EoO|yc$P\<"9s[_~/xl$g" wsPZȱ=6yLkI8zn TOA<'jNM}glE2W_6>6O_mrxv&V(!joξE]xs:+H@'MzS}[o-ž<9ZVguVQacel&x$HǮb0Q$ҦK;d 𾲱/nuK ^+Pr?*/Ļ2ęg W4{okXXd2.F+ʳJҥ;;$]ֽW18h҂ڞIJ2 hw"QwikOyݮ-ET1;[jjX.\ܴFvʞdsSMyow)uGMMrۣ9_[?^o(:G\q8RndǡIp\ #՚;7$𤱬w (Ѩ7azA 0Q𮰾mñ V@_ O@cR.%+-v1W7*QwGz4,'kQUeE&8oӏ6jvN[5vyٓ2.>}eƯ2E*Fџ+<) #Tfq]+~$M'ggIsk,6[#'Uf^ged̉6YøzWr2mE%۹{0]9-jڸ-Ϝx|L귷#Oc$wiXȤqs l~Ѿ7𿎵]+RΆ/&s4aį~5zv{o HX溻 ~O#]ݜ KZ%[b@ p%vWxY7>^ko V'mCiR%/Y2%#Q5~ӱڒrsQ~F>*Zyla_3WМSQRߑﴞ>-)Lj)REsO{5̮0qq+ύvꟳڴ,i2,IzHk~# XʟS|exv#[+KpEF`ŹeXӂ$եWHӍE&Xu2clkJ\[L]ʼnYm=K3ic!HS.?򯶫K#Y ޅA'x܌TߵZ| Pr[WKhgeYHdd|5zGia)7$יp:|~g^X[@.n$9 ؖmq@^c@j^&lN 0pnޕ_6IOQ^G]+5O]x^K}e~|&ǴxbJw-%.$q2r9lc3`V;"`Oki ju9[kudu'yx2/֖ZEHBOs h 8. jN1tK؜ӫVWDߙE! !nQmK"85;d8>Vǿ5"tkGQT-ls*<#PĖ7&7v |_LaZsU%ԏ+Vm xY, m;|ӄmԠ™/&X`(-&q~9AǙwg3 UZh>YUzI0Gۛ)uhN6PuQ@{qom7 0@cr3^K A_*)c߾kcjwr-0U2ye 0?m|,|Ei70p9'BQ|qEW}|˴awl}3^~#&ue5Ks+on_Ëe7ȎOsMp^=:k-\ıqwrE-ec~G^{/mҮYyk0+tic%;(w=itINTkoD.>h /.%#.zy'ڬPj>%iԼ0c̐(?3g0 p`Ӆy܎ }+՗PYdO/e*Wh'xŷ^#\]8ڡxүxjKs2I:38-m3m AS3qޱ?lGG,Iᴶ391،qxDCka(+ <;/?ZRmXJm*[ȲJ2*}>nt9nHIo2 UUܸq ,T}KZCp1+\'c*S9];\.-RV_9XDQQUS֦?<`t&?>k9 Zn?QVET(=)iJJO"oBR}AN (# o~c"YIsnsM;JxA; rѬG -w4QEQEQEQEQF*e`9E#@"U'\wkq|u?SI 뽈D?'VDL _M!|#y}{HZ"wwl:KGdI E]}4cpŔG80lɽÖe!=ɸY9'-Rkctq */2)xmkrXFѱ>nqм@7 )ȧ .˅cх2)$ӷuԻ`OCOڀ$!xH~;c8t>VH yt6rE-^hQ^ R[M1{z3aac ׌c-J]:%H9aVn얫h3ϼ{IcL4RC%?׵A,`F:"4f>juQOHQ$Ηi}MC /.vV<.L*$e#por~݊>~;Ƭ#_]O4̏Tt6iV;lNr(?ֳ䶊e2[Z fi$tU~ nTU{?S֦YrOT)@ (ZҊEPHzR@5 I_UEjOkieVqK+ @e{/) Fy5$I$@Q@Q@Q@S}'Ա@Vnz~ &Nycǚ|#]lqqF28cՉhv sƢgv"(c<2K@9`7X4R?S@򣇙O4gyҒ(]BF?~'\['z7_Ҁ[cU.鰤QCxjG,q=X]G 淘/@ gHLF<GCYάHr\o$?CHv|8U<(8qw>G2FDq}Ea;¢Gt`Xwf鵕^E$W u,|n{Qpg%te uu QÓ緭Ex]f<Ia6aܪ>bsQl.CLO=7Gs2'yrIP#&wHأ.B$Dd}NmV =ݟ$@oN3)yi:Bi?7iooǐ|)7 ܏QZ7cbEF)KI%~ƀ+r9+QxXߡE;#Ŏ0}*+9Ҧ9?tP7 m 8o# nAUO-ѳG~9=pgç@iS>OvUò+PZ{H4j%4/?QOz3fG Fv>,}d_Uih?QOzZOz= MR3VuYEo2llzJқIt$cT:}#,2<˞H=AJ;$=5Rgxw1iUhi~9Ҧ$II#h<3*?+iNy#G F ՔV|U4 t0B*^&u(qB^]=4X[hX\Yڽ`'#c*^t4W+ 3hɗ+qwz&ny88=E>MkKH.14s;#lqƞi){K,fv0Etq.@V;bs3o4˝|1Miyp!29Iwj*sN#gܡFEDذW~2߻mg4Q:(yYmg_*6M :ms (7pqE8Mr۹"2 c82+J =69#yKDBK>x5O_I [xSc ,?qF{^Q4Ka,#Ip ;L@{q(EDŽ_zk;d767$J3qۚA*XIdߙe!qViϪ5K/ R4q ?@D[\$y<*wnm7#mLMK~xgx{ɍUɑc;00'|:Gh&㉕Z{5xg2A’^?8X4F{3y [ȨJ@$gM^ogWJV`sq5gĚni \qوq MG:Ѣtajgõe!*\6X~v-o4 ]dJB:ڦ`"Wo'47Wg90hğc$W=۲%!S4EFUhxS}XL򀤀ǽk%rE'=I&m6'01QKX59bN _IwB\n?ߢ*QE%r{ջH;K vbLַʼn2y#aUn'fd,D{~a;Vm\ֿ%'TTR*@汷BIJ+"9M6e=G1(m6~_`Ao2E!ey,Ms<L1H"m; aǙNҚQn: _j͢9"lj@'v*QEQEKk1?Ҭ#+Xt*A8 Ia6jY `z"C" %1Np7H%N65:)NQn|ϙ֛ ۣvSQC;eOjV}6@^ w@}O5chM>ezt $Epa8GAM?$x?a T%2enAT s3btP#R!'.Y0 B5=N~c4^}k5 -Kh΢m\lM LI27󩢳Vx㺕mc>˞Z$do>Ahq/ɋuX:YҡGOjm+31O4製lj?/?X cEPWu?*W'@ ֿ+qk_zEPW4#CZ]Wÿ7Oo.$ 'XqrCIyêឿ(泫:ޡsĉc+*9OG_hh~(Y.?*>_{'}ȕkI@ѳ}#}>"x> m$G0'ѿZµΝs?C&!_Ǔ#Rb#d Op@y/4GLqL;lY^STOZWOgltĤ'#-d~#ګ57~{H4iAA/$"*]_S`Ix=]$Ӱ Ƹ_^DNO٢|=jDnO񧤤C1H}R.=I,΀%&w^ZRѿE@Q@製lj?/>5[Ϥ cEPW'TjW@ ֿ+qk_Q@(֏yZ6&XOS5i>v OkGDK5 Hʾ+t5OV2N}IpȚ⿃(XZfr  Cr `㩮Vm.D m8##zN'¾"tKFWoh%Ѐ-ոBI]J&p5c㯋z=`DQwr.Bg=c&@'|;$ PAjO(;1JRZiHs߾**pw q]SIEQEQEQEQE>)^66=}@Heo]f(%p*Fm,KeP6/RB_?M&DŁqlin0>f9nUسb{Fj]ѕT>`v@UIcd`qG?,vs4o9$UPU.U9QEwA=lj?/>5@Q@^ӿЪ^ӿШn?QVE} #dW( N?º+G?e??A/_r2|# xc[TѴ?OH -![nyſ#w.A9?$ז]Rib{T26zWp5iQ{6۳_u[tFg˦Ys:սf_8䑲؀tdgmb[t;īl dջ>jRn5rFH#-ሔkk-P! U}~:hxÖ@R,Kv*.#y մ>+4VdOGOh괟/W[E|G3~{WG(>xfD4m䏲'+)Tֺ(OԿ}ZV;DEic?'aj_ʾrBvG+oН*XEթ*µ '᷀N?kg>KW܎H|6 /Q ?'h]f)hOԿ}[xCnµ 'uQթ*¶ '-Bv]f(4_0/_r9?V;DU¸ICET -/g>KW܎SρyGEmUR''/uX/ }Z|8R{'+_Л"WJ:ROԿ}ZoA]m&(OԿ}῀Y> ''š~h ?,g>KW܎k/)jEsgo9L}4eC/x<>]7콨"7c\ |6񯄉}kB/2/x~bGB GمlBS_s֟[#=`~t?.X_^d7@t}BR pGM5υ*;Qq`N#D}yG3Ovgseհ]wG E`_Bp^ӿЪ^ӿ3ZҊ5 (Z(5~-&GyGZҏu: ]6X`Wf|~],"ĹsKE]__j-/sG9'I$y;ךx[^!:|CH}_V[Nd@gw|`;ֆO-{x%ԕԌB%N;3W}L(tk򿑊Qvos33yPiلj18IJk]>&xVm6[C85fir@*kdx0碊]\$]OAZ/xBR jp[Dk`J8׷;mz⻻>ӣy$AsJI^#%M/'m~ዄ; Z֡y'n嶴Y#X cY^Lj~%t3xbnMhX`a8ZEpRMAwTUM[*{I,%$ginN/ttFWi)sKRPQE&hh((NQ@Rc PEPH:@Q@Q@A}koyk%lȻEOE8Ŧ.)3MOBϦezzWH`F>\Ex'f r~j)w`;>9/.RGyRuh]^ӿSYVcW4u?*8n?QV((S^Utm RO6{Մ#NA$|åwjba9qY"c nwҔӾ]0+w' OMamb[u 1t pF @tRH7|M7HPm”6w DHڽ`z8 Nd+7={>G;63. z^b??;uJ//6ktpN*${iY@F}ceMgJL~ҲBۊ]WCy- &T(bXep3GJkzP$^8r~\gN+ َ:NtZw~KQJ2RR8[3׌o&H$JR K Ci8zV^x4C hOї7PHxٟo\^i}nkY * nFAT?*a3 n|%L";;b x'K^:7hZux6F8@\'vЄwuSrC;Z_ëMleV v"~jQXƤR-+ wXq䌴@ۻG]C=|Ld5cI*û{6;זa4r QfPM͂zVzEq[<{v?Sq~&Dޱ=j0ۣDR2pv61nj":Vxv .7ccpwC1YG:E$/O M~?*YdPF[p?"|*"D*ִi]2=ӪEEөS_>Qqm32(S`E!QEAKE!(((- (Hih)((A@ E(BhhCKEQE!G况$k*Э蟶E M ﶱS.0(޸OOLt+SŠ(LEPE CK@Q@)h ( (:R@Q@Q@Q@PEPEPE|B񵿄~Xy:Fq[r _J**TUՍ8I}x7WM"HQA07F~{OӼL/ռ:*UoɔT۵ΞAK^aҎ㾒5zB=Ċ?4Wiwn042gὂl%Z|̛4Q_(z!ALREQHhh(AKERKE(QEQEQEPhEPE!RZ(A= s5w$Z}yVLb.3ӡ%}u1pNjэM$xՖ΋{7z$sJYUpa]6-WUӼS4ռCZlo&GV<^-[hdqљ"ֽEZ\v+93ӧq5{kvz|:ފdP6kyup2Y4?^Ʒw:EiXKlMP7dq+q:m}mwkHq|?tIk'ӮfO1 ق{WU=cz/MVڹh{ TblN*?<-:n)hӤ(@Q@&iM ((4P(4Q@)h ( ( ( C֖BE ) -((3KH:EPEPEPf-!Q@Q@Q@٠Fy1׿ Cj=aR=JFIFXXC  !"$"$C," }!1AQa"q2#BR$3br %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz w!1AQaq"2B #3Rbr $4%&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz ?.ShjRwǬ"-DpȊ0x0A,~@ߣ"x]<ꬺ]! vU%Wlƿ*4;-[ǿ5]SXg䴳I9X@ǁ~|hLj4u]N_P6,:y#3v, QiڅޫO~grB;nB?M Mdžhoa۬F;*dԞ_?C :',xL|:8uU?I8|EG[ȿ-3H P@'&qkC]]CIA\C"?̯_vY۽V+U(Z+ǂ?urN0PhlA@D6pqXˍ߁ּ>xHѱ*#cW?%ߴ$WD6Z]ÒslJ~2AӾźE(w.x€;*+/Uuwx-#uHO]^O1@EqZů:A×#B4؜bIր (vTBUFI' Z+GE[]kW !*!3'Jω<ľ%=F5 \ UAِAtVWxWK&S*]A$3h((((+/A/ ]xXbYP0)wPpkMGUĞ4;i/ڡk{F14/UmԬ"]iQUbޜs_5?g,LC \xs_^mxE})Sk{Զp+:-BN, I-&MFyzP94n~+`%$T~$|@o{o:H7wme\V<NIn+|#¿/863qz]pƄƤuώZ~UFSY|;K[4 έ>=H/?]xQЯl›C$jv5dڽC ;ė%y_jj5݁˵#*RyCg^1^[7G-߇"A[蚡HY-[n!VO-N~NS|5go<)}- qua rC%ԒGPkG!*I\bsZ@e< _>]|E^2x/ X?yr?@,!+{xPGQTE@iٳ Cֵnc$ыO W //x@` DdS`Fw>b9)]둒=U!ԭp?MM?iQkknty@_dxGփ={Yu LS%4'_cW1j>4dS-0{91:0MO!DXnllt??*?-]-B=a㹙TyGS@/|#m_Py,bm: @Q"sAeׂ tn9$p 3їEEaksiVjGq6ĸutP3&;y5~ڞ?A5ũ ͵]$PeOL~1{[KNmDtNbM`rھ5M2R.-.I+b4G>&E-28F.裫aY|A/'g9GvxmO5kxď Jg?,v MrBth.yJY <1_~ǿ g/onVxoR=pk~v~-AP.mIj#0Lwq|^-Yt9ۢ͝;+hoVorgjSƮCZ? Ϭi7QվIm9cAeFWpJ wً7ƭĞ'VeL0d98-9H~[m]s:uwa7xQS<7Jvc;Dq_8gb/[^<ɩZM-Cc HLG'z/[hD"]OF-GGߎ8WZ3 BO9{w 'p-WS%֗bKe*ՍA0e:5)Qk|~oEU:2GY3Vg>+ӠqKzsk,K#!*Ӹ8M|{pjpmIWW-,m:;Pz)_D~/NկZp{LH$oF~P |5EqNVkEmZyͺb7c8M\o |o%r׉XTk?չIF>?)gK[ ]fdT <=#lű^@K#yrDC_CGБ޿;> :[X6\LbU,ɯj{>fm,bIZs&e N@RX{;էh ..UIJD;O^.{[>w1M?#^Kxv^t9㌵ܶ8UT*WIOxOQ Rޞd[Juyu;ryצQ0̚_($S|&lgW8|Cà÷:} I(W2%A?6 Go('KokWF\ىܲcv}=kBv'Sx~%RjleW@vxs@iC4ԑrf 莏'^@vYKȎ7:3? 鐤p!FpIEMx |ys]XOIi-WLΎ v`z(o^pI'ա%ZؓTMko-)P +0*-τѡw;- L궗p$ pwOJmO xsšItRnB 8VݣxakT`UW:/o0!$ .c6i1sN6hv ƽ]4t?^\z=ŏ +ڋqZh@n OĻX1sQ:ĭw?|mjZS^F'u @?>u/qo &\mvm-cێGPA#_%kM\}o!c+i%i呎Y݋}ɬ%C/?#?f8NM}zPGiw~A!7.Jm7M%!@(U˜g}g¾A 3jrm+1ܰav=wڝz'E:.G|ze>k9[BsF9צ\dpk2n!h."ha2q Q^KC3uQ?MLf|*5cG**]aRqH]T 8l k/~?/6ui 818,O7ZY_ <nB+ Uҹ1*dzեo̟zf#i(μE_9𶩧"Nxm#iRۅNxR&1n3~*nxݑ2Mj_O!{?ʦ? 57~<;:/D[ $H,iV^8 1k@~%{} X!kR|eSxGRx֫uhs0+?k.9PD,Wb( j|ۨG+Z))d.uqV4,r_j] v@9ckҾ@kO.Y.4-ZGK" dwH78ペLobuwSUId1\[cBAs֞cS_Ljr7KS?ß3Ag}7t x ̪ɂebb`F2x=+ôoقQXoFđ{]P }z.|VmoB>Ūvn8p< |=/n,ؗ+ۨ<]rԎGG˳;~Kxòn#E"qLt'n?mA-̗Al#Idʸ $@x;d~xs߆;bka sEʋԒI V<{TVXH$AU8|9ĺgI,?;ש~meBmfr  #ǽZ7.]y1hS~[3 񶝮7ºewP%bQ zƾ~9|%F[J,5xwefBe@e.AK{doRQM3ZF-'4R[hG8 |+Ub9UGW,@5w*:| =Y0_3xdU>k^L/v6R[SE[ai_/-ak3|;;$CԐ~&Q$d8|p>A4HB%Ae*zSmce_㽹y3PB㵼rڒ?8gh|:.Y$qD_Y< ׎eVA*7\Gm }xkúQh:^`VwPƛ<^s:˖Š( ( (15WZSqěߵ¿w>#ƁoEG@uqs|: Ư?6rY{y,$5"eMہNh{GY&eep}IV"%yɑvj4I\Χ&^gj9RVeg">F\Z/#G캍z'&䚳4sPӺ8 UoE/;m;N2V(X8z¾?Br?!?Y [{@ѥ W@ף1H:K>k{XgZ| go=C?fSg⏆vZt(4DK{yF$1zfA+ۿTwhᲶsNGK!TpTrk1B^G$6.AkEDI|4>lַ1\>Hwp2`W xV_+ȷ@T8xs:~vPN#>_,~ h稔oWPDϭ i:I= MƺK[[8D6:$HG*j+ecgRsM* ( ( ( ( ( M=uoZSV[sЯPƝo c JOΤ63mw'OJaZnݢTe+‡r-?iǕ!5(c_Q:;6^ݽJk?a|%fZj-^_Gw|&:6࿵}sgmź#Sw~ K PI;>UK o>fcz~B;9cg~3F׼%?t&ib72^^*)(qv@]5<] :ɽREK"Q `p85 _ q1Vcd@ H+iؘYd2i189 rJT'>KӡBĸX䜒}MZb iMƝ9*&ÕaPxSQiIl>.xWa=O;/\*jZ.yh A$0#_4K\Q⾄ Au i6G Ķ *TQRA8<9^)s/3< lƅVp-ܖ `X3y ѶZRkzև%Zk3y;NO#_%?[-Ε$v$}S xa!r>475ͭл]: ao*.QrIv3(A_z>_ s"J]sl.?dюQg/5W M6ᕁvcBix^_>&󎄏_a– 5I\j89 y~Y{9턗}}EWQEQEQEQEQEQEQE~|~X|udrRoɵAyj"0ݸqO^^۬?!fOהn)G1$|%rՖOK#"6bV+YFF>?JvI /[8sE%+bW ?7>%\2Q}=]mKʖa+4|>w:]?:\>6;˻3L⺊((((((//u̒IW#<ֿL\Z_0 V 95foHS}|o̱S$y?cKO|{s6}p?JI, E,01 }--xa? ?<fө+?Aƌd#O>7O_wY­gq?WU'b"uj0HBDǖR>;56.o(<((((((F8ʺ?C_3Mx$]+5$?ďXF ZJ‰[W\?+Nk0on}Α A?Xo5G;&X a(cs g3}+Ԭuy0=usU,\QE{Q@Q@Q@Q@Q@Q@E{qsG m#@'T|n>x0&ȥaS'ʛ.9께^u;:VqyM2{sk杲H}>(Kl]Pj~V> ҥ+g?~+׫/d|%]\ 7ƺZ1|*|.QZQ@Q@Q@Q@Q@Q@~~VL5p9#&@k{Jh>-ƿ-'O:sJr9mhTG0%\_O~:<[\Ơp?+.yskܿb=O_fd(ed~`gG 5袊Š((((((Wտ Of Ame?.f|4mLi九IAb>񞵆)ڔܺ X'R{d́ =*}:[ZӬVd8`5NF;{xPāG`((((((((+/Mo eZwU@ξ&|5yowir^XEy1!g`N&ܺOV=s|ա5V" l@_qqfqdVB~K6dR[C[ c&MoZ>Ҝ7 ;$f7e8O?; ( ( ( ( ( ( ?hq2kρ_Nl~QEy/H;(3B((((((((k/.?z/kWJ(.>2(P(((/j(im   N p : D N q p q r shttp://www.oaktable.net/main.jsp;jsessionid=7441B6E64E8D531D15CEF0E157F7B5882 www.realvnc.org,http://www.oaktable.net/main.jsp;jsessionid=7441B6E64E8D531D15CEF0E157F7B588/ 0DTimes New Roman<( )0(Y 0DArialNew Roman<( )0(Y 0 " DTheSansMonoConSemiLight(Y 0  ` .  @n?" dd@  @@`` h45I #  2    3  U 7  (-' / $*' 10   ! !&#*+  ,%0?b$uNt*HGCs/M%.R$$ x;1M%.R$׿ Cj=aR=1~.c 1? f̙@8   g48d8d )0ppp@ <42d2d 0(g48d8d )0p6 p5<4PdPd 0(oʚ;J{)ʚ;<4ddddH 04&BRANCHTO257JHOTSPOTTYPE$DefinedInNavigator<$DEFINEDINNAVIGATORTrue2___PPT9/ 0?:- &www.go-faster.co.ukOt= `Go-Faster Consultancy Ltd. www.go-faster.co.ukP!PeopleTools 8.45 Upgrade Musings""! VDavid Kurtz Go-Faster Consultancy Ltd. david.kurtz@go-faster.co.uk www.go-faster.co.ukN ((F0(( ` Who am I?Oracle DBA Independent consultant System Performance tuning PeopleSoft ERP Oracle RDBMS UK Oracle User Group Unix SIG Oak Table www.oaktable.net www.baarf.com       ,  Book www.psftdba.com&*    _ Resources  bIf you can t hear me say so now. Please feel free to ask questions as we go along. The presentation will be available from Customer Connection Tech PUG Page www.go-faster.co.uk&{7{7*   6zMy recent experience hFinancials 8.4 SP0 No service packs PT8.41.06 Oracle 8.1.7.0.0 Windows Developed own Polish translation!6EEi  RNo App Change PT8.45.10 Oracle 9.2.0.5 Sun Solaris 9 Base language swap to Polish6DDS OBusiness Drivers Handling of Polish characters New version of SQR shipped with PT8.44 Oracle 8i going out of support Which doesn t mean that support washes their hands of you, but there is no error correction.`'^'^ NStrategy  Build a new database on the target platform/Oracle version Oracle export/import sysadm schema And another schema for legacy data migration 8Gb export in 2Gb parts Could have used Data Mover But it would have been slower Mandatory if changing database platform!T_ZEZZGZ_EG*P   <PeopleSoft Documentation Enterprise PeopleTools 8.45 Installation for Oracle Fairly comprehensive Some omissions and inconsistencies even fairly comprehensible! Enterprise PeopleTools 8.45 Upgrade n4#$4#%  V Configuration 4 x 1.25GHz 1Gb  4 x 1.25GHz 4+Gb  W.My personal preference&  PApplication Server CPU intensive cannot starve DBMS of CPU Horizontally scalable&>>Q  EFewer CPUs cheaper /CPU Oracle licence Different kernel configuration6  F QUnix Kernel Configuration On Solaris it is set in /etc/system settings recommended in Chapter 6B of PeopleSoft install guide permit 1024 file handles per process set rlim_fd_cur=1024 set rlim_fd_max=1024 Nd%*d%* ~          RUnix Kernel Configuration settings recommended in PSFT on-line performance red paper for 8.44 And further adjusted by me Increase IPC message size set msgsys:msginfo_msgmax=262144 set msgsys:msginfo_msgmnb=262144 `DBDB ~               SUnix Kernel Configuration Increase maximum number of queues set msgsys:msginfo_msgmni=1024 1 per Tuxedo queue So 1 per process type: PSAPPSRV, PSQRYSRV etc. 1 per server process 3 PSAPPSRVs => 3 queues 1 per WSL, WSH, JSL and JSH 1 per BBLv"4/&"4/&~&      a   2 UUnix Kernel Configuration BMainly required by Oracle set semsys:seminfo_semmns=4096 (max semaphores) set semsys:seminfo_semmnu=4096 set semsys:seminfo_semmni=512 (semaphore sets) set semsys:seminfo_semmap=512 set semsys:seminfo_semume=10 set semsys:seminfo_semmsl=8 set shmsys:shminfo_shmmni=100 (max shared mem segs) set msgsys:msginfo_msgtql=1024*((                                                     7{Oracle Versions WOracle 8.1.7.4.1 Terminal Release Went out of support 31.12.2004 Certified up to PT8.45&GGX  Oracle 9.2.0.5 Highest version certified by PSFT Security Patch 68? 9.2.0.6 Includes security patch Only Some platforms certified so far 10g? Not yet certifiedZ5ZZ>ZZZ5>  :~Oracle Database Creation PeopleSoft Database Creation Wizard  magic is about illusions, everything is hidden I refuse to use it to create my database because I can t see/control what it is going to on! PSFT abandoned Oracle DBCA in PT8.4 It was better because DBA could control it Can generate a set of scripts Manual scripts are still Oracle 8 orientedj$ZZ$ZJZ+Z$$J+K =Oracle SQL*Net Query Kill from PT8.44 requires SQLNET.EXPIRE_TIME ps doc says this is seconds, but it is actually minutes. Oracle Metalink note 151972.1: DCD explained BEQUEATH_DETACH=YES Oracle Metalink note 74839.1 `3f3fb3  >  9   @GSC 200723987: SQL*Net Fix Application server error on pslibora Extra symbolic link on SQL*Net library ln -s $ORACLE_HOME/lib32/libclntsh.so.9.0 $ORACLE_HOME/lib/libclntsh.so.8.08LL 'L~  (         AOracle SQL*Net Bug rUse the 9.2.0.5 client Oracle OCI bug fix 9.2.0.2 Remember to patch the client not just server! GSC 200737351<NNs 8|Application Designer Projects ]XML from PT8.4x XML Very flexible Buzzword compliant But slow to open CPU intensive to parseD*$*$^ 9}PLTLSCUR upgrade projects hRelative to 8.40 PT Upgrade Project 35m PT ML Upgrade slow 3x larger 1h25m! (all languages) 5000+ fieldsL$.$.i yUnix Installation Java Installer GUI interface under X-terminal Xterminal on the cheap - www.realvnc.org Also good across slow network link! Same interface as windows Same concept as Oracle Universal Installer Add /usr/openwin/bin to path Set DISPLAY=:0.0 .:.i  .       o    +   0GV;Notes BEA Tuxedo 8.1 R2 CDs shipped with PT8.45  RP89 Win  De-install rolling patch before applying new RP. Weblogic 6.1 from PT8.40 Weblogic 8.1 from PT8.43/44? PIA now under PS_HOME not WL_HOME!LY6#Y6#  XCobol  Financials uses remote call On-line voucher edit and post Application server synchronously initiates Cobol batch program So must have Cobol compiler on same OS as application server&  >Gotchas  oREN server configuration PTWEBSERVER operator Base Language Swap Various process scheduler problems PeopleBooks$p K p ?GSC 200761534: REN Sever  Previously optional Now used for standard functionality from 8.44 Defaults to port 7180 Specified in psappsrv.cfg But also in database Changing psappsrv.cfg not enough UPDATE PSREN SET PORT_NUM = 7780;~.r.    "tf        - BGSC 200761492: PTWEBSERVER user  User ID used by sign-on panel before sign-on. Put this in in PIA install In WebLogic config.xml Encrypt PSCipher.sh Add user PTWEBSERVER PeopleTools Web Server role PeopleTools permission list PTPT1500.+V.     8 ZL       W KData Mover Bug  Base Language Swap If date-time field as a part of unique key Data Mover strips time portion of data Can result in duplicate key error Putting date-timestamp in primary key is poor design&  C+GSC 200777344: Process Scheduler Privileges , DAdd ProcessSchedulerAdmin role to user who starts process scheduler.$E,&  + HProcess Scheduler  dAdditional purge classes in PT8.44 Remember to set purge settings BEFORE you start process scheduler e IDefault Process Scheduler  Defaults in process scheduler page UPDATE psprcsruncntls SET servername = ' ' WHERE servername != ' '; Assign primary OS and enable load balancingN$ZEZ,Z$E+Z+         6 Y#New process scheduler functionality $ From PT8.44, it is now possible to have different elements of a job running on different process schedulers. Eg. Cobol process on Unix because application server on Unix and remote call Crystal report on Windows Must leave scheduler name blank else will get error on submissionmZZZ3ZZ!Z"Zm3 ! " &m   Z&GSC 200766251: Processes remain queued ' VProcesses remain queued when no server name in request Set blank categories to Default:7 7 W [:Process Still Remain Queued when Scheduler is blank - RTFM ; Remember to set process server system settings PeopleTools -> Process Scheduler -> System Settings Assign a Primary OS Can also Load Balance to any OS or just Primary OS:/4G/4G  JReport Repository  QPosting status help separately on PSPRCSRQST Report Node held on PS_CDM_AUTH_LIST R D(GSC 200780041: SchedulerTransfer servlet&    (SchedulerTransfer servlet for HTTP transfer to Report Repository Even if you use FTP need servlet to verify transfer (new in 8.44?) Servlet was subject of a security alert Authentication added Set password (any password) on default local node PeopleTools -> Integration Broker -> Node DefinitionsAC(260C(26    F GSC 200728339: Cobol Compilation ! :Need to add /usr/ccs/bin to path GSC 16201: ignore  01 or 77 level required errors when compiling ??C?????.cbl. These are copy books and so can be ignored.8,r rZ     X  / GGSC 200944167: PeopleBooks  From 8.44 install on Unix Batch transfer replaced PT8.45 PB can be installed over old application PeopleBooks Collection (for indexing) does not work Need to delete srch.js in language subdirectories prior to new PB installation Single Weblogic Server Issues PSOL not PORTAL serverT(OT(O  @    n L"GSC 200946000: Performance Monitor # Allow access to monitor servlet diagnostic information PeopleTools>Web Profile> Web Profile Configuration>"Profile Name">Customer Properties PPMConsole = trueF7V8V&    M Other Issues  H200735163 - PeopleTools objects read only in permission list ALLPAGES  since 8.42 200751620 - Crystal Date Format Issue  affects pt8.42 only, says fixed in 8.43? ICE Incident 569443000 command line parameter -LX0 to Crystal process type Fixed the date issue in pt8.45 but not number issue.* % P Side Effects  ,PSFT didn t ship Polish translations for FSCM 8.4 SP0 So customer developed their own translations PT8.45 does ship with Polish translations Decision taken to take  vanilla PeopleSoft translations Various effects on many application panels Eg. Next, Previous, Save buttons etc.T6Z-ZcZQZ6-cQ&  $ a Questions?  WHow many on PT8.4? How many >= PT8.44? PT8.45? Oracle? Oracle 9? Oracle 10 (elsewhere)? X o!PeopleTools 8.45 Upgrade Musings""! VDavid Kurtz Go-Faster Consultancy Ltd. david.kurtz@go-faster.co.uk www.go-faster.co.ukN ((F0(( /bDF1PTQ\RP ` ___f3f` ___3f` 999MMM>?" dd@,|?" dd@   " @ `"  n?" dd@   @@``@n?" dd@  @@``PR    @ ` ` p>> 0 k c  8 (  8pF  q0a 8 q 0a2 8 C BUCENG HZI8Qf3? جU,جU,8`T,8`T q0a2 8 C BUCENG HZIDQD? U8U8D`T8D`T 2 8 C BUCENG HZIEQ[? U9U9E`T9E`T dn" 8  G/*d6?@33@@@sf 4 8 Zgֳgֳ ?  T Click to edit Master title style! !: 8 TLgֳgֳ ?0  RClick to edit Master text styles Second level Third level Fourth level Fifth level!     S  8  `tgֳgֳ ?`  GPSFT Tech PUG 10.1.05   8  `(gֳgֳ ?   B*  8  `gֳgֳ ?   B*H 8 0޽h? ??0888 ___f3f Fireball     @ <u (  <pF  0  <  0 2 < C BUCENG HZI8Qf3? جU,جU,8`T,8`T 0 2 < C BUCENG HZIDQD? U8U8D`T8D`T 9Y 2 < C BUCENG HZIEQ[? U9U9E`T9E`T " <  G/*d6?@33@@@sf  < Zܭgֳgֳ ?`  T Click to edit Master title style! ! < Tgֳgֳ ?0 `    W#Click to edit Master subtitle style$ $  <  `$“gֳgֳ ?`  @*  <  `œgֳgֳ ?   B*  <  `ʓgֳgֳ ?   B*H < 0޽h? ??0<<< ___f3f 0 bZ`(    Z'1 ?0   Z* X  C  i  @  Z*1 ? *?  RClick to edit Master text styles Second level Third level Fourth level Fifth level!     S  Z/1 ?a i0  \*    `/1 ?,\   Z*    `@91 ?,a i\  \* B  s *e ? ̙33V & 4(  4  4 Z$1 ?0   j*David Kurtz     4 Z01 ?a i0  V*   b 4  `l1 ?,\   h*Experiences of Global Temporary Table in Oracle 8.155  5  4  `l1 ?,a i\  X*  H 4 0e ? ̙33` 6: &www.go-faster.co.uk 0L(    # l(Փgֳgֳ ?<`     fՓgֳgֳ ?<  f2  c ؓgֳgֳvd @?UQl$ 0q 0 0 > 2 f2  c 8ܓgֳgֳvd @?@UQ< l$ 0: 0 0 > 2 f2   c p˓gֳgֳvd @? UQ l$ 0D 0 0 > 2 f2   c 4gֳgֳvd @?@ TP< l$ 0N 0 0 > 2   AJ)http://www.oaktable.net/oaktable.jpg `r  0B  s *޽h ? f3f3f 6 .&p`(  `r ` S f8    ` S g8 <$ 0   ` S hh8p 0<$ 0   ` s dA:C:\user\Ppt\psftdbacover.jpgj @,$D 0H ` 0޽h ? ___f3f P \0(  \x \ c ${8   x \ c $|80  H \ 0޽h ? ___f3f  f^T(  Tr T S `E8    T S 88 0<$ 0   T S B8p 0<$ 0  H T 0޽h ? ___f3f  $(  r  S T8   r  S 80  H  0޽h ? ___f3f(  P(  r  S Ȯ8     S 80<$ 0  H  0޽h ? ___f3f(  |P(  |r | S 8    | S 80<$ 0  H | 0޽h ? ___f3f  E= (  r  S i8   r  S `j8 0  r  S Xf8p 0  z8 P   `  BИ1))?P ,$D  0 ZNode$ "   `Ԙf @1))?p p,$D  0 V Web Server    8 @ P 0  `   Bؘ1))?@ P 0,$D  0 ZNode$ =    `ݘ @1))?  p,$D  0 qTuxedo Application Server&   Hߘ1))? p,$D  0 \DBMS& H  0޽h ? ___f3f 6 qi (  r   S 08   r   S 8 0     S 8p 0<$ 0  8 P @   0 `  Bx1))?P @ ,$D  0 ZNode$ "   `f @1))?p p,$D  0 V Web Server    =   ` @1))? p,$D  0 qTuxedo Application Server& h8 P 0  `  Bd1))?P 0,$D  0 ZNode$    H1))? p,$D  0 \DBMS& H  0޽h ? ___f3f  $(  r  S |$8   r  S 8%80  H  0޽h ? ___f3f  0(  x  c $48   x  c $580  H  0޽h ? ___f3f  0(  x  c $B8   x  c $C80  H  0޽h ? ___f3f    $(   r   S P8   r   S tQ80  H   0޽h ? ___f3f Q6 :20X(  Xr X S \c8   r X S d8 0   X S d8p 0<$ 0  H X 0޽h ? ___f3f(  @pP(  pr p S k8    p S }80<$ 0  H p 0޽h ? ___f3f  P$(  r  S ̝8   r  S 80  H  0޽h ? ___f3f  `$(  r  S Xɐ8   r  S 80  H  0޽h ? ___f3f  \Tp(  r  S 8   r  S P80  |  T1?R<  3 A? H  0޽h ? ___f3f  \*(  \r \ S 0›8   x \ c $›80  H \ 0޽h ? ___f3f  d$(  dr d S hϛ8   r d S  80  H d 0޽h ? ___f3f F 0(  x  c $<ڛ8   x  c $ڛ80  H  0޽h ? ___f3f 6 t$(  tr t S 8   r t S 80  H t 0޽h ? ___f3f   $(   r   S H8   r   S 80  H   0޽h ? ___f3f  $(  r  S 8   r  S ސ80  H  0޽h ? ___f3f  $(  r  S < 8   r  S  80  H  0޽h ? ___f3f  0(  x  c $8   x  c $l80  H  0޽h ? ___f3f  $(  r  S X'8   r  S (80  H  0޽h ? ___f3f  $(  r  S 048   r  S 480  H  0޽h ? ___f3f   0(  x  c $A8   x  c $dB80  H  0޽h ? ___f3f 6 0$(  r  S N8   r  S HO80  H  0޽h ? ___f3f  @$(  r  S T^8   r  S ^80  H  0޽h ? ___f3f  P(0(  (x ( c $8   x ( c $Ѝ80  H ( 0޽h ? ___f3f R  $$(  $r $ S 8   r $ S P80  H $ 0޽h ? ___f3f  `$(  r  S >8   r  S H80  H  0޽h ? ___f3f  p$(  r  S 8   r  S ؒ80  H  0޽h ? ___f3f  $(  r  S D8   r  S 80  H  0޽h ? ___f3f  $(  r  S о8   r  S 80  H  0޽h ? ___f3f 6 $(  r  S l͞8   r  S (Ξ80  H  0޽h ? ___f3f  $(  r  S Þ8   r  S l80  H  0޽h ? ___f3f  $(  r  S ,8   r  S 80  H  0޽h ? ___f3f(  P(  r  S 8     S T80<$ 0  H  0޽h ? ___f3fx D: &www.go-faster.co.uk Xd(  X X C xpgֳgֳ ?<`   X 3 r@gֳgֳ ?<  f2 X c $gֳgֳvd @?UQl$ 0p 0 0 > 2 f2 X c gֳgֳvd @?@UQ< l$ 0q 0 0 > 2 f2 X c Tgֳgֳvd @? UQ l$ 0r 0 0 > 2 f2 X c gֳgֳvd @?@ TP< l$ 0s 0 0 > 2  X AJ)http://www.oaktable.net/oaktable.jpg `r , 0B X s *޽h ? f3f3f 0 P@a( tdvL @X @ C i    @ S pD *?   c9An introduction to SQL*Trace, TKPROF and Execution Plans : H @ 0e ? ̙33 0 0d8(  dd d c $i    d s * *?   " H d 0e ? ̙33o 0 \8(  \d \ c $i    \ s *d *?   " H \ 0e ? ̙33y 0 i(  ^  S i     c $I *?   _I want to talk about how to use SQL Trace, how to process the trace files, a bit on how to read execution plans. We will also talk about the timing information that you can get. But before we get into all that stuff I want to talk about why you should bother with any of that.  H  0e ? ̙33 0 @, (  ,X , C i    , S  *?   " H , 0e ? ̙33{ 0 PP(  X  C i     S Ȩ *?   R( Limited certification of both 8i and 9i) H  0e ? ̙33( 0 ,x(  ,X , C i    , S @l *?   zPThis one was in PeopleBooks, all I had to do is configure verity and look it up!Q H , 0e ? ̙33r  ߂ 07jRx_ Ob1 a 1 6Fp!%)עӠ-͸Ѻ7 \Oh+'0 px $0 T ` l x SQL TRace  David Kurtz UKOUG 2003 oNC:\Program Files\Microsoft Office\Templates\Presentation Designs\FIREBALL.POT\ David Kurtz82iMicrosoft PowerPoint 7.0t O@.@Zmi@6N@2>՜.+,D՜.+,P     OverheaduGo-Faster Consultancy Ltd.B9* .Times New RomanArialTheSansMonoConSemiLight Fireball"PeopleTools 8.45 Upgrade Musings Who am I? ResourcesMy recent experienceBusiness Drivers StrategyPeopleSoft DocumentationConfigurationMy personal preferenceUnix Kernel ConfigurationUnix Kernel ConfigurationUnix Kernel ConfigurationUnix Kernel ConfigurationOracle VersionsOracle Database CreationOracle SQL*NetGSC 200723987: SQL*Net FixOracle SQL*Net BugApplication Designer ProjectsPLTLSCUR upgrade projectsUnix InstallationNotesCobolGotchasGSC 200761534: REN Sever GSC 200761492: PTWEBSERVER userData Mover Bug,GSC 200777344: Process Scheduler PrivilegesProcess SchedulerDefault Process Scheduler$New process scheduler functionality'GSC 200766251: Processes remain queued;Process Still Remain Queued when Scheduler is blank - RTFMReport Repository)GSC 200780041: SchedulerTransfer servlet!GSC 200728339: Cobol CompilationGSC 200944167: PeopleBooks#GSC 200946000: Performance Monitor Other Issues Side Effects Questions?"PeopleTools 8.45 Upgrade Musings  Fonts UsedDesign Template Slide Titles*go   O W _gow _PID_HLINKS TemplateType GraphicType Compression ScreenSize ScreenUsage MailAddress HomePage Other DownloadOriginal DownloadIEButton UseBrowserColor BackColor TextColor LinkColor VisitedColorTransparentButton ButtonType ShowNotes NavBtnPos OutputDirA0B258,3,Custom Topic B259,4,Vital Statistics260,5,Favorite Links to Visit257,2,Custom Topic A257,2,Custom Topic A258,3,Custom Topic B259,4,Vital Statistics260,5,Favorite Links to VisitMhttp://www.oaktable.net/main.jsp;jsessionid=7441B6E64E8D531D15CEF0E157F7B588http://www.realvnc.org/Mhttp://www.oaktable.net/main.jsp;jsessionid=7441B6E64E8D531D15CEF0E157F7B5882david@go-faster.co.ukMuwww.go-faster.co.uk;Presentation to DBMS SIG of UK Oracle User Group 14/3/2000z  f3 C:\User\kurzbyrn\go-faster\#_ David KurtzDavid Kurtz  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmopqrstuvwxyz{|}~    Root EntrydO)PicturesCurrent User SummaryInformation(PowerPoint Document(nCDocumentSummaryInformation8