PDF《DB2》

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

1 B DB2 Connect En

5 :1Sf>

7 DM'

z(}f>

9 DxXrwz v PING |n1,DB2 Connect +;

'

VC|n# DB2 Connect f>

7 Pf

2 P;

6D&

\ DB2 Connect f>

7.2 |(BPv?&

\: v T Microsoft? Transaction Server(MTS)M COM+

8 z/OS ~qw#9C z/OS -display ddf |n4 q! DB2 ~qw;

C{ r{ IP X7MKZ# VSE Z}]bVxPKPDI DBNAME j6D DB2 VSE f VM Z CMS ibzPKPDI DBNAME j6D DB2 VM f OS/400? DB2 iSeries f,|G OS/400 Yw53D/I?~#}G53;

dC*9C@ D(zf X,qrZ iSeries ~qwO;

\P;

v}]b# `XEn: v Z

3 3D:DB2 Connect;

v Z

7 3D:DB2 Connect M SQL od;

`XNkwzr iSeries ~qw. dD}]w/# *K5V DRDA ~qw}]b\m53k}]bM'

z.dD,S,DRDA 9CBP e5a9: v V{}]m>

e5a9(CDRA) v V20K DB2 Connect vKfD$w>

kwzr iSeries }]b~q wD1S,S# ? Copyright IBM Corp. 1993,

2006 15 : 1. ;

X+ DB220Z DB2 Connect $w>

O#g{k* DB2 Connect $w>

OPj {DX5}]b\m53,r): DB2# 2. DB2 M'

zVZG DB2 Connect m~|D;

?V,g{M'

k*+dCZ&

CL r* ,rI20|#Kb,DB2 Connect VZ|(0f }L9(w1,|IC 49( bTM?p DB2 OS/390 fM z/OS fDf }L# 3. 9C Microsoft ODBC OLE DB r ActiveX }]Ts(ADO)* Windows &

CLrD C Lr1&

C9C Microsoft Open Database Connectivity Software Development Kit#TZk*9C Java `LoT4* &

CLrDLr1,IT9C NN Java * 73# 4. g{*'

ktCK Sysplex D DB2 z/OS f}]b~qwD,S,rM'

z+T/ TXB( ,S# `XEn: v :9C DB2 Connect vKf4CJwzr iSeries DB2 }];

(6DB2 Connect v KflYkE7) v Z

21 3D:DB2 Connect M&

CLr~qw;

v Z

24 3D:DB2 Connect MBq&

m`Sw;

v Z

18 3D:DB2 Connect M Web &

CLr;

v Z

17 3D:w*,S~qwD DB2 Connect ~qwz7;

TCP/IP DB2 Connect DB2 VSE DB2 VM DB2 iSeries DB2 OS/390 z/OS S/390 S/370 zSeries iSeries ODBC

1 2

3 4 n ADO.NET DB2 CLI JDBC SQLJ SQL PHP Perl OLE DB <

3. DB2 Connect kwzr iSeries }]b~qw.dD1S,S

16 C'

8O v Z

15 3D:DB2 Connect =8;

w*,S~qwD DB2 Connect ~qwz7 DB2 Connect ~qwJm`vM'

z,SAwzr iSeries }] ITxuY( M, $CJs5}]yhD$w#<

4 5wK3)73B IBM Dbv=8,Zb)73P, zkC DB2 M'

z(} DB2 Connect ~qwz7(}g:DB2 Connect s5f)k wzr iSeries }]b~qw( dS,S# g{*'

k DB2 Connect ~qwD TCP/IP ,S,rM'

z+T/ TXB( ,S# M'

z+WH TXB( k-ZC~q wOKP#+G,;

G+?v%@D SQL od MA DB2 }]b,xG M4Pf }LDks#Kf }L|(Km` SQL od;

g{;

Cf }L,b)od+* %@XKP#f }L5MKZ CGI E>

MsK}]b.dw/D{ }# f }LDw*EcGuYK HTTP ~qwk DB2 }]bsKdDxgw?# `XEn: v Z

15 3D:DB2 Connect =8;

`XN#,1,|Jmin X+}]b\m&

\&

CZwVYw53M2~=(O!3D}]b~qw# M'

z/~qw#M(dP&

CLr_-VD&

m\&

M]?Dhs#Kb,T}]b~qwDhs2ssDvSK,- rG?vM'

zh*;

v(CD}]b,SM,$kbyD,S`X*DJ4#IZ f }LDc:9C,V 5q_-T=cM'

z/~qwD@5I\PyuY,+ g{;

T#Mwv|DD0,m;

v1c;

]Wbv# &

CLr~qwbv=8 fE=cM'

z/~qw&

CLrDI>

M4STDO},s?VnsD&

C Lr*}#8uyPD0s5J4f .1(ERP))&

L}|(lHD0s5X5\m1)&

L,g Siebel M Vantive# &

CLr~qwM DB2 Connect DB2 Connect ~qwz7T?p`c&

CLra)K+f'

V#DB2 Connect a )D'

V|(IC4* &

CLr_-DwV API(ODBC ADO.NET DB2 CLI 6k= SQL JDBC SQLJ Perl PHP M OLE DB),T0C4k DB2 5P}]b~qwxP;

%Dj{(Ey!a9# DB2 Connect 9'

VI`v DB2 5P}]b~qwiID}]bcD5V# bJm&

CLr~qwZ%vBqP5VT`v}]b~qwOD}]xP| BDBq# DB2 Connect a)D=WNd5-i'

V#$bVV#Kb,9Ir/\m,-rG;

h*20M,$d{~ qw# DB2 DB2 SQL JDBC SQLJ ADO.NET OLE DB ODBC Perl PHP DB2 CLI SQL DB2 Connect Jane, Mike, Tom, Sue Select name from... Update... API <

5. DB2 Connect T&

CLr~qwD'

V Z

3 B DB2 Connect =8

23 + DB2 Connect 20Z@ D~qwOZTBivBGOCD!q;

zD DB2 Connect ~qwz7;