安装ibm bata server client


IBM DB2 10.1 for Linux, UNIX, and Windows 20 IBM Data Server Client G151-1751-00  IBM DB2 10.1 for Linux, UNIX, and Windows 20 IBM Data Server Client G151-1751-00  "b 9CKE"0d'VDz70,kHDAZ 65 3D=< C, :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 2012. ?< XZKvfo .............v Z 1 ?V IBM }]~qwM'z ...1 Z 1 B IBM }]~qwM'zri ...3 IBM }]~qwM'zM}/LrEv......3 IBM Data Server Driver Package Ev ......3 ,SAPMzMsMz}]b .........4 v?M|nP&mw (CLPPlus) ........4 M'z"}/LrM~qw6piO.......5 Z 2 ?V 20 IBM }]~qw}/ Lr| ...............7 Z 2 B IBM }]~qw}/Lr|20* s .................9 ELMZf*s .............9 20*s (Windows) ............9 20hs(Linux M UNIX).........10 Z 3 B 20 IBM }]~qw}/Lr| 11 Windows ...............11 20 IBM Data Server Driver Package (Windows) 11 20 IBM Data Server Driver Package (Windows) D|nP!n .............11 Linux M UNIX .............12 20 IBM Data Server Driver Package(Linux M UNIX) ...............12 Z 3 ?V IBM }]~qw}/Lr |D}]b,S...........13 Z 4 B M'zA~qw(EdCEv ..15 Z 5 B (E-i ..........17 Z 6 B dCD~ db2dsdriver.....19 Z 7 B db2dsdcfgfill - 4(dCD~ db2dsdriver.cfg ...........23 Z 8 B i$ IBM }]~qw}/Lr| 20 ................25 9C CLPPlus bTM'z=~qwD(E ....25 9C CLI bTM'z=~qwD,S ......25 9C ADO.NET bTM'z=~qwD,S ....27 Z 4 ?V IBM }]~qw}/Lr |O"#i.............31 Z 9 B IBM }]~qw}/Lr|5} O"#i (Windows) .........33 Z 5 ?V 6X ..........35 Z 10 B 6X IBM Data Server Driver Package (Windows) .........37 Z 11 B 6X IBM Data Server Driver Package(Linux M UNIX) ......39 Z 6 ?V =< ..........41 Z 12 B IBM }]~qwM'z Ev 43 Z 13 B 20 IBM }]~qwM'z (Windows) ............45 Z 14 B 20 IBM }]~qwM'z (Linux M UNIX) .........49 Z 15 B 6X IBM }]~qwM'z 51 Z 7 ?V =< ..........53 =< A. DB2 }]bz7Mr|E"...55 =< B. DB2 SQL 4,oz ......59 CJ;,f>D DB2 E"PD ........59 |B20ZFczrZ?x~qwOD DB2 E"P D .................60 V/|B20ZFczrZ?x~qwOD DB2 E "PD ................61 DB2 LL ...............63 DB2 JOoOE" ............63 E"PDunMu~ ...........63 =< C. yw ............65 w} ................69 © Copyright IBM Corp. 2012 iii iv 20 IBM Data Server Client XZKvfo g{zk20MdC IBM }]~qwM'zr}/LrT0hC]M'zr DB2 Con- nect™ ]M'z73,G4&DA>i# © Copyright IBM Corp. 2012 v vi 20 IBM Data Server Client Z 1 ?V IBM }]~qwM'z © Copyright IBM Corp. 2012 1 2 20 IBM Data Server Client Z 1 B IBM }]~qwM'zri IBM }]~qwM'zM}/LrEv P8V`MD IBM® }]~qwM'zM}/LrIC#?VM'zM}/Lrij8XV[K IBM Data Server Driver Pack- age D20M6X}L#zITZ>iD=# v 'V9C ODBC"CLI"PHP r Ruby CJ}]bD&CLr# v Z Windows Yw53O,'V9C .NET r OLE DB D&CLrCJ}]b#K b,K}/Lr|9TI203qDN=a)#9CO"#i,IaIZyZ Win- dows Installer D20P6k}/Lr# © Copyright IBM Corp. 2012 3 v 'V(}9C JDBC T Java oT`4DM'z&CLrM!Lr0'VCZ Java (SQLJ) D6k= SQL# v 'VKP6k= SQL &CLr#;a)$`kwrs(&\# v CZX( PHP"Ruby"Python M Perl }/LrD&CLr7D~#Z IBM Data Server Driver Package P4a) Python M Perl }/Lr;+GIT(}9Cb) 7D~4BXM9(b)}/Lr# v (} db2cli |n'V DB2 ;%= CLI# v (} db2drdat |n'V DRDA® zY# ,SAPMzMsMz}]b 9C IBM Data Server Driver Package,IT,SAsMzMPMz=((4:OS/390® M z/OS®"System i®"VSE M VM =()OD DB2 }]b#9IT,SA{ODis- tributed Relational Database Architecture™ (DRDA) -iDd{}]b# *9C IBM Data Server Driver Package ,SA z/OS ~qwr System i ~qw,X k$n DB2 for z/OS S53OD DB2 Connect mI$\?#*$n DB2 for z/OS S53ODmI$\?: 1. 7# Java KP173 1.4.2 r|_f>Zz*KP$n5CLrD DB2 for Linux, UNIX, and Windows $w>OIC# 2. S activation_cd_root\consv_zs\db2\license ?,SAPMzrsMz}]b: v >X20 IBM Data Server Driver Package,"9C|1S,SAwz# v (}PdD DB2 Connect ~qwxX,SA,;(wzr_;,wz# v?M|nP&mw (CLPPlus) |nP&mwv?f (CLPPlus) a)|nPC'gf,9CCgfIT,SA}]b" (e"`-MKPod"E>M|n# CLPPlus I9d|nP&mw (CLP) a)D&\#CLPPlus |(BP&\?~: v Zza)}]bC'j6M\k1,'V("=}]bD,S# v ICZf"E>"E>VN"SQL od"SQL PL odr PL/SQL odTxP`- ;s4PD:f#ITP>"r!r`-:fPDD>,rw*z&mE>KPC :fPDD># v ICZ(eIZC:fPf"Dd?MV{.D+fD&mw|n/O# v lwPX}]bM}]bTsDE"D|n/O# v ZD~Pf":fr:fdvD&\# v CZq=/E>Mi/dvD`v!n# 4 20 IBM Data Server Client v 'V4P53(eD}L# v 'V4PYw53|n# v G<4P|n"odrE>DdvD!n# CLPPlus v'V SERVER"SERVER_ENCRYPT M KERBEROS O$# M'z"}/LrM~qw6piO I+wVf>DM'zr}/Lr,S=PMzMsMz~qwO;,f>D~qw M DB2 }]b# IBM DB2 pureScale® Feature &\h*D DB2 M'z6p *KC&CLrdV9C DB2 pureScale &\,DB2 M'zXkZ3v"P6p: ~qwf> M'zf> IC&\ V9.8 r|_f> f> 9.7 ^)| 1 r|_f> Bq6pM,S6p$w:X=b yZ$w:XDM'zT/XB7I M'zW5X5 V9.8 r|_f> f> 9.1"V9.5 r V9.7(FP1 .0Df>),S6p$w:X=b(Bq6p$w:X=b;IC) yZ$w:XDM'zT/XB7I DB2 V9.1"DB2 V9.5"DB2 V9.7 M DB2 V10.1 M'zM~qwD iO (#,DB2 V9.1"DB2 V9.5 M DB2 V9.7 M'zDM'zM DB2 ~qw;Z,;v53O,G49CxLd(E (IPC)D>XM'zk~qw,S;\'V#;x,I(}9C TCP/IP (",Sw* 6L,S(F*XM,S)# IBM Data Server Driver Package ICJO_rOMf>D~qw#+G,1O_f> D}/LrCJOMf>D~qw1,^(+O_f>D&\CZCM'z#}g, IBM Data Server Driver Package V10.1 ICJ DB2 V9.1 ~qw;+G,^(+ DB2 V9.7 &\CZCM'z#*9CC~qwDnB&\,k(F=nBf>D~qw# DB2 V10.1 MsPMz=(OD DB2 z7DiO DB2 ~qw'VSsPMz=(ODTBM'zCJ: v DB2 for z/OS and OS/390 V8 r|_f> v DB2 i5/OS® ff> 5 r|_f> v DB2 VM fM VSE ff> 7 Z 1 B IBM }]~qwM'zri 5 6 20 IBM Data Server Client Z 2 ?V 20 IBM }]~qw}/Lr| © Copyright IBM Corp. 2012 7 8 20 IBM Data Server Client Z 2 B IBM }]~qw}/Lr|20*s ELMZf*s 7#zD IBM Data Server Driver Package 20Pc;DELUd?IC,"RQ`& VdZf# EL*s IBM Data Server Driver Package h*DnMELUdsG;V_620=(,TZs`} C';Fv9CK=(# v IBM Data Server Driver Package D1!2076* Program Files\IBM\IBM DATA SERVER DRIVER#g{Z,;zwO20 IBM Data Server Driver Package D`v1 >,G41!?<{F* Program Files\IBM\IBM DATA SERVER DRIVER_nn,dP nn G9C?<{I*(;{FDzID`E#}g,g{zZ,;zwO20m;v 1>,G41!?<{* Program Files\IBM\IBM DATA SERVER DRIVER_02# *20 IBM Data Server Driver Package m~|,*qC|,K}/Lr|D9uD~: 1. k*A IBM Support Fix Central Web >c (www.ibm.com/support/fixcentral/)# 2. Sz7iPm,!qE"\m# 3. Sz7Pm,!q IBM Data Server Client Packages# 4. S20f>Pm,!qX(f>ryPf># 5. S=(Pm,!qX(=(ryP=(,;s%wLx# ZB;vA;OYN%wLx,+rz9>ICZzD=(DyPM'zM}/Lr |DPm# © Copyright IBM Corp. 2012 9 20hs(Linux M UNIX) Z Linux M UNIX Yw53P,BP^FJCZ IBM Data Server Driver Package: v XkVp20 IBM Data Server Driver Package# v ^(+NNd{}]bz720= IBM Data Server Driver Package yZD76# *20 IBM Data Server Driver Package m~|,*qC|,K}/Lr|D9uD~: 1. k*A IBM Support Fix Central Web >c (www.ibm.com/support/fixcentral/)# 2. Sz7iPm,!qE"\m# 3. Sz7Pm,!q IBM Data Server Client Packages# 4. S20f>Pm,!qX(f>ryPf># 5. S=(Pm,!qX(=(ryP=(,;s%wLx# ZB;vA;OYN%wLx,+rz9>ICZzD=(DyPM'zM}/Lr |DPm# 10 20 IBM Data Server Client Z 3 B 20 IBM }]~qw}/Lr| Windows 20 IBM Data Server Driver Package (Windows) TB?VhvKZ Windows Yw53O20 IBM Data Server Driver Package D}L# }L *S Windows OD^)|3q20 IBM Data Server Driver Package,k4PTBY w: 1. S IBM Support Fix Central Web >c (www.ibm.com/support/fixcentral/) BX|, 20LrD}/Lr|# 2. **<20BXD IBM Data Server Driver Package,kKP20I4PD~# 3. S\mI-iPDun# 4. !q IBM Data Server Driver Package D2076# 5. a) IBM Data Server Driver Package 1>{F,b&CLr|D20;C#1! 1>{FG IBMDBCL1# 6. 7#(}i$20hC8(yP`&76# a{ VZQ+ IBM Data Server Driver Package 20Z20}LP8(D;C# B;=v24 IT!qTX4( db2dsdriver.cfg dCD~,"9C}]b?#PX Windows Installer !nD|`E",kND http://www.msdn.microsoft.com/# /n [copy_name] 8(#{209CD1>{F#g{1>QfZ,G4+TC1>4P,$2 0#qr,+9C8(D1>{F4PB20#8(K!na2GZl&D~ PD2076# /o 8(*9CyzID1!1>{F44PB1>20# /u [response_file] 8(l&D~Dj{76MD~{# /m T>20ZdDxH0Z#+G,;aa>zdkNNZ]#+K!nk /u ! ndO9C# © Copyright IBM Corp. 2012 11 /l [log_file] 8(U>D~Dj{76MD~{# /p [install_directory] |Dz7D2076#8(K!na2GZl&D~PD2076# /i language 8(*4P20DoTD+V8oTzk# /? zIC(E"# BP>}T>gN9C3)|nPN}: v *9CyzID1!1>{F420B1>,k"vTB|n: setup /o v *20m;v1>,k"vTB|n: setup /n "copy_name" v *4Pl&D~20,k"vTB|n: setup /u "[Full path to the response file]" y>l&D~fZZ \samples S?i~gBy>: M'z (ED"p=#KG+I IBM Data Server Driver Package d1# Server 4TCM'zD(EksDSU=#KG+(#I DB2 for Linux, UNIX and Windows ~qwz7d1#1a= DB2 Connect z71,uo~qw2IT m>PMzrsMz=(OD DB2 ~qw# (E-i CZZM'zM~qw.d"M}]D-i# DB2 z7'VBP-i: v TCP/IP#Cf>ITG TCP/IPv4 r TCP/IPv6# v |{\@#K!nvZ Windows Yw53Oa)# =Si~JCZ3)73: a?6?XzwOD}]b?}G, IBM Data Server Driver Package 9C TCP/IP ("k DB2 ~qwD(E# hC~qwT9C*"731(g IBM Data Studio),I\Zu< DB2 ,S1av =ms{" SQL30081N#I\D-rG6L}]b~qwD@p=h9(",S#Zb VivB,ki$Gq}7dCK@p=4S\M'zD,Sks# © Copyright IBM Corp. 2012 15 16 20 IBM Data Server Client Z 5 B (E-i S IBM Data Server Driver Package ,S= DB2 ~qwD\'VD-i|(BPZ]: v (}9C DB2 Connect z7S IBM }]~qwM'z ,S=PMzMsMzwz v +PMzrsMz=(,S= DB2 for Linux, UNIX, and Windows }]b TCP/IP -iZa)K DB2 for Linux, UNIX, and Windows m~DyPYw53O\ 'V#TCP/IPv4 M TCP/IPv6 <\'V#IPv4 X7_P;vD?Va9,}g, 9.11.22.314#IPv6 X7_P;vK?V{F,dP?v?VIDv.yxF}ViI" I 0 E V t # = v 0 E (::) m > ; v r ` v c / , } g , 2001:0db8:4545:2::09ff:fef7:62dc# DB2 }]bz79'V SSL -i"S\4T9C IBM Data Server Driver Package D &CLrD SSL ks# mb,Windows |{\@-iZ Windows xgO\'V# \'V+fZ^FD&\ IBM Data Server Driver Package 'V_P^FD3)&\: v 'Va?6?X}]b?<#+;G9C>X}]b?<,xG9C db2dsdriver.cfg dCD ~#db2dsdriver.cfg dCD~T IBM Data Server Driver Package DdCa)DX F,}KC}]b? M jGP#K?VPDX |VvJCZX(}]4{F# }]bE" K?V|,Z M jGP#K?VPDX|VvJ CZX(}]b,S# *tC_ICT&\,IZ}]bE"?V(e=vSZ: $w:Xyb KSZ|,Z M jGP#ZKSZP,zI8(k$ w:Xac`XDX|V# T/M'zXB7I KSZ|,Z M jGP#ZKSZP,zI8(kT /M'zXB7IX*DN}# +VtT K?V|,Z M jGP#K?VPDN}JC ZyP}]bMp{# LDAP K?V|,Z M jGP#zIT9CK?V8 ( LDAP ~qwE"# db2dsdriver.cfg D~D>} TBy> db2dsdriver.cfg dCD~P;v}]4{F?V(9C M jG)";v}]bE"?V(9C M jG) M;v+VtT?V(9C M jG): © Copyright IBM Corp. 2012 19 db2dsdriver dCD~^F BP^FJCZ db2dsdriver.cfg dCD~: v db2dsdriver.cfg dCD~'V;i;BD!4 XML jG#;'VB._ (_)#XML jGtT(zZb)tT.d8(K IBM Data Server Driver Package dCX|V) I|,s4"!4MB._ (_) V{# v TZ_PBPtTD}]b,dCD~^(|,`v`,Du?:}]b{F"~ qw{FMKZE#Kb,CdCD~;\|,`v`,}]bp{u?# v u?(p{"{F"wzMKZ)M u?({F"wzM KZ)Xk|,5# v g{zZ;vPO(e`vN},G4+vTb)N}# db2dsdriver dCD~;C db2dsdriver.cfg d C D ~ ; f DB2 m ~ ; p a ) # + G , a ) K db2dsdriver.cfg.sample y>dCD~4ozzkE#9C db2dsdriver.cfg.sample D~DZ]IZy>dCD~yZD`,;C4( db2dsdriver.cfg D~#y>dCD ~D;C!vZ}/Lr`MMYw53#TZ IBM Data Server Driver Package,Z BPdP;v76P4(CdCD~: v Z AIX®"HP-UX"Linux r Solaris Yw53O:install_path/cfg v Z Windows XP Professional M Windows Server 2003 O:C:\Documents and Settings\All Users\Application Data\IBM\DB2\driver_copy_name\cfg v Z Windows Vista"Windows 7 M Windows Server 2008 O:C:\ProgramData\IBM\ DB2\driver_copy_name\cfg zIT9C DB2DSDRIVER_CFG_PATH "amd?* db2dsdriver.cfg D~8(m;;C# IT4FM`- db2dsdriver.cfg dCD~#Zz`-CD~s,XkXBt/ ODBC"CLI".NET"OLE DB"PHP r Ruby &CLrE\9|Dz'# g{fZ IBM }]~qwKP1M'z or IBM }]~qwM'z,G4IT(}9 C db2dsdcfgfill |n+VP}]b?X}]b?<"Zc?X`?6LD}] b,RIT*`?D}]b(eM'zN}#IBM }]~qwM'z M IBM }]~ qwKP1M'z S?<}]bIz}]b"wzMKZE","9CKE"Z db2dsdriver.cfg dCD~PiR`&Du?# Z 6 B dCD~ db2dsdriver 21 22 20 IBM Data Server Client Z 7 B db2dsdcfgfill - 4(dCD~ db2dsdriver.cfg Zz20 IBM Data Server Driver Package s,ITKP db2dsdcfgfill |nT4( MndK$IAq=D db2dsdriver.cfg dCD~# hv 9C db2dsdcfgfill |n+}]b?4T V9.7 FP2 rOMf>,G4af;C1>#mb,g{;P*KN}8(5,G4aZ 3v?iZ 6 BP D“db2dsdriver dCD~”wb# -? T>C(E"# C(5w Z;P -migrateCliIniFor.NET N}DivBKP db2dsdcfgfill |n,g{Zdv ?E"i$ IBM Data Server Driver Package(ds }/Lr) D20# *i$ CLPPlus $wGq}#,k4PBPYw: 1. ZYw53Da>B,(}"vxP username M dsn_alias N}D clpplus |n t/ CLPPlus#TZ dsn_alias N},8( db2dsdriver.cfg D~P(eD DSN p { sampledsn# clpplus username@sampledsn 2. vVa>1,dkkza)DC'{`X*D\k# I&,S= sampledsn DSN p{8> CLPPlus $w}##TBy>dvT>==i$ }LMI&D,S: C:\>clpplus db2admin@sampledsn CLPPlus:V1.4 Copyright (c) 2009, 2011, IBM CORPORATION. All rights reserved. dk\k:********** }]b,SE":--------------------------------- wz{ = samplehost.domain.com }]b~qw = DB2/NT SQL09074 SQL Z(j6 = db2admin >X}]bp{ = SAMPLEDSN KZ = 19766 9C CLI bTM'z=~qwD,S q-8>E"9C CLI Ti$ IBM Data Server Driver Package(ds }/Lr)D2 0# IT"v db2cli validate -dsn sampledsn Ti$ db2dsdriver.cfg D~PdCD DSN p{ sampledsn#g{b)u?}7,G4i$I&# Linux Yw53Dy>dvgBy>: C:\Program Files\IBM\IBM DATA SERVER DRIVER\bin>db2cli validate -dsn sampledsn db2cli validate -dsn alias1 IBM DATABASE 2 Interactive CLI Sample Program (C) COPYRIGHT International Business Machines Corp. 1993,1996 All Rights Reserved Licensed Materials - Property of IBM US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp. --------------------------------------------------------------------------- [ CLI Driver Version : 09.07.0000 ] [ Informational Tokens : "DB2 v9.7.0.5","s111017","IP23292","Fixpack 5" ] [ CLI Driver Type : IBM Data Server Driver For ODBC and CLI ] --------------------------------------------------------------------------- © Copyright IBM Corp. 2012 25 db2dsdriver.cfg Schema Validation : Success: The schema validation operation completed successfully. The configuration file /home/hotel75/ashojose/DS/dsdriver/cfg/db2dsdriver.cfg is valid Note: The validation operation utility could not find the configuration file named db2cli.ini. The file is searched at /home/hotel75/ashojose/DS/dsdriver/cfg/db2cli.ini db2dsdriver.cfg Validation : --------------------------------------------------------------------------- [ DB2DSDRIVER_CFG_PATH env var : unset ] [ db2dsdriver.cfg Path : /home/hotel75/ashojose/DS/dsdriver/cfg/ db2dsdriver.cfg ] --------------------------------------------------------------------------- [ Valid keywords used for DSN : alias1 ] Keyword Value -------------------------------------------------- DATABASE name1 HOSTNAME server1.net1.com PORT 50001 CURRENTSCHEMA OWNER1 [ Parameters used for WLB ] Parameter Value -------------------------------------------------- enableWLB true maxTransports 50 [ Parameters used for ACR ] Parameter Value -------------------------------------------------- enableACR true The validation completed. Z Windows Yw53O,db2cli validate |ndv|( DB2 1>{F,gTB> }y>: >db2cli validate -dsn sampledsn IBM DATABASE 2 Interactive CLI Sample Program (C) COPYRIGHT International Business Machines Corp. 1993,1996 All Rights Reserved Licensed Materials - Property of IBM US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp. --------------------------------------------------------------------------- [ CLI Driver Version : 09.07.0000 ] [ Informational Tokens : "DB2 v9.7.500.702","s111017","IP23286","Fixpack 5"] [ CLI Driver Type : IBM }]~qw}/Lr| ] [ CLI Copy Name : IBMDBCL1 ] --------------------------------------------------------------------------- db2dsdriver.cfg Schema Validation : Success: The schema validation operation completed successfully. The configuration file C:\Documents and Settings\All Users\Application Data\IBM \DB2\IBMDBCL1\cfg\db2dsdriver.cfg is valid Note: The validation operation utility could not find the configuration file named db2cli.ini. The file is searched at C:\Documents and Settings\All Users\Application Data\IBM \DB2\IBMDBCL1\cfg\db2cli.ini 26 20 IBM Data Server Client db2dsdriver.cfg Validation : --------------------------------------------------------------------------- [ DB2DSDRIVER_CFG_PATH env var : unset ] [ db2dsdriver.cfg Path : C:\Documents and Settings\All Users\ Application Data\IBM\DB2\IBMDBCL1\cfg\db2dsdriver.cfg ] --------------------------------------------------------------------------- [ Valid keywords used for DSN : alias1 ] Keyword Value -------------------------------------------------- DATABASE name1 HOSTNAME server1.net1.com PORT 50001 CURRENTSCHEMA OWNER1 [ Parameters used for WLB ] Parameter Value -------------------------------------------------- enableWLB true maxTransports 50 [ Parameters used for ACR ] Parameter Value -------------------------------------------------- enableACR true --------------------------------------------------------------------------- The validation completed. g{*9C DB2 Connect z7,+;9CyZ~qwDmI$\?r DB2 Connect ~ qw,G4Z"T,SsaqCK{": [IBM][CLI Driver] SQL1598N An attempt to connect to the database server failed because of a licensing problem. SQLSTATE=42968 *bvKms{",k4PBP=h: v g{*9C DB2 Connect Unlimited Edition for System z® z7,k9CyZ~qw DmI$\?#K=hatestconn20 -dtc "database= sampledsn;uid=username;pwd=password" mS MSDTC =h =h 1:r!f>E" .NET Framework f>:2.0.50727.3615 64 ; DB2 .NET a)Lrf>:9.0.0.2 DB2 .NET D~f>:9.7.3.2 \&;:Q(e+? 9(:20101113 Qi$;d?{F IBM.Data.DB2 D$' Qi$;d?{F IBM.Data.Informix D$' 4T DbFactory D IDS.NET G+2 IDS.NET 4}720 VSAI Q-}:1.2969165 =h 2:kT db2dsdriver.xsd #=D~i$ db2dsdriver.cfg C:\ProgramData\IBM\DB2\IBMDBCL1\cfg\db2dsdriver.cfg against C:\ProgramData\IBM\DB2\IBMDBCL1\cfg\db2dsdriver.xsd Q-}:0 =h 3:9C“database=sampledsn;uid=username;pwd=password”4xP,S ~qw`MMf>:DB2/NT 09.07.0003 Q-}:2.8594665 Step 4: Selecting rows from SYSIBM.SYSTABLES to validate existence of packages SELECT * FROM SYSIBM.SYSTABLES FETCH FIRST 5 rows only Q-}:0.3281355 Step 5: Calling GetSchema for tables to validate existence of schema functions Q-}:0.906279 =h 6:4( XA ,S DB2TransactionScope:,SQXU# Q-}:3.2657295 Q(}bT# zITvTms{" VSAI is not installed properly#"zKmsGr*,VSAI vZ 32 ;f>PIC,R;aI 64 ;D testconn20 5CLrlb=#32 ; f>D testconn20 5CLr&C}7(f VSAI E"# v *Z;P+p{mSA db2dsdriver.cfg D~DivBbTkX(~qwD,S,G 4IZ,SV{.P8(j{D,SE",gTB>}y>: C:\Program Files\IBM\IBM DATA SERVER DRIVER\bin>testconn20 -dtc "database= sample;server=samplehost.domain.com:19766;uid=username;pwd=password" v *bTZ 64 ;73PKPD 32 ;&CLrD,S,G4I9C testconn20 5C LrD 32 ;f>,gTB>}y>: C:\Program Files\IBM\IBM DATA SERVER DRIVER\bin>testconn20_32 -dtc "database= sampledsn;uid=username;pwd=password" adding MSDTC step =h 1:r!f>E" .NET Framework f>:2.0.50727.3615 DB2 .NET a)Lrf>:9.0.0.2 DB2 .NET D~f>:9.7.3.2 \&;:Q(e+? 9(:20101113 Qi$;d?{F IBM.Data.DB2 D$' Qi$;d?{F IBM.Data.Informix D$' 4T DbFactory D IDS.NET G+2 IDS.NET VSAI iO~f>:9.1.0.0 28 20 IBM Data Server Client VSAI D~f>:9.7.3.1012 Q-}:1.0000192 =h 2:kT db2dsdriver.xsd #=D~i$ db2dsdriver.cfg C:\ProgramData\IBM\DB2\IBMDBCL1\cfg\db2dsdriver.cfg against C:\ProgramData\IBM\DB2\IBMDBCL1\cfg\db2dsdriver.xsd Q-}:0 =h 3:9C“database=sampledsn;uid=username;pwd=password”4xP,S ~qw`MMf>:DB2/NT 09.07.0003 Q-}:2.8594665 Step 4: Selecting rows from SYSIBM.SYSTABLES to validate existence of packages SELECT * FROM SYSIBM.SYSTABLES FETCH FIRST 5 rows only Q-}:0.3281355 Step 5: Calling GetSchema for tables to validate existence of schema functions Q-}:0.906279 =h 6:4( XA ,S DB2TransactionScope:,SQXU# Q-}:3.2657295 Q(}bT# Z 8 B i$ IBM }]~qw}/Lr|20 29 30 20 IBM Data Server Client Z 4 ?V IBM }]~qw}/Lr|O"#i © Copyright IBM Corp. 2012 31 32 20 IBM Data Server Client Z 9 B IBM }]~qw}/Lr|5}O"#i (Windows) P=V`MDO"#iIC:DB2 5}O"#iM IBM }]~qw}/Lr|5}O "#i#(i9C IBM }]~qw}/Lr|5}O"#i# 9C IBM }]~qw}/Lr|5}D Windows Installer O"#i,ITaIX+ IBM Data Server Driver Package &\mSANN9C Windows Installer Dz7# O"#i1,aa>za)1>{F#ITZ,;zwO20 IBM Data Server Driver Package z7D`v1>,rK,&y]?v1>D(;{F4T|GxPj6#Z? v?jzwO2019CK{F#!q;v;+I\Q-CZm;v IBM }]~qw }/Lrr DB2 1>D{F#OJD{F|(zD&CLrD{F,}g, myapp_dsdrivercopy_1#g{C{F;G(;D,G4C20a'\# PXO"#iODD 5:http://msdn.microsoft.com# IBM } ] ~ q w } / L r | Merge Module.msm O " # i a ) T 9 C ODBC"CLI".NET"OLE DB"PHP"Ruby"JDBC r SQLJ TCJ}]D&CLr D'V#|9Jm&CLr9C IBM Data Server Provider for .NET(DB2 .NET Data Provider M IDS .NET Data Provider)m~#IBM Data Server Provider .NET m~G ADO.NET SZD)9,|Jm .NET &CLrlYx2+XCJ DB2 }]br Informix® }]bD}]# I(}9CO"#i4( IBM Data Server Driver Package#IBM Data Server Provider for .NET m~D"a}Ly]53O20D .NET Framework f>4xP#}g,Z 20.0,Xk20 Microsoft .NET framework 2.0# BPO"#i|,I IBM Data Server Driver Package 9CDX(ZoTD{"#Sz 7DoTx(,ZOJDO"#iP|,"20i~# IBM DSDRIVER {" - "-.o.msm IBM DSDRIVER {" - #S{Go.msm IBM DSDRIVER {" - rePD.msm IBM DSDRIVER {" - 1ePD.msm IBM DSDRIVER {" - K^XGo.msm IBM DSDRIVER {" - ]Ko.msm IBM DSDRIVER {" - $so.msm IBM DSDRIVER {" - I}Lr”0Z,C0ZI(} Windows XFfeCJ#PXS Windows Yw53} %m~z7D|`E",kNDYw53Doz# © Copyright IBM Corp. 2012 37 38 20 IBM Data Server Client Z 11 B 6X IBM Data Server Driver Package(Linux M UNIX) *6X Linux M UNIX Yw53OD IBM Data Server Driver Package,k4PTB =h# }L *6X Linux r UNIX Yw53OD IBM Data Server Driver Package,k(}"v rm -rf }%|,m~D?<# © Copyright IBM Corp. 2012 39 40 20 IBM Data Server Client Z 6 ?V =< © Copyright IBM Corp. 2012 41 42 20 IBM Data Server Client Z 12 B IBM }]~qwM'z Ev IBM }]~qwM'z _P IBM }]~qwKP1M'z D+?&\,T0CZ} ]b\m"&CLr*"MM'z/~qwdCD&\# IBM }]~qwKP1M'za)KZ6L}]bOKP&CLrD=(#GUI $_; f IBM }]~qwKP1M'z ;pa)# IBM }]~qwM'z |(BP&\: v Z Windows Yw53O,\;^t IBM }]~qwM'z 203q,Tu!ds !# v BP$_IhCM\m Q 4FM SQL 4FDyP4FLr:4FPD"ASNCLP | nPLrM4F(/`Sw$_#4FPDvZ Linux M Windows Yw53OI C# v JCZBC'D“Z;=”D5# v Visual Studio $_# v &CLr7D~# v wV`LoTD$`kLr# v s('V# v y>MLL# © Copyright IBM Corp. 2012 43 44 20 IBM Data Server Client Z 13 B 20 IBM }]~qwM'z(Windows) >wbPV[K20 IBM }]~qwM'z D8>E"M IBM }]~qwKP1M 'z#>}LhvDG;VP420 DB2 }]bz71Dr%x#{Div# *<.0 v g{zwOQ20KM'zDOMf>,G4*i4Ev}6Dwb# v 7(nJOzDh*DM'z# v R=|,203qrm;203qD DVD#*BX3q, 1. k*A IBM Support Fix Central Web >c (www.ibm.com/support/fixcentral/)# 2. Sz7iPm,!qE"\m# 3. Sz7Pm,!q IBM Data Server Client Packages# 4. S20f>Pm,!qX(f>ryPf># 5. S=(Pm,!qX(=(ryP=(,;s%wLx# ZB;vA;OYN%wLx,+rz9>ICZ Windows DyPM'zM}/L r|DPm#y]z9CDzw;,,&7#_P`&D 32 ;r 64 ;f># v 7#_P;vtZ Administrators iD Windows C'J'# ":g{zF.9CG Administrator C'J'20Cm~,G4WH20 VS2005 K P1b#IS Microsoft KP1bBX Web >cq! VS2005 KP1b#* 32 ; 53!q vcredist_x86.exe b,r* 64 ;53!q vcredist_x64.exe b# v 7#53zcyPZf"ELUdM20*s#20LraliELUdMy>5 3*s,"(*zGqfZJb# XZKNq g{zwOQ20K DB2 }]b~qwz7,G4;h*20 IBM }]~qwM' z,r* DB2 }]b~qwa)K IBM }]~qwM'z DyP&\# ^F v z^(+d{ DB2 }]bz720=BPdP;vz7yZD76: – IBM }]~qwKP1M'z – IBM Data Server Driver Package – DB2 E"PD v DB2 20rwbDd{?V|,PXd{ivDE"# }L *Z Windows Yw53O20 IBM }]~qwM'z,k4PBPYw: 1. 9CkC44P20DC'J'G<53# 2. I!: XUd{NNLr# © Copyright IBM Corp. 2012 45 3. + DVD ek}/wP#T/KP&\+t/“DB2 20”r<,Cr<7(53o T"t/CoTD20Lr# TZIBM }]~qwM'z,IT(}V/wC“DB2 20”r<,9C setup | n"8(oTzk,4TG1!53oTKP“DB2 20”r<#}g,setup -i fr |n+KP9C(oD DB2 20r<#TZ IBM }]~qwKP1M'z r IBM Data Server Driver Package,?VoT4PYw# v *20 IBM }]~qwKP1M'z,kND setup |nN}PD`X4S# IBM }]~qwKP1M'z ;Pt/e# *20 IBM }]~qwKP1M'z Dm;v1>,k"vTB|n: setup /v" TRANSFORMS=:InstanceIdn.mst MSINEWINSTANCE=1" dP n G 1# *20 IBM }]~qwKP1M'z D?vsx1>(n`P 16 v1>), k(}vS InstanceIdn 4^D|n,g: setup /v" TRANSFORMS=:InstanceId2.mst MSINEWINSTANCE=1" *c:?R(iv_6C'20`v1># v *20 IBM Data Server Driver Package,k9CBPdP;v=(: – Sz7 DVD KP setup |n# – (}STB;CBX}/Lr,S^)|3q20C}/Lr: http:// www.ibm.com/support/docview.wss?rs=71&uid=swg27007053#PX setup |n DN}DE",kND`XD4S# *20 IBM Data Server Driver Package Dm;v1>,k9CBPdPD;v =(: – (}"vTB|n9CzID1!1>{F4PBD1>20: setup /o – ZVPD1>O4P,$r}620# – (}"vTB|n9C8(D1>{F4PBD1>20: setup /n copyname 20 IBM Data Server Driver Package s,ITP!qTX4( db2dsdriver.cfg dCD~,"9C}]b? DzwO20 IBM }]~qwM'z,G4+*za)CZ20B1>r}6 DB2 UDB V8 1>D!n#20B1>a#t DB2 UDB V8 D1>"20m;v DB2 V9 1> #}6C1>I+ DB2 UDB V8 M'z5}hC4F= DB2 V9 1>, ;s}% DB2 UDB V8 1># 46 20 IBM Data Server Client ^F:g{zwQ20K DB2 UDB V8 1>,G4^(+ V9 1>hCI1!1 ># g{*20 IBM }]~qwKP1M'z,G420Lr#* w*;vsx=h}6 DB2 UDB V8 M'z5},kNDPX(FDwb# a{ Cz7VZ20Z20Zd8(D;C# Z IBM }]~qwM'zD20}LP+4( DB2 }]b\mw5}#g{;PF * DB2 Dd{5},G4C5}+F* DB2#g{Q-20K DB2 UDB V8 r DB2 V9.1 5}D1>,G41!5}* DB2_01# X(zwO IBM }]~qwM'z M IBM }]~qwKP1M'z DZ;v1> D1!2076G Program Files\IBM\sqllib#TZX(zwOD=S1>,1!?< {FG Program Files\IBM\sqllib_nn,dP nn G20ZCzwOD1>}u;#} g,g{zZ,;zwO20m;v1>,G41!?<{FG Program Files\IBM\ sqllib_01# X(zwO IBM Data Server Driver Package DZ;v1>D1!2076G Pro- gram Files\IBM\IBM DATA SERVER DRIVER#TZX(zwOD=S1>,1!?<{F G Program Files\IBM\IBM DATA SERVER DRIVER_nn,dP nn GzID9K?<(; D`E#}g,g{zZ,;zwO20m;v1>,G41!?<{* Program Files\IBM\IBM DATA SERVER DRIVER_02# zn`IT20 16 v IBM Data Server Driver Package 1>#Xk+?v1>20= ;,D?{F* DB2COPY1# IBM Data Server Driver Package D1!1>{FG IBMDBCL1# K20;|,z7D5# B;=v24 Zz20 IBM }]~qwM'z s,xPdCTCJ6L DB2 }]b~qw# 9C;G Administrators iDI1DC'J'xP20 Power Users iDI1IT20 IBM }]~qwM'z#g{ Administrators iDI 1a)TBP=8D4mI(,G4 Users iDI19IT20 IBM }]~qwM' z: v HKEY_LOCAL_MACHINE\SOFTWARE "amV' v 53?<(}g c:\WINNT)# v 1!2076 (c:\Program Files) rm;v2076 g{;vG\m1C'4PK-<20,G4G\m1C'2IT20^)|#+ G,g{G_P\m1C'J'DC'4PK-<20,G4G\m1C'M;\2 0^)|# Z 13 B 20 IBM }]~qwM'z (Windows) 47 48 20 IBM Data Server Client Z 14 B 20 IBM }]~qwM'z(Linux M UNIX) *Z Linux r UNIX Yw53O20 IBM }]~qwM'z,k4PBP8>E"# b)8>E"JCZ IBM }]~qwM'zM IBM }]~qwKP1M'z# *<.0 v g{zwOQ20KM'zDOMf>,G4*i4Ev}6Dwb# v 7( IBM }]~qwM'z r IBM }]~qwKP1M'z GqnJOzDh *# v R=zh*D DVD rd{203q#*BX3q, 1. k*A IBM Support Fix Central Web >c (www.ibm.com/support/fixcentral/)# 2. Sz7iPm,!qE"\m# 3. Sz7Pm,!q IBM Data Server Client Packages# 4. S20f>Pm,!qX(f>ryPf># 5. S=(Pm,!qX(=(ryP=(,;s%wLx# v 7#53zcyPZf"ELUdM20*s#20LraliELUdMy>5 3*s,"(*zGqfZJb# v g{*Z Solaris r HP-UX Yw53O20 IBM }]~qwM'z,G4Xk| BZKdCN}#TZ Linux Yw53,2(i4PK=h# XZKNq g{CzwQ20K DB2 }]b~qwz7,G4;h*20M'z,r* DB2 } ]b~qwa) IBM }]~qwM'z m~DyP&\# }L *Z Linux r UNIX Yw53O20NN IBM }]~qwM'z,k4PTBYw: 1. ek"20J1D DVD# 2. Z20K DVD D?4PYw#CrXoT20 IT(}V/wC DB2 20r<"8(oTzk,4TG1!53oTKP DB2 2 0r<#}g,./db2setup -i fr |n+KP9C(oD DB2 20r<#;x,DB2 20rD1!?<{* V10.1#TZX(zwOD=S1>,1!?<{FG V10.1_nn,dP nn 820D1>}u;#}g,Z~v20P;v1!?<{F V10.1_01# ZQ-fZ DB2 V9 M'zD53O20 IBM }]~qwM'z r IBM }]~q wKP1M'z,a#tC1>"20d{ DB2 V9.5 r|_f>D1>#PX+M' z5}}6A DB2 V9.5 r|_f>DE",kND}6wb# 50 20 IBM Data Server Client Z 15 B 6X IBM }]~qwM'z *20 IBM }]~qwM'z,k4PBP=h# }L v *Z Linux r UNIX Yw53O20 IBM }]~qwM'z,kS DB2DIR/ install ?<"v db2_deinstall -a,dP DB2DIR GZ20}]~qwM'z1 8(D;C# v *6X Windows Yw53OD IBM }]~qwM'z,k9CBPdP;v!n: – TZyPM'z,k9C“mS/>}Lr”0Z,C0ZI(} Windows XFfe CJ#PXS Windows Yw53}%m~z7D|`E",kNDYw53Do z# – TZ IBM }]~qwM'z,kKP db2unins |n#PX|`E",kND6| n}C7D5PD“db2unins |n”wb# © Copyright IBM Corp. 2012 51 52 20 IBM Data Server Client Z 7 ?V =< © Copyright IBM Corp. 2012 53 54 20 IBM Data Server Client =< A. DB2 }]bz7Mr|E" DB2 }]bz7PtI;,f>#9P;)I! DB2 &\?~#3) DB2 }]bz 7M&\?~vZX(Yw53OIC# BmP>K?vYw53PICD DB2 }]bz7M&\?~# m 1. DB2 }]bz7M&\?~Z UNIX Yw53PDICT DB2 }]bz7M&\?~ AIX HP-UX on IA-64 2~ Solaris on UltraSPARC 2~ Solaris on x86- 64(“x64”) 2~ DB2 Advanced Enterprise Server Edition GGGG DB2 Enterprise Server Edition GGGG DB2 $wi~qwf GGGG DB2 Personal Edition qqqq DB2 Express®f qqqG DB2 Express-C qqqG }]~qwM'zM}]~qwKP1M 'z GGGG DB2 Advanced Access Control Feature GGGG IBM DB2 Express Edition qqqG IBM DB2 Enterprise Server Edition ,94 F&\?~ GGGG IBM DB2 Enterprise Server Edition T\E /&\?~ GGGG DB2 Storage Optimization Feature GGGG m 2. DB2 }]bz7M&\?~Z Linux Yw53PDICT DB2 }]bz7M&\?~ Linux on x86-32 2~ Linux on x64 2~ Linux on IBM Power Systems™ Linux on System z DB2 Advanced Enterprise Server Edition q1 GGG DB2 Enterprise Server Edition q1 GGG DB2 $wi~qwf GGGq DB2 Personal Edition GGqq DB2 W]f GGGq DB2 Express-C GGGq }]~qwM'zM}]~qwKP1M' z GGGG DB2 Advanced Access Control Feature q1 GGG DB2 Geodetic Data Management Feature q1 G q G IBM DB2 Express Edition GGGq IBM DB2 Enterprise Server Edition ,94F &\?~ q1 GGG IBM DB2 Enterprise Server Edition T\E/ &\?~ q1 GGG © Copyright IBM Corp. 2012 55 m 2. DB2 }]bz7M&\?~Z Linux Yw53PDICT (x) DB2 }]bz7M&\?~ Linux on x86-32 2~ Linux on x64 2~ Linux on IBM Power Systems™ Linux on System z DB2 Storage Optimization Feature q1 GGG ": 1. Z DB2 Enterprise Server Edition Linux on x86-32 2~Pv'VbTM*"#+G,zIT"T9C DB2 Enterprise Server Edition yZ x86-32 D Linux f,":rr(}+IBM Database Enterprise Devel- oper EditionmI$$i20ZTCf1>O# m 3. DB2 }]bz7M&\?~Z Windows Yw53PDICT DB2 }]bz7M&\?~ Windows XP"Windows Vista M Win- dows7(32 ;f>) yZ x86 64 ;(“x64”) 2~D Windows XP"Windows Vista M Windows 7 Windows Server 2003 M Windows Server 2008(32 ; f>) Windows Server 2003 M Windows Server 2008(64 ; f>)on x64 2~ DB2 Advanced Enterprise Server Edi- tion q1 q1 GG DB2 Enterprise Server Edition q1 q1 GG DB2 $wi~qwf GGGG DB2 Personal Edition GGGG DB2 W]f GGGG DB2 Express-C GGGG }]~qwM'zM}]~qwKP1 M'z GGGG DB2 Advanced Access Control Feature q1 q1 GG DB2 Geodetic Data Management Fea- ture q1 q1 GG IBM DB2 Express Edition GGGG IBM DB2 Enterprise Server Edition ,9 4F&\?~ q1 q1 GG IBM DB2 Enterprise Server Edition T\ E/&\?~ q1 q1 GG DB2 Storage Optimization Feature q1 q1 GG ": 1. Z Windows Vista Ultimate Edition"Enterprise Edition M Business Editions T0 Windows XP Profes- sional Edition OD DB2 Advanced Enterprise Server Edition"DB2 Enterprise Server EditionM IBM Data- base Enterprise Developer EditionPv'VxPbTM*"# PX DB2 }]bz7Mr|E"DE",kND http://www-1.ibm.com/support/ docview.wss?rs=73&uid=swg21219983# PX DB2 Express-C DE",kND:www.ibm.com/software/data/db2/express 56 20 IBM Data Server Client =< B. 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. 2012 57 m 4. 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# =< B. 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 ?: 60 20 IBM Data Server Client 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# =< B. 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# 62 20 IBM Data Server Client 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# =< B. 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 64 20 IBM Data Server Client =< C. 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. 2012 65 >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- 66 20 IBM Data Server Client 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. =< C. yw 67 68 20 IBM Data Server Client w} [B] oz SQL od 59 [C] 4(dCD~|n 23 ELUd *s 9 [D] sMz}]b ,SA 4 [F] ~qw M'ziO 5 [G] |B DB2 E"PD 60, 61 JOoO LL 63 *zE" 63 [H] O"#i IBM }]~qw}/Lr|5} 33 [J] LL JOoO 63 Pm 63 Jb7( 63 pureXML 63 [K] M'z ~qwiO 5 M'zA~qw(E ,S dC 15 [M] |n db2dsdcfgfill 23 db2setup 20}]~qwM'z 49 |nP&mwv?f (CLPPlus) Ev 4 [N] Zf *s IBM }]~qw}/Lr| 9 [P] dCD~ 19 [S] yw 65 }]~qw}/LrX|V 19 [T] unMu~ vfo 63 (E-i Ev 17 [W] D5 Ev 57 9CunMu~ 63 !"f 57 PDF D~ 57 Jb7( LL 63 ICDE" 63 [X] 6X IBM }]~qwM'z 51 IBM Data Server Driver Package Linux 39 UNIX 39 © Copyright IBM Corp. 2012 69 6X (x) IBM Data Server Driver Package (x) Windows 37 [Y] C'J' IBM }]~qwM'z 45 [Z] PMz}]b ,SA 4 D DB2 z7 r| 55 ;cE" 55 DB2 E"PD f> 59 |B 60, 61 db2dsdcfgfill |n j8E" 23 db2dsdriver.cfg D~ 19 I IBM }]~qwM'z 20 Linux 49 UNIX 49 Windows 11, 45 Ev 43 `M 3 C'J' 45 IBM }]~qw}/Lr `M 3 IBM }]~qw}/Lr| 20 hC|nP!n 11 Linux 12 UNIX 12 Windows 11 20*s Windows 9 Ev 3 ^F 9 IBM Data Server Driver Package 20*s Linux 10 UNIX 10 ^F 10 i$20 9C CLI 25 IBM Data Server Driver Package (x) i$20 (x) ADO.NET 27 CLPPlus 25 DSN p{ 25 L Linux 20 IBM }]~qwM'z 49 IBM }]~qw}/Lr| 12 S SQL od oz T> 59 T TCP/IP IBM }]~qw}/Lr| 17 U UNIX 20 IBM }]~qwM'z 49 IBM }]~qw}/Lr| 12 W Windows 20 IBM }]~qwM'z 11, 45 IBM }]~qw}/Lr| 11 70 20 IBM Data Server Client  Printed in China G151-1751-00 Spine information: IBM DB2 10.1 for Linux, UNIX, and Windows 20 IBM Data Server Client 

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

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

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

下载pdf

pdf贡献者

yulewo123

贡献于2016-11-06

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