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 Con­nect 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

Z 2 ?V DB2 Connect N<

© Copyright IBM Corp. 1993, 2009 23

24 DB2 Connect C'8O

Z 4 B |B}]b?<

DB2 Connect 9CBP?<4\m}]b,SE":

53}]b?<

v

v

v

":

1. Z|Bb)?<.0,&Z IBM sMz}]b~qwM$w>OdC(E#

2. IT9CdCzV(CA)4|B}]b?<#

*|B}]b?<:

1. 9C?<(F$wm4U/

2. kNDXFPDPD“|BxPXZ6L}]b~qwzwD?<”wb

53}]b?<5

53}]b?<OfZ}]b\mw D?v5},"R|,Q*K5}`-?<D?
v}]bD;vu?# DB2 Connect z7P,53}]b?<|,XZ?v}]bD

{F"p{"Zc{MO$`MDE"#

Zc?<

M(E-iE"#

}]b,S~q(

"#

:|,K DB2 Connect CJD?v IBM sMz}]b~qwDxgX7

:|,K DB2 Connect CJD?v}]bD{F"ZcMO$E"#

DCS

)?<

:|,KX(Z IBM sMz}]b~qw}]bDE

}]b?<E"

Zc?<5

Z53}]b?<PIT8(T

}]b{F

kz4k“DCS ?<N}”mPD5`,#

}]bp{

IBM sMz}]b~qwDp{#CJC}]bDyP&CLr<+9CK{
F#1!ivB,9Cz*“}]b{F”8(D5#

q=:1 = 8 v%VZV8}VV{

@*{E($)MB._(_)#|;\TB._r}V*7#

Zc{ kz4k“Zc?<N}”mPD5`,#

O$ 8(+ZN&i$CZk DB2 Connect ~qw(",SDC'{M\k#P'

! n * : SERVER

KERBEROS"SERVER_ENCRYPT_AES M DATA_ENCRYPT#53}]b?
<P;'V GSSPLUGIN O$`M#

ZZc?<PIT8(TBE":

Zc{ 6L}]byZD IBM sMz}]b~qw53DGF#K{FGIC'(e

D#Z“Zc?<N}”mM“53}]b?<N}”mP4k`,DZc{#

BE":

,|(}V{E(#)"at {E(@)"

" SERVER_ENCRYPT" CLIENT"

© Copyright IBM Corp. 1993, 2009 25

q=:1 = 8 v%VZV8}VV{,|(}V{E(#)"at {E(@)"
@*{E($)MB._(_)#|;\TB._r}V*7#

-i Xk* TCP/IP#

2+`M

+4PD2+TliD`M#TZ TCP/IP Zc,SECURITY SOCKS !n8(Z
c+tC
XhD"RXk+|GhC*tC SOCKS#

TCP/IP 6Lwz{r IP X7

1(e TCP/IP Zc1D6L TCP/IP wz{,r_G6L TCP/IP X7#g

{8(Kwz{,GXkZ DB2 Connect $w>P(}“r{~qw”(DNS)

iRr_

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

, VIPA X7"XU[O537Im#?vI1 DSNL004I {"<T>X(Z
I1Dr{#

TCP/IP ~q{FrKZE

1(e TCP/IP Zc1D6L TCP/IP ~q{F,r_GKZE#XkZ6L

wzOr TCP/IP TdxP

E#

SOCKS,ZKivB,SOCKS_NS M SOCKS_SERVER 73d?G

(}>X TCP/IP wzD~PDu?4bvwz{#

!D DB2 I1#*CJX(I1,9CCX( DB2 I1/

(e#KZE 446 Q;"a* DRDA D1!KZ

DCS ?<5

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 }]2m

X77IA:Xn!D DB2 I1#*CJX(I1,9CCX( DB2 I1/
, VIPA X7"XU[O537Im#?vI1 DSNL004I {"<T>X(Z

I1Dr{#

":II~qw8(Z~vKZ,TC4T

,=Yw#}g,DB2 z/OS f}<}]/+8(;vKZE(RESPORT),
CKZE;CZ DB2 z/OS fk>,SDY,=#b;h*(e~q{F#

Z DCS ?<PIT8(TBE":

}]b{F

C'(eD IBM sMz}]b~qwGF#Z“DCS ?<N}”mM“53}]
b?<N}”mPh9C`,D}]b{F#

q=:1 = 8 v%VZV8}VV{,|(}V{E(#)"at {E(

@*{E($)MB._(_)#|;\TB._r}V*7#

i,G4r{&3dA DB2 i/, VIPA X7#K

TCP/IP ,SOD=WNd5xPY

@)"

26 DB2 Connect C'8O

?j}]b{F

IBM sMz}]b~qw53OD}]b,gBy>:

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#?v I 1
DSNL004I {"<T>X(ZI1Dr{#

VSE r VM

}]b{F(DBNAME)

IBM Power Systems

X5}]b{F(RDBNAME)

d{ TZ Windows"Linux M UNIX Yw53,Z}]b?<PR=D}

]bp{#

N}V{.

g{k|D1!5,G44BP3r8(BPNNryPN}#

map-file

2GK1! SQLCODE 3dD SQLCODE 3dD~D{F#

*O* SQLCODE 3d,8( NOMAP#

":&mi/ks1,DRDA ~qwTm>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(F

j

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 4 B |B}]b?< 27

,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 ? <P dC K

INTERRUPT_ENABLED,"RM'z&CLrZ,SA IBM

sMz}]b~qw1"vPO,G4 DB2 Connect +(}O
*,SMXv$w%*44PPO#Z AIX M Windows O,

KPOP*G\'VD#

&CLr+SU= sqlcode (-30081),|8>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<ICZ TCP/IP ,S

\O*WSV,+Gy]~qw5V,I\P2I\;P4j

ISU#DB2 z/OS f9Cl=WSVwC,rK\;lbv,
SD*'"XvNN}ZxPD$1dKPD SQL od#

#M'zI

28 DB2 Connect C'8O

,,,,,SYSPLEX

KN}GZ 6 v;CN},IT9CCN}4T=

]btC DB2 Connect [O53'V#

XTX(}

,,,,,,LOCALDATE=″<value>″

KN}GZ_v;CN},IC|4tC DB2 Connect UZq
=/'V#bG(}T <value> 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=
5#"b 9 C Y w 5 3 * e V { “\”( 4 1 \ ),T 7 # 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 ?
<u?D PARMS VNPDZ_v;CN}#

T+}EZ8( LOCALDATE

*9UZZkP',BPwn<Xk*f

:

1. ?i Y"M M D <;\P;vrP#dP Y Gj];"
M GB];"D GUZ;#

2. Z;vrPP,Y Dns;}* 4#

3. Z;vrPP,M Dns;}* 2#

4. Z;vrPP,D Dns;}* 2#

}g,TBGyPP'DUZ

“YYyyMmDd” - Y"M M D ;GxVs!4D

“MM+DD+YYYY” - Jm_P`Z 10 vVZDZk

“abcYY+MM” - IT;P D rP

Zk:

"JmZkPP} Y"M M
D .bDV{

BPGyP^'DUZZk:

“YYYYyMMDD” - ^',r*Z;vrPPP 5 v Y

“YYYYMDDM” - ^',r*P 2 v M rP

g{UZq=Zk^',+;a"vms#xG+dvT#b
Gr*UZZkP'";b6E+9CCZk#v1BPwn

“+?”*f1,Eay]P'UZZk44PUZq=d;:

1. ;P SQL ms#

2. dvGIC`FZ ISO(ISO M

JIS)q=DUZ5#

Z 4 B |B}]b?< 29

3. dv}]xAYP 10 vVZ$#bGdv}]xDn!s

!(49;4PUZq=d;),Tc+}]5f"ZG

o#49UZq=1dZkax1YZ 10 vVZ,K*s
T;JC#

4. Z DCS ?<u?P8(KP'DUZq=Zk"RKZk
dv}]xr#

JO

,,,,,,,,BIDI=<ccsid>

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?<N}

m1.Zc?<N}

N}>} 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 ?<N}

m

2. DCS

N}>} zD5

}]b{F DB2DB

?j}]b{F NEW_YORK3

&CLrksw

N}V{. ″,,,,,,LOCALDATE=\″\″YYMMDD\″\″\″

?<N}

53}]b?<N}

m3.53}]b?<N}

N}>} zD5

}]b{F DB2DB

}]bp{ NYC3

30 DB2 Connect C'8O

m3.53}]b?<N}(x

N}>} zD5

Zc{ DB2NODE

O$ SERVER

)

T,;}]b(e`vu?

TZ?v}]b,XkZ}v?<(Zc?<"DCS ?<M53}]b?<)D?v?
<PAY(e;vu?#Z3)ivB,zI\k*}]b(e`vu?#

&m BiDi }]

}g,g{S IBM sMz}]b~qwPF2K&CLr,+G4S\K*M'z
qw73*"D&CLrD1!3d,G4zI\kTb)&CLrO* SQLCODE 3

d#z+4BP=h4PKYw:

v ZZc?<P(e;vu?#

v Z DCS ?<PC;,D}]b{F(e=vu?#TZ;vu?,ZN}V{.P

8( NOMAP#

v {C;,D}]bp{MzZ DCS ?<P8(D=v}]b{F,Z53}]b?

<P(e=vu?#

=vp{CJ,;v}]b,;vp{_P SQLCODE 3d,m;v;P SQLCODE
3d#

TB?VvJCZ z/OS ~qw#;\T DB2 IBM i f~qwtCK&\,-rGQ

a)j{ BiDi 'V#

*}7X&m;,=(OD BiDi }],BP BiDi tTGXhD:

v }VN4(ARABIC k HINDI)

v =r(RIGHT-TO-LEFT k LEFT-TO-RIGHT)

v \N(SHAPED k UNSHAPED)

v TF;;(YES r NO)

>`M(LOGICAL k VISUAL)

v D

/~

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

1Z DB2 Connect k~qwOD}]b.d;;}]1,(#GSU=Tdk}]4

P*;#,;<((#9+JCZ BiDi <Vd;,Cd;GT#CDzk3*;D9
d#;x,?0;Pwz DB2 z7'VX(Z BiDi D

rK,Q-CI!&\v?K DB2 Connect,TcT*"M=~qw}]bD}],T

0S~qw}]bPSUD}]4P BiDi <Vd;#

D}]+aTms==T>#

CCSID r BiDi <Vd;#

Z 4 B |B}]b?< 31

*9 DB2 Connect T"MA~qw}]bD}]4P BiDi <Vd;,;(*2GC
~qw}]bD BiDi CCSID#IZ~qw}]bD DCS }]b?<u?D PARMS

VNP9C BIDI N}45Vb;?D#

nCC;v>}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;*@x

P 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 <Vd;,S
CCSID 62213(BiDi V{.`M 5)d;* CCSID 62209(BiDi V{.`M 10)#

3. DB2 Connect +TdS DB2 wz}]bSU=D}]4P Bidi <Vd;,S
CCSID 62245(BiDi V{.`M 10)d;* CCSID 62213(BiDi V{.`M 5)#

32 DB2 Connect C'8O

":

1. *K9 BIDI N}z',Xk+73d?r"am5 DB2BIDI hC* YES#Xk
ZT DCS }]b?<u?xP`?D DB2 Connect $w>P

hC DB2BIDI#T
ZZ DB2 Connect ~qwD6LM'zOKPD&CLr,,yXkZCM'zO
hC DB2BIDI d?#

2. g{zk* DB2 Connect T*"M= DB2 wz}]bD}]4P<Vd;,49

z;h*2G|D CCSID,+T;h*Z DCS }]b?< PARMS VNPmS

BIDI N}#ZK

ivB,z&Ca)D CCSID MG1! DB2 wz}]b CCSID#

3. P)ivB,9C+r CCSID I\lI SQL i/>m;^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 <BK(}9CBfb)(ik)^(|}DJb,G4&
C+73d?

r"am5 DB2BIDI hC* NO#

N}V{.f6

TBG DCS N}D>}(?PG;iN}):

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 ?<u?:

DCS 1 u?:

>X}]b{F =X
?j}]b{F =Y
&CLrksw{ =
DCS N} = ,,,,,,LOCALDATE="YYMMDD"
"M =
DCS ?<"Pf6p = 0x0100

Z 4 B |B}]b?< 33

34 DB2 Connect C'8O

Z 5 B 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#

(e;)u~,Zb)u~BJmM'z&CLr 4(IE,S#

IE73

Jm}]b\m1}d{u~b9

IE, S

IT4P

;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(

m4.,SD`M!vZ;,DYwiO

z*s,SIE T=IE,S # f , S " 5 X / f

z;*s,SIE ~=IE,S #f,S

}KZC'9C,S1ZhC'Y1G+X(b,

eDu~,kNDm 4 PD\a#

K,S{O~qwTIE,S
(eDu~

K,S;{O~qwTIE,
S(eDu~

SQL20360W( SQLSTATE

01679)

~=IE,S

k#f,Sj+`

,#ZhDG+X((g{P)Z9,SIEDIE73P8(#

~=IE,SII9C DB2 Connect xP,SDNN&CLr4(#~=IE,SD
4(M9C=(k#f,S`,#bb6E;*&CLr(} DB2 Connect xP,S,

^k|D

VP&CLrDNNzk4I9C~=IE,S#

T=I E,S

TC'ZhY1G+X(D=(k~=I E,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*ZbV

ivB,}]b~qw;O$Z(j 6#+G,Z9CK&

\1,XkG#O(zD&CLr;Jm Z;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#

© Copyright IBM Corp. 1993, 2009 35

}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,S9CDJ
~=IE,Sr;fZbvJb#

":

1.

X*Bn:;a)\k4P;C'+F}}]b~qwDO$#&CLr;\Jm
P;A;P\kDZ(j6,}GC&CLrQ-i$"O$KCZ(j 6#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+z wOK

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*

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#

zXk*@ZIE73P8(D53Z(j6#IE,SD53Z(j6GZ4(

v

,S1r~qwa)Dw*C'{DZ (j6#*9zD,S ;X(IE73E
N,53Z(j6XkGZCIE73P8(DZ(j6#kzD2+T\
)P'D53Z(j6MCj6D\k#

4I\^(ME#TZ

TRUE#g{x

m1a

36 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)#

m5.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

KP#K-r;JCZ~=IE,S#

O

(} 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,SDIE

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;D
{.D8k,CV{.|,CZ(j6D\k#

1. wC SQLSetConnectAttr /}ThC SQL_ATTR_TRUSTED_CONTEXT_USERID t

T#+dhC*k*P;DZ(j6#

rc = SQLSetConnectAttr(

);
//lims

conn,
SQL_ATTR_TRUSTED_CONTEXT_USERID, newuser, SQL_NTS

73XkdC*JmP;Az*P;DZ(j6#

C'DZ(j6#Y(d? passwd G;v8rV

kqXlimsM/f,XpGmm6 PP>DG)#

m6.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(j 6D\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(

);
//lims

conn,
SQL_ATTR_TRUSTED_CONTEXT_PASSWORD, passwd, SQL_NTS

Z 5 B DB2 Connect 2+T 37

kqXlimsM/f,b)msM/fP>Zm Z 37 3Dm 6 M m 7 P#

m7.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,

m8.8>P;C''\Dms

SQLCODE ,e

SQL1046N JmKIE,SDIE73;P;dC*Jm

SQL30082N **P;ADZ(j6a)D\k;}7#

xP>zms -20361 D SQL0969N 3)}]b6p<xh9

9kqXlim 8 PPvDms#m 8 PDms8>C'P;'\#

P;=zT<P;DZ(j6#z+;\P;
=CZ(j6,1=|DKCIE73#

zP;C'#

g{C'P;'\,G4ZzI&P;Ad{C'0,,S+&Z“4,S”4,#
zITP;&Z4,S4,DIE,SDC',+;\CJCIE,SD}]b~

qw#ZzI&P;C'.0,&Z4,S4,D,S+#VC4,

#

":

1. X*a>:;a)\k4P;C'+F}}]b~qwDO$#&CL r;\Jm

P;A;P\kDZ(j6,}GC&CLrQ-i$"O$KCZ(j 6#q
r,P;C'+lI2+)4#

2. T SQL_ATTR_TRUSTED_CONTEXT_USERID tT8( NULL 5H,Z8(

7353Z(j6(4(T=IE,S19CDC'j6)#

3. 1zI&XhCKT=IE,SO SQL_ATTR_TRUSTED_CONTEXT_USERID ,
StTD5s,"4XBhCC,S#XBhCDa{g,9CC,SD-<,S

tT4(;vB,S;y#49z+,St
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*

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<Mi$

IE

TD5hC*53Z(j6"NULL rt

z#Kfr;JCZIE7353Z(j

38 DB2 Connect C'8O

":g{6LM'zP48(O$`M,G4M'z+1!* SERVER_ENCRYPT#g
{~qw;S\K`M,G4M'z+9 CS~qw5XD`&5xPXT#*Ko

zE/T\,<U*8(M'zPDO$`M,T\bzzbVnbDxgw?#

S DB2 Connect f

> 8.2.2(`1Zf> 8.1 ^)| 9)*<,xXZO$-LZd

;YG;/DNk_,xGdI;v w/G+#ZxXD}]b?<u?P8(DO
$`M2GKM'z`?DO$`M#M'z"x XM~qw<Xk8(f]`M#

g{;PZ

}]b?<u?P8(xXD`?O$`M,SERVER O$+I*yks~

qwD1!`M#+G,g{~qw;'V SERVER O$,G4TaZM'zM~q
w.dxP-L # K P*k M 'z; ,,g { ; P8(O $ ` M,M 'z1 ! *

SERVER_ENCRYPT#

g{ZM'zh

CK“hCM'z API”D DB2NODE r SQL_CONNECT_NODE !n,

G4+;9CZxX`?DO$`M #Zb`ivB,T;v^ZZM'zM~qw
.dxP-L#

DB2 Connect JmBPO$`M:

CLIENT

ZM'zPi$C'{M\k#

DATA_ENCRYPT

ZM'z/~qw(EZdTC'}]xPS\

#KO$`MZ IBM Power Sys-

tems }]b~qwO;\'V#

KERBEROS

JmM'z9C Kerberos O$4G<=~qw,x;9C+3Dj6M\ki
O#KO$`M*s~qwMM'z<&CGtCK Kerberos D#

SERVER

C'{M\kZ System z r IBM Power Systems ~qw}]bOxPi$#

SERVER_ENCRYPT

AZ SERVER O$,C'{M\kZ System zr IBM Power Systems }]
b~qwOxPi$,++MDC'j6M\kZM'zOxPS\#

SERVER_ENCRYPT_AES

+MDC'j6M\kGZM'zO9C_6S\j<(AES)S\c(S\
D,"Z System z }]b~qwOxPi$#

Kerberos O$_

P(;T,r*M'z;a+C'j6M\k1S+M=~qw#!x

z.,Kerberos d1Z}=O$zF#C'ZM'zUKPdk;Nj6M\k,

Kerberos i$KG<#;s,Kerberos T/xV2+X+C'D(^+M=yksDN
N>XMxg~qP#

bb6EC';h*XBdkC'j 6M\kMITG<6L

DB2 ~qw#Kerberos O$a)D%cG<&\*s DB2 Connect M|}Z,SD}

]b~qw<a) Kerberos 'V#

":;'V GSSPLUGIN O$`M#

Z 5 B DB2 Connect 2+T 39

Kerberos 'V

&m>%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
}d RACF

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#

®

h)a) Kerberos >%&m,|Jmwzd1 UNIX KDC#

rBf]T

qC Kerberos 'VD DB2 nM*s:

IBM }]~qwM'z:

f> 8

DB2 Connect:

f> 8

DB2 z/OS f:

f> 7

XZ z/OS 2+TDa>M<I

>wba)PX DB2 Connect ,SA DB2 z/OS f}]b~qwD2+TDa>M<

I#

®

V2R10 r z/OS V1R2 (

40 DB2 Connect C'8O

)92+TVN

7#“DB2 z/OS f)92+T”VNhC* YES#KVNvVZ DB2 z/OS f DSNTIPR

feP#

)92+Tzk

Z DB2®Universal Database™z/OS ff> 5.1 .0,a)KC'j6r\kD,Sk
sI\aZ'\1xP 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-rkT

*{CKv?&\,&C+CZ)92+TD DB2 z/OS f ZPARM 20N}D5hC

* YES#9C DB2 z/OS f20fe DSN6SYSP 4hC EXTSEC=YES#9IT9C DDF

b,9+a)(PASSWORD EXPIRED)HE"#

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\<B2+T

Jb# DB2 z/OS f}xKBDs(!n DYNAMICRULES(BIND),C!nJmZyP_

rs(LrDZ(B4P/, SQL#

DB2M DB2 Connect Z DB2CLI.INI dCD~Pa)K;vBD CLI/ODBC dCN}

CURRENTPACKAGESET#&C+|hC

*_PJ1X(D#={#Z&CLrD?v,S

.s,+T/"v SQL SET CURRENT PACKAGESET schema od#

9C“ODBC \mw”4|B DB2CLI.INI#

\k|D'V

g{C'j6D\kQ-=Z,SQL CONNECT od5X;ums{",}g:
SQLCODE -30082 -rk 1#9C DB2 Connect,IT6L|D\k#(} DRDA,
DB2 z/OS fMIT(}"vTB CONNECT od*z|D\k:

CONNECT TO <database> USER <userid> USING <password>

NEW <new_password> CONFIRM <new_password>

9IT9C“DB2 dCzV”D“|D\k”T0r4|D\k#

DB2 Connect 'VDO$`M

KwbP> DB2 Connect 'VDO$M2+ThCDwViO#

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?<u?P#

m9.P'O$=8

=8 O$hC i$

1 CLIENT M'z

2 SERVER IBM sMz}]b~qw

3 SERVER_ENCRYPT IBM sMz}]b~qw

4 KERBEROS Kerberos 2+T

5 DATA_ENCRYPT wz

6 SERVER_ENCRYPT_AES wz}]b~qw

O$`MV[

TBV[JCZOfhvD,S,"P>Zm 9 P#TBT?V=8<xPK
j8hv:

Z 5 B DB2 Connect 2+T 41

v Z=8 1 P,vZ6LM'zPi$C'{M\k#TZ>XM'z,vZ

DB2 Connect ~qwPi$C'{M\k#

C'+Z"aD;CxPO$#C'j6G(}xg"MD,+;(}xg
"M\k#v1yPM'z$w><_Pc;DIE2+

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'j

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(#

6M\kGS\D#

Th)1E9CK

42 DB2 Connect C'8O

Z 6 B 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<f"K

Z

s(D~

)s(D~D}L#

r*f DB2 Connect a)D;)5CLrG9C6k= SQL *"D,yTb)5C
LrXkHs(= IBM sMz}]b~qw,E\kC53dO9C#g{z
DB2 Connect 5CLrMSZ,G4;h*+|Gs(=?v IBM sMz}]b~q
w#ZBPD~P|,Kb)5CLryh*Ds(D~DPm:

v ddcsmvs.lst(CZ System z)

v ddcsvse.lst(CZ VSE)

v ddcsvm.lst(CZ VM)

v ddcs400.lst(CZ IBM Power Systems)

}]bCJ=8#b)CJ=8GI&CL r*"_a)D,|G|,

P,CD~GZ$`kZd4(#s(G IBM sMz}]b~qw&mb

;9C

1+b)D~PmDdP;vk

}]bxPs(#

g{20K DB2 Connect ~qwz7, DB2 Connect 5CLrXks(=?v IBM

sMz}]b~qw,EIkC53 dO9C#Y(M'z2&Z,;^)|6p,
;\f0`YM'z=

}g,g{C 10 ( Windows M'zM 10 ( AIX M'z(} Windows ~qwO

D DB2 Connect s5f,SA DB2 z/OS f,k4PBPdP;vYw:

v SdP;v Windows M'zs( ddcsmvs.lst#

v SdP;v AIX M'zs( ddcsmvs.lst#

v S DB2 Connect ~qws( ddcsmvs.lst#

>>}Y

v yPM'z<&Z,;~q6p#g{|G;&Z,;6p,G4I\h*S?v

v ~qwkM'z&Z,;~q6p#g{|G;&Z,;6p,G42h*S~q

}K DB2 Connect 5CL
Gk 9C D ?v } ]b x Ps ( #1 4 P4 s (D &CLr 1, ( #< + zz

SQL0805N ms{"#zI\k*h*s(DyP&CLr4(;v=SDs(PmD
~#

(:

X(~q6pDM'z4xPs(#

wxPs(#

(,z;hs(;N5CLr#

}]bxPs(1,+<B?v%v 5CLr<kC

r.b,d{NN9C6k= SQL D&CLr9Xkk|

TZ?v*s(AD IBM sMz

1. 7#zT IBM sMz}]b~qw\m53_Pc;D(^:

© Copyright IBM Corp. 1993, 2009 43

}]b~qw,k4PBPYw:

System z

h*D(^G:

v SYSADM r

v SYSCTRL r

v BINDADD

":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(#

M

CREATE IN COLLECTION NULLID

A) g{nuGzT

OfyP>DNN(^,M+JmzjIs(#

B) g{d{K4PKnuDs(,xz}Z4PZ~Ns(,G4z+Xk

_P SYSADM r SYSCTRL (^E\jIs(#g{z;_P BINDADD

M CREATE IN COLLECTION NULLID

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
'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

:4PKs(,xz}ZYN4Ps(,G4;*z_P

(^,G4+;JmzjIs(#

DB2 Connect m~|%@ZhCJ(),G4 NULLID C

44 DB2 Connect C'8O

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 [e-mail] 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 '{ ri j6Zh
EXECUTE X(#g{;9C bind |nD grant !n,G4Xk

pv4P 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

*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, G 4 9Cs ( Pm

db2ubind.lst

"R;8( sqlerror continue(|vZ,SA IBM sMz}]

b~qw1E P')#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,G

4I\h*+b)M'zOD5CLr

k DB2 Connect xPs(#

Z 6 B s(&CLrM5CLr(DB2 Connect) 45

46 DB2 Connect C'8O

Z 7 B `>c|B

`>c|B(2F*V<=$w%*(DUOW)M=WNd5)G;V&\,|9&
CLr\;|B`v6L}]b~q wPD}]"#$}]Dj{T#}g,f0+

JpS;vJ'*F=d{}]b~qwPDm;vJ'DxP;

ZbyD;WP,5V;vJ'OD hnYwD|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#byD
TP `Swz7D>}|( IBM TxSeries(CICS M Encina)"IBM Message and Queu-
ing 5P"IBM Component Broker 5P"IBM San Francisco Project T0 Microsoft
Transaction Server(MTS)"

vZG9C>z SQL `>c|B,9G9C TP `Sw`>c|B#

>z SQL M TP `Sw`>c|BLr<Xk9C CONNECT 2 SYNCPOINT TWOPHASE
!n4xP$`k#~_<IT9C SQL Connect od48>k*Dv}]bCZf

sD SQL

SU xa_open wCT("}]b,SD DB2 y8>D),G4+9C DB2 m~4-
wCBq#

W#

#

BEA Tuxedo M8vd{z7#20*swP;,,b!

od#g{;PNN TP `Swf_ DB2 |+-wBq(gS TP `Sw

19C TP `Sw`>c|B1,&CLrXk(}9C TP `SwD API 4ksd
5rXv,}

SQL `>c|B1,Xk9C}#D SQL COMMIT M ROLLBACK#

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 <
w%*(DUOW)#?0,BP DB2 ~qwa)K DUOW 'V,9Cb)~qw\

;NkV<=Bq:

v DB2 Linux f"UNIX fM Windows ff> 8 r|_f>

v DB2 z/OS ff> 7 r|_f>

v DB2 IBM i f

;vV<=BqIT|B\'VD}]
vBqP,1|B Windows OD DB2 }]b"DB2 z/OS f}]bM DB2 i f}]

bPDtIm#

g CICS SYNCPOINT" Encina Abort() M MTS SetAbort()#19C>z

=BqD?v}]b<Xk\;'VV< =$

b~qwDNbiO#}g,&CLrI Z%

© Copyright IBM Corp. 1993, 2009 47

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

G48(Bq\mw}]b#

7. %wjI#

9CXFPDbT`>c|B

#g{;P9C TP `Sw,

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

=r4%(> M >>)Z!qDPmrPFxMFv!q#9IT(}Z!qDPm
rP1S`-!qDC'j6M\k4|D|G#

3. 1zjI!q1,%w7(# “`>c|BbTa{”0Zr*#

4. “`>c|Bb

0Z+T>'\D}]bD SQL zkMms{"#%wXUTXUC0Z#

5. %wXUTXU“bT`>c|B”0Z#

`>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
h*9C SPM D=8D\a#Cm9T>,S Intel
xPNNCJ1,Gqh* DB2 Connect#TZ`>c|B,g{}Z9C TP `S

w,G4 DB2 Connect D SPM i~GXhD#

#IT9CPdD

Ta{”0ZT>y!qD}]bD)|BbTI&,D)'\#C

!vZ-iD!q(TCP/IP)T0 TP `SwD9C#Bma)K

®

r UNIX zwT IBM sMz

48 DB2 Connect C'8O

m

10.

h*

SPM – TCP/IP

Gq 9 CB q& m w
`Sw?

GG

qq

D`>c|B=8

Gq h *, =c \ mw?Xh D z7 (! q ;n)\'VD IBM sMz

DB2 Connect ~qw

z7

&C DB2 Connect m

I$D DB2 s5~

qwf

DB2 Connect vKf

}]b

DB2 z/OS f V7

DB2 z/OS f V8 r

|_f>

DB2 z/OS

f V7

":;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=

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{

ND TP `SwDD5#

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

h:

DB2 Connect ~qw

z7

&C DB2 Connect m

I$D DB2 s5~

qwf

.T) TP `Sw9CDE",

+ XA 'V#

DB2 z/OS f V8 r

|_f>

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{D

de#

g{*9C TCP/IP ,SA DB2 z/OS f,G4z;X|DNN1!hC#ZKi

vB,;h*NN SPM dC,-rG|Q-GIYwD#

Z 7 B `>c|B 49

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&\

V'}pDx(,1r@x#

u!0Z,ZC0ZP,V<=BqD; vV'v=I,;+VBqZm;v

50 DB2 Connect C'8O

Z 8 B 9C DB2 Connect 4F/}]

g{z}Z4SD73P$w,ZC 73P,h*Zwz}]b53k$w>.dF

/}],G4IT9C DB2 Connect,bGwzk}]b.dD}]+dxX(kND
< 8)#

<8.(}

DB2 D export M import 5CLrJmZ IBM sMz~qw}]bk DB2 Connect

$w>

CLrrX5}]b\m53P9CC}]#}g,IT+}]S IBM sMz~qw
}]b<v= PC/IXF D~P,;s<k= DB2 }]b Linux f"UNIX fM Win-
dows f}]

ITS}]bM'zr DB2 Connect $w>4P<vM<kYw#

":

1. *<vr<kD}]XkkJCZb=V}]bDs!M}]`M^F`{#

2. *Ka_<kT\,IT9C4Oi/#Z import 5CLrP8( compound D~

TZ DB2 Connect 45,<vM<kYwXk{OBPu~:

v D~`MXkG PC/IXF#

© Copyright IBM Corp. 1993, 2009 51

DB2 Connect

ODD~.dF/}]#;s,IT ZNNd{'VbV<vr<kq=D&

bP#

`M^N{T+8(}?D

d#

xP<k/<v

i/odViIi#bIT5Mxg*z"uLl&1

v XkHZ?j~qwO4(tTk}]f]D?jm,;sE\+C}]<kd

P#IT9C db2look 5CLr4q!4mtT#Z(} DB2 Connect xP<k1,
IZ;'V INSERT !n,yT;\4(m#

g{;{ONNu~,Ywa'\"5Xms{"#

":<v1;af"w}(e,<k12;a9CC(e#

g{<vr<klO}](H|,% VZ}]2|,+VZ}]DP),k<GBP

Bn:

™

v Z9C EBCDIC 4f"}]D53(MVS

" System z" IBM Power Systems"VM

M VSE)O,shift-out M shift-in V{jG+VZ}]D*<kax#Z(e}]b
mDP$H1,qX*b)V{$tc;DUd#

v }GP}]P;BD#=,qr(i9Cd$V{P#

+}]S$w>FAwz~qw

*+}]F

Awzr System i ~qw}]b:

1. + DB2 mPD}]<vA PC/IXF D~

2. 9C INSERT !n,+ PC/IXF D~<k=wz~qw}]bPf]DmP#

*+}]Swz~qw}]bFA$w>:

1. +wz~qw}]bmPD}]<v= PC/IXF D~#

2. + PC/IXF D~<k

= DB2 mP#

>}

TB>}5wgN+}]S$w>FAwzr_ System i ~qw}]b#

(}"vTB|n,+}]<v= IXF q=Db?D~P:

db2 export to staff.ixf of ixf select * from userid.staff

"vTB|nTcT?j DB2 }]b(" DRDA ,S:

db2 connect to cbc664 user admin using xxx

g{?jm;fZ,G4Z?j DB2 }]b5}O4(?jm:

CREATE TABLE mydb.staff (ID SMALLINT NOT NULL, NAME VARCHAR(9),

DEPT SMALLINT, JOB CHAR(5), YEARS SMALLINT, SALARY DECIMAL(7,2),
COMM DECIMAL(7,2))

52 DB2 Connect C'8O

*<k}],k"vTB|n:

db2 import from staff.ixf of ixf insert into mydb.staff

b+S IXF q=DD~PA!?;}]P,"R+"v SQL INSERT odT+CPe
k= mydb.staff mP#+Vx;P;PXek}],1=+yP}]<Fk?jm*

9#

®

IBM Redbooks

vfo“Moving Data Across the DB2 Family”Pa)Kj8E"#IT

ZTB URL ;CPR=Kl$ivfo:http://www.redbooks.ibm.com/redbooks/
SG246905#

Z 9 B SQLCODE 3d

;,D IBM X5}]bz7TZ`FDms";\GzI`,D SQLCODE#49
SQLCODE `,,|2I\=xT;,= =8(DjG#jGPm+M= SQLCA D
SQLERRMC VNP#1!ivB, DB2 Connect +?v IBM sMz}]b~qwD
SQLCODE MjG3d*`&D DB2 SQLCODE#

g{k

g{S IBM sMz}]b~qw(g DB2 z/OS f)1SF2&CLr,G4zI\

h*O* SQLCODE 3d# b + Jmz 9 C C&CLr , x ;|D|y}C D
SQLCODE#

O* SQLCODE 3d

g{k*O* SQLCODE 3d,kZ DCS ?<DN}V{.P8( NOMAP#

g{S IBM sMz}]b~qw(g DB2 z/OS f)1SF2&CLr,G4zI\

h*O* SQLCODE 3d# b + Jmz 9 C C&CLr , x ;|D|y}C D
SQLCODE#

w{ SQLCODE 3d

1!ivB, DB2 Connect +?v IBM sMz}]b~qwD SQLCODE MjG3
d*`&D DB2 SQLCODE#BPD~G1! SQLCODE 3dD1>:

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#

*O* SQLCODE 3d,G4kZ DCS ?<DN}V{.P8( NOMAP#

TZ Linux r UNIX Yw53OD DB2,;h*xP3d#

1. g{

2. Z“DCS ?<”DN}V{.P8(BD SQLCODE 3dD~DD~{#

3. ?v3dD~<G ASCII kD~,|GG(}9C ASCII `-w44(M`-D#

© Copyright IBM Corp. 1993, 2009 53

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-

Znu201,CD~f"Z2076D map ?<P#

CD~IT|,BPXb`MD

&& D~D_-*7#ZZ ; N v V && .0DyPP;O*GTIq=D"

M, + ;v T#g { Z && .s D~ P; PN NZ ], G4; 4 P
SQLCODE 3d#z9ITC NOMAP N}4O* SQLCODE 3d,g0
fyv#

* w*;PPDZ;vV{,m>

<D SQLCODE 3d#

P:

CPG"M#

W w*;PPD(;V{,m>/fj>&CXBxP3d#1!ivB,

+M-<D/fj>#W Xks4#

&& .sDd{yPPXk*UWrICBPq=D3dod:

input_code [, output_code [, token_list]]

input_code m>BPdP;n:

sqlcode

4T IBM sMz}]b~qwD SQLCODE#

U yP4(eD:D SQLCODE(ZKD~P4P>DG)5);3d*8(

D output_code#g{ZKPP;P8( output_code, G49C-<D

SQLCODE#KV{Xks4#

P yP4(eD}D SQLCODE(ZK

D~P4P>DG)5);3d*8(

D output_code#g{ZKPP;P8( output_code, G49C-<D

SQLCODE#KV{Xks4#

ccnn 4T IBM sMz}]b~qwD SQLSTATE `zk#nn *BPdP;

n:

00 ;OqDI&jI

01 /f

02 ^}]

21 y}%}

22 }

]l#

23 <x%}

24 Nj4,^'

26 SQL odj6^'

40 BqXv

42 CJ%}

51 &CLr4,^'

55 Ts4&ZHvu~4,

54 DB2 Connect C'8O

56 d{ SQL rz7ms

57 J4;ICrYw1ik

58 53ms

8(D output_code CZ3dD~P4T=8(D _PK`zkDy

P

SQLCODE#g{ZKPP;P8( output_code,G4-<D SQLCODE 3

d*|>m"R;4FjG#

V{ cc Xk!4#

g{Z 3 d D~ P `Nv V ,; input_code,G49C Z ;v v V Dz k #
output_code m >dv SQLCODE#g{ ; P8 ( NN 5 ,G 4 9C - < D

SQLCODE#

g{z8(K

dvzk,G49IT8(BPdP;n:

(s) dk SQLCODE 0z7j6(ARI"DSN r QSQ)+Ek SQLCA {"

jGVNP#

-<D SQLCODE G5XD(;jG#K!n;hFC4&m4(eD
SQLCODE,+ +965 M -969 }b#g{ +965 r -969 G output_code,
G4 Z SQLCA D SQLERRMC V NP 5X D jG P m|( -<
SQLCODE,sSz7j6,Y

sS-<jGPm#

V{ s Xk!4#

(token-list)

jGP m,I:EV*#;8(;v:EITx }X(DjG#}g,q
=(,t2,,t4)b6EZ;vMZ}vdvjGGUD#

?vjG<_P}Vq=(n),I!qZd0fmS c,2IT

!qsS c

r i#dbMgB:

c K;CPjGD}]`M* CHAR(1!5)#g{ c Z n D0

f,G4m>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+` v j G E,Sp 4 , IT+` v j GEiO I

;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#

Z 56 3D< 9 T>;vy> SQLCODE 3d

D~#

Z 9 B SQLCODE 3d 55

&&

-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~

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+NNjGEk

SQLCA P#

dv

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~v

jG<G CHAR#b=vdkjG;iOI;v CHAR dvjG,Cdv

jG+G SQLCA PDZ;vdvjG#

5. SQLCODE GS -633 3dA -206#S IBM sMz}]b~qwSU=DZ;v

dkjGG CHAR#|;*;* INTEGER "RZdv SQLCA P;CwZ~vj
G#dv SQLCA PDZ

;vjGGUD,r*|GI;v:E48>D#

6. SQLCODE GS -30021 3dA -30021#S IBM sMz}]b~qwSU=DZ

;vMZ~vdkjG<G CHAR,"R+|GCwdv SQLCA PDZ;vMZ
~vjG#

7. Z SQLCA P,SQLSTATE * 00 `DyP SQLCODE <+;3d* SQLCODE

#

+000

8. yP4(eD SQLCODE <;3d* -969#v1P>KyPI3dDzk(|(G

)j+`,x;h*3dDyPzk),E&C9CK!n#(s) !n8>:Z

SQLCA D SQLERRMC VNP*5XDjGPm|(-< SQLCODE,sS"z
KmsDz7,YsS-

<jGPm#g{;|( U u?,G4+MyP4P>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-<jGPm#g{;|( P u?,G4+MyP4P>D

}zk1,+;xPNN3d#

56 DB2 Connect C'8O

Z 10 B }]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 `XjG(CRRTKN),CZ;\#$DT0#

v $w%*j6(UOWID),CZ\“DRDA-3 ,=c\mw”(Z TCP/IP ,SO9C

1)#$

v DB2 Connect ,Sj6(&CLrj6)#

KE"T>Dv DB2 Connect ,S<BKCJb,|Jm53\m1?F4P53P
D%vM'z&CLr,x;a0l9CC DB2 Connect ,SDd{M'z#

D=WN,S#

P>`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$_.;,|C<N4m>53T\#I

T!q`SwV53"}]bMk(EPXDn"Z<Nm>(P,13d|G#

}g,(}9C`

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,ZB<P,8v DB2 b?5}Zk CPU 9CJxPTU"T<N==m>v
4#T<mN=m>D5D/O;#fZD~ db2chart.pmc P#zIT#fNb`v

PMC D~,?vD~43;,D53T\Xf#

Sw,MITC51<ND==4T>(} GET SNAPSHOT FOR

#

© Copyright IBM Corp. 1993, 2009 57

<

10.

T\`Sw

*tC>X&CLrD`S,+h*XU DB2CONNECT_IN_APP_PROCESS 73d?#

9C GET SNAPSHOT |n

DB2 `Sw,$X*D53E"DKPjG#ZNN1r<IT(}"v GET SNAP-
SHOT | n4 q!5 3 4,D \a #g {z T*` SD }] b\ mw5 } _P
SYSMAINT"SYSCTRL r SYSADM (^,G4zITq!`SlU#

58 DB2 Connect C'8O

PevlU|nIC4`S DCS E"#|

GG:

v GET SNAPSHOT FOR ALL DCS DATABASES

v GET SNAPSHOT FOR ALL DCS APPLICATIONS

v GET SNAPSHOT FOR DCS APPLICATION ...

v GET SNAPSHOT FOR DCS DATABASE ON db_alias

v GET SNAPSHOT FOR DCS APPLICATIONS ON db_alias

?vlU|n<+zI;vXZzyksDlrDj8(f#

}g,"v GET SNAPSHOT FOR DCS DATABASE ON DCSDB 1+zIBP(f:

DCS }]blU

DCS }]b{F = DCSDB

wz}]b{F = GILROY
Wv}]b,SD1dAG = 12-15-2001 10:28:24.596495

nBD,SyC1d = 0.950561
nB-}D,SVx1d = 0.000000

wzl&1d(sec.ms) = 0.000000

ON4;1dAG =

"TD SQL od} =2
"TDd5od} =1

"TDXvod} =0

'\DodYw} =0

xX,SD\} =1
10DxX,S} =1
H}wz&pDxX,S =0
H}M'zksDxX,S =1
kwzDxX(Ems =0

ON"z(EmsD1dAG = None
xX,S}D_.;jG =1

!qDP} =0

Q"MDv>VZ} = 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<j6 = smith

wz&CLrj
rE = 0000

xXPD}]bp{ = MVSDB
DCS }]b{F = DCSDB

wz}]b{F = GILROY
wz"Pf6p = DSN05012
wz CCSID = 500

6 = G9150F74.B6A5.991215152825

v>(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;1dA
!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

G =

=

Z 10 B }]b53`SM DB2 Connect 59

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

w

zl&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;,#

m

11.

yZwzf>M

=8 &CLrj6q=

M'z9CMZf> 7
D RDB \mw6p'

VCJ}]~qw

M'z(} TCP/IP V4

9C RDB \mw6p

'V 8 r|_6pC

J}]~qw

M'z(} TCP/IP V6

9C RDB \mw6p

'V 8 r|_6pC

J}]~qw

TCP/IP

G91A0D3A.P8BC.060306212019

9.26.13.61.65289.060306213816

2002:91a:519:13:209:6bff:fe14:4fbb.7684.060306213741

'V6pD&CLrj6q=

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":

60 DB2 Connect C'8O

O$j6 &CLr{ &CLr wz&CLrj6

------- ---------------- ------ ---------------------------------------------------­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

dz

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",|(:

O$j6 &CLr{ &CLr M'z&CLrj6

------------------------------ -------------------- ---------- ---------------------------------------------------­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

----- -------------------- -------­00001 MEXICO DSN08015

M'z&CLrj6

dz

f>

(;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#

Z 10 B }]b53`SM DB2 Connect 61

M'zrE(Seq#)

M'zrEMGBqrE#IC|4+V<Z;,53PDBqX*p4#

M'z}]bp{

I*,SA}]bD&CLra)D}]bp{#K*XIC4j6&CLr

}ZCJD5J}]b#K{Fk}]b{F.dD3
cM}]b\mw~qwZcOD}]b?<4jI#

M'z NNAME(Zc)

j6}Z4PM'z&CLrDZc#KE"f}Z9CDM'z-iD;,

xPy;,#TZ(} TCP/IP ,SDM'z,bGwz{#

dI(}9CM'zZ

M'zz7j6(

}ZM'zOKPDz7Mf>#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 Universal Database M DB2 Connect z

70dM'z#

v SQL08020,m>f> 8.2 D DB2 Universal Database M DB2 Connect z

70dM'z#

v SQL09120,m>f> 9.1 D DB2 z7f> 9.1" DB2 Connect z

M'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{&C

XITozzV/*;S&CLr+MD}]" (}}]b53`Sw4T
>#}g,IT9C|4oz*;“&CLr{”#

v>rE

bm>v>rE#IC|49;

M'z)

70d

Lrzk3kKP}]b53`SwyCDzk3;,,Kzk3*

,53ODBq`X#

62 DB2 Connect C'8O

wz}]b{F

&CLry,SAD}]bDf5{F# Z DCS ?<P,bG

#

F

wzz7j6

}Z~qwOKPDz7Mf>#dq=* PPPVVRRM,dP:

PPP j6 IBM sMz}]b~qwz7(}g,TZ DB2 z/OS f,*

VV m>=;f>E,}g,08#

RR m>=

M m>%V{D^D6p(0-9 r A-Z)#

?j}]b{

DSN;TZ DB2 ~qw VSE M VM f,* ARI;r_TZ DB2
IBM i f,* QSQ)

;"PfE,}g,01#

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'zG

v M'z&CLrDxLj6

v xXPD}]bp{

v DCS }]b{F

VP|n!n4.==r4P>VN ,?v&CLrP>;P,B!n491=r4
P>VN,?PP>;vVN#

TBG|nDBo(:

LIST DCS APPLICATIONS [SHOW DETAIL | EXTENDED ]

<j6

xTBG9CBD EXTENDED !n1,K|nyzIDy>dv:

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&CLrDx
M'zG<j6 = ISAYYID

wz&CLrj6 = G91A0D3A.P982.060306214231
rE = 00001

xXPD}]bp{ = MDB
DCS }]b{F = MDB

wz}]b{F = MEXICO

wz"Pf6p = DSN08015

wz CCSID = 1208

Lj6 = 1192

&CLr4,VN|,BP}v5.;:

1. ,S]R - v>#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#

Z 10 B }]b53`SM DB2 Connect 63

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(4(T
sD,$"!5/(Dh*#T!5 /(Dl&YwITw*KPM#fN=i4r

a;#

DB2 z/OS fKP4v`SwEv

Z z/OS 53O,DB2 z/OS fKP4v`Sww**`SD?v DB2 S53DNq
r}]2miD(CI1t/#

DB2 z/OS fKP4v`Sw4_TP(eD$(1dM1ddt%"TTs,$_T
D@@#Ts,$_TG9C DB2 XFPDD“4(Ts,$_
@@_TZd,<akTZTs,$ _TPhCDP5liCZ(i,$Du~,T

7 ( G q h * x P T s , $ ( 4 , G q h *

COPY"REORG"RUNSTATS"STOSPACE"ALTER TABLESPACE r ALTER
INDEX),"ZJ11j6mUd"w}Mf"wiTsD\^4

{Z@@_TZdTs;j6*&Z/( 4,,G4a(}gSJ~X7M0tzE
k(*_TKP4v/(*5K#ZXFPDP(eK?v DB2 S53DKP4v/

(*5KPm,"IZCPDPxP\m#

T”r<4(D#?N

,(g CHKP)#g

nuIK

C1dmlU47(%"_T@@D 1d#K1dmlU4KP4v`Swt/1r
KP4v`SwSU"B|n18( D"B1d"B#"B1dm1,K

w+aqCT_TD@@1dmywDNN|D#

IVp9C MVS 53D START M STOP |nSXF(t/M#9KP4v`Sw#

20w5 DSNTIJHM +y >`?D }L (DSNHMONP)M y>`? D}L
(DSNHMONA)ECZ}LbP,dP DSNHMONP CZt/;v DB2 KP4v
Sw,x DSNHMONA CZZ MVS 53r Parallel Sysplex

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`S

@@*<M_T@@ax1G<u?#U>u?#t 7 l,7 lsaSmP+d>}#
I9C DSNTIJCC 20w5TKm4(D DB2 S< DSNACC.HM_ALERT_PO_EV 4

T>yPO;N@@|z4I&D_T#

P4v`SwZt/1zI_TD@ @1dmDlU,KP4v`Sw9C

P4v`S

®

Zt/`v DB2 KP

w%"D_T@@G<Z DSNACC.HM_EVAL_LOG mP# Z_T

`

64 DB2 Connect C'8O

t/"#9M"B DB2 z/OS fKP4v`Sw

Z z/OS 53O,DB2 z/OS fKP4v`Sww**`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#

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, Xk 9 C * `S D S53 Pm 4n d DSNHMONA } L P8(D

HMONPARM }]/#Q`?D}LM}]/I DSNTIJHM 20w54(#

"B DB2 KP4v`SwC47(%"_T@@D1dD_T@@1dmlU,

v *

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 10 B }]b53`SM DB2 Connect 65

}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/(T sD(iYw,"zI4Pb)(iYwD

JCL w5#

TBo(<T>K

CZwC 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</dkwd?DU8>
{#

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

v 2 - a;CZ4PT/(Ts(iDYwD JCL w

5,"+Cw5ECZRpSP

P

v 3 - +T/(Ts(iDYw#f*bI1PD JCL w5



66 DB2 Connect C'8O

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

CR - h*D COPY

v

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

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 ;D w 5D { F# jobname G ` M*
VARCHAR(8) DdvN}#

jcl-proc-time

8(Q&m1dks#jcl-proc-time G`M* TIMESTAMP DdvN}#

last-statement

1 DSNACCHR 5XOX

ms(5Xk 12)1,KVN|,"zCms14PD SQL

od#last-statement G`M* VARCHAR(2500) DdvN}#

Z 10 B }]b53`SM DB2 Connect 67

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
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

P{ }]`M hv

JCLSEQNO INTEGER

JCLSTMT VARCHAR(80) 8( JCL od

a{/q=

i4KP4v/(**

HEALTH_OVERVIEW /}T DB2 mDN=5XKP4v/(\a VSAM KSDS }
]/PDE"#K}]/I DSNTIJHM 20w54(#

“KP4v/(\a”}]/|,PXH0r1020D?v DB2 S53D DB2 KP
4v`SwM/(\a3FE"DE",b) DB2 53IC MVS

CODKP4v`Sw`S#b)E"+5X=M'z,dPP;P|,?v DB2 S
53M/((i#

|,ms{"(|(Qq=/

mPDrE(1,...,n)

53r"P534

68 DB2 Connect C'8O

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<r{#bG`M* VARCHAR(255) DP#

summary-stats

g{ health-ind G“HM”,G4m> DB2 KP4v`SwD4,#I\D5|(:

v 0 m>4t/KP

4v`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 -

}#

1 health-ind *“HM”1,alert-state <U* 0#bG`M* INTEGER DP#

K/}Db?Lr{* HEALTH_OVERVIEW,X({F* DSNACC.DSNACCHO#K
/}I DSNTIJCC 20w54(#

>}:iR DB2 S53“ABCD”Ph* COPY D/(Ts\}:

SELECT SUMMARYSTATS FROM TABLE (DSNACC.HEALTH_OVERVIEW()) AS T

WHERE DB2SSID = 'ABCD'

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

AND HEALTHIND = 'CR';

DB2 Tb)/(Tsf"bm4(Km`S<#S<M/(Tsf"bm

I DSNTIJCC

20w54(#Z 70 3Dm 13 P>K(e?vS<ykTDmT0S<hv#yPS

Z 10 B }]b53`SM DB2 Connect 69

<{Mm{<_P^(J DSNACC#

m

13.

KP4v/(TsDS<

S<{ ykTDm S<hv

HM_ALERT_TS_RS HM_MAINT_TS T>&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

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

T>d)9}]i,vKC'8(^FDyP
w}

70 DB2 Connect C'8O

Z 3 ?V _ICTM DB2 Connect

TZ9C DB2 ConnectD73PD_ICT,P;)X(D"bBn#g{xgPD}
]b~qwIZ3v-rx;IC,G4 X*DG+M'z$w>XB7I=xgP
m;}]b~qwD\&#

© Copyright IBM Corp. 1993, 2009 71

72 DB2 Connect C'8O

Z 11 B wz}]b,SD_ICTM:Xyb

Z1qE"<uP!,PX}]D41I CTDhs\s#XkzcKhs,E\9
+>kdTV:y"#VVxDv$#1q\` Web"gSLqMgSmq&CLrh

*Ts5}]xPCJ#rKXk("k IBM sMz}]bDI?"lYM
S#K,SXk?\ 7 l?l 24 !1<IC"R\;&mYg:Xu~BD_,Sh
s#gNE\9(K,SX?

_ICT=8

;v+>aPZ 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#

2+D,

<

11.

y>xg=8

*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`X4Si4PX9

v=8Dj8E"#

© Copyright IBM Corp. 1993, 2009 73

C DB2 Connect MM'zT/XB7I&\Db

74 DB2 Connect C'8O

Z 12 B M'zT/XB7IDhvMhC(DB2 Connect)

M'zT/XB7I&\Dw*?jG9 IBM }]~qwM'z&CLr\;V4(
E,Tc&CLrITLx$w,"+P OuAnM#K{<e,'V,xYwDK
DZZXB7I#+G;PfZH,ZM 'z, SD8C;C1,E\xPX
I#ZG DB2 Connect _ICT73P,(#(}wV&\(}g,_ICT/:`

&mw(HACMP

qwk8C DB2 ~qw.d,=#

+G,TZ DB2 Connect ~qw,r*;*s9>X}]b,=,yT;h*7#-
<M8C DB2 Connect ~qw4TB==T?j IBM sMz}]bxP`?,4I
9Cj+`,D}]bp{TdxPCJ#

":Z DB2 Connect ~qw73P,IT8(8C DB2 Connect ~qwTcZM'z
k DB2 Connect ~qw.dtCT/XB7I#*Z DB2 Connect vKr~qwz7
k IBM sMz}]b~qw.dxPXB7I,6L~qwXk*T

v8CX7#TZ DB2 z/OS f,g{}]bG[O53}]2m73,G4a*@`
vX7#

g{tCK[O53'V,G4ITZ DB2 Connect kwz}]b~qw.ddC[
O53DXB7I&\#[O53DXB7I&\G;
DB2 Connect Z-<I1(E'\sT[O53iDd{I1XT,S#;h*Z}]

b?<PT8C~qwxP`?,4IZ DB2 Connect OtC[O53DXB7I&
\#1!ivB,g{tCK[O53' V,G4MtCK[O5
\#

™

)r_ICTVQV4(HADR))9*CJD}]bZ-< DB2 ~

:a);vr`

V DB2 Connect &\,|Jm

3DXB7I&

B7

*9 IBM }]~qwM'z\;9CM'zT/XB7I&\V4k DB2 Connect ~
qwD(E,XkZ(E'\08(8C DB2 Connect ~qwD;C#9C UPDATE

ALTERNATE SERVER FOR DATABASE |n4(eX( IBM sMz}]bD8C
DB2 Connect ~qwD;C#8Cwz{MKZ

Ew*|nD;?Va)#C;Cf"

Z DB2 Connect ~qwOD53}]b?<D~P#*K7#8(D8C DB2 Con-
nect ~qw;CJCZyPM'zDK}]b,XkZ DB2 Connect ~qwK8(8

C~qw;C#g{ZM'z5}PhCK;C,G4avT8C

~qw#

}g,Y(Z DB2 Connect ~qw S1(wz{* db2conn1,KZE* 122)O9C
}]bp{ db1 T IBM sMz}]bxP`?#}]b\m1#{ZKZE* 123 D

wz{ db2conn2O8(8C DB2 Connect ~qw S2#TBG}]b\m1*Z DB2
Connect ~qw S1 OKPD|

db2 update alternate server for database db1 using hostname db2conn2 port 123

n:

Z DB2 Connect ~qw S1 O*}]bp{ db1 8(K8C DB2 Connect ~qw;
Cs,8C~qw;CE"+w*,S}LP5XA IBM }]~qwM'z#g{I

ZNN-r((#G(Ems,g SQL zk -30081 r SQL zk -1224)x<B IBM
}]~qwM'zk DB2 Connect ~qw S1

.dD(E'\,G4 IBM }]~q

wM'z+"T(}-< DB2 Connect ~qw(S1)r8C DB2 Connect ~qw(S2)
XB,SA db1(Zb=v~qw.d;f"T)#=N"T.dD1ddtnu\L,
;sf?N"Tp%v$#

© Copyright IBM Corp. 1993, 2009 75

;),SI&,Ma5X SQL zk -30108,T8>(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?<u?PD8C~qw,SE"I\adClR#*9

nM,k<GZ53}]b?<P`?=vu?4m>,; 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#;

1,vZZfP,$E""Rb)E"ZxLU91+a*'#

P;v8C~qw4kEL#fZ`v8C~qwrn/~qw

lRLH5A

<(

76 DB2 Connect C'8O

Z 13 B dCM'zT/XB7IT+dkM'z,SV"w<u
dO9C

Zw}]b~qwvVJO1,V"wrVIw<u(g WebSphere EdgeServer)a+
M'z&CLrXB,SksV"A;iQ(eD53#g{*+V"w<uk DB2 M
'zT/XB7IdO9C,G4Xk+V"w>mj6* DB2 M'zT/XB7I

D8C~qw#

TZ`FBfD73P9CV"w<u:

I

M'z —> V"w<u —>(DB2 Connect ~qw 1 r DB2 Connect ~qw 2)—>

DB2 z/OS

dP:

v V"w<ui~_P TCP/IP wz{ DThostname

v DB2 Connect ~qw 1 _P TCP/IP wz{ GWYhostname1

v DB2 Connect ~qw 2 _P TCP/IP wz{ GWYhostname2

v DB2 z/OS ~qw_P TCP/IP wz{ zOShostname

M'zG9C DThostname 4

Connect ~ qw #S kV"w <u MI Tv ( G9C GWYhostname1 9G
GWYhostname2#;)wvKv(,M'zMIkb=v DB2 Connect xXDdP;

vxXxP1SWSV,S#;)ky!qD DB2 Connect ~qw("KWSV,S,

M("KM'zA DB2 Connect ~qw,C~qwA DB2 z/OS DdM,S#

z

}g,Y(V"w!q GWYhostname2#b+zITB73:

M'z —> DB2 Connect ~qw 2 —> DB2 z/OS

g{"zNN(EJO,V"w;aXT NN,S#g{kZbyD73PT}]b
tCM'zT/XB7I&\,G4&
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,1 w*w~qwM8C~qwDiv
TM'z,S#K!nJmz9C DB2 M'zT/XB7I&\4iOM,$V"w

&\#+8C~qwhC*}KV"ww z{TbDwzT;a*M'za)M'z

T/XB7I&\#+G,M'z+kQ (eD8C~qw("1S,S,Sx
CV"w<u,bM{}KV"w0dyx4D[5#

M'zT/XB7I&\9XBP SQL zk:

v sqlcode -20157

v sqlcode -1768(-rk =7)

xP`?D,Tc{CV"w<u4CJNN;v DB2

+ DB2 Connect ~qw(DB2 Connect ~qw

BX

49

":g{“TCP Keepalive”Yw53dCN}DhC+_,G4I\^(+WSVJO0
1(*M'zXB7I#("b,KdC

© Copyright IBM Corp. 1993, 2009 77

N}D{Ff=(xDd#)

78 DB2 Connect C'8O

Z 4 ?V w{M DB2 Connect

1<GT\Jb1,9C DB2 Connect 4F/M'z$w>M}]b~qw.dD}
]ksMl&D}]b73_PXpD"bB n#P8VCZZ73Pa_r,VT

\D=(#

© Copyright IBM Corp. 1993, 2009 79

80 DB2 Connect C'8O

Z 14 B DB2 Connect T\"bBn

T\

GFcz53Zx($w:XDiv BDP*==#|\ICJ40J4D9C

==M2m==D0l#g{k*DxT\,XkWHv(T\D,e#

zI!qm`;,D

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#

T\8j

,|(:

}]w

< 12 T>}](} DB2 Connect Z IBM sMz}]b~qwk$w>.dw/D7
6#

<

12. DB2 Connect

© Copyright IBM Corp. 1993, 2009 81

PD}]w

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\a<BT\Jb#

v xg|(gBiO"xg/_w

2~SZ B IT*(EXFw(}g 3745 r 3172)r IBM Power Systems ~q
wDnF7Jdw#Zxg2~SZ A k B .dIf0`V+diJ#

v xg2~SZ A I*nF7"T+x**"d{ LAN Jd

-iDJdw#

v DB2 Connect M(ES53 A (#;Z,;53O#TZKV[6',Y(&CL

r2Z,;53O#

"(E_7"*XMd{(EXFw#}g,xg

wr_'V SDLC r X.25

?1

BqLB?k53PYHn}Di~PX #g{"VfZT\?1,(#I(}|D
dCN}"*PJbDi~Vd|` J4"}6Ci~rmSBi~TV#3)$w

4:bbvJb#

I9CwV$_47(i/(Z?v i~OD1
i~TDxT\#}g,g{7(Z DB2 Connect zwPi/yC1d<\1dD

60%,G4zI\k*w{ DB2 Connect r(g{z_P6LM'z)+m;v DB2
Connect zwmSAxg#

d#baCzKb&w{r}6D)

F(y<

F(y <

#D73PKPbT&CLr4*<#r *T\JbD6'u!K,yTI*"(E
DbTC}4^FbTM[lD&\DwCr#

F(y<;X+4S#(EDb

"#Tr%Db?*<RvZPQU1Evs4SLH#

<Cy<DXw:

v ?NbT<GIX4D#

v bTD?NX4<GZ&Z,;534,DivB*<D#

v CZF(y<D2

v }G=8|(53P4PDd{n/,qr,}K;b?D&\r&CLrb,;

+;v73PDT\km;v73P DT\xPHO#F(y<I(}Z}

TC};h*#B{v&CLrMIqC P[5DE

~Mm~kzDzz73`%d#

Pd{n/D&\r&CLr#

":49yt/D&CLr;n!/r*UP1,|G<a9CZf#bI\a<

B"zw3M

y<a{'f#

82 DB2 Connect C'8O

T\$_

BmP>K;)$_,|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 (fM 6pDxg3FE",

|(g?kSU=DE"|r

!D}?.`D TCP/IP 3F

E"#

xgXFw,g 3745 NetView

®

Performance Monitor (f(EXFM VTAM®D9

CJ#

Linux M UNIX netstat &m TCP/IP w?#

Z 14 B DB2 Connect T\ 83

84 DB2 Connect C'8O

Z 15 B E/ ODBC CJ

DB2 }]ba)<Z(} ODBC Dx(ET\DXbE/\&#b)v?&\ICZ
Microsoft Access"Lotus Approach®r Visual Basic#(}9C DB2 DdCzV

(CA),ITSl ODBC LB?xqCOCDT\#

*$nE/D ODBC:

v g{*(eB,S:

1. t/ DB2 CA#

2. r*!nK%"!q9Cr<4mS}]b...

3. q-r<3fD8>E"Yw,1=4=}]43f#

!qr CLI/ODBC "aK}]b#

4.

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

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(

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

– w*D~}]4m>+4(;v|,}]4E"DD~#g{zP TCP/IP ,

6. dk;v}]4

7. (I!)SE/&CLrPm!q;v&CLr,T*X(&CLrE/}]4

hC#

8. %w7("Kv CA#

"Kv CA#

*C'}]4m>zGITCJC}]bD(;C'#

S,G4K}] 4D~Ikd{$w>2m#qr,CD~vIZ>(Fc

zO9C#

"DD~#g{zP TCP/IP ,

{F.

© Copyright IBM Corp. 1993, 2009 85

86 DB2 Connect C'8O

Z 16 B &CLrhF

4(&CLr1,I48V=(4DxT\#

4O SQL Mf"}L

TZ"MMSU\`|nMp4D&CLr,xg*zI\.Vs#4O SQL
Mf"}LG=VuYK*zDl(#

Viks

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!/#

+`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)#

© Copyright IBM Corp. 1993, 2009 87

}]Vi

g{kS~qwq!s?D}],&9C}]Vi#ViDxKxgxmD9
C"uYK IBM sMz}]b~qwM DB2 Connect ~qwD CPU *z#

TZ"MMSUD?u{"(;<Gds!),CPU Mxg*zGL(D?#
}]ViuYK

hzZVi,i/PDWP}]+ZSU=Wvi.sE"MA&CLr#V
ivSKWPDlw1d,+DxKsxPDlw1d#

`,?D}]+dyhD{"}#

m;v"bBnGy9CDZf?#(#, ZxPVi1,Zf$w

S#

Z DB2 Connect Z,zITXF?viZ+MD}]?#

*wCVi,9C prep r bind |nD BLOCKING !n#g{BPivt

5,G4Vi&Zr*4,:

v NjG;AD,r

v NjG#}DRViGZ4P prep r bind |nZd8(D#

":9C

xP BLOCKING D SQL od

I|BD SELECT od(9C UPDATE/DELETE WHERE CURRENT OF od)GG
Vii/,yTvZxTX*1E&9C|G#

I|BD SELECT #$KZjI SELECT k"v UPDATE/DELETE .dD1d

Z;a|DCP#g{K"P6pTZ&CLr";X*

9CxPQwu~(|GyZS;I|BD SELECT 5XD3)5)D
DELETE r UPDATE#

TZ;A SELECT,8( FOR FETCH ONLY(Z VM M VSE P}b,|Zd
PG;\'VD)#

2,M/, SQL

/, SQL 1,Nj\G&Z#}4,#

/av

,G4m;v!qG

88 DB2 Connect C'8O

!?9C2, SQL#|\bKKP1 SQL ZD<8M#}Nj

;\\b9C/, SQL,G4I4PBPYwTns^HXuYxgw?MD

xT\:

v g{od* SELECT RXk<8,G44P PREPARE ... INTO SQLDA#

&+hCyhD5Js!Vdx SQLDA#g{PDns}?* x R#{#

VC}?;d,G4

((R;fZZf;;CDJb),G49C SQLVAR Dns}?(256

v)#

g{Vdx SQLDA D}?;;s,;\f"5XD SQLDA,G4LrX
k"vm;vPc;s SQLDA D DESCRIBE,TYNf"a{#b+vS

xgw?#

;*9C PREPARE M DESCRIBE rP#9C PREPARE.....INTO od\

;a)|CDT\#

v 4P2,s(D SQL COMMIT r ROLLBACK odx;G/,D COM-

MIT M ROLLBACK od#

* SQLDA Vd x v SQLVAR#g{1ZDP};7

DvV#g{

v g{|;G SELECT"COMMIT r ROLLBACK od,G4"v EXECUTE

IMMEDIATE T4PCodx;G PREPARE M EXECUTE rP#

v ODBC &CLr9C/, SQL#I9C CLI/ODBC 2,E*Vv&\?~

4DxT\#K&\?~Jmz6q"+ ODBC wC*;*f"Z}]bm
~|PD2,od#z+

d{ SQL "bBn

\D45,ZLrP9C|nP&mw(CLP)H9C/, SQL YH},-r
G CLP XkZ+ SQL a;x}]b}f.0TdkxPo(Vv#CLP 9

aZSU=}]1T|xPq=/,b

bMoT(}g REXX

odD4PYH*}#

P=V`MD CONNECT od,F*`M 1 M`M 2#PK`M 2 ,S,,

SA}]b+a90;v,Sxk]94,,+;+dO*#g{TsP;A
]9,S,G4\b
`M 2 ,SIDxCJ`v}]bD&CLrDT\#

qCD5JT\!vZ&CLrD4SLH#

TZ&CLr45I\G;X*D#

™

)PD SQL odH`koT(}g C)PD`, SQL

K0kbMhCZ?}]a9D*z#IZK-r,9C

Z 16 B &CLrhF 89

90 DB2 Connect C'8O

Z 17 B ,S\m

,S\mI=vYwiI:,SXM,S /Pw#,SXPzZuY("}]b,S
M&m,S]?yh*D*z#,S /Pw(}E/wz}]b~qw9CDJ44

a_zD$w73DIluT#+ZKV[b=vYw#

,SX

DB2 Connect ~qwz7(}g DB2 Connect s5f)(#,1*O'vM'Kks

a)}]b,S#("M,$k}] b~qwD,SG;v\DQJ4D}L,|T
}]b~qwM DB2 Connect ~qwDT\PG#;{D0l#

b;JbZ Web 73PHdwT,ZC
k}]b~qwDB,S,4Pi/MU9,S#*uYK*z,DB2 Connect ~qw

z79C,SX4ZWZCJDXP,$}]bD*E=,S#

yZ Web <uD`}&CLr4Ps?LZBq#dMD

SD;?V44PD#;T.,4PBqb6E("}]b,S;sZ;) SQL od
.sU9K,S#b;("MO*, SD}LPyhI>G#_#|f0 DB2 Con-

nect zmxLD4("Kzmx Lk DB2 ~qw.dxg,
DB2 _LD4(#TZ$ZKPD,S,b)I>Gy]ZK,SO4PDyPBq4
[ID,+TZdMD Web Bq,b)I>(#a,}4PBq>mDI>#

,SXGbyD;V<u,|JmT sx,SX

DB2 Connect 5}1,a4(-wzmxLX#,SksvV1,aTKks8(;v
zmxL#CzmxL+,S= DB2 ~qw"R+Z DB2 P4(;v_L#1&C

Lr"vO*,Sks1,CzmxL;+Kks+M
mxLEX=XP#XPDCzmxLT;5P|k DB2 ~qwD,SM`&D DB2
_L#1m;&CLr"v,Sks1,+Kzm xL8(=KBD&CLr#*7

#2+Yw,+C'j6E"+M= DB2 _L,|Y4

DB2 Connect D,SXZbV73Pa)\sDT\DF#DB2 Connect ZICXP,

$}]bD*E=,S#M'zks,S1, SKXPITa)Q<8CD,S#,
SXTx5MK(#CZr*MXUb),SD*z#

73P,T Web 3fD?NCJ<h*("

Web BqGw*dTm,

SD("T0~qwO

49CQ("D,Sy!a9#t/

= DB2 ~qw#`4,+Cz

PC'O$#

,SXTZ(} DB2 Connect ,
kwzD,S1,DB2 Connect O*kC&CLrDk>,S,+ZXP#fkwzD

v>,S#1BD&CLrks,S1,DB2 Connect 9CVPXPD;v,S#9C
QfZD,SuYK\e,S1d,T0w

DB2 Connect zmxLITGb=V4,.;:UPrn/#zmxLZ|*&CLr
xP$w1&Zn/4,#;)K$ wjI,zmxLMxkUP4,,H}4T,
;rm;&CLrDx;=$w#yPU PDzmxL
xLXDXP#IT9C num_poolagents dCN}4dCKXDs!#KN}HZ

k*53,$DUPzmxLDns}? # +KN}hC*cMHZXU,SX&
\#KdCN}D1!5hC* AUTOMATIC,"Rd5* 100#

MATIC 1,DB2 Connect aT/\mUPzmxLXPDUPzmxL}#

© Copyright IBM Corp. 1993, 2009 91

SAwzD&CLrG8wD#1&CLrksO*

zOD_ CPU ,SI>#

<;;p#fZF*UPzm

hC* AUTO-

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

M'zkskwzD,S1,DB2 Connect +T<q!XPkwz}]b~qw,SD

zmxL#g{CYw'\,DB2 Connect +"TZUPXPiRICDzmxL#g
{CX*U,G4 DB2 Connect +4(BDzmxL#

}9C max_coordagents dCN}4XFI"Pn/DnszmxL}#;),

I(

vK},BD,S+'\,ms sqlcode * SQL1226#(Kzkb6E,vK"Pv>
ns,S}#)KdCN}D1!5hC* AUTOMATIC,"Rd5* 200#hC*

AUTOMATIC 1,DB2 Connect aT/\m-wzmx

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 ~q

P,rx DB2CONNECT_IN_APP_PROCESS XkhC* NO#

;*<Mkwz}]b~qw,S#

L}#

wz7zmxLPx

DB2 Connect ,SXk&CLr~qw,SX

,SXTNNyZ Web <uD,*'Vs?BqD&CLrGXkD#VZs` Web
&CLr~qwa)|GT:D}]b,SX=(#}g,Microsoft MTS(COM+)M

IBM WebSphere <a),SX#

,S/Pw

b)~qw5VD&CLrXzFwT;,Z DB2 Connect ~qwya)D&CLr
XzF#IZ&CLr~qwX,Sv)|GT:9C , yT|G(#YhC'j

6"\kMtk6pHHTyP,S+j+; y#|*X*DG,&CLr~qwv
OC,;xLt/D,S#bm>; OC4Td{zw"C'rxLD,S#d;

)&CLr~qwOC<uT&CLrD,; 5}("D,SxP4CGP'D,+
GT`vC'M~qwHHDOC,SxT^'#

,SX(I DB2 Connect ~qwa))k&CLr"zwMC'j+^X#TZ4T
`vM'zD,S,_P;,C'j6D

S,MaCOCJ4D{CJssa_#

9CDV`MD,SXG}7D?=V<G#(#,,19C DB2 Connect ,SXM
“&CLr~qw”,SXG;v\CD_T,r*|G`%;0l#49ZtC&C

qw,SX1,DB2 Connect ,SX2IT*`v&CLr~qwT09C DB2

Lr~

Connect ~qwDd{M'za),S4C#

,S/PwuYKZ DB2 z/OS f}]b~qwO'Vs?$w>M Web C'yhD

J4#K&\Isya_ DB2 z/OS fM DB2 Connect bv=8DIluT,,19
aZ DB2 z/OS f}]2m73Pa)JO#UYwMBq6p:Xyb#

yP&CLr~qw<IT4C`%D,

b

92 DB2 Connect C'8O

,S/PwJm&CLrZ DB2 w

T'FDC'Z&CLrP&Zn/4,,xv98v_LZ DB2 wz~qwO&Z
n/4,#

z~qwO#V,Sx;{DNNJ4#IT9}