DB2 Connect用户指南


IBM DB2 Connect 9.7 DB2 Connect C'8O 2010 j 9 B|B V9R7 S151-1176-02  IBM DB2 Connect 9.7 DB2 Connect C'8O 2010 j 9 B|B V9R7 S151-1176-02  “b 9CKE“0d'VDz70,kHDAZ 119 3D=< B, :yw;BD#fE“# ^)fyw KD5|, IBM DyP(E“#|ZmI-iPa),R\f((D#$#>vfoP|,DE“;|(TNNz7D #$,Ra)DNNod<;h*gKbM# zIZ_r(}1XD IBM zm&): IBM vfo# v *Z_):vfo,k*A IBM vfoPD,x7*:www.ibm.com/shop/publications/order v *iR1XD IBM zm&,k*A IBM +r*5K?<,x7*:www.ibm.com/planetwide *S@zrSCsD DB2 P!Mz[?): DB2 vfo,kBg 1-800-IBM-4YOU(426-4968)# 1zr IBM “ME“1,4,bZh IBM @;^~D(&T|O*J1R;aTzlINN0lD==9CrV“C E“# © Copyright IBM Corporation 1993, 2010. ?< XZ>i...............v Z 1 B DB2 Connect En ......1 DB2 Connect ..............1 DB2 Connect a)Dz7 .........1 DB2 Connect f> 8 P;6D&\ ......1 wz}]b ..............2 DB2 Connect M SQL od ........3 DB2 Connect \m5CLr ........3 InfoSphere Federation Server M DB2 Connect. . . 4 V<=X5}]be5a9..........4 DRDA M}]CJ ...........5 DB2 Connect M DRDA ..........5 6L$w%* .............6 V<=ks ..............7 DB2 Connect =8 ............8 1SCJwz}]b ...........8 9C DB2 Connect vKf4CJ System z wzr IBM i DB2 }] ............9 DB2 Connect ~qwz7w*,S~qw....10 DB2 Connect M Web &CLr.......11 DB2 Connect M IBM WebSphere ......12 DB2 Connect w* Java &CLr~qw ....13 Web ~qwOD DB2 Connect .......14 DB2 Connect M&CLr~qw.......14 DB2 Connect MBq&m`Sw.......17 Z 2 B DB2 Connect N< ......21 |B}]b?< .............21 53}]b?<5 ...........21 Zc?<5 .............21 DCS ?<5 .............22 ?<(F$wm ............26 T,;}]b(e`vu? ........27 &m BiDi }] ............27 DB2 Connect 2+T ...........29 (} DB2 Connect xPDIE,S .....29 DB2 Connect O$“bBn ........33 s(&CLrM5CLr(DB2 Connect) ....36 `>c|B ..............39 9CXFPDtC`>c|B .......40 9CXFPDbT`>c|B .......40 `>c|BM,=c\mw ........41 9C{O XA DBq\mwdC DB2 Connect . . 41 DB2 Connect TI“nOBqD'V .....42 9C DB2 Connect 4F/}] ........42 SQLCODE 3d .............44 O* SQLCODE 3d ..........45 w{ SQLCODE 3d ..........45 }]b53`SM DB2 Connect........48 `S6LM'zD,S ..........48 9C Windows T\`Sw`ST\ .....49 9C GET SNAPSHOT |n ........49 DCS &CLr4, ...........51 KP4v`SwM/( ..........55 Z 3 B _ICTM DB2 Connect . . . 63 wz}]b,SD_ICTM:Xyb .....63 M'zT/XB7IDhvMhC(DB2 Connect) 64 dCM'zT/XB7IT+dkM'z,SV“w ...........99 DRDA zYDsx:exE“ .......103 Z 6 B {“ ............105 DB2 Connect #{Jb ..........105 =< A. DB2 SQL 4,oz ......113 CJ;,f>D DB2 E“PD .......113 Z DB2 E“PDPTzDW!oTT>wb ...113 |B20ZzDFczrZ?x~qwOD DB2 E “PD................114 V/|B20ZzDFczrZ?x~qwOD DB2 E“PD .............115 DB2 LL...............116 DB2 JOoOE“............117 unMu~ ..............117 =< B. yw ............119 w} ...............123 iv DB2 Connect C'8O XZ>i 6DB2 Connect™ C'8O7a)zKbM'0 DB2 Connect z7yhDyPE“# DB2 Connect En+TdM=8N=T> DB2 Connect Mxg73Dd{?V.dD X5#+V[f0}]b?<“53dD2+T“`=f|B“F/}]M`S DB2 Connect D“bBn#+9V DB2 Connect gNZxg73P'V_ICT#7# DB2 Connect MZxgPD_T\,+w*kJOoODI\Jb`XD;)wb}x# >iD9C_ 53\m1“}]b\m1M53(6K1&CT>iD;?Vr+?PK$# © Copyright IBM Corp. 1993, 2010 v Z 1 B DB2 Connect En DB2 Connect DB2 Connect a)k IBM® sMz}]bDlY!3,S,T)Z Linux®“UNIX® M Windows® Yw53BKPDgSLqMd{&CLr9C# DB2 Connect vKfa)k System z® M IBM Power Systems™ ~qwD1S,S, x DB2 Connect ~qwz7a)dS,S,C,SJmM'z(} DB2 Connect xX CJ System z M IBM Power Systems ~qw#;, DB2 Connect ~qwz7wT a)(;Db0MmI$“Ebv=8,b9z\!qJOz73Dz7# DB2 Connect a)Dz7 DB2 Connect _P8v,Sbv=8,dP|( DB2 Connect vKfMm` DB2 Con- nect ~qwz7# v DB2 Connect s5f v DB2 Connect &CLr~qwf v DB2 Connect ^^Ff System z f v DB2 Connect ^^Ff System i® f PX DB2 Connect a)Dz7Dj8E“,kND www.ibm.com/software/data/db2/ db2connect/ DB2 Connect f> 8 P;6D&\ >Za) DB2 Connect f>P}kDv?&\D\a#*Kb DB2® f> 9 P}k D0l DB2 Connect &\D|DPm,kNDTBwb: v DB2 Connect f> 9.5 ^)|\a v DB2 Connect f> 9.1 ^)|\a DB2 Connect f> 8 “Pf 2 P;6D&\ DB2 Connect f> 8.2 |(BPv?&\: v M'zT/XB7I g{*'k~qwr DB2 Connect ~qwD TCP/IP ,S,G4M'z+T /“TXB(“,S(g{fZ8C~qw)#8C~qwGZ~qw5} O8(D,d;C+Z,SZd“MxM'z# v }]S\ M'z/~qw(EVZa)K1C'}]ZxgPw/1TdxPS\D &\# DB2 Connect f> 8 “Pf 1(|(yP^)|M^D6p)P;6D&\ DB2 Connect f> 8.1 |(BPv?&\: v 'V|$D SQL od(n` 2MB) © Copyright IBM Corp. 1993, 2010 1 `o 2MBD SQL odITw- CLI M JDBC &CLr#+G,6k= SZ#t 64K D^F# v j6 SQL odp4DoOE“ I7(T DB2 z/OS® f/, SQL od_Y:f“vX(odD&CLr# v %P=dk}i Jm&CLrT%v SQL oda)`iN}# v `Sxg1d 9CKBD`S*X4|CXKb}]br&CLr6pD}]bn/Mx gw?# v DB2 CLI /,Iv/Nj'V VZ,Z DB2 CLI P,1CJ DB2 (C}]b(UDB)z/OS ff> 8.1 r|Bf>D~qw1,'V/,Iv/Nj# v eWLM 'V a)K(}Pd~i`SKTK$w%*T7(?1D\&# v T DB2 ping |nDv? DB2 ping |nVZ'VksMl&|s!Df6# “:1Sf> 7 DM'z(}f> 9 DxXrwz“v PING |n1,DB2 Connect +;'VC|n# wz}]b Z{vD5P,uo}]bC4hvX5}]b\m53(RDBMS)#Zk DB2 Con- nect (EDd{53P,9Cuo“}]b”hvDEnI\aTP;,#Z DB2 Con- nect P,uo“}]b”9IT8: System z DB2 z/OS f. Id LOCATION NAME j6D DB2 z/OS fS53#(}G < TSO “9CdP;vICDi/$_“vTB SQL i/,MIT7( LOCATION NAME: select current server from sysibm.sysdummy1 Z“}<}]/”(BSDS)M DSNL004I {“(LOCATION=location)P2(e K LOCATION NAME,|GZt/“V<=}]h)”(DDF)1`4D# LOCATION NAME 'Vn` 8 vp{;C{,Sx9&CLr\;9C;, D dbalias {F4CJf> 8 z/OS ~qw#9C z/OS -display ddf |n4q ! DB2 ~qw;C{“r{“IP X7MKZ# VSE Z}]bVxPKPDI DBNAME j6D DB2 for VSE VM Z CMS ibzPKPDI DBNAME j6D DB2 for VM IBM Power Systems ~qw DB2 IBM i f,4 IBM i Yw53Dw*?V#}G53dC*9C@“( zf“X,qr IBM Power Systems ~qwO;\fZ;v}]b# 2 DB2 Connect C'8O DB2 Connect M SQL od DB2 Connect +&CLrya;D SQL od*“= IBM sMz}]b~qwP# DB2 Connect IT*“8uyPP'D SQL odT0\'VD DB2 API(&CLr `LSZ): v JDBC v SQLJ v ADO.NET v OLE DB v ODBC v Perl v PHP v pureQuery v Python v Ruby v DB2 CLI v 6k= SQL 6k= SQL 'V P=V`MD6k= SQL &m:2, SQL M/, SQL#2, SQL (}T SQL x P$H&m,Sx9C4P SQL odyh*D1dnL#/, SQL GZ+ SQL o da;A IBM sMz}]b~qw1&mD#/, SQL |in,+GI\4PCO }#=WG9C2, SQL 9G9C/, SQL,I&CLr14v(#DB2 Connect , 1'Vb=V SQL od# ;,D IBM sMz}]b~qw5V SQL D==G;,D#DB2 Connect j+'V #C IBM SQL T0 SQL D DB2 z/OS f“DB2 ~qw VM M VSE f(T0F* SQL/DS)M DB2 IBM i f5V#?R(i9C IBM SQL 4,$}]bD@“T# DB2 Connect \m5CLr *c:f> 9.7 PQ-;Fv9CXFPD0d`X*i~,ZTsD“PfPI\a +|G}%# PX|`E“,kND6DB2 f> 9.7 BvZ]7;iPD“Q-;Fv 9CXFPD$_M DB2 \m~qw(DAS)”wb# IT9CBP5CLr4oz DB2 Connect \m1: v |nP&mw(CLP)JmzT IBM sMz}]b~qw}]b“v SQL od# |+ SQL od“M=z8(D}]bP# v DB2 |nPD*|nP&mw(CLP)a)KM IBM sMz}]b~qw}]bODD~0 k“OKPDd{&CLrP# v g{z}KP DB2 Connect ~qwz7,zI9C“B~i4w”M“T\`Sw”#( }9C“B~i4w”,MITi4 DB2 Connect yGXr6L`SM\m DB2 Connect ~qwDT\# Z 1 B DB2 Connect En 3 v DB2 XFPDJmz\mM`S DB2 Connect ~qwDyP=f#|9Jm\m1 9C DB2 z/OS f}]bTs,}gm“S<“:eXM_L# v }]b53`Sw5CLrJm53\m1`S53,S#v1 DB2 Connect d1 ~qw1,K&\EIC#K5CLr9IToz53\m17(ms4#53\ m1IT9M'z&CLrk IBM sMz}]b~qwOKPD`&w5X*p4# “:ZH0“PfP,DB2 9 *<,DB2 zA4CJ(#InfoSphere Federation Server 9a)TGX5Mz|F'} ]4(g Documentum“IBM Lotus® Extended Search“ma9D~M XML)DACJ (#IT9C|4mvT*O53PD}]Di/# V<=X5}]be5a9 Distributed Relational Database Architecture™((DRDA®)(V<=X5}]be5a9) G;i-i,|Jm`v}]b53(^[G IBM D9GG IBM D)M&CLr; p$w#IT,SNN9C DRDA DX5}]b\mz7DiO4NIV<=X5} ]b\m53#DRDA (}(eXk;;D)Z]T0XkgN;;|4-w53.d D(E# $w%* $w%* (UOW) G%v_-Bq#|I;5P SQL odiI,ZC5PP, *4I&X4PKyPYw,*4C5Pw*;v{eG;I&D# V<=$w%* V<=$w%* (DUOW),VF*`>c|B,f0;v$w%*PD`v} ]b~qw#DUOW _PBPXw: v ?v$w%*|B`v}]b\m~qw# v &CLr8<$wDVd“t/d5# v ?v$w%*I\P`vks# v ?vksP;v}]b\m~qw# v Z`v}]b~qw.d-wKd5# 4 DB2 Connect C'8O DRDA M}]CJ !\ DRDA (eK}]b(E-i,+|;P(e`LSZr API(&CLr1h* 9C|G)#(#,&CLrIT9C DRDA 4+M?j DRDA ~qwI4PDN Nks#?0ICDyP DRDA ~qwM4ST#(}dV{C DRDA e5a9,DB2 Connect a) KT\Dbv=8,C=8_PM'yh*D53\mXw# Z DRDA uoP,&CLrksw (AR) GC4&mV<=,SD&CLrKDzk# AR G}Zks}]D&CLr#DB2 Connect zm DB2 Connect $w>D>X&C Lrr DB2 Connect D6LM'zOD&CLrd1&CLrksw# &CLr~qw (AS) G&m,SD}]bKDzk# DRDA 9'V&CLrkswM~qw.dxP`c,S#ZbVXKP,&CLrk sw,SAD~qwG&CLr~qw,+YBNDNNd{~qw<;F*}]b ~qw (DS),r*|;1Sk&CLrkswxP;%#Kb,*K;vdH;G“v }]bksD532;GTks4P}]b&\D53DG+,&CLrkswkn U}]b~qw.dD?v&CLr~qwr}]b~qw2;F*Pd~qw# DB2 Connect 'V9C}]b~qwMPd~qw# < 1T> DB2 Connect $w>k IBM sMz~qw.dD}]w(Z;P>XM'z DivB)# *K5V DRDA ~qw}]b\m53kIBM }]~qwM'z.dD,S,DRDA 9CBPe5a9: < 1. DB2 Connect ~qwk IBM sMz~qw.dD}]w Z 1 B DB2 Connect En 5 v V{}]m>e5a9 (CDRA) v V<=}]\me5a9 (DDM) v q=/}]TsZ]e5a9 (FD:OCA) v +dXF-i/rXx-i (TCP/IP) b)e5a9Cw9(i#(}xgw/D}]wGI DRDA e5a98(D,|5 wK'VV<=X5}]bCJD}]w-i# ks(}|,wV`M(EE“D?;vKPyp*F&CLrD}]bM'z,|CJ|,'1 J'mM“nJ'mD}]bT0;WQCF.m#C&CLrXk: v S\*SC'gfP*FD\n# v S“nJ'Pu%C\n“7(BD`n# v A!QCF.mT7(“nJ'D;WQCT0x(D`n# v S“nJ'Pu%;WQC# v +*F\nmSA'1J'P# v d5Bq($w%*)# 6 DB2 Connect C'8O *hCbyD&CLr,zXk: 1. Z,;}]bP*“nJ'“'1J'M;WQCF.4(m# 2. g{omOG6LD,G4hC}]b~qwT9C`&D(E-i# 3. g{omOG6LD,G4TZcM}]bxP`?Tj6}]b~qwOD}] b# 4. T&CLrxP$`k,T8(`M 1 ,S;2MG5,Z PREP |nO8( CONNECT(1)# V<=ks V<=ksG;VV<=}]b&\,|Jm&CLrMC'Z%vodPa;}C =vr`v DBMS r_}]bD SQL od#}g,=v;, DB2 z/OS fS53P Dm.dD,S# DB2 Connect 'Vg}]bM DBMS DV<=ks#}g,zITZDB2 mk Oracle S<.d4P UNION Yw#\'VD DBMS |( DB2 5P(g DB2 }]b Linux f“UNIX fM Windows f“DB2 z/OS fM DB2 i f)T0 Oracle DI1#1+ DB2 Connect k InfoSphere Federation Server dO9C1,`)&L'VI)9C# V<=ks*}]bTsa)K;C8wT#g{}%K(mMSwbEv8 v=8,|GI\JCZzDX(h*r73# 1SCJwz}]b DB2 Connect Dy>&\Ga)S$w>OKPD@f&CLrAwz}]bD1S, S#a)Kbv=8Dnr%l(G9C_P DB2 Connect mI$DIBM }]~qw }/Lr|# 20K DB2 Connect vKfD?v$w>Ik DB2 z/OS f“DB2 IBM i fM DB2 }]b Linux f“UNIX fM Windows f~qw(“1S TCP/IP ,S#Kb,&C LrITZ,;BqP,SM|B`v DB2 5P}]b,R_P=WNd5-ia) D+?}]j{T# Z 9 3D< 3 T>S20K DB2 Connect vKfD$w>A IBM sMz}]b~q wD1S,S# 8 DB2 Connect C'8O “: 1. ;X+ DB220Z DB2 Connect vKf$w>O#g{k* DB2 Connect vKf $w>OPj{DX5}]b\m53,G4): DB2# 2. yP IBM }]~qwM'z&\Gf DB2 Connect vKfa)D# 3. g{ktCK[O53{CD DB2 z/OS f}]b~qwD,SO*,G4M'z +T/“TXB(“C,S# 9C DB2 Connect vKf4CJ System z wzr IBM i DB2 }] ;PPd~qwD1S,SG;VG#=cMmkDdC#TZ IBM sMz}]b~ qw'V TCP/IP ,SDivHdgK#Zb)ivB,?v DB2 Connect $w>< +k IBM sMz}]b~qw(“1S,S# TCP/IP ,S*s IBM sMz}]b'V TCP/IP#BPf>'V>z TCP/IP ,S: v DB2 z/OS ff> 7.1 r|_f> v DB2 IBM i f V5R1 r|_f>,T0 v DB2 ~qw VM M VSE ff> 7 r|_f> *,SA IBM sMz}]b~qw,h*ImSA IBM }]~qwM'zD DB2 Connect mI$# < 3. DB2 Connect k IBM sMz}]b~qw.dD1S,S Z 1 B DB2 Connect En 9 < 4 T>20K DB2 Connect vKfD$w>,“RC$w>1S,SA IBM sM z}]b~qw# DB2 Connect ~qwz7w*,S~qw DB2 Connect ~qwJm`vM'z,SA IBM sMz}],“ITxuY(“M, $Ts5}]DCJyhD$w#Z 11 3D< 5 5wK3)73B IBM Dbv=8, Zb)73P,zk* DB2 M'z(} DB2 Connect ~qwz7(g DB2 Connect s5f)k IBM sMz}]b~qw(“dS,S# “:vZ Linux“UNIX r Windows OKPD DB2 M'zr JCC M'z'VdS, S#“T9CNNd{M'z(} DB2 Connect ~qwz7k IBM sMz}]b~ qw(“,Sa9ZZ?9C Web &CLr,xb)Lr(#2Ps(}]b# < 5. DB2 Connect s5f Z 1 B DB2 Connect En 11 C'Z Web 3fOnCmq,b)mq(} CGI ;a;A Web ~qwOD&CLr rE>#SB4,E>+9Ca)D}]b API 4+ SQL i/a;Awz}]b#; s,,;E>I9Ci/Da{49( Web (HTML) 3““MXC'D Web /@w “T>v4#}g,;v*z?<,C'IZdPi/X(L7r~qDICT0n B[q# CGI &CLrDhFr%“RWZ,$#r* CGI j<,1@“ZYw53MoT, yT|8uICZyPFc=(#CGI LrIC C++ rE>oT(g Perl r PHP) `4# d; CGI I\4p4CsGyZ Web D&CLrDmkbv=8,+|2PwTD 1c#CGI D`L73“;sd{ API GyjF#Kb,TZsf#DgSLqYw 45,IluT2G;vJb#?NwC CGI &CLr1,+Z Web ~qwO4( ;vBxL#?vxLXk(“|T:k}]bD,S“Ra;di/#Zs?DB qT73P,KV^TI\azzOXDT\Jb# I+ DB2 Connect k Web ~qwdO9CT4(!3D“s?DgS3W&CLr# DB2 Connect a)K;)bv=84DxyZ Web D&CLrDT\#f“}LJm DB2 Connect C'uY*“MA}]bDi/}# ,SX5MKk}]b,SMO*,SD5J# 9C PHP w* Web ~qw#ire~ d; PHP ICZ CGI `L,+|(#Cw Web ~qw#ire~#Z`xL Web ~qw(g Apache)P,IT9CCZ PHP D IBM DB2 }/Lr4uaIluT Jb#Z`xL Web ~qwP,+4CxLX4&m Web ~qwks#*\b*? v Web ks9(}]b,S,IT4(Vx,S#ZK73P,Vx,SITZ%v PHP E>D6'bfZ#g{sx Web ksh*j+`,D,S,G4+4CK, S# DB2 Connect M IBM WebSphere IBM WebSphere® a)DgSLqbv=8H9C+3DE>`F$_(g PHP)a) D|jF#WebSphere Application Servers ;+4P PHP DwVI\DE>`F,x RJmz(} Web “9C servlet“ASP M Enterprise JavaBeans™ 4a)4SD_K ~ q , “ R 9 a ) T y Z Web D < u ( } g , Java™ “ TCP/ IP“HTTP“HTTPS“HTML“DHTML“XML“MIME“SMTP“IIOP“ X.509 0d{) D'V#hz WebSphere,zIT: v {C5gj<4a_*“YHM+%YwTns/ v ekZ}=$_cZ]T\M9CJ v inw{>cT]I|`C'M,$LB? v Z;)w*DYw73(AIX®“HP-UX“Linux“Novell NetWare“z/OS“IBM i“Solaris Yw53M Microsoft Windows)OxP?p v 9CVPD Web ~qw,|( Apache“IBM“Netscape M Microsoft a)DG) ~qw# 12 DB2 Connect C'8O WebSphere ;G;vz7,xGkT}v;,?jP!D}vz7D5P#WebSphere bv=8DKD?VG WebSphere Application Server# WebSphere Application Server *}V`MDTsa)73#;VG JSP(Java server page),|`FZ ASP#Z~vi~I Java servlet iI,xZ}VG Enterprise JavaBeans#Enterprise JavaBeans GBKDC4?psf#“!3Ds56&CLrDj <# WebSphere &CLrITk Web ~qwM DB2 ?pZ,;=(O#TZ DB2 z/OS f“DB2 ~qw VM M VSE f M DB2 IBM i f,WebSphere k DB2 Connect ~ qwz7?pZ,;=(O# P`v WebSphere bv=8,T0 Rational® Application Developer(RAD)#*Kb |`E“,kCJ http://www.ibm.com/software/webservers/appserv/was/ DB2 Connect w* Java &CLr~qw (}9C Java,m`E>oTD1c`Fbv=8(g Perl DBI r Microsoft ASP)k DB2 dO9C, r*x9C Java &CLr~qwa)D|!3Dbv=8(}g IBM WebSphere)# * Java Lr1a)K=V&CLr`LSZ(API)#Z;vG JDBC,|'V9C Java 4*“}]P* Java Applet“Java &CLrT0 Java servlet“Java server pages(JSP)M Enterprise Java Bean(EJB)#JDBC GwCcr=(wC API#m; v Java API G SQLJ#SQLJ a)KZ Java LrZ8( SQL 1SekD&\#DB2 ITZ Web BqDM'zr~qwK9Cb=V API# ZM'zK,applet“}]P*(data-aware)applet M&CLrG\'VD#Z}]b K,Java tC|(}]bTs(gC'(eD/}Mf“}L)# TZ DB2 z/OS f“DB2 ~qw VM M VSE fM DB2 IBM i f,P=V;,D= (IC4?p Java &CLr#I9C DB2 Connect vKf(} TCP/IP a)D1S ,S,2I!q(} DB2 Connect ~qwz7xP,S,Cz7a)k IBM sMz }]~qwD,S# Zb=VivB,Web ODC';h*NNXbDm~4CJ}]b,;hj(g PHP)r CGI E>D,;BqZ9C`v}]bD\&# f“}L sZM'z/~qw73P;y,Web &CLrD;vX*“bBnG!?uY“zZ HTTP Server ksK}]b.dDw?#K“bBnZs?BqT&mPXpX*,b V&mGs?VgSLq&CLrDKD# FvD=(G+f“}LP|(D`LM5q_-k CGI &CLr`L[OZ;p# DB2 }]b Linux f“UNIX fM Windows f M DB2 z/OS f“DB2 IBM i fM DB2 VSE f+?2m,;N}<(4wCf“}L# k9C#f Web SZE>;y,Web /@w+m%a;xKP Web SZE>D Web ~qw#+G,;G+?v%@D SQL od“MA DB2 }]b,xG“M4Pf“ }LDks#Kf“}L|(Km` SQL od;g{;Cf“}L,b)od+*% @XKP#f“}LuYKZ Web SZE>ksK}]b.d4Xw/D{“}# f“}LDw*EcGuYK HTTP Server k DB2 }]bsKdDxgw?# DB2 Connect M&CLr~qw M'z/~qw&CLrDvV9&CLrhF_IT(}Zng Windows .`D=( O*&CLra)#,1,|JminX +}]b\m&\&CZwVYw53M2~=(O!3D}]b~qw# M'z/~qw#M(dP&CLr_-VO)(#;F*=cM' z~qw#Z=c#MP,&CLrGZM'zcO?pD,x}]b~qw5V~ qwrsKc#DB2 Connect a)T 2 cM'z/~qw&CLrD+f'V,dP} ]b~qwG DB2 z/OS f“DB2 IBM i fr DB2 ~qw VM M VSE f# fEM'z/~qw&CLrs!DvS,=cM'z/~qw#MD^sV^TMT> v4K#+s?D5q_-Va9d|\mI*4 SRI>_:D$w#NN5qfr|DOxP,,1*7#5qfrD& C*;B# =cM'z/~qw#MDm;v1cfEbyD&CLr9CDJ4?)sxTVv 4#?pIYrO'DVM'z((#byFt=cM'z)vSKT?vM'z$ 14 DB2 Connect C'8O w>D&m\&M]?D*s#Kb,T}]b~qwD*s2ssDvSK,-r G?vM'zh*;v(CD}]b,SM,$kbyD,S`X*DJ4#IZf “}LDc:9C,V“5q_-T=cM'z/~qwD@5I\PyuY,+g{ ;T#Mwv|D,m;v1c;]Wbv# &CLr~qwbv=8 fE=cM'z/~qw&CLrDI>M4STDO},s?VnsD&C Lr*D_-5V=8#s=c #M;y,(#h*(}9Cf“}L4DxT\,TK9d5qfrD5 V# r*M'z$w>;Y5VsiD&CLr_-,xGv&mC'D;%w C,yTQss5MKTM'zcDJ4hs#B5O,}c#MPDM'z c(#F*]M'z#Kb,r*Pk&CLr~qw&m4TyPM'zD ks,yT|_P2mJ4D\&,g2myPM'zdD}]b,S#r ),}]b~qw;Yh*,$?v&CLrC'D(C,S# ?0,5gPfZm`}c&CLr~qwD>}#8uyPD“s5J4f .”(ERP) )&L<9C}c#M(g SAP R/3 M PeopleSoft V7 &CLr) 45V{GD&CLr#d{>}|(lHD“s5X5\m”)&L,g Siebel M Vantive# &CLr~qwM DB2 Connect DB2 Connect ~qwz7*?p`c&CLra)+f'V#DB2 Connect a )D'V|(IC4*“&CLr_-DwV API(ODBC“ADO.NET“DB2 CLI“6k= SQL“JDBC“SQLJ“Perl“PHP M OLE DB),T0C4k DB2 5P}]b~qwxP;%Dj{(Ey!a9# DB2 Connect 9'VI`v DB2 5P}]b~qwiID}]bcD5V# bJm&CLr~qwZ%vBqP5VT`v}]b~qwOD}]xP| BDBq# DB2 Connect a)D=WNd5-i'V#$bVV<=BqDj{T# } g,&CLrITZ,;BqP|B DB2 z/OS f}]bM DB2 }]b Linux f“UNIX fM Windows fPD}]#g{20KV<=ks'V“tCK |,G4&CLrIZ,;BqPA! Oracle }]bM|B DB2 5P}] b# ZB20Z&CLr~ qwyZD~qwO#+ DB2 Connect 20Z&CLr~qwOJmdNk& CLr~qwI\5VDNNJO*FM:Xyb=8#KhC9I1ZXa )|CDT\,-rG|E}KZ@“D~qwO20 DB2 Connect 1yXh DnbxgPL>#Kb,9Ir/\m,-rG;h*20M,$d{~q w# < 6. DB2 Connect T&CLr~qwD'V 16 DB2 Connect C'8O + DB2 Connect 20Z@“D~qwOZTBivBGOCD!q;zD DB2 Connect ~qwz7;ICZKP&CLr~qwDYw53r2~=(# DB2 Connect MBq&m`Sw &CLr~qwJms?DC'9CnY?D53J444P&CLr#&CLr~ qwIT)9,TJmI&CLr~qw4PD&CLrwCQ-wDBq#KBq -w(#;F*“Bq&m”(TP) `Sw#TP `Swk&CLr~qwdO9C# BqI;SwKPi/DU#YwD}PB~,(#G~qks#3rX&mBqM G TP `Sw;hFID$w`M# Bq&m ?;vi/i/D4,,yT}];aP;V1># }]j{T }]Xkm>i/D104,RZZ?XkG;BD#}g,?v)%Xkk ;vM'G<`X*# MI>/Bq r*Bq&mm>4P5qD1SI>,d53I>XkGn!D#DB2 Con- nect JmI Linux“UNIX M Windows OKPD&CLr~qwXFD&CL rT6L LAN“IBM sMz}]b~qw4PBq“I TP `Sw4-wb )Bq# Z 1 B DB2 Connect En 17 Z< 7 P,API T0&CLr~qwMsK}]b~qw.dD,SzF} ?0P!On#{D TP `SwP: v IBM WebSphere Application Server v IBM WebSphere MQ v IBM TxSeries CICS® v BEA Tuxedo v BEA WebLogic v Microsoft Transaction Server (MTS) IZIb) TP `Sw-wDBqP9C6L IBM Power Systems“System z M LAN }]b~qw# X/Open V<=Bq&m (DTP) #M 4P5q_-D&CLrI\h*C4|B%vBqZD`vJ4#}g,5V+J pS;vJ'*Am;vJ'DxP&CLr,|h*S;v}]b(“4”J')h v“fkm;v}]b(“?j”J')# < 7. DB2 Connect T TP `SwD'V 18 DB2 Connect C'8O 2PI\b=v}]bG;,D)&La)D#}g,;v}]b* DB2 z/OS f,m ;v}]b* Oracle }]b#Q-(eK TP `SwkI&CLrCJDNNJ4. dD+2BqSZ,x;GI?;v TP `Sw45V?;v}]b)&LD(CBq SZ#KSZ;F* XA SZ#9C“XA SZ”D TP `Sw;F* XA f]Bq\m w (TM)#5V XA SZDI|BJ4;F* XA f]J4\mw (RM)# OvP>D TP `SwOdC(E# 2. IT9CdCzV (CA) 4|B}]b?<# *|B}]b?<: 1. 9C?<(F$wm4U/}]b?P(}“r{~qw”(DNS) iRr_(}>X TCP/IP wzD~PDu?4bvwz{# TZ DB2 z/OS f6Lwz,1t/“V<=}]h)”(DDF)1wz{vV Z DSNL004I {“P(DOMAIN=hostname)#2IT9C -DISplay DDF | n# g{CJ z/OS }]2mi,G4r{&3dA DB2 i/, VIPA X7#K X77IA:Xn!D DB2 I1#*CJX(I1,9CCX( DB2 I1/ , VIPA X7“XU[O537Im#?vI1 DSNL004I {“X(Z I1Dr{# TCP/IP ~q{FrKZE 1(e TCP/IP Zc1D6L TCP/IP ~q{F,r_GKZE#XkZ6L wzOr TCP/IP TdxP(e#KZE 446 Q;“a* DRDA D1!KZ E# TZ DB2 z/OS f6Lwz,Z“}<}]/”(BSDS)P+KZE(e* PORT,“RZt/“V<=}]h)”(DDF)1,9Z DSNL004I {“Pa) KKZE(TCPPORT=portnumber)#2IT9C -DISplay DDF |n# g{CJ z/OS }]2mi,G4r{&3dA DB2 i/, VIPA X7#K X77IA:Xn!D DB2 I1#*CJX(I1,9CCX( DB2 I1/ , VIPA X7“XU[O537Im#?vI1 DSNL004I {“X(Z I1Dr{# “:II~qw8(Z~vKZ,TC4T TCP/IP ,SOD=WNd5xPY ,=Yw#}g,DB2 z/OS f}<}]/+8(;vKZE(RESPORT), CKZE;CZ DB2 z/OS fk>,SDY,=#b;h*(e~q{F# DCS ?<5 Z DCS ?: 22 DB2 Connect C'8O System z Id LOCATION NAME j6D DB2 z/OS fS53rZ z/OS ~q wO(eDp{LOCATION NAME .;# (}G<= TSO “9CdP;vICDi/$_“vTB SQL i /,MIT7( LOCATION NAME: select current server from sysibm.sysdummy1 Z“}<}]/”(BSDS)M DSNL004I {“(LOCATION=location) P 2 ( e K ` v LOCATION NAME, DSNL004I {“ (LOCATION=location)GZt/“V<=}]h)”(DDF)1`4 D#2IT9C -DISplay DDF |n# g{CJ z/OS }]2mi,G4r{&3dA DB2 i/, VIPA X 7#KX77IA:Xn!D DB2 I1#*CJX(I1,9CCX ( DB2 I1/, VIPA X7“XU[O537Im#?vI1 DSNL004I {“X(ZI1Dr{# VSE r VM }]b{F(DBNAME) IBM Power Systems X5}]b{F(RDBNAME) d{ TZ Windows“Linux M UNIX Yw53,Z}]b?a{/D;iPD N=5X}]#TZ?;P,9P;v5XD SQLCA,(#| ,cr}D sqlcode(}g,+12 r +802)#g{zZ DB2 Connect ~qwO9C(F3dD~,G4Z|G|,Z(F3 dD~P“R_P(F3dDivB,+;a3dbV}D sqlcode(}g,+|G3dAm; sqlcode r|G_P(Fj G3d)# ?wbc\X*: 1. }D sqlcodes m>/f,k:D sqlcodes `4,s_m> ms4,#yP:D sqlcodes +ZyPivB\G;3d D,;[Z9CDv3dD~#yP}D sqlcodes(|,Z (FD3dD~P“R3dAdTmx^NN|D)2+ ;1;3d#mb,b)}D sqlcodes(4|,Z DB2 Connect ~qwODQ(F3dD~P)2+;1;3d# 2. g{9C1!3dD~,r1Skwz}]b,S,G4 sqlcode 3d+\GTyP sqlcodes 4P# Z 2 B DB2 Connect N< 23 ,D bGZ~v;CN}#g{8(KCN},G415XBP SQLCODES .;1,&CLr+k IBM sMz}]b~qw }]bO*,S: SQL30000N SQL30040N SQL30050N SQL30051N SQL30053N SQL30060N SQL30070N SQL30071N SQL30072N SQL30073N SQL30074N SQL30090N 148(O*,SN} ,D 1,v15XBP SQLCODE 1, E+4PO*,S: SQL30020N SQL30021N SQL30041N SQL30061N SQL30081N PXb)zkD5w,NDMessage Reference# “:g{ DB2 Connect IZ“zmsxO*,S,G4+T/ 4PXv# ,,INTERRUPT_ENABLED bGZ}v;CN}#g{UK~qw;'VPO,G4v INTERRUPT_ENABLED JC#g{~qw'V DRDA PO w,G4 DB2 Connect +v+POks+M= DRDA ~qw O# g{Z DB2 Connect $w>D DCS ?Q-U9Kk~q wD,S#rK,&CLrXkk IBM sMz}]b~qw( “BD,S,E\&md{}]bks#Z AIX V5.2 M|B f>T0 Windows .bD=(O,1&CLr9C DB2 Con- nect SUPOks1,|;'VT/O*,SD!n# “:ZNN=(O,K'V″ KN}GZ_v;CN},IC|4tC DB2 Connect UZq =/'V#bG(}T 9CUZZk45VD,gB y>: Y(z“vBP CLP(|nP&mw)od: catalog TCPIP node nynode remote myhost server myport catalog dcs database nydb1 as new_york catalog database nydb1 as newyork1 at node nynode authentication server }]bp{ newyork1 +CZCJwz}]b,x;xPUZd ;,r*P48(UZZk# ;x,hzBDUZq=/'V,zVZIT9CBP CLP | n#ZKivB,r*9CK CLP “RN}V{.>mG9C +}E8(D,yT,XkZ=T+}EZ8( LOCALDATE 5#“b9CYw53*eV{“\”(41\),T7#Z LOCALDATE f6P;ap“+}E# catalog dcs database nydb2 as new_york parms \“,,,,,,LOCALDATE=\“\“YYYYMMDD\“\“\“ catalog database nydb2 as newyork2 at node nynode authentication server }]bp{ newyork2 *za)KT`,wz}]bDCJ, +G,|98(KUZq=Zk#K>}5wUZq=1dZ kG9CX|V LOCALDATE 8(D,“R,|G DCS ? KN}GZEv;CN},ICKN}48(CZ2G1!~ qw}]b BiDi CCSID D“+r”(BiDi) CCSID#}g: “,,,,,,,,BIDI=xyz“ dP xyz m> CCSID 2G# ?<(F$wm ?<(F$wmT>zh*U/DE“#zI\a“VFwC$wmD;v1>“d k535a|=c# Zc?} zD5 Zc{ DB2NODE 6Lwz{(TCP/IP Zc) ZOSHOST ~qw(TCP/IP ~q{FrKZE) db2inst1c(r 446) “: 1. DRDA D1! TCP/IP KZE* 446# 2. }Gz*@ IBM sMz}]b~qw'V SECURITY SOCKS,qr;** TCP/IP Zc8( SECURITY# DCS ?} zD5 }]b{F DB2DB ?j}]b{F NEW_YORK3 &CLrksw N}V{. ″,,,,,,LOCALDATE=\″\″YYMMDD\″\″\″ 53}]b?} zD5 }]b{F DB2DB }]bp{ NYC3 26 DB2 Connect C'8O m 3. 53}]b?} zD5 Zc{ DB2NODE O$ SERVER T,;}]b(e`vu? TZ?v}]b,XkZ}v?<(Zc?<“DCS ?`M(LOGICAL k VISUAL) r*;,=(OD1!5;;y,rKZ+ DB2 }]S;v=(“M=m;v=(1 avVJb#}g,Windows =(9C LOGICAL UNSHAPED }],x z/OS }] (#* SHAPED VISUAL q=#rK,g{;PT BiDi tTD'V,G4S DB2 z/OS f“MA Windows OD DB2 Connect D}]+aTms==T># 1Z DB2 Connect k~qwOD}]b.d;;}]1,(#GSU=Tdk}]4 P*;#,;<((#9+JCZ BiDi }45wK&\?~D9C# Y( Hebrew IBM }]~qwM'z}ZKP CCSID 62213(BiDi V{.`M 5), xzkCJ}ZKP CCSID 424(BiDi V{.`M 4)D DB2 wz}]b#;x, z*@ DB2 wz}]bP|,D}]4GyZ CCSID 62245(BiDi V{.`M 10) D# ZKivBfZ=vJb#Z;vJbMG DB2 wz}]b;*@xP CCSID 424 M 62245 D BiDi V{.`M.dDxp#Z~vJbMG DB2 wz}]b;\6p IBM }]~qwM'z CCSID 62213#|;'Vk CCSID 62213 yZ,;zk3D CCSID 62209(BiDi V{.`M 10)# z+h*7#“M= DB2 wz}]bD}]GT BiDi V{.`M 6 q=*7,“R 9&CC DB2 Connect *@|*TS DB2 wz}]bPSU=D}]4P BiDi < Vd;#+T DB2 wz}]b9CBP`?: catalog dcs database nydb1 as TELAVIV parms “,,,,,,,,BIDI=62245“ bf_ DB2 Connect *C 62245 42G DB2 wz}]b CCSID 424#K2G|( BP&m: 1. DB2 Connect +9C CCSID 62209(BiDi V{.`M 10),SA DB2 wz}] b# 2. DB2 Connect +Td+*“MADB2 wz}]bD}]4P BiDi PhC DB2BIDI#T ZZ DB2 Connect ~qwD6LM'zOKPD&CLr,,yXkZCM'zO hC DB2BIDI d?# 2. g{zk* DB2 Connect T*“M= DB2 wz}]bD}]4Pm;^D,a{9 DB2 ~q w;\6pC SQL i/#XpG,1IT9Cd{V{.`M1,&!?\b9C IMPLICIT CONTEXTUAL M IMPLICIT RIGHT-TO-LEFT CCSID#g{ SQL i /P|,C}E}p4DV{.,G4 CONTEXTUAL CCSID I\azz;I$ bDa{#Z SQL odP*!?\b9C}E}p4DV{.,x&C!I\9C wd?# g{X(D+r CCSID }(?PG;iN}): 28 DB2 Connect C'8O NOMAP /u/username/sqllib/map/dcs1new.map,D ,D ,,INTERRUPT_ENABLED NOMAP,D,INTERRUPT_ENABLED,,,SYSPLEX,LOCALDATE=“YYMMDD“,, mb,g{;8(N}V{.,2ITS\1!5# “:Z UNIX 53O,IZZN}V{.P8( LOCALDATE Zk1h*8(=T+ }E,yT1SYw53D|nP9C CLP 1,Xk9CYw53*eV{“\”(41 \)#}g: db2 catalog dcs db x as y parms \“,,,,,,LOCALDATE=\“\“YYMMDD\“\“\“ b+zIBP DCS ?X}]b{F =X ?j}]b{F =Y &CLrksw{ = DCS N} = ,,,,,,LOCALDATE=“YYMMDD“ “M = DCS ?<“Pf6p = 0x0100 DB2 Connect 2+T 19C DB2 Connect 1,C'O$G#X*,-rGC'I\,1(}>Xr6L, S=5P{Gk*CJD}]D DB2 Connect M}]b# IE,SM Kerberos 'V+kCZwzzwOD}]bD2+T“bBn;,9V# (} DB2 Connect xPDIE,S 3) DB2 }]b~qw'VIEOBD#IE73Jm}]b\m1}d{u~b9 (e;)u~,Zb)u~BJmM'z&CLr4(IE,S#IE,SIT4P ;c,S^(4PDYw# P=V`MDIE,S:T=IE,SM~=IE,S#4(,S1,zD,SGT =IE,S“~=IE,S9G#f,S!vZzGqksIE,ST0,SGqz cZ~qwDIE73P(eDu~,kNDm 4 PD\a# m 4. ,SD`M!vZ;,DYwiO K,S{O~qwTIE,S (eDu~ K,S;{O~qwTIE, S(eDu~ z*s,SIE T=IE,S # f , S “ 5 X / f SQL20360W(SQLSTATE 01679) z;*s,SIE ~=IE,S #f,S }KZC'9C,S1ZhC'Y1G+X(b,~=IE,Sk#f,Sj+` ,#ZhDG+X((g{P)Z9,SIEDIE73P8(# Z 2 B DB2 Connect N< 29 ~=IE,SII9C DB2 Connect xP,SDNN&CLr4(#~=IE,SD 4(M9C=(k#f,S`,#bb6E;*&CLr(} DB2 Connect xP,S, ^k|DVP&CLrDNNzk4I9C~=IE,S# T=IE,STC'ZhY1G+X(D=(k~=IE,S`,#mb,Z4Pg ,SDYw1,T=IE,SJmz|DZ(j6#|DT=IE,SDZ(j6; F*P;C'#zITP;DZ(j6T0ZP;=x(Z(j6Gqh*\kb) Jb<(e*Jm4(IE,SDIE73D;?V# C'P;ITTx5MZtIC'.d2m,SD*z,XpGTZ;h*\kDC '{HgK,r*ZbVivB,}]b~qw;O$Z(j6#+G,Z9CK& \1,XkG#O(zD&CLr;JmZ;Pi$MO$Z(j6DivBP;A CZ(j6#qr,+TzD53lI2+)4# 19C CLI r JDBC (|( XA (“D,S)(} DB2 Connect xP,S1,IT 4(T=IE,ST0P;C'#4(T=IE,S“P;C'h*hCX(D,S tT#bb6E+^DVP&CLrT9CT=IE,S# }KUEa0Dnp,zIT9Ck#f,S`,D==49CIE,S(^[G~ =D9GT=D)#+G,1z9CjT=IE,Ss,Xk7#T=XO*C, S,49C,SQ&ZO*4,1`gK#qr,C,S9CDJ4I\^(ME# TZ~=IE,Sr;fZbvJb# “: 1. X*Bn:;a)\k4P;C'+F}}]b~qwDO$#&CLr;\Jm P;A;P\kDZ(j6,}GC&CLrQ-i$“O$KCZ(j6#q r,P;C'+lI2+)4# 2. T=IE,S;&9C CLIENT O$#K-r;JCZ~=IE,S# 3. 9CT=IE,SD&CLr&Z\\k#$“vIZ(K19CD2+zwOK P#K-r;JCZ~=IE,S# (} CLI 4(MU9IE,S g{z,SD}]b~qwdC*JmIE,S,zIZ(} CLI xP,S14(T= IE,S# K}LY(z;P9C XA Bq\mw#g{z}Z9C XA Bq\mw,;h7# +CBq\mwdC*1|wC xa_open 1,+ TCTX dC5hC* TRUE#g{x PKbyDhC,G4ITI*T=IE,SDNN,S<+I*T=IE,S#* i$3v,SGT=IE,S,kND=h 3# v z,SD}]bXk'VIE73# v Xk+IE73(e*O*zDM'zIE# v zXk*@ZIE73P8(D53Z(j6#IE,SD53Z(j6GZ4( ,S1r~qwa)Dw*C'{DZ(j6#*9zD,S;X(IE73E N,53Z(j6XkGZCIE73P8(DZ(j6#kzD2+T\m1a )P'D53Z(j6MCj6D\k# 30 DB2 Connect C'8O b)8>E“PD>}9C C oT“Y( conn G;v8rP'+4,SD,Sdz D8k#Y(d? RC D}]`M* SQLRETURN# 1. }KhC#f,S&hCD,StTb,9(}wC SQLSetConnectAttr /}+,S tT SQL_ATTR_USE_TRUSTED_CONTEXT hC* SQL_TRUE# rc = SQLSetConnectAttr( conn, SQL_ATTR_USE_TRUSTED_CONTEXT, SQL_TRUE, SQL_IS_INTEGER ); 2. 9C#f,S=(,S=}]b,}g:(}wC SQLConnect /},S#9C5 3Z(j6w*C'{,Cj6D\kw*\k#kqXlimsM/f,XpG mm5 PP>DG)# m 5. 8>4(IE,S'\Dms SQLCODE SQLSTATE ,e SQL20360W 01679 ;\(“IE,S#(“K#f,S# g{;Pmsr/f,G4,SQ(“R*T=IE,S# 3. ( I ! ) I T ( } 9 C SQLGetConnectAttr / } l i , S t T SQL_ATTR_USE_TRUSTED_CONTEXT D54i$y(“D,SGqMGT=IE ,S#g{CtThC* SQL_TRUE,G4,S4*T=IE,S# 4. 1z9Cj,Ss,Xk!DXT=O*C,S,uAC,SQ&ZO*4,1` gK#g{;PT=O*T=IE,S,G4C,S9CD3)J4+;\ME# “: 1. T=IE,S;&9C CLIENT O$#K-r;JCZ~=IE,S# 2. 9CT=IE,SD&CLr&;Z\\k#$“vIZ(K19CD2+Fcz OKP#K-r;JCZ~=IE,S# (} CLI P;IE,SDC' I(}|nPgf(CLI)P;T=IE,SDC'#PXP;9CIE,SDC'D ,eDhv,kND`X4SPDwb# v Xk+,SI&4(*T=IE,S# v T=IE,S;\ZBqP# v Jm4(T=IE,SDIE73XkdC*JmP;Az*P;DZ(j6# b)8>E“PD>}9C C oT“Y( conn G;v8ry,SDT=IE,SD 8k#Y(d? rc D}]`M* SQLRETURN#Y(d? newuser G;v8rV{ .D8k,CV{.|,k*P;DC'DZ(j6#Y(d? passwd G;v8rV {.D8k,CV{.|,CZ(j6D\k# 1. wC SQLSetConnectAttr /}ThC SQL_ATTR_TRUSTED_CONTEXT_USERID t T#+dhC*k*P;DZ(j6# rc = SQLSetConnectAttr( conn, SQL_ATTR_TRUSTED_CONTEXT_USERID, newuser, SQL_NTS ); //lims k q X l i m s M / f , X p G m Z 32 3 D m 6 P P > D G ) # Z 2 B DB2 Connect N< 31 m 6. 8>ZP;C'1^(hCBZ(j6Dms SQLCODE ,e CLI0106E 4xP,S# CLI0197E ,S;GIE,S# CLI0124E a)D5PJb#kliC5Gq*Ur+$H# CLI0196E ,Sf0h9P;C'D$w%*#*kP;C',,S;(;\ZBqP# 2. (}GJmKIE,SDIEOBD*sza)+P;ADZ(j6D\k,qr C Y w G I ! D ) w C SQLSetConnectAttr / } 4 h C SQL_ATTR_TRUSTED_CONTEXT_PASSWORD tT#+dhC*BZ(j6D\ k# rc = SQLSetConnectAttr( conn, SQL_ATTR_TRUSTED_CONTEXT_PASSWORD, passwd, SQL_NTS ); //lims kqXlimsM/f,b)msM/fP>Zmm6 M m 7 P# m 7. 8>ZP;C'1^(hC\kDms SQLCODE ,e CLI0198E P4hCtT SQL_ATTR_TRUSTED_CONTEXT_USERID# 3. 4U#f,SD==Lx4P#g{z}Z9C XA Bq\mw,G4ZB;Nk s 1 “ T C ' P ; ; q r , + Z t / C J } ] b D B ; v / } w C ( g SQLExecDirect)0“TP;C'#ZNN;VivB,}KxP#fDmsM/ fli,9kqXlim 8 PPvDms#m 8 PDms8>C'P;'\# m 8. 8>P;C''\Dms SQLCODE ,e SQL1046N JmKIE,SDIE73;P;dC*Jm P;=zTzms -20361 D SQL0969N 3)}]b6p:;a)\k4P;C'+F}}]b~qwDO$#&CLr;\Jm P;A;P\kDZ(j6,}GC&CLrQ-i$“O$KCZ(j6#q r,P;C'+lI2+)4# 2. T SQL_ATTR_TRUSTED_CONTEXT_USERID tT8( NULL 5H,Z8(IE 7353Z(j6(4(T=IE,S19CDC'j6)# 32 DB2 Connect C'8O 3. 1zI&XhCKT=IE,SO SQL_ATTR_TRUSTED_CONTEXT_USERID , StTD5s,“4XBhCC,S#XBhCDa{g,9CC,SD-<,S tT4(;vB,S;y#49z+,StTD5hC*53Z(j6“NULL rt TD105,2axPXBhC# 4. g{hCK SQL_ATTR_TRUSTED_CONTEXT_PASSWORD tT,G4ZP;C' }LP+O$\k,49JmKIE,SDIE73;*sTCZ(j6DP;C 'xPO$`gK#b+zz;X*D*z#Kfr;JCZIE7353Z(j 6#g{ZP;IE7353Z(j61,;*sTCj6xPO$,G449a )K\k,2;axPO$# DB2 Connect O$“bBn w*k System z r IBM Power Systems }]b\m1OwD DB2 Connect \m1, I7(*ZN&TC'{M\kxPi$: v ZM'zP v Z System z r IBM Power Systems ~qwO v (}Z}=53(Kerberos)4xP%cG 8.2.2(`1Zf> 8.1 ^)| 9)*<,xXZO$-LZd ;YG;/DNk_,xGdI;vw/G+#ZxXD}]b?XMxg~qP#bb6EC';h*XBdkC'j6M\kMITG<6L DB2 ~qw#Kerberos O$a)D%cG<&\*s DB2 Connect M|}Z,SD} ]b~qw%53D Kerberos O$c;/I= Windows 2000 Active Directory zFP# &CLrDM'zM~qwKVpk Kerberos SSP(2+T'V)&L)M'zM~q w#ixP(E#“2+T'V)&LSZ”(SSPI)T Kerberos SSP Md{2+T- ia)_6SZ# dMhC *9C Kerberos O$4dC DB2,khC: v ZxgO2mD Active Directory PCZ DB2(w*~q)DZ(_T,T0 v Kerberos \?V“PD(KDC).dDENX5 Znr%D=8P,AY*dC;v KDC ENX5,4,XFM'z$w>D KDC k IBM Power Systems r System z .dDX5#OS/390® V2R10 r z/OS V1R2 ( }d RACF® h)a) Kerberos >%&m,|Jmwzd1 UNIX KDC# DB2 Connect M=#;ya) 3 chCPD7Iw&\#19C Kerberos 2+T1, |;aP#O$PDNNG+#`4,|v+M'zD2+TnF+]A DB2 IBM i f r DB2 z/OS f#DB2 Connect xX;XGM'zrwzD Kerberos rDI1# rBf]T qC Kerberos 'VD DB2 nM*s: IBM }]~qwM'z: f> 8 DB2 Connect: f> 8 DB2 z/OS f: f> 7 34 DB2 Connect C'8O XZ z/OS 2+TDa>Mwba)PX DB2 Connect ,SA DB2 z/OS f}]b~qwD2+TDa>M< I# )92+TVN 7#“DB2 z/OS f)92+T”VNhC* YES#KVNvVZ DB2 z/OS f DSNTIPR feP# )92+Tzk Z DB2 z/OS ff> 5.1 .0,a)KC'j6r\kD,SksI\aZ'\1x P SQL30082 -rk 0,+G;P8>“zKD)ms# DB2 z/OS ff> 5.1 }x;Vv?&\,|\;'V)92+Tzk#8()92+ T+a)=SoO,}g,}K-rkTb,9+a)(PASSWORD EXPIRED)HE“# *{CKv?&\,&C+CZ)92+TD DB2 z/OS f ZPARM 20N}D5hC * YES#9C DB2 z/OS f20fe DSN6SYSP 4hC EXTSEC=YES#9IT9C DDF fe 1(DSNTIPR)4TdxPhC#1!5G EXTSEC=NO#Z\k=Z1,9C DB2 Connect D Windows“Linux“UNIX M Web &CLr+SU= SQL30082 ms{“# Qi$ TCP/IP 2+T g{ka)T DB22+T!n AUTHENTICATION=CLIENT D'V,G4&9C DB2 z/OS f20fe DSNTIP4(DDF fe 2)4+ TCP/IP Q-i$D2+ThC* YES# @f ODBC M Java &CLr2+T $w> ODBC M Java &CLr9C/, SQL#bZ3)20ivBI\ USER USING NEW CONFIRM 9IT9C“DB2 dCzV”D“|D\k”T0r4|D\k# DB2 Connect 'VDO$`M KwbP> DB2 Connect 'VDO$M2+ThCDwViO# Z 2 B DB2 Connect N< 35 TCP/IP ,SDO$`M TCP/IP (E-i;'Vxg-icDO$!n#O$`M7(ZN&xPO $#DB2 Connect v'VKmPyT>DiO# O$hCZ DB2 Connect ~ qwD}]b?Zm 9 P#TBT?V=8XM'z,vZ DB2 Connect ~qwPi$C'{M\k# C'+Z“aD;CxPO$#C'j6G(}xg“MD,+;(}xg “M\k#v1yPM'z$w><_Pc;DIE2+Th)1E9CK 2+`M# v Z=8 2 P,vZ IBM sMz}]b~qwOi$C'{M\k#C'j 6M\k(}xgS6LM'z“MA DB2 Connect ~qwT0S DB2 Connect ~qw“MA IBM sMz}]b~qw# v =8 3 M=8 2 `,,+C'j6M\kGS\D# v Z=8 4 P,M'zS Kerberos KDC q! Kerberos >%#(} DB2 Con- nect +>%-b;/X+MA~qw“I~qw4xPi$# v =8 5 M=8 3 `,,;GTC'}]2xPKS\“R DATA_ENCRYPT ;'V IBM Power Systems }]b~qw# v =8 6 M=8 3 `,,+9CK_6S\j<(AES)S\c(# s(&CLrM5CLr(DB2 Connect) 9C6k= SQL *“D&CLrXkk|G+&mD}]bxPs(#Za)Kb) &\D=(O,IT9C|nPDMdCzV4xPs(# ?v&CLr&CT?v}]b4P;Ns(#Zs(}LP,*+*4PD?v SQL od>}Y(: v yPM'z<&Z,;~q6p#g{|G;&Z,;6p,G4I\h*S?v X(~q6pDM'z4xPs(# v ~qwkM'z&Z,;~q6p#g{|G;&Z,;6p,G42h*S~q wxPs(# }K DB2 Connect 5CLr.b,d{NN9C6k= SQL D&CLr9Xkk| Gk9CD?v}]bxPs(#14P4s(D&CLr1,(#<+zz SQL0805N ms{“#zI\k*h*s(DyP&CLr4(;v=SDs(PmD ~# TZ?v*s(AD IBM sMz}]b~qw,k4PBPYw: 1. 7#zT IBM sMz}]b~qw\m53_Pc;D(^: System z h*D(^G: v SYSADM r v SYSCTRL r v BINDADD M CREATE IN COLLECTION NULLID “:v1m~|P4fZ1,BINDADD M CREATE IN COLLECTION NULLID X(E\a)c;D(^#}g,z}ZWN4(m~|D1r# g{m~|Q-fZ“Rz}ZYNs(|G,G4jICNqyh*D (^!vZG-4PKnuDs(# A) g{nuGzT:4PKs(,xz}ZYN4Ps(,G4;*z_P OfyP>DNN(^,M+JmzjIs(# B) g{d{K4PKnuDs(,xz}Z4PZ~Ns(,G4z+Xk _P SYSADM r SYSCTRL (^E\jIs(#g{z;_P BINDADD Z 2 B DB2 Connect N< 37 M CREATE IN COLLECTION NULLID (^,G4+;JmzjIs(# g{z;P SYSADM r SYSCTRL X(,T;IT4(m~|#ZKi vB,z+h*Tkf;D?vVPm~|<_P BIND X(# VSE r VM h*D(^G DBA (^#g{kZs((bind)|nP9C GRANT !n (T\b*?v DB2 Connect m~|%@ZhCJ(),G4 NULLID C 'j6XkP(*d{C'ZhTBPmD(^: v system.syscatalog v system.syscolumns v system.sysindexes v system.systabauth v system.syskeycols v system.syssynonyms v system.syskeys v system.syscolauth v system.sysuserauth Z VSE r VM 53O,zIT“v: grant select on table to nullid with grant option IBM Power Systems T NULLID /OD *CHANGE (^r|_(^# 2. “v`FZBPD|n: db2 connect to DBALIAS user USERID using PASSWORD db2 bind path@ddcsmvs.lst blocking all sqlerror continue messages ddcsmvs.msg grant public db2 connect reset dP DBALIAS“USERID M PASSWORD &CZ IBM sMz}]b~qw, ddcsmvs.lst G z/OS Ds(PmD~,x path m>Cs(PmD~D;C# }g,drive:\sqllib\bnd\ &CZyP Windows Yw53,INSTHOME/sqllib/ bnd/ &CZyP Linux M UNIX Yw53,dP drive m>20 DB2 Connect D _-}/w,INSTHOME m> DB2 Connect 5}Dw?<# IT9C bind |nD grant !n4T PUBLIC r8(DC'{rij6Zh EXECUTE X(#g{;9C bind |nD grant !n,G4Xkpv4P GRANT EXECUTE (RUN)# *Kbs(D~Dm~|{F,dkBP|n: ddcspkgn @bindfile.lst }g: ddcspkgn @ddcsmvs.lst I\zzBPdv: s(D~ m~|{F ------------------------------ ------------------------------ f:\sqllib\bnd\db2ajgrt.bnd SQLAB6D3 38 DB2 Connect C'8O *7( DB2 Connect Db)5,4P ddcspkgn 5CLr,}g: ddcspkgn @ddcsmvs.lst mb,K5CLrIC47(%vs(D~Dm~|{F,}g: ddcspkgn bindfile.bnd “: a. h*9Cs(!n sqlerror continue;;x,19C DB2 $_r|nP&m w(CLP)4s(&CLr1+T/*z8(K!n#8(KK!n,+Qs( ms*;*/f,rK,s(;v|,msDD~1T;IT4(m~|#, y,bJmT`v~qw9C;vs(D~,49X(D~qw5VI\+m ;v5VD SQL o(j>*^'#rK,TNNX(D IBM sMz}]b~ qws(NNPmD~ ddcsxxx.lst <&zI;)/f# b. g{z}Z(} DB2 Connect ,SA DB2}]b,G49Cs(Pm db2ubind.lst “R;8( sqlerror continue(|vZ,SA IBM sMz}] b~qw1EP')#mb,*,SA DB2}]b,(iz9C DB2(x;G DB2 Connect)a)D DB2M'z# 3. 9C`FDod4s(?v&CLrr&CLrPm# 4. g{z_P DB2 0“PfD6LM'z,G4I\h*+b)M'zOD5CLr k DB2 Connect xPs(# `>c|B `>c|B(2F*V<=$w%* (DUOW) M=WNd5)G;V&\,|9&C Lr\;|B`v6L}]b~qwPD}]“#$}]Dj{T#}g,f0+J pS;vJ'*F=d{}]b~qwPDm;vJ'DxP;W# ZbyD;WP,5V;vJ'ODhnYwD|B;aC=d5,}G9d5K& mm;J'D{nyXhD|B,b;cG\X*D#`>c|B“bBnJCZ1 m>b)J'D}]I=v;,D}]b~qw\m1Div# DB2 z7*`>c|Ba)+f'V#K'VICZ9C#f SQL *“D&CLrT 09CBq&m`Sw(TP `Sw)5V X/Open XA SZf6D&CLr#K` TP `Swz7D>}|( IBM TxSeries CICS“IBM Message and Queuing 5P“IBM Component Broker 5P“IBM San Francisco Project 0 Microsoft Transaction Server(MTS)“BEA Tuxedo Md{z7#20*swP;,,b!vZG9C>z SQL `>c|B,9G9C TP `Sw`>c|B# >z SQL M TP `Sw`>c|BLrk*Dv}]bCZf sD SQL od#g{;PNN TP `Swf_ DB2 |+-wBq(gS TP `Sw SU xa_open wCT(“}]b,SD DB2 y8>D),G4+9C DB2 m~4- wCBq# 19C TP `Sw`>c|B1,&CLrXk(}9C TP `SwD API 4ksd 5rXv,}g CICS SYNCPOINT M MTS SetAbort()#19C>z SQL `>c|B1, Xk9C}#D SQL COMMIT M ROLLBACK# Z 2 B DB2 Connect N< 39 TP `Sw`>c|BIT-wCJ DB2 MG DB2 J4\mw(}g Oracle“Informix r SQLServer)DBq#>z SQL `>c|BvJCZ DB2 ~qw# *9`>c|BBqpwC,NkV<=BqD?v}]b 8 r|_f> v DB2 z/OS ff> 7 r|_f> v DB2 IBM i f ;vV<=BqIT|B\'VD}]b~qwDNbiO#}g,&CLrIZ% vBqP,1|B Windows OD DB2 }]b“DB2 z/OS f}]bM DB2 i f}] bPDtIm# 9CXFPDtC`>c|B IT9CXFPD4a)`>c|B# *tC`>c|B: 1. t/XFPD# 2. %w [+] ET9*wNS<# 3. 9CsjR|4!q#{dCD5}# ;v/vK%r*# 4. !q`>c|B *> dCK%n# “`>c|Br<”0Zr*# 5. !q9CZBf|{D TP `Sw“8(Bq&mw(TP)`Sw# KVN+T> QtCD TP `SwD1!5#g{;k*9C TP `Sw,G4!q;9C TP `Sw# %wB;=# 6. g{}Z9C TP `Sw,G48(,=c\mwhC#g{;P9C TP `Sw, G48(Bq\mw}]b# 7. %wjI# 9CXFPDbT`>c|B IT9CXFPDbT`>c|BhC# *bT`>c|B: 1. CsjR|!q5}“S/vK%P!q`>c|B *> bTK%!n# “bT` >c|B”0Zr*# 2. ZICDPmrP,SICD}]bP!qzk*bTD}]b#IT9CPdD =r4%(> M >>)Z!qDPmrPFxMFv!q#9IT(}Z!qDPm rP1S`-!qDC'j6M\k4|D|G# 3. 1zjI!q1,%w7(# “`>c|BbTa{”0Zr*# 4. “`>c|BbTa{”0ZT>y!qD}]bD)|BbTI&,D)'\#C 0Z+T>'\D}]bD SQL zkMms{“#%wXUTXUC0Z# 5. %wXUTXU“bT`>c|B”0Z# 40 DB2 Connect C'8O `>c|BM,=c\mw IBM sMz}]b~qw*s DB2 Connect Nk Linux, Windows“UNIX M Web & CLr“vDV<=Bq#mb,f0 IBM sMz}]b~qwDm``>c|B= 8<*sdC“,=c\mw”(SPM)i~#4( DB2 5}1,9C1!hCT/d C DB2 SPM# Gqh* SPM,b!vZ-iD!q(TCP/IP)T0 TP `SwD9C#Bma)K h*9C SPM D=8D\a#Cm9T>,S Intel® r UNIX zwT IBM sMz xPNNCJ1,Gqh* DB2 Connect#TZ`>c|B,g{}Z9C TP `S w,G4 DB2 Connect D SPM i~GXhD# m 10. h* SPM – TCP/IP D`>c|B=8 Gq9CBq&mw `Sw? Gqh*,=c\m w? XhDz7(!q; n) \'VD IBM sMz }]b GG DB2 Connect ~qw z7 &C DB2 Connect m I$D DB2 s5~ qwf DB2 z/OS f V7 DB2 z/OS f V8 r |_f> qq DB2 Connect vKf DB2 Connect ~qw z7 &C DB2 Connect m I$D DB2 s5~ qwf DB2 z/OS f V7 DB2 z/OS f V8 r |_f> “:;vV<=BqIT|B\'VD}]b~qwDNbiO#}g,&CLrI Z%vBqP,1|B Windows OD DB2 }]b“DB2 z/OS f}]bM DB2 IBM i f}]bPDtIm# 9C{O XA DBq\mwdC DB2 Connect >wbhv9C IBM Power Systems M System z }]b~qw1h*Z TP `Sw P4PDdC=h# zXk_PIYwD TP `Sw,Q20 DB2 Connect,“dCMbTKk IBM sM z}]b~qwD,S# *Z TP `Sw+ DB2 Connect dC*9C IBM Power Systems M System z }] b~qw,k4PBP=h: 1. dC TP `SwTc|ICJ“DB2 XA *X”#“DB2 XA *X”* TP `Swa) K DB2 Connect D XA API DX7#?v TP `Sw4PKYwD==<;,# 2. C DB2 D XA_OPEN V{.4dC TP `Sw#?v TP `Sw4PKYwD= =<;,#PXgNdC DB2 D XA OPEN V{.T) TP `Sw9CDE“, ND TP `SwDD5# Z 2 B DB2 Connect N< 41 3. g{h*,^D“DB2 Connect ,=c\mw”(SPM)1!dCN}#IBM wzM System i(f> 5 “Pf 3 M|gDf>)}]b~qwP4'V XA SZ#Sys- tem i f> 5 “Pf 4 0TsDf>_Pj+ XA 'V# SPM G DB2 Connect Di~,|+ XA =WNd5-i3dA IBM sMz}] b~qw9CD=WNd5-i#Z1!ivB,DB2 5}_P SPM dCN}D $(e5#nX*DN}G}]b\mwdCN} SPM_NAME#|1!* TCP/IP wz{D0_vV{Dde# 4. Z DB2 Linux f“UNIX fM Windows fO,+ DB2COMM “amd?hC * TCPIP,+ SVCENAME }]b\mwdCN}hC*9C TCP/IP KZEr~ q{F# DB2 Connect TI“nOBqD'V DB2 Connect PTI“nOBqD'VJCZTBC':{G5VCJ DB2 IBM i f V5R4 r|_f>T0 DB2 z/OS ff> 7 r|_f>D XA V<=&CLr#K' VJm,;+VBqD;,V'2m DB2 z/OS fODx(Ud# TI“nODBqD'VJCZ NET M COM+ &CLr# K&\u!0Z,ZC0ZP,V<=BqD;vV'v=I,;+VBqZm;v V'}pDx(,1r@x# 9C DB2 Connect 4F/}] g{z}Z4SD73P$w,ZC73P,h*Zwz}]b53k$w>.dF /}],G4IT9C DB2 Connect,bGwzk}]b.dD}]+dxX(kND Z 43 3D< 8)# 42 DB2 Connect C'8O DB2 D export M import 5CLrJmZ IBM sMz~qw}]bk DB2 Connect $w>ODD~.dF/}]#;s,ITZNNd{'VbV4PFAwz~qw *+}]FAwzr System i ~qw}]b: 1. + DB2 mPD}]: 1. +wz~qw}]bmPD}]} TB>}5wgN+}]S$w>FAwzr_ System i ~qw}]b# (}“vTB|n,+}]: v dcs1dsn.map 3d DB2 z/OS f SQLCODE# v dcs1ari.map 3d DB2 ~qw VM M VSE f SQLCODE# v dcs1qsq.map 3d DB2 IBM i f SQLCODE# TZ Linux r UNIX Yw53OD DB2,;h*xP3d# 1. g{k*2G1! SQLCODE 3d,r_z}Z9C;P SQLCODE 3dD IBM sMz}]b~qw(G IBM }]b~qw),G4IT4FdP;vD~“+d CwB SQLCODE 3dD~Dy!#nC(}4Fx;*1S`-KD~,IT7 #zZh*1\;1}C-CPG“M# W w*;PPD(;V{,m>/fj>&CXBxP3d#1!ivB, +M-#W Xks4# && .sDd{yPPXk*UWrICBPq=D3dod: input_code [, output_code [, token_list]] input_code m>BPdP;n: sqlcode 4T IBM sMz}]b~qwD SQLCODE# Z 2 B DB2 Connect N< 45 U yP4(eD:D SQLCODE(ZKD~P4P>DG)5);3d*8( D output_code#g{ZKPP;P8( output_code,G49C-DG)5);3d*8( D output_code#g{ZKPP;P8( output_code,G49C-m“R;4FjG# V{ cc Xk!4# g{Z3dD~P`NvV,; input_code,G49CZ;vvVDzk# output_code m>dv SQLCODE#g{;P8(NN5,G49C-GdkjG;g{|Z n sf,G4m>Gdvj G#V{ c Xk!4# i K;CPjGD}]`M* INTEGER#g{ i Z n sf,G4m >GdvjG#i ;\Z n .0vV,-rG IBM sMz}]b ~qwz7v'V CHAR jG#V{ i Xk!4# n CZ8>y9CD IBM sMz}]b~qwjGD}V#|GG4 Udv SQLCA PZ{ECD3r4EPD#C}V8> IBM s Mz}]b~qwjG;EP==8>Z SQLCA PECjG1+ ICD3r# }g,IBM sMz}]b~qwI\5X=vjG,4 1 M 2#g {Zdv SQLCA Pk*jG 2 vVZjG 1 .0,G48( (2,1)# Cdc+`vjGE,Sp4,IT+`vjGEiOI;v CHAR dvjG# C:E4+dvjGt*#g{Z:E0f;P8(NNjG,G 4Z SQLCA PC;C;|(dvjG#Zdv SQLCA P,Z8 (Dns;vjGsfvVDNNjG<+;3d*UjG# < 9 T>;vy> SQLCODE 3dD~# TBhvkO;}VPD%dPET&: 1. SQLCODE GS -007 3dA -007#S IBM sMz}]b~qwSU=DZ;v dkjG;CwZ;vdvjG“R|1!* CHAR#;+Md{jG# 2. SQLCODE GS -010 3dA -010(48(dv SQLCODE)#;P+NNjGE kdv SQLCA P# && -007 , -007 , (1) -010 -060 , -171 , (2) ... -204 , -204 , (c1.2c) ... -633 , -206 , (,c1i) -30021 , -30021 , (c1c,c2c) cc00 , +000 ... U , -969 , (s) P , +965 , (s) < 9. SQLCODE 3dD~ Z 2 B DB2 Connect N< 47 3. SQLCODE GS -060 3dA -171#OzS IBM sMz}]b~qwSU=DZ ;vdkjG#Zdv SQLCA P,Z~vjG;CwZ;vjGR|G CHAR# Zdv SQLCA P;PZ~vjG# 4. SQLCODE GS -204 3dA -204#S IBM sMz}]b~qwSU=DZ;v MZ~vjGD# 6. SQLCODE GS -30021 3dA -30021#S IBM sMz}]b~qwSU=DZ ;vMZ~vdkjGKyPI3dDzk(|(G )j+`,x;h*3dDyPzk),E&C9CK!n#(s) !n8>:Z SQLCA D SQLERRMC VNP*5XDjGPm|(-< SQLCODE,sS“z KmsDz7,YsS-D zk1,+;xPNN3d# 9. yP4(eD} SQLCODE <;3d* +965#v1P>KyPI3dDzk(| (G)j+`,x;h*3dDyPzk),E&C9CK!n#(s) !n8>:Z SQLCA D SQLERRMC VNP*5XDjGPm|(-< SQLCODE,sS“z K/fDz7,YsS-D }zk1,+;xPNN3d# }]b53`SM DB2 Connect +V[8vZ73P9C DB2 Connect 4`S,SMT\D=(#*9CD`S`M IYw538(# `S6LM'zD,S zIT+}]b53`Swk DB2 Connect ~qwz7(g DB2 Connect s5f)d O9CT`S6LM'z,S#*`S DB2 Connect ~qwD>XM'z(4b)M 'zZC~qwOKP),h*hCTBd?: db2set DB2CONNECT_IN_APP_PROCESS=NO }g,1 IBM sMz53O“zms1,53\m1I7(CJbGqZ DB2 Con- nect $w>O#}]b53`Sw`XBn: v DRDA X*jG(CRRTKN),CZ;\#$DT0# v $w%*j6(UOWID),CZ\“DRDA-3 ,=c\mw”(Z TCP/IP ,SO9C 1)#$D=WN,S# v DB2 Connect ,Sj6(&CLrj6)# KE“T>Dv DB2 Connect ,S`S*XD4, *P>`S*XD4,,9C db2 get monitor switches |n# 9C Windows T\`Sw`ST\ Windows Yw53*`S DB2 &CLrDT\a)PCD`S$_#“T\`Sw ”(Performance Monitor)G Windows D\m$_.;,|C53T\#I T!q`SwV53“}]bMk(EPXDn“Z(P,13d|G# }g,(}9C`Sw,MITC51(} GET SNAPSHOT FOR ALL DCS DATABASES r GET SNAPSHOT FOR ALL DCS APPLICATIONS |n C=D(f,“+|G1Skng“CPU 9CJ”D5xPHO#IT1SHO}]bO D;,hCD'{r(ET\#IT+hCDX(dC#fZ PMC D~P,TszI TTdxPlw# }g,ZBv 4#TD5D/O;#fZD~ db2chart.pmc P#zIT#fNb`v PMC D~,?vD~43;,D53T\Xf# *tC>X&CLrD`S,+h*XU DB2CONNECT_IN_APP_PROCESS 73d?# 9C GET SNAPSHOT |n DB2 `Sw,$X*D53E“DKPjG#ZNN1rVZ} = 140 QSUDv>VZ} = 103 K(fa)KPX}]b,S“T\“msM SQL i/DLB?DE“#5JO, “DB2 `Sw”lUIT|j8#}g,g{z“v GET SNAPSHOT FOR ALL DCS APPLICATIONS |n,G4+SU=kBPZ]`FD(f: DCS &CLrlU M'z&CLrj6 = 09150F74.B6A4.991215152824 rE = 0001 Z(j6 = SMITH &CLr{ = db2bp &CLrdz =1 &CLr4, = H}ks 4,|D1d = 12-15-2001 10:29:06.707086 M'zZc = sys143 M'z“Pf6p = SQL06010 M'z=( = AIX M'z-i = TCP/IP M'zzk3 = 850 M'z&CLrDxLj6 = 49074 M'zG(EX7 = 9.21.21.92 5021 v>(E-i = TCP/IP k>(EX7 = 9.21.15.116 46756 Wv}]b,SD1dAG = 12-15-2001 10:28:24.596495 wzl&1d(sec.ms) = 0.000000 xX&myCD1d = 0.000000 ON4;1dAG = !qDP} =0 “TD SQL od} =2 '\DodYw} =0 d5od} =1 Xvod} =0 QSUDk>VZ} = 404 Q“MDv>VZ} = 140 QSUDv>VZ} = 103 Q“MDk>VZ} = 287 r*DNj} =0 &CLrUP1d =1VS 32 k UOW jI4, = O;v UOW jI1dAG = 12-15-2001 10:28:25.592631 UOW *<1dAG = 12-15-2001 10:29:06.142790 UOW #91dAG = ONjID UOW DDC1d (sec.ms) = 0.034396 n|DYw = “44P n|YwD*<1dAG = 12-15-2001 10:29:06.142790 n|YwD#91dAG = 12-15-2001 10:29:06.707053 od = “44P ZE = 203 &CLr4(_ = NULLID m~|{F = SQLC2C07 T timeron *%;4FcD SQL `kwI>@F =0 SQL `kwy}@F =0 od*<1dAG = 12-15-2001 10:29:06.142790 od#91dAG = 12-15-2001 10:29:06.707053 wzl&1d(sec.ms) = 1.101612 ONjID stmt DDC1d(sec.ms) = 0.564263 QCfDP} =0 xX&myCD1d = 0.013367 *odSUDk>VZ} = 220 *od“MDv>VZ} = 130 *odSUDv>VZ} =49 *od“MDk>VZ} =27 SQL odD>: create table t12 (col1 int, col2 char) DCS &CLr4, 53`Swa) LIST DCS APPLICATIONS |nD}Vq=,gBy>: v LIST DCS APPLICATIONS v LIST DCS APPLICATIONS SHOW DETAIL v LIST DCS APPLICATIONS EXTENDED ZSB4DdvP,y] IBM sMz}]bf>M TCP/IP 'V6pD;,,wz& CLrj6MM'z&CLrj6Dq=IT;,# Z 2 B DB2 Connect N< 51 m 11. yZwzf>M TCP/IP 'V6pD&CLrj6q= =8 &CLrj6q= M'z9CMZf> 7 D RDB \mw6p' VCJ}]~qw G91A0D3A.P8BC.060306212019 M'z(} TCP/IP V4 9C RDB \mw6p 'V 8 r|_6pC J}]~qw 9.26.13.61.65289.060306213816 M'z(} TCP/IP V6 9C RDB \mw6p 'V 8 r|_6pC J}]~qw 2002:91a:519:13:209:6bff:fe14:4fbb.7684.060306213741 LIST DCS APPLICATIONS *i4`Swa)D&CLr6pDE“,“v DB2 LIST DCS APPLICATIONS |n# |+T TCP/IP ,S(DB2 Connect k DB2 z/OS fD,S)5XTBE“: O$j6 &CLr{ &CLr wz&CLrj6 dz ------- ---------------- ------ ---------------------------------------------------- NEWTON db2cli.exe 7 G91A0D3A.P8BC.060306212019 NEWTON db2cli.exe 25 9.26.13.61.65289.060306213816 NEWTON db2cli.exe 20 2002:91a:519:13:209:6bff:fe14:4fbb.7684.060306213741 Z(j6 CZG< IBM sMz}]b~qwDZ(j6#|j6}ZKP&CLrDC '# &CLr{F }ZM'zOKPD“DB2 Connect y*@D&CLr{#;Pns;v76 Vt{sfD0 20 vVZIC# &CLr dz }Z DB2 Connect $w>O4PDzmxL#IT9CK*X4+}]b53 `SwE“4SAd{oOE“#19C FORCE USERS |nr API 1,9 h*zmxLj6# wz&CLrj6 *BPdP;n: v DRDA X*jG(CRRTKN),CZ;\#$DT0# v $w%*j6(UOWID),CZ\“DRDA-3 ,=c\mw”(Z TCP/IP , SO9C1)#$D=WN,S# K(;j6GZ&CLr,SA IBM sMz}]b~qw1zID#IT+K *Xk“&CLrj6”;p9C,T9&CLrE“DM'zk~qw?V` X*# LIST DCS APPLICATIONS SHOW DETAIL g{8(K DB2 LIST DCS APPLICATIONS SHOW DETAIL |nq=,G49aT>d{ E“,|(: 52 DB2 Connect C'8O O$j6 &CLr{ &CLr M'z&CLrj6 dz ------------------------------ -------------------- ---------- ---------------------------------------------------- NEWTON db2cli.exe 37 2002:91a:519:13:209:6bff:fe14:4fbb.8196.060306214224 rE M'z M'z M'z M'z wz&CLrj6 DB p{Zc “Pf zk3 ----- -------- -------- -------- ---------- -------------------------- 00001 MDB SAYYID SQL09000 1252 G91A0D3A.P982.060306214231 rE wz DB {F wz f> ----- -------------------- -------- 00001 MEXICO DSN08015 M'z&CLrj6 (;Xj6k DB2 Connect $w>`,SD&CLr#&CLrj6P;,D q=,b!vZM'zk DB2 Connect $w>.dD(E-i# K5Jmz+M'zk DB2 Connect $w>.dD,S“T0 DB2 Connect $ w>k IBM sMz}]b~qw.dD,SX*p4# M'zrE(Seq#) M'zrEMGBqrE#IC|4+V#M'zz7j6+*: v SQL07010,m>f> 7.1 D DB2 Universal Database™ M DB2 Connect z 70dM'z# v SQL08010,m>f> 8.1 D DB2 (C}]b M DB2 Connect z70d M'z# v SQL08020,m>f> 8.2 D DB2 (C}]b M DB2 Connect z70d M'z# v SQL09120,m>f> 9.1 D DB2 z7f> 9.1“DB2 Connect z70dM 'z# zk3j6 t/\`SD&CLrDZcODzk3j6# IT9CKE“47#&CLrzk3k}]bzk3(rTZ IBM sMz} ]b~qw}]b,r* IBM sMz}]b~qw CCSID).dD}]*; G\'VD# g{&CLrzk3kKP}]b53`SwyCDzk3;,,Kzk3* XITozzV/*;S&CLr+MD}]“(}}]b53`Sw4T >#}g,IT9C|4oz*;“&CLr{”# Z 2 B DB2 Connect N< 53 v>rE bm>v>rE#IC|49;,53ODBq`X# wz}]b{F &CLry,SAD}]bDf5{F#Z DCS ?#dq=* PPPVVRRM,dP: PPP j6 IBM sMz}]b~qwz7(}g,TZ DB2 z/OS f,* DSN;TZ DB2 ~qw VSE M VM f,* ARI;r_TZ DB2 IBM i f,* QSQ) VV m>=;f>E,}g,08# RR m>=;“PfE,}g,01# M m>%V{D^D6p(0-9 r A-Z)# LIST DCS APPLICATIONS EXTENDED IT9CxP!n EXTENDED D LIST DCS APPLICATIONS |n,TzI“)9( f”#“)9(f”P>K1Z|nO8(K SHOW DETAIL !n1P>DyPVN,T 0EvBVN: v DCS &CLr4, v 4,|D1d v M'z=( v M'z-i v wz`kV{/j6(CCSID) v M'zGVN,?v&CLrP>;P,B!n491=r4 P>VN,?PP>;vVN# TBG|nDBo(: LIST DCS APPLICATIONS [SHOW DETAIL | EXTENDED ] xTBG9CBD EXTENDED !n1,K|nyzIDy>dv: 54 DB2 Connect C'8O DCS &CLrDPm - )9(f M'z&CLrj6 = 2002:91a:519:13:209:6bff:fe14:4fbb.8196.060306214224 rE = 00001 Z(j6 = NEWTON IEZ(j6 = &CLr{F = db2cli.exe &CLrdz =37 &CLr4, = H}ks 4,|D1d = 4U/ M'zZc = SAYYID M'z“Pf6p = SQL09000 M'z=( =NT M'z-i = TCP/IP M'zzk3 = 1252 M'z&CLrDxLj6 = 1192 M'zG#bb6EQ-“vK,SA IBM sMz}]bDks,DB2 Connect }ZH}(“,S# 2. H}ks#bb6EQ-(“Kk IBM sMz}]bD,S,DB2 Connect }Z H}4TM'z&CLrD SQL od# 3. H}&p#bb6EQ-+ SQL od“MA IBM sMz}]b# mb,v1Z&mZdr*K“53`S UOW”1,(fPEaT>4,|D1d#q r,+T>“4U/”# KP4v`SwM/( DB2 z/OS fKP4v`Sw(1@@Ts,$_T#g{KP4v`Swv(h*T sD,$,G4a4(!5(/# T!5/(Dl&YwITw*KPM#fN=i4ra;# DB2 for z/OS KP4v`SwEv Z z/OS 53O,DB2 for z/OS KP4v`Sww**`SD?v DB2 S53DNq r}]2miD(CI1t/# DB2 for z/OS KP4v&mw4_TP(eD$(1dM1ddt%“TTs,$_T D@@#Ts,$_TG9C DB2 XFPDD“4(Ts,$_T”r<4(D#?N @@_TZd,`?D}L(DSNHMONP)My>`?D}L (DSNHMONA)ECZ}LbP,dP DSNHMONP CZt/;v DB2 KP4v` Sw,x DSNHMONA CZZ MVS 53r Parallel Sysplex® Zt/`v DB2 KP 4v`Sw# 20w5 DSNTIJCC M DSNTIJHM 4(“20 DB2 KP4v`SwrBfP>D` XNq9CDS<“m“}]/“Q`?D}L“f“}L“C'(eD/}Ma{ /m#DSNTIJCC M DSNTIJHM f FMID JDB771D M JDB881D a)# _T@@U> DB2 KP4v`Sw%“D_T@@Gu?#t 7 l,7 lsaSmP+d>}# I9C DSNTIJCC 20w5TKm4(D DB2 S< DSNACC.HM_ALERT_PO_EV 4 T>yPO;N@@|z4I&D_T# t/“#9M“B DB2 for z/OS KP4v`Sw Z z/OS 53O,DB2 for z/OS KP4v&mww**`SD?v DB2 S53DNq r}]2miD(CI1t/# v *t/ DB2 KP4v`Sw,k“vTB START MVS 53|n: S membername,DB2SSN=ssid,JOBNAME=HMONssid,TRACE=trace,REFRESH=nn TRACE M REFRESH N}GI!D# membername 8(*4PCZt/ DB2 KP4v`SwD}LbI1,4 DSNHMONP#KQ` ?D}LI DSNTIJHM 20w54(# ssid 8(*`SD DB2 S53D{Frj6# trace 8(zYj>#I\D5|(: –ON- r*zY#+zYG<4k SYSOUT – OFF - ;r*zY 1!5G OFF# nn 8(KP4v`Sw“B@@1dmlU1D1dc(9C 24 !1F),KP4v `Sw9CC1dmlU%“_T@@#1!5G 22# 56 DB2 Connect C'8O v *t/`v DB2 KP4v`Sw,k“vTB START MVS 53|n: S membername membername 4PCZt/`v DB2 KP4v`SwD}LbI1,4 DSNHMONA# “:(}9C;v START |n“9C DSNHMONA t/`v DB2 KP4v`S w.0,Xk9C*`SDS53Pm4nd DSNHMONA }LP8(D HMONPARM }]/#Q`?D}LM}]/I DSNTIJHM 20w54(# v *“B DB2 KP4v`SwC47(%“_T@@D1dD_T@@1dmlU, k“vTB MODIFY MVS 53|n: F HMONssid,APPL=REFRESH ssid }Z“BD DB2 KP4v`Swy`SD DB2 S53D{Frj6# v *#9 DB2 KP4v`Sw,k“vTB STOP MVS 53|n: STOP HMONssid r P HMONssid ssid }Z#9D DB2 KP4v`Swy`SD DB2 S53D{Frj6# i4“a;M#f(iDYw *i4“a;M#fT_T@@Zdyj6/(TsD(iYw,IwC DSNTIJCC 2 0w54(D DB2 f“}L SYSPROC.DSNACCHR#DSNACCHR Gby;vf“} L:|7(T_T@@Zdyj6/(TsD(iYw,“zI4Pb)(iYwD JCL w5# TBo(KCZwC DSNACCHR D SQL CALL od#r* DSNACCHR D 4S<(G GENERAL WITH NULLS,yTg{Zwd?P+]N},G4h*f? vwd?|(;vU8>{#Z4P CALL od.0,Xku {# o( CALL DSNACCHR ( query-type, health-ind, policy-id, work-set, dataset-name, member-name, save-opt, trace-flag, NULL NULL NULL job-id, jobname, jcl-proc-time, trace-flag, last-statement, return-code, error-msg ) query-type 8(k*gN&mT_T@@Zdj6*/(4,TsD(iYw#I\D5|(: v 0 - w* JCL w5i4T/(Ts(iDYw v 1 - a;CZ4PT/(Ts(iDYwD JCL w5 Z 2 B DB2 Connect N< 57 v 2 - a;CZ4PT/(Ts(iDYwD JCL w5,“+Cw5ECZRpSP P v 3 - +T/(Ts(iDYw#f*bI1PD JCL w5 query-type G`M* INTEGER DdkN}# health-ind 8( DSNACCHR |(Z JCL w5PD/(`M#I\D5|(: v RS - \^4, v EX - Q,v)9}]i} v RR - h*D REORG v CR - h*D COPY v RT - h*D RUNSTATS v SS - h*D STOSPACE health-ind G`M* VARCHAR(4) DdkN}# policy-id 8(Ts,$_T#policy-id G`M* VARCHAR(7) DdkN}# work-set 8(Ts,$_TD$w/,C_Tj6 DSNACCHR |(Z JCL w5PD/(Ts# Xk9CZN} policy-id M health-ind P8(D_TM/(`M4j6K$w/#work- set G`M* INTEGER DdkN}# dataset-name 8(Vx}]/(PDS)rVx}]/)9(PDSE)Dj<{F#g{ query-type G 3,G4Xk8(K5#dataset-name G`M* VARCHAR(44) DdkN}# member-name 8(Z dataset-name N}P8(DVx}]/(PDS)rVx}]/)9(PDSE)DI 1,Ts,$ JCL w5+#fZC PDS r PDSE P#g{ query-type G 3,G4X k8(K5#member-name G`M* VARCHAR(8) DdkN}# save-opt 8(gN#fTs,$ JCL w5#g{ query-type G 3,G4Xk8(K5#I\D 5|(: v R - f; v A - 7S v NM - B(I1 save-opt G`M* VARCHAR(2) DdkN}# trace-flag 58 DB2 Connect C'8O 8(Gr*9GXUzY#I\D5|(: v Y - r*zY v N - XUzY trace-flag G`M* CHAR(1) DdkN}# job-ID 1 query-type G 1 r 2 1,8(Qa;Dw5Dj6#job-id G`M* VARCHAR(8) DdvN}# jobname 1 query-type G 1 r 2 1,8(Qa;Dw5D{F#jobname G`M* VARCHAR(8) DdvN}# jcl-proc-time 8(Q&m1dks#jcl-proc-time G`M* TIMESTAMP DdvN}# last-statement 1 DSNACCHR 5XOXms(5Xk 12)1,KVN|,“zCms14PD SQL od#last-statement G`M* VARCHAR(2500) DdvN}# return-code 4P DSNACCHR zzD5Xk#I\D5|(: v 0 - I&4PK DSNACCHR v 12 - DSNACCHR rOXmsxU9#error-msg N}|,CZhvmsD{“#last- statement N}|,“zms14PD SQL od# return-code G`M* INTEGER DdvN}# error-msg 1 DSNACCHR 5XOXms(5Xk 12)1,KVN|,ms{“(|(Qq=/ D SQLCA)#error-msg G`M* VARCHAR(1331) DdvN}# 1 query-type N}G 0 1,DSNACCHR 5X;va{/#Ca{/|, DSNACCHR zID JCL w5#DSNACCHR a{/mI DSNTIJCC 20w54(#m 12 T>K a{/Dq=# m 12. DSNACCHR a{/q= P{ }]`M hv JCLSEQNO INTEGER mPDrE(1,...,n) JCLSTMT VARCHAR(80) 8( JCL od i4KP4v/(** HEALTH_OVERVIEW /}T DB2 mDN=5XKP4v/(\a VSAM KSDS } ]/PDE“#K}]/I DSNTIJHM 20w54(# Z 2 B DB2 Connect N< 59 “KP4v/(\a”}]/|,PX DB2 S53D DB2 KP4v`SwM/(3F E“DE“,b)S53H0r10IC MVS 53r“P534CODKP4v`S w`S#b)E“+5X=M'z,dPP;P|,?v DB2 S53M/((i# C/}Da{G_PTBPD DB2 m: ip-addr DB2 ~qwD IP X7#bG`M* VARCHAR(40) DP# db2-ssid DB2 S53DS53j6#bG`M* VARCHAR(4) DP# health-ind /(`M#I\D5|(: v RS - \^4, v EX - Q,v)9}]i} v RR - h*D REORG v CR - h*D COPY v RT - h*D RUNSTATS v SS - h*D STOSPACE v PO - _T@@'\ v HM - KP4v`Sw4, health-ind G`M* VARCHAR(4) DP# host-name DB2 ~qwDj DB2 KP4v`SwD4,#I\D5|(: v 0 m>4t/KP4v`Sw v 1 m>Qt/KP4v`Sw v -1 m>KP4v`Sw4,4* qr,m>_P health-ind P8(D/(`MD/(Ts\}#bG`M* INTEGER DP# alert-state health-ind P8(D/(D4,#I\D5|(: v 5 - /( v 4 - “b v 3 - /f v 0 - }# 60 DB2 Connect C'8O 1 health-ind *“HM”1,alert-state }:iR DB2 S53“ABCD”Ph* COPY D/(Ts\}: SELECT SUMMARYSTATS FROM TABLE (DSNACC.HEALTH_OVERVIEW()) AS T WHERE DB2SSID = ’ABCD’ AND HEALTHIND = ’CR’; i4KP4v/(Ts y]/(TsD`M,+ONI&|z_T@@Zdj6D/(Ts#fZBP/( Tsf“bmP# /(Ts|(: v CZf“mUdD DSNACC.HM_MAINT_TS v CZf“w}D DSNACC.HM_MAINT_IX v CZf“f“wiD DSNACC.HM_MAINT_SG DB2 Tb)/(Tsf“bm4(Km`S<#SK(e?vS&Z\^4,DyPmUd HM_ALERT_TS_EX HM_MAINT_TS T>d)9}]i,vKC'8(^FDyP mUd HM_ALERT_TS_RR HM_MAINT_TS T>h* REORG DyPmUd HM_ALERT_TS_CR HM_MAINT_TS T>h* COPY DyPmUd HM_ALERT_TS_RT HM_MAINT_TS T>h* RUNSTATS DyPmUd HM_ALERT_IX_RS HM_MAINT_IX T>&Z\^4,DyPw} HM_ALERT_IX_EX HM_MAINT_IX T>d)9}]i,vKC'8(^FDyP w} HM_ALERT_IX_RR HM_MAINT_IX T>h* REORG DyPw} HM_ALERT_IX_CR HM_MAINT_IX T>h* COPY DyPw} HM_ALERT_IX_RT HM_MAINT_IX T>h* RUNSTATS DyPw} HM_ALERT_SG_SS HM_MAINT_SG T>h* STOSPACE DyPf“wi Z 2 B DB2 Connect N< 61 62 DB2 Connect C'8O Z 3 B _ICTM DB2 Connect TZ9C DB2 ConnectD73PD_ICT,P;)X(D“bBn#g{xgPD} ]b~qwIZ3v-rx;IC,G4X*DG+M'z$w>XB7I=xgP m;}]b~qwD\&# wz}]b,SD_ICTM:Xyb Z1qE“kdTV:y“#VVxDv$#1q\` Web“gSLqMgSmq&CLrh *Ts5}]xPCJ#rKXk(“k IBM sMz}]bDI?“lYM2+D, S#K,SXk?\ 7 l?l 24 !1aPZ Windows“Linux M UNIX OKPD8v$w>M&CLr~qw# b)zwh*T$tZtI IBM sMz}]bOD}]xPCJ#b)zwOKPD &CLr*sk}]bxPlYMI?D,S#(}9C TCP/IP DT+xxg,S{ v53# *9$w>M&CLr~qwCJ IBM sMz}]b,h*d1PiD,Si~#K i~Xka)k IBM sMz}]bD_IC“!3RlYD,S#|9XkGIlu DTJ&TsD,S]?v$# 9CKwbPD`X4Si4PX9C DB2 Connect MM'zT/XB7I&\Db v=8Dj8E“# < 11. y>xg=8 © Copyright IBM Corp. 1993, 2010 63 M'zT/XB7IDhvMhC(DB2 Connect) M'zT/XB7I&\Dw*?jG9 IBM }]~qwM'z&CLr\;V4( E,Tc&CLrITLx$w,“+POuAnM#K{X}]b,=,yT;h*7#- (E'\sQXB(“}]b, S#+5Xwz{r IP X7M~q{FrKZE#g{;\XB(“M'zk-<~ qwr8C~qw.dD(E,G4 IBM }]~qwM'zvr&CLr5X-<( EJODms# 9&C“bBPZ DB2 Connect ~qw73PxP8C~qw,Syf0D“bBn: v 9C DB2 Connect ~qwzm6LM'zM>XM'zCJ IBM sMz}]b1, 53}]b?,; IBM sMz}]b#* 6LM'z`?;vu?,*>XM'z`?m;vu?# v S?j DB2 z/OS f~qw5XDNN[O53E“v#fZ DB2 Connect ~qw D_Y:fP#;P;v8C~qw4kEL#fZ`v8C~qwrn/~qw 1,vZZfP,$E““Rb)E“ZxLU91+a*'# dCM'zT/XB7IT+dkM'z,SV“wmj6* DB2 M'zT/XB7I D8C~qw# ITZ`FBfD73P9CV“w V“w(DB2 Connect ~qw 1 r DB2 Connect ~qw 2)*> DB2 z/OS dP: v V“w DB2 Connect ~qw 2 *> DB2 z/OS g{“zNN(EJO,V“w;aXTNN,S#g{kZbyD73PT}]b tCM'zT/XB7I&\,G4&+ DB2 Connect ~qw(DB2 Connect ~qw 1 r DB2 Connect ~qw 2)P`X*D;vr`v}]bD8C~qwhC*V“ w(DThostname)#;s,g{ DB2 Connect ~qw 1 IZNN-rxx(,G4a %“M'zT/XB7I,“RZV“w,1w*w~qwM8C~qwDivBX TM'z,S#K!nJmz9C DB2 M'zT/XB7I&\4iOM,$V“w &\#+8C~qwhC*}KV“wwz{TbDwzT;a*M'za)M'z Z 3 B _ICTM DB2 Connect 65 T/XB7I&\#+G,M'z+kQ(eD8C~qw(“1S,S,Sx49 CV“wM}]b~qw.dD} ]ksMl&D}]b73_PXpD“bBn#P8VCZZ73Pa_r,VT \D=(# DB2 Connect T\“bBn T\GFcz53Zx($w:XDivBDP*==#|\ICJ40J4D9C ==M2m==D0l#g{k*DxT\,XkWHv(T\D,e# zI!qm`;,DT\8j,|(: l&1d &CLr“M}]bksD1dk&CLrSU=l&D1d.dDdt# BqLB? IZ?v1d%*ZjID$w%*}#$w%*I\a\r%(sCfM| B;P)r_\4S(f0IYu SQL od)# }]+dJ ?%;1dZ DB2 Connect &CLrk IBM sMz}]b.d+MD}]V Z}# T\+\IC2~Mm~J4D^F#}g,2~J4=fP CPU“ZfMxgJd w#m~J4=fP(ES53“w3S53M AIX D mbuf# }]w Z 68 3D< 12 T>}](} DB2 Connect Z IBM sMz}]b~qwk$w>. dw/D76# © Copyright IBM Corp. 1993, 2010 67 v IBM sMz}]bM(ES53 B D?~(#Z,;53OKP#K53|(;v r`v CPU“wf“w“I/O S53“DASD MYw53#IZd{LrI\a2m b)i~,J4yCI\aK;)$_,|GIozzb?53T\#r*b)$_>m9C53J 4,yTZ{v}LPzI\<;k$n|G# m 14. CPU MZf9CJDT\$_ 53 $_ hv AIX vmstat“time“ps M tprof a)PX DB2 Connect $w> M6LM'zOD CPU rZ fyCJbDE“# HP-UX vmstat“time“ps“monitor M glance(g{ICD0) Windows Microsoft Performance Monitor m 15. }]bn/DT\$_ 53 $_ hv yP }]b`Sw 7(JbGq4Z}]b System z IBM Tivoli® OMEGAMON® XE for DB2 Performance Monitor on z/OS“ASG-TMON for DB2(ASG)M CA Insight Performance Monitor for DB2 for z/OS(Computer Associates International, Inc.) Windows Microsoft Performance Monitor m 16. xgn/DT\$_ 53 $_ hv AIX netpmon (fM6pDxg3FE“, |(g?kSU=DE“|r !D}?.`D TCP/IP 3F E“# xgXFw,g 3745 NetView® Performance Monitor (f(EXFM VTAM® D9 CJ# Z 4 B w{M DB2 Connect 69 m 16. xgn/DT\$_ (x) 53 $_ hv Linux M UNIX netstat &m TCP/IP w?# E/ ODBC CJ DB2 }]ba)E“Yw,1=4=}]43f# 4. !qr CLI/ODBC “aK}]b# 5. 8(CJK}]bD CLI/ODBC &CLr&gN“a: – w*53}]4m>C}]bI;53OyPC'9C# – w*C'}]4m>zGITCJC}]bD(;C'# – w*D~}]4m>+4(;v|,}]4E“DD~#g{zP TCP/IP , S,G4K}]4D~Ikd{$w>2m#qr,CD~vIZ>(Fc zO9C# 6. dk;v}]4{F. 7. (I!)SE/&CLrPm!q;v&CLr,T*X(&CLrE/}]4 hC# 8. %w7(“Kv CA# v g{*|BVPD,S: 1. t/ DB2 CA# 2. +wk*E/D}]bp{# 3. %w}]4# 4. !qr CLI/ODBC “aK}]b# 5. 8(CJK}]bD CLI/ODBC &CLr&gN“a: – w*53}]4m>C}]bI;53OyPC'9C# – w*C'}]4m>zGITCJC}]bD(;C'# – w*D~}]4m>+4(;v|,}]4E“DD~#g{zP TCP/IP , S,G4K}]4D~Ikd{$w>2m#qr,CD~vIZ>(Fc zO9C# 6. dk;v}]4{F. 7. (I!)SE/&CLrPm!q;v&CLr,T*X(&CLrE/}]4 hC# 8. %w7(“Kv CA# 70 DB2 Connect C'8O &CLrhF 4(&CLr1,I48V=(4DxT\# 4O SQL Mf“}L TZ“MMSU\`|nMp4D&CLr,xg*zI\.Vs#4O SQL Mf“}LG=VuYK*zDl(# g{&CLr“M}v SQL odx;0l`L_-,G4I9C4O SQL# g{Z SQL odiZh*`L_-,G4I9Cf“}L# yPI4PodI|,Z4O SQL odP,+BPod}b: CALL FETCH CLOSE OPEN Compound SQL Connect Prepare Release Describe Rollback Disconnect Set connection execute immediate (}Z~qwOECLr_-,f“}LPzZuYxgw?#ITZKv} L1T/d5#9I5Xa{/,|9M'zOD&CLr_-n!/# Viks +`XD}]bks(SQL od)iO*;v}]bksIuYZxgP+M DksMl&}# }g,+BPod: SELECT COL1, COL2, COL5, COL6 FROM TABLEA WHERE ROW_ID=1 SELECT COL1, COL2, COL5, COL6 FROM TABLEA WHERE ROW_ID=2 Vi* SELECT COL1, COL2, COL5, COL6 FROM TABLEA WHERE ROW_ID=1 OR ROW_ID=2 I9xgPDks}?Y;)# 9I9Cng IN M BETWEEN .`DX|V,TuY5XDP}#Kb,9 IZ UPDATE M DELETE odO9C WHERE“IN M BETWEEN X|V# =J_- I9C=J_-4vksh*DPMP#b9C}]+dDxgw?M CPU * zn!/# }g,;*9Ci/: SELECT * FROM TABLEA (v1D7h* ROW_ID * 1 D TABLEA DZ;P1rv1h*P 1 MP 2 1)# }]Vi Z 4 B w{M DB2 Connect 71 g{kS~qwq!s?D}],&9C}]Vi#ViDxKxgxmD9 C“uYK IBM sMz}]b~qwM DB2 Connect ~qwD CPU *z# TZ“MMSUD?u{“(;G#_#|f0 DB2 Con- nect zmxLD4(“KzmxLk DB2 ~qw.dxg,SD(“T0~qwO DB2 _LD4(#TZ$ZKPD,S,b)I>Gy]ZK,SO4PDyPBq4 [ID,+TZdMD Web Bq,b)I>(#a,}4PBq>mDI># ,SXGbyD;V,S,+ZXP#fkwzD v>,S#1BD&CLrks,S1,DB2 Connect 9CVPXPD;v,S#9C QfZD,SuYK\e,S1d,T0wzOD_ CPU ,SI># DB2 Connect zmxLITGb=V4,.;:UPrn/#zmxLZ|*&CLr xP$w1&Zn/4,#;)K$wjI,zmxLMxkUP4,,H}4T, ;rm;&CLrDx;=$w#yPUPDzmxL<;;p#fZF*UPzm xLXDXP#IT9C num_poolagents dCN}4dCKXDs!#KN}HZ k*53,$DUPzmxLDns}?#+KN}hC*cMHZXU,SX& \#KdCN}D1!5hC* AUTOMATIC,“Rd5* 100#hC* AUTO- MATIC 1,DB2 Connect aT/\mUPzmxLXPDUPzmxL}# ZSU=Z;vM'zks.0,DB2 Connect ;a(“k}]bD,S#+G,IZ NNM'zxPks0rXndUPzmxL#ITZ9C num_initagents dCN} xPt/1ndCX#KN}7(&Zt/14(`YvUPzmxL#b)UPz mxL+;a;* ns,S}#)KdCN}D1!5hC* AUTOMATIC,“Rd5* 200#hC* AUTOMATIC 1,DB2 Connect aT/\m-wzmxL}# DB2 “amd? DB2CONNECT_IN_APP_PROCESS JmZ DB2 Connect ~qwz7 yZzwOKPD&CLrC DB2 Connect Z&CLrxLZKP(1!P*)r_ 9&CLr,SA DB2 Connect ~qwz7,;s9wz,SZzmxLZKP#* 9&CLr9C,SX,kwzD,SXkZ DB2 Connect ~qwz7zmxLPx P,rx DB2CONNECT_IN_APP_PROCESS XkhC* NO# DB2 Connect ,SXk&CLr~qw,SX ,SXTNNyZ Web ;OC4Td{zw“C'rxLD,S#d;b )&CLr~qwOCM Web C'yhD J4#K&\Isya_ DB2 z/OS fM DB2 Connect bv=8DIluT,,19 aZ DB2 z/OS f}]2m73Pa)JO#UYwMBq6p:Xyb# ,S/PwJm&CLrZ DB2 wz~qwO#V,Sx;{DNNJ4#IT9} T'FDC'Z&CLrP&Zn/4,,xv98v_LZ DB2 wz~qwO&Z n/4,# DB2 Connect D,S/Pw&CLr,S# v -wzmxL,|5P DB2 ,SM_L,“4P&CLrks# 1;vB&CLrT#;T.,;v&CL rXkHO*,S,m;v&CLrEI4COCD,S# m;=f,,S/PwJm DB2 Connect Z;v&CLraxBq1,d,SI“4 CZm;v&CLr,x^h0_HO*,S#y>O,v1&CLr_Pn/DB q1,|E9C}]b~qw,S0dX*DwzM DB2 Connect J4#;)Bq& mjI,,S0dX*DJ4MIIh*4PBqDNNd{&CLr9C# Z 4 B w{M DB2 Connect 75 ZH0f>D DB2 Connect P,?vn/D&CLr<_P“}fwH%*”(EDU), |\m}]b,SMNN&CLrks#K EDU (#;F*-wzmxL#?v-w zmxL= Y# ,S/Pw+zmxLV*=v5e,_-zmxLM$wLrzmxL#_-zm xLm>;v&CLr,+kX(D EDU ^X#_-zmxL|,&CLryXhD yPE“MXFi#g{P n v&CLrkC~qw,S,G4C~qwO+aP n v _-zmxL#$wLrzmxLG4P&CLrksDom EDU,+kNNx(D& CLr^@CTDX*#$wLrzmxLk_-zmxL`X*T4PBqRZB q_g&axX*“5XAICDX# F*VIwD5e+$wLrzmxLVdx_-zmxL#T3)Fc=(Or* D~dz}D^FI\azz`vwHLr5}# ,S/PwD^F T DB2 Connect ~qw/PwD9CP;)X*D^F#ZTXM6LM'zDk>,S#v9C TCP/IP r “>X”(IPC)Dk>,SI{COCDv>,S#/Pw+S\(}d{(E-i (g|{\@)xPD,S,+z^(+d XA /P&\kC,SdO9C# v TZ XA t\nOBq'V,Nk,; XA BqDyP&CLrXk9C,; DB2 Connect ~qw5}4,SAwz# v vPZBq_gaxVFJ4(gVFNj)D&CLrE\S/Pw\f#4X UVFNjDBq+TLxxP,+a;Vd(CD$wLrzmxL,RrKx +^(9C/PwD+?&\?~/# v g{ywY1m,G4|GXkZBqrV'_g&;T=>}#g{^(>}b )m,G4+aXU,S/P,+&CLr+Lx$w# v Nk,; XA BqDyP&CLrXk_P,; CCSID “9C,;C'j64xP ,S# v g{v>,S(“D?DG'V=WN,S,G4C,SDzmxLvIC4'V =WN,S#`FX,(“?DG'V;WN,SDzmxLvI'V;WN, S# v /Pw'VG)9CCZ JDBC M SQLJ D IBM }]~qw}/LrD&CLr, T0G)9C/, SQL DwC6SZ (CLI) &CLr#CLI &CLr2;&9C KEEPDYNAMIC w*/Pw,b!vZ}Z?vBq_gOXB<8Dod# v 6k=/, SQL &CLrD/,<8ks+;\x#&Ddb)&CLrT9C2 , SQL r9C/, SQL odD CLI# v g{,S/PwQr*,G4T DB2 Connect ~qwDk>ks;\9C SSL#+ G,T?j}]b~qwDv>ksI9C SSL#g{,S/PwQXU,G4k> Mv>ks 9 rf> 8 ^)| 13(r|_f>)1,tC DB2 Connect /Pw 'Vh* IBM Power Systems f> 5 “Pf> 4(PTF SI23726)#qr,;'V, S/PwD XA ?V# $n,S/Pw }]b\mwdCN} max_coordagents hC_-zmxLDns}?#IT(}+ max_connections D5hC*sZ1!5DNN54$nC/Pw&\#max_connections D1!5HZ max_coordagents D5#r*?v&CLr<+_P;v_-zmxL, yT max_connections 5JOXFI,SA}]b5}D&CLrD}?,x max_coordagents XFIf1$nDk>,SD}?#max_connections D}V6'+* max_coordagents = 64 000#_-zmxLD1!}?HZ max_coordagents# IT+ max_connections M max_coordagents 5#g { max_connections M max_coordagents 5,x max_coordagents +T/vs,T,V,S}k-wzmx L}.dD/PHJ# P8vVPDdCN}C4dCzmxL#b)N}gBy>: max_coordagents n/D-wzmxLDns}?# num_poolagents zmxLXs!#zmxLX|(;n/zmxLMUPzmxL#*a_T \,&+ num_poolagents dC*kM'z=y}`HD5# num_initagents XP$wLrzmxLDu<}?#b)zmxL+GUPzmxL# XA Bq'V ,S/PwDe5a9Jm DB2 Connect * DB2 z/OS fM DB2 IBM i fa)t\ nOD XA Bq'V#/Pw+$wLrzmxLkX(D XA Bq(%v XID)` X*,Ms|TNNd{BqywDGy#+G,g{ XA BqGI xa_end()(V' _g)axD,G4$wLrzmxL+;aME|>m“CZ(CXP#`4,$ wLrTkCX( XA Bq`X*#1m;v&CLr,S,; XA Bq1,$wL rzmxL+kC&CLr`,# NNBq_gwC+QzmxL5XAX#}g,xa_prepare()(;A)“ xa_rollback()“xa_recover()“xa_forget()“xa_commit() rmvaxBqV',xb;cTax|k XID DX*# XA Bq'VD>} 1. )4+53'Ja}An_: MAX_CONNECTIONS = 4,000 MAX_COORDAGENTS = 1,000 NUM_POOLAGENTS = 1,000 /Pw+a#Vr*`o 4 000 v““a0,49xXv,1\m 1 000 vBq` gK# 2. ZTO>}P,$wLrzmxL+a;ONIMO*k_-zmxLDX*#G )4&ZUP4,DzmxLI\a,Vk}]bD,S,+;NkNNX(B q,rK,|GICZks,SDNN_-zmxL(&CLr)# XA BqDivP);,#TZK>},Y( TP `Sw}k DB2 Connect xXM System z r IBM Power Systems }]b;p9C#&CLrks,S1,/Pw +9;n/DzmxL**&mCks,r4(BD$wLrzmxL#Y(&C Lrks XA Bq#*KBq4(;v XID R$wLrzmxLk|`X*# ZQ&m&CLrDkss,&CLr“v xa_end() “S$wLrzmxLpk# $wLrzmxLTkCBqD XID `X*#VZ,|vI&mT_Pd`X* XID DBqDks# K1,m;v&CLrI\aTG XA BqxPks#49;PNNd{ICD$ wLrzmxL,k XID `X*DzmxL2+;ICZZ~v&CLr#|;S wGn/D#+a*Z~v&CLr4(BD$wLrzmxL#1Z~v&CL rjIdBq&m1,|D$wLrzmxL;ME=ICDXP# kK,1,kskZ;vzmxL XID `X*DBqDd{&CLrI\akCz mxL`,SMO*,S,CzmxL*b)&CLr4Pd(CD XA Bq#N NksCX(BqD&CLr+;“MAK$wLrzmxL(g{|GUP)# Z&CLr“vBq_gwC(x;G xa_end())T0,$wLrzmxL+;a ;MEX(CXP#}g,&CLrI\C xa_commit() axBq,,1$wLr zmxLO*|kC XID DX*“5XAICDX#K1,NNxPksD&CL rm,49|48(d{N}2 GgK# hz[O53DM'zT/XB7I&\,1!P*GZvV(EJO1,tCK[ O53D,SXTC,S#1 DB2 Connect ,SA DB2 z/OS f~qw1,(CDf w5+;Ovs,1=XB4P45PJ4Dns;vI&Bq*9# z I T 9 C DB2_MAX_CLIENT_CONNRETRIES M DB2_CONNRETRIES_INTERVAL “amd?,dC<7DM'zT/XB7IXT P*,dP|({C#,S,1“amd?G DB2TCP_CLIENT_CONTIMEOUT# Z 4 B w{M DB2 Connect 79 System z [O53{CD“bBn DB2 Connect Z+,SXB7IA`v[O531a):XybM]m&\#1,SA KPZ}]2m73PD DB2 z/OS f}]b~qw1,DB2 Connect +y]“$w: X\mw”(WLM)a)D53:XE“4ZiI}]2miD;, DB2 S53.d V/$w:X# DB2 Connect aS WLM SU=[O53I1DEHPm#?v[O535X?v, SX7DS(EH6E“#;s,DB2 Connect 9CKPm4&mkV CONNECT k s,|+b)ksV“x8(Kn_EH6DtI[O53I1#TZ:Xyb,[ O53S(EH6E“DPmGZ?N,SZdqCD#g{tCK DB2 Connect , S/Pw,G4Z7(+?vBq“M=N&12*9CKPm# “:;h*|D System z V<=}]h)(DDF)dCMIT9C DB2 Connect [ O53{C# ZvV,SJO1,DB2 Connect 9(}“T,SA8CD[O53zwa)]m& \#v1yPQ*,S<'\1,msEa5X=&CLrP# DB2 Connect [O53ZhF1O_Y:f5XDX7Pm#;) T TCP/IP Zc“vKu< CONNECT,G4+5X IP X7# CZ:XybM]mDEH6E“ DB2 z/OS fa)DX7Pm9,EH6E“(|,?vxgX7D,S})#?1 DB2 Connect (“KB,S1,Ma“BCPm#K=SE“CZxP:XybT0] m# 80 DB2 Connect C'8O DB2 Connect 9CD_Y:fX7Pm g{k ALIASB D}]b,S'\,G4a“vms{“ SQL30081N,“R+>}C ,S#g{SU= ALIASB DYN,Sks,G4 DB2 Connect +4PBPYw: 1. |y] DB2 z/OS f5XDEH6E“4T_Y:fDX7PmPEH6n_D~ qwxP“T#DB2 Connect O“zs?Dw3# g{1! DRDA is!(32767);aZ4P&CLr1“z}`Dw3,G49CC is!#qr,u! I/O is!,1=;“zw3*9#;)*<“zw3,MavV TxDT\5M#9CT\`Sw$_(gCZ Linux M UNIX Yw53D vmstat $ _)T7(53OGq}Z“zw3# DIR_CACHE DIR_CACHE N } 7 ( G q T ? < E “ x P _ Y : f # h z Z _ Y : f (DIR_CACHE=YES),A!?# g{|B_Y:fD?<,G4b)|D;a“44FA_Y:f#g{4Z_Y: fPR=?P;\ NUMDB dCN}D0l,+G,TZf> 8, bViv“zKd/#KN}8>M'z(} DB2 Connect ~qwI,SAD}]b Dns}?#|_exT,IZ DB2 Connect ~qwO`?D;,}]bp{Dns }?# d{ DB2 ConnectN} f> 9.5 P(i;*9C AGENTPRI M MAXAGENTS# CZ|B MAXAGENTS D5D|n+LxpwC,byVP&CLrM;aPO,+ +avT5#N}{;avVZNNdCPmP#T0,JmZx( DB2 VxO4( D\zmxL}G(} MAXAGENTS dCN}XFD#VZ,zITT/dCzmx L# 1!ivB,NUM_POOLAGENTS +hC* AUTOMATIC,“Rd1!5* 100# ,yZ1!ivB,MAX_COORDAGENTS +hC* AUTOMATIC,“Rd1!5* 200# *SM'z&CLrr DB2 Connect ~qw“MGJV{.,9CX( API ==hC GJE“#X( API b6E4PYHHhC DB2ACCOUNT 73d?l# IBM }]~qw JDBC M SQLJ }/Lr com.ibm.db2.jcc.DB2BaseDataSource.clientAccountingInformation tT IBM Data Server Provider for .NET DB2Connection.ClientAccountingInformation tT CLI/ODBC ClientAcctStr CLI/ODBC dCX|V 6k= SQL (C“C++ M COBOL) sqlesact /} g{;h*(FD SQLCODE 3dD~,G4I(}9C1! SQLCODE 3drO* SQLCODE 3d4DxT\#1!3dD~G6kZ DB2 Connect bPD,(FD3 dD~XkSELA!,xba0lT\# 82 DB2 Connect C'8O wz}]bw{ 53T\+\ IBM sMz}]b~qwT\D0l#;,D}]b\m53P;,D T\&\?~#}g,;,53D SQL E/wZ,;&CLrPP*I\a;,#i 4 IBM sMz}]b~qw53T\D5TKb|`E“# JC1,zIT(}9C“4d5DA”(UR)r“;d5”(NC)s(!nT\bGk U>4a_T\# “:9C UR 1,4GkU>D}]vIA!,;\|B,rK,v1+VihC* ALL 1EI|B# S&CLr~qw0da)Dx(#HD;,,CZi/r&CLrDtk6pI\ TT\PTxD0l#}]b&_PJ1Df6/6p“w}DP'9CM}]bU dDOmVd#T\9a\=y9CD}]`MD0l,}gZBf8ZPyhv D# xgw{“bBn DxV<=}]b73\eT\DnCl(G}%xgPDSY#xg\m1UiO *g{xg\;!I\XU/+dPD}],G4|a|P'J#K=(TngV< =}]b.`D&CLr;pwC,-rG|ZxgPlIKSY#nUC'4;= xgD'J,;4C=SY# s?Vxgh8_PSYN},xb)N}PDs`}N}D1!5TZV<=}] bxT<\;JC#*DxT\,&Rvb)N}Rg{PI\,+|GhC*c# Kb,9&7#h8OD:exs!c;s,T@9IZ*'}]xxPXB“M# }g,UNIX 53D“+M”r“SU”SPnH1!5(#* 32#*KqC|CD'{, +SPnHhC* 150#DLC hCO`&DN}*“SUnH”,2&+|hC* 150# Zs?VX=,IOBUF N},S)H(“SM'zAxXD,S(k>, S)(Q*`C`#Z;v}T'FDM'z(}xX51X,SA~qw0S~q wO*,SD73P,`1;?V&m1d<(ZK(“v>,SO#DB2 Connect a )KyZ TCP/IP D,SX#1M'zksO*k~qwD,S1,xXO*kM'z Dk>,S,+ZXP#fk~qwDv>,S#1BDM'zrxXks,S1, xXa)XPDVP,S,SxuYK\D,S1d“Z!K~qwOD_ CPU ,S I># Z 4 B w{M DB2 Connect 83 m 17 Pa)KxgT\w{=(D\a# m 17. xgT\w{=( iR24 >} hC “b JbSY xgh8OSYN} hC* 0# 1!5(#O_# :ex IOBUF N} hC* 3992# T ESCON rd{(@ JdwHdPC# :ex RUSIZE nEs!* 4096# + RUSIZE M RQRIOBLK hC*` ,Ds!IzznQ T\# :ex w= VPACING“PACING M“==E*D~”& hC* 63# ZJ1DX=9CT J&w=# JdwhC +M/SUSPnH (i5* 150# 1!5(#* 32# TCP hC Ns! ZT+xO* 1500, ZnF7M FDDI O * 4400# CZ TCP/IP D ESCON Jdw&: db2 update database manager configuration using RQRIOBLK 32767 84 DB2 Connect C'8O 2. 7#Z IBMRDB ==(eP(eDns RU s!;hC*OJD5#TZ9Cn F72~D,S,(i9C;MZ 4K D RU s!#TZ9CT+x2~D,S, “bnsDT+x!s!* 1536 vVZ,bI\G;v^FrX# w{ DB2 z/OS f IZ z/OS PE/;n/D_L&m#Z V5 P,In`““,S 25,000 (M'z# +G,ZyPivB,I““n/Dns(}* 1999#?v$w>M'z# uYM'z“MA~qwDTi/iDksN}9T\Txa_#T\DTxa_G r*Z“MkSU.dxPP;ST\O45G:sDYw#VZ,Z1!ivB, DB2 Connect IT(}S DB2 z/OS f~qwksnbi/i4{CKT\v?&\# *TW!Dxg-i TCP/IP dV{C5XDnbi/i(?vbyDi/in$IT * 32K VZ),XktC0ZuE)9,MsZ DB2 Connect D RFC-1323 Bf9 (D;y#K&\Jm TCP/IP /,Xw{“MMSU0Zs!T]I(}nbi/i _'5XD1ZDs?}]# nbi/i xP DB2 z/OS ff> 7 r|_f>D~qwODnbi/i'VG(} DB2 DDF 20feO EXTRA BLOCKS SRV N}dCD#K'VG(}XFnbi/iDns }?4dCD, TZ3;ks,DB2 I+nbi/i“MXM'z#IT+KN}h C*iZ 0 k 100 .dD5#+CN}5hC* 0 +{Cnbi/iD5X#&C ;19C1!5 100 4ns^HX{CK&\,T@9xgP+QKhCd*!Zmk hCDNNXT# ZM'K,^[&CLrG(}k DB2 z/OS f `,;CD DB2 Connect 201S CJ9G;,;CD DB2 Connect ~qw20CJ,mP8(“OPTIMIZE for N ROWS”SdM/r“FETCH FIRST N ROWS ONLY”Sd,C'MITwCTi/Dnbi/i'V# v (}9C“OPTIMIZE for N ROWS”Sd,DB2 z/OS f+y] EXTRA BLOCKS SRV DDF 20N}hC“TT*5XA DB2 Connect DZ{P }xPVi#&CLrIT!qCfDP},} N,r* DB2 z/OS f;a +nU5XDi/a{/D\P}^F* N# v “FETCH FIRST N ROWS ONLY”Sd$wD=(kd`F,+ DB2 z/OS f+i/a{/^F* N P#Cf,} N P+~qw,+D*9C“FETCH FIRST N ROWS ONLY”Sd# – TZf> 7,i/a{; DB2 z/OS f^F* N P#Cf,} N P+ 8 r|Bf>,CLI 7#(}M'zNj\mwv+0 N P5 Xx&CLr# JDBC C'IT(} setMaxRows =(4wCTi/Dnbi/i'V#k CLI/ ODBC 'V`F,DB2 Connect +kT DB2 z/OS f 6.x ~qwjG “OPTIMIZE for N ROWS”Sd#DB2 Connect 9+kT DB2 z/OS f 7.1 r |_f>~qwjG“FETCH FIRST N ROWS ONLY”Sd# RFC-1323 0ZuE TZ'V TCP/IP D RFC-1323 )9DyP Windows“Linux M UNIX =(45,0 ZuEG\'VD#I(}9C DB2 “amd? DB2SORCVBUF Z DB2 Windows f“Linux fr UNIX fOtCK&\#*r*0ZuE,K“amd?&ChC* 64K TODNN5#}g,Z DB2 Windows f“Linux fr UNIX fO,I“v db2set DB2SORCVBUF =65537# ns“M:exs!MSU:exs!SX(Yw53x(#*7#S\ydCD: exs!,C'IT+}]b\mwdCN} DIAGLEVEL hC* 4(N<)“li \m(*U>D~PD{“# *90ZuEz',XkZ,SD=K(4$w>MwzO)tC|,I1S(}Y w53 TCP/IP Q;rdS(} DB2 z745V#}g,TZ DB2 z/OS f,10v I(}Yw53+ TCPRCVBUFRSIZE hC* 64K TODNN54$n0ZuE#g {*(} DB2 Connect ~qw$w>9C6L IBM }]~qwM'z4CJ IBM s Mz DB2 }]b,G49IZM'zOtC0ZuE#(},;jG,Z4f0 IBM sMz DB2 }]b1,9IZ6L IBM }]~qwM'zk$w> DB2 ~qw. dtC0ZuE# d;0ZuEGC4v?xgT\D,+5C“bDG$ZDxgT\a_“;\G a5V#;)tCK0ZuE,wvrX.dD;%(gCZT+xrnF7 LAN J dwD!s!“IP MTU s!T0{v(E47ODd{7IwhC)uAI\a(#!Z}V}]*;DI ># DATE/TIME/TIMESTAMP D}]*;I>8uk%VZ CHAR DI>`,#!c} ]*;I>n_#&CLrhF_ZhFyZ DB2 Connect D&CLr1I\a*{ Cb)B5# g{}]bmP;P(e*“FOR BIT DATA”,G4}Z&CLrk}]bd+MDV {}];h*xPNN}]*;#Z IBM sMz}]b~qwOi5}]1IT9C bV=(# V{}]D}]`M V{}]I_P CHAR r VARCHAR }]`M#DV}]`M|P'*SVNP} ]D;c$Hx(: v g{5J}]Ds!d/Tx,G4 VARCHAR |*P',-rG CHAR mSK =SDUWV{4ndVN#b)UWV{XksNNd{V{;yZxgP+ M# v g{5J}]Ds!d/;s,G4 CHAR |*P',-rG?v VARCHAR V NP8vVZD$HE“Xk+M# xg2~ BP“bBnk2~`X: v xgr+diJDYH 9COlYD+diJ+aDxT\#}g,TB*;)dMD-<}]+dJ: (@d(bK) 4.0 MB/k 16 Mbps LAN 2.0 MB/k (@d(#f) 1.0 MB/k 4 Mbps LAN 0.5 MB/k _Y T1 X((1.544 Mbps) 0.193 MB/k Z 4 B w{M DB2 Connect 87 lY6L 56 Kbps g0_ 0.007 MB/k 19.6 Kbps wFbww 0.002 MB/k 9600 bps wFbww 0.001 MB/k }]+dJ\ IBM sMz}]b~qw76PYJnMD+diJD^F# v xgJdwr(EXFw &wwf.xgJdwM(EXFwDZf9C#Kb,9&kxg(5K1;@ OwT7#XFw\;&mI DB2 Connect zID=Sw?# v xgXKa9 g{}]Z;,D LAN .dw/,T0Z;,Dxg.dw/,G4&6#AY*XpBPJ b: v nuD,SQ-I&Kp? v 2~KP}#p? v (E76}#p? v PNN(Exg|Da9H0D?X\I&4P|p? u<,S4I& 4iBPJb“7#Qq-K20=h: 1. I&jIK20}Lp? v yPX8m~z7(E? v XkdCT~qw(eM'zI1“TM'z(e IBM sM z~qw# c. M'z$w>dCXk(e$w>D{FM(E-i# v XZ44Pnu,SDJbVv|(:i$ PU(om%*){F“(*D~M/(U>ZZDyPoO}]< ZoO}]?<76(diagpath)}]b\mwdCN}8(D76P: g{KdCN}D5* null,G4oO}]+4kBP?# v IT9CDoO$_|( db2trc“db2pd“db2support M db2diag v TZ Linux M UNIX Yw53,ps |n+XZn/xLDxL4,E“5X=j +.VP^# 49;*szq!zYD~,z2&C*@gN}7Xt/zYT0gN*“zYD ~# “:zh* SYSADM“SYSCTRL r SYSMAINT (^DdP;V(^49C db2trc# *sBKbICD!n,4P;xNNN}D db2trc |n: C:\>db2trc C(:db2trc (chg|clr|dmp|flw|fmt|inf|off|on) options PXX( db2trc |nN}D|`E“,k9C -u !n#}g,*i4PXt/zYD |`E“,k4PTB|n: db2trc on -u baa)PXIZt/ DB2 zY18(DyP=S!n(j“*“$_”)DE“# tCzY1,nX*D!nG -L#|8(CZf“zYE“DZf:exDs!#:e xs!ITVZrWVZ*%;48(#*8(WVZ,G4Z5sf7S“M”r“m”# zY:exs!XkG 2 WVZD]#g{8(Ds!;{OK*s,G4:exs! +T/ak*nS|D 2 D]# g{:ex+!,G4E“I\a*'#Z1!ivB,g{:exdz,G4;a #tnBDzYE“#g{:e+s,I\QT+D~“MA IBM m~'VES# g{zY1d`TOLDYw(g}]b,S),G4sE 8MBs!(#MQc;: C:\> db2trc on -l 8M Qt/zY +G,g{zYf#OsDYwr_,1ZxPs?$w,G4I\h*OsDzY :ex# Zs`}=(O,zYI4gOyvf1r*“$w#+G,P)X(ivh*“ b: 1. Z`}]bVx53O,XkT?vom(`TZ_-)}]bVxKPzY# 2. Z HP-UX O,Linux M Solaris =(O,g{Zt/5}sXUzY,G4;\8 (s!gN,B;Nt/zY1db2trc clr Qe}zY 94 DB2 Connect C'8O *zYDYwjIs,9CszzYD~{D dmp !n+Zf:eX*“AEL#} g: C:\>db2trc dmp trace.dmp zYQ*“AD~ zY:ex*“AELs,zY$_+LxKP#*XUzY,9C OFF !n: C:\>db2trc off QXUzY q=/ DB2 zYD~ db2trc dmp |n4(D*“D~*~xFq=,“R;IA!#*i$GqIA!zY D~,kT~xFzYD~xPq=/TT>w?XF“+q=/dv“MAUh 8# BfD>}T>KCZ4PKNqD|n: db2trc flw example.trc nul dP example.trc 9C dmp !nzID~xFD~# K|nDdv+T=X8vA!D~GqPJb,T0zYGqQO“# K1,I+*“D~“MA IBM m~'Vz9#{Gay]zD DB2 ~q6p4T dxPq=/#+P1I\a*szZ“M*“D~.0+d*;* ASCII q=#bG (} flw M fmt !njID#Xka)~xF*“D~D{F0*4(D ASCII D~ D{F: C:\>db2trc flw trace.dmp trace.flw C:\Temp>db2trc flw trace.dmp trace.flw \zYG<}:18854 XOzY:NO O“zY:NO q=/DzYG<}:1513(pid:2196 tid 2148 Zc:-1) q=/DzYG<}:100(pid:1568 tid 1304 Zc:0) ... C:\>db2trc fmt trace.dmp trace.fmt C:\Temp>db2trc fmt trace.dmp trace.fmt XOzY:NO O“zY:NO \zYG<}:18854 q=/DzYG<}:18854 g{Kdv8>“O“zY”*“YES”,G4m>zY:ex;;s,^(|,zY1d NU/DyPE“#y]iv,O“zY2mGIPD#g{zXDDGnBE“ (}G8(K -i !n,qrbG1!ivB#tDE“),G4zYD~PDZ]I\ Q-c;#+G,g{zXDDGzY1dN*<1“zDiv,r_XD“zDy Piv,G4zI\k*9C|sDzY:exXvCYw# +~xFD~q=/*IAD>D~1,P;)!nIC#}g,I9C db2trc fmt -xml trace.dmp trace.fmt *;~xF}]“T XML Ibvq=dva{#d{! nT>ZzY|n(db2trc)Dj8hvP# *“bDm;~BG:Z Linux M UNIX Yw53O,DB2 Zr*OXmsxXU5 }1aT/+zY:ex*“AEL#rK,g{5}l#ax1tCKzY,G4 Z 5 B JOoO 95 aZoO?}: db2trc on -l 8M db2trc clr db2trc dump db2trc.dmp db2trc off db2trc flw db2trc.dmp .flw db2trc fmt db2trc.dmp .fmt db2trc fmt -c db2trc.dmp .fmtc DRDA zYD~ ZVv DRDA zY.0,XkKb DRDA G}]M(Ea9D(eD*E=j<# }g,DRDA |,PX}]+dDi/==T0PXCE“D(E==D;ifr# b)frGZTBNIS www.opengroup.org q!# db2drdat 5CLrG< DRDA Application Requestor(AR)k DB2 DRDA Applica- tion Server(AS).d(g DB2 Connect kwzr Power Systems Servers }]b~ qw.d)D}];;# zY5CLr db2drdat 5CLrG< DB2 Connect ~qw(zmIBM }]~qwM'z)k IBM sMz}]b~qw.d;;D}]# w*}]b\m1(r&CLr*“_),zI\a“VKbK}]wgN$wG\ PCD,r*b)*6ITozz7(X(JbDp4#Y(z&ZTBivP:T IBM sMz}]b~qw“vK CONNECT TO }]bod,+GC|n'\“RzSU =;v;I&D5Xk#g{z75Kb=D)E“;+M= IBM sMz}]b~q w\m53,G4zMI\\;7(JOD-r,495XkE“G;cE“#\` JOGIr%DC'mslID# 4T db2drdat DdvP>K DB2 Connect $w>k IBM sMz}]b~qw\m 53.d;;D}]w#“M= IBM sMz}]b~qwD}]jG* SEND BUF- FER,xS IBM sMz}]b~qwSU=D}]jG* RECEIVE BUFFER# g{SU:exP|, SQLCA E“,G4|+sSK}]DQq=/DbM“jG* SQLCA#SQLCA D SQLCODE VNG IBM sMz}]b~qwy5XD43dD 5#ZD~P,“M:exMSU:exG4SnI=nBD3r4EPD#?v: ex<_P: v xLj6# v SEND BUFFER“RECEIVE BUFFER r SQLCA jE#:exPDZ;v DDM | nrTs;jG* DSS TYPE# 96 DB2 Connect C'8O Z“M:exMSU:exPDd{}];VIeP,|(: v VZ}# v Z 2 PMZ 3 Pm>Z=v53.dy;;D DRDA }]w,IC ASCII r EBCDIC q=# v Z 2 PMZ 3 PD ASCII m># v Z 2 PMZ 3 PD EBCDIC m># zYdv db2drdat 5CLr+BPE“4k=zYD~P: v -r – DRDA &p/TsD`M – SU:ex v -s – DRDA ksD`M – “M:ex v -c – SQLCA v TCP/IP msE“ – SU/}5Xk – OXT – 9CD-i – 9CD API – &\ – msE “: 1. vZkD5*c,8>I&jIK|n,Gc58>;PI&jI|n# 2. 5XDVN+f9CD API ;,x;,# 3. 5XDVN+fKP DB2 Connect D=(;,x;,,49TZ,; API 2Gg K# 4. g{ db2drdat |n+dv“MAQfZDD~,G4+A}ID~,}GD~Dm I(;JmA}# zYdvD~Vv Z db2drdat zYP6q=BPE“: v M'z&CLrDxLj6(PID) v Z}]b,S~q(DCS)?{, 4U DDM f6,|Gzkc X’116D’#EXCSAT |nZZ;v:exP#Z EXCSAT |nZ,;)}%K X’116D’,5 X’9481A292’(4 CCSID 500 ` k)M;*;*Zk# EXCSAT |n9|, EXTNAM(b?{)Ts,(#+CTsEZ IBM s Mz}]b\m53ODoOE“P#|I 20 vVZD&CLrj6“sS 8 vVZDxLj6(r_G 4 vVZDxLj6M 4 vVZD_Lj6)i I#|Izkc X’115E’ m>,ZK>}P,d5* db2bp “CUqnd,s S 000C50CC#Z Linux r UNIX IBM }]~qwM'zO,IT+K5k ps |n`X*,C|n+kn/xLPXDxL4,E“5X=j* DB2 Connect $w>dCDzk /#ZK>}P,CCSIDSBC * X’0333’,zk/* 819# Z ACCRDB |nP9fZ=STs CCSIDDBC(+VZV{D CCSID)M CCSIDMBC(lOVZV{D CCSID),|GDzkcVp* X’119D’ M X’119E’ #ZK>}P,CCSIDDBC * X’04B0’,zk/* 1200;CCSIDMBC * X’0333’,zk/* 819# EXCSATRD M ACCRDBRM CCSID 52GS IBM sMz}]b~qwDZ~v:exZD“CJ RDB & p{“”(ACCRDBRM)P5XD#K:exP|, EXCSATRD,sS ACCRDBRM#y>dvD~P|, IBM sMz}]b~qw53D=v CCSID 5#b=v5Vp* 1208(TZ%VZV{MlOVZV{)M 1200 (TZ+VZV{)# g{ DB2 Connect ;\6pS IBM sMz}]b~qw5XDzk3,G4 +TC'5X SQLCODE -332 T04M?jzk3#g{ IBM sMz}]b ~qw;6pS DB2 Connect “MDzk/,G4|+5X VALNSPRM(; \'VDN}5,DDM zkc* X’1252’),“*C'*;* SQLCODE -332# ACCRDBRM 9|,N} PRDID(X(z7j6,zkc* X’112E’)#5* X’C4E2D5F0F8F0F1F5’,C EBCDIC m>* DSN08015#4Uj<,DSN * DB2 z/OS f#98>Kf>E#ARI m> DB2 ~qw VSE fM VM f, SQL m> DB2 }]br DB2 Connect,x QSQ m> DB2 IBM i f# 98 DB2 Connect C'8O zYdvD~y> BPwKy>dv,TDB2 Connect$w>kwzr System i }]b~qw.d ;;D;) DRDA }]wxPK5w#SC'DGH44,Q-9C|nP&mw (CLP)“vK CONNECT TO }]b|n# Z 100 3D< 13 9C TCP/IP ,SOD DB2 Connect s5ff> 9.1 M DB2 z/OS ff> 8# Z 5 B JOoO 99 1 data DB2 UDB DRDA Communication Manager sqljcSend fnc (3.3.54.5.0.100) pid 807116 tid 1 cpid -1 node 0 sec 0 nsec 0 probe 100 bytes 16 Data1 (PD_TYPE_UINT,8) unsigned integer: 233 2 data DB2 UDB DRDA Communication Manager sqljcSend fnc (3.3.54.5.0.1177) pid 807116 tid 1 cpid -1 node 0 sec 0 nsec 19532 probe 1177 bytes 250 SEND BUFFER(AR): EXCSAT RQSDSS (ASCII) (EBCDIC) 01234567 89ABCDEF 0123456789ABCDEF 0123456789ABCDEF 0000 00C3D041000100BD 1041007F115E8482 ...A.....A...^.. .C}........“.;db 0010 F282974040404040 4040404040404040 ...@@@@@@@@@@@@@ 2bp 0020 4040F0F0F0C3F5F0 C3C3F0F0F0000000 @@.............. 000C50CC000... 0030 0000000000000000 0000000000000000 ................ ................ 0040 0000000000000000 000000000060F0F0 .............`.. .............-00 0050 F0F1A2A495404040 4040404040404040 .....@@@@@@@@@@@ 01sun 0060 4040404040404040 4040404040404040 @@@@@@@@@@@@@@@@ 0070 C4C5C3E5F8404040 F0A2A49540404040 .....@@@....@@@@ DECV8 0sun 0080 4040404040404040 4000181404140300 @@@@@@@@@....... ....... 0090 0724070008147400 05240F0008144000 .$....t..$....@. .............. . 00A0 08000E1147D8C4C2 F261C1C9E7F6F400 ....G....a...... .....QDB2/AIX64. 00B0 08116D9481A29200 0C115AE2D8D3F0F9 ..m.......Z..... .._mask...]SQL09 00C0 F0F0F0 ... 000 ACCSEC RQSDSS (ASCII) (EBCDIC) 01234567 89ABCDEF 0123456789ABCDEF 0123456789ABCDEF 0000 0026D00100020020 106D000611A20003 .&..... .m...... ..}......_...s.. 0010 00162110E2E3D3C5 C3F1404040404040 ..!.......@@@@@@ ....STLEC1 0020 404040404040 @@@@@@ 3 data DB2 UDB DRDA Communication Manager sqljcReceive fnc (3.3.54.3.0.100) pid 807116 tid 1 cpid -1 node 0 sec 0 nsec 110546200 probe 100 bytes 12 Data1 (PD_TYPE_UINT,4) unsigned integer: 105 4 data DB2 UDB DRDA Communication Manager sqljcReceive fnc (3.3.54.3.0.1178) pid 807116 tid 1 cpid -1 node 0 sec 0 nsec 110549755 probe 1178 bytes 122 RECEIVE BUFFER(AR): EXCSATRD OBJDSS (ASCII) (EBCDIC) 01234567 89ABCDEF 0123456789ABCDEF 0123456789ABCDEF 0000 0059D04300010053 1443000F115EE5F8 .Y.C...S.C...^.. ..}..........;V8 0010 F1C14BE2E3D3C5C3 F100181404140300 ..K............. 1A.STLEC1....... 0020 0724070007147400 05240F0007144000 .$....t..$....@. .............. . 0030 0700081147D8C4C2 F20014116DE2E3D3 ....G.......m... .....QDB2..._STL 0040 C5C3F14040404040 4040404040000C11 ...@@@@@@@@@@... EC1 ... 0050 5AC4E2D5F0F8F0F1 F5 Z........ ]DSN08015 ACCSECRD OBJDSS (ASCII) (EBCDIC) 01234567 89ABCDEF 0123456789ABCDEF 0123456789ABCDEF 0000 0010D0030002000A 14AC000611A20003 ................ ..}..........s.. 5 data DB2 UDB DRDA Communication Manager sqljcSend fnc (3.3.54.5.0.100) pid 807116 tid 1 cpid -1 node 0 sec 0 nsec 110656806 probe 100 bytes 16 Data1 (PD_TYPE_UINT,8) unsigned integer: 233 < 13. zYdvD>}(TCP/IP ,S) 100 DB2 Connect C'8O 6 data DB2 UDB DRDA Communication Manager sqljcSend fnc (3.3.54.5.0.1177) pid 807116 tid 1 cpid -1 node 0 sec 0 nsec 110659711 probe 1177 bytes 250 SEND BUFFER(AR): SECCHK RQSDSS (ASCII) (EBCDIC) 01234567 89ABCDEF 0123456789ABCDEF 0123456789ABCDEF 0000 003CD04100010036 106E000611A20003 .<.A...6.n...... ..}......>...s.. 0010 00162110E2E3D3C5 C3F1404040404040 ..!.......@@@@@@ ....STLEC1 0020 404040404040000C 11A1D9858799F485 @@@@@@.......... ....Regr4e 0030 A599000A11A09585 A6A39695 ............ vr....newton ACCRDB RQSDSS (ASCII) (EBCDIC) 01234567 89ABCDEF 0123456789ABCDEF 0123456789ABCDEF 0000 00ADD001000200A7 20010006210F2407 ........ ...!.$. ..}....x........ 0010 00172135C7F9F1C1 F0C4F3C14BD7C1F8 ..!5........K... ....G91A0D3A.PA8 0020 F806030221064600 162110E2E3D3C5C3 ....!.F..!...... 8..........STLEC 0030 F140404040404040 4040404040000C11 .@@@@@@@@@@@@... 1 ... 0040 2EE2D8D3F0F9F0F0 F0000D002FD8E3C4 ............/... .SQL09000....QTD 0050 E2D8D3C1E2C30016 00350006119C0333 .........5.....3 SQLASC.......... 0060 0006119D04B00006 119E0333003C2104 ...........3. 7 data DB2 UDB DRDA Communication Manager sqljcReceive fnc (3.3.54.3.0.100) pid 807116 tid 1 cpid -1 node 0 sec 0 nsec 259908001 probe 100 bytes 12 Data1 (PD_TYPE_UINT,4) unsigned integer: 176 8 data DB2 UDB DRDA Communication Manager sqljcReceive fnc (3.3.54.3.0.1178) pid 807116 tid 1 cpid -1 node 0 sec 0 nsec 259911584 probe 1178 bytes 193 RECEIVE BUFFER(AR): SECCHKRM RPYDSS (ASCII) (EBCDIC) 01234567 89ABCDEF 0123456789ABCDEF 0123456789ABCDEF 0000 0015D0420001000F 1219000611490000 ...B.........I.. ..}............. 0010 000511A400 ..... ...u. ACCRDBRM RPYDSS (ASCII) (EBCDIC) 01234567 89ABCDEF 0123456789ABCDEF 0123456789ABCDEF 0000 009BD00200020095 2201000611490000 ........“....I.. ..}....n........ 0010 000D002FD8E3C4E2 D8D3F3F7F0000C11 .../............ ....QTDSQL370... 0020 2EC4E2D5F0F8F0F1 F500160035000611 ............5... .DSN08015....... 0030 9C04B80006119E04 B80006119D04B000 ................ ................ 0040 0C11A0D5C5E6E3D6 D540400006212524 .........@@..!%$ ...NEWTON ..... 0050 34001E244E000624 4C00010014244D00 4..$N..$L....$M. ....+...<.....(. 0060 06244FFFFF000A11 E8091E768301BE00 .$O........v.... ..!.....Y...c... 0070 2221030000000005 68B3B8C7F9F1C1F0 “!......h....... ...........G91A0 0080 C4F3C1D7C1F8F840 4040400603022106 .......@@@@...!. D3APA88 ..... 0090 46000A11E8091E76 831389 F......v... ....Y...c.i 9 data DB2 UDB DRDA Communication Manager sqljcSend fnc (3.3.54.5.0.100) pid 807116 tid 1 cpid -1 node 0 sec 2 nsec 364420503 probe 100 bytes 16 Data1 (PD_TYPE_UINT,8) unsigned integer: 10 < 14. zYdvD>}(TCP/IP ,S)- x Z 5 B JOoO 101 10 data DB2 UDB DRDA Communication Manager sqljcSend fnc (3.3.54.5.0.1177) pid 807116 tid 1 cpid -1 node 0 sec 2 nsec 364440751 probe 1177 bytes 27 SEND BUFFER(AR): RDBCMM RQSDSS (ASCII) (EBCDIC) 01234567 89ABCDEF 0123456789ABCDEF 0123456789ABCDEF 0000 000AD00100010004 200E ........ . ..}....... 11 data DB2 UDB DRDA Communication Manager sqljcReceive fnc (3.3.54.3.0.100) pid 807116 tid 1 cpid -1 node 0 sec 2 nsec 475009631 probe 100 bytes 12 Data1 (PD_TYPE_UINT,4) unsigned integer: 54 12 data DB2 UDB DRDA Communication Manager sqljcReceive fnc (3.3.54.3.0.1178) pid 807116 tid 1 cpid -1 node 0 sec 2 nsec 475014579 probe 1178 bytes 71 RECEIVE BUFFER(AR): ENDUOWRM RPYDSS (ASCII) (EBCDIC) 01234567 89ABCDEF 0123456789ABCDEF 0123456789ABCDEF 0000 002BD05200010025 220C000611490004 .+.R...%“....I.. ..}............. 0010 00162110E2E3D3C5 C3F1404040404040 ..!.......@@@@@@ ....STLEC1 0020 4040404040400005 211501 @@@@@@..!.. ..... SQLCARD OBJDSS (ASCII) (EBCDIC) 01234567 89ABCDEF 0123456789ABCDEF 0123456789ABCDEF 0000 000BD00300010005 2408FF ........$.. ..}........ 13 data DB2 UDB DRDA Communication Manager sqljcSend fnc (3.3.54.5.0.100) pid 807116 tid 1 cpid -1 node 0 sec 5 nsec 721710319 probe 100 bytes 16 Data1 (PD_TYPE_UINT,8) unsigned integer: 126 14 data DB2 UDB DRDA Communication Manager sqljcSend fnc (3.3.54.5.0.1177) pid 807116 tid 1 cpid -1 node 0 sec 5 nsec 721727276 probe 1177 bytes 143 SEND BUFFER(AR): EXCSQLIMM RQSDSS (ASCII) (EBCDIC) 01234567 89ABCDEF 0123456789ABCDEF 0123456789ABCDEF 0000 0053D0510001004D 200A00442113E2E3 .S.Q...M ..D!... ..}....(......ST 0010 D3C5C3F140404040 4040404040404040 ....@@@@@@@@@@@@ LEC1 0020 D5E4D3D3C9C44040 4040404040404040 ......@@@@@@@@@@ NULLID 0030 4040E2D8D3C3F2C6 F0C1404040404040 @@........@@@@@@ SQLC2F0A 0040 4040404041414141 41484C5600CB0005 @@@@AAAAAHLV.... ......<..... 0050 2105F1 !.. ..1 SQLSTT OBJDSS (ASCII) (EBCDIC) 01234567 89ABCDEF 0123456789ABCDEF 0123456789ABCDEF 0000 002BD00300010025 2414000000001B64 .+.....%$......d ..}............. 0010 656C657465206672 6F6D206464637375 elete from ddcsu .%......?_...... 0020 73312E6D79746162 6C65FF s1.mytable. ..._`./.%.. 15 data DB2 UDB DRDA Communication Manager sqljcReceive fnc (3.3.54.3.0.100) pid 807116 tid 1 cpid -1 node 0 sec 5 nsec 832901261 probe 100 bytes 12 Data1 (PD_TYPE_UINT,4) unsigned integer: 102 < 15. zYdvD>}(TCP/IP ,S)- x 102 DB2 Connect C'8O DRDA zYDsx:exE“ ITVvsx“MMSU:exTq!=SE“#B;vks|,;vd5#commit | n8> IBM sMz}]b~qw\m534d510$w%*#ZDv:exGw* d5rXvDa{S IBM sMz}]b~qw}]b\m53PSU=D#||,“a x$w%*&p{“”(ENDUOWRM),|8>10$w%*Q-ax# 16 data DB2 UDB DRDA Communication Manager sqljcReceive fnc (3.3.54.3.0.1178) pid 807116 tid 1 cpid -1 node 0 sec 5 nsec 832906528 probe 1178 bytes 119 RECEIVE BUFFER(AR): SQLCARD OBJDSS (ASCII) (EBCDIC) 01234567 89ABCDEF 0123456789ABCDEF 0123456789ABCDEF 0000 0066D00300010060 240800FFFFFF3434 .f.....`$.....44 ..}....-........ 0010 3237303444534E58 4F544C2000FFFFFE 2704DSNXOTL .... ......+.!.<..... 0020 0C00000000000000 00FFFFFFFF000000 ................ ................ 0030 0000000000572020 2057202020202020 .....W W ................ 0040 001053544C454331 2020202020202020 ..STLEC1 ....<........... 0050 2020000F44444353 5553312E4D595441 ..DDCSUS1.MYTA ............(... 0060 424C450000FF BLE... .<.... 17 data DB2 UDB DRDA Communication Manager sqljcSend fnc (3.3.54.5.0.100) pid 807116 tid 1 cpid -1 node 0 sec 5 nsec 833156953 probe 100 bytes 16 Data1 (PD_TYPE_UINT,8) unsigned integer: 10 18 data DB2 UDB DRDA Communication Manager sqljcSend fnc (3.3.54.5.0.1177) pid 807116 tid 1 cpid -1 node 0 sec 5 nsec 833159843 probe 1177 bytes 27 SEND BUFFER(AR): RDBRLLBCK RQSDSS (ASCII) (EBCDIC) 01234567 89ABCDEF 0123456789ABCDEF 0123456789ABCDEF 0000 000AD00100010004 200F ........ . ..}....... 19 data DB2 UDB DRDA Communication Manager sqljcReceive fnc (3.3.54.3.0.100) pid 807116 tid 1 cpid -1 node 0 sec 5 nsec 943302832 probe 100 bytes 12 Data1 (PD_TYPE_UINT,4) unsigned integer: 54 20 data DB2 UDB DRDA Communication Manager sqljcReceive fnc (3.3.54.3.0.1178) pid 807116 tid 1 cpid -1 node 0 sec 5 nsec 943306288 probe 1178 bytes 71 RECEIVE BUFFER(AR): ENDUOWRM RPYDSS (ASCII) (EBCDIC) 01234567 89ABCDEF 0123456789ABCDEF 0123456789ABCDEF 0000 002BD05200010025 220C000611490004 .+.R...%“....I.. ..}............. 0010 00162110E2E3D3C5 C3F1404040404040 ..!.......@@@@@@ ....STLEC1 0020 4040404040400005 211502 @@@@@@..!.. ..... SQLCARD OBJDSS (ASCII) (EBCDIC) 01234567 89ABCDEF 0123456789ABCDEF 0123456789ABCDEF 0000 000BD00300010005 2408FF ........$.. ..}........ < 16. zYdvD>}(TCP/IP ,S)- x Z 5 B JOoO 103 ZK>}P,zYu? 12 |,;vUD SQLCA,IsS X’FF’ D DDM zkc X’2408’ 8>#UD SQLCA(X’2408FF’)m>I&(SQLCODE 0)# Z 100 3D< 13 ZzYu? 16 PT>K|,ms SQLCA DSU:exD>}# 104 DB2 Connect C'8O Z 6 B {“ DB2 Connect #{Jb >wbP>9C DB2 Connect 1v=D#{D,SJb“4#Z?VivB,<*z a): v {“EMkC{“`X*D5Xk(rX(Z-iD5Xk)DiO#?v{“M 5XkiO<_P@“Djb,b)jbGH4{“E,Y45Xk4ErD# v “4,(#ICy>{“PmDq=# v (iDbv=8,8>msDI\-r#Z3)ivB,I\aa)`V(iDb v=8# SQL0965 r SQL0969 “4 I\aS DB2 IBM i f“DB2 z/OS fM DB2 ~qw VM M VSE f“v {“ SQL0965 M SQL0969 0s?;,D5Xk# 1zv=NNdP;v{“1,&CZ“vC{“D}]b~qwz7DD5 PiR-< SQL zk# bv=8 ;\*;S IBM sMz}]bSUD SQL zk#y]mszk4|}CJ b,;sXBa;'\D|n# SQL5043N “4 4\I&t/T;vr`v(E-iD'V#+G,QI&t/KKD}]b \mw&\# DB2 Connect ~qwOI\4t/ TCP/IP -i#H0I\Q-PI&DM' z,S# g{ diaglevel = 4,G4 db2diag U>D~I\|,`FDu?,}g: 2001-05-30-14.09.55.321092 Instance:svtdbm5 Node:000 PID:10296(db2tcpcm) Appid:none common_communication sqlcctcpconnmgr_child Probe:46 DIA3205E Z TCP/IP services D~PdCDR TCP/IP ~qw'VyhDWSVX7“30090”};m;xL9C# bv=8 K/fG;V“4,|m>d16LM'zD~qwD DB2 Connect Z&m; vr`vM'z(E-i1v=Jb#b)-iITG TCP/IP Md{-i,{ “(#a8v* DB2 Connect (eD3v(E-i4}7dC# -r(#G4(e DB2COMM E*D~d?,r_Cd?4}7(e#CJb (#G DB2COMM d?k}]b\mwdCP(eD{F(}g,svcename r nname).d;%dDa{# ;VI\DivGH0PI&D,S,;sC= SQL5043 ms{“,+4|D NNdC#9C TCP/IP -i1,16L53r*3)-rxl#U9K,S, MI\a“zbViv#“zbViv1,M'zOI\T;T>,SfZ, (}“vBfyT>D|n,MI4-,S,x^kx;=DYw# © Copyright IBM Corp. 1993, 2010 105 k DB2 Connect ~qw`,SD3vM'z\PI\Z TCP/IP KZOTPd z#Zk DB2 Connect ~qw`,SD?;(M'zO,dkBP|n: db2 terminate db2stop SQL30020 “4 SQL30020N 4P'\,-rG“V<=-ims”,Cms+0lsx|nM SQL odDI&4P# bv=8 v=Kms1,&Ck~qPD*5#k~qPD*5.0kHKP db2support |n# SQL30060 “4 SQL30060N ″″ ;P4PYw ″″ DX(# bv=8 ,SA DB2 z/OS f1,4}7|B(E}]b(CDB)m# SQL30061 “4 ,SAmsD IBM sMz}]b~qw;C - R;=?j}]b# bv=8 I\Z DCS ? remote server db2 catalog dcs database as db2 catalog database as at authentication server *,SA}]b,z&C“v: db2 connect to user using xP5Xk 79 D SQL30081N “4 SQL30081N Qlb=(Ems# y9CD(E-i:“TCP/IP”# y9CD(E API:“SOCKETS”# ;C lb=msD;C:“”# msD (E&\: “,S”#X(Z-iDmszk:“79”““*”M“*”# SQLSTATE=08001 bv=8 16LM'z4\k DB2 Connect ~qw,S1,MI\“zKms#S DB2 Connect ~qw,SA IBM sMz}]b~qw1,2I\“zKms# 106 DB2 Connect C'8O 1. Z DB2 Connect ~qwO,DB2COMM E*D~d?I\hCC;}7#l iKd?#}g,1Z AIX OKP DB2 s5~qwf1,|n db2set db2comm=tcpip &CvVZ sqllib/db2profile P# 2. IBM }]~qwM'z P8(D TCP/IP ~q{FMKZEI\k DB2 Connect ~qwP8(D;%d#ZTO=VzwPi$ TCP/IP services D~PDwvu?# 3. liZ DB2 Connect ~qwOGqt/K DB2#9CTB|n+“}]b \mwdC”diaglevel hC* 4: db2 update dbm cfg using diaglevel 4 Z#9“XBt/ DB2 s,i4 db2diag U>D~,TcliGqQ-t /K DB2 TCP/IP (E#z&C4=kBPE“`FDdv: 2001-02-03-12.41.04.861119 Instance:svtdbm2 Node:00 PID:86496(db2sysc) Appid:none common_communication sqlcctcp_start_listen Probe:80 DIA3000I “TCPIP”-i'VQI&t/# xPX(Z-iDmszk 10032 D SQL30081N “4 SQL30081N Qlb=(Ems# y9CD(E-i:“TCP/IP”# y9CD(E API:“SOCKETS”# ;C lb=msD;C:“9.21.85.159”# lb= msD(E&\: ““M”#X(Z-iDmszk:“10032”““*“, “*“. SQLSTATE=08001 bv=8 1TLr – LL v DB2 i. – PDF D~(IBX) – PDF D~(Z DB2 PDF DVD P) – !“fi. v |nPoz – |noz – {“oz “:DB2 E“PDwbD|B5JH PDF i.r2=4i.D|B5J_#*q!n BE“,k20ICDD5|B,r_ND ibm.com OD DB2 E“PD# ITZ_CJ ibm.com ODd{ DB2 c:http://www.ibm.com/software/ data/sw-library/# D54! RGG#XSzT DB2 D5D4!#g{zkMgNDF DB2 D5av(i,k+ gSJ~“MA db2docs@ca.ibm.com# DB2 D5!iaDAzDyP4!,+;\1 Sp4z#k!I\a)_eD>},byRGE\|CXKbzyXDDJb#g {z*a)PX_ewbrozD~D4!,kSOjbM URL# k;*CTOgSJ~X7k DB2 M''Vz9*5#g{zv=D5;\bvD DB2 9.7 VaD“Df>M-kf># !\b)mj6i.P!“f,+I\4ZzyZzRrXxa)# ?N|BVa1,m%EDVaDnBf># “:DB2 E“PDD|B5JH PDF r2=4i.D|B5J_# © Copyright IBM Corp. 1993, 2010 109 m 18. DB2 c,x7*:http://www.ibm.com/shop/publications/order#XkH!qz R“XxroTE\CJvfo):E“,;sY4UkTzyZ;CD):8> E“xP):# v *S1XD IBM zm&):!“fD DB2 i.: 1. SBPdP;v Web >cR=1Xzm&D*5E“: – IBM +r*5K?<,x7* www.ibm.com/planetwide# – IBM vfo Web >c,x7* http://www.ibm.com/shop/publications/order# XkH!qzR“XxroTE\CJT&zDyZXDvfow3#ZK 3fPCJ“XZK>c”4S# 2. kZBg15wzk): DB2 vfo# 3. krz1XDzma)k*):Di.Di{MiE#PXi{MiEDE“, kNDZ 109 3D:2=4r PDF q=D DB2 SQL 4,oz DB2 z7kTI\d1 SQL oda{Du~5X SQLSTATE 5#SQLSTATE oz 5w SQL 4,M SQL 4,`zkD,e# *t/ SQL 4,oz,kr*|nP&mw“dk: ? sqlstate or ? class code dP,sqlstate m>P'D 5 ; SQL 4,,class code m>C SQL 4,D0 2 ;# }g,? 08003 T> 08003 SQL 4,Doz,x ?08T> 08 `zkDoz# CJ;,f>D DB2 E“PD TZ DB2 f> 9.8 wb,DB2 E“PD URL * http://publib.boulder.ibm.com/infocenter/ db2luw/v9r8/# TZ DB2 f> 9.7 wb,DB2 E“PD URL *:http://publib.boulder.ibm.com/ infocenter/db2luw/v9r7/# TZ DB2 f> 9.5 wb,DB2 E“PD URL *:http://publib.boulder.ibm.com/ infocenter/db2luw/v9r5# TZ DB2 f> 9.1 wb,DB2 E“PD URL *:http://publib.boulder.ibm.com/ infocenter/db2luw/v9/# TZ DB2 f> 8 wb,k*A DB2 E“PD URL:http://publib.boulder.ibm.com/ infocenter/db2luw/v8/# Z DB2 E“PDPTzDW!oTT>wb DB2 E“PD“TTzZ/@wW!nP8(DoTT>wb#g{4a)wbDW! oT-kf>,G4 DB2 E“PD+T>CwbD“Df# v *Z Internet Explorer /@wPTzDW!oTT>wb: 1. Z Internet Explorer P,%w$_ *> Internet !n *> oT... 4%#“oT W!n”0Zr*# 2. 7#zDW!oT;8(*oTPmPDZ;vu?# – *+BoTmSAPm,k%wmS... 4%# “:mSoT“;\#$Fcz_PTW!oTT>wbyhDVe# – *+oTFAPm%?,k!qCoT“%wOF4%1=CoTI*oT PmPDZ;vu?# 3. “B3fTcTW!oTT> DB2 E“PD# v *Z Firefox r Mozilla /@wPTW!oTT>wb: 1. Z$_ *> !n *> _6T0rPDoT?VP!q4%#“oT”fe+T>Z “W!n”0ZP# 2. 7#zDW!oT;8(*oTPmPDZ;vu?# =< A. DB2 DB2 E“PD# Z3)/@wMYw53iOO,I\9Xk+Yw53DxrhC|D*z!qD oT73MoT# |B20ZzDFczrZ?x~qwOD DB2 E“PD >X20D DB2 E“PDXk(ZxP|B# XkQ20 DB2 f> 9.7 E“PD#PXj8E“,kND620 DB2 ~qw7P D“9C DB2 20r<420 DB2 E“PD”wb#yPJCZ20E“PDDHv u~M^F,yJCZ|BE“PD# IT/rV/|BVP DB2 E“PD: v T/|B - |BVPE“PD&\MoT#T/|BD;vEcGZ|BZd,E “PD;ICD1dnL#mb,T/|BIhC*w*(ZKPDd{z&mw 5D;?VKP# v V/|B - &CZ|B}LZd*mS&\roT19C#}g,g{>XE“P Dnu20DG“oM(of,xVZ9*20Bof;G4V/|B+20Bo f,“|BVPE“PDD&\MoT#+G,V/|B*szV/#9“|BM XBt/E“PD#Z{v|B}LZdE“PD;IC# Kwbj85wKT/|BD}L#PXV/|BD8>E“,kND“V/|B20 ZzDFczrZ?x~qwOD DB2 E“PD”wb# *T/|B20ZzDFczrZ?x~qwOD DB2 E“PD: 1. Z Linux Yw53O, a. /@AE“PDD20;C#1!ivB,DB2 E“PD20Z /opt/ibm/ db2ic/V9.7 ?: ic-update 2. Z Windows Yw53O, a. r*|n0Z# b. /@AE“PDD20;C#1!ivB,DB2 E“PD20Z \IBM\DB2 Information Center\Version 9.7 ? m> Program Files ?BDT0|BsDw b#g{E“PD|B;IC,G4aZU>PmS{“#U>D~;Z doc\eclipse\ configuration ?D~{FGfzzID`E#}g,1239053440785.log# V/|B20ZzDFczrZ?x~qwOD DB2 E“PD g{Q-Z>X20K DB2 E“PD,G4zITS IBM q!D5|B“20# V/|BZ>X20D DB2 E“PD*sz: 1. #9FczOD DB2 E“PD,;sT@“==XBt/E“PD#g{T@“= =KPE“PD,G4xgODd{C'+^(CJE“PD,rxzIT&C| B#DB2 E“PDD$w>f>\GT@“==KP# 2. 9C“|B”&\?~4i4ICD|B#g{PzXk20D|B,G4k9C“ |B”&\?~4q!“20b)|B# “:g{zD73*sZ;(4,SArXxDzwO20 DB2 E“PD|B,G 4(}9C;(Q,SArXx“PQ20D DB2 E“PDDzw+|B>c5q A>XD~53#g{xgPPm`C'+20D5|B,G4IT(}Z>X2 *|B>cFw5q“*|B>c4(zm4uL?vK4P|Byh*D1d# g{a)K|B|,k9C“|B”&\?~4q!b)|B|#+G,;PZ%z ==BE\9C“|B”&\?~# 3. #9@“E“PD,;sZFczOXBt/ DB2 E“PD# “:Z Windows 2008“Windows Vista M|_f>O,TsP>ZK?VD|nXk w*\m1KP#*r*_P+f\m1X(D|na>{r Program Files ?: help_start 531! Web /@w+r*TT>@“E“PD# 3. %w|B4%( )#(XkZ/@wPtC JavaScript™#) ZE“PDDR_f eO,%wiR|B# +T>VPD5D|BPm# 4. *t/20xL,kliz*20D!n,;s%w20|B# 5. Z20xLjIs,k%wjI# 6. *#9@“E“PD,k4PBPYw: v Z Windows O,/@A20?: help_end “:help_end E>|,2+X#99C help_start E>t/DxLyhD|n# ;*9CNNd{=(4#9 help_start E># 7. XBt/ DB2 E“PD# v Z Windows O,%w*< → XFfe → \m$_ → ~q#R|%w DB2 E “PD~q,“!qt/# v Z Linux O,dkTB|n: /etc/init.d/db2icdv97 start |BsD DB2 E“PD+T>BDT0|BsDwb# DB2 LL DB2 LLozzKb DB2 z7Dwv=f#b)NLa)Kp=8>E“# *<.0 ISE“PDi4 XHTML fDLL:http://publib.boulder.ibm.com/infocenter/db2help/ # 3)NL9CKy>}]rzk#PXdX(NqDNNHvu~Dhv,kNDL L# DB2 LL *i4LL,k%wjb# 6pureXML 8O7PD“pureXML®” hC DB2 }]bTf“ XML }]T0T>z XML }]f“4Py>Yw# 6Visual Explain LL7PD“Visual Explain” 9C Visual Explain 4Vv“E/Mw{ SQL odTq!|CDT\# 116 DB2 Connect C'8O DB2 JOoOE“ a)K\`JOoOMJb7(E“Tozz9C DB2 }]bz7# DB2 D5 JOoOE“IZ 6JOoOMw{}]bT\7 r DB2 E“PDD“}] by!”?VPR=#IZC&R=PXgN9C DB2 oO$_M5CLr4 tkMRvJbDE““3)n#{JbDbv=8T0PXgNbv9C DB2 }]bz71I\v=DJbD(i# DB2 c g{zv=KJb“Rk*q!iRI\D-rMbv=8Doz,kND DB2 c#C“c_P8rnB DB2 vfo“< u5w“Z(LrVv(f(APAR rms^))“^)|Md{J4D4S# IQwK*6b“iRJbDI\bv=8# kCJ DB2 c:http://www.ibm.com/software/data/db2/support/ db2_9/# unMu~ g{{OTBunMu~,G4Zhz9Cb)vfoDmI(# vK9C:;*#tyPD(P(yw,zMIT*vK“GL59C4Fb)vf o#4- IBM w7,b,z;ITV““9>rFwb)vfordPNN?VD] ow7# L59C:;*#tyPD(P(yw,zMITvZs5Z4F“V“M9>b) vfo#4- IBM w7,b,z;ITFwb)vfoD]ow7,r_ZzDs5 b?4F“V“r9>b)vfordPDNN?V# }G>mI(Pw7Zh,qr;CZhTb)vfordP|,DNNE““} ]“m~rd{*6z(DNNmI(“mI$r({,^[Gw>D9G5,D# 19Cb)vfop&K IBM D{f,r_y] IBM Df(,4}7qXOv8< 5w1,G4 IBM #tTwv(7z>DZhDmI(D({# ;Pzj+q-yPJCD(IM(f,|(yPD@zvZ(IM(f,zEIT BX“vZrYvZCE“# IBM Tb)vfoDZ];wNN#$#b)vfo“4V4”a),;=PNNV`D (^[Gw>D9G5,D)#$,|(+;^Z5,DXZJzMJCZ3VX( C>D#$# =< A. DB2 E“G*Z@za)Dz7M~q`4D#PXG IBM z7DE“GyZWNvf KD51DIqE“Raf1|B# IBM I\Zd{zRrXx;a)>D5PV[Dz7“~qr&\XT#PXz10 yZxrDz7M~qDE“,krz1XD IBM zmI/#NNT IBM z7“L rr~qD}C“GbZw>r5>;\9C IBM Dz7“Lrr~q#;*;V8 IBM D*6z(,NN,H&\Dz7“Lrr~q,I\Q5Pr}Zjkk>D5Z]PXDwn({#a)>D5“4ZhC '9Cb)({DNNmI#zITCif==+mIi/Dy: IBM Director of Licensing IBM Corporation North Castle Drive Armonk, NY 10504-1785 U.S.A. PX+VZV{/ (DBCS) E“DmIi/,kkzyZzRrXxD IBM *6z( ?E*5,rCif==+i/Dy: Intellectual Property Licensing Legal and Intellectual Property Law IBM Japan, Ltd. 1623-14, Shimotsuruma, Yamato-shi Kanagawa 242-8502 Japan >un;JC“zrNNbyDunk1X(I;;BDzRrXx:International Busi- ness Machines Corporation“4V4”a)>vfo,;=PNNV`D(^[Gw>D9 G5,D)#$,|(+;^Z5,DPXGV(“JzMJCZ3VX(C>D# $#3)zRrXxZ3);WP;Jmb}w>r5,D#$#rK>unI\; JCZz# >E“PI\|,JODBf>P#IBM ITf1T>JOPhvDz7M/rLrxPD xM/r|D,x;mP(*# >E“PTG IBM Web >cDNN}C<;G*K=cp{Ea)D,;TNN== d1TG) Web >cD#$#G) Web >cPDJO;GK IBM z7JOD;? V,9CG) Web >cx4DgU+IzTPP## IBM IT4|O*J1DNN==9CrV“zya)DNNE“x^kTzP#NN pN# © Copyright IBM Corp. 1993, 2010 119 >LrD;mI=g{*KbPXLrDE“To=gB?D:(i) JmZ@“4(DL rMd{Lr(|(>Lr).dxPE“;;,T0 (ii) JmTQ-;;DE“xP `%9C,kkBPX7*5: IBM Canada Limited U59/3600 3600 Steeles Avenue East Markham, Ontario L3R 9Z7 CANADA ;*qXJ1DunMu~,|(3)iNBD;(}?D6Q,JOPhvDmILr0dyPICDmIJOyI IBM @] IBM M'-i“IBM zJm~mI-irNN,H-iPDuna)# K&|,DNNT\}]D5DC'&1i$dX(73DJC}]# f0G IBM z7DE“ISb)z7D)&L“dvf5wrd{I+*qCDJO Pq!#IBM ;PTb)z7xPbT,2^(7OdT\D+7T“f]TrNNd {XZG IBM z7Dyw#PXG IBM z7T\DJb&1rb)z7D)&La v# yPXZ IBM 44=rrbrDywK?jMb8xQ# >E“I\|,ZU#5qYwP9CD}]M(fD>}#*K!I\j{X5w b)>},>}PI\a|(vK“+>“7FMz7D{F#yPb){FE“|(4oTN=Dy>&CLr,b)y>5w;,Yw=(OD`L=(# g{G*4UZ`4y>LrDYw=(OD&CLr`LSZ (API) xP&CLrD *““9C“-zrV“,zITNNN=Tb)y>LrxP4F“^D“V“, x^kr IBM 6Q#b)>}“4ZyPu~Bw+fbT#rK,IBM ;\##r 5>b)LrDI?T“I,$Tr&\#Ky>Lr“4V4”a),R;=PNN V`D#$#TZ9CKy>Lry}pDNNp5,IBM +;P#pN# 2b)y>LrD?]=4rdNN?VrNN\zz7,D{F)(j]). K?VzkGy] IBM +>Dy>Lr\zv4D#© Copyright IBM Corp. (dkj]). All rights reserved. 120 DB2 Connect C'8O Lj IBM“IBM UjM ibm.com® G International Business Machines Corp. Z+r6'm `\=xrZDLjr“aLj#d{z7M~q{FI\G IBM rd{+>DLj# Web >c www.ibm.com/legal/copytrade.shtml OD“f(MLjE“”Pa)K IBM L jDnBPm# BPuoGd{+>DLjr“aLj v Linux G Linus Torvalds Z@zM/rd{zRrXxD“aLj# v Java MyPyZ Java DLjMUjG Sun Microsystems,Inc. Z@zM/rd{zR rXxDLj# v UNIX G The Open Group Z@zMd{zRrXxD“aLj# v Intel“Intel Uj“Intel Inside®“Intel Inside Uj“Intel® Centrino®“Intel Centrino U j“Celeron®“Intel® Xeon®“Intel SpeedStep®“Itanium® M Pentium® G Intel +> rdS+>Z@zMd{zRrXxDLjr“aLj# v Microsoft“Windows“Windows NT® M Windows UjG Microsoft Corporation Z @zM/rd{zRrXxDLj# d{+>“z7r~q{FI\Gd{+>DLjr~qjG# =< B. yw 121 122 DB2 Connect C'8O w} [A] 2+T 35 DB2 Connect 29 DB2 z/OS fPD)9zk'V 35 GRANT od 35 Kerberos 34 TCP/IP 35 [B] oz dCoT 113 SQL od 113 s( Lr| DB2 Connect 36 (^ 36 5CLr DB2 Connect 36 &CLr 36 s(Pm DB2 Connect 36 `kV{/j6(CCSID) +r'V j8E“ 22 jG SQLCODE 44 [C] N} ?< 26 V{. 27 PRDID 97 SYSPLEX 22 N}V{. :E 22 =v:E 22 _T@@U> 55 bT `>c|B 40 i/i a_ DB2 Connect }]+dJ 85 Lr| wz}]b~qw 36 System i }]b~qw 36 0ZuE RFC-1323 )9 86 f“}L Ev 14 ms JOoO 91 ms{“ DB2 Connect 105 [D] wC6SZ(CLI) Ev 88 IE,S 29 &CLr CURRENTPACKAGESET CLI/ODBC dCN} 35 w{ N} agentpri 81 dir_cache 81 maxagents 81 MAXDARI 81 numdb 81 rqrioblk 81 xg 83 wz}]b 83 DB2 Connect 67 DB2 z/OS f 85 ): DB2 i. 112 /, SQL &m0l 3 T\ c|B bT 40 V<=$w%* (DUOW) 39 XFPD 40 tC 39 ,=c\mw 41 [E] nbi/i Ev 85 EXTRA BLOCKS SRV N} 85 © Copyright IBM Corp. 1993, 2010 123 [F] “M:ex zY}] 96 =8 TCP/IP 2+T 35 V<=$w%* `>c|B 39 Ev 4 =WNd5 39 \'VD~qw 39 V<=X5}]be5a9 (DRDA) Ev 4 DB2 Connect 5 V<=X5}]be5a9(DRDA) }]CJ 5 V<=ks Ev 7 V<=}]\m (DDM) V<=X5}]be5a9 (DRDA) 5 V<=}]\m(DDM) db2drdat dv 96 Vi }] 71 Vx.xF}]`M 87 !c}]`M *; 87 {E?j{F xVs!4 21 ~qw &CLr DB2 Connect 14 [G] _ICT DB2 Connect 63 _Y:fDX7Pm 80 q=/}]TsZ]e5a9 (FDOCA) 5 zY dvD~ 96, 97 dvD~y> 99 DB2 93, 94, 95 DB2 Connect 93 DB2 Connect k~qw.dD}] 96 DRDA :exE“ 103 bM 96 y> 99 zY5CLr(db2drdat) 96 |B }]b?< 21 DB2 E“PD 114, 115 +2xXSZ (CGI) `L V^T 11 Ec 11 $_ Zf9Civ 67 T\ 67 CPU 9Civ 67 $wm ?<(F 26 $w%* (UOW) V<= 39 Ev 4 6L 6 JOoO zY 9C db2trc |n4q! 93 DRDA 99, 103 LL 117 *zE“ 117 ,S 91, 92 U/E“ 91 T\ 84 DB2 Connect 91, 105 XZ>i v [H] KDD~ Jb7( 93 [J] `S ,S 48 Windows T\`Sw 49 !5(/ DB2 z/OS f 55 +zY*“AD~ Ev 94 LL JOoO 117 Pm 116 Jb7( 117 Visual Explain 116 ;;~qwtT|n 97 Zc {F Zc?<5 21 ?<(F$wm 26 53}]b5 21 ?< |B 21 5 21 ax$w%*&p{“(ENDUOWRM) 97 xL4,5CLr |n 93, 97 /(Ts i4 61 124 DB2 Connect C'8O /(\a i4 60 2, SQL &m0l 3 T\ 71 v_'V53(DSS) 96 [K] IE,S (} CLI/ODBC P;C' 31 CLI/ODBC 30 DB2 Connect 29 IEOBD CLI/ODBC 'V 30 DB2 Connect 'V 29 M'z}]bp{ 51 M'z&CLr (EV4 64 M'zT/XB7I 20 64 ,S'\ 65 j8E“ 64 XFPD `>c|B 40 is! DB2 Connect 81 [L] *O}]b V<=ks 7 ,S XB(“ 1S,SAwz 8 DB2 Connect s5f 10 \m 73 OC Ev 73 ,S/Pw 75 Ec 75 '\ M'zT/XB7I 65 1S,Swz 8 1S,S IBM sMz 8 1S,S IBM i 9 1S,S System z wz 9 DB2 Connect s5f 10 ,SX Ev 73 ,S\m 73 ,S/PwHO 78 ,S~qw DB2 Connect s5f 10 ,S/Pw Ev 73, 75 $wLrzmxL 75 ,SXHO 78 ,S\m 73 DB2 Connect 79 =WNd5 tC 39 TCP/IP ,S9CDY,=KZ 21 d5|n 97 [M] \k |D z/OS 35 |n d5 97 ACCRDB 97 ACCRDBRM 97 ACCSEC 97 db2drdat Ev 96 db2trc q=/zYD~ 95 q!zY 93 EXCSAT 97 EXCSATRD 97 GET SNAPSHOT Ev 49 SECCHK 97 |nP&mw(CLP) T\ 71 SQL od 3 ?j}]b {F 22, 26 ?< (F 26 53}]b |B 21 5 21 ?<_Y:f'VdCN} DB2 Connect w{ 81 [N] Zf 9Civ$_ 67 [P] dC \k|D 35 wz,S 8 w} 125 dCN} agentpri 81 dir_cache 81 MAXDARI 81 max_coordagents Ev 73 j8E“ 75 numdb 81 num_initagents 73, 75 num_poolagents 73, 75 rqrioblk 81 TCP_KEEPALIVE 65 dC`>c|Br< 40 ?1 Bq 67 T\ 67 [Q] t/ DB2 z/OS fKP4v`Sw 56 (^ s( 36 [R] UZ 1x'V 22 U> _T@@ 55 [S] yw 119 1x Ev 22 5CLr s( 36 zY 96 }]b53`Sw 3 DB2 Connect \m 3 db2drdat 96 ddcspkgn 36 ps(xL4,) 93, 97 >} ,S/Pw 75 XA /Pw 75 Bq `>c|B 4, 39 V<= 39 $w%* (UOW) 4 =WNd5 4 Bq&m`Sw 17 I“nO DB2 Connect 42 Bq (x) LB? DB2 Connect 67 DB2 Connect s5f 17 XA V<=&CLr 42 Bq&m`Sw `>c|B 39 >} 17 DB2 Connect 17 OLTP 17 Tuxedo 17 i. ): 112 }] +d HJ 67, 87 T\ 87 Zwzk$w>.d 42 Vi 71 w DB2 Connect 5, 67 4 7 }]b p{ ?<(F$wm 26 53}]b?< 21 w{ 83 Viks 71 {F ?<(F$wm 26 53}]b?< 21 DCS ?< 22 RDBNAM Ts 97 T\$_ 67 wz 2 }]b,S~q (DCS) ?< |Bu? 21 }]b,S~q(DCS)?< 5 22 }]b?< `vu? 27 |B 21 Zc 21 }]b,S~q (DCS) 21 }]bks *T\xPVi 71 }]b53`Sw Ev 3 6LM'z 48 }]`M Vx.xF 87 !c wz}]*; 87 9u.xF 87 *; T\'{ 87 126 DB2 Connect C'8O }]`M (x) V{ 87 CHAR 87 INTEGER wz}]*; 87 VARCHAR Ev 87 +r CCSID 'V BIDI N} 22 [T] unMu~ vfo 117 #9 DB2 z/OS fKP4v`Sw 56 (E V4 64 ,=c\mw(SPM) =8 41 dCN} 1!5 41 LB? Bq 67 [W] xg w{ 83 }]+dJ 87 T\$_ 67 =J _-DT\ 71 D5 Ev 109 9CunMu~ 117 !“f 109 PDF D~ 109 Jb7( LL 117 ICDE“ 117 ,S 91 ,Ss 92 oO$_ Ev 93 [X] 53}]b?< |B 21 5 21 534, GET SNAPSHOT |n 49 53J4 yC 84 l&1d DB2 Connect 67 r< `>c|B 40 ENX5 DB2 Connect 29 T\ ,SX 78 ,S/Pw 78 |nP&mw(CLP)0l 71 xg2~ 87 53J4 84 &CLrhF 71 DB2 Connect w{ 67 Ev 67 JOoO 84 vs+dJ 85 ODBC CJ 70 z/OS 85 [Y] 9u.xF}]`M 87 3fwHis! 81 F/}] DB2 Connect 42 }<}]/(bootstrap data set,BSDS)N} z/OS 21 }C (e`v}]bu? 27 &CLr s( 36 f“}L 71 4O SQL 71 hF 71 T\ &CLrhF 71 Web DB2 Connect 11 &CLr~qw DB2 Connect 14 DRDA (e 5 &CLr*“ &CLrhF 71 IBM }]~qw}/Lr| 8 ODBC 8 &CLr{F`S*X 51 &CLrksw (AR) DRDA (e 5 &CLrksw(AR) N} 26 2~ xgT\ 87 6L$w%* Ev 6 w} 127 6L$w%* (x) >} 6 Xw 6 KP4v`Sw DB2 z/OS f 55 [Z] oOE“ Ev 93 yC 53J4 84 F(y< T\ 67 wz}]b ,S :Xyb 63 _ICT 63 9C DB2 Connect vKf4CJ 8 *; wz 87 J4CJXFh)(RACF) authentication 35 V{}]m>e5a9 (CDRA) 5 V{}]`M 87 [O53 N} 22 :Xyb 80 dC*s 81 ]m 80 9C 80 EH6E“ 80 DB2 Connect 'V 79 System z 80 A ACCRDB |n 97 ACCRDBRM |n 97 ACCSEC |n 97 agentpri }]b\mwdCN} 81 AS ?j}]b{F 22 ATOMIC 4O SQL Z DB2 Connect P;\'V 71 authentication 26 Ev 33 `M 1!5 33 CLIENT 33, 35 DATA_ENCRYPT 33 KERBEROS 33 SERVER 33 SERVER_ENCRYPT 33 SERVER_ENCRYPT_AES 33 53}]b?< 21 authentication (x) i$ 33 DB2 Connect 35 REVOKE od 35 B BINDADD (^ DB2 Connect 36 C CGI(+2xXSZ)`L 11 CHAR }]`M j8E“ 87 CLIENT O$`M DB2 Connect 33 COMMIT od 2,s( 71 CPU T\$_ 67 CREATE IN COLLECTION NULLID (^ 36 CURRENTPACKAGESET CLI/ODBC X|V 35 D D(O*,S)N} 22 DATA_ENCRYPT O$`M 33 DB2 E“PD f> 113 |B 114, 115 oT 113 DB2 Connect 2+T 29 z7 1 sMz'V 8 Ev 1 \m5CLr 3 ,S~qw=8 8 ,S/Pw 79 dC IBM sMz 41 IBM Power Systems 41 System z 41 s5f {O XA DBq\mw 41 ,S~qw 10 Bq&m`Sw 17 Java &CLr~qw 13 Web ~qw 14 Web &CLr 11 F/}] 42 v?&\ &\ 1 wz'V 8 128 DB2 Connect C'8O DB2 Connect (x) [O53'V 79 System i 'V 8 DB2 z/OS f 2+T 35 Zc?<5 21 KP4v`Sw Ev 55 (iDYw 57 /(Ts 61 /(\a 60 t/ 56 “B 56 #9 56 DYNAMICRULES (BIND) !n 35 db2drdat |n dvD~ 96 db2trc |n Ev 93 q=/zYdv 95 *“zYdv 94 DCS(}]b,S~q)?< kND}]b,S~q(DCS)?< 22 dcs1ari.map D~ 45 dcs1dsn.map D~ 45 dcs1qsq.map D~ 45 ddcs400.lst D~ 36 ddcsmvs.lst D~ 36 ddcstrc 5CLr 97 ddcsvm.lst D~ 36 ddcsvse.lst D~ 36 DESCRIBE od 4O SQL od 71 PREPARE odDT\ 71 dir_cache N} 81 E EXCSAT |n 97 EXCSATRD |n 97 EXECUTE IMMEDIATE od &CLrhF 71 export 5CLr Zwzk$w>.d+M}] 42 EXTNAM Ts 97 F FOR FETCH ONLY Sd SELECT od 71 FORCE |n 51 G GET SNAPSHOT |n Ev 49 I IBM WebSphere Ev 12 import 5CLr ZwzM$w>.d+M}] 42 InfoSphere Federation Server Ev 4 INTEGER }]`M wz}]*; 87 INTERRUPT_ENABLED(O*,S)N} 22 J Java &CLr~qw API 13 DB2 Connect 13 JDBC 13 SQLJ 13 K Kerberos O$-i DB2 Connect 33 OS/390 34 z/OS 34 L LIST DCS APPLICATIONS |n dv 51 LOCALDATE N} 22 M maxagents }]b\mwdCN} ;Fv 81 max_coordagents }]b\mwdCN} Ev 73 j8E“ 75 Microsoft Windows &CLr 8 N NOMAP N} O* SQL 3d 45 DCS ? 113 COMMIT 71 DB2 Connect 3 DESCRIBE 71 EXECUTE IMMEDIATE 71 PREPARE 71 ROLLBACK 71 SELECT 71 SELECT D FOR FETCH ONLY Sd 71 SQL0965 mszk 105 SQL0969 mszk 105 SQL30020 mszk 105 SQL30060 mszk 105 SQL30061 mszk 105 SQL30073 mszk 105 SQL30081N mszk 105 SQL30082 mszk 105 SQL5043N mszk 105 SQLCA }]D:ex 96 SQLCODE VN 96 SQLCODE 3d 44, 45 3dD~ 45 SQLCA PDVN 96 SQLDA Vds! 71 SQLSTATE `zk 45 SQL_ATTR_ TRUSTED_CONTEXT_PASSWORD (} CLI P;IE,SDC' 31 TRUSTED_CONTEXT_USERID (} CLI P;IE,SDC' 31 USE_TRUSTED_CONTEXT (} CLI 4(IE,S 30 SRVNAM Ts 97 START MVS 53|n 55 STOP MVS 53|n 55 T TCP/IP 2+T 35 KZE 26 130 DB2 Connect C'8O TCP/IP (x) ~q{F 21 dC wz,S 9 O$=8 35 6Lwz{ 21, 26 Y,=KZ 21 wz{ 26 ACCSEC |n 97 DOMAIN 21 RESPORT 21 RFC-1323 )9 86 SECCHK |n 97 TCPPORT 21 TCP_KEEPALIVE Yw53dCN} 65 Tuxedo DB2 Connect s5f 17 V VARCHAR }]`M Ev 87 W Web ~qw DB2 Connect 14 Web &CLr f“}L 14 DB2 Connect 11 WebSphere Ev 12 WebSphere MQ DB2 Connect 79 Windows T\`Sw `S DB2 &CLr 49 X XA /Pw>} 75 IE,S 29 J4\mw 17 XA Bq\mw Ev 17 ,S/Pw 75 X/Open V<=Bq&m (DTP) #M Ev 17 [XpV{] && SQLCODE 3dD~ 45 w} 131 132 DB2 Connect C'8O  Printed in China S151-1176-02 Spine information: IBM DB2 Connect 9.7 V9R7 DB2 Connect C'8O 
还剩140页未读

继续阅读

下载pdf到电脑,查找使用更方便

pdf的实际排版效果,会与网站的显示效果略有不同!!

需要 2 金币 [ 分享pdf获得金币 ] 0 人已下载

下载pdf

pdf贡献者

kaiye

贡献于2019-02-20

下载需要 2 金币 [金币充值 ]
亲,您也可以通过 分享原创pdf 来获得金币奖励!