ibm db2 connect 安装和配置 db2 connect personal edition


IBM DB2 Connect 10.1 DB2 Connect 20MdC DB2 Connect Personal Edition S151-1773-00  IBM DB2 Connect 10.1 DB2 Connect 20MdC DB2 Connect Personal Edition S151-1773-00  "b 9CKE"0d'VDz70,kHDAZ 67 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*:http://www.ibm.com/shop/publications/order v *iR1XD IBM zm&,k*A IBM +r*5K?<,x7*:http://www.ibm.com/planetwide/ *S@zrSCsD DB2 P!Mz[?): DB2 vfo,kBg 1-800-IBM-4YOU(426-4968)# z"ME"x IBM s,4Zh IBM G@<(^,IBM IT4|O*J1DNN==9CrV"zya)DNNE"x ^kTzP#NNpN# © Copyright IBM Corporation 1993, 2012. ?< XZ>i...............v Z 1 ?V XZ>i .........1 Z 2 ?V DB2 Connect ri ....3 Z 1 B XZ DB2 Connect ......5 DB2 Connect a)Dz7 ..........5 Z 2 B #{ DB2 Connect =8 ....7 9C DB2 Connect vKf4CJ System z wzr IBM i DB2 }] .............7 Z 3 ?V 20 DB2 Connect vKf 9 Z 3 B 20MdC DB2 Connect Personal Edition yh*DdM=h ..11 DB2 Connect ELMZf*s ........11 DB2 Connect ELMZf*s ........12 20 DB2 Connect Personal Edition (Linux) ....13 DB2 Connect Personal EditionD20*s (Linux) 15 20 DB2 Connect D CD r DVD (Linux) . . . 15 20 DB2 Connect D CD r DVD (Linux) . . . 16 20 DB2 Connect Personal Edition (Solaris)...16 DB2 Connect z7D20*s(Solaris) ....18 20 DB2 Connect D CD r DVD (Solaris) . . 19 20 DB2 Connect D CD r DVD (Solaris) . . 20 20 DB2 Connect Personal Edition (Windows) . . . 20 DB2 Connect Personal Edition D20*s (Windows) ..............22 20 DB2 Connect Personal Edition yhDC'J ' (Windows) .............23 * LDAP ?<~q)9 Active Directory #= (Windows) ..............24 * LDAP ?<~q)9 Active Directory #= (Windows) ..............25 DB2 Connect DG\m1C'20 (Windows) . . 25 Z 4 B C'j6\m ........27 +C'j6mSA DB2ADMNS M DB2USERS C' i (Windows) ..............27 +C'j6mSA DB2ADMNS M DB2USERS C' i (Windows) ..............28 Z 4 ?V dC DB2 Connect (E 29 Z 5 B <8 IBM DB2 for IBM iTcS DB2 Connect xP,S........31 Z 6 B <8 DB2 z/OS f TcS DB2 Connect xP,S ..........33 wz}]b ..............33 * DB2 z/OS f dC TCP/IP ........34 dC DB2 z/OS f ............36 Z 7 B <8 DB2 for VSE & VM Tc S DB2 Connect xP,S ......37 Z 8 B dCksMzMPM~qwD,S 39 dCk IBM sMz}]b~qwD,S .....39 Z 5 ?V N< ..........41 Z 9 B dCT IBM sMz}]bDCJ 43 Z 10 B \'VD DB2 Connect gf oT ................45 T>XoTT>“DB2 20”r<(Linux M UNIX) 45 CZKPm;oTf>D“DB2 20”rXoTT>“DB2 20”r<(Linux M UNIX) 49 CZKPm;oTf>D“DB2 20”r SQL 4,oz ......61 CJ;,f>D DB2 E"PD ........61 |B20ZFczrZ?x~qwOD DB2 E"P D .................62 © Copyright IBM Corp. 1993, 2012 iii V/|B20ZFczrZ?x~qwOD DB2 E "PD ................63 DB2 LL ...............65 DB2 JOoOE" ............65 E"PDunMu~ ...........65 =< B. yw ............67 w} ................71 iv DB2 Connect 20MdC DB2 Connect Personal Edition XZ>i 620MdC DB2 Connect™ vKf7a)<8020 DB2 Connect vKfz7yh D+?E"#dP|(X(Z?v\'VDYw53DE"#92vK DB2 Connect v Kfk\'VD}]b~qwz7.dDX5,|(gNdC,S# >iD9C_ 53\m1"}]b\m1"(E(RT0m~z720_iD?Vr+ ?Z]PK$# © Copyright IBM Corp. 1993, 2012 v vi DB2 Connect 20MdC DB2 Connect Personal Edition Z 1 ?V XZ>i 620MdC DB2 Connect vKf7a)<8020 DB2 Connect vKfz7yhD +?E"#dP|(X(Z?v\'VDYw53DE"#92vK DB2 Connect v Kfk\'VD}]b~qwz7.dDX5,|(gNdC,S# >iD9C_ 53\m1"}]b\m1"(E(RT0m~z720_iD?Vr+ ?Z]PK$# © Copyright IBM Corp. 1993, 2012 1 2 DB2 Connect 20MdC DB2 Connect Personal Edition Z 2 ?V DB2 Connect ri © Copyright IBM Corp. 1993, 2012 3 4 DB2 Connect 20MdC DB2 Connect Personal Edition Z 1 B XZ DB2 Connect DB2 Connect a)S Linux"UNIX M Windows Yw53=sMzMPMz}]bD ,S# zITZ z/OS®"IBM® i"IBM Power Systems™"VSE T0 VM O,SA DB2® } ]b#9IT,SA{O Distributed Relational Database Architecture™(V<=X5} ]be5a9,DRDA®)DG IBM }]b# DB2 Connect a)Dz7 DB2 Connect _P8v,Sbv=8,dP|( DB2 Connect Personal EditionMm` DB2 Connect ~qwz7# v DB2 Connect Enterprise Edition v DB2 Connect Application Server Edition v DB2 Connect Unlimited Edition System z® f v DB2 Connect Unlimited Edition System i® f PX DB2 Connect a)Dz7Dj8E",kND www.ibm.com/software/data/db2/ db2connect/ © Copyright IBM Corp. 1993, 2012 5 6 DB2 Connect 20MdC DB2 Connect Personal Edition Z 2 B #{ DB2 Connect =8 2v9C DB2 Connect 44($w}]b73D#{=(MjIf0 DB2 Connect D w*NqD#{=(#b)=8|(BP73MNq:DB2 Connect k IBM sMz} ]b~qw.dD1S,S;9CdCzV4\mk}]bD,S;T0}]b&C Lr*"D IBM }]~qwM'z'V# 9C DB2 Connect vKf4CJ System z wzr IBM i DB2 }] ;PPd~qwD1S,SG;VG#=cMmkDdC#TZ IBM sMz}]b~ qw'V TCP/IP ,SDivHdgK#Zb)ivB,?v DB2 Connect $w>< +k IBM sMz}]b~qw("1S,S# TCP/IP ,S*s IBM sMz}]b'V TCP/IP#BPf>'V>z TCP/IP ,S: v DB2 z/OS f V7.1 r|_f> v IBM DB2 for IBM i V5R1 r|_f>,T0 v DB2 ~qw VM M VSE f V7 r|_f> *,SA IBM sMz}]b~qw,h*ImSA IBM }]~qwM'zD DB2 Connect mI$# Z 8 3D< 1 T>20K DB2 Connect Personal Edition D$w>,"RC$w>1S ,SA IBM sMz}]b~qw# © Copyright IBM Corp. 1993, 2012 7 ODBC ADO.NET DB2 CLI JDBC SQLJ Embedded SQL PHPPerl OLE DBpureQuery Python Ruby  1  2  3  4  n TCP/IP DB2 VSE  DB2 VM  DB2 z/OS  System z DB2 IBM i  Power Systems  DB2 Connect  < 1. DB2 Connect k IBM sMz}]b~qw.dD1S,S 8 DB2 Connect 20MdC DB2 Connect Personal Edition Z 3 ?V 20 DB2 Connect vKf © Copyright IBM Corp. 1993, 2012 9 10 DB2 Connect 20MdC DB2 Connect Personal Edition Z 3 B 20MdC DB2 Connect Personal Edition yh*D dM=h hC DB2 Connect Personal Edition G;vh*4P`v=hD}L#20MdC DB2 Connect Personal Edition yhDdM=h|(i$53Hvu~"20 DB2 Connect m ~"bT,S0s(LrM5CLr# ":g{zDFcz20K IBM }]~qwM'z,G4IT(}rCFcz"az D DB2 Connect Personal Edition mI$4$n DB2 Connect Personal Edition# 1. 7(zkZxgPgN9C DB2 Connect# 2. i$Z$w>M IBM sMz}]b~qwOGq_P}7DX82~Mm~# 3. i$ IBM sMz}]b~qwGqdC*S\4T DB2 Connect D,S# 4. 20 DB2 Connect m~#z+9CK$w>4dCMi$ IBM sMz,S# 5. 20.s,Z DB2 Connect k IBM sMz}]b53.d(",S# DB2 Connect IT*zR=MdCyP TCP/IP ,S#PXj8E",kNDPX i$ IBM }]~qw}/Lr| (Windows) 20Dwb# 6. +f DB2 Connect a)DLrM5CLrs(A IBM sMz}]b# ":IBM }]~qw}/Lr|(DS }/Lr)h*K=h#TZOsDM'zL r|,?N^)|}6O& C20K IBM }]~qwM'z# 9. g{k*9CK$w>4\m DB2 z/OS fr DB2 Database for Linux, UNIX, and Windows~qw,k20 IBM }]~qwM'z# DB2 Connect ELMZf*s 7#zD DB2 Connect 73PJ1DELUd?IC,"RQ`&VdZf# EL*s z7h*DELUd!vZy!qD20`MT0_PDD~53`M#“DB2 20”r }LDW!8C}L#PXj8E ",kND IBM }]~qwM'z`M# *<.0 Z*<20.0: v IT9C root C'rG root C'(^20 DB2 Connect#PXG root C'20 D|`E",kND“G root C'20Ev(Linux M UNIX)”# v 7#zD53zc: – ELMZf*s – Z 15 3D:DB2 Connect Personal EditionD20*s (Linux);. v XkZ53O20 DB2 }]bz7 DVD# v DB2 Connect z73qXkIC#g{*20G"ofD DB2 Connect z7,9X k_P`&D“>XoT|”# v *Rv53OQ20D DB2 }]bz7,k"v db2ls |n# v “DB2 20”rZ]#}g,export DISPLAY=9.26.163.144:0# v g{ZzD73P9CKnga?6?z205CLr rpm V/20 DB2 }]bz7#+h*|D|,>z205CLrDNNVPE>,z+9Cb)L r4k DB2 20;%"TdxPi/# }L *Z Linux O9C“DB2 20”r<420 DB2 Connect Personal Edition: 1. P;=20K DVD D?<: cd /db2dvd ,dP db2dvd m> DVD 20c# 2. g{zBXK DB2 Connect z73q,G4XkTz7D~xPb9u# a. b9uz7D~: gzip -d product.tar.gz dP product GBXD}]bz7D{F# b. b9uz7D~: tar xvf product.tar c. |D?<: cd ./product/disk1 ":g{QBX“>XoT|”,G4+|b9=,;?<#byMaZ,;?

# 3. Sz73qyZD?}?]v# z9IT8(T:D DB2 }]bz72076# 14 DB2 Connect 20MdC DB2 Connect Personal Edition a{ 2ITZ20 DB2 Connect z7s,(}S“>XoT|”yZD?XoT|”# 1!ivB,20U> db2setup.log M db2setup.err ;Z /tmp ?D~D;C# g{k* DB2 }]bz7\;CJ>XFczrxgPDm;FczOD DB2 D5, G4Xk20 DB2 E"PD#DB2 E"PD|, DB2 }]bM DB2 }]b`Xz 7DD5#kND620 DB2 ~qw7PD:9C“DB2 20”r<420 DB2 E" PD (UNIX);wb# DB2 Connect Personal EditionD20*s (Linux) Z Linux Yw53O20 DB2 Connect Personal Edition .0,7#z!qD53z cXhDYw53"2~"m~M(E*s# *20 DB2 Connect Personal Edition,XkzcBP*s: 2~*s &mwITGBPdP.;: v x86(Intel Pentium"Intel Xeon M AMD Athlon) v x64(Intel EM64T M AMD64) V"*s PX'VD Linux V"z7DnBE",k9C/@wCJTBx7: www.ibm.com/db2/linux/validate# zI\h*|BZKdCN}#ZKdCN}GZ /etc/sysctl.conf PhC D#PX9C sysctl |n4hCM$nb)N}DE",kNDYw53V a# m~*s v h*9C/@w4i4*zoz# v g{k*9C“DB2 20”r<420 DB2 Connect,r_g{zk*9CN N DB2 CD r DVD D20c# 2. "z# a{ CD r DVD D~53VZQ20C#i4 CD r DVD DZ],=(G:+bLE k}/wP"dk cd /cdrom |n,dP cdrom G20c?<# 20 DB2 Connect D CD r DVD (Linux) *Z Linux Yw53O20 CD-ROM,k"v mount |n# *<.0 y]zD53dC,I\h* root C'(^E\20bL# }L *Z Linux Yw53O20 CD r DVD: 1. + CD r DVD ek}/w"dkTB|n: mount -t iso9660 -o ro /dev/cdrom /cdrom dP /cdrom m> CD r DVD D20c# 2. "z# a{ CD r DVD D~53VZQ20C#i4 CD r DVD DZ],=(G:+bLE k}/wP"dk cd /cdrom |n,dP cdrom G20c?<# 20 DB2 Connect Personal Edition (Solaris) *(e20W!nM20 DB2 Connect Personal Edition,k9C“DB2 20”r<#2 0 IBM }]~qw}/Lr|(DS }/Lr),;s&C DB2 Connect Personal Edi- tion mI$GTB?VPP>D}LDW!8C}L#PXj8E",kND IBM } ]~qwM'z`M# *<.0 Z*<20.0: v IT9C root C'(^rG root C'(^20 DB2 Connect#PXG root C'2 0D|`E",kND620 DB2 ~qw7PD“G root C'20Ev(Linux M UNIX)”# v 7#53zc20"ZfMEL*s# v XkZ53O20 DB2 }]bz7 DVD# v DB2 Connect z73qXkIC#g{*20G"ofD DB2 Connect z7,9X k_P`&D“>XoT|”# 16 DB2 Connect 20MdC DB2 Connect Personal Edition v *Z53ORvQ20D DB2 }]bz7,k9C db2ls |n#kND620 DB2 ~qw7PD:P>53OQ20D DB2 z7(Linux M UNIX);wb# v “DB2 20”rZ]#}g,export DISPLAY=9.26.163.144:0# v g{ZzD73P9CKnga?6?z205CLr pkgadd 4V/ 20 DB2 }]bz7#+h*|D|,>z205CLrDNNVPE>,z+9 Cb)Lr4k DB2 20;%"TdxPi/# }L *Z Solaris x64 O9C“DB2 20” r<420 DB2 Connect Personal Edition: 1. P;=20K DVD D?<: cd /db2dvd dP db2dvd m> DVD D20c# 2. g{zBXK DB2 Connect z73q,G4XkTz7D~xPb9u# a. b9uz7D~: gzip -d product.tar.gz dP product GBXD DB2 Connect z7D{F# b. b9uz7D~: tar xvf product.tar c. |D?<: cd ./product/disk1 ":g{QBX“>XoT|”,G4+|b9=,;?<#byMaZ,;?

# 3. Sz73qyZD?}?]v# z9IT8(T:D DB2 Connect z72076# a{ 2ITZ20 DB2 Connect z7s,(}S“>XoT|”yZD?XoT|”# 1!ivB,20U> db2setup.log M db2setup.err ;Z /tmp ?D~D;C# g{k* DB2 }]bz7\;CJ>XFczrxgPDm;FczOD DB2 D5, G4Xk20 DB2 E"PD#DB2 E"PD|, DB2 }]bM DB2 `Xz7DD 5#kND620 DB2 ~qw7PD:9C“DB2 20”r<420 DB2 E"PD (UNIX);wb# DB2 Connect z7D20*s(Solaris) Z Solaris Yw53O20 DB2 Connect z70,7#z!qD53zcXhDYw5 3"2~"m~M(E*s# *Z Solaris O20 DB2 Connect z7,XkzcBP*s: m 1. Solaris 20*s Yw53 2~ Solaris 10 |B 9 v 64 ;ZK Solaris x64(Intel 64 r AMD64) Solaris 10 |B 9 v 64 ;ZK UltraSPARC r SPARC64 &mw 1. v'VZ>Xxr20 DB2 z7#DB2 z7K1;'V+VxrD20# Yw53*s h*q!“(i9!M2+T9!”# 9h* J2SE Solaris Operating System Patch Cluster# Solaris Yw53D Fujitsu PRIMEPOWER 9!IS;Z http:// download.ftsi.fujitsu.com/ OD FTSI BX# *q!I\0l Solaris OD DB2 }]b53Dd{JbPm,kND www.ibm.com/support/docview.wss?&uid=swg21257606# DB2 }]bz7'V Solaris ZFS D~53M_-r(LDOM)# 18 DB2 Connect 20MdC DB2 Connect Personal Edition PX DB2 z7'VDib/dC*fZZ2mELO(b IT(} spm_log_path }]b\mwdCN}45V),"RJO*F 53_Pj+`,D TCP/IP dC(wz{M IP X7H<`,),G4 aEmK^F# 20 DB2 Connect D CD r DVD (Solaris) + CD-ROM ek Solaris Yw53OD}/wP1,g{C CD-ROM ;PT/20, k"v mount |n# *<.0 g{9C NFS S6L5320 CD r DVD }/w,G4Xk9C root C'CJ( X53dC,zZ>XFczOI \9h* root C'CJ(# }L *Z Solaris O20 CD r DVD: 1. + CD r DVD ek=}/wP# 2. 1“m\mw”(vold) }Z53OKP1,g{ CD r DVD _Pj),G4bLT /20* /cdrom/cd_label;g{ CD r DVD ;_Pj),G4bLT/20* /cdrom/unnamed_cdrom# g{“m\mw”4Z53OKP,G4jITB=h420 CD r DVD: a. (}dkTB|n47(h8D{F: ls -al /dev/sr* |awk ’{print "/" $11}’ K|na5X CD r DVD h8D{F#ZK>}P,|n5XV{. /dev/ dsk/c0t6d0s2# b. dkTB|n420 CD r DVD: mkdir -p /cdrom/unnamed_cdrom mount -F hsfs -o ro /dev/dsk/c0t6d0s2 /cdrom/unnamed_cdrom dP /dev/dsk/c0t6d0s2 m>ZH0=hP5XDh8D{F,/cdrom/ unnamed_cdrom m> CD r DVD 20?<# 3. "z# Z 3 B DB2 Connect Personal Edition 19 a{ CD r DVD D~53VZQ20C#i4 CD r DVD DZ],=(G:+bLE k}/wP"dk cd /cdrom |n,dP cdrom G20c?<# 20 DB2 Connect D CD r DVD (Solaris) + CD-ROM ek Solaris Yw53OD}/wP1,g{C CD-ROM ;PT/20, k"v mount |n# *<.0 g{9C NFS S6L5320 CD r DVD }/w,G4Xk9C root C'CJ( X53dC,zZ>XFczOI \9h* root C'CJ(# }L *Z Solaris O20 CD r DVD: 1. + CD r DVD ek=}/wP# 2. 1“m\mw”(vold) }Z53OKP1,g{ CD r DVD _Pj),G4bLT /20* /cdrom/cd_label;g{ CD r DVD ;_Pj),G4bLT/20* /cdrom/unnamed_cdrom# g{“m\mw”4Z53OKP,G4jITB=h420 CD r DVD: a. (}dkTB|n47(h8D{F: ls -al /dev/sr* |awk ’{print "/" $11}’ K|na5X CD r DVD h8D{F#ZK>}P,|n5XV{. /dev/ dsk/c0t6d0s2# b. dkTB|n420 CD r DVD: mkdir -p /cdrom/unnamed_cdrom mount -F hsfs -o ro /dev/dsk/c0t6d0s2 /cdrom/unnamed_cdrom dP /dev/dsk/c0t6d0s2 m>ZH0=hP5XDh8D{F,/cdrom/ unnamed_cdrom m> CD r DVD 20?<# 3. "z# a{ CD r DVD D~53VZQ20C#i4 CD r DVD DZ],=(G:+bLE k}/wP"dk cd /cdrom |n,dP cdrom G20c?<# 20 DB2 Connect Personal Edition (Windows) I9C“DB2 20”rD}LDW!8C}L#PXj8E",kND IBM }]~qwM'z`M# 20 DB2 Connect 20MdC DB2 Connect Personal Edition *<.0 Zt/“DB2 20”r<.0: v 7#53zcBP*s: – 2~Mm~*s – ELMZf*s v g{z}Z Windows OxP20"Rk*9C“a?6?X\m1i,"R&C_PBP_6C' (^: – TYw53==Yw – 4(jGTs – vS^n – f;xL6pjG d;zITZ;P_6C'(^DivBxP20,+G20LrI\+^(i$ J'# v g{k*9CG\m1J'420 DB2 Connect,kND:DB2 Connect DG\m1 C'20 (Windows);wb# }L v *9C“DB2 20”r<420 DB2 Connect Personal Edition: 1. w*_P\m1(^DC'G4LxxP20#*zozI8D~CZf"20M6Xn/zID;cE"Mms{"#U>DD~{q- TBq=:DB2-Product Abrreviation-Date Time.log,}g DB2-CLIENT-10-06- 2006_17_23_42.log#1!ivB,U>D~;Z My Documents\DB2LOG ? DVD }/w – language m>oTDXrzk(}g,EN m>"o)# 3. %w7(# g{k* DB2 }]bz7\;CJ>XFczrxgPDm;FczOD DB2 D 5,G4Xk20 DB2 E"PD#DB2 E"PD|, DB2 }]b53M`Xz7 DD5# DB2 Connect Personal Edition D20*s (Windows) Z Windows Yw53O20 DB2 Connect Personal Edition .0,7#z!qD53 zcXhDYw53"2~"m~M(E*s# *20 DB2 Connect Personal Edition,XkzcBP*s: Yw53*s BPdP;n: v xP Service Pack 3 r|_f>D Windows XP Professional Edition(32 ; M 64 ;) v x Service Pack 2 r|_f>D Windows 2003: – Standard Edition(32 ;M 64 ;) – Enterprise Edition(32 ;M 64 ;) – Datacenter Edition(32 ;M 64 ;) v xP Service Pack 2 r|_f>D Windows Vista – Business Edition(32 ;M x64) – Enterprise Edition(32 ;M x64) yP Windows Vista service pack <\'V# v xP Service Pack 1 r|_f>D Windows 7 – Professional Edition(32 ;M x64) – Enterprise Edition(32 ;M x64) v xP Service Pack 2 r|_f>D Windows Server 2008 – Standard Edition(32 ;M 64 ;) – Enterprise Edition(32 ;M 64 ;) – Datacenter Edition(32 ;M 64 ;) v Windows Server 2008 R2 – Standard Edition(64 ;) – Enterprise Edition(64 ;) – Datacenter Edition(64 ;) yP Windows Server 2008 R2 service pack <\'V# 2~*s v yP Intel M AMD &mw<\;KP\'VD Windows Yw53(32 ; MyZ x64 D53)# m~*s 22 DB2 Connect 20MdC DB2 Connect Personal Edition v h*9C/@w4i4*zoz# (E*s v TCP/IP \'V"RQfYw53;pa)# Windows(64 ;)"bBn v SOgf>D6L 32 ;M'zO"vD SQL ks\'V# &\?~ Kf>D DB2 Connect )vK$w>9C0CZ&CLr,S#~qwrxX &\;IC#PXKf>Pa)D&\?~Dj{j8E",kCJ http:// www.ibm.com/software/data/db2/db2connect/edition-pe.html# Kf>D DB2 Connect ;CZtC&CLr~qw,rK;&20ZK`~q wO# 20 DB2 Connect Personal Edition yhDC'J' (Windows) g{*Z Windows O20 DB2 Connect Personal Edition z7,h*;v20C'J '# 20C'J'MG*4P20DC'DJ'#XkZKP“DB2 20”r<.0(e20 C'J'#ITZ20.0(ehCC'J',2ITC“DB2 20”r<4(b)hC C'J'# yPC'J'{FXC'J'rrC'J'E\4P20#(#,C'J'XktZ+4P 20DFczOD Administrators i# 2IT9CG\m1C'J'#9CG\m1C'J'1,*s Windows Administra- tors iDI1WHdC Windows a}X(hC,TJmG\m1C'J'4P20# }g,Z 64 ;Yw53O,XkHV/ZhT HKLM\Software\Wow6432Node Dj+m I(,;sE\I&20 DB2 Connect Personal Edition#Z Windows Vista O,G\ m1C'I4P20,+“DB2 20”rzdk\m>$# 20C'J'Xk_P“SxgPCJKFcz”b;C'(^# TZrJ',*i$C'j6,20C'j6XktZ+*ZdP4(J'DrOD r Administrators i# 9IT9CZCD“>X53”J'4KPyPz7D20# DB2 20LrZhDC'(^ DB2 20Lr;aZh“wTLr”C'(^#DB2 20Lr+ZhTBC'(^: v TYw53==Yw v 4(jGTs v x(ZfPD3 Z 3 B DB2 Connect Personal Edition 23 v w*~qG< v vS^n v f;xL6pjG Windows OD)92+T DB2 z7a)K)9D Windows 2+T#zIT9C3vC'j6420 DB2 Con- nect Personal Edition,+G}GCC'j6tZ DB2ADMNS r DB2USERS i,q r|^(KPNN DB2 |n# DB2 20Lra4(b=vBi#zITZ(F20Zd8(;vB{F,2ITS\ 1!{F# *tCK2+T&\?~,kZ20 DB2 Zd,!P* DB2 TstCYw532+ TfeODtCYw532+T4!r#S\“DB2 \m1i”VNM“DB2 C'i”VN D1!5#1!i{* DB2ADMNS M DB2USERS#g{kVPi{e;,53+a >z|Di{#g{h*,zIT8(T:D5# * LDAP ?<~q)9 Active Directory #= (Windows) g{rc+a?6?: runas /user:MyDomain\Administrator x:\db2\Windows\utilities\db2schex.exe dP x: m> DVD }/wL{# B;=v24 1 db2schex jI1,zITLx20 DB2 }]bz7;r_g{zQ20 DB2 } ]bz7rQ4(}]b,G4XkV/"aZc"`?}]b#PX|`E",k ND“DB2 20jIstC LDAP 'V”wb# 24 DB2 Connect 20MdC DB2 Connect Personal Edition * LDAP ?<~q)9 Active Directory #= (Windows) g{rc+a?6?: runas /user:MyDomain\Administrator x:\db2\Windows\utilities\db2schex.exe dP x: m> DVD }/wL{# B;=v24 1 db2schex jI1,zITLx20 DB2 }]bz7;r_g{zQ20 DB2 } ]bz7rQ4(}]b,G4XkV/"aZc"`?}]b#PX|`E",k ND“DB2 20jIstC LDAP 'V”wb# DB2 Connect DG\m1C'20 (Windows) Z Windows Yw53O9CG\m1C'J'20 DB2 Connect 1P;)=S"b Bn# TZG\m1C'20,zG<1yICDJ'XktZ“_6C'”i# XkZ"amD HKEY_CURRENT_USER D~PPdk3)&Z"amPvVDPX DB2 Connect DE"#TZ DB2 Connect DG\m1C'20,!\m`n+f"Z "amD HKEY_LOCAL_MACHINE D~PP,+GTXkZ HKEY_CURRENT_USER P|D73hC# Windows Administrators iDI1XkdC Windows a}X(hC,TcJmG\m 1C'J'4P20#}g,Z 64 ;Yw53O,XkHV/ZhT HKLM\Software\ Wow6432Node Dj+mI(,;sE\I&20 32 ; DB2 Connect Personal Edition z7# ":g{rc9CG\m1C'J'xPz720,G4Z"T20 DB2 z7.0, Xk20 VS2010 KP1b#VS2010 KP1bXkZYw53O,E\20 DB2 z 7#IS Microsoft KP1bBX Web >cq! VS2010 KP1b#P=v!n:T Z 32 ;53,!q vcredist_x86.exe;TZ 64 ;53,!q vcredist_x64.exe# Z 3 B DB2 Connect Personal Edition 25 TZG\m1C'20,Xk+53l]==|D*C'l]==#Kb,IZ~q TZ20NN DB2 Connect z7)Yw53ODb) G\m1C'IT6X DB2 z7# 26 DB2 Connect 20MdC DB2 Connect Personal Edition Z 4 B C'j6\m 20 DB2 Connect vKfsD;nX*NqG+C'mSA1!{F* DB2ADMNS M DB2USERS D=vC'i.;#KNq+w*T}]b735)D}]b2+_T D;?V4jI# +C'j6mSA DB2ADMNS M DB2USERS C'i (Windows) ZI&jI DB2 20.s,TZh*ZzwOKP>X DB2 &CLrM$_DC', zXk+b)C'mS= DB2ADMNS r DB2USERS i#DB2 20Lra4(=v Bi#IT9CB{F,2ITS\1!{F#1!i{* DB2ADMNS M DB2USERS#K}L2JCZyZ5}DM'z# *<.0 v XkQ20 DB2 }]bz7# v Z20 DB2 }]bz7Zd,XkQZ“* DB2 TstCYw532+T”feO !PKtCYw532+T4!r# }L *+C'mS=J1DiP: 1. %w*<"!qKP# 2. dk lusrmgr.msc,;s%w7(# 3. !q>XC'Mi# 4. !qC'# 5. !qk*mSDC'# 6. %wtT# 7. %w%tZ!n(# 8. %wmS# 9. !qJ1Di# 10. %w7(# B;=v24 g{jIK20+!q;tCBD2+T&\,Z20.s(}KP db2extsec.exe | nT;ITtCC&\#+C'mS=i.s,CC'Z;NG<1,K|DMaz '#}g,g{+zDC'j6mS= DB2ADMNS i,G4zh*"z;sYNG <,T9K|Dz'# © Copyright IBM Corp. 1993, 2012 27 +C'j6mSA DB2ADMNS M DB2USERS C'i (Windows) ZI&jI DB2 20.s,TZh*ZzwOKP>X DB2 &CLrM$_DC', zXk+b)C'mS= DB2ADMNS r DB2USERS i#DB2 20Lra4(=v Bi#IT9CB{F,2ITS\1!{F#1!i{* DB2ADMNS M DB2USERS#K}L2JCZyZ5}DM'z# *<.0 v XkQ20 DB2 }]bz7# v Z20 DB2 }]bz7Zd,XkQZ“* DB2 TstCYw532+T”feO !PKtCYw532+T4!r# }L *+C'mS=J1DiP: 1. %w*<"!qKP# 2. dk lusrmgr.msc,;s%w7(# 3. !q>XC'Mi# 4. !qC'# 5. !qk*mSDC'# 6. %wtT# 7. %w%tZ!n(# 8. %wmS# 9. !qJ1Di# 10. %w7(# B;=v24 g{jIK20+!q;tCBD2+T&\,Z20.s(}KP db2extsec.exe | nT;ITtCC&\#+C'mS=i.s,CC'Z;NG<1,K|DMaz '#}g,g{+zDC'j6mS= DB2ADMNS i,G4zh*"z;sYNG <,T9K|Dz'# 28 DB2 Connect 20MdC DB2 Connect Personal Edition Z 4 ?V dC DB2 Connect (E © Copyright IBM Corp. 1993, 2012 29 30 DB2 Connect 20MdC DB2 Connect Personal Edition Z 5 B <8 IBM DB2 for IBM iTcS DB2 Connect xP, S DB2 Connect Jm6L53&CLrCJ IBM DB2 for IBM i 53OD}]# }L *(",S,h*KbBPE": 1. >Xxg{#I(}dk DSPNETA 4q!KE"# 2. >XJdwX7#I(}dk WRKLIND |n(IICBPN;==)4q!KE": WRKLIND (*elan) P>T+xJdw WRKLIND (*trlan) P>nF7Jdw WRKLIND (*all) P>yPJdw 3. wz{#I(}dk DSPNETA 4q!KE"# 4. TCP/IP KZr~q{F#1!5G X’07’6DB(X’07F6C4C2’)#DB2 i f;vPm#“6 L;C”PP|, *LOCAL DPj6XkTM'z(eD RDBNAME#g{;P *LOCAL u?,G4ITmS;v,r9CS~qwOD DSPNETA |nPqCD5 3{F# © Copyright IBM Corp. 1993, 2012 31 a{ TBG;v>}: T>X5}]b?j8E" 6 = r!j8E" X5 6L !n }]b ;CD> _ ____________________ _ DLHX RCHAS2FA _ JORMT2FA JORMT2FA _ JORMT4FD JORMT4FD _ JOSNAR7B RCHASR7B _ RCHASR7B *LOCAL _ RCHASR7C RCHASR7C _ R7BDH3SNA RCH2PDH3 _ RCHASDH3 RCHASDH3 S IBM Power Systems ~qwq!b)N}1,kZBfD$wmPdkzD5: m 2. IBM Power Systems PDdCN} n N}>} zD5 A-1 >Xxg{ SPIFNET A-2 >XJdwX7 400009451902 A-4 wz{ SYD2101A A-5 TCP/IP KZr~q{F X’07F6C4C2’(1! 5) A-6 X5}]b{F NEW_YORK3 PX|`E",kND DB2 Server for VSE & VM SQL Reference (SC09-2989) D“DRDA Considerations”;Z# 32 DB2 Connect 20MdC DB2 Connect Personal Edition Z 6 B <8 DB2 z/OS f TcS DB2 Connect xP,S DB2 Connect Jm6L53&CLrCJ DB2 z/OS f 53OD}]# *<.0 g{z$F DB2 z/OS f+Nk`>c|BBq(=WNd5),kND6DB2 Con- nect C'8O7PV[tC`>c|BDwb# XZKNq >wba)KPXZ DB2 Connect ~qwr DB2 Connect M'zk DB2 z/OS f. d(" TCP/IP xg,SD8>E"# }L *dC DB2 z/OS fTSU4T DB2 Connect D,Sks,h*dC-i: v Z 34 3D:* DB2 z/OS f dC TCP/IP; v v Z 36 3D:dC DB2 z/OS f; wz}]b Z{vD5P,uo}]bC4hvX5}]b\m53(RDBMS)#Zk DB2 Con- nect (EDd{53P,9Cuo“}]b”hvDEnI\aTP;,#Z DB2 Con- nect P,uo“}]b”9IT8: System z DB2 z/OS f. Id LOCATION NAME j6D DB2 z/OS f S53#9C z/OS -display ddf |n4q! DB2 ~qw;C{"r{"IP X7MKZ# DB2 for z/OS ;CG}]b~qwD(;{F#&CLr9C;C{F4CJ DB2 for z/OS S53r DB2 for z/OS }]2mi#}]2mi'V;, DB2 S53OD&CLr""A/4,;}]#&CLr9C DB2 }]2mixg X74CJ DB2 }]2m;C#;CJD DB2 S53TC&CLr8w# r* DB2 for z/OS 'V,; DB2 ;CD`v}]b,yT;C{F`FZ Linux"UNIX M Windows }]bp{#CJ;C1,I+}]bp{CZ2 G;Cr;Cp{#;Cp{G;CDd{{F#|CZXF&CLrCJ} ]2miPDD;vS53# 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 {F4CJ V8 z/OS ~qw# IBM Power Systems ~qw IBM DB2 for IBM i,4 IBM i Yw53Dw*?V#}G53dC*9C@ "(zf"X,qr IBM Power Systems ~qwO;\fZ;v}]b# © Copyright IBM Corp. 1993, 2012 33 * DB2 z/OS f dC TCP/IP *dC DB2 Connect $w>k DB2 z/OS f V8 r|_f>.dD TCP/IP (E, XkHU/PXwz}]b~qwDxgj8E"# *<.0 8>E"Y(QvVBPiv: v }Z(} TCP/IP k;vwz}]b~qwr;C,S#+Tj+`,D==&m` vwz,S,!\?VivyhDKZEM~qEI\;,#k9Ci IP X7ki ;C,S# v ?j}]b$tZ DB2 z/OS f V8 r|_f>O# v 20KyPX8m~# v Qy]h*hCK DB2 M'z# }L 1. *9C TCP/IP ,SOD DB2 Connect,XkU/PXwz}]b~qwM DB2 Connect ~qwDE"#TZ}Z(} TCP/IP ,SD?vwz~qw,XkKbB PE": v TCP/IP services M hosts D~Z DB2 Connect $w>OD;C: Z UNIX M Linux O /etc/ Z Windows XP M Windows Server 2003 O (#* %SystemRoot%\system32\drivers\etc\,dP %SystemRoot% m> Windows 2076?<# zI\k+wzE"mSAr{~qw4\bZ`v53O,$KD~# v ?j DB2 z/OS f wzOH[D~D;C# v T DB2 z/OS f (eD TCP/IP KZE# ":Z DB2 Connect $w>M DB2 z/OS f .d;;;`X*D~q{FE"# KZE 446 Q;"a*4T DB2 Connect $w>D(ED1!KZ# v wzM DB2 Connect $w>D TCP/IP X7Mwz{# v DB2 z/OS f}]b~qwD LOCATION NAME# v 1T IBM sMz~qwOD}]b"v CONNECT ks1*9CDC'j6M \k# 2. k>Xxg\m1T0 DB2 z/OS f\m1ozq!KE"#9CBPmw*$w m4f. DB2 Connect kwz}]b~qw.dD?v TCP/IP ,S# m 3. C'E" N< hv y>5 zD5 TCP-1 C'{ A.D.B. C' TCP-2 *5KE" (123)-456-7890 TCP-5 C'j6 ADBUSER TCP-6 }]b`M db2390 34 DB2 Connect 20MdC DB2 Connect Personal Edition m 3. C'E" (x) N< hv y>5 zD5 TCP-7 ,S`M(Xk* TCPIP)# TCPIP TCPIP m 4. wzPDxg*X N< hv y>5 zD5 TCP-8 wz{ MVSHOST TCP-9 wz IP X7 9.21.152.100 TCP-10 ~q{F db2inst1c TCP-11 KZE 446 446 TCP-12 ;C{ NEW_YORK3 TCP-13 C'j6 TCP-14 Password ": a. *q!wzD IP X7 TCP-9,kZwzOdk: TSO NETSTAT HOME b. *q!KZE TCP-11,kZ DB2 wX7Udr53U>P0R DSNL004I# m 5. DB2 Connect M'zM~qwODxg*X N< hv y>5 zD5 TCP-18 wz{ mcook02 TCP-19 IP X7 9.21.27.179 TCP-20 ~q{F db2inst1c TCP-21 KZE 446 446 m 6. DB2 Connect ~qwOD DB2 ?5 zD5 TCP-30 Zc{ MVSIPNOD TCP-31 }]b{F nyc3 TCP-32 }]bp{ mvsipdb1 TCP-33 DCS }]b{F nyc3 3. *?v TCP/IP wzjI;v$wm>}D1>: a. n4*CZ DB2 z/OS f wzDwz{M IP X7(TCP-8 M TCP-9)D5# b. n4*CZ DB2 Connect $w>Dwz{M IP X7(TCP-18 M TCP-19)D 5# c. 7(*CZ,SD~q{FrKZE(TCP-10"TCP-20"TCP-11 r TCP- 21)# d. 7(*,SAD DB2 z/OS f}]b~qwD LOCATION NAME# e. 7(,SAwz}]b1*CZC'j6M\kD5# 4. Z System z ~qwO: Z 6 B DB2 for z/OS 35 a. i$wzX7rwz{# b. i$KZEr~q{F# c. gPX*,9C}7DKZEM~q{F4|B~qD~# d. gPX*,9C DB2 Connect $w>Dwz{M IP X7|BwzD~(r DB2 z/OS f 53y9CD“r{~qw”)# e. 7#Z"TbT,S.0B(eGn/D#I/wzxg\m1r_Zh*1 |;XFK1# f. k DB2 z/OS f \m1lizDC'j6"\kT0}]b;C{GqP'# g. 9C}7DKZE4T DB2 Connect ~qw4P PING Yw(g{wz53O D TCP/IP 'VC!n)#}g: ping remote_host_name -p port_number TBx7a)KT System z ~qwD'V:http://www.ibm.com/servers/eserver/ support/zseries/ dC DB2 z/OS f ZIT9C DB2 Connect .0,DB2 z/OS f \m1XkdC DB2 z/OS f TJm 4T DB2 Connect $w>D,S# XZKNq >Z8>Jm DB2 Connect M'zk DB2 z/OS f }]b~qw(",Syh*D n ! | B # P X | j8D > } , k N D DB2 z/OS f20 D 5 : http:// publib.boulder.ibm.com/infocenter/imzicrND DB2 for z/OS 20VaPD DDF 20 =h# 36 DB2 Connect 20MdC DB2 Connect Personal Edition Z 7 B <8 DB2 for VSE & VM TcS DB2 Connect xP ,S XZKNq PXgN+ DB2 ~qw VM M VSE f hC*&CLr~qwDE",kND DB2 Server for VSE & VM SQL Reference (SC09-2989) D“DRDA Considerations”;Z# © Copyright IBM Corp. 1993, 2012 37 38 DB2 Connect 20MdC DB2 Connect Personal Edition Z 8 B dCksMzMPM~qwD,S 20 DB2 Connect "+}]b~qwdC*S\(Es,h*Zb=v53.d(" ,S"xPwZ#k6L53D,SG9C|nP&mw (CLP) ("D# dCk IBM sMz}]b~qwD,S I9C DB2 |nP&mw (CLP) Z DB2 Connect ~qwk IBM sMz}]b.d V/dC TCP/IP ,S#PX9C db2dsdriver.cfg dC,SDj8E",kNDPX db2dsdriver dCD~Dwb# *<.0 Z DB2 Connect k IBM sMz}]b~qw.dV/dC TCP/IP ,S.0,7#: v TCP/IP Z DB2 Connect ~qwM IBM sMz53OI9C# v Q-j6KBPN}5: – wz{(hostname)r IP X7(ip_address) – ,S~q{F(svcename)rKZE/-i(port_number/tcp) – ?j}]b{F(target_dbname) – >X}]b{F(local_dcsname) – Zc{(node_name) }L *Z DB2 Connect ~qwk IBM sMz}]b.dV/dC TCP/IP (E,k4P BPYw: 1. Z DB2 Connect ~qwOdC TCP/IP#kNDZ 34 3D:* DB2 z/OS f dC TCP/IP;# 2. `? TCP/IP Zc# kND6Command Reference7PD:CATALOG TCPIP/TCPIP4/ TCPIP6 NODE |n;wb# 3. + IBM sMz}]b`?*}]b,S~q (DCS) }]b# kND6Command Reference7PD:CATALOG DCS DATABASE |n;wb# 4. `? IBM sMz}]b# kND6Command Reference7PD:CATALOG DATA- BASE |n;wb# 5. +5CLrM&CLrs(= IBM sMz}]b~qw#kNDZ 53 3D:Z DB2 Connect Os(}]b5CLr;# 6. bT IBM sMz,S# kND6SQL Reference Volume 27PD:CONNECT(1 `)od;wb# a{ ":IZ TCP/IP -iDXw,m; IBM sMzODOwoi"zJO1,TCP/IP I \;a"4C=(*#rK,9C TCP/IP CJ6L DB2 ~qwDM'z&CLrr © Copyright IBM Corp. 1993, 2012 39 ~qwODT&zmxLP1I\&ZRp4,#I9C TCP/IP SO_KEEPALIVE W SV!n4lbN1"zKJOR TCP/IP ,SQPO# 40 DB2 Connect 20MdC DB2 Connect Personal Edition Z 5 ?V N< © Copyright IBM Corp. 1993, 2012 41 42 DB2 Connect 20MdC DB2 Connect Personal Edition Z 9 B dCT IBM sMz}]bDCJ 20 DB2 Connect "+}]b~qwdC*S\(Es,h*Zb=v53.d(" ,S"xPwZ# >ZhvgN9C DB2 |nP&mw (CLP) 4iR",SMs(A}]b~qw# © Copyright IBM Corp. 1993, 2012 43 44 DB2 Connect 20MdC DB2 Connect Personal Edition Z 10 B \'VD DB2 Connect gfoT T DB2 gfD DB2 oT'VITV`*~qwioTMM'zioT# ~qwioT+-ks?VD{""ozM DB2 }]IT9CDoT#b)oTG DB2 gf'VDoTD,/# T>XoTT>“DB2 20”r<(Linux M UNIX) db2setup |nCZi/Yw53T7(VPDoThC#g{ db2setup 'VYw53 ODoThC,G4ZT>“DB2 20”r<1+9CCoT# g{zD539CDzk3k DB2 gfy'VDzk3`,,+oT73{F4;` ,,G4(}dkTB|n+ LANG 73d?hC*J1D5,MT;IT4=*;D db2setup: bourne(sh)"korn(ksh)M bash shell: LANG=locale export LANG C shell: setenv LANG locale dP locale G DB2 gf'VDoT73# CZKPm;oTf>D“DB2 20”rXoTT>“DB2 2 0”r<# m 7. oTj6 oT oTj6 "-.o(vZ Windows =(OIC) ar © Copyright IBM Corp. 1993, 2012 45 m 7. oTj6 (x) oT oTj6 MwOQ@o br #S{Go bg rePD cn 1ePD tw K^XGo hr ]Ko cz $so dk I}]IT9CDoT#b)oTG DB2 gf'VDoTD,/# zk*9CD DB2 gfoTXkQ20Z53O#9C“DB2 20”r<20 DB2 } ]bz71,53a!P"20 DB2 }]bz7gfoT#g{+ DB2 }]bz7 46 DB2 Connect 20MdC DB2 Connect Personal Edition DgfoT|D*P420D\'VgfoT,G4 DB2 }]bz7gfoT+WH 1!hC*Yw53oT,g{CoT;\'V,G4gfoT+*"D# Z Windows O|D DB2 }]bz7DgfoT*sz|D Windows Yw53D1 !oThC# }L *Z Windows Yw53O|D DB2 }]bz7gfoT,k4PTBYw: 1. (}“XFfe”!qxrMoT!n# 2. Zxr!n!n(PDjO,TZK=h,k9Cq=!n(# 3. Zxr!n!n(PD;CBf,!qk`&oTT&D;C# 4. Z_6!n(PDCZG Unicode LrDoTBf,!q`&DoT#Z Win- dows 2008 M Windows Vista r|_f>O,Z\m!n(ODCZG Unicode L rDoTBf,%w|D53oT73"!q`&DoT#;s,53+*szX B}<,b1k%w!{# 5. Z_6!n(PD1!C'J'hCBf,!PT10C'J'M1!C'E*D ~&CyPhCr#Z Windows 2008 M Windows Vista r|_f>O,Z\m! n(OD#tJ'Bf,%w4F=#tJ',;s!P*+oThC4F=DJ '# 6. 53+*szXB}<,;sb)|DEaz'# B;=v24 kNDYw53oz,Tq!PX|D1!53oTDd{E"# |D DB2 Connect gfoT(Linux M UNIX) DB2 }]bz7DgfoTGvVZ{""ozMXoT|20 DB2 }]bz71,53a!P"20 DB2 g foT'V# XZKNq *li53OPD)+2DoT73IC,KP $ locale -a |n# Z 10 B “DB2 20”r<>XoT'V 47 }L *|D DB2 gfoT,k4PTBYw: + LANG 73d?hC*zZ{DoT73# v TZ bourne(sh)"korn(ksh)M bash shell: LANG=locale export LANG v TZ C shell: setenv LANG locale }g,*k(ofD DB2 }]bz7;w,XkQ-20K“(o”oT'V,"RX k+ LANG 73d?hC*“(o”oT73(}g,fr_FR)# V{}]D*; 1Zzwd+]V{}]1,Xk+V{}]*;*SUzwIT9CDq=# }g,1Z DB2 Connect ~qwkwzr System i }]b~qw.d+M}]1,( #+|S~qwzk3*;*wz CCSID,4.`;#g{=(zw9C;,Dzk3 r CCSID,G4+zkcS;vzk3r CCSID 3dAm;vzk3r CCSID#K *;}]IT9CDoT#b)oTG DB2 gf'VDoTD,/# T>XoTT>“DB2 20”r<(Linux M UNIX) db2setup |nCZi/Yw53T7(VPDoThC#g{ db2setup 'VYw53 ODoThC,G4ZT>“DB2 20”r<1+9CCoT# g{zD539CDzk3k DB2 gfy'VDzk3`,,+oT73{F4;` ,,G4(}dkTB|n+ LANG 73d?hC*J1D5,MT;IT4=*;D db2setup: bourne(sh)"korn(ksh)M bash shell: LANG=locale export LANG C shell: setenv LANG locale dP locale G DB2 gf'VDoT73# CZKPm;oTf>D“DB2 20”rXoTT>“DB2 2 0”r<# m 8. oTj6 oT oTj6 "-.o(vZ Windows =(OIC) ar © Copyright IBM Corp. 1993, 2012 49 m 8. oTj6 (x) oT oTj6 MwOQ@o br #S{Go bg rePD cn 1ePD tw K^XGo hr ]Ko cz $so dk I}]IT9CDoT#b)oTG DB2 gf'VDoTD,/# zk*9CD DB2 gfoTXkQ20Z53O#9C“DB2 20”r<20 DB2 } ]bz71,53a!P"20 DB2 }]bz7gfoT#g{+ DB2 }]bz7 50 DB2 Connect 20MdC DB2 Connect Personal Edition DgfoT|D*P420D\'VgfoT,G4 DB2 }]bz7gfoT+WH 1!hC*Yw53oT,g{CoT;\'V,G4gfoT+*"D# Z Windows O|D DB2 }]bz7DgfoT*sz|D Windows Yw53D1 !oThC# }L *Z Windows Yw53O|D DB2 }]bz7gfoT,k4PTBYw: 1. (}“XFfe”!qxrMoT!n# 2. Zxr!n!n(PDjO,TZK=h,k9Cq=!n(# 3. Zxr!n!n(PD;CBf,!qk`&oTT&D;C# 4. Z_6!n(PDCZG Unicode LrDoTBf,!q`&DoT#Z Win- dows 2008 M Windows Vista r|_f>O,Z\m!n(ODCZG Unicode L rDoTBf,%w|D53oT73"!q`&DoT#;s,53+*szX B}<,b1k%w!{# 5. Z_6!n(PD1!C'J'hCBf,!PT10C'J'M1!C'E*D ~&CyPhCr#Z Windows 2008 M Windows Vista r|_f>O,Z\m! n(OD#tJ'Bf,%w4F=#tJ',;s!P*+oThC4F=DJ '# 6. 53+*szXB}<,;sb)|DEaz'# B;=v24 kNDYw53oz,Tq!PX|D1!53oTDd{E"# |D DB2 Connect gfoT(Linux M UNIX) DB2 }]bz7DgfoTGvVZ{""ozMXoT|20 DB2 }]bz71,53a!P"20 DB2 g foT'V# XZKNq *li53OPD)+2DoT73IC,KP $ locale -a |n# Z 11 B “DB2 20”r<>XoT'V 51 }L *|D DB2 gfoT,k4PTBYw: + LANG 73d?hC*zZ{DoT73# v TZ bourne(sh)"korn(ksh)M bash shell: LANG=locale export LANG v TZ C shell: setenv LANG locale }g,*k(ofD DB2 }]bz7;w,XkQ-20K“(o”oT'V,"RX k+ LANG 73d?hC*“(o”oT73(}g,fr_FR)# V{}]D*; 1Zzwd+]V{}]1,Xk+V{}]*;*SUzwIT9CDq=# }g,1Z DB2 Connect ~qwkwzr System i }]b~qw.d+M}]1,( #+|S~qwzk3*;*wz CCSID,4.`;#g{=(zw9C;,Dzk3 r CCSID,G4+zkcS;vzk3r CCSID 3dAm;vzk3r CCSID#K *;r~q6p,G4Xk*?vYw53M DB2 f>iOxP;N5CLrD s(# s(5CLr+4(;vm~|,Cm~|Gby;vTs,||(&m%v4D~ PX( SQL odyhDyPE"# Q-+s(D~/PZ;p,"VpEZ bnd ?}Cw#e: connect to dbalias user userid using password bind path/bnd/@ddcsmvs.lst blocking all sqlerror continue messages mvs.msg grant public connect reset dP path T&Z DB2PATH "am5# v *+}]b5CLrk DB2 }]bxPs(,k9C|nP&mw: 1. P;A bnd ?<,4 x:\sqllib\bnd,dP x: m>20K DB2 D}/w# 2. *k}]b,S,kZ|nPDr|nP&mwPdkBP|n: connect to database_alias dP database_alias m>zk*,SD}]bDp{# 3. Z|nP&mwPdkTB|n: "bind @db2ubind.lst messages bind.msg grant public" "bind @db2cli.lst messages clibind.msg grant public" ZK>}P,bind.msg M clibind.msg Gdv{"D~,"+ EXECUTE M BINDADD X(Zh public# 4. dkgB|n,XCkC}]bD,S: connect reset ": © Copyright IBM Corp. 1993, 2012 53 1. db2ubind.lst D~|,*}]b5CLr4(m~|yhDs((.bnd)D~D Pm#db2cli.lst D~|,* CLI M DB2 ODBC }/Lr4(m~|yhD s((.bnd)D~DPm# 2. I\*(8VSE\jIs(# 3. g{z_P BINDADD (^,1zZ;N9C CLI r ODBC }/Lr1,+ T/s( CLI m~|#g{}Z9CD&CLrh*s(A}]b,G4IT9 C BIND |n44Ps(Yw# KPT:D&CLr I9CQ20D IBM }]~qwM'z49(MKP DB2 &CLr# BPwV`MD&CLr,"R53OPd{ DB2 1>,k9C db2swtch |n ZLx6X.0!q;vBD1!1>#Kb,g{ DB2 \m~qw(DAS)}Z* }%DGv1>BKP,k+C DAS F=;a;}%D1>B#qr,Z6X.sh *9C db2admin create |nXB4( DAS,"R*XBdC DAS E\93)&\ pwC# }L *S Windows P}% DB2 }]bz7,k4PTBYw: 1. I!: 9C drop database |n>}yP}]b# 7#;Yh*b)}]b#g {>}K}]b,G4yPD}]}Lr”4>} DB2 }]bz7,G4IT!qGq4PK =h# 3. IT(}TB=v!n4}% DB2 }]bz7: v mSr>}Lr I(} Windows D“XFfe”CJ|,9C“mSr>}Lr”0Z4>} DB2 } ]bz7#PXS Windows Yw53P}%m~z7D|`E",kNDYw5 3Doz# v db2unins |n ITS DB2DIR\bin ? mSr>}Lr&\r_9C db2unins /p |nr db2unins /u |n";G,KP db2unins /f |n#K|n+ T53ODyP DB2 1><4PV)D?F6X#}KC'}](}g,DB2 }] b).bDyPJ4<+;?F>}#ZKPx /f N}DK|n.0,kND db2unins |nTKbj8E"# 6X DB2 Connect(Linux M UNIX) KNqa)S Linux r UNIX Yw53P}% DB2 }]bz71h*4PD=h# XZKNq 20Bf>D DB2 }]bz7;h*4PKNq#Z Linux r UNIX O,?vf> D DB2 }]bz7<_P;,D2076,rKIT2fZ,;FczO# ":KNqJCZ9C root C'(^20D DB2 }]bz7#@"wb5wgN6X w*G root C'20D DB2 }]bz7# }L *}% DB2 }]bz7: 1. I!: >}yP}]b# I9C DROP DATABASE |n4>}}]b#1>};v 5}4;PWH>}}]b1,}]bD~ZD~53O#Vj{# 2. #9 DB2 \m~qw# kND620 DB2 ~qw7Va# 3. }% DB2 \m~qw,rKP dasupdt |nT+ DB2 \m~qw|BAm;2 076# *}% DB2 \m~qw,kND620 DB2 ~qw7Va# 4. #9yP DB2 5}# kND620 DB2 ~qw7Va# 5. }% DB2 5},rKP db2iupdt |nT+5}|BAm;2076# *}% DB2 5},kND620 DB2 ~qw7Va# 6. }% DB2 }]bz7# kND620 DB2 ~qw7Va# 56 DB2 Connect 20MdC DB2 Connect Personal Edition Z 6 ?V =< © Copyright IBM Corp. 1993, 2012 57 58 DB2 Connect 20MdC DB2 Connect Personal Edition =< A. DB2 Lr – LL v DB2 i. – PDF D~(IBX) – PDF D~(Z DB2 PDF DVD P) – !"fi. v |nPoz – |noz – {"oz ":DB2 E"PDwbD|B5JH PDF i.r2=4i.D|B5J_#*q!n BE",k20ICDD5|Br_ND ibm.com OD DB2 E"PD# zITZ_CJ ibm.com ODd{ DB2 c:http:// www.ibm.com/software/data/sw-library/# D54! RGG#XSzT DB2 D5D4!#g{zkMgNDF DB2 D5av(i,kr db2docs@ca.ibm.com "MgSJ~#DB2 D5!i+DAzDyP4!,+^(1S xzp4#k!I\a)_eD>},byRGE\|CXKbzyXDDJb#g {z*a)PX_ewbrozD~D4!,kSOjbM URL# k;*9CTOgSJ~X7k DB2 M''Vz9*5#g{zv=D5^(bvD DB2 M-kf># !\b)mj6i.P!"f,+I\4ZzyZzRrXxa)# ?N|BVa1,m%EDVaDnBf># ":DB2 E"PDD|B5JH PDF r2=4i.D|B5J_# © Copyright IBM Corp. 1993, 2012 59 m 9. DB2 SQL 4,oz DB2 z7kTI\d1 SQL oda{Du~5X SQLSTATE 5#SQLSTATE oz 5w SQL 4,M SQL 4,`zkD,e# }L *t/ SQL 4,oz,kr*|nP&mw"dk: ? sqlstate or ? class code dP,sqlstate m>P'D 5 ; SQL 4,,class code m>C SQL 4,D0 2 ;# }g,? 08003 T> 08003 SQL 4,Doz,x ?08T> 08 `zkDoz# CJ;,f>D DB2 E"PD zITZ ibm.com® OD;,E"PDPR=d{f> DB2 z7DD5# XZKNq TZ DB2 V10.1 wb,DB2 E"PD URL G http://publib.boulder.ibm.com/infocenter/ db2luw/v10r1# =< A. DB2 XD DB2 E"PDXk(ZxP|B# *<.0 XkQ20 DB2 V10.1 E"PD#PXj8E",kND20 DB2 ~qwPD“9C DB2 20r<420 DB2 E"PD”wb#yPJCZ20E"PDDHvu~M^ F,yJCZ|BE"PD# XZKNq ITT/rV/|BVPD DB2 E"PD: v T/|B+|BVPDE"PD&\?~MoT#T/|BD;vEcG,kV/ |B`H,E"PDD;IC1dOL#mb,T/|BIhC*w*(ZKPD d{z&mw5D;?VKP# v IT9CV/|B=(4|BVPDE"PD&\?~MoT#T/|BITuL |B}LPD#z1d,+g{zkmS&\?~roT,G4Xk4PV/} L#}g,g{>XE"PDnu20DG"oM(of,xVZ9*20Bo f;G4V/|B+20Bof,"|BVPE"PDD&\MoT#+G,V/ |B*szV/#9"|BMXBt/E"PD#Z{v|B}LZdE"PD; IC#ZT/|B}LP,E"PDvZ|BjIs#9$wTXBt/E"P D# Kwbj85wKT/|BD}L#PXV/|BD8>E",kND“V/|B20 ZzDFczrZ?x~qwOD DB2 E"PD”wb# }L *T/|B20ZFczrZ?x~qwOD DB2 E"PD: 1. Z Linux Yw53O, a. /@AE"PDD20;C#1!ivB,DB2 E"PD20Z /opt/ibm/ db2ic/V10.1 ?: 62 DB2 Connect 20MdC DB2 Connect Personal Edition update-ic 2. Z Windows Yw53O, a. r*|n0Z# b. /@AE"PDD20;C#1!ivB,DB2 E"PD20Z \IBM\DB2 Information Center\V10.1 ? m > Program Files ?BDT0|BsD wb#g{E"PD|B;IC,G4aZU>PmS{"#U>D~;Z doc\ eclipse\configuration ?D~{FGfzzID`E#}g, 1239053440785.log# V/|B20ZFczrZ?x~qwOD DB2 E"PD g{zQZ>X20 DB2 E"PD,G4IS IBM q!D5|B"xP20# XZKNq V/|B20Z>XD DB2 E"PD*sz: 1. #9FczOD DB2 E"PD,;sT@"==XBt/E"PD#g{T@"= =KPE"PD,G4xgODd{C'+^(CJE"PD,rxzIT&C| B#DB2 E"PDD$w>f>\GT@"==KP# 2. 9C“|B”&\?~4i4ICD|B#g{PzXk20D|B,G4k9C“ |B”&\?~4q!"20b)|B# ":g{zD73*sZ;(4,SArXxDzwO20 DB2 E"PD|B,k 9C;(Q,SArXx"Q20 DB2 E"PDDzw+|B>c5qA>XD~ 53#g{xgPPm`C'+20D5|B,G4IT(}Z>X2*|B>c Fw5q"*|B>c4(zm4uL?vK4P|Byh*D1d# g{a)K|B|,k9C“|B”&\?~4q!b)|B|#+G,;PZ%z ==BE\9C“|B”&\?~# 3. #9@"E"PD,;sZFczOXBt/ DB2 E"PD# ":Z Windows 2008"Windows Vista M|_f>O,TsP>ZK?VD|nXk w*\m1KP#*r*_P+f\m1X(D|na>{r XFfe > \m$_ > ~q#R|%w DB2 E "PD~q,"!q#9# =< A. DB2 Program Files ?: help_start 531! Web /@w+r*TT>@"E"PD# 3. %w|B4%( )#(XkZ/@wPtC JavaScript#) ZE"PDDR_f eO,%wiR|B# +T>VPD5D|BPm# 4. *t/20}L,kliz*20D!n,;s%w20|B# 5. Z20xLjIs,k%wjI# 6. *#9@"E"PD,k4PBPYw: v Z Windows O,/@A20?: help_end ":help_end E>|,2+X#99C help_start E>t/DxLyhD|n# ;*9CNNd{=(4#9 help_start E># 7. XBt/ DB2 E"PD# v Z Windows O,%w*< > XFfe > \m$_ > ~q#R|%w DB2 E "PD~q,"!qt/# v Z Linux O,dkTB|n: /etc/init.d/db2icdv10 start a{ |BsD DB2 E"PD+T>BDT0|BsDwb# 64 DB2 Connect 20MdC DB2 Connect Personal Edition DB2 LL DB2 LLozzKb DB2 }]bz7Dwv=f#b)NLa)Kp=8>E"# *<.0 zITZE"PDPi4 XHTML fDLL:http://publib.boulder.ibm.com/infocenter/ db2luw/v10r1/# 3)NL9CKy>}]rzk#PXdX(NqDNNHvu~Dhv,kNDL L# DB2 LL *i4LL,k%wjb# pureXML 8OPD:pureXML®; hC DB2 }]bTf" XML }]T0T>z XML }]f"w4Py>Y w# DB2 JOoOE" RGa)KwVwyDJOoOMJb7(E"4ozz9C DB2 }]bz7# DB2 D5 zITZJOoOMw{}]bT\r_ DB2 E"PDD“}]by!”?VP R=JOoOE",b)E"|,TBZ]: v PXgN9C DB2 oO$_M5CLr4tkM7(JbDE"# v ;)n#{JbDbv=8# v g{zv=Jb"R#{C=ozTiRI\D-rMbv=8,kCJ IBM 'VE'x>#bvca)K8rnB DB2 vfo":http://www.ibm.com/support/entry/portal/Overview/ Software/Information_Management/DB2_for_Linux,_UNIX_and_Windows E"PDunMu~ g{{OTBunMu~,G4Zhz9Cb)vfoDmI(# JCT:C'h*q- IBM Web >cD9Cun0TBunMu~# vK9C:;*#tyPD(P(yw,zMIT*vK"GL59C4Fb)vf o#4- IBM w7,b,z;ITV""9>rFwb)vfordPNN?VD] ow7# L59C:;*#tyPD(P(yw,zMITvZs5Z4F"V"M9>b) vfo#4- IBM w7,b,z;ITFwb)vfoD]ow7,r_ZzDs5 b?4F"V"r9>b)vfordPDNN?V# =< A. DB2 mI(Pw7Zh,qr;CZhTb)vfordP|,DNNE ""}]"m~rd{*6z(DNNmI("mI$r({,^[Gw>D9G5 ,D# IBM #ty]TmDPO,O*TvfoD9Cp&K IBM D(f(I IBM Tm7 ()r4}7q-TO8>E"1,7XK&yZh(^D({# ;Pzj+q-yPJCD(IM(f,|(yPD@zvZ(IM(f,zEIT BX"vZrYvZCE"# IBM Tb)vfoDZ];wNN#$#b)vfo“4V4”a),;=PNNV`D (^[Gw>D9G5,D)#$,|(+;^Z5,DXZJzMJCZ3VX( C>D#$# IBM Trademarks: IBM, the IBM logo, and ibm.com are trademarks or registered trade- marks of International Business Machines Corp., registered in many jurisdictions world- wide. Other product and service names might be trademarks of IBM or other compa- nies. A current list of IBM trademarks is available on the Web at www.ibm.com/legal/ copytrade.shtml 66 DB2 Connect 20MdC DB2 Connect Personal Edition =< B. yw >E"G*Z@za)Dz7M~q`4D#PXG IBM z7DE"GyZWNvf KD51DIqE"Raf1|B# IBM I\Zd{zRrXx;a)>D5PV[Dz7"~qr&\XT#PXz10 yZxrDz7M~qDE",krz1XD IBM zmI/#NNT IBM z7"L rr~qD}C"GbZw>r5>;\9C IBM Dz7"Lrr~q#;*;V8 IBM D*6z(,NN,H&\Dz7"Lrr~q,I\Q5Pr}Zjkk>D5Z]PXDwn({#a)>D5"4ZhC '9Cb)({DNNmI#zITCif==+mIi/Dy: IBM Director of Licensing IBM Corporation North Castle Drive Armonk, NY 10504-1785 U.S.A. PX+VZV{/ (DBCS) E"DmIi/,kkzyZzRrXxD IBM *6z( ?E*5,rCif==+i/Dy: Intellectual Property Licensing Legal and Intellectual Property Law IBM Japan, Ltd. 1623-14, Shimotsuruma, Yamato-shi Kanagawa 242-8502 Japan >un;JC"zrNNbyDunk1X(I;;BDzRrXx:International Busi- ness Machines Corporation“4V4”a)>vfo,;=PNNV`D(^[Gw>D9 G5,D)#$,|(+;^Z5,DPXGV("JzMJCZ3VX(C>D# $#3)zRrXxZ3);WP;Jmb}w>r5,D#$#rK>unI\; JCZz# >E"PI\|,JODBf>P#IBM ITf1T>JOPhvDz7M/rLrxPD xM/r|D,x;mP(*# >E"PTG IBM Web >cDNN}C<;G*K=cp{Ea)D,;TNN== d1TG) Web >cD#$#G) Web >cPDJO;GK IBM z7JOD;? V,9CG) Web >cx4DgU+IzTPP## IBM IT4|O*J1DNN==9CrV"zya)DNNE"x^kTzP#NN pN# © Copyright IBM Corp. 1993, 2012 67 >LrD;mI=g{*KbPXLrDE"To=gB?D:(i) JmZ@"4(DL rMd{Lr(|(>Lr).dxPE";;,T0 (ii) JmTQ-;;DE"xP `%9C,kkBPX7*5: IBM Canada Limited U59/3600 3600 Steeles Avenue East Markham, Ontario L3R 9Z7 CANADA ;*qXJ1DunMu~,|(3)iNBD;(}?D6Q,JOPhvDmILr0dyPICDmIJOyI IBM @] IBM M'-i"IBM zJm~mI-irNN,H-iPDuna)# K&|,DNNT\}]D5DC'&1i$dX(73DJC}]# f0G IBM z7DE"ISb)z7D)&L"dvf5wrd{I+*qCDJO Pq!#IBM ;PTb)z7xPbT,2^(7OdT\D+7T"f]TrNNd {XZG IBM z7Dyw#PXG IBM z7T\DJb&1rb)z7D)&La v# yPXZ IBM 44=rrbrDywK?jMb8xQ# >E"I\|,ZU#5qYwP9CD}]M(fD>}#*K!I\j{X5w b)>},>}PI\a|(vK"+>"7FMz7D{F#yPb){FE"|(4oTN=Dy>&CLr,b)y>5w;,Yw=(OD`L=(# g{G*4UZ`4y>LrDYw=(OD&CLr`LSZ (API) xP&CLrD *""9C"-zrV",zITNNN=Tb)y>LrxP4F"^D"V", x^kr IBM 6Q#b)>}"4ZyPu~Bw+fbT#rK,IBM ;\##r 5>b)LrDI?T"I,$Tr&\#Ky>Lr“4V4”a),R;=PNN V`D#$#TZ9CKy>Lry}pDNNp5,IBM +;P#pN# 2b)y>LrD?]=4rdNN?VrNN\zz7,D{F)(j]). K?VzkGy] IBM +>Dy>Lr\zv4D#© Copyright IBM Corp. (dkj]). All rights reserved. Lj IBM, the IBM logo, and ibm.com are trademarks or registered trademarks of Interna- tional Business Machines Corp., registered in many jurisdictions worldwide. Other prod- 68 DB2 Connect 20MdC DB2 Connect Personal Edition uct and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the web at :Copyright and trademark information; at www.ibm.com/legal/copytrade.shtml. The following terms are trademarks or registered trademarks of other companies v Linux is a registered trademark of Linus Torvalds in the United States, other coun- tries, or both. v Java and all Java-based trademarks and logos are trademarks or registered trademarks of Oracle, its affiliates, or both. v UNIX is a registered trademark of The Open Group in the United States and other countries. v Intel, Intel logo, Intel Inside, Intel Inside logo, Celeron, Intel SpeedStep, Itanium, and Pentium are trademarks or registered trademarks of Intel Corporation or its subsidiar- ies in the United States and other countries. v Microsoft, Windows, Windows NT, and the Windows logo are trademarks of Microsoft Corporation in the United States, other countries, or both. Other company, product, or service names may be trademarks or service marks of oth- ers. =< B. yw 69 70 DB2 Connect 20MdC DB2 Connect Personal Edition w} [A] 2+T C'i 27, 28 20 DB2 Connect Personal Edition 11, 23 20 CD r DVD Linux 15, 16 Solaris 19, 20 [B] oz SQL od 61 s( 5CLr DB2 Connect 53 >XoT'V (NLS) T>“DB2 20”r< 45, 49 *;V{}] 48, 52 `kV{/j6 (CCSID) +roT 48, 52 [C] }% DB2 Connect (root) Linux 56 UNIX 56 [D] sMzCJ dC 39, 43 zk3 \'V 45, 49 *; l# 48, 52 Xrzk 3'V 48, 52 [F] =8 DB2 Connect 7 CJ DB2 }]b applicationsWindows Yw53 54 [G] |B DB2 E"PD 62, 63 JOoO LL 65 *zE" 65 XZ>i v, 1 [J] LL JOoO 65 Pm 65 Jb7( 65 pureXML 65 gfoT Ev 45, 49 |D UNIX 47, 51 Windows 46, 50 [L] ,S (} Communications Server D DRDA wz 34 1S,S IBM i 7 1S,S System z wz 7 [M] |n db2setup T>XoTT>“DB2 20”r< 45, 49 ?<#= )9 Windows 24, 25 [P] dC ,SAsMz 39 DB2 Connect Personal Edition 11 TCP/IP 9C CLP 39 [Q] 1!oThC Windows 46, 50 © Copyright IBM Corp. 1993, 2012 71 [S] yw 67 5CLr s( 53 >} DB2 Connect 7 }]b wz 33 }]b&CLr *" 53 +r CCSID 'V oT'V 48, 52 [T] unMu~ vfo 65 (E-i DRDA wzCJdC 34 [W] D5 Ev 59 9CunMu~ 65 !"f 59 PDF D~ 59 Jb7( LL 65 ICDE" 65 [X] 6X DB2 Connect 55 Windows 55 root C'20 56 [Y] &CLr ODBC 53 C'J' 20XhD (Windows) 23 C'i 2+T 27, 28 mSA 27 DB2ADMNS 27, 28 DB2USERS 27, 28 oT +r'V 48, 52 CZoTj6D“DB2 20”r< 45, 49 DB2 gf 46, 50 DB2 Connect gf 45, 49 oT73 DB2 Connect gfoT 45, 49 KPT:D&CLr }]~qwM'z Q20 54 [Z] PMz~qw dC,S 39 wz}]b dC TCP/IP 39 *; V{ 48, 52 C CD 20 Linux 15, 16 Solaris 19, 20 D DB2 E"PD f> 61 |B 62, 63 DB2 Connect 20 G\m1C' 25 z7 5 ELMZfhs 11, 12 ~qwz7 20(Solaris Yw53) 18 Ev 5 DB2 for VSE & VM 37 IBM i ,S 31 Personal Edition 20(Ev) 11 20 (Linux) 13, 15 20 (Windows) 21, 22 20(Solaris) 16 dC 11 Windows C'J' 23 DB2 for VM & VSE <8S DB2 Connect xP,S 37 DB2 for z/OS |B53m 36 DB2ADMNS i mSC' 27, 28 DB2 Connect Personal Edition 27 db2setup |n oThC 45, 49 DB2USERS C'i mSC' 27, 28 72 DB2 Connect 20MdC DB2 Connect Personal Edition DB2USERS C'i (x) DB2 Connect 27 DVD 20 Linux 15, 16 Solaris 19, 20 L LANG 73d? hC 45, 47, 49, 51 Linux 20 CD 15, 16 DB2 Connect Personal Edition 13 DVD 15, 16 }% DB2 Connect (root) 56 6X DB2 Connect root C' 56 O ODBC QtCD&CLr 53 S Solaris Yw53 20*s DB2 Connect ~qwz7 18 20 CD r DVD 19, 20 20 DB2 Connect Personal Edition 16 SQL od oz T> 61 System i }]b~qw dC TCP/IP 39 T TCP/IP dC wz,S 7, 34 wz}]b~qw 39 System i }]b~qw 39 DB2 for z/OS dC 33 U UNIX }% DB2 Connect (root) 56 UNIX (x) |D DB2 Connect gfoT 47, 51 6X DB2 root C' 56 6X DB2 Connect root C' 56 V VTAM <8 z/OS TcS DB2 Connect xP,S 33 W Windows 20 DB2 Connect(_PG\m1C'CJ() 25 DB2 Connect Personal Edition (}L) 21 1!oThC 46, 50 6X DB2 Connect 55 C'J' DB2 Connect Personal Edition 20 23 Windows Yw53 20 DB2 Connect Personal Edition (*s) 22 Z z/OS dC DB2 }]b53 36 [XpV{] “DB2 20”r< oTj6 45, 49 w} 73 74 DB2 Connect 20MdC DB2 Connect Personal Edition  Printed in China S151-1773-00 Spine information: IBM DB2 Connect 10.1 DB2 Connect 20MdC DB2 Connect Personal Edition 

还剩84页未读

继续阅读

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

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

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

下载pdf

pdf贡献者

yulewo123

贡献于2016-11-06

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