ibm数据应用程序开发入门


IBM DB2 10.1 for Linux, UNIX, and Windows }]b&CLr*"kE G151-1764-00  IBM DB2 10.1 for Linux, UNIX, and Windows }]b&CLr*"kE G151-1764-00  "b 9CKE"0d'VDz70,kHDAZ 85 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 2006, 2012. ?< XZ>i...............v Z 1 B DB2 }]b&CLr*"73 ..1 Z 2 B T}]b&CLr*"73*XD 'V ................3 Z 3 B }]b&CLr*"y'VDYw 53 ................5 DB2 ~qwM IBM }]~qwM'zD20*s (AIX) .................5 DB2 ~qwM IBM }]~qwM'zD20*s (HP-UX) ...............7 DB2 ~qwM IBM }]~qwM'zD20*s (Linux) ................10 DB2 ~qwM IBM }]~qwM'zD20*s (Solaris)................11 DB2 }]b~qwM IBM }]~qwM'zD20 *s (Windows) .............13 Z 4 B IBM Data Server Client T}] b&CLr*"D'V.........15 Z 5 B \'VD}]b&CLr`LSZ 17 * IBM }]~qw*" ADO.NET ......17 IBM Data Server Provider for .NET Ev....17 ODBC .NET Data Provider ........18 OLE DB .NET Data Provider........19 DB2 wC6SZM ODBC ri........20 6k= SQL ri ............21 \'VD JDBC M SQLJ }/Lr ......22 IBM OLE DB Provider for DB2........24 Perl DBI ...............25 * IBM }]~qw*" PHP &CLr .....25 * IBM }]~qw*" Python"SQLAlchemy M Django Framework &CLr .........26 IBM_DB Ruby }/LrM Rails Jdw .....26 Z 6 B CZ}]b&CLr*"D`Lo TM`kw .............29 \'VD .NET *"m~ ..........29 T9C C xP}]b&CLr*"D'V ....30 T9C C++ xP}]b&CLr*"D'V ...31 T9C COBOL xP}]b&CLr*"D'V ..32 T9C Fortran xP}]b&CLr*"D'V ..33 DB2 }]bz7D Java m~'V .......33 T9C Perl xP}]b&CLr*"D'V ...36 T9C PHP xP}]b&CLr*"D'V ...36 T9C Ruby/Ruby on Rails xP}]b&CLr*" D'V ................37 T9C REXX xP}]b&CLr*"D'V ...38 Z 7 B \'VDBq\mw ......39 Z 8 B \'VD}]b&CLr*"$_ 41 Z 9 B dC}]b&CLr*"73 ..43 dCYw53TxP}]b&CLr*" .....44 hC&CLr*"73(Linux M UNIX) ...44 hC&CLr*"73(Windows) .....45 dC IBM Data Server Client TxP}]b&CLr *" .................46 dC&CLr`LSZD*"73 .......47 dC*"73T9("KP CLI M ODBC &CL r ................48 20 IBM }]~qw JDBC M SQLJ }/Lr 48 Bq\mw ..............52 X/Open V<=Bq&m#M ........52 hC unixODBC }/Lr\mw ......71 =< A. DB2 }]bz7Mr|E"...75 =< B. DB2 SQL 4,oz ......79 CJ;,f>D DB2 E"PD ........79 |B20ZFczrZ?x~qwOD DB2 E"P D .................80 V/|B20ZFczrZ?x~qwOD DB2 E "PD ................81 DB2 LL ...............83 DB2 JOoOE" ............83 E"PDunMu~ ...........83 =< C. yw ............85 w} ................89 © Copyright IBM Corp. 2006, 2012 iii iv }]b&CLr*"kE XZ>i 6&CLr*"kE8O7a)KCZZBPX|lr'VMdC}]b&CLrD X|En: v }]b&CLr`LSZ v }]b&CLr`LoT v `kw v Bq\mw v *"$_ v Yw53 >ia)DE"PzZ*za)xPI&D}]b&CLr*"yXhDJ4# © Copyright IBM Corp. 2006, 2012 v vi }]b&CLr*"kE Z 1 B DB2 }]b&CLr*"73 DB2® }]b&CLr*"73ItIm~*XiI# b)m~*X|(: v Yw53 v IBM® }]~qwM'z v }]b&CLr`LSZ (API) v `LoT v Bq\mw v *"$_ TZdPm`*X,fZ`V!q#}g:I\PtIYw53ICZ2~;DB2 }] b'VtI API;I9C XA f]DNNBq\mw4\m DB2 }]bDV<=B q# S V9.7 FP3a *<,}]~qwM'za(ZwC SYSIBM.DB2CONN_LIC f"}L TxPmI$"EMdC# © Copyright IBM Corp. 2006, 2012 1 2 }]b&CLr*"kE Z 2 B T}]b&CLr*"73*XD'V DB2 }]bD&CLr*"\;5Pc:DYw53M}]bM'z,T0s?D`L SZ"oT"`kwM$_'V# TBD5wb(e DB2 z7O}]b&CLr*"D'V: v Z 5 3DZ 3 B, :}]b&CLr*"y'VDYw53; v Z 15 3DZ 4 B, :IBM Data Server Client T}]b&CLr*"D'V; v Z 17 3DZ 5 B, :\'VD}]b&CLr`LSZ; v Z 29 3DZ 6 B, :CZ}]b&CLr*"D`LoTM`kw; v Z 39 3DZ 7 B, :\'VDBq\mw; v Z 41 3DZ 8 B, :\'VD}]b&CLr*"$_; © Copyright IBM Corp. 2006, 2012 3 4 }]b&CLr*"kE Z 3 B }]b&CLr*"y'VDYw53 DB2 }]bD&CLr*"\;5PYw53Me5a9'V# ITZBPYw53O*" DB2 }]b&CLr: v AIX® v HP-UX v Linux v Solaris v Windows TZN1IT9Ca)D 32 ;r 64 ;e5a9,fZTB^F: v ZyZ x86 D Linux MyZ x86 D Windows Yw53O,v'V 32 ; DB2 } ]b5}#Z 64 ; Windows Yw53O,'V 32 ;M 64 ;5}#ZyPd{ Yw53O,DdP;v IBM }]~qwM'z4KP 32 ;}] b&CLr"R9CC 32 ;r 64 ; IBM }]~qwM'z4xP*" v Z 32 ;73P9(&CLrD=hP1;,ZZ 64 ;73P9(&CLrD=h# DB2 ~qwM IBM }]~qwM'zD20*s (AIX) Z AIX Yw53O20 DB2 }]bz7.0,&7#z!qD53{OXhDYw 53"2~"m~M(E*s#db2prereqcheck |nlizD53Gqzc20DHv u~# DB2 }]bz7PtI;,f>#3) DB2 }]bz7M&\?~vZX(Yw53 OIC# g{zF.20 IBM DB2 pureScale® Feature,G4h*;,D20Hvu~#kND :20 DB2 pureScale &\?~;wb# *20 DB2 }]bz7,Xk{OBP*s: © Copyright IBM Corp. 2006, 2012 5 m 1. AIX 20*s Yw53 2~ AIX V6.12 v h* 64 ; AIX ZK v AIX 6.1 )D~/# AIX V7.1 v h* 64 ; AIX ZK v AIX 7.1 )D~/# 64 ;+22~N<=( (CHRP) e5a9,; |(yZ POWER3 &mwD53#1 yP\KP\'VD AIX Yw53D&mw# v 1*i$|Gq* CHRP e5a953,"v lscfg |n"iRTBdv:Model Architecture: chrp#TZyZ POWER3 &mwD53,WH}6=yZ POWER4 &mwD53#;'VyZ POWER3 &mwD53# v 2Z AIX 6.1 P,P=V`MD$w:XVx (WPAR):53 WPAR M&CLr WPAR#DB2 20vZ53 WPAR O\'V#AIX 6.1 9'VT JFS2 D~53r D~/xPS\# v 3PX POWER7® 53Dd{"bBn: – POWER7 53OKPD DB2 z7'V Active Memory™ Expansion# v 9'V 32 ;M'z# ":g{9CYw53}6x;GBYw5320&CKnMYw53*s,G4X k%@20 I/O jIKZ (IOCP)#IS AIX 20 CD Pq! IOCP b"Z DB2 ~ qwOdC IOCP#g{;20M'z,G4;h* IOCP# PX|`E",kNDJ OoOMw{}]bT\PD“Z AIX OdC IOCP”# m~"bBn v PX&CLr*"MKP1"bBn,kND“CZ}]b&CLr*"D\'V` LoTM`kw”PDwb# v zITS IBM AIX XL C M C++ 'V Web >cBXnBD“CZ AIX D IBM C++ KP173i~”# v (vJCZM'z)g{F.9C Kerberos O$,G4h* IBM Network Authen- tication Service M'z V1.4 r|_f># v 9C bosboot |nP;A 64 ;ZK# *P;A 64 ;ZK,h* root C'(^"dkBP|n: ln -sf /usr/lib/boot/unix_64 /unix ln -sf /usr/lib/boot/unix_64 /usr/lib/boot/unix bosboot -a shutdown -Fr v h*BPdP;v/@w4i4*zoz"KP“Z;=”(db2fs): – Firefox 3.0 M|_f> 6 }]b&CLr*"kE – Google Chrome – Safari 4.0 v g{vVBPiv,G4h*_P\;J>#3) DB2 }]bz7M&\?~vZX(Yw53 OIC# *Z HP-UX Yw53O20 DB2 z7,XkzcBPYw53"2~M(E*s: ":h* 64 ; HP-UX Yw53'V DB2 z7# m 2. HP-UX 20*s Yw53 2~ DB2 z7ZBPYw53O\'V: v xPTB9!D HP-UX 11iv3 (11.31): – PHSS_37202 – PHKL_41481 – PHKL_42035 – PHKL_42335 – PHKL_41588 v HP-UX 11iv4 yZ Itanium D HP Integrity Series Systems T>f]Rj+\;KPy8(DY w53DNN2~"yP`&D'V m~T0`X*D4-^DDNN& CLr# ZKdC"bBn g{|BZKdCN},G4h*XBt/53#ZKdCN}GZ /etc/system Ph CD#y]ZKdCN}D5,kZ20M'zr DB2 ~qwz7.0^DdP;) N}#g{}Z^DDZKN}4/,P>,G4h*XB}<53,T9T /etc/ system ywD|Dz'# m~"bBn v libpam.so.0(32 ;)G DB2 }]b~qwKP 32 ;G SQL }LyXhDm~# v (vJCZM'z)g{F.9C Kerberos O$,G4zD DB2 &CLrXkG 64 ;# Z 3 B DB2 'VDYw53 7 v (M'zM~qw)*9C Kerberos O$,kZYw53O(} Kerberos m~|2 0 HP krb5 Kerberos 'V# v h*BPdP;v/@w4i4*zoz"KP“Z;=”(db2fs): – Firefox 3.0 M|_f> – Google Chrome – Safari 4.0 v g{*9C“DB2 20”r<420 DB2 z7,G4h*_P\;J>D^)|(0 V9.8 FP2 M|_^)|)|( IBM Tivoli® Sys- tem Automation for Multiplatforms(SA MP) Base Component D|Bf>,zIT Z_P SLES 11 r POWER7 53D73P9CCf>#PX|`E",kND:2 0 IBM Tivoli System Automation for Multiplatforms(SA MP) Base Component; r:}6 IBM Tivoli System Automation for Multiplatforms(SA MP) Base Com- ponent;# `_Le5a9V^T g{*Z Linux Yw53O20 32 ; DB2 }]bz7,kK SLES M RHEL V"z7Dm~|*s: v libpam.so.0(32 ;)G DB2 }]b~qwKP 32 ;G SQL }LyXhDm~ |# v libaio.so.1 G9Cl= I/O D DB2 }]b~qwDXhm~|# v TZ DB2 }]b~qwMM'z,libstdc++.so.6 GXhD# SLES M RHEL Dm~|*s m~|{hv libaio |, DB2 }]b~qwyhDl=b# compat-libstdc++ |, libstdc++.so.6(Linux on POWER ;h*Kn) Z 3 B DB2 'VDYw53 9 BPwmP>K DB2 Vx}]b~qwD SUSE Linux M Red Hat V"z7Dm~ |*s# v SUSE10 M RHEL5 53h* ksh93 Korn shell m~|#yPd{ DB2 }]b5 3h* pdksh Korn Shell m~|# v Vx}]b53h*6L shell 5CLr#DB2 }]b53'VBP6L shell 5C Lr: – rsh – ssh 1!ivB,T6L DB2 Zc4P|n1(}g,t/6L DB2 }]bVx1), DB2 }]b53+9C rsh#*9C DB2 }]b531!5,Xk20 rsh- server m~|(kNDBm)#DB2 Information Center a)KPX rsh M ssh D |`E"# g{!q9C6L shell 5CLr rsh,G49Xk20"KP inetd(r xinetd)#g{!q9C6L shell 5CLr ssh,G4h*ZjI DB2 20s" 4hC DB2RSHCMD (Ed?#g{;hCK"amd?,G49C rsh# v Vx}]b53h*xgD~53'Vm~| nfs-utils# ZLxxP DB2 }]b5320.0,&20"dCyPXhDm~|#PX Linux D;cE",kND Linux V"D5# SUSE Linux Dm~|*s m~|{hv pdksh r ksh93 Korn Shell# openssh Km~|P|,;i~qwLr,|GJmC'(}2+ shell Z6 LFczOKP|nr_KP4T6LFczD|n#g{+ DB2 }]b53D1!dCk rsh dO9C,G4;h*Km~|# rsh-server Km~||,;i~qwLr,|GJmC'Z6LFczOKP |n"GXD~# Red Hat Dm~|*s ?< m~|{hv /System Environment/Shell pdksh r ksh93 Korn Shell#Vx}]b73h*Km~ |# /Applications/Internet openssh Km~|P|,;iM'zLr,b)L r9C'\;(}2+ Shell Z6LFcz OKP|n#g{+ DB2 }]b53D1 !dCk rsh dO9C,G4;h*Km ~|# /System Environment/Daemons openssh-server\ Km~|P|,;i~qwLr,b)L r9C'\;(}2+ Shell S6LFcz OKP|n#g{+ DB2 }]b53D1 !dCk rsh dO9C,G4;h*Km ~|# 10 }]b&CLr*"kE Red Hat Dm~|*s ?< m~|{hv /System Environment/Daemons rsh-server Km~||,;iLr,|GJmC'Z 6LFczOKP|n#Vx}]b73 Ph*Km~|#g{+ DB2 }]b53 dC*9C ssh,G4;h*Km~|# /System Environment/Daemons nfs-utils xgD~53'Vm~|#|Jm6LF czCJ>XD~# m~"bBn v (M'zM~qw)*9C Kerberos O$,k(}Yw53 Kerberos m~|20 Linux krb5 Kerberos 'V# v h*BPdP;v/@w4i4*zoz"KP“Z;=”(db2fs): – Firefox 3.0 M|_f> – Google Chrome – Safari 4.0 v g{vVBPiv,G4h*_P\;J> SELinux _T# DB2 ~qwM IBM }]~qwM'zD20*s (Solaris) Z Solaris O20 DB2 }]bz7.0,k7#53zcYw53"2~Mm~*s# db2prereqcheck |nlizD53Gqzc20DHvu~# Z 3 B DB2 'VDYw53 11 DB2 }]bz7PtI;,f>#3) DB2 }]bz7M&\?~vZX(Yw53 OIC# m 3. Solaris 20*s Yw53 2~ Solaris 10 v 64 ;ZK v Update 9 UltraSPARC r SPARC64 &mw Solaris 10 v 64 ;ZK v Update 9 Solaris x64(Intel 64 r AMD64) v v'V DB2 z720Z>Xxrr+Vxr#Z+VxrP201,IId{xr 2m# ZKdC"bBn ZKdCN}GZ /etc/system PhCD#g{}Z^DDZKN}4/,P>,G4 h*XB}<53,T9T /etc/system ywD|Dz'#zXkHhCb)N},; sE\20 IBM }]~qwM'z# m~"bBn v libpam.so.0(32 ;)G DB2 }]b~qwKP 32 ;G SQL }LyXhDm~# v (M'zM~qw)*9C Kerberos O$,k(}ICD Kerberos m~|20 krb5 Kerberos 'V# v h*BPdP;v/@w4i4*zoz"KP“Z;=”(db2fs): – Firefox 3.0 M|_f> – Google Chrome – Safari 4.0 v g{*9C“DB2 20”r<420 DB2 }]bz7,G4h*_P\;J>cq!2+T9!#Z SunSolve Z_ Web >cO, %ws_fePD9!# 9h* Java2 Standard Edition (J2SE) Solaris Yw539!/M SUNWlibC m~,I TS http://java.sun.com Web >cqCb)Z]# Solaris Yw53D Fujitsu PRIMEPOWER 9!IS;Z http://download.ftsi.fujitsu.com/ OD FTSI BX# DB2 }]bz7'VBP Solaris En: v Solaris _-r (LDoms) v Solaris (x v ZFS D~53 12 }]b&CLr*"kE PX DB2 z7'VDib/#3) DB2 }]bz7M&\?~vZX(Yw53 OIC# m 4. Windows $w>=( Yw53 Hvu~ 2~ Windows XP Professional(32 ;M 64 ;) Windows XP Enterprise(32 ;M 64 ;) Windows XP Ultimate(32 ;M 64 ;) Windows Vista Business(32 ;M 64 ;) Windows Vista Enterprise(32 ;M 64 ;) Windows Vista Ultimate(32 ;M 64 ;) Windows 7 Professional(32 ;M 64 ;) Windows 7 Enterprise(32 ;M 64 ;) Windows 7 Ultimate(32 ;M 64 ;) Windows XP Service Pack 3 r|_f> Windows Vista Service Pack 2 Windows 7 Service Pack 1 IBM Data Server Pro- vider for .NET M'z &CLrM CLR ~q wK}Lh* .NET 2.0 r|_f>Dr\KP 1# 'V 64 ; IBM }] ~qw .NET a)Lr &CLr# \;KP\'VD Windows Yw 53(yZ 32 ;M 64 ;D5 3)DyP Intel M AMD &mw Z 3 B DB2 'VDYw53 13 m 5. Windows ~qw=( Yw53 Hvu~ 2~ Windows 2003 Datacenter Edi- tion(32 ;M 64 ;)M Win- dows 2003 R2(32 ;M 64 ;) Windows 2003 Enterprise Edi- tion(32 ;M 64 ;)M Win- dows 2003 R2(32 ;M 64 ;) Windows 2003 Standard Edi- tion(32 ;M 64 ;)M Win- dows 2003 R2(32 ;M 64 ;) Service Pack 2 r|_f># IBM Data Server Provider for .NET M'z&CLrM CLR ~qwK }Lh* .NET 2.0 r|_f>D r\KP1# 'V 64 ; IBM }]~qw .NET a)Lr&CLr# \ ; K P \ ' V D Windows Yw53(y Z 32 ;M 64 ;D5 3)DyP Intel M AMD &mw# Windows Server 2008 Datacenter Edition(32 ;M 64 ;)M Win- dows Server 2008 R2(64 ;) Windows Server 2008 Enterprise Edition(32 ;M 64 ;)M Win- dows Server 2008 R2(64 ;) Windows Server 2008 Standard Edi- tion(32 ;M 64 ;)M Win- dows Server 2008 R2(64 ;) Service Pack 2 r|_f># IBM Data Server Provider for .NET M'z&CLrM CLR ~qwK }Lh* .NET 2.0 r|_f>D r\KP1# 'V 64 ; IBM }]~qw .NET a)Lr&CLr# ":DB2 }]bz7'VZC= Windows Yw53PD2~5)}]4P#$ (DEP) &\?~# d{m~"bBn v Windows Installer 3.0 GXhD#g{20Lr4lb=|,G4MaxP2 0# v IBM Data Server Provider for .NET M'z&CLrM CLR ~qwK}L h* .NET 2.0 r|_f>Dr\KP1#Z x64 73P,32 ; IBM Data Server Provider for .NET &CLrT WOW64 Bf==KP# v g{F.9C LDAP(a?6? – Internet Explorer 7.0 M|_f> – Google Chrome – Safari 4.0 14 }]b&CLr*"kE Z 4 B IBM Data Server Client T}]b&CLr*"D'V }]~qwM'z 'V}]bD&CLr*"# }]~qwM'z |(BP&\?~: v C/C++"COBOL M Fortran $`kw(Y(oT\C=('V)# v 6k= SQL &CLr'V,dP|(`Lb"|,D~Mzky># v ODBC M DB2 wC6SZ(DB2 CLI)&CLr'V,dP|(CZ*";)& CLrD`Lb"|,D~Mzky>,I\=cX+b)&CLrF2= ODBC " 9C ODBC SDK 4T|GxP`k#IS Microsoft(TZ Windows Yw53) Md{w)&L(TZd{m`\'VD=()q! ODBC SDK#Z Windows Y w53O,1!ivB,ODBC M CLI }/Lraf DB2 M'z;p20,Sx 'V(} Microsoft ODBC Software Developer’s Kit *"D&CLr#TZd{y P=(,I!qf DB2 M'z;p20 ODBC M CLI }/Lr,Sx'V(}C =(D ODBC SDK(g{fZ)*"D&CLr# v IBM }]~qw JDBC M SQLJ }/Lr,||(TBwn: – T JDBC 3 M JDBC 4 f]D&CLrD'V – SQLJ 'V,CZ(}2, SQL *" Java &CLr v Java 5 73,6kZ DB2 ~qwPT'V|(f"}LMC'(eD/}ZZD ~qwK Java &CLr$~ v Windows Yw53OD ActiveX }]Ts(ADO)T0Ts4Sk6k(OLE)T //}L(UDF Mf"}L),dP|(T Microsoft Visual Basic M Microsoft Visual C++ 5VDzky># v Windows Yw53ODTs4Sk6k}]b(OLE DB)m/}# v Windows Yw53OD C# M Visual Basic .NET &CLrT0 CLR .NET } L# v Ruby M Ruby on Rails &CLr'V,dP|(CZrW20D IBM_DB gem Mzky>#Ruby GCZ*" Web &CLrD+f/IfrTsLrhFoT# Ruby on Rails(RoR),2F* Rails,GCZ4U Model-View-Control e5a9r \*"T}]bxPCJD Web &CLrDr\ v PHP ,D>$&mw&CLr'V,dP|(`LbMzky>#PHP GCZ*" Web &CLrDE>oT#|9'VfrTsLrhF v Data Studio GJCZ}]b*"_M*" DBA D+W/I Eclipse $_#Data Stu- dio auYBPn/yCD1d:4PU#\mNq;4("?p"wT SQL M Java f"}L;?pT}]*PDD Web Service T0(}+ SQL M XQuery CZ DB2 M Informix® }]~qw44(X5M XML }]i/# v ;%= SQL,(}|nP&mw (CLP) 4+ SQL odCw-MrT}]b4PY 1i/# v ;iQ5w API,)d{&CLr*"$_1SZdz7Z5VT DB2 D$`kw 'V#}g,AIX OD IBM COBOL 9CKSZ# © Copyright IBM Corp. 2006, 2012 15 16 }]b&CLr*"kE Z 5 B \'VD}]b&CLr`LSZ I9CTBNN`LSZ4\mrCJ DB2 }]b# ITxPBPYw: v 9C DB2 API 44Png8]M4-}]b.`D\m&\# v TZ9C C"C++"COBOL"FORTRAN M REXX `LD&CLr,+2,M/, SQL od6k=dP# v Z&CLrPT DB2 wC6SZ(DB2 CLI)/}wCxP`kTwC/, SQL o d# v 9C Java }]b,S&CLr`LSZ (JDBC API) r Java D6k= SQL (SQLJ) 4*" Java &CLrM applet# v 9C ActiveX }]Ts(ADO)4*" Microsoft Visual Basic M Visual C++ &C Lr# v 9C IBM }]~qw .NET a)Lr(DB2 .NET)4*" ADO.NET &CLr# v 9C IBM rZ}=$_4*"&CLr,}g,Excel"Perl Mng Lotus® Approach® 0d`LoT LotusScript® .`D*E=}]b,S(ODBC)nUC'$_# v 9C PHP E>oTM Ruby on Rails(RoR)4*" Web &CLr,Ruby on Rails(RoR)GCZ*"T}]bxPCJD Web &CLrDr\# v 9C Python 4*" Web &CLr,Python G(CD_6E>oT,G#JCZl Y*"&CLr# v Sf> 9.7 ^)| 1 *<,9C Oracle wCSZ (OCI) &CLr4CJ DB2 } ]b#IBM }]~qw DB2CI }/Lr 'VTm` OCI API DwC# * IBM }]~qw*" ADO.NET IBM Data Server Provider for .NET GT ADO.NET SZD)9,|Jm .NET &C Lr(}2+,S4CJ IBM }]~qw"4P|nT0lwa{/# 20 IBM Data Server Client 1,IBM Data Server Provider for .NET =xa)KN ) v IBM DB2 for IBM i V5R4 M V6R1,(} DB2 Connect(TZ IBM DB2 V9.7 FP3 0|Mf>) v IBM Informix V11.10"V11.50 M V11.70 `BwbV[K+2 DB2 .NET Provider# Informix }]b~qw .NET Provider (IBM.Data.Informix.dll) (} Informix }]b~qw .NET Provider,.NET &CLrICJTB}]b \m53: v IBM Informix V11.10 M V11.50 #PXKa)LrD|`E",kND:IBM Informix Dynamic Server E"P D# **"MKP9C }]~qw .NET a)LrD&CLr,zh* .NET Frame- work# } IBM }]~qw .NET a)Lr.b,IBM Database Add-Ins for Visual Studio 9 Jmz9C Microsoft Visual Studio lYaIX* IBM }]~qw*" .NET &CL r#9IT9CCSX~44(}]bTs(}g,w}Mm)T0*"~qwKT s(}g,f"}LMC'(eD/})# ODBC .NET Data Provider ODBC .NET Data Provider 9C CLI }/LrT DB2 }]4xP ODBC wC#r K,ODBC .NET Data Provider 'VD,SV{.X|Vk CLI }/Lr'VD,S V{.X|V`,#RG;YbTKa)Lr#(iC'9C IBM }]~qw .NET a )Lr# xR,ODBC .NET Data Provider D^Fk CLI }/LrD^F`,#ODBC .NET Data Provider 9Pd{^F,TBwbTb)^FwK{v:6*" ADO.NET M OLE DB &CLr7PD:ODBC .NET Data Provider ^F;# *9C ODBC .NET Data Provider,Xk20 .NET Framework V2.0"V3.0 r V3.5# TZ DB2 (C}]b AS/400® f V5R4 0|Mf>,~qwOh*TB^):APAR II13348# m 1 PP>K ODBC .NET Data Provider D\'VD,SX|V: m 6. ODBC .NET Data Provider DPC ConnectionString X|V X|V 5 ,e DSN }]bp{ }]b?}: [Visual Basic .NET] Dim con As New OdbcConnection("DSN=sample;UID=userid;PWD=password;") con.Open() [C#] OdbcConnection con = new OdbcConnection("DSN=sample;UID=userid;PWD=password;"); con.Open() OLE DB .NET Data Provider OLE DB .NET Data Provider 9C IBM DB2 OLE DB Driver,Z ConnectionString TsP,+s_w* IBMDADB2 xP}C# OLE DB .NET Data Provider 'VD,SV{.X|Vk IBM OLE DB Provider for DB2 'VDG)X|V`,#RG;YbTKa)Lr#(iC'9C IBM }]~q w .NET a)Lr# "R,OLE DB .NET Data Provider D^F2k IBM DB2 OLE DB Provider `,# OLE DB .NET Data Provider 9Pd{^F,TBwbTb)^FwK{v:6*" ADO.NET M OLE DB &CLr7PD:OLE DB .NET Data Provider ^F;# *9C OLE DB .NET Data Provider,Xk20 .NET Framework V2.0"V3.0 r V3.5# TZ DB2 (C}]b AS/400 f R520"R530 M R540,~qwOh*TB^): APAR ii13348# OLE DB .NET Data Provider DyP'VD,SX|VT>Zm 1 P: m 7. OLE DB .NET Data Provider DPC ConnectionString X|V X|V 5 ,e PROVIDER IBMDADB2 8( IBM OLE DB Provider for DB2(Xh) DSN r Data Source }]bp{ }]b?}G: Z 5 B \'VD API 19 [Visual Basic .NET] Dim con As New OleDbConnection("Provider=IBMDADB2;" + "Data Source=sample;UID=userid;PWD=password;") con.Open() [C#] OleDbConnection con = new OleDbConnection("Provider=IBMDADB2;" + "Data Source=sample;UID=userid;PWD=password;" ); con.Open() DB2 wC6SZM ODBC ri DB2 wC6SZ (CLI) G DB2 5P}]b~qwD IBM IwC SQL SZ#bGC ZxPX5}]bCJD“C”M“C++”&CLr`LSZ,KSZ9C/}wC+/, SQL odw*/}Td?xP+]# IT9C CLI SZCJBP IBM }]~qw}]b: v DB2 V9 for Linux, UNIX, and Windows v DB2 Universal Database for OS/390® and z/OS V8(M|_f>) v DB2 for IBM i 5.4 M|_f> v IBM Informix V11.50(S DB2 V9.7 FP1 M|_f>*<)M V11.70(S DB2 V9.7 FP3 M|_f>*<) CLI Ifz6k=/, SQL,+;,Z6k= SQL DG,|;h*wd?r$`k w#&CLrITfrwV}]bKP,x;XkTdPD?v}]bxP`k#Z KP1,&CLr(}}LwC4,S=}]b""v SQL odT0lw}]M4, E"# CLI SZa)Km`Z6k= SQL P4a)D&\#}g: v CLI a)K'VZ DB2 5Pwvz7.d#V;BDi/}]b?&CLrD>}# ":%DB2PATH% G8 DB2 20?<# 2,M/, SQL IT(}=V==PD;V44P SQL od:2,==r/,==# T2,==4PD SQL od TZT2,==4PD SQL odxT,o(Z$`k1Qj+7(#zXkj +X8( SQL odDa9,CodEa;O*G2,od#}g,odP}C DPMmD{FZ$`k1Xkj+7(#(;ITZKP18(DE"GC ody}CDNNwd?D5#+G,TXkTwd?E"(}g}]`M) xP$`k#kZKP&CLr.0$`k"s(M`kT2,==4PD SQL od#2, SQL nJOZ3FE";asy|DD}]b# T/,==4PD SQL od T/,==4PD SQL odI&CLrZKP19(M4P#JOZ/, SQL DivD;v;m>}G,a>nUC'dk SQL odX|?V(}g*Qw DmMPD{F)D;%=&CLr# \'VD JDBC M SQLJ }/Lr DB2 z7|(T=V`MD JDBC }/Lre5a9D'V# y] JDBC f6,JDBC }/Lre5a9V*D`: 1 ` K`}/Lr+ JDBC API w*8r*E=}]b,S(ODBC).`Dm;}] 22 }]b&CLr*"kE CJ API D3d45V#K`}/Lr(#@5Z>zb,Cb^FK|GDIF 2T#DB2 }]b534a) 1 `}/Lr# 2 ` bG8?V9C Java `LoT`4"?V9C>zzk`4D}/Lr#b)}/ Lr9CX(Z|Gy,SD}]4D>zM'zb#IZ9CK>zzk,yT |GDIF2T\^# 3 ` bG89C? Java M'z"9C@"Z}]~qwD-ik}]~qwxP(ED }/Lr#;s,}]~qw+M'zDks+o=}]4#DB2 }]b534a ) 3 `}/Lr# 4 ` bG8j+9C Java 4`4"R*X(}]45VKxg-iD}/Lr#M'z +1S,S=}]4# DB2 Database for Linux, UNIX, and Windows 'VTB}/Lr: }/Lr{ r|== }/Lr`M IBM }]~qw JDBC M SQLJ }/Lr v db2jcc.jar M sqlj.zip(CZ JDBC 3.0 'V) v db2jcc4.jar M sqlj4.zip(CZ 'V3) JDBC 4.0 r|_ f>&\) 2 `M 4 ` IBM }]~qw JDBC M SQLJ }/Lr(2 `M 4 `) IBM }]~qw JDBC M SQLJ }/LrG|, JDBC 2 `M JDBC 4 `P*D% ;}/Lr#1&CLr0k IBM }]~qw JDBC M SQLJ }/Lr1,+* 2 `M 4 `5V0k%;}/Lr5}#&CLrIT9Cbv%;}/Lr5}4xP 2 `M 4 `,S#IT,1xP 2 `M 4 `,S#IBM }]~qw JDBC M SQLJ }/Lr 2 `}/LrP*;F* IBM }]~qw JDBC M SQLJ 2 `,S}/L r#IBM }]~qw JDBC M SQLJ }/Lr 4 `}/LrP*;F* IBM }] ~qw JDBC M SQLJ 4 `,S}/Lr# IBM }]~qw JDBC M SQLJ }/Lr P=vf>#IBM }]~qw JDBC M SQLJ }/Lr V3.5x k JDBC 3.0 ;B#IBM }]~qw JDBC M SQLJ }/L r V4.x k JDBC 4.0 r|_f>f]# IBM }]~qw JDBC M SQLJ }/Lr 'VBP JDBC M SQLJ &\: v V3.5x 'V JDBC 3.0 f6PhvDyP=(# v V4.x 'V JDBC 4.0 r|_f>f6PhvDyP=(# v SQLJ j<(eD SQLJ &CLr`LSZ,CZr/S Java &CLrPxPD} ]CJ# v 'V,S2mD,S#,S2mI WebSphere® Application Server rm;v&CLr ~qw4P# v Z Java C'(eD/}Mf"}LP,k}]~qwD,Sv9C IBM }]~q w JDBC M SQLJ 2 `,S}/Lr#wCC'(eD/}rf"}LD&CLr I9C IBM }]~qw JDBC M SQLJ 2 `,S}/Lrr IBM }]~qw JDBC M SQLJ 4 `,S}/Lr4,S=}]~qw# Z 5 B \'VD API 23 IBM }]~qw JDBC M SQLJ }/Lr G Java }LD1!}/Lr# v 'VV<=Bq\m#K'V5VK Java 2 Platform, Enterprise Edition (J2EE) Java Bq~q(JTS)M Java Bq API (JTA) f6,b)f6k X/Open V<=Bqj <;B(kND http://www.opengroup.org a)D Distributed Transaction Process- ing: The XA Specification)# IBM OLE DB Provider for DB2 IBM OLE DB Provider for DB2 Jm DB2 d1 OLE DB a)LrDJ4\mw# K'V9yZ OLE DB D&CLr\;9C OLE SZ4i!ri/ DB2 }]# Microsoft OLE DB G;i OLE/COM SZ,|G9&CLr\;TwVE"4Pf" D}]xP;BDCJ#OLE DB e5a9(eK OLE DB 9C_M OLE DB a) Lr#OLE DB 9C_GNN9C OLE DB SZD53r&CLr;OLE DB a) LrGNNa) OLE DB SZDi~# IBM OLE DB Provider for DB2 Da)Lr{F* IBMDADB2,|9 OLE DB 9C _\;CJ DB2 }]b~qwOD}]#g{Q20 DB2 Connect,G4b) OLE DB 9C_9ITCJwz DBMS(}g DB2 z/OS f"DB2 ~qw VM M VSE f r DB2 (C}]b AS/400 f)OD}]# IBM OLE DB Provider for DB2 a)KBP&\: v 'VZ 0 6 OLE DB a)Lrf6,dP|(3)=SDZ 1 6SZ# v TID_L/a)Lr5V,K5V9&CLr\;Z;v_LP4(i~"ZN Nd{_LP9CG)i~# v msiR~q,K~qCZ5X DB2 ms{"# "b,IBM OLE DB Provider $tZM'zO,"Rk,y\ DB2 }]b53'V D OLE DB m&\Py;,# >D5DsxBZ+hv IBM OLE DB Provider for DB2 DX(5V#PX Microsoft OLE DB 2.0 f6D|`E",kND Microsoft Press a)D Microsoft OLE DB 2.0 Programmer’s Reference and Data Access SDK# f>;BT IBM OLE DB Provider for DB2 k Microsoft OLE DB f6D V2.7 r|_f>;B# 53*s kND IBM OLE DB Provider for DB2 }]~qwDyw/,TKb\'VD Win- dows Yw53# *20 IBM OLE DB Provider for DB2,XkHZOfP>DdP;n\'VYw5 3PKP#z9h*20;vj{D DB2 z7"IBM }]~qw ODBC M CLI } /Lr r IBM Data Server Driver Package# 24 }]b&CLr*"kE Perl DBI DB2 'V Perl }]bSZ(DBI)f6,SxJm(} DBD::DB2 }/LrxP}] CJ# DB2 Perl DBI Web >c;ZTB;C: http://www.ibm.com/software/data/db2/perl/ K>ca)KnBD DBD::DB2 }/LrM`XE"# Perl GbMMoT,Perl DBI #i9C/, SQL#b)tT9C Perl I*lY4(M ^) DB2 &CLrDmkoT#Perl DBI #i9CDSZk CLI M JDBC SZG# `F,b9z\;=cX+ Perl &CLrF2= CLI M JDBC r_+ CLI M JDBC &CLrF2= Perl# * IBM }]~qw*" PHP &CLr PHP:,D>$&mw(PHP)G;VbMM`LoT,c:CZ*" Web &CLr# PHP r%W'"`XZ5Jbv=8"'V Web &CLrPs`}(#XhD&\, rKQI*wPD Web *"oT# PHP G;V#i/oT,|9z\;(}9C)9TICD&\xP(F#b))9I Tr/ngBPNq:A4M&m XML,4( SOAP M'zM~qw,T0T~qw M/@w.dD(ExPS\#+G,PHP DnwP)9a)KT}]bDA4CJ& \,rK,zITaI=cX4(I}]b}/D/, Web >c# IBM a)KCZCJ IBM }]~qw}]bDP>D PHP )9: ibm_db2 bG;v}L=&CLr`LSZ (API),|}Ka)}#D4("A!"|B M4k}]bYwTb,9a)KT}]b*}]Dc:CJ#IT9C PHP 4 r PHP 5 4`k ibm_db2 )9#K)9I IBM `4",$M'V# pdo_ibm bG PHP }]Ts (PDO) )9D}/Lr,|(} PHP 5.1 P}kDj< frTs}]bSZ4a)T IBM }]~qw}]bDCJ# b))9|(Z IBM }]~qw}/m~|(DS }/Lr)V1.7.0 P"w*|D; ?Va)#'VKf>r|_f>,S= IBM DB2 V9.7 for Linux, UNIX, and Win- dows#IT(}"v php --re ibm_db2 |nli ibm_db2 )9Df># ;ZTB;CD PHP Extension Community Library (PECL) P2a)K ibm_db2 M pdo_ibm DnBf>:http://pecl.php.net/# PHP &CLrITCJP>D IBM }]~qw}]b: v IBM DB2 V9.1 for Linux, UNIX, and Windows FP2 M|_f> v IBM DB2 Universal Database (DB2 UDB) V8 for Linux, UNIX, and Windows FP15 M|_f> v 6L,SA IBM DB2 for IBM i V5R3 v 6L,SA IBM DB2 for IBM i V5.4 M|_f> v 6L,SA IBM DB2 z/OS f V8 M|_f> Z 5 B \'VD API 25 Z}v)9“3; ODBC”-HMa)KT DB2 }]b53DCJ(#+G,TZB& CLrxT,IT9C ibm_db2 M pdo_ibm,bGr*|GDT\MH(T`TZ Uni- fied ODBC oT,G#JCZlY*"&CLr#Python ?wzkIAT "'VwV`L6},dP|(}L=`L"frTs`L"fr=f`L"*`L M&\=`L#Python oTI Python Software Foundation \m# IT(}P>D)9S Python &CLrPCJ IBM }]~qw}]b: ibm_db K API I IBM (e,|a)KT_6&\DnQ'V#z}KIT"v SQL i/"wCf"}LM9C pureXML® Tb,9ITCJ*}]E"# ibm_db_dbi K API 5VK Python }]b API f6 V2.0#IZ ibm_db_dbi API kKf 6;B,rK4a) ibm_db API y'VD3)_6&\#g{&CLrD} /Lr'V Python }]b API f6 V2.0,G4IT=cXP;= ibm_db#ibm_db API M ibm_db_dbi API r|Z;p# ibm_db_sa KJdw'V SQLAlchemy,s_a)K;VinD=(4CJ IBM }]~q w#SQLAlchemy G;vwPD*E=4zk Python SQL $_W~MTs= X53dw (ORM)# ibm_db_django KJdwa)S Django T IBM }]~qwDCJ(^#Django G;vwP D Web r\,ICZ8YX9(_T\"ED IBM }]~qw: v IBM DB2 V9.1 for Linux, UNIX, and Windows FP2 M|_f> v IBM DB2 Universal Database (DB2 UDB) V8 for Linux, UNIX, and Windows FP15 M|_f> v 9C PTF SI27358(|( SI27250)6L,SA IBM DB2 for IBM i V5R3 v 9C PTF SI27256 6L,SA IBM DB2 for IBM i 5.4 M|_f> v k IBM DB2 z/OS f V8 M V9 D6L,S v IBM Informix Dynamic Server V11.10 M|_f> IBM_DB Ruby }/LrM Rails Jdw IZ}kKT Ruby on Rails r\D'V,rK Rails &CLrVZ\;CJ IBM } ]~qwOD}]# IBM_DB Ruby }/LrM Rails Jdw3F* IBM_DB gem,|GJm Ruby &C LrCJP>D}]b\m53: 26 }]b&CLr*"kE v DB2 for Linux, UNIX, and Windows V9 M|_f> v DB2 Universal Database (DB2 UDB) V8 for Linux, UNIX, and Windows v DB2 UDB for AS/400 and iSeries® V5 R1 (M|_f>),(} DB2 Connect v DB2 z/OS fV8 M V9((} DB2 Connect) v Informix Dynamic Server V11.10 M|_f> ":M'z&CLrZCJ Informix Dynamic Server V11.10 1Xk9C IBM Data Server Driver V9.5 r|_f>#H0f>;\'V#M'z&CLr9IT9C IBM }]~qwKP1M'zr IBM }]~qwM'z# IBM_DB Ruby }/LrICZ,S=Ov IBM }]~qwT0CJdPD}]# IBM_DB Ruby JdwJmNN\}]b'VD Rails &CLrk IBM }]~qwx P;%# PX IBM Ruby n?M RubyForge *E=4gxD|`E",kND http://rubyforge.org/ projects/rubyibm/ *q! DB2 }]bz7D20*sDPm,kND http://publib.boulder.ibm.com/ infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.qb.server.doc/doc/r0025127.html# *q! IBM Informix Dynamic Server D20*sDPm,kND http:// publib.boulder.ibm.com/infocenter/idshelp/v111/topic/com.ibm.expr.doc/ids_in_004x.html# PXBX IBM Data Server Driver Package(DS }/Lr)D|`E",kND http:// www.ibm.com/software/data/support/data-server-clients/index.html# Z 5 B \'VD API 27 28 }]b&CLr*"kE Z 6 B CZ}]b&CLr*"D`LoTM`kw DB2 }]bD&CLr*"\;5P`LoTM`kw'V# IT9CBPoT4*" DB2 }]b&CLr: v C++ v C#"VB .NET Md{ .NET oT v C v COBOL v Fortran v Java v Perl v PHP v Python v REXX v Ruby M Ruby on Rails CZ*"b?}LD API M`LoT(#kG)CZ}]b&CLr*"Df]#ZH vu~M'V.dfZ3)O!nl#*i4CZb?}L*"D\'V API M`Lo T,kND:CZb?}L*"D\'V API M`LoT# \'VD .NET *"m~ **"M?pfr IBM }]~qwKPD .NET &CLr,z+h*9C\'VD* "m~MYw53# 'V*"M?p .NET Framework 2.0"3.0"3.5 M 4.0 &CLrDY w53 v Windows XP Service Pack 2(32 ;M 64 ;f>) v Windows Server 2003(32 ;M 64 ;f>) v Windows Vista(32 ;M 64 ;f>) v Windows Server 2008(32 ;M 64 ;f>) v Windows Server 2008 R2(64 ;f>) v Windows 7(32 ;M 64 ;f>) 'V .NET Framework &CLrD*"m~ } IBM }]~qwM'zr}/m~|.b,z9h*BPdP;v\'V$_4* " .NET Framework &CLr# v Visual Studio 2008 v Visual Studio 2010 © Copyright IBM Corp. 2006, 2012 29 'V .NET Framework &CLrD?pm~ } IBM }]~qwM'zr}/m~|.b,z9h*BPdP;v\'Vm~|4 ?p .NET Framework &CLr#Zs`}ivB,Windows 20+=xa)dPD ;v!n# v .NET Framework V2.0 Redistributable Package v .NET Framework V3.0 Redistributable Package v .NET Framework V3.5 Redistributable Package v .NET Framework V4.0 Redistributable Package T9C C xP}]b&CLr*"D'V DB2 }]bD&CLr*"\;5P C oT`kw'V# BmP>K DB2 }]b&CLr*"y'VD C `kw# }GmP5w,qrBmPP>D`kw'V 32 ;M 64 ;&CLr*"# m 8. \'VD C `kw Yw53 \'VD`kw AIX v IBM XL C/C++ Enterprise Edition V9.0 for AIX v IBM XL C/C++ Enterprise Edition V10.1 for AIX v IBM XL C/C++ Enterprise Edition V11.0 for AIX yZ IPF (IA64) D HP-UX v TZ HP-UX 11i V3,9C HP aC++ Compiler Version A.06.12 yZ x86 D Linux v GNU/Linux gcc V3.3 M V3.4 v GNU/Linux gcc V4.1 v Intel C Compiler V10.1 yZ x64 D Linux v GNU/Linux gcc V3.3 M V3.4 v GNU/Linux gcc V4.1 v Intel C Compiler V10.1 yZ POWER(PowerPC®" Power Systems™ ~qwM pSeries®)D Linux v GNU/Linux gcc V3.3 M V3.4 v GNU/Linux gcc V4.1 v IBM XL C/C++ Advanced Edition V9.0 for Linux v IBM XL C/C++ Advanced Edition V10.1 for Linux v IBM XL C/C++ Advanced Edition V11.0 for Linux Linux on System z (s/390x) v GNU/Linux gcc V3.3 M V3.4 v GNU/Linux gcc V4.1 yZ UltraSPARC D Solaris v Sun Studio 10 v Sun Studio 11 v Sun Studio 12 v Forte C++ V6.2 v Sun ONE Studio 7(`kw/O) 30 }]b&CLr*"kE m 8. \'VD C `kw (x) Yw53 \'VD`kw yZ x64 D Solaris v Sun Studio 10 v Sun Studio 11 v Sun Studio 12 yZ x86 D Windows v Intel Proton Compiler for Windows V9.0.021 r|_f> 32 ;&CLr v Microsoft Visual C++ .NET r|_f> yZ x64(x64 M AMD64/ EM64T)D Windows v Microsoft Platform SDK for Windows Server 2003 SP1(9 (f> 1830 r|_f>),C/C++ for x64 `kw v Intel Proton Compiler for Windows x64 V9.0.024 r|_f > v Microsoft Visual C++ 2008, 2010 T9C C++ xP}]b&CLr*"D'V DB2 }]bD&CLr*"\;5P C++ oT`kwD'V# BmP>K DB2 }]b&CLr*"y'VD C++ `kw# }GmP5w,qrBmPP>D`kw'V 32 ;M 64 ;&CLr*"# m 9. \'VD C++ `kw Yw53 \'VD`kw AIX v IBM XL C/C++ Enterprise Edition V9.0 for AIX v IBM XL C/C++ Enterprise Edition V10.1 for AIX v IBM XL C/C++ Enterprise Edition V11.0 for AIX yZ IPF (IA64) D HP-UX v TZ HP-UX 11i V3,9C HP aC++ Compiler Version A.06.12 yZ x86 D Linux v yZ RHEL5 M SLES10 D GNU/Linux g++ V4.1.1 M V4.1.0 v Intel C++ `kw V9.1 M|_f> ": g{ RHEL5 OD g++ V4.1.1 `kwvVJb,kXB 9C RHEL 5 OTf]|N=a)D g++ V3.4 `kw# yZ x64 D Linux v yZ RHEL5 M SLES10 D GNU/Linux g++ V4.1.1 M V4.1.0 ": g{ RHEL5 OD g++ V4.1.1 `kwvVJb,kXB 9C RHEL 5 OTf]|N=a)D g++ V3.4 `kw# y Z POWER(PowerPC"Power Sys- tems ~qwM pSeries)D Linux v yZ RHEL5 M SLES10 D GNU/Linux g++ V4.1.1 M V4.1.0 v CZyZ pSeries D Linux D IBM XL C/C++ Enterprise Edi- tion V9.0 ":g{ RHEL 5 OD g++ V4.1.1 `kwvVJb,kXB 9C RHEL 5 OTf]|N=a)D g++ V3.4 `kw# Z 6 B `LoTM`kw 31 m 9. \'VD C++ `kw (x) Yw53 \'VD`kw Linux on zSeries® (s/390x) v yZ SLES9 D GNU/Linux g++ V3.4 M V3.3 v yZ RHEL5 M SLES10 D GNU/Linux g++ V4.1.1 M V4.1.0 ": g{ RHEL5 OD g++ V4.1.1 `kwvVJb,kXB 9C RHEL 5 OTf]|N=a)D g++ V3.4 `kw# yZ UltraSPARC D Solaris v Sun Studio 10 v Sun Studio 11 v Sun Studio 12 v Forte C++ V6.2 v Sun ONE Studio 7(`kw/O) yZ x64 D Solaris v Sun Studio 10 v Sun Studio 11 v Sun Studio 12 yZ x86 D Windows v Intel Proton Compiler for Windows V9.0.021 r|_f> 32 ;&CLr v Microsoft Visual C++ .NET yZ x64 D Windows v Microsoft Windows Server 2003 SP1 SDK(9(f> 1830 r|_f>)"C/C++ for x64 `kw v Intel Proton Compiler for Windows x64 V9.0.024 r|_f > v Microsoft Visual C++ 2008, 2010 T9C COBOL xP}]b&CLr*"D'V KNK DB2 }]b&CLr*"y'VD COBOL `kw# }GmP5w,qrBmPP>D`kw'V 32 ;M 64 ;&CLr*"# m 10. \'VD COBOL `kw Yw53 \'VD`kw AIX v IBM COBOL for AIX V3.1 v IBM COBOL for AIX V4.1 v Micro Focus Server Express® V5.1 v Micro Focus Server Express V6.0 yZ IPF (IA64) D HP-UX v Micro Focus Server Express V5.1 v Micro Focus Server Express V6.0 yZ x86 D Linux v Micro Focus Server Express V5.1 v Micro Focus Server Express V6.0 32 }]b&CLr*"kE m 10. \'VD COBOL `kw (x) Yw53 \'VD`kw yZ x64 D Linux v Micro Focus Server Express V5.1 v Micro Focus Server Express V6.0 Linux on zSeries (s/390x) v Micro Focus Server Express V5.1 v Micro Focus Server Express V6.0 yZ UltraSPARC D Solaris v Micro Focus Server Express V5.1 v Micro Focus Server Express V6.0 yZ x86 D Windows v Micro Focus Server Express V5.1 v Micro Focus Server Express V6.0 v IBM Rational® Developer for zSeries V7.6.0 yZ x64 D Windows v Micro Focus Server Express V5.1 v Micro Focus Server Express V6.0 T9C Fortran xP}]b&CLr*"D'V DB2 }]bD&CLr*"\;5P FORTRAN oT`kw'V# BmP>K DB2 }]b&CLr*"y'VD Fortran `kw# }GmP5w,qrBmPP>D`kw'V 32 ;M 64 ;&CLr*"# m 11. \'VD Fortran `kw Yw53 \'VD`kw AIX v IBM XL Fortran for AIX V12.1 yZ IPF (IA64) D HP-UX v HP-UX F90 B.11.23 yZ UltraSPARC D Solaris v SPARCompiler Fortran V4.2 M V5.0(vTZ 32 ;) DB2 }]bz7D Java m~'V h*_8J16pD IBM Java m~*"|(SDK),T9CyZ Java D$_T04 (MKP Java &CLr(|(f"}LMC'(eD/})# g{}Z20D3vi~h* IBM Java SDK,xC76PP420 Java SDK,G4 Z9C“DB2 20”rK DB2 }]bz7DQ20 Java SDK 6p: Yw53=( Java SDK 6p AIX SDK 7 yZ Itanium D HP-UX 53 SDK 6 Z 6 B `LoTM`kw 33 Yw53=( Java SDK 6p yZ x86 D Linux SDK 7 yZ AMD64/EM64T D Linux SDK 7 yZ zSeries D Linux SDK 7 yZ POWER D Linux SDK7 Solaris Yw53 SDK 7 Windows x86 SDK 7 Windows x64 SDK 7 ": 1. ISTB developerWorks® Web 3fBX Java SDK m~:http://www.ibm.com/ developerworks/java/jdk/index.html#PX Java SDK D\'V6pDPm,kND> ZPTsa)Djb*“DB2 Database for Linux, UNIX, and WindowsT Java SDK D'V”Dm# ":TZ Windows Yw53=(,9C IBM Development Package for Eclipse x PBX# 2. DB2 GUI $_vZ Linux on x86"Linux on AMD64/EM64T"Windows x86 M Windows x64 OKP# 3. Z Windows x86 MyZ x86 D Linux O: v Q20 32 ; SDK v 'V 32 ;&CLrM Java b?}L 4. ZyP\'VD=(O(Windows x86 M Linux on x86 }b): v 'V 32 ;&CLr v ;'V 32 ; Java b?}L v 'V 64 ;&CLrM Java b?}L \'VD Java &CLr*"m~ BmP>K Java SDK D\'V6p#'VyP>6pM`,6pDIr0f]D|_ f># IZ Java SDK ^)M|B+*51,yT4bTyP6pMf>#g{}]b&CL r_Pk Java SDK `XDJb,k"T Java SDK x(6pDB;vICf># Java SDK f>(x;G IBM SDK)v'V9(MKP@"D Java &CLr#TZ9 (MKPB Java f"}LMC'(eD/},v'Vf DB2 Database for Linux, UNIX, and Windowsz7a)D IBM SDK for Java#*KPH0 DB2 "Pf9(D Java f "}LMC'(eD/},kNDm 1 D“Java f"}LMC'(eD/}”PTKb j8E"# 34 }]b&CLr*"kE m 12. DB2 Database for Linux, UNIX, and Windows'VD Java SDK 6p 9C JDBC }/Lr db2java.zip r db2jcc.jar D Java & CLr 9C JDBC }/Lr db2jcc4.jar D Java &CLr Java f"}LMC' (eD/} DB2 Graphical Tool AIX 1.4.2 A 7 7 1.4.26 A 7 5 ;JC y Z Itanium D HP-UX 53 1.4.2 A 61 61 1.4.26 A6 ;JC yZ POWER D Linux 1.4.2 A 73,4 73,4 1.4.26 A 7 ;JC yZ x86 D Linux 1.4.2 A 72,3,4 72,3,4 1.4.26 A 75A 7 Linux on AMD64 M Intel EM64T &mw 1.4.2 A 72,3,4 72,3,4 1.4.26 A 7 ;JC yZ zSeries D Linux 1.4.2 A 73,4 73,4 1.4.26 A 7 ;JC Solaris Yw53 1.4.2 A 72 72 1.4.26 A 7 ;JC yZ x86 D Windows 1.4.2 A 72 72 1.4.26 A 75A 7 Windows on x64(JC Z AMD64 M Intel EM64T &mw) 1.4.2 A 72 72 1.4.26 A 75A 7 ": 1. 'V`,6pD Hewlett-Packard a)D Java SDK 9(MKP9C IBM }]~q w JDBC M SQLJ }/LrD@"M'z&CLr# 2. 'V Oracle a)D`,6pD Java SDK 9(MKP9C IBM }]~qw JDBC M SQLJ }/LrD@"&CLr#;x,g{z*9CS\D2+T`MhC IBM }]~qw JDBC M SQLJ }/LrtT securityMechanism,G4 Java SDK Xk'Vz9CDS\`M#}g,z9CD Java SDK I\'V 256 ; AES (?)S\,+;'V 56 ; DES(u)S\#IT(}hC IBM }]~qw JDBC M SQLJ }/LrtT encryptionAlgorithm 48(S\c(#*9C 256 ; AES S\,k+ encryptionAlgorithm hC* 2#T Oracle a)D Java SDK 9C 256 ; AES S\1,I\h*20 JCE Unlimited Strength Jurisdiction _TD~, ITS Oracle qCCD~# 3. SUSE Linux s5~qw (SLES) 10 *s Java SDK DnM6p* 1.4.2 SR6#Red Hat Enterprise Linux(RHEL)5 *s Java SDK DnM6p* 1.4.2 SR7# 4. Z Linux O'V Java SDK 6 h* Java SDK 6 SR3 r|_f># 5. g{9C Java SDK 6 SR2 r|_f>,khC DB2LIBPATH=java_home/jre/lib/ ppc64# 6. V9.7 P;Fv9CT IBM SDK for Java 1.4.2 9(D Java f"}LMC'(e D/}D'V,"RI\aZ+4"PfP}%#IBM SDK for Java 1.4.2 D~q axUZ* 2011 j 9 B#(iZKUZ.0}% SDK for Java 1.4.2 @5X5# (}9C DB2 V9.1"DB2 V9.5"DB2 Version 9.7 r DB2 V10.1 P|,D Java SDK 4X( Java f"}LMC'(eD/},IT}%K@5X5# Z 6 B `LoTM`kw 35 T9C Perl xP}]b&CLr*"D'V DB2 }]bD&CLr*"\;5P PERL oTf>'V# BmP>K DB2 }]b&CLr*"y'VD Perl `LoTf># }GmP5w,qrBmPP>Df>'V 32 ;M 64 ;&CLr*"# m 13. \'VD Perl `LoTf> Yw53 \'VDf> AIX v Perl 5.8 r|_f> v DBI 1.41 r|_f> yZ IPF (IA64) D HP-UX v Perl 5.8 r|_f> v DBI 1.41 r|_f> yZ x86 D Linux v Perl 5.8 r|_f> v DBI 1.41 r|_f> yZ x64 D Linux v Perl 5.8 r|_f> v DBI 1.41 r|_f> y Z POWER(PowerPC"Power Sys- tems ~qwM pSeries)D Linux v Perl 5.8 r|_f> v DBI 1.41 r|_f> Linux on zSeries (s/390x) v Perl 5.8 r|_f> v DBI 1.41 r|_f> yZ UltraSPARC D Solaris v Perl 5.8 r|_f> v DBI 1.41 r|_f> yZ x64 D Solaris v Perl 5.8 r|_f> v DBI 1.41 r|_f> yZ x86 D Windows v Perl 5.8 r|_f> v DBI 1.41 r|_f> yZ x64 D Windows v Perl 5.8 r|_f> v DBI 1.41 r|_f> T9C PHP xP}]b&CLr*"D'V DB2 }]bD&CLr*"\;5P PHP oTf>'V# BmP>K DB2 }]b&CLr*"y'VD PHP E>oTf># d;,ZBmPP>Ky>'V,+9G(i9CnBf> PHP 5# }GmP5w,qrBmPP>Df>'V 32 ;M 64 ;&CLr*"# 36 }]b&CLr*"kE m 14. \'VD PHP E>oTf> Yw53 \'VDf> AIX v PHP 4.3.4 r|_f>(TZ IBM_DB2 }/Lr) v PHP 5.1 r|_f>(TZ PDO_IBM }/Lr) yZ IPF (IA64) D HP-UX v PHP 4.3.4 r|_f>(TZ IBM_DB2 }/Lr) v PHP 5.1 r|_f>(TZ PDO_IBM }/Lr) yZ x86 D Linux(vTZ 32 ; DB2 5}MoT) v PHP 4.3.4 r|_f>(TZ IBM_DB2 }/Lr) v PHP 5.1 r|_f>(TZ PDO_IBM }/Lr) yZ AMD64/EM64T D Linux v PHP 4.3.4 r|_f>(TZ IBM_DB2 }/Lr) v PHP 5.1 r|_f>(TZ PDO_IBM }/Lr) y Z POWER(PowerPC"System i M pSeries)D Linux v PHP 4.3.4 r|_f>(TZ IBM_DB2 }/Lr) v PHP 5.1 r|_f>(TZ PDO_IBM }/Lr) Linux on zSeries (s/390x) v PHP 4.3.4 r|_f>(TZ IBM_DB2 }/Lr) v PHP 5.1 r|_f>(TZ PDO_IBM }/Lr) yZ UltraSPARC D Solaris v PHP 4.3.4 r|_f>(TZ IBM_DB2 }/Lr) v PHP 5.1 r|_f>(TZ PDO_IBM }/Lr) yZ x64 D Solaris v PHP 4.3.4 r|_f>(TZ IBM_DB2 }/Lr) v PHP 5.1 r|_f>(TZ PDO_IBM }/Lr) yZ x86 D Windows(vTZ 32 ; DB2 5}) v PHP 4.3.4 r|_f>(TZ IBM_DB2 }/Lr) v PHP 5.1 r|_f>(TZ PDO_IBM }/Lr) yZ x64(AMD64/EM64T)D Windows v PHP 4.3.4 r|_f>(TZ IBM_DB2 }/Lr) v PHP 5.1 r|_f>(TZ PDO_IBM }/Lr) T9C Ruby/Ruby on Rails xP}]b&CLr*"D'V DB2 }]bD&CLr*"\;5P Ruby M Ruby on Rails oTf>'V# BmP>K DB2 }]b&CLr*"y'VD Ruby/Ruby on Rails f># }GmP5w,qrBmPP>Df>'V 32 ;M 64 ;&CLr*"# m 15. \'VD Ruby/Ruby on Rails f> Yw53 \'VDf> AIX v Ruby 1.8.5 M|_f> v Ruby on Rails 1.2.1 M|_f># yZ IPF (IA64) D HP-UX v Ruby 1.8.5 M|_f> v Ruby on Rails 1.2.1 M|_f># yZ x86 D Linux(vTZ 32 ; DB2 5}MoT) v Ruby 1.8.5 M|_f> v Ruby on Rails 1.2.1 M|_f># Z 6 B `LoTM`kw 37 m 15. \'VD Ruby/Ruby on Rails f> (x) Yw53 \'VDf> yZ AMD64/EM64T (x64) D Linux v Ruby 1.8.5 M|_f> v Ruby on Rails 1.2.1 M|_f># y Z POWER(PowerPC"System i M pSeries)D Linux v Ruby 1.8.5 M|_f> v Ruby on Rails 1.2.1 M|_f># Linux on zSeries (s/390x) v Ruby 1.8.5 M|_f> v Ruby on Rails 1.2.1 M|_f># yZ UltraSPARC D Solaris v Ruby 1.8.5 M|_f> v Ruby on Rails 1.2.1 M|_f># yZ x64 D Solaris v Ruby 1.8.5 M|_f> v Ruby on Rails 1.2.1 M|_f># yZ x86 D Windows(vTZ 32 ;&CLr*") v Ruby 1.8.5 M|_f> v Ruby on Rails 1.2.1 M|_f># yZ x64(AMD64/EM64T)D Windows(vTZ 32 ;&CL r*") v Ruby 1.8.5 M|_f> v Ruby on Rails 1.2.1 M|_f># T9C REXX xP}]b&CLr*"D'V DB2 }]bD&CLr*"\;5P REXX `LoTf>'V# BmP>K DB2 }]b&CLr*"y'VD REXX `LoTf># v'V REXX D 32 ;f># m 16. \'VD REXX `LoTf> Yw53 \'VDf> AIX1 v REXXSAA 4.00 Linux on x86(vTZ 32 ; DB2 5}M`kw)1 v Object REXX Interpreter for Linux V2.1 Linux on zSeries (s/390x)1 v Object REXX 2.2.0 for Linux/390 v 1v'V 32 ;f>D REXX# 38 }]b&CLr*"kE Z 7 B \'VDBq\mw DB2 }]bITd1NN XA f]DBq\mwDJ4\mw# TBG XA f]D;)#{Bq\mw,IC4-wf0 DB2 }]bDV<=Bq: v IBM TXSeries CICS® v IBMWebSphere MQ v BEA Tuxedo v BEA WebLogic v Microsoft V<=Bq-ww(DTC) © Copyright IBM Corp. 2006, 2012 39 40 }]b&CLr*"kE Z 8 B \'VD}]b&CLr*"$_ b)/I*"73M*"$_PzZ DB2 }]b&CLr*"# IBM /I}]b&CLr*"73 v IBM Data Studio(bQ IBM i~) v Rational Application Developer(%@a)D IBM z7) v Rational Software Architect(%@a)D IBM z7) v InfoSphere® Data Architect(%@a)D IBM z7) /I*"73D}]b&CLre~ v IBM Database Add-Ins for Visual Studio CZ*" SQL"SQL/XML M XQuery odD$_ v |nP&mw (CLP) v IBM Data Studio CZ}]b&CLr`SMT\w{D$_ v lUMB~`Sw v CZ CLI"ODBC M JDBC &CLrD2,E*Vv v IBM Data Studio(SQL PL E*Vv) CZ*" Web &CLrD$_ v IBM Data Studio - inD Web Service }]CJ(;h*xPNN`L) v Rational Application Developer - CZ Web &CLrD[O Java *"73 v Zend Studio - CZ Web &CLrD PHP *"M?p73 v Ruby on Rails - 9C Ruby on Rails r\MBD Rails Jdw4lY*" Web &CLrTS IBM }]~qwCJ}] v Microsoft Visual Studio with IBM Database Add-Ins - CZyZ .NET D Web &CLrD*"73 IBM Database Enterprise Developer Edition IBM Database Enterprise Developer Edition z79&CLr*"_\;hFM9(&C LrT0+&CLrCw-M,TcZNN IBM E"\mM'zr~qw=(OxP ?p#(}9CKz7=xDm~,IT*"MbTZ;vYw53OKPD&CL r"RZ,;rm;Yw53OCJ}]b#}g,IT4(Z Windows Yw53O KPD&CLr,+Z UNIX Yw53g AIX OCJ}]b# © Copyright IBM Corp. 2006, 2012 41 42 }]b&CLr*"kE Z 9 B dC}]b&CLr*"73 *dC}]b&CLr*"73,XkdCYw53"}]~qwM'z"*"73 MBq\mw# *<.0 *kT DB2 }]b&CLr*"xPdC,h*zcTB*s(gPX*): v \'VDYw53 kNDZ 5 3DZ 3 B, :}]b&CLr*"y'VDYw53;# v Q20 IBM }]~qwM'z kND620 IBM Data Server Client7PD:20 IBM }]~qwD=(;# v 20 API }/Lr,X*120}/Lr\mw kNDZ 17 3DZ 5 B, :\'VD}]b&CLr`LSZ;# v Q20z+9CD`LoTyhD`kwrbMw kNDZ 29 3DZ 6 B, :CZ}]b&CLr*"D`LoTM`kw;# v Q20Bq\mw kNDZ 39 3DZ 7 B, :\'VDBq\mw;# v Q20*"$_ kNDZ 41 3DZ 8 B, :\'VD}]b&CLr*"$_;# XZKNq DB2 }]b&CLr*"73ItIm~*XiI,gBy>: v Yw53 v }]~qwM'z v }]b&CLr`LSZ (API) v `LoT v Bq\mw v *"$_ ?vbyD*X4jIhCNq# XZKNq ?v}]b\mw5}:db2profile M db2cshrc#1Z JDBC &CLrP9C 4 `,S1,;h*hC73# }L 1. KP}7E>ThC+C4*"&CLrD5}D73# v TZ bash r Korn shell: . $HOME/sqllib/db2profile v TZ C shell: source $HOME/sqllib/db2cshrc 2. g{9C ODBC"DB2 CLI"JDBC r SQLJ *"&CLr,G44PBPNq: v 6Call Level Interface Guide and Reference Volume 17PD:hC ODBC 73;# 44 }]b&CLr*"kE v Z 48 3D:20 IBM }]~qw JDBC M SQLJ }/Lr;# UNIX 73d?hC }7k}]b73;%yXhD UNIX Yw53D73d?# SyZ UNIX =(D;,,aZ db2profile(TZ bash r korn shell)r db2cshrc (TZ C shell)PhCTB73d?D5,"Ra+Tb)D~DwCECZ5}yP _D .bashrc (bash shell) P,"RaECZ .profile(bash r korn shell)D~r .login (C shell) D~P# AIX: v PATH,|(tI DB2 ?<,dP|( sqllib/bin v LIBPATH,|(?< sqllib/lib(kNDTB"M) HP-UX: v PATH,|(tI DB2 ?<,dP|( sqllib/bin v SHLIB_PATH(32 ;M 64 ;)r LD_LIBRARY_PATH(64 ;),|(? < sqllib/lib(kNDTB"M) Linux M Solaris: v PATH,|(tI DB2 ?<,dP|( sqllib/bin v LD_LIBRARY_PATH,|(?< sqllib/lib(kNDTB"M) Z5}4(Zda4(UWD~ sqllib/userprofile M sqllib/usercshrc,TcC' ImS{GT:D5}73hC#g{;h* db2profile r db2cshrc E>PDB7 3hC,G4IT9C`&D“C'”E>4T|GxP2G,aZ db2profile r db2cshrc E>D)2wCCE>#Z5}}6(db2iupgrade)Zd,aTC'E>x P2G35,TcT;9C73^D# hC&CLr*"73(Windows) *Z Windows Yw53OhC&CLr*"73,zXkq-b)=h# XZKNq Z Windows Yw53O20 IBM Data Server Client 1,20Lr+9C73d? INCLUDE"LIB M PATH 4|BdC"am#536'73d? DB2INSTANCE I20h C*y4(1!5}({* DB2)#DB2PATH GZr*D“DB2 |n”0ZPhCD# I2Gb)73d?,ThC53r10QG: set LIB="%DB2PATH%;%LIB%" Kd?D1!205G \Program Files\IBM\SQLLIB(||,Uq),rK,kC} E+j{76}p4# Z 9 B hC&CLr*"73 45 2. Kb,Xk4PBPCZKP DB2 &CLrDX(=h: v 9( C r C++ Lr1,Xk7#73d? INCLUDE + %DB2PATH%\INCLUDE | ,*Z;v?<# *K,k|B`kwD73: a. t/ Visual Studio |na>{Dl]==# b. Z Visual Studio |n0ZP,KP DB2CMD.exe Tr* DB2 |n0Z# c. Z DB2 |n0ZP,hC INCLUDE 76,gBy>: set INCLUDE=%DB2PATH%\INCLUDE;%INCLUDE% v 9( Micro Focus COBOL Lr1,k+73d? COBCPY hC*8r %DB2PATH %\INCLUDE\cobol_mf# v 9( IBM COBOL Lr1,k+73d? SYSLIB hC*8r %DB2PATH%\ INCLUDE\cobol_a# v (}9CTB|n47#73d? LIB 8r %DB2PATH%\lib: set LIB="%DB2PATH%\lib";%LIB% *S 32 ;73P;f*" 64 ;&CLr,kND6}6= DB2 V10.17PD :T*Z 64 ;5}OKPD 32 ;}]b&CLrxP}6;# v *T6L~qwKP&CLr,Xk}7dCM'zM~qw#}g,XkZ6 L}]bD~qwOhC73d? DB2COMM# dC IBM Data Server Client TxP}]b&CLr*" }]~qwM'z'V}]b&CLr*";dCM'zG*&CLr*"xPDd C$wD;?V# *<.0 *dC }]~qwM'zTxP}]b&CLr*",XkzcTB*s: v Q20 }]~qwM'z kND620 IBM Data Server Client7PD:20 IBM }]~qwM'z(Linux M UNIX);M:20 IBM }]~qwM'z (Windows);# v I!:Q4(CZbT&CLrDy>}]b kND6SQL Reference Volume 17PD:SAMPLE }]b;# v QjI}]~qwM'zDy>dC=h# kND620 IBM Data Server Client7PD:M'zk~qw(EdCEv;# XZKNq PX*xP}]b&CLr*"dC}]~qwM'zDE",kNDZ 47 3D:d C&CLr`LSZD*"73;# 46 }]b&CLr*"kE dC&CLr`LSZD*"73 Z**" DB2 }]b&CLrxxPdC1,dP;?VdC$wG*z+*Z&C LrP9CD&CLr`LSZ (API) dC*"73# *<.0 **z+*9CD&CLr`LSZ (API) dC&CLr*"73,XkjIBPN q: v 20 IBM }]~qwM'z v 20 API }/Lr kNDZ 17 3DZ 5 B, :\'VD}]b&CLr`LSZ;# v v^Z ODBC API:20 ODBC }/Lr\mw kND6Call Level Interface Guide and Reference Volume 17PD:hC Win- dows CLI 73;# }L *dC API D*"73,k4PTB=h: 1. TZ ADO .NET,kND6*" ADO.NET M OLE DB &CLr7PD:* IBM }]~qwxP ADO.NET *";Tq!j8E"# 2. TZ CLI M ODBC,k4PJCZzD73DBPNNNq: v 6Call Level Interface Guide and Reference Volume 17PD:hCzD&CLr *"73TKP CLI M ODBC &CLr; v 6Call Level Interface Guide and Reference Volume 17PD:hC UNIX ODBC }/Lr\mw; 3. TZ6k= SQL,k4PBPNq:6*"6k= SQL &CLr7PD:hC6 k= SQL *"73;# 4. TZ JDBC M SQLJ,k4PTBNq:6Developing Java Applications7PD:2 0 IBM }]~qw JDBC M SQLJ }/Lr;# 5. TZ OLE DB,kND}]b&CLr*"kEPD:IBM OLE DB Provider for DB2;Tq!j8E"# 6. TZ Perl,kNDDeveloping Perl, PHP, Python, and Ruby on Rails ApplicationsP D:Perl DBI;Tq!j8E"# 7. TZ PHP,4PBPdP;nNq: v Z Linux r UNIX OhC PHP 73# v Z Windows OhC PHP 73# 8. TZ Ruby/Ruby on Rails,4P}]b&CLr*"kEPD:IBM_DB Ruby } /LrM Rails Jdw;PP>DNNJCZ73DNq# 9. TZ Python,4PDeveloping Perl, PHP, Python, and Ruby on Rails Applications PD:* IBM }]~qwhC Python 73;Nq# Z 9 B hC&CLr*"73 47 dC*"73T9("KP CLI M ODBC &CLr I9C IBM Data Server Client"IBM Data Server Runtime Client r IBM Data Server Driver for ODBC and CLI kT DB2 }]b~qwKP CLI M ODBC &CLr# +G,*`k CLI r ODBC &CLr,zh* IBM }]~qwM'z# }L *9 CLI &CLr\;I&CJ DB2 }]b: 1. k7#Z20 DB2 M'zZdQ20 CLI/ODBC }/Lr# 2. v^Z IBM }]~qwM'zMKP1M'z:g{}ZS6LM'zCJ}] b,kTC}]bT0C}]byZzwDwz{xP`?# Z Windows Yw53O,IT9C“CLI/ODBC hC”GUI T DB2 }]bxP` ?# 3. I!: 9CTB|nT=X+ CLI/ODBC s(D~s(A}]b: db2 bind ~/sqllib/bnd/@db2cli.lst blocking all sqlerror continue \ messages cli.msg grant public Z Windows Yw53O,IT9C“CLI/ODBC hC”GUI + CLI/ODBC s(D~ s(A}]b# 4. I!: (}`- db2cli.ini D~|D CLI/ODBC dCX|V#PX db2cli.ini D~D;CDE",kNDCall Level Interface Guide and Reference Volume 1PD :db2cli.ini u# TZ} IBM }]~qwKP1M'z M IBM Data Server Driver Package TbD yP DB2 z7,DB2 Database for Linux, UNIX, and Windows 20}L+T/2 0 SDK for Java V5# g{*9C JDBC 4.0 &\,G4Xk20 SDK for Java 6 r|_f># g{*9C JDBC 4.1 &\,G4Xk20 SDK for Java 7 r|_f># 48 }]b&CLr*"kE g{zF.Z53OKP JDBC r SQLJ &CLr+;`kb)&CLr,G4; h* Java KP173# *c:(iz;*T Java }L9CT SDK for Java 1.4.2 D'V,"RI\Z+4 D"PfP}%K'V# v JVM >z_L'V NNKPG)h*CJ DB2 }]bD Java &CLrD JVM z_L 'V#(}+ THREADS_FLAG 73d?hC*“native”,IT8(>z_Lw*3) JVM D1!_L'V#PX9>z_LI*53OD1!_LD8>E",kND Java 73DD5# v System i ~qwD Unicode 'V g{NN SQLJ r JDBC Lr+9C IBM }]~qw JDBC M SQLJ 4 `,S }/Lr,S= DB2 i f~qw,G4 System i Yw53Xk'V Unicode UTF-8 `k=8#BmP>'V Unicode UTF-8 yhD System i PTF: m 17. CZ'V Unicode UTF-8 D System i PTF System i f> PTF E V5R3 r|_f> ^('VIz7=xa)) v HP-UX M'zM~qwD Java 'V HP-UX ~qw:IBM }]~qw JDBC M SQLJ }/Lr ;'V9C HP-UX 1 !V{/ Roman8 D}]b#rK,Z HP-UX ~qwO4(zF.(} IBM }] ~qw JDBC M SQLJ }/Lr 4CJD}]b1,Xk4(9Cm;V{/D} ]b# HP-UX M'zM~qw:HP-UX 53OD Java 73*sxPXbDhCE\Z IBM }]~qw JDBC M SQLJ }/Lr BKPf"}L# ^F g{+ IBM }]~qw JDBC M SQLJ }/Lr 20Z Windows 64 ;Yw53 O,G4^(9C IBM }]~qw JDBC M SQLJ 2 `,S}/Lr4S 32 ; Java &CLr,S= DB2 Database for Linux, UNIX, and Windows 5}# }L *20 IBM }]~qw JDBC M SQLJ }/Lr,k4PTBYw: 1. Z DB2 Database for Linux, UNIX, and Windows D20}LP,k!q Java ' V(TZ UNIX r Linux)r JDBC 'V(TZ Windows)# b): db2jcc.jar r db2jcc4.jar g{zF.9C;|, JDBC 3.0 r|Mf>&\D IBM }]~qw JDBC M SQLJ }/Lr f>,kZ CLASSPATH P|( db2jcc.jar# g{zF.9C|, JDBC 4.0 r|_f>&\0 JDBC 3.0 r|Mf >&\D IBM }]~qw JDBC M SQLJ }/Lr f>,kZ CLASSPATH P|( db2jcc4.jar# sqlj.zip r sqlj4.zip g{zF.<8;|, JDBC 3.0 r|Mf>&\D SQLJ &CLr, kZ CLASSPATH P|( sqlj.zip# g{zF.<8|, JDBC 4.0 r|_f>&\0 JDBC 3.0 r|Mf >&\D SQLJ &CLr,kZ CLASSPATH P|( sqlj4.zip# v ^D CLASSPATH T9d|( IBM }]~qw JDBC M SQLJ }/Lr `D~# *c:;aT db2jcc.jar M sqlj.zip D~T/4PK=h#g{z}Z9C db2jcc4.jar D~r sqlj4.zip D~,G4XkV/^D CLASSPATH#Z CLASSPATH P+ db2jcc.jar |D* db2jcc4.jar r+ sqlj.zip |D* sqlj4.zip# 9XkZ?vr*D DB2 |nP0ZPxPK|D# *c:Z CLASSPATH P|( db2jcc.jar r db2jcc4.jar#k;*,1|(b= vD~# *c:Z CLASSPATH P|( sqlj.zip r sqlj4.zip#k;*,1|(b=vD ~#k;*,1|( db2jcc.jar M sqlj4.zip r_,1|( db2jcc4.jar M sqlj.zip# v g{ IBM }]~qw JDBC M SQLJ }/Lr M'zmI$D~fZ,G4 20xLa20b)D~"^D CLASSPATH T|(b)D~# b)D~+;Ek sqllib\java ?<(TZ Windows 53)r sqllib/java ? <(TZ UNIX r Linux 53)#D~{gBy>: m 18. IBM }]~qw JDBC M SQLJ }/LrmI$D~ mI$D~ mI$D~yJm,S=D~qw |,mI$D~Dz7 db2jcc_license_cisuz.jar DB2 z/OS f DB2 i f yP DB2 Connect z7 S IBM }]~qw JDBC M SQLJ }/Lr V3.50 r|_f>,S= DB2 Database for Linux, UNIX, and Windows"Cloudscape r IBM Informix }]b ";h*M'zmI$D~#1S,S= DB2 z/OS f";h*M'zmI$D ~(g{Q4P DB2 Connect Unlimited Edition for System z ~qwmI$$ n)# (i:g{1S,S= DB2 z/OS f}]~qw,x;G(} DB2 Connect x XxP,S,"R9C DB2 Connect Unlimited Edition for System z 9.7 FP3 r |_f>,G4Xk$n DB2 Connect Unlimited Edition for System z D~qw 50 }]b&CLr*"kE mI$\?#Xk$nz+,SD?v DB2 z/OS fS53r}]2miODm I$\?#kND DB2 Connect E",Tq!PX~qwmI$$nDj8E "# v 20 IBM }]~qw JDBC M SQLJ }/Lr >zb,Tc'V IBM }] ~qw JDBC M SQLJ 2 `,S}/Lr# b)D~+;Ek sqllib\bin ?<(TZ Windows 53)r sqllib/bin ?< (TZ UNIX r Linux 53)# D~{gBy>: libdb2jcct2.so CZ AIX"yZ IPF D HP-UX"Linux T0 Solaris db2jcct2.dll CZ Windows 2. g{NN1!5;JC,k(F}/Lr6'DdCtT# 3. dC TCP/IP# ZBPivB,Xk* TCP/IP (EdC~qw: v JDBC r SQLJ &CLr9CK IBM }]~qw JDBC M SQLJ 4 `,S} /Lr# v JDBC r SQLJ &CLr9CK IBM }]~qw JDBC M SQLJ 2 `,S} /Lr,"Z,S URL P8(K server M port number# 7# TCP/IP l}w&ZKP4,#*$n TCP/IP l}w,k4PBPYw: a. +73d? DB2COMM hC* TCPIP: db2set DB2COMM=TCPIP b. 9C~qD~P8(D TCP/IP ~q{F4|B}]b\mwdCD~: db2 update dbm cfg using svcename TCP/IP-service-name CZ applet M SQLJ LrDKZEXkk}]b\mwdCD~P9CD TCP/IP svcename E`,# c. 4P db2stop M db2start |n,T9~q{FhCz'# 4. ZzF.KP Java f"}LrC'(eD/}D DB2 Database for Linux, UNIX, and Windows ~qwO,k|B}]b\mwdCT9d|( SDK for Java D7 6# *jIKNq,kZ~qw|nPOdk`FZTBD|n: v TZ UNIX r Linux OD}]b53: db2 update dbm cfg using JDK_PATH /home/db2inst/jdk15 /home/db2inst/jdk15 G SDK for Java D2076# v TZ Windows OD}]b53: db2 update dbm cfg using JDK_PATH c:\Program Files\jdk15 c:\Program Files\jdk15 G SDK for Java D2076# Z 9 B hC&CLr*"73 51 *i$ DB2 }]b\mwdCP jdk_path VND5Gq}7,kZ}]b~qw OdkTB|n: db2 get dbm cfg zI\h*+dvX(rAD~T=ci4#jdk_path VN+T>Zdv*7=|# 5. g{zF.S Java LrPwC DB2 Database for Linux, UNIX, and Windows ~ qwOD SQL }L,"Rk}]b~qwDXrzk`X*DUZM1dq=;G USA q=,k4PBPYw: a. Z}]b~qwOhC DB2_SQLROUTINE_PREPOPTS "amd?,T8>1!UZ 1dq=G ISO: db2set DB2_SQLROUTINE_PREPOPTS="DATETIME ISO" b. XB(ezF.S Java LrPwCDNNVP SQL }L# *7#wC&CLr}7XSUUZM1d5,Xk4Pb)=h# 6. g{F.9C Java &CLr4CJ DB2 z/OS f}]b~qw,kq-“CZS Java LrCJ DB2 for z/OS ~qwDXbhC”(Z Developing Java Applications P) PD8>E"# Bq\mw Bq\mwGm~i~,CZTX(}]bBq8(j6"`SBq&mT0i$B qGjI9G'\r_ZBqjIr'\14PYw# Bq\mCZ$@2~Mm~ms,b)msI\ab)i~.dDX5# 52 }]b&CLr*"kE &CLr (AP) &CLr (AP) (eBq_gT0G)iIBqDX(Z&CLrDYw# }g,CICS &CLrI\*CJng}]bM CICS 21}]SP.`DJ4\mw (RM) T09C`L_-4&m}]#?vCJksk RM PU>.dDX*jG#=WNd5rXvh* XID,TZ5 3t/14PY,=Yw(2F*Y,=)rZX*1C\m14Pt"=Yw(2 F*V/I$)# Z TP `Swt/.s,|a*s TM r*;i&CLr~qwQ(eDyP RM#TM a+ xa_open wC+]Ab) RM,Tc\;uk RM U>.dDe;1,RM E+*@G *d59GXvdBqV'#*K4PY,=Yw,TM TdP?v RM "v xa_recover wC;Nr`N,T6pyP;7(Bq#TM a+&pk|T:U>PD E"xPHO,T7(Gq&C(* RM Tb)Bq4P xa_commit r xa_rollback# g{ RM (}d\m1Dt"=YwQd5rXvd;7(BqV',G4 TM aT C RM "v xa_forget wCTjIY,=Yw# 1C'&CLrksd5rXv1,|Xk9C TP `Swr TM a)D API,Tc TM \;Zf0DyP RM .dTd5MXvxP-w#}g,1 WebSphere &CL r"vd5BqDks1,WebSphere XA TM +4}4"v XA wC(}g xa_end" xa_prepare"xa_commit r xa_rollback)Tks RM d5rXvCBq#g{vf0 ;v RM r RM D&p8vdV'*;A,G4 TM I!q9C;WNd5x;G =WNd5# 54 }]b&CLr*"kE J4\mw (RM) J4\mw (RM) a)Tng}]b.`D2mJ4DCJ# w*}]bDJ4\mwD DB2 53INkI XA f]D TM xP-wD+VBq# 4 XA SZD*s,}]b\mwa)`M* xa_switch_t D db2xa_switch b? C d ?4+ XA P;a95XA TM#K}]a9|,*I TM wCDwv XA }LDX 7T0 RM DYwXw# RM I9CTB=V=(4"adZ?v+VBqPDNk:2,"aM/,"a: v 2,"a*s TM T*~qw&CLr(eDyP RM "v(kT?vBq) xa_start"xa_end M xa_prepare 5PwC,;\BqGq9Cx( RM#g{" G?v RM D xa_open V{.q= TBG xa_open V{.Dq=: parm_id1 = parm_value,parm_id2 = parm_value, ... T243r8(b)N}^Xt*#B;ZhvK parm_id DP'5# ":}GT=yw,qrb)N};xVs!4"R;P1!5# AXLIB |, TP `SwD ax_reg M ax_unreg /}Db#K5I DB2 Database for Linux, UNIX, and Windows C4q!yh ax_reg M ax_unreg /}DX7#|IC4y ] TPM N}2GY(5,2II TPM PmO;PvVD TP `Sw9C#Z AIX O,g{b*i5b,G4}K8(b{.b,9&C8(i5I1#}g: AXLIB=/usr/mqm/lib/libmqmax_r.a(libmqmax_r.o)#KN}*I!# CHAIN_END xa_end 4Sj>#P'5* T"F r^NN5#XA_END 4SGII DB2 Data- base for Linux, UNIX, and Windows C4uYxgwDE/==#g{ TP `S w73gK,Tc\;7#ZwC xa_end .s+"4Z,;_LrxLZwC xa_prepare,"Rg{ CHAIN_END r*,G4 xa_end j>+k xa_prepare | Z 9 B hC&CLr*"73 55 n4Z;p,Sx{};vxgw#5 T b6E CHAIN_END r*;5 F b6 E CHAIN_END XU;;PNN8(5rb6E CHAIN_END r*#KN}IC 42GS8(D TPM 5IzDhC#g{48(KN},G4a9C1!5 F# CREG xa_start 4Sj>#P'5* T"F r^NN5#xa_start 4SGI DB2 Data- base for Linux, UNIX, and Windows C4uYxgwDE/==#v1 TP `S w9C2,"a1,CN}EP'(kND SREG)#TP `Sw73gK,Tc\ ;7#ZwC XA API xa_start .s+"4wC SQL od#g{ CREG hC * T,G4 SQL oda4A xa_start ks,Sx{};vxgw#KN}IC 42GS8(D TPM 5IzDhC#g{48(KN},G4a9C1!5 F# CT ,S,1#P'5* 0 = 32767#CT 8(1"Tk~qw(",S1&CLr+ H}D1d(TkF)#g{Z8(D1dZ;P(",S,G4+5Xms#8 (5 0 b6E&CLr+"TH},1=,S("*9,;\yC1d`$#+ G,1! TCP/IP ,1hCI\+U9,S"T#g{48(KN},G4a9C 1!5 0# DB }]bp{#&CLrC4CJ}]bD}]bp{#Xk8(KN}# HOLD_CURSOR 8(Z{vBqd5ZdGqRpNj#P'5* T"F r^NN5#TP `Sw( #aT`v&CLr4C_LrxL#*K7#B0k&CLr;aLPH0D& CLryr*DNj,aZd5.sXUNj#g{ HOLD_CURSORS r*,G4 ;aXUxx(tTDNj,|G+#VZBqd5_g#19CK!n1,Xk S,;XF_Ld5rXv+VBq#g{ HOLD_CURSOR XU,G4+\xr *NNxx(tTDNj#5 T b6E HOLD_CURSOR r*;5 F b6E HOLD_CURSOR XU;KN}ICZ2GS8(D TPM 5IzDhC#g{48 (KN},G4a9C1!5 F# PWD \k#kC'j6`X*D\k#Z8(KC'j6DivBGXhD#KN}x Vs!4# SINGLE_PROCESS 8(Gq**CJ DB2 z/OS fDM'ztC1S XA 'V#P'5* T"F r ^NN5#TZyZ5}DM'z(IBM }]~qwM'z),Xk(}KhCr db2dsdriver dCD~PD enableDirectXA hC4T=tC XA 'V#TZ_P OY5}DM'z(IBM }]~qw}/Lr),1!ivB,a* Microsoft V <=Bq-wwr Microsoft Component Services(COM+)tC XA 'V#TZ yPd{\'VBq\mw,Xk(} SINGLE_PROCESS X|VT=tCT_P OY5}DM'zD XA 'V# SREG 2,"a#P'5* T"F r^NN5#DB2 Database for Linux, UNIX, and Win- dows 'V=V"a+VBqD=(#Z;V=(G/,"a,dP DB2 Data- base for Linux, UNIX, and Windows wC TP D ax_reg /}4"aBq(kN D AXLIB)#Z~V=(G2,"a,dP TP wC XA API xa_start 4t/ +VBq#"b,/,"ak2,"a%b#g{48(KN},G4a9C1! 5 F# SUSPEND_CURSOR 8(1BqXF_L]R1Gq#VNj#P'5* T"F r^NN5#]RBq 56 }]b&CLr*"kE V ' D TP ` S w I T + ] R D _ L r x L 4 CZd { B q # g { SUSPEND_CURSOR XU,G4aXU}xx(tTNj.bDyPNj#ZV4 ]RDBq.s,&CLrXkYNq!Nj#g{ SUSPEND_CURSOR r*, G4;aXUNNr*DNj,"RZV4]RDBq.s,|GICZCBq# 5 T b6E SUSPEND_CURSOR r*;5 F b6E SUSPEND_CURSOR XU; KN}ICZ2GS8(D TPM 5IzDhC#g{48(KN},G4a9C 1!5 F# TCTX 8(BqGq&C9CIE,S#P'5* TRUE r FALSE#g{KN}hC* TRUE,G4|(*Bq\mw"Tr*IE,S# TOC 5e(“XF_L”),yP DB2 XA ,S: m 19. TPM M tp_mon_name DP'5 TPM 5 TP `Swz7 Z?hC CICS IBM TXSeries CICS AXLIB=libEncServer(TZ Windows) =/usr/lpp/cics/lib/libEncServer (TZyZ UNIX D53) HOLD_CURSOR=T CHAIN_END=T SUSPEND_CURSOR=F TOC=T Z 9 B hC&CLr*"73 57 m 19. TPM M tp_mon_name DP'5 (x) TPM 5 TP `Swz7 Z?hC MQ IBM MQSeries® AXLIB=mqmax (TZ Windows) =/usr/mqm/lib/libmqmax_r.a (TZ AIX _L&CLr) =/usr/mqm/lib/libmqmax.a (TZ AIX G_L&CLr) =/opt/mqm/lib/libmqmax.so (TZ Solaris) =/opt/mqm/lib/libmqmax_r.sl (TZ HP _L&CLr) =/opt/mqm/lib/libmqmax.sl (TZ HP G_L&CLr) =/opt/mqm/lib/libmqmax_r.so (TZ Linux _L&CLr) =/opt/mqm/lib/libmqmax.so (TZ Linux G_L&CLr) HOLD_CURSOR=F CHAIN_END=F SUSPEND_CURSOR=F TOC=P CB IBM Component Bro- ker AXLIB=somtrx1i(TZ Windows) =libsomtrx1 (TZyZ UNIX D53) HOLD_CURSOR=F CHAIN_END=T SUSPEND_CURSOR=F TOC=T SF IBM San Francisco AXLIB=ibmsfDB2 HOLD_CURSOR=F CHAIN_END=T SUSPEND_CURSOR=F TOC=T TUXEDO BEA Tuxedo AXLIB=libtux HOLD_CURSOR=F CHAIN_END=F SUSPEND_CURSOR=F TOC=T MTS Microsoft Transaction Server ;X* MTS dC DB2 Database for Linux, UNIX, and Windows#DB2 Database for Linux, UNIX, and Windows PD ODBC }/Lra T/lb MTS# JTA Java Bq API ;X*ng IBM WebSphere .`D Enter- prise Java Server (EJS) dC DB2 Database for Linux, UNIX, and Windows#DB2 Database for Linux, UNIX, and Windows PD JDBC }/ LraT/lb=K73#rK,avTK TPM 5# OMf>D xa_open V{.q= OMf>D DB2 Database for Linux, UNIX, and Windows 9CKK&yvD xa_open V{.q=#} 1. }Z Windows O9C IBM TXSeries CICS#TXSeries D58vh*(} libEncServer:C D54dC tp_mon_name#bT;GIS\Dq=;+G,TZ DB2 Database for Linux, UNIX, and Windows r DB2 Connect V8 FP3 M|_f>, I!q4PTBYw: v 8( tp_mon_name D5* CICS((iCZKiv): db2 update dbm cfg using tp_mon_name CICS TZ“xr *> J4 *> z7 *> XAD *> J4\mw”u J4 *> z7 *> XAD *> J4\mw”u,I!q4PTBYw: v 8( tp_mon_name D5* MQ((iCZKiv): db2 update dbm cfg using tp_mon_name MQ TZ“xr *> J4 *> z7 *> XAD *> J4\mw”u J4 *> z7 *> XAD *> J4\mw”u J4 *> z7 *> XAD *> J4\mw”uGUd4Jmz“|G”Qt"= d5rXvDBq# (}9CK`|n(r`X API)4V/bv;7(Bq1,k+dww,;=r;C Q;*9C#nQ_TGH}Bq\mw}/Y,=xL#g{ZdP;vNk}] bPV/d5rXvBqxTm;vNk}]b4PK`4Yw,G4I\v=}] j{TJb#S}]j{TJbxPV4*szKb&CLr_-,T6pQ|Dr 60 }]b&CLr*"kE XvD}],;s4P}]bD1dcV4r_V/7zrXB&Cb)|D#g{ ^(H}Bq\mwt/Y,=xL"RXkME;7(Bqs(DJ4,G4Xk 9Ct"=Yw#g{Bq\mw+$Z;ICZ4PY,="R;7(Bqs(1 hDJ4,G4I"zKiv#ZBq\mwrJ4\mw;IC.0,;7(Bq as(kKBq`X*DJ4#TZ}]b\mw,b)J4|(kTmMw}Dx ("U>UdMBq9CDf"w#mb,?vV;v;7(Bq,II}]b&m Dns"PBq}Mau 1#xR,}GQbvKyP;7(Bq,qr;\xPQz 8]# ZBPivB,h*t"T|G&\: v 1Qt"=d5rXvDBqQzu~1,QZ LIST INDOUBT TRANSAC- TIONS |nDdvP8> v 1*xPQz8]1 t"= forget /}aME;7(BqUd#bb6E,g{Bq\mwnU 4PK;7(BqDY,=Yw,G4|I\wvmsv_4d5rXvd{J4\ mw,r*ZKJ4\mwP;fZCBqDNNU>G<#(#,U>G<“*'” b6ECJ4\mwQXvCBq# }L *V/bv;7(Bq,k4PTBYw: 1. ,SA}]b,TZC}]b,*syPBqE"47(d{Nk J4\mw# 4. 7(*T?v;7(Bq4PDYw: v g{Bq\mwIC,RJ4\mwPD;7(BqGIZCJ4\mwZZ~ vd5WNrZOgDY,=xLP;ICxT7(QTd{J4\mw4P24Yw# b. T}]b4P,;Yw;4,9C LIST INDOUBT TRANSACTIONS WITH PROMPT- ING |n4t"=d5rt"=XvBq# v g{Bq\mw; IC,k9Cd{NkJ4\mwPBqD4,47(4P2 4Yw: – g{AY;vd{J4\mwQd5Bq,kZyPb)J4\mwPt" =d5Bq# – g{AY;vd{J4\mwQXvBq,kt"=XvBq# Z 9 B hC&CLr*"73 61 – g{BqZyPNkJ4\mwP<&Z“Q<8”(;7()4,,kt"= XvBq# – g{d{J4\mwPD;vr`v;IC,kt"=XvBq# B;=v24 *S DB2 Database for Linux, UNIX, and Windows q!;7(BqE",k,S=C }]b""v LIST INDOUBT TRANSACTIONS WITH PROMPTING |n,rSM'z&CL rwC db2XaListIndTrans API# ;7(Bq\m API P1\;i/,d5MXv;7(Bqx;XH}Bq\mw (TM) 4PY,=YwG \PCD#}g,g{(E_7PO,"R;7(Bqs(yhJ4,G4I\av VKiv# 1J4yP_(}g}]b\m1)^(H} TM 4PY,=Yw1,a*$_`4_ a);i API 4T;7(Bq4Pt"=/}#TZ}]b\mw,b)J4|(kT mMw}Dx("U>UdMBq9CDf"w#mb,?vV;v;7(Bq,I I}]b\mw&mDns"PBq}Mau 1# t"= API \;i/,d5MXv;7(BqT0(}}%U>G34! {Qt"=d5rXvDBq# /f: 9Ct"= API 1&Cww,;=r;CQ;*9C#TM &C}/Y,=B ~#g{ TM a)KCZt/Y,=YwDYw1|n,G4&C9CC|n#g{C '^(H} TM t/DY,=,G4Xk9Ct"=Yw# d;;PNNH(D=(44Pb)Yw,+GBP;7(Bq#|G_P4,“P”(Q<8),+4 ,S#xid D gtrid ?VGNk+VBqDd{J4\mw (RM) PD+VBqj6# v 9CPX&CLrMYw73D*647(d{NkD RM# v g{Bq\mw* CICS,"R(; RM * CICS J4,G44Pt"=Xv# v g{Bq\mw;G CICS,G49C|47(k;7(Bq_P`, gtrid DBq D4,# v g{AYP;v RM Q-d5rXv,G44Pt"=d5rXv# v g{yPBq<&ZQ<84,,G44Pt"=Xv# v g{AYP;v RM ;IC,G44Pt"=Xv# g{Bq\mwIC"R;7(BqGIZC RM ZZ~WNrZOgDY,=P;I Cx47(Td{ RM Q4P24Yw,;s4 P,yDYw#gtrid G TM k RM .dD%d|# }GQt"=d5rXvDBqUIQz4v,qr;*4P sqlxhfrg#forget /}MEK;7(BqUd#g{Bq\mwnU4PK;7(BqDY ,=Yw,G4 TM Iwvmsv_4d5rXvd{ RM,r*ZK RM PR;= NNG<#(#,G<*'b6EC RM QXv# 62 }]b&CLr*"kE XA Bq\mwD2+T"bBn TP `Swa$HVd;i~qwxL,;s(}b)~qwxLDj6S;,C'KP Bq#TZ}]b,?v~qwxL(}g,CICS U>)47(DvC'N1QKPb)BqrLr# DB2 Database for Linux, UNIX, and Windows 'VD XA /} DB2 Database for Linux, UNIX, and Windows 'V X/Open CAE f6 - V<=Bq &m:XA f6P(eD XA91 f6,+PgB}b: v l=~q C XA f6JmSZ9Cl=~q,TcITsliksa{#}]b\mw*sk sT,===wC# v "a XA SZJm9CTB=V=(4"a RM:2,"aM/,"a#DB2 'V/," aM2,"a#DB2 a)=vP;4XFy9C"aD`M# – db2xa_switch_std,CZ/,"a – db2xa_switch_static_std,CZ2,"a v X*(F DB2 z7;'VZXF_L.dxPBq(F# Z 9 B hC&CLr*"73 63 XA P;9CM;C 4 XA SZD*s,}]b\mwa)`M* xa_switch_t D db2xa_switch_std M db2xa_switch_static_std b? C d?4+ XA P;a95XA TM#}Kwv XA / }DX7.b,a5XBPVN: VN 5 {F }]b\mwDz7{F#}g,IBM DB2 V9.7 for AIX# j> TZ db2xa_switch_std,ahC TMREGISTER | TMNOMIGRATE T=yw DB2 z79C/,"a,"R TM ;&C9CX*(F#~=yw ;'Vl=Yw# TZ db2xa_switch_static_std,ahC TMNOMIGRATE T=yw DB2 z79C2,"a,"R TM ;&C9CX*(F#~=yw ;'Vl=Yw# f> Xk* 0# 9C DB2 Database for Linux, UNIX, and Windows XA P; XA e5a9*sJ4\mw (RM) a)CZ9 XA Bq\mw (TM) \;CJC RM D xa_ }LDP;#RM P;9CF* xa_switch_t Da9#CP;|, RM D{F" 8r RM D XA kZcDG NULL 8k"j>T0f>E# Linux M UNIX I(}TB=V=(PDNN;V4q! DB2 Database for Linux, UNIX, and Win- dows DP;: v (}vS;vdScN#Z C LrP,bI(}(ej4jI: #define db2xa_switch_std (*db2xa_switch_std) #define db2xa_switch_static_std (*db2xa_switch_std) Z9C db2xa_switch_std r db2xa_switch_static_std .0# v (}wC db2xacic_std r db2xacicst_std DB2 a)b) API,|Ga5X db2xa_switch_std r db2xa_switch_static_std a9 DX7#K/}GTB=(D-M: struct xa_switch_t * SQL_API_FN db2xacic_std( ) struct xa_switch_t * SQL_API_FN db2xacicst_std( ) Z9CdPN;=(1,} C zk TBzkTICZ(} C LrCJ db2xa_switch_std r db2xa_switch_static_std D; ,=(xPK5w#kqX+&CLrk`&b4S# #include #include struct xa_switch_t * SQL_API_FN db2xacic_std( ); #ifdef DECLSPEC_DEFN extern __declspec(dllimport) struct xa_switch_t db2xa_switch_std; #else #define db2xa_switch_std (*db2xa_switch_std) extern struct xa_switch_t db2xa_switch_std; #endif main( ) { struct xa_switch_t *foo; printf ( "switch_std.name ); foo = db2xacic_std(); printf ( "name ); return ; } XA SZJb7( Z4T TM D XA ksZdlb=ms1,&CLrI\^(S TM q!mszk# g{Lrl#U9r_S TP `Swr TM q!S\5Xk,G4&Ci4WNJO ~qU>,ZoO6p 3 r|_6pz'1,|a(f XA msE"# 9&CiDXF({""TM msD~T0PXy9Cb?Bq&mm~Dd{X(Z z7DE"# }]b\mwa+yPX(Z XA Dms4kWNJO~qU>,xP SQLCODE -998 (Bqrt"=ms)M`&-rk#TBGdP;)O*#{Dms: v xa_open V{.Po(^'# v IZBPdP;v-r,4\,Sp,SQXB7I"R}ZK PDX(BqQ-Xv#K1,&CLrI!qXBKPCBqrLxKPBBo# 19C ACR 1vVJODw}]bk“4Oq”8C}]b.dD}];BT,\sL H!vZ,SQXB7IAD}]bP}]bU>D4,#*KxPKV[,RG+ K}]bF*“8C}]b”,xK8C}]byZD~qwrF*“8C~qw”#g{ 8C}]bGvVJODw}]bZ"zJO1D+71>,G48C}]bPD} ]+;B"R+;fZNN}]j{TJb#+G,g{8C}]b;GvVJOD w}]bD+71>,G4TZ XA Bq\mwQ<8+P4d5DBq,I\fZr Bqa{;;BxzzD}]j{TJb#b)F*;7(Bq#9C ACR &\D} ]b\m1M&CLr*"_Xkb6=9CK&\1}]j{TJbDgU# TB8ZhvKwv DB2 Database for Linux, UNIX, and Windows 73T0w73P }]j{TJbDgU# _ICTVQV4 (HADR) DB2 _ICTVQV4&\ (HADR) IC4XFZw}]b"zJO.s&CLrX BqC,S1w}]bk8C}]b.dDU>X46p#XFU>X46pD}] bdCN}F* hadr_syncmode#KN}PDvI\D5: v SYNC K==ITa)nsD#$T!I\X\bBq*',z[GZDV==PBql &1dn$#gC==D{Fy>,SYNC C49w}]bk8C}]bPBqU>D 4k,=#1w}]bQ4k|T:DU>D~,"RSU=4T8C}]bD& p,7OZ8C}]bO2Q4kb)U>1,,=4jI# g{9C XA Bq\mw4-wf0 DB2 J4DBq,G4?R(i9C SYNC = =#1M'zXB7IA8C}]b1,SYNC ==+7#}]j{TT0BqY,= j{T,r*8C}]bGw}]bD+71># v NEARSYNC k SYNC ==HO,K==Z\bBq*'=fTu,+Bql&1d|L#v1U >Q4kw}]bT:DU>D~,"Rw}]bSU=4T8C}]bD&p, 7Ob)U>2Q4k8C}]bOwf"w1,w}]bEO*U>4kI&# g{8C}]bZd+U>Sf"w4F=EL.0@#,G4LZZ8C}]b Oa*'b)U># *'DI\TT08C}]b;Gw}]bD+71>b;i v,}]j{TI\+\=F5#g{x(BqG;7(Bq,;sw}]b@ #,G4avVbVF5#Y(Bqa{*“d5”#1 XA TM "vsx XA_COMMIT ks1,IZw}]bQ@#,Cks+'\#r* XA_COMMIT k sQ'\,yT XA TM +h*(}"v XA_RECOVER ks4ZK}]bOV4 KBq#8C}]b+(}5XdyP;7(BqDPm4xPl&#g{Z“Zf P”}]bU>;4kELT0 XA_RECOVER ksI XA TM "v.08C}] b+*@#"XBt/,G48C}]b+Q*'PXCBqDU>E","^( 5XKE"4l& XA_RECOVER ks#by,XA TM +O*}]bQd5KB q#+G,5Jiv*}]&mQ*',CBqQXv#IZ XA TM“Qd5”KB qPf0DyPd{J4,yTbaQ4kw}]bT:DU>D~," Rb)U>Q+]Aw}]bDwzO TCP c1,w}]bEO*U>4kI&# w}]b;aH}4T8C}]bDNN`MD7O#1w}]bO*`XBqQ d51,I\T;Z+b)U>+]A8C}]b# g{"z NEARSYNC PyvDiv,G4k NEARSYNC HO,BqE"*'DI\T |s#rK,k NEARSYNC M SYNC HO,"z}]j{TJbDI\T|s# v SUPERASYNC K==_PnLDBql&1d,+w53"zJO1,Bq*'DI\T2n _#1z;#{rxgPOr5{xQ4kw}]bT:DU>D~1,w}]bEO*U>4kI &#w}]b;aH}4T8C}]bDNN`MD7O#1w}]bO*`XB qQd51,I\T;Z+b)U>+]A8C}]b# g{"z NEARSYNC PyvDiv,G4k NEARSYNC HO,BqE"*'DI\T |s#rK,k NEARSYNC M SYNC HO,"z}]j{TJbDI\T|s# Vx}]b73 ZVx}]b73P9CT/M'zXB7I (ACR) 2I#rK,8C}]b(}]bVx B) +Tw}]b(}]bVx A)PfZD;7(Bq;^y*# GVx}]b73 ZGVx}]b73P9C ACR 2I#rK,Z“_ICTVQV4 NEARSYNC”?VPyv DivBV4;7(BqI},G4C+Vd?+;hC*>}0_PD5# zITTa0+Vd?(e1!5#Za0PZ;N}CCd?1,+T/XTCd ?8(K5# XA ;% a0+Vd?DwCr^(* XA BqPD?va06p,rK;I)d{SkBqD a09C# +Vd?GGBqT4,Ts#rK,Z XA 73(TZt\nOBqMI"nOB q)P,+Vd?TsDfZivM5Z XA_end 1;a|D(TZ XA_start M XA_rollback .`Dd{ XA API xT,iv"GgK)# ":`4,DB2 for Linux, UNIX and Windows +Qyw+VY1mw*BqT4,T s5V#rK,4PBP XA API 1,+>}Qyw+VY1m# v XA_rollback v XA_end(SUCCESS) v XA_start(NOFLAGS) v XA_start(JOIN) dC IBM WebSphere Application Server: XZKNq IBM WebSphere Application Server GyZ Java D&CLr~qw#|IT(} DB2 JDBC }/Lra)D Java Bq API (JTA) 49C DB2 Database for Linux, UNIX, and Windows XA 'V#kND IBM WebSphere D5,KbPXgN+ Java Bq API k WebSphere Application Server dO9C#IZ_i4 WebSphere Application Server D5,x7* http://www.ibm.com/software/webservers/appserv/was/library/# dC IBM WebSphere MQ: Z 9 B hC&CLr*"73 69 XZKNq IBM WebSphere MQ Gfr{"D5q/I~qw#|I9C DB2 Database for Linux, UNIX, and Windows XA 'V4Z WebSphere MQ $w%*Z/I}]b|B#kN D IBM WebSphere MQ D5,KbPXgN9C WebSphere MQ PDBq'V#I Z_i4 WebSphere MQ D5,x7* http://publib.boulder.ibm.com/infocenter/wmqv7/ v7r0/index.jsp# dC IBM TXSeries CICS: XZKNq PXgNdC IBM TXSeries CICS T9C DB2 Database for Linux, UNIX, and Win- dows w*J4\mwDE",kND IBM TXSeries CICS Administration Guide#zI TZ_i4 TXSeries D5,x7* http://www-01.ibm.com/software/htp/cics/txseries/ library/#wzM System i }]b~qwINk CICS -wDBq# dC BEA Tuxedo: TBhvKdC*k DB2 Database for Linux, UNIX, and Windows dO9CD BEA Tuxedo D}L#y] Tuxedo G9C DB2 Database for Linux, UNIX, and Windows D 64 ;5}9G9Cd 32 ;5},fZ;)*"bDnp# XZKNq ":XA P;}]a9DB{FgB:db2xa_switch_std M db2xa_switch_static_std#m b,API DB{FgB:db2xacic M db2xacicst#+G,v19C DB2 Database for Linux, UNIX, and Windows D 32 ;5}1,E\9CH0DP;}]a9M API { F# }L *dC Tuxedo T+ DB2 Database for Linux, UNIX, and Windows CwJ4\mw, k4PTBYw: 1. 4Cz7DD5P8(D==20 Tuxedo#7#4PyPy> Tuxedo dC,dP |(U>D~M73d?# 9h*`kwM}]~qwM'z#X*1,k20b )Lr# 2. Z Tuxedo ~qwj6&,hC73d? DB2INSTANCE T}CdP|,z#{ Tux- edo 9CD}]bD5}#hCd? PATH T|( DB2 }]bLr?<#7O Tux- edo ~qwj6GqIT,SA DB2 }]b# 3. 9C5 TUXEDO 4|B tp_mon_name }]b\mwdCN}# 4. + DB2 }]bz7D(emSA Tuxedo J4\mw(eD~# ZBfD>}P, UDB_XA GkT DB2 V9.1 >X(eD Tuxedo J4\mw{F,x db2xa_switch_std G DB2 }]bT`M* xa_switch_t Da9(eD{F: v TZ AIX,ZD~ ${TUXDIR}/udataobj/RM P,mSTB(e: # DB2 UDB UDB_XA:db2xa_switch_std:-L${DB2DIR} /lib -ldb2 dP {TUXDIR} G Tuxedo D20?<,x {DB2DIR} G DB2 5}?<# v TZ Windows,ZD~ %TUXDIR%\udataobj\rm P,mSTB(e: 70 }]b&CLr*"kE # DB2 UDB UDB_XA;db2xa_switch_std;%DB2DIR%\lib\db2api.lib dP %TUXDIR% G Tuxedo D20?<,x %DB2DIR% G DB2 5}?<# 5. 9( DB2 D Tuxedo Bq`Sw~qwLr: v TZ AIX: ${TUXDIR}/bin/buildtms -r UDB_XA -o ${TUXDIR}/bin/TMS_UDB dP {TUXDIR} G Tuxedo D20?<# v TZ Windows: XA -o UDB 6. 9(&CLr~qw#ZBfD>}P,!n -r 8(J4\mw{F,!n -f(Q 9C;Nr`N)8(|,&CLr~qDD~,!n -s 8(K~qwD&CLr ~q{F,x!n -o r8(dv~qwD~{: v TZ AIX: ${TUXDIR}/bin/buildserver -r UDB_XA -f svcfile.o -s SVC1,SVC2 -o UDBserver dP {TUXDIR} G Tuxedo D20?<# v TZ Windows: XA -f svcfile.o -s SVC1,SVC2 -o UDBserver dP %TUXDIR% G Tuxedo D20?<# 7. hC Tuxedo dCD~T}C DB2 ~qw#Z UDBCONFIG D~D *GROUPS ?V P,mS`FZTBZ]Du?: UDB_GRP LMID=simp GRPNO=3 TMSNAME=TMS_UDB TMSCOUNT=2 OPENINFO="UDB_XA:db=sample,uid=db2_user,pwd=db2_user_pwd" dPN} TMSNAME 8(H09(DBq`Sw~qwLr,xN} OPENINFO r8(J4\mw{F#Ku?sz}]b{FT0CZO$D DB2 }]bC'j 6M\k#Z Tuxedo dCD~D *SERVERS ?VP}CKH09(D&CLr~ qw# 8. g{&CLrCJ DB2 z/OS fM OS/390 f"DB2 IBM i fr DB2 VM fM VSE fOD}],G4+h* DB2 Connect XA /Pw# 9. t/ Tuxedo: tmboot -y ZC|njI.s,Tuxedo {"&C8>~qwQt/#Kb,g{"v DB2 | n LIST APPLICATIONS ALL,G4&C4=I Tuxedo dCD~ UDBCONFIG D UDB_GRP PN} TMSCOUNT 8(D=u,S(ZKivB)# hC unixODBC }/Lr\mw *Z Linux r UNIX Yw53OKP ODBC &CLr,XkdC unixODBC }/L r\mw# Z 9 B hC&CLr*"73 71 }L *hC unixODBC }/Lr\mwTc+dk CLI M ODBC &CLrdO9C,k 4PBPYw: 1. S http://www.unixodbc.org BXnBD unixODBC 4zk# 2. +4D~b9u# }g: gzip -d unixODBC-2.2.11.tar.gz tar xf unixODBC-2.2.11.tar 3. v^Z AIX:+ C `kwdC*tC_L: export CC=xlc_r export CCC=xlC_r 4. *9C xlc_r `kw4`k 64 ;f>D}/Lr\mw,khC73d? OBJECT_MODE M CFLAGS: export OBJECT_MODE=64 export CFLAGS=-q64 -DBUILD_REAL_64_BIT_MODE 5. +}/Lr\mw20=zDw?#9P;)I! DB2 &\?~#3) DB2 }]bz 7M&\?~vZX(Yw53OIC# BmP>K?vYw53PICD DB2 }]bz7M&\?~# m 20. 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 W]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 21. 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. 2006, 2012 75 m 21. 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. CZ Linux on x86-32 2~D DB2 Enterprise Server Edition v'VbTM*"#+G,zIT9CT B=V=(49C DB2 Enterprise Server Edition for Linux on x86-32:;VG“HTsr”,;VGZ TCf1>O20 IBM Database Enterprise Developer Edition mI$i# m 22. 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 76 }]b&CLr*"kE =< 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. 2006, 2012 77 m 23. 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 ?: 80 }]b&CLr*"kE 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# 82 }]b&CLr*"kE 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 84 }]b&CLr*"kE =< 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. 2006, 2012 85 >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- 86 }]b&CLr*"kE 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 87 88 }]b&CLr*"kE w} [A] 20 *s AIX 5 HP-UX 7 Linux 8 Solaris Operating Environment 12 Windows 13 IBM }]~qw JDBC M SQLJ }/Lr 48 [B] oz SQL od 79 `LoT ** 29 C30 COBOL 32 C++ 31 FORTRAN 33 Perl 36 PHP 36 REXX 38 Ruby on Rails 37 ;7(Bq V4 X/Open V<=Bq&m (DTP) #M 52 bv 60 [C] Yw53 20*s AIX 5 HP-UX 7 Linux 8 Solaris Operating Environment 12 Windows 13 dC 44 &CLr*" 3, 5 [D] wC6SZ (CLI) Ev 20 73hC 48 IBM Data Server Client 'V 15 [F] V<=Bq&m (DTP) 2+T 63 ms&m 60 dC 66 Bq\mw (TM) 52 }]b |B(wzM System i) 60 ,S 66 &CLr (AP) 52 J4\mw (RM) 52 X/Open V<=Bq&m (DTP) #M 52 Vx}]b Bq CJ}]b 66 [G] |B DB2 E"PD 80, 81 JOoO LL 83 *zE" 83 [H] KD6p/} ODBC 20 73d? UNIX Ev 45 [J] LL JOoO 83 Pm 83 Jb7( 83 pureXML 83 bv=8 ;7(Bq 60 2,E*Vv *"$_ 41 [K] M'z dC 46 © Copyright IBM Corp. 2006, 2012 89 M'zXB7I T/ 66 M'zT/XB7I j8E" 66 [L] ,S JO M'zT/XB7I 66 ,SX|V ODBC .NET Data Provider 18 OLE DB .NET Data Provider 19 [M] |nP&mw (CLP) IBM Data Server Client 15 [Q] t"=Yw bv;7(Bq V/ 60 t"=v_ bv;7(Bq 60 6k= SQL &CLr Ev 21 IBM Data Server Client 'V 15 +Vd? XA Bq 69 [R] m~*s AIX 5 HP-UX 7 Linux 8 Solaris Operating Environment 12 Windows 13 [S] yw 85 Bq CJVx}]b 66 G XA 52 t\nO 52 =WNd5 52 +V 52 I"nO X/Open V<=Bq&m (DTP) #M 52 Bq&m`Sw 2+T 63 Bq&m`Sw (x) dC"bBn 66 BEA Tuxedo 70 IBM TXSeries CICS 70 Bq\mw V<=Bq&m 52 Ev 52 Jb7( 65 k XA ;B 39 BEA Tuxedo 70 IBM TXSeries CICS 70 IBM WebSphere Application Server 69 IBM WebSphere MQ 69 XA e5a9 63 }]b&CLr `LSZ 17 [T] unMu~ vfo 83 [W] D5 Ev 77 9CunMu~ 83 !"f 77 PDF D~ 77 Jb7( LL 83 ICDE" 83 [X] 53*s IBM OLE DB Provider for DB2 24 _L IBM OLE DB Provider for DB2 24 [Y] &CLr `LSZ 17 *"$_ 41 &CLr*" `LoT 29 Yw53 dC 44 \'V 5 Linux 44 UNIX 44 $_ 3, 41 73 Ev 1 90 }]b&CLr*"kE &CLr*" (x) 73 (x) dC 43 dC Yw53 44 73 43 73 (Windows) 45 &CLr`LSZ (API) D9C73 47 IBM Data Server Client 46 6k= SQL Ev 21 Bq\mw 39 &CLr`LSZ (API) dC 47 ** 17 'VD*X 3 IBM Data Server Client dC 46 j8E" 15 IBM Data Server Provider for .NET 17 Linux dC 44 Perl DBI 25 UNIX dC 44 Windows dC 45 2~ *s DB2 ~qwz7 (AIX) 5 DB2 ~qwz7 (HP-UX) 7 DB2 ~qwz7 (Linux) 8 DB2 ~qwz7 (Solaris Operating Environment) 12 DB2 ~qwz7 (Windows) 13 IBM }]~qwM'z (AIX) 5 IBM }]~qwM'z (HP-UX) 7 IBM }]~qwM'z (Linux) 8 IBM }]~qwM'z (Solaris Operating Environment) 12 IBM }]~qwM'z (Windows) 13 $`kw IBM Data Server Client 'V 15 [Z] wz}]b (} XA Bq\mwxP|B 60 J4\mw (RM) Ev 52 +}]bhC* 66 A ActiveX }]Ts DB2 Data Server Client 'V 15 ActiveX }]Ts (ADO) f6 IBM Data Server Provider for .NET 17 ADO.NET &CLr *" 17 AIX 20 DB2 ~qwz7 5 IBM }]~qwM'z 5 API Ev 17 t"= 62 B BEA Tuxedo dC 70 C C oT 'VDf> 30 COBOL oT 'VDf> 32 C/C++ oT 'VDf> 31 D Data Studio *"$_ 41 DB2 z7 r| 75 ;cE" 75 DB2 E"PD f> 79 |B 80, 81 DTP(V<=Bq&m) kNDV<=Bq&m (DTP) 52 F FORTRAN oT \'VDf> 33 H HP-UX 20 DB2 ~qw 7 IBM }]~qwM'z 7 w} 91 I IBM }]~qwM'z &CLr*" 3 IBM }]~qw JDBC M SQLJ }/Lr 20 48 DB2 f>6p 33 IBM Data Server Provider for .NET Ev 17 D5 17 IBM Database Add-Ins for Visual Studio *"$_ 41 IBM OLE DB Provider 20 24 f> 24 Ev 24 9C_ 24 a)Lr 24 53*s 24 IBM TXSeries CICS dC 70 ibm_db API j8E" 26 IBM_DB Ruby }/LrM Rails Jdw j8E" 26 ibm_db2 API j8E" 25 ibm_db_dbi API j8E" 26 ibm_db_sa Jdw j8E" 26 J Java DB2 z7'V 33 IBM Data Server Client 'V 15 JDBC }/Lr j8E" 22, 33 IBM }]~qw JDBC M SQLJ }/Lr 20 48 IBM Data Server Client 'V 15 L Linux 20 DB2 ~qw 8 IBM }]~qwM'z 8 b libaio.so.1 8 libstdc so.5 8 dC &CLr*" 44 LIST INDOUBT TRANSACTIONS |n V/bv;7(Bq 60 M Microsoft Visual Studio .NET i4 IBM Data Server Provider for .NET D5 17 O ODBC KD6p/} 20 }/Lr\mw unixODBC 72 CLI 20 ODBC .NET Data Provider Ev 18 OLE IBM Data Server Client 'V 15 OLE DB m/} 24 OLE DB .NET Data Provider Ev 19 P pdo_ibm j8E" 25 Perl f> 36 }]bSZ (DBI) f6 25 PHP f> 36 &CLr*" 25 IBM }]~qwD)9 25 Python &CLr*" 26 IBM }]~qwD)9 26 R Rails Jdw j8E" 26 Rational Application Developer(RAD) \'VD*"$_ 41 Rational Data Architect \'VD*"$_ 41 Rational Software Architect \'VD*"$_ 41 REXX oT 'VDf> 38 Ruby }/Lr j8E" 26 Ruby on Rails *"$_ 41 Ruby/Ruby on Rails oT \'VDf> 37 92 }]b&CLr*"kE S SAMPLE }]b ,S ODBC .NET Data Provider 18 OLE DB .NET Data Provider 19 SDK z76p 33 Solaris Yw53 20*s DB2 ~qw 12 IBM }]~qwM'z 12 SQL `-w 41 SQL CJi 20 SQL od oz T> 79 /, SQL 21 2, SQL 21 SQLAlchemy IBM }]~qwDJdw 26 SQLJ }/Lr 22 IBM Data Server Client 'V 15 System i }]b (} XA Bq\mwxP|B 60 T TPM 5 55 TPMONNAME 5 55 Tuxedo dC 70 TXSeries CICS 70 U UNIX dC &CLr*" 44 &CLr*" 73d?hC 45 unixODBC }/Lr\mw hC 72 W WebSphere Application Server Ev 69 WebSphere MQ Ev 69 Windows 20 DB2 ~qw(*s) 13 Windows (x) 20 (x) IBM }]~qwM'z(*s) 13 &CLr*"73dC 45 X XA f6 63 SZ 52 P; 63 Bq 69 XA Bq\mw 2+T"bBn 63 |Bwz}]b 60 |B System i }]b 60 JOoO 65 Pm 39 dC"bBn 66 X/Open V<=Bq&m (DTP) #M j8E" 52 X/Open Company 20 X/Open SQL CLI 20 Z Zend Core 41 [XpV{] .NET &CLr*"m~ 29 w} 93 94 }]b&CLr*"kE  Printed in China G151-1764-00 Spine information: IBM DB2 10.1 for Linux, UNIX, and Windows }]b&CLr*"kE 
还剩104页未读

继续阅读

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

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

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

下载pdf

pdf贡献者

yulewo123

贡献于2016-11-06

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