IBM C8O User Manual
IBM DB2 Connect 9.7
DB2 Connect C'8O
S151-1176-00
IBM DB2 Connect 9.7
DB2 Connect C'8O
S151-1176-00
"b
9CKE"0d'VDz70,kHDAZ 163 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 International Business Machines Corporation 1993, 2009.
?<
XZ>i...............v
Z 1 ?V DB2 Connect En ....1
Z 1 B DB2 Connect.........3
DB2 Connect a)Dz7 ..........3
DB2 Connect f> 8 P;6D&\ .......3
wz}]b ...............4
DB2 Connect M SQL od .........5
DB2 Connect \m5CLr .........5
InfoSphere Federation Server M DB2 Connect....6
Z 2 B V<=X5}]be5a9....7
DRDA M}]CJ ............7
DB2 Connect M DRDA...........7
6L$w%* ..............8
V<=ks ...............9
Z 3 B DB2 Connect =8 ......11
1SCJwz}]b ...........11
9C DB2 Connect vKf4CJ System z wzr
IBM i DB2 }].............12
DB2 Connect ~qwz7w*,S~qw.....13
DB2 Connect M Web &CLr ........14
DB2 Connect M IBM WebSphere .......15
DB2 Connect w* Java &CLr~qw .....16
Web ~qwOD DB2 Connect ........17
DB2 Connect M&CLr~qw........17
DB2 Connect MBq&m`Sw........20
Z 2 ?V DB2 Connect N< ...23
Z 4 B |B}]b?< ........25
53}]b?<5 ............25
Zc?<5 ..............25
DCS ?<5 ..............26
?<(F$wm .............30
T,;}]b(e`vu? .........31
&m BiDi }] .............31
Z 6 B s(&CLrM5CLr(DB2
Connect) .............43
Z 7 B `>c|B .........47
9CXFPDtC`>c|B ........48
9CXFPDbT`>c|B ........48
`>c|BM,=c\mw .........48
9C{O XA DBq\mwdC DB2 Connect . . . 49
DB2 Connect TI"nOBqD'V ......50
Z 8 B 9C DB2 Connect 4F/}] 51
Z 9 B SQLCODE 3d .......53
O* SQLCODE 3d ...........53
w{ SQLCODE 3d ...........53
Z 10 B }]b53`SM DB2
Connect ..............57
`S6LM'zD,S ...........57
9C Windows T\`Sw`ST\ ......57
9C GET SNAPSHOT |n .........58
DCS &CLr4, ............60
KP4v`SwM/( ...........64
DB2 z/OS fKP4v`SwEv ......64
t/"#9M"B DB2 z/OS fKP4v`Sw 65
i4"a;M#f(iDYw .......66
i4KP4v/(**
i4KP4v/(Ts ..........69
..........68
Z 3 ?V _ICTM DB2 Connect 71
Z 11 B wz}]b,SD_ICTM:
Xyb ...............73
Z 12 B M'zT/XB7IDhvMh
C(DB2 Connect) .........75
Z 13 B dCM'zT/XB7IT+d
kM'z,SV"w<udO9C ....77
Z 5 B DB2 Connect 2+T .....35
(} DB2 Connect xPDIE,S ......35
(} CLI 4(MU9IE,S .......36
(} CLI P;IE,SDC' .......37
DB2 Connect O$"bBn .........38
Kerberos 'V .............40
XZ z/OS 2+TDa>M<I .......40
DB2 Connect 'VDO$`M .......41
Z 4 ?V w{M DB2 Connect . . 79
Z 14 B DB2 Connect T\"bBn 81
Z 15 B E/ ODBC CJ ......85
Z 16 B &CLrhF ........87
Z 17 B ,S\m ..........91
© Copyright IBM Corp. 1993, 2009 iii
,SX ................91
,S/Pw ..............92
,SXM,S/Pw ...........96
WebSphere MQ Transaction Manager M DB2 z/OS
fh*,S/Pw ............96
Z 18 B DB2 Connect ~qw[O53
'V ................99
System z [O53{CD"bBn .......99
DB2 [O53{C............100
[O53DdC*s ...........100
Z 19 B M'z[O53'V .....101
Bq6p$w:Xyb(M'K).......101
dCBq6p$w:Xyb(M'K) ....102
M'zT/XB7I(M'K) .......104
dCM'zT/XB7I(M'K) .....105
XA 'V(M'K) ...........107
tC XA 'V(M'K) ........107
dCM'zW5X5 ...........108
kT9CM'z[O
53'VDV^T .....112
u<,S4I&.............127
u<,Ssv=DJb ..........128
oO$_ ...............129
Z 23 B DB2 Connect PD DB2 z
Y ................131
9C db2trc q! DB2 zY ........131
*" DB2 zYD~ ...........132
q=/ DB2 zYD~ ..........132
Z 24 B DRDA zYD~ ......135
zY5CLr .............135
zYdv ...............136
zYdvD~Vv ............136
zYdvD~y> ............137
DRDA zYDsx:exE" ........142
Z 6 ?V {" ..........145
Z 25 B DB2 Connect #{Jb ...147
Z 20 B DB2 Connect w{ .....115
wz}]bw{.............116
xgw{"bBn ............117
53J4yC .............118
DB2 Connect T\JOoO .........118
w{ DB2 z/OS f............118
a_ DB2 Connect }]+dJ........119
nbi/i ..............119
RFC-1323 0ZuE ...........120
wz}]*; .............120
V{}]D}]`M ...........121
xg2~ ...............121
Z 21 B CLI/ODBC &CLrT\w{ 123
Z 5 ?V JOoO ........125
Z 22 B JOoO DB2 Connect . . . 127
U/`XE" .............127
Z 7 ?V =< ..........151
=< A. DB2 <uE"Ev ......153
2=4r PDF q=D DB2 <ub ......153
):!"fD DB2 i. ..........156
S|nP&mwT> SQL 4,oz ......157
CJ;,f>D DB2 E"PD .......157
Z DB2 E"PDPTzDW!oTT>wb ...157
|B20ZzDFczrZ?x~qwOD DB2 E
"PD................158
V/|B20Z
DB2 E"PD .............159
DB2 LL...............160
DB2 JOoOE"............161
unMu~ ..............161
=< B. yw ............163
w} ...............167
zDFczrZ?x~qwOD
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 gNZ
Connect MZxgPD_T\,+w*kJOoODI\Jb`XD;)wb}x#
xg73P'V_ICT#7# DB2
>iD9C_
53\m1"}]b\m1M53(6K1&CT>iD;?Vr+?PK$#
© Copyright IBM Corp. 1993, 2009 v
vi DB2 Connect C'8O
Z 1 ?V DB2 Connect En
© Copyright IBM Corp. 1993, 2009 1
2 DB2 Connect C'8O
Z 1 B DB2 Connect
DB2 Connect a)k IBM®sMz}]bDlY!3,S,T)Z Linux®"UNIX®M
Windows
DB2 Connect vKfa)k System z
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#
®
Yw53BKPDgSLqMd{&CLr9C#
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
PX DB2 Connect a)Dz7Dj8E",kND www.ibm.com/software/data/db2/
db2connect/
®
M IBM Power Systems™~qwD1S,S,
®
f
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,G4
/"TXB(",S(g{fZ8C~qw)#8C~qwGZ~qw5}
O8(D,d;C+Z,SZd"MxM'z#
v }]S\
M'z/~qw(EVZa)K1C'}]Zx gPw/1TdxPS\ D
&\#
DB2 Connect f> 8 "
DB2 Connect f> 8.1 |(BPv?&\:
v 'V|$D SQL od(n` 2MB)
Pf 1(|(yP^)|M^D6p)P;6D&\
M'z+T
© Copyright IBM Corp. 1993, 2009 3
`o 2MBD SQL odITw- CLI M JDBC &CLr#+G,6k=
SZ#t 64K D^F#
v j6 SQL odp4DoOE"
®
I7(T DB2 z/OS
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
,Z DB2 CLI P,1CJ DB2 (C}]b(UDB)z/OS ff> 8.1
VZ
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#
f/, SQL od_Y:f"vX(odD&CLr#
wz}]b
":1Sf
Connect +;'VC|n#
Z{vD5P,uo
nect (EDd{53P,9Cuo“}]b”hvDEnI\aTP;,#Z DB2 Connect P,uo“}]b”9IT8:
System z
DB2 z/OS f. Id LOCATION NAME j6D DB2 z/OS fS53#(}G
<= TSO "9CdP;v ICD
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
VSE Z}]bVxPKPDI DBNAME j6D DB2 VSE f
> 7 DM'z(}f> 9 DxXrwz"v PING |n1,DB2
}]b
C4hvX5}]b\m53(RDBMS)#Zk DB2 Con-
i/$_"vTB SQL i /,MIT7(
{"IP X7MKZ#
4 DB2 Connect C'8O
VM Z CMS ibzPKPDI DBNAME j6D DB2 VM f
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#
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
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(T0
F* SQL/DS
"T#
™
)M DB2 IBM i f5V#?R(i9C IBM SQL 4,$}]bD@
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#
IT9CBP5C
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)K<Ngf#
v <kM<v5CLrJmzT$w>
k"<kM<v}]#;s,IT9Cb)D~4+}]<k}]b"gSmqT
0Z$w>OKPDd{&CLrP#
, SQL 9G9C/, SQL,I&CLr14v(# DB2 Connect ,
Lr4oz DB2 Connect \m1:
M IBM sMz}]b~qw}]bODD~0
Z 1 B \m DB2 Connect 53 5
v g{z}KP DB2 Connect ~qwz7,zI9C“B~i4w”M“T\`Sw”#(
}9C“B~i4w”,MITi4 DB2 Connect yG<Dl#B~#(}9C“T\
`Sw”,MITZ>Xr6L`SM\m DB2 Connect ~qwDT\#
v DB2 XFPDJ
mz\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#K5CLr9IToz
m1IT9M'z&CLrk IBM sMz}]b~qwOKPD`&w5X*p4#
":ZH0"PfP,DB2 <N\m$_(}g,XFPD)ZyP=(O<\'V#
Sf> 9 *<,DB2 <N\m$_vZ Windows x86
EM64T)"x86 OD Linux M AMD64/EM64T OD Linux O\'V#TZyP=(,
IT9C DB2 |nP&mw(CLP)4xP\m#
InfoSphere Federation Server M DB2 Connect
InfoSphere™Federation Server G;v@"z7,|a)T`v)&L}]4D}]CJ
(T0g`v)&L}]4D}]/I,x DB2 Connect 9z\;{CVPwzMP
M~qwODs?}]#
InfoSphereFederation Server (}Jm+}]4D/Ow*%;4xPi4M&m4oz
/IE"#b9C
tion Server Ik DB2 Connect ~qwz7dO9C#InfoSphere Federation Server a
)T DB2 z75P"Informix
}]bD>zA4CJ(#InfoSphere Federation Server 9a)TGX5Mz|F'}
]4(g Documentum"IBM Lotus
(#IT9C|4mvT*O53PD}]Di/#
}]4CJT4PwCD&CLrxTj+8w#InfoSphere Federa-
®
"Oracle"Sybase"Teradata M Microsoft®SQL Server
®
Extended Search"ma9D~M XML)DACJ
53\m17(ms4#53\
"Windows x64(AMD64/
6 DB2 Connect C'8O
Z 2 B 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
D(E#
$w%*
$w%*(
*4I&X4PKyPYw,*4C5Pw*;v{eG;I&D#
V<=$w%*
V<=$w%*(
}]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~
v Z`v}]b~qw.d-wKd5#
UOW)G%v_-Bq#|I;5P SQL odiI,ZC5PP,
DUOW),VF*`>c|B,f0 ;v$w%*PD`v
]T0XkgN;;|4-w53.d
qw#
DRDA M}]CJ
!\ DRDA (eK}]b(E-i,+|;P(e`LSZr API(&CLr1h*
9C|G)#(#,&CLrIT9C DRDA 4+M?j DRDA ~qwI4PDNN
ks#?0ICDyP DRDA ~qw<I4PI&CLr(} DB2 Connect *"D
SQL ks#
IBM *&CLr1zI
b ) $_ G DB2 M 'zD; ?V # DB2 } ]b \m w' Vt I `L SZ :
ADO.NET"JDBC"SQLJ"PHP"Perl DBI"6k= SQL"DB2 wC6SZ(DB2 w
C6SZ)M OLE DB#Lr1IT9Cb) API 49(wV`LoT`4D&C
r#
DB2 Connect M DRDA
DB2 Connect 5V DRDA e5a9T5MCJf"Z DB2 IBM i f"DB2 IBM Power
Systems"DB2 z/OS f" DB2 ~qw VM M VSE fT0d{{O DRDA D}]
b~qwPD}]DI>M4ST#(}dV{C DRDA e5a9,DB2 Connect a
)KT\<CD"MI>Dbv=8,C=8_PM'yh*D5
Z DRDA uoP,
AR G}Zks}]D&CLr#DB2 Connect zm DB2 Connect $w>D>X&C
Lrr DB2 Connect D6LM'zOD&CLrd1&CLrksw#
CZ Windows"UNIX M Linux Yw53D SQL ka)$_#
3\mXw#
&CLrksw(AR)
GC4&mV<=,SD&CLrKDzk#
L
&CLr~qw(AS)
© Copyright IBM Corp. 1993, 2009 7
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*|;1S k&CLrkswxP;%#Kb,*K;vdH;
"v}]bksD532;GTks4P}] b&\D53DG+,&CLrksw
knU}]b~qw.dD?v&CLr~q wr}]b~qw2;F*Pd~q
w#DB2 Connect 'V9C}]b~qwMPd~qw#
G
< 1T> DB2 Connect $w>k IBM sM
DivB)#
<
1. DB2 Connect
*K5V DRDA ~qw}]b\m53kIBM }]~qwM'z.dD,S,DRDA
9CBPe5a9:
v V{}]m>e5a9(CDRA)
v V<=}]\me5a9(DDM)
v q=/}]TsZ
v +dXF-i/rXx-i(TCP/IP)
~qwk
IBM
sMz~qw.dD}]w
]e5a9(FD:OCA)
z~qw.dD}]w(Z;P>XM'z
6L$w%*
8 DB2 Connect C'8O
b)e5a9Cw9(i#(}xgw/D}]wGI DRDA e5a98(D,|5
wK'VV<=X5}]bCJD}]w-i#
ks(}|,wV`M(EE"D?<M}ZCJD DRDA
IA}7?j#
6L$ w%*
VCJ$w%*ZD;v}]b#d ;&CLrIT|B8v6L}]b,+G|;
\CJ;v$w%*ZD;v}]b#
6L$w%*_PBPXw:
v 'V?v$
v 'V?v$w%*fZ`vNj#
v ?v$w%*;\|B;v}]b#
JmC'r&CLrA!r|B?v$w%* D;v;CD}]#|'
w%*fZ`vks(SQL od)#
~qw}]bD{F47
v &CLr*4d5*4Xv$w%*#Z3)msivB,}]b~qwr DB2 Con-
nect I\aXv$w%*#
}g,< 2 T>;vKPyp*F&CLrD}]bM'z,|CJ|,'1J'mM
"nJ'mD}]bT0;WQCF.m#C&CLrX
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%*
)#
k:
V<=ks
<2.ZBqP9C%v}]b
*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`?T
b#
4. T&CLrxP$`k,T8(`M 1 ,S;2MG5,Z PREP |nO8(
CONNECT(1)#
V<= ks
=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 Y
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#
G;VV<=}]b&\,|Jm&CLrM C'Z%vodPa;}C
w#\'VD DBMS |( DB2 5P(g DB2 }]b Linux
j6}]b~qwOD}]
Z 2 B V<=X5}]be5a9(DRDA) 9
V<=ks*}]bTsa)K
XTksCE"D&CLrwNN|DMIT|BTCE"D}C(F*
=ks9T;'VyP DB2 SQL oTr3)E/&\D DBMS a)K
DBMS B;\4PDYw(}g,]i SQL)GZ DB2 Connect BfKPD#
kTw
V<=ksIC
1,a;|,KT Oracle TsD}CD DB2 i/#V<=ks;a"Or^F(,v
j{TMx(<xD6')T Oracle rd{ DBMS TsDCJ#
==KP#}g,ITZ Oracle &CLr}ZCJ,;~qw
;C8 wT
#g{}%K(mMS<PD)E" ,;
GF
)#V<
9%
#ZbV
V<=ks&\D5V|( DB2 Connect 5}"+d1*O}
r`v6L}]4#
DBMS M}]iI#&CLr,SA*O}]bk,SAd{NN DB2 }]bj+;
y#DB2 Connect *O}]bDmI;GC4\mC'}]#d(;?DGC4fEP
X}]4DE"#
ZhC*O53.s,ITCJ`v }]4PDE",MC
]bP#C'M&CLr+i/"M=;v*O}]bP,;s,|S DB2 5PM
Oracle 53Py]h*4lw}]#C'M&CLrZi/P8(GF,b)GFa)
KT}]4PDmMS<D}C#SnUC'DGH
m`rXa0lV<=ksDT\#nX *DrXMG*7#+PX}]40dTs
DnB<7E"f"Z*O}]b+V?<P#KE") DB2 E/w9C"RIT0
lGqv(4PYwTcZ}]4xP@@#
*O} ]b
|,C4j6}]40dXwD?<u? #
4,GF`FZp{#
]bD}]bT0;v
}]4
qb)E"Z;vsM}
I
10 DB2 Connect C'8O
Z 3 B DB2 Connect =8
DB2 Connect Ia)wVbv=8Tzc IBM sMz}]bCJh*#>wbEv8
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$D IBM }]~q
w}/Lr|#
20K DB2 Connect vKfD?v$w>Ik DB2 z/OS f" DB2 IBM i fM DB2
}]b Linux f"UNIX fM Windows f~
LrITZ,;BqP,SM|B`v DB2 5P}]b,R_P=WNd5-ia)
D+?}]j{T#
< 3 T>S20K DB2 Connect vKfD$w>A IBM sMz}]b~qwD1S
,S#
qw("1S TCP/IP ,S#Kb,&C
<
3. DB2 ConnectkIBM
© Copyright IBM Corp. 1993, 2009 11
sMz}]b~qw.dD1S,S
":
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*
+T/"TXB("C,S#
,G4M'z
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#B
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$#
Z 13 3D< 4 T>20K DB2 Connect vKfD$w>
IBM sMz}]b~qw#
Pf>'V>z TCP/IP ,S:
,"RC$w>1S,SA
12 DB2 Connect C'8O
<
4. DB2 ConnectkIBM
sMz}]b~qw.dD1S,S
DB2 Connect ~qwz7w*,S~qw
DB2 Connect ~qwJm`vM'z,SA IBM sMz}],"ITxuY("M,
$Ts5}]DCJyhD$w#Z 14 3D< 5 5wK3)73B IBM Dbv=8,
Zb)73P,zk* DB2 M'z(} DB2 Connect ~qwz7(g DB2 Connect
s5f)k IBM sMz}]
":vZ Linux"UNIX r Windows OKPD DB2 M'zr JCC M'z'VdS,
S#"T9CNNd{M'z(} DB2 Connect ~qwz7k IBM sMz}]b~
qw(",Sa<B SQL1334 ms#
b~qw("dS,S#
Z 3 B =8 13
<
5. DB2 Connect
g{*'k DB2 Connect ~qwD TCP/IP ,S,G4M'z+T/"TXB(",
S#M'z+WH"TXB("k-<~ qwD,S#g{4XB("C,S,G4
M'zZ"zJO1+*A8C DB2 Connect ~qw#(8C~qwGZ~qw5}O
8(DRZ,
S,G4M'z+"TXB("k-<~ qwD,S#M'z+;O"TXB(",
S(Z-<~qwk8C~qw.dP;),1=("K,Sr"TN},1*9#
s5f
SZda+d;C5XxM'z#)g{4XB("k8C~ qwD,
DB2 Connect M Web &CLr
Web /@w}8YI*S*z?<=Z?x&CLr;PBqDj<gf#TZr%D
Web &CLr,;*;v Web ~qwI\MQ;C#TZh*}]bCJMBq&m
Ds?&CLr,IBM a)K;)bv=8,|G9C DB2 Connect (} Web 4\
ms?D,
+3 CGI `LDEcMV^T
r,x(WWW)ODgSLq&CLr(#9C“+2xXSZ”(CGI)49C'I
i/sK}]b#m`+>9ZZ?9C Web &CLr,xb)Lr(#2Ps(}
]b#
1Bq#
14 DB2 Connect C'8O
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
>v4#}g,;v*z?<,C' IZdPi/X(L7r~qDICT0n
"T
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 ~qw
O4(
;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=8
4DxyZ 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,I
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
~ 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}=$_<uM&CLrr\
v Vv Web >cZ]T\M9CJ
v inw{>cT]I|`
v Z;)w*DYw73(AIX
i"Solaris Yw53M Microsoft Windows)OxP?p
v 9CVPD Web ~qw,|( Apache"IBM"Netscape M Microsoft a)DG)
~qw#
T4(Vx,S#ZK73P,Vx,SITZ%v
™
4a)4SD_K
C'M,$LB?
®
"HP-UX"Linux"Novell NetWare"z/OS"IBM
Z 3 B =8 15
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#"!
<#
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
`E",kCJ http://www.ibm.com/software/webservers/appserv/was/
DB2 Connect w* Java &CLr~qw
(}9C Java,m`E>oTD1c<ITK~#IBM a)KJmzZ Web BqD?
;WN9C Java D applet M&CLr#IBM a)Dbv=8Jm9ClO<u,b
b6EI+E>`Fbv=8(g Perl DBI r Microsoft ASP)k DB2 dO9C,
r*x9C Java &CLr~qw
a)D|!3Dbv=8(}g IBM WebSphere)#
3Ds56&CLrDj
®
Application Developer(RAD)#*Kb|
* 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 L
qDM'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
=(IC4?p Java &CLr#I9C DB2 Connect vKf(} TCP/IP a)D1
S,S,2I!q(} DB2 Connect ~qwz7xP,S,Cz7a)k IBM sM
z}]~qwD,S#
Zb=VivB,Web ODC';h*NNXbDm~4C
/@w4I#vh*20 DB2 Connect ~qwz7MNN5gj< Web ~qw#g
{ Web ~qwM DB2 Connect ;Z,;omzwO,G4h*Z Web ~qwO2
0 IBM }]~qwM'z#
TZ DB2 z/OS f,X|i~GZPdc~qwOKPD DB2 Connect
}K,SA DB2 z/OS f" DB2 ~qw VM M VSE fM DB2 i f~qwTb,
Ki~9a) JDBC ~qw'V#M'zD Web /@w2;h*NNXbDm~#
rZ8( SQL 1SekD&\#DB2 ITZ Web B
fM DB2 IBM i f,P=V;,D
J}]b,;hj<D Web
~qwz7#
16 DB2 Connect C'8O
IBM **" Java &CLrM applet a)+fD'VM$_#TZ}]b&CLr*
",DB2 }]bs5*
WebSphere Application Server T0 DB2 z7M DB2 Connect T)bT#Z}=$_
(g NetBeans"Borland JBuilder r Symantec Visual Cafe)2ITk IBM D}]b
bv=8dO9C#
"_fa) Rational Web Developer"IBM Data Studio"DB2
Web ~qwOD DB2 Connect
IBM T HTTP(Web)~qwa)yP DB2 Connect z7#DB2 Connect ~qwz7
(g DB2 Connect s5f)a)KT Apache r Lotus Domino®Go web ~qwDn
b'V,|9IT9CNNd{ Web ~qw(}g Microsoft Internet Information Server
r Netscape Enterprise Server)#
g{9CZ System z" IBM Power Systems"VM M VSE 53OKPD DB2 }]
b5P,G4 Web ~qwOh* DB2 Connect ~qwz7#DB2 Connect ~qwz
7+a)bM(ESZ,T9 Web ~qw\;CJb)
TCP/IP Z Web ~qwk System z" IBM Power Systems"VM r VSE OKPD}
]b.dxP(E#
":IBM Web bv=8a)KZ,;“+2xXSZ”(CGI)E>(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#
IBM sMz=(#IT9C
FvD=(G+f"}LP|(D`LM
DB2 }]b Linux f"UNIX fM Windows f M DB2 z/OS f" DB2 IBM i f
M 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%@
}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 }]
DB2 Connect M&CLr~qw
M'z/~qw&CLrDvV9&CLrhF_IT(}Zng Windows .`D=(
O*&CLra)<NC'gf4v?I CTM5M`5I>#,1,|JminX
+}]b\m&\&CZwVYw53M2~=(O!3D}]b~qw#
M'z
z~q w
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#
/~qw#M(dP&CL r_-V<ZM'z$w>O)(#;F*
#Z=c#MP,&CLrGZM'zcO? pD,x}]b~qw5V~
5q_-k CGI &CLr`L[OZ;p#
D SQL od"MA DB2 }]b,xG"M4Pf"
bsKdDxgw?#
=cM'
fEM'z/~qw&CLrs!DvS,=
v4K#+s?D5q_-V<ZI YuAO'DM'z$w>a9d|\mI*4
SRI>_:D$w#NN5qfr |D<h*f;&CLrDM'z?V#(#b
)&CLr*v;(*Zs5D
C*;B#
yPM'z$w>OxP,,1*7#5 qfrD&
cM'z/~qw#MD^sV^TMT>
Z 3 B =8 17
=cM'z/~qw#MD m;v1cfEbyD&CLr9CDJ4?)sxTVv
4#?pIYrO'D
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"
;T#Mwv|D,m;v1c;]Wbv#
&CLr~qwbv=8
fE=cM 'z/~qw&CLrDI>M4STDO},s?VnsD&C
Lr*<E Vy`cM'z/~qw"
4|D#+GM'zcr9dK;vr`vPdc(;c*;v),yTF*
}c
#
Z}c#MP,M'zDwCB5*v&mC';%wC,x;|,NN5q
_-#PdcGI;vr`v&CLr~qwiID#&CLr~qwD?j
GZ5qwLM5qfrDsfa)!3D"MI>D_-5V=8#s=c
M;y,(#h*(}9Cf"}L4DxT\ ,TK9d5qfrD5
#
V#
r*M'z$w>;Y5VsiD&CLr_-,x Gv&mC'D;%w
C,yTQss5MKTM'zcDJ4hs#B5O,}c#MPDM'z
c(#F*
ks,yT|_P2mJ4D\&,g2myP M'zdD}]b,S#r
),}]b~qw;Yh*,$?v&CLrC'D(C,S#
VM'z
5q_-T=cM'z/~ qwD@5I\PyuY,+g{
]M'z
((#byFt=cM'z)vSKT? vM'z$
9#Z`c #MP,}]bcDwCT
#Kb,r*Pk&CLr~qw&m4TyPM'zD
?0,5gPfZm`}c&CLr~qwD>}
.”(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#
)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#
Jm&CLr~qwZ%vBqP5VT`v}]b~qwOD}]xP|
b
BDBq#
DB2 Connect a)D=WN d5-i'V#$bVV<=BqDj{T# }
g,&CLrITZ,;BqP|B DB2 z/OS f}]bM DB2 }]b Linux
f"UNIX fM Windows fPD}]#
|,G4&CLr IZ,;BqPA! Oracle }]bM|B DB2 5P}]
b#
ZB<P,DB2 Connect ~qwz7a)K&CLr~qwksK}]b~q
wdD,SzFT0 API,}g:DB2 Connect s5f#
#8uyPD“s5J4f
DB2 Connect a
g{20KV<=ks'V"tCK
18 DB2 Connect C'8O
<
6. DB2 Connect
T&CLr~qwD'V
DB2 Connect D_6&\?~,}g,SXssuYK&CLrJ4Dhs"
r/K&CLr~qwD5V#
DB2 Connect M&CLr~qwdC
k&CLr~qwdO9C1,DB2 Connect ~qwz7GXhD#DB2 Con-
nect vKfG;\'VDR;aqCk&CLr~qwdO9CDmI
5)&CLr~qwDM'&4if{GD DB2 Connect ;pa)DunMu
~,TKbh*q!DC'mI$}#
Z&CLr~qw73PP=VCZ DB2 Connect D?p=(# DB2 Con-
nect ~qwz7I20Z:
v &CLr~qwO,r
v @"D(E~qwO
?VivB,W!Dbv=8G+ DB2 Connect D1>20Z&CLr~
Zs
qwyZD~qwO#+ DB2 Connect 20Z&CLr~qwOJmdNk&
CLr~qwI\5VDNNJO*FM:Xyb=8#KhC9I1ZXa
)|CDT\,-rG|E}K
DnbxgPL>#Kb,9Ir/\m,-rG;h*20M,$d{~q
w#
#Kb,
Z@"D~qwO20 DB2 Connect 1yXh
Z 3 B =8 19
+ 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~qw4 PD&CLrwCQ-wDBq#KBq
-w(#;F*“Bq&m”(TP)`Sw#TP `Swk&CLr~qwdO9C
Bq
I;SwKPi/DU#YwD}P B~,(#G~qks#3rX&mBqM
G TP `Sw;hFID$w`M#
Bq&m
#
?;vi/<PhvdKw==Df rM}L#5Vb)frDC'&CLrF*
q_ -
”(OLTP)#
L5D OLTP Dw*XwP:
`C' i/PDs`}K<9CBq&mG#{Div,r*P\`Ka0l5qD
X4T s?VkFczD;%
rLD;%wC
2mD}]
}]j{T
MI>/Bq
#b ) 5q &CLr y4 PD Bq (#F* “B q& m” r“ *z Bq &m
104,#
wCcrZ;NV;NX4P,;}L#}g,?l`
Ndk,;v)%r&m6n#
i/PDKkBq&m53Ds?V;%wCDVx1d<\L#
r*}]m>i/D4,,yT}];aP;V1>
}]Xkm>i/D104,RZZ?XkG;BD#}g,?v)%Xkk
;vM'G<`X*#
r*Bq&mm>4P5qD1SI>,d53I>XkGn!D#DB2 Con-
nect JmI Linux"UNIX M Windows OKPD&CLr
rT6L LAN"IBM sMz}]b~qw4PBq"I TP `Sw4-wb
)Bq#
#
~qwXFD&CL
5
20 DB2 Connect C'8O
<
7. DB2 ConnectTTP
`SwD'V
Z< 7 P,API T0&CLr~qwMsK}]b~qw.dD,SzF<GI DB2
Connect ~qwz7(g DB2 Connect s5f)a)D#
Bq&m`SwD>}
?0P!On#{D TP `SwP:
v IBM WebSphere Application Server
v IBM WebSphere MQ
v IBM TxSeries CICS
v IBM TxSeries Encina®`Sw
v BEA Tuxedo
v BEA WebLogic
v Microsoft Transaction Server(MTS)
IZIb) TP `Sw-wDBqP9C6L IBM Power Systems" System z M LAN
}]b~qw#
®
Z 3 B =8 21
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')#
2PI\b=v}]
;v}]b* Oracle }]b#Q-(eK TP `SwkI&CLrCJDNNJ4.
dD+2BqSZ,x;GI?;v TP `Sw45V?;v}]b)&LD(CBq
SZ#KSZ;F*
TM)#5V XA SZDI|BJ4;F* XA
w(
OvP>D TP `Sw<G{O XA D TM#(} DB2 Connect CJ1,6Lwz"
IBM Power Systems MyZ LAN D DB2 }]bG{O XA D RM#rK,NN_
P{O XA D TM D TP `Sw<IZ4PBqD5q&CLrZ9Cwz" IBM
Power Systems MyZ LAN D DB2 }]b#
bG;,D)&La)D#}g,;v}]b* DB2 z/OS f,m
XA
SZ
#9C“XA SZ”D TP `Sw;F* XA
f]J4\mw(RM)
f]Bq\m
#
22 DB2 Connect C'8O
Loading...