ibm数据移动实用程序指南和参考

yulewo123

贡献于2016-11-06

字数:0 关键词: DB2 数据库服务器

IBM DB2 10.1 for Linux, UNIX, and Windows }]F/5CLr8OMN< S151-1756-00  IBM DB2 10.1 for Linux, UNIX, and Windows }]F/5CLr8OMN< S151-1756-00  "b 9CKE"0d'VDz70,kHDAZ 247 3D=< F, :yw;BD#fE"# ^)fyw KD5|, IBM DyP(E"#|ZmI-iPa),R\f((D#$#>vfoP|,DE";|(TNNz7D #$,Ra)DNNod<;h*gKbM# zIZ_r(}1XD IBM zm&): IBM vfo# v *Z_):vfo,k*A IBM vfoPD,x7*:http://www.ibm.com/shop/publications/order v *iR1XD IBM zm&,k*A IBM +r*5K?<,x7*:http://www.ibm.com/planetwide/ *S@zrSCsD DB2 P!Mz[?): DB2 vfo,kBg 1-800-IBM-4YOU(426-4968)# z"ME"x IBM s,4Zh IBM G@<(^,IBM IT4|O*J1DNN==9CrV"zya)DNNE"x ^kTzP#NNpN# © Copyright IBM Corporation 1993, 2012. ?< XZ>i...............v }]F/5CLrMN< ........1 }]F/!n ..............1 INGEST 5CLrE> .......123 d{}]F/!n ............125 (}9C ADMIN_MOVE_TABLE }L4T*z ==F/m .............125 IBM 4F$_(4i~) ........128 4F#= ..............129 9CT/zIDE>44PX(r4- ....140 (}]R I/O M*zVn5q'Vq!_ICT 160 db2relocatedb - X(;}]b .......162 db2look - DB2 3FE"M DDL i!$_...167 INGEST 5CLr"XoT'V .........225 XML }]F/ ............226 =< A. SQL 4,oz ......241 CJ;,f>D DB2 E"PD .......241 |B20ZFczrZ?x~qwOD DB2 E"P D .................242 V/|B20ZFczrZ?x~qwOD DB2 E "PD................243 DB2 LL...............245 DB2 JOoOE"............245 E"PDunMu~ ...........245 =< F. yw ............247 w} ...............251 © Copyright IBM Corp. 1993, 2012 iii iv }]F/5CLr8OMN< XZ>i >ia)KPXTBDB2® Database for Linux, UNIX, and Windows}]F/5CLr DE","]>KgN9Cb)5CLr: v EXPORT 5CLrM IMPORT 5CLr EXPORT 5CLrM IMPORT 5CLr9C DB2 Connect™ ZmrSwbE vKzIT9CD}]F/$_"5CLr"f"}LM|n# b)mIozz7(D)}]F/!n\nCXzczDhs# m 1. 0k5CLr =( 0k5CLr C> _'X+s?}]F=B4(Dmr_Q|, }]DmP# Gqg=(f] G nQ5yC( 1T\GzX"Dw*=f1,9CK5CL rnOJ#K5CLrITCw#0kYwITdV{C SMP M MPP 73PDJ4,g CPU MZ f# N +w}]SD~r\@wk= DB2 ?jm,, 1T9b)mIC# Gqg=(f] G nQ5yC( K5CLrIZT\MICT.do= +b?D~PD}]ek=m"cNa9"S TdP;Vb?D~q= (}+ db2move 5CLrk COPY !ndO9 C,zIT+#=#e(|,}]r;|,} ])S4}]b4F=?j}]b,r_+{ v#=S4}]bF/=?j}]b#+ db2move 5CLrk IMPORT r EXPORT !nd O9CP{ZZ DB2 }]b.dF/s?m# Gqg=(f] G nQ5yC( k COPY !ndO9C1,4}]bM?j}] bXk;,#COPY !nTZzI#=#e\P C#1g=(8]M4-Yw;\'V1,I 9C IMPORT r EXPORT !n4K!}]b# IMPORT M EXPORT !n+k db2look |ndO 9C# N 9CVP8]3qPDE>+{v}]bS; v534F=m;v53# 2 }]F/5CLr8OMN< m 6. RESTORE |n (x) Gqg=(f] \^F#kND“N44PX(r4-; v }]V40_ICT8OkN X|{}]b,r+{vr?V}]bXBV dx,;53rm;53# Gqg=(f] q nQ5yC( v 18]M4-5CLr*DCs?1d1, IT9CK5CLr# v ZF/r4(}]b1>1,I+K5CL rCw8]M4-5CLrD8C5CL r# v K5CLr9a)K;VlY=(4*d{ 73(gbT)K!}]b# v IT9CK5CLr+mUd]wF=;i BDf"h8# N JmzzI%v#=PyPTsD1>,;s ZB#=PXB4(b)Ts#ITZ}]b P9C}]r;9C}]4PK4FYw# Gqg=(f] G }]F/5CLrMN< 3 m 8. ADMIN_COPY_SCHEMA }L (x) nQ5yC( K5CLrTZzI#=#e\PC#g{z k*Ti#=(}g,"T9CBw}),+ ;k0l4#=DP*,G4K5CLr2\ PC#ADMIN_COPY_SCHEMA }Lk db2move 5CLrDw*npZZ: v ADMIN_COPY_SCHEMA }LCZ%v}] b,x db2move 5CLrZwv}]b.d 9C v g{ZwC db2move 5CLr1|;\4( omTs(gmrw}),G4K5CLr +'\#ADMIN_COPY_SCHEMA }L+G Jmz+mPD}]FA,{DBmTs(+ G_PI\;,Df"Xw),x}]T;& Z*z4,"RI)CJ# Gqg=(f] G nQ5yC( K5CLraT/+m}]FABmTs,, 19Jm}]&Z*z4,T)xP!q"e k"|BM>}CJ#z9ITZF/m1z I9uVd# v \b,1T,;mUd4P`vF/Yw# v ZmODn/OY1KPK}L# v 9C`=hF/Yw#ITZNN1rwC INIT M COPY WN#4P REPLAY WN` NT9G(ms!O!,;sZmODn/ OY1"v SWAP# v g{*&m;P(;w}Dmr;PNNw }Dm,k 4(K!"8Cr8]}]b Gqg=(f] q nQ5yC( v 4(8C53,TcZw53"zJO1u Y#z1d v ZVn}]bO4P8]Yw,x;CZ5 1zzzwO4PKYw v a);VlY=(4*d{73(gbT) K!}]b "bBn v ;\Z}]bDVnf>O8] DMS mU d v (#kf"53a)D2d4F,+bya9CZ}]bDf"wUdS 6 Nh8b?4!?5MdvD~yC Jb# {"D~ {"D ~#TZ CLP TbDyPSZ,Xk$H9C MESSAGES N}8(b)D~D {F#g{*9C CLP "R;8({"D~,G4P,IT9CTB$_DNqzV:}rCJ}]bJ4#(^6pa)K;V=(,TJm z+X(3dA_6}]b\mw,$M5CLrYw# X(M(^2,XF}]b\mw0d}]bTsDCJ#C';\CJ{GTd_ P`&(^(4XhDX(r(^)DTs# TZNk} r% XML }]#XDS Gm>* XML jG(d{FG“XDS”)DV{.,|_PCZhvXZPP5J XML }]D E"DtT;bVE"f0|,5J XML }]DD~{,T0CD~Z XML }]D +F?M$H# IT9C XML TO M XMLFILE !n8({F# g{8(K XML TO r XMLFILE !n,G4Q{F|(Q} ZBP>}P,Y( USER.T1 m|,DP=P: }]F/5CLrMN< 7 C1 INTEGER C2 XML C3 VARCHAR(10) C4 XML m 11. USER.T1 C1 C2 C3 C4 2 You Menote1 Hello World! ’char1’ Him Hernote2< body>Hello World! 4 NULL ’char2’ ?xml version=″1.0″ encoding=″UTF-8″ ?>to>Us Themnote3 Hello World! >} 1 TB|n+(g ASCII (DEL) q=D USER.T1 DZ] { F * “t1export.del.xml”#XMLSAVESCHEMA !n8>+Z","char1", "" 4,,"char2","" You Menote1Hello World! Him Hernote2Hello World! UsThemheading>note3 Hello World! >} 2 TB|n+ DEL q=D USER.T1 DZ]{F“xmldocs”|{ XML D~,"++Z","char1", "" 4,,"char2","" You Menote1Hello World! HimHernote2 Hello World! UsThem note3Hello World! >} 3 }K+} 2 `F# EXPORT TO /mypath/t1export.del OF DEL XML TO /home/user/xmlpath XMLFILE xmldocs MODIFIED BY XMLINSEPFILES XMLSAVESCHEMA SELECT * FROM USER.T1 ","char1","XDS FIL=’xmldocs.002.xml’ />" 4,,"char2","" You Menote1Hello World! note time="13:00:00">to>Him/to> from>Her/from>heading>note2/heading>body>Hello World!/body> /note> Us Themnote3Hello World! >} 4 TB|n+ XQuery Da{4k XML D~# EXPORT TO /mypath/t1export.del OF DEL XML TO /home/user/xmlpath XMLFILE xmldocs MODIFIED BY XMLNODECLARATION select xmlquery( ’$m/note/from/text()’ passing by ref c4 as "m" returning sequence) from USER.T1 " "" }P} >} 1 TB>}5wgNT IXF dvq=+ SAMPLE }]b(C'Xk,SAD}]b)D STAFF mPDE"} 2 TB>}5wgNT IXF dvq=+ SAMPLE }]b(C'Xk,SAD}]b)D STAFF mPPX Department 20 D01DE"} 3 TB>}5wgN+ LOB } 4 TB>}5wgN+ LOB } 5 TB>}5wgN+}]$J mzA!D}]# g{ LBAC >$;JmzA!3P,G4CP;a$;JmzA!3P,G4} ZBP>}P,dv9C DEL q=,"Ra4AD~ myfile.del#}]+Sm REPS P}aT1!q= `-wPDIAT;+C: TB>}aT2+jEV{.q=}4(D}]D~D*<#"b,2+jEDq=GIDAD: ... "Secret:():Epsilon 37", 2005, "Susan Liu" "Secret:():(Epsilon 37,Megaphone,Cloverleaf)", 2006, "Johnny Cogent" "Secret:():(Megaphone,Cloverleaf)", 2007, "Ron Imron" ... mSO=BSs=R/@cNa9 PyP,mMSm#Z_P 4 VP'iz3rDcNa9: v Person -> Employee -> Manager -> Architect -> Student v Person -> Student -> Employee -> Manager -> Architect v Person -> Employee -> Architect -> Manager -> Student v Person -> Student -> Employee -> Architect -> Manager 12 }]F/5CLr8OMN< IZiz3r7(K;)}]`TZd{}]DF/?j;C,yT,Zmc Na9.dF/}]1,K3r.VX*#P=V`MDiz3r:1!iz 3rMC'8(Diz3r# 1!iz3r 9C1!iz3r1,yP`X`MD 1!iz3r* Person -> Student -> Employee -> Manager -> Architect# Zk;,D~q=dO9C1,1!iz3rDP*Py;,#g{+}]< v* PC/IXF D~q=,G4+4(yP`X`M"|GD(e0`XmDG <#} }]F/5CLrMN< 13 cNa9(Sm)1AW?Sm,;s5XAd,m,YrB/@B;v“n R_D”Sm,;s5XA|_6pD,m,YrB/@AdSm,@K` F# g{k*XFcNa9Diz3r,G47#T} 1 TB>}yZ< 1 PDVca9#*1!iz3rSm PRESON * <# >} 2 *=20 "b,+N} HIERARCHY hC* Person, Employee, Manager, Architect, Student +8>C'8(Diz3r# j6P LOB }]ZD~Pf";CDV{.# LLS Dq=* lobfilename.ext.nnn.mmm/,dP lobfilename.ext G|, LOB DD ~D{F,nnn GCD~Z LOB D+F?(TVZ*%;F?),x mmm G LOB D$H(TVZ*%;F?)#}g,db2exp.001.123.456/ D LLS m> LOB ;Z D~ db2exp.001 P,T 123 VZD+F?*Ds!* 0,G4 LOB ;S*$HG 0#g{$H* -1,G4 LOB ;S* NULL,"RvT+F?MD~{# g{;#{w LOB }]"CZ,;D~,k9C lobsinsepfiles D~`M^N{T +?v LOB 4A%@D~# ":IXF D~q=;af"CPD LOB !n,gCZ8>GqG< LOB PD!n# bb6E} 1 TB>}5wgN+ LOB(dPQ{F lobs1)} 2 TB>}5wgN+ LOB }yPVP}]"ekQ}yPVP}]"ekQP,IT9CTB$_DNqzV: XML r LOB }]fZ, G4Ud"bBn,nC8(d5Z{"D~T|,kCYw`X*Dms{ ""/f{"MN<{"#g{C5CLrG(}&CLr`LSZ (API) db2Import wCD,G4Xk9C MESSAGES N}$H8(b)D~D{F,q rKN}GI!N}#9C{"D~IT\=cX`SI&h DATAACCESS (^,IT4PNN`MDKT?vNkm" S$#*+}]}mDZ],;s9C INSERT odwC};sXB4(Cm,SE9C INSERT odwC} r%}P,+kT}P,+kT} >} 1 TB>}5wgN+ myfile.ixf PDE"} 2 TB>}T>gN} 3 TB>}T>gN{DmP: TABLE1 P 5 P: v COL1 VARCHAR 20 NOT NULL WITH DEFAULT v COL2 SMALLINT v COL3 CHAR 4 v COL4 CHAR 2 NOT NULL WITH DEFAULT v COL5 CHAR 2 NOT NULL ASCFILE1 P 6 v*X: v ELE1 ;C 01 = 20 v ELE2 ;C 21 = 22 v ELE5 ;C 23 = 23 v ELE3 ;C 24 = 27 v ELE4 ;C 28 = 31 v ELE6 ;C 32 = 32 v ELE6 ;C 33 = 40 }]G<: 1...5....10...15...20...25...30...35...40 Test data 1 XXN 123abcdN Test data 2 and 3 QQY wxyzN Test data 4,5 and 6 WWN6789 Y TB|n+ ASCFILE1 PDG<:0k TABLE1 1,TZx(DP,Gq+ COL2 M COL3 hC* NULL#TZx(G<,g{CPDU8>{;C|, Y,G4CP +G NULL#g{|, N,G4+dkG<(I L(........) (e)PCPD}];C P|,D}]5CwCPDP}]4#ZK>}P,Z 1 PPDNN;P<;G NULL;Z 2 PPD COL2 G NULL;Z 3 PPD COL3 G NULL# 3. ZK>}P,+ COL1 M COL5 D NULL INDICATORS 8(* 0(c),m> }];I*U# 4. x(PD NULL INDICATOR ITZdkG`M#t) – j6tT – $H(lob_file `M}b) – zk3(g{JC) – j6!n – PG(e*IU9G;IU – #?D1!5(g{fZ),+;|(d{`MD1!5 v w}E",|(: – w}{ – w}4(_{ – P{T0?PG4}r9G5rEr – w}Gq;(e*(;w} – w}GqG/:w} – w}GqJmfr(h – PCTFREE 5 }]F/5CLrMN< 23 – MINPCTUSED 5 ":g{w}PDP{|,V{ - r +,G4;a#tNNw}E","R5 X SQL27984W# *'DtT XB4(Dm;a#t-} >ZPD>}yZTBcNa90DVP'iz3r: v Person -> Employee -> Manager -> Architect -> Student v Person -> Student -> Employee -> Manager -> Architect v Person -> Employee -> Architect -> Manager -> Student v Person -> Student -> Employee -> Architect -> Manager }]F/5CLrMN< 25 >} 1 *9C} 2 *XB4(4}]bD{vcNa9"+d} 26 }]F/5CLr8OMN< EMPLOYEE DP#4,SerialNum M REF(Employee_t) P;a} 3 K>}T>gNS#fmbViv,yT}P,?jm STUDENT XkfZ#r* STUDENT GSm,yT^N{ no_type_id CZ8>Z;PP;P Type_id#+G,}K STUDENT mPfZDyP d{tT.b,9Xk7#fZ Object_id P#Object-id &CG$#T Z10k?jm`X*D2+_T,Xk,1a)P'2+jEr_I*;*P'j ED2+jE# g{;PP' LBAC >$,D5JVZ}#+G,3)-< }]I\|,;P{,|GI\a; IMPORT |nmsXbM*P(g{#g {"zKJb,k9C delprioritychar D~`M^N{T7#V{(g{E HZP(g{#9C delprioritychar 1,|,ZV{(g{PDNNG#$mD2+_TPDP'2+jE,G4;aekCP,"R a5X/f(SQLSTATE 01H53)# 9I{FD2+jE;fZ,G4;a ekCP,"Ra5X/f(SQLSTATE 01H53)# >} TZyP>},dk}]D~ myfile.del +9C DEL q=#}]a},Y(dkD~|,1!q=D2+jE: db2 import from myfile.del of del modified by delprioritychar insert into reps TZK>},Y(dkD~|,2+jEV{.q=D2+jE: db2 import from myfile.del of del modified by seclabelchar insert into reps TZK>},Y(dkD~|,2+jEPD2+jE{F: db2 import from myfile.del of del modified by seclabelname insert into reps :eek}: Robert, 45.2, J Mike, 76.9, K Leo, 23.4, I y*: db2 import from import.del of del replace into table1 (c1, c3, c4) +G,TZ|,m`PDm45,Ko(QT9C"R]Wvm#: db2 import from import.del of del modified by identitymissing replace into table1 ZxPj6PDivB}: 1, 5, J 2, 6, K 3, 7, I y*: db2 import from import.del of del replace into table1 (c1, c2, c3) +G,TZ|,m`PDm45,Ko(QT9C"R]Wvm#m;V: db2 import from import.del of del modified by generatedmissing replace into table1 Z_PzIPDivB:49dk}]D~|,yPzIPD}],2&CvTb)}],"R&C*? ;PzI5#}g,C'I\*+TB}]SD~ (import.del) f" LOB }]D;C LOB }]D;C#}T>gN}]`M#byz M;X+ UDT T=*;*y>}]`M#}]`M*;JmZ UDT k SQL PDy >}]`M.dxPHO# d{D?<,g{8(K) D tmp S?Z#fcI&0kDdkP}# 2. 9( Z9(WN,+y]0kWNU/Dw}|zIw}#Z0kWN+Tw}|xP Er"U/w}3FE"(g{8(K STATISTICS USE PROFILE !nRE*D~8 >U/w}4,)#b)3FE"k(} RUNSTATS |nU/D3FE"`F# 3. >} Z>}WN,+SmP}%}DP+f"ZCmP# 4. w}4F Zw}4FWN,+w}}]S53Y1mUd4F=-}mPDVP}]"Cdk}]ndCm# v RESTART ZK==B,QPOD0k+Lx#Zs`}ivB,0k+S|'\1y&DW NLx#g{CWN*0kWN,G40k+SO;vI&;BcLx# v TERMINATE ZK==B,+Xv'\D0kYw# IT8(D!n|(: v *0kD}]ZM'zO(g{S,SD6LM'zwC0k5CLr)#k" b,49z8( CLIENT !n,2}Mw}4F }]F/5CLrMN< 35 1. ;\ZYwjI.si4{"D~DZ]#g{*Z0kYw}ZKP1i40 k{",G4IT9C LOAD QUERY |n# 2. Z{"D~P,?u{"0kYwy]CE*D~ U/3FE",0kYwMa'\"5Xms{"# g{Tm7S}],M;aU/3FE"#*U/PX7SDmD103FE", kZ0k}LjIswC RUNSTATS 5CLr#g{T|,(;w}DmU/3FE ","RZ>}WN>}KX4D|,G4;a|B3FE"4}tDG <#g{z$FaP`1}?DX4G<,k;*Z0kYw4PZdU/3FE "#xG,&CZ0k}LjIswC RUNSTATS 5CLr# v Gq#tyw|DD1>#g{#t|D1>,MITtC}]b0vV4&\# g{T}]b{CK0vV4&\(4,}]bdCN} logarchmeth1 M logarchmeth2 hC* OFF),G4;'VK!n#g{44(1>,+tCK0vV 4&\,G40kYwjI.s,mUd+&Z“8]]R”4,# *9}]bj+IV4,Mh*xPG<#0k5CLr8uj+;G,x;GxPG<#g{ }]b73JmZ"zJOsxP}]bV4,G4IT4PBPdP;nYw: – T=ks4(mDQ0k?VD1># – Z0kYwjIs"48]myZDmUd# g{hCK}]bdCN} logindexbuild,"RwC0kYw18(K COPY YES I V4T!nM INCREMENTAL ("w}!n,G40kYw+GG}byDm(kNDZ 37 3D< 4)#g{8(KK!n, Z0kYwjIsM;a+mUdCZ“8]]R”4,,"RZ0kYw4PZd ;X4(y0k}]D1># 36 }]F/5CLr8OMN< v 0kYw4PZd4(Y1D~1*9CDj<76#K{FI LOAD |nD TEMPFILES PATH N}8(#1!5G}]b76#K76Z~qwO,"RI DB2 5}T@<==CJ#rK,TKN}8(DNN76{^($# DB X X X () < 4. 0vYw4PZdD;IV4&m }]F/5CLrMN< 37 v *+}]0k=|,\#$PDmP,XkQ+#$CmD2+_Ty|,D4C J2+jEZha0Z(j6# LOAD (^ Z}]b6p_P LOAD (^T0Tm_P INSERT X(DC'IT9C LOAD |n +}]0k=mP# ":_P DATAACCESS (^DC'T LOAD |n_Pj+CJ(# g{H0D0kYwGC40kek}]DYw,G4Z}]b6p_P LOAD (^ RTm_P INSERT X(DC'IT4P LOAD RESTART r LOAD TERMINATE Yw# Z}]b6p_P LOAD (^,1Tm_P INSERT M DELETE X(DC'IT9 C LOAD REPLACE |n# g{H0D0kYwG0kf;,G49XkTCC'Zh DELETE X(,CC'E \4P LOAD RESTART r LOAD TERMINATE Yw# g{+l#mCw0kYwD;?V,G4C'Tl#mXk_P INSERT X(# _PK(^DC'IT4P QUIESCE TABLESPACES FOR TABLE"RUNSTATS M LIST TABLESPACES |n# 0k}] 0k5CLr\;P'X+s?}]F=B4(Dmr_Q|,}]DmP# *<.0 ZwC0k5CLr0,Xk,SA(r\;~=,SA)*+}]0k=dPD} ]b# IZC5CLr"v COMMIT od,yT&C(}"v COMMIT r ROLLBACK o d4jIyPBq"MEyPx(,;sYwC0k5CLr# }]G4UvVZdkD~PD3r0kD,+9C`,/: (MDC) m"Vxmr anyorder D~`M^N{1}b#g{*9CX(3r,kZ"T4P0kYw.0T }]xPEr#g{h*xP/:,G4&CZ4P0k04/:w}T}]xPE r#Z+}]0k=`,/:m (MDC) P1,Z4P0kYw0;h*xPEr,} ]+y] MDC m(exP/:#Z+}]0k=VxmP1,Z4P0kYw0;h *xPEr,}]+y]m(exPVx# ^F BfGJCZ0k5CLrDdP;)^F: v ;'V+}]0k=GFP# v ;'V+}]0k=`Mmr_xPa9/`MPDmP# v ;'V+}]0k=QywDY1mMQ4(DY1mP# v ;\S~qwKA! XML }];g{*SM'KA! XML D~,G49C}m# 38 }]F/5CLr8OMN< v ;\+}]0k=(} DB2 Connect r6pMZ DB2 V2 D~qwCJD}]bP# vJCZ10f>D!n;\CZH0"PfD~qw# v g{ LOAD REPLACE YwZdvm,G4mPD-<}]Ma*'#z&C#t;] dk}]Tc\;XBt/0kYw# v ;aTB0kDP$n%"w#0k5CLr;a?F4Pk%"w`X*D5q fr# v ;'V0kQS\D}]# BfGZ0k=Vxm1JCZ0k5CLrDdP;)^F: v 1VxzmLr}sZ 1 1,;'V;Bc# v ;'V+}]0k=}]VxS/PD,1#Vd`}]Vxj+*z# v 0kYwrhCj{T]RYw9CDl#m;\Vx# v 10k5CLrTek==rXBt/KP"R0k?jm_PNNQpkDSt 1,G4;\X((;w}# }L *wC0k5CLr,k4PTBYw: v Z|nP&mw (CLP) P"v LOAD |n# v SM'z&CLrwC db2Load &CLr`LSZ (API)# v Z IBM Data Studio PT LOAD |nr*NqzV# >} TBG(} CLP "vD LOAD |n>}: db2 load from stafftab.ixf of ixf messages staff.msgs insert into userid.staff copy yes use tsm data buffer 4000 ZK>}P: v +NN/frms{"Ek staff.msgs D~# v ywD|DD;v1>+f"Z Tivoli® Storage Manager (TSM) P# v Z0kYwZd+9C 4000 3D:exUd# TBG(} CLP "vDm;v LOAD |n>}: db2 load from stafftab.ixf of ixf messages staff.msgs tempfiles path /u/myuser replace into staff ZK>}P: v +f;m}]# v 9C TEMPFILES PATH N}+ /u/myuser 8(*4kY1D~D~qw76# ":b)>}T0kdkD~9C`T76{#;JmS}]byZ}]bVxOD M'zxPDwC9C`T76{#(i9Cj<76{# B;=v24 wC0k5CLrs,IT9C LIST UTILITIES |n4`S0kYwDxH#g{T INSERT =="REPLACE ==r RESTART ==4P0kYw,G453aa)j8xH }]F/5CLrMN< 39 `S'V#"vx SHOW DETAILS N}D LIST UTILITIES |n4i4XZ100kW NDj8E"#T TERMINATE ==4P0kYw1,+^(q!j8E"#LIST UTILI- TIES |nvT>0kU95CLr10}ZKP# 0kYw#t(; 'V9CQywNj40k XML }]#TB>}ywNj"9CCNjM LOAD |n +m CUSTOMERS PD}]mS=m LEVEL1_CUSTOMERS P: DECLARE cursor_income_level1 CURSOR FOR SELECT * FROM customers WHERE XMLEXISTS(’$DOC/customer[income_level=1]’); LOAD FROM cursor_income_level1 OF CURSOR INSERT INTO level1_customers; + XML }]0k= XML PP1'V LOAD |n9C ANYORDER D~`M^N{# Z0kZd,;aU/`M* XML DPDV<3FE"# ZVx}]b73P0k XML }] TZV}P,+kTI(g ASCII dkD~ data2.del PD XDS j6D#=i$kV XML D5: LOAD FROM data2.del OF DEL XML FROM /home/user/xmlpath XMLVALIDATE USING XDS INSERT INTO USER.T2 ZKivB,XDS |, SCH tT0CZi$D XML #=Dj< SQL j6 “S1.SCHEMA_A”: 40 }]F/5CLr8OMN< 8(bv!n IT9C XMLPARSE !n48(G#t9G%t0kD XML D5PDUq#ZTB >}P,+kTxP SQL j6“S2.SCHEMA_A”D#=i$yP0kD XML D5, "RZ#tUqDivBbvb)D5: LOAD FROM data2.del OF DEL XML FROM /home/user/xmlpath XMLPARSE PRESERVE WHITESPACE XMLVALIDATE USING SCHEMA S2.SCHEMA_A INSERT INTO USER.T1 0ka0 - CLP >} >} 1 TABLE1 P 5 P: v COL1 VARCHAR 20 NOT NULL WITH DEFAULT v COL2 SMALLINT v COL3 CHAR 4 v COL4 CHAR 2 NOT NULL WITH DEFAULT v COL5 CHAR 2 NOT NULL ASCFILE1 P 6 v*X: v ELE1 ;C 01 = 20 v ELE2 ;C 21 = 22 v ELE3 ;C 23 = 23 v ELE4 ;C 24 = 27 v ELE5 ;C 28 = 31 v ELE6 ;C 32 = 32 v ELE7 ;C 33 = 40 }]G<: 1...5...10...15...20...25...30...35...40 Test data 1 XXN 123abcdN Test data 2 and 3 QQY XXN Test data 4,5 and 6 WWN6789 Y TB|nSD~P0km: db2 load from ascfile1 of asc modified by striptblanks reclen=40 method L (1 20, 21 22, 24 27, 28 31) null indicators (0,0,23,32) insert into table1 (col1, col5, col2, col3) ": 1. IZZ MODIFIED BY N}P8(K striptblanks,yT+?FXO VARCHAR PPDUW(}g,Z 1"2 M 3 PPD COL1 P$HVp* 11"17 M 19 v VZ)# 2. Z MODIFIED BY N}P8(K reclen=40,bm>Z?vdkG<)2;P;P {,"R?vG:0k TABLE1 1,TZx(DP,Gq+ COL2 M COL3 hC* NULL#TZx(G<,g{CPDU8>{;C|, Y,G4CP +G NULL#g{|, N,G4+dkG<(I L(........) (e)PCPD}];C P|,D}]5CwCPDP}]4#ZK>}P,Z 1 PPDNN;P<;G NULL;Z 2 PPD COL2 G NULL;Z 3 PPD COL3 G NULL# 5. ZK>}P,+ COL1 M COL5 D NULL INDICATORS 8(* 0(c),m> }];I*U# 6. x(PD NULL INDICATOR ITZdkG} 2(9C*"D~) m FRIENDS D(egBy>: table friends "( c1 INT NOT NULL, c2 INT, c3 CHAR(8) )" g{"T+BP}]G<0k=mP: 23, 24, bobby , 45, john 4,, mary +\xZ~P,bGr*Z;v INT G NULL,+P(e8(K NOT NULL#|, k DEL q=;;BDu}: 22 3, 34,"bob" 0k5CLr+0k 22,34,"bob" "zI;u/f{",C{"8vvTKZ;PP 22 sfD3)}]#;a\xCG<# >} 3(0k|,j6PDm) TABLE1 P 4 P: v C1 VARCHAR(30) v C2 INT GENERATED BY DEFAULT AS IDENTITY v C3 DECIMAL(7,2) v C4 CHAR(1) TABLE2 k TABLE1 `,,+ C2 G GENERATED ALWAYS j6P# DATAFILE1 PD}]G<(DEL q=): "Liszt" "Hummel",,187.43, H "Grieg",100, 66.34, G "Satie",101, 818.23, I 42 }]F/5CLr8OMN< DATAFILE2 PD}]G<(DEL q=): "Liszt", 74.49, A "Hummel", 0.01, H "Grieg", 66.34, G "Satie", 818.23, I ": 1. IZZ DATAFILE1 P;P*Z 1 PMZ 2 Pa)j65,rKTB|n+*b =PzIj65#+G,VpTZ 3 PMZ 4 P8(KC'a)Dj65 100 M 101# db2 load from datafile1.del of del replace into table1 2. *+ DATAFILE1 0k= TABLE1 P,Tc*yPPzIj65,k"vBPd P;v|n: db2 load from datafile1.del of del method P(1, 3, 4) replace into table1 (c1, c3, c4) db2load from datafile1.del of del modified by identityignore replace into table1 3. *+ DATAFILE2 0k= TABLE1 P,Tc*?;PzIj65,k"vBPd P;v|n: db2 load from datafile2.del of del replace into table1 (c1, c3, c4) db2 load from datafile2.del of del modified by identitymissing replace into table1 4. *+ DATAFILE1 0k= TABLE2 PTcTZ 3 PMZ 4 P8(j65 100 M 101,k"vTB|n: db2 load from datafile1.del of del modified by identityoverride replace into table2 Z>}P,IZ8>0k5CLr9CC'a)D542G53zIDj65,y T+\xZ 1 PMZ 2 P#+G,g{C'4a)5,MXk\xCP,bGr* j6PZ~=ivB;\* NULL# 5. g{+ DATAFILE1 0k= TABLE2 P,+49CNNkj6`XDD~`M^ N{,G4+0kZ 1 PMZ 2 P,++\xZ 3 PMZ 4 P,bGr*b= Pa)K|GT:DGU5,xj6PG GENERATED ALWAYS P# >} 3(S CURSOR 0k) MY.TABLE1 P 3 P: v ONE INT v TWO CHAR(10) v THREE DATE MY.TABLE2 P 3 P: v ONE INT v TWO CHAR(10) v THREE DATE Nj MYCURSOR G4TB==(eD: declare mycursor cursor for select * from my.table1 }]F/5CLrMN< 43 TB|n+ MY.TABLE1 PDyP}]0k= MY.TABLE2 P: load from mycursor of cursor method P(1,2,3) insert into my.table2(one,two,three) ": 1. Z%v LOAD |nP;8(K;vNj{#4,;Jm load from mycurs1, mycurs2 of cursor...# 2. TZSNj0k45,P'D METHOD 5;P P M N# 3. ZK>}P,IZekPPm (one,two,three) m>1!5,yTIT+ METHOD P MCekPPm!T# 4. MY.TABLE1 ITGm"S<"p{rGF# VxmD0k"bBn T?jmxPVx1,+'VyPVP0k&\,+fZTB#f^F: v 1VxzmLr}sZ 1 1,;'V;Bc# v ;'V+}]0k=}]VxS/PD,1#Vd`}]Vxj+*z# v 0kYw9CDl#m;\Vx# v g{?jm|, XML P,G4;\8(l#m# v 1 LOAD 5CLrTek==rXBt/KP"R0k?jm_PNNQpkDS t1,G4;\X((;w}# v k0k MDC m`,,0kVxm1+;a#tdk}]G3)?jm}]Vx&Z`, rpk4,#kTT&Z?jmD`X?v4,+a|(Z\xDG"V6'%},+;aT?;vG<4G<{"#}K?jmPD yPP.b,l#m9|(CZhvX(P"zD`M%}DP#|,^'} ]DP(|(;\VxD}])+4A*"D~# r*l#mekI>\_,yTITXFek=l#mPD4P'+r*6'^Fr(;TVxmKPK0kY w# U90kYw U90kf;Yw+j+XOyPIS}]Vx,xU90kekYwa+y PIS}]VxXOA0k0D$H#g{ ALLOW READ ACCESS LOAD Y wZ0k4FWN'\,G4ZU9CYwZd,w}adC^'#ZU9f 0w}D ALLOW NO ACCESS LOAD Yw1,w}2adC^',bGr *X(w}==r_v?,$ZdekK|x9Cw}&Z;;B4,#+} ]0k=`v?jP;a0l0kV4Yw,++^(S0kWNZdq!D ;BcXBt/0kYw#ZKivB,g{T?jmxPVx,G4+vT SAVECOUNT 0k!n#KP*k+}]0k= MDC ?jmPDP*;B# zIP g{zIPZNNVx",rV<|P,G4avT generatedoverride D~ `M^N{"R LOAD 5CLrazI5,Mq8(K generatedignore D ~`M^N{;y#ZKivB,0kmsDzIP5I\G<,b)U>GUd?# v 1m,1xPKVxMV<1,Vx}]b0kI\;a0lyP}]bV x#;Pdv}]bVxODTsEa|D# v Z0kYwZd,VxmDZf{Dafm}DvSxvS#"b,\vS ?;G_TD,r*v\Zf*sD;!?Vk}]Vx}I}H# \ LBAC #$D}]0k"bBn *I&0k=xP\#$PDmP,Xk_P LBAC(yZjEDCJXF)>$#T Z10k?jm`X*D2+_T,Xk,1a)P'2+jEr_I*;*P'j ED2+jE# g{;PP'D LBAC >$,0ka'\"5Xms(SQLSTATE 42512)#g{d k}]4|,2+jErC2+jE49CdZ?~xFq=,G4I9CtID~ `M^N{TJmLx0k# + } ] 0 k = _ P \ # $ P D m P 1 , ? jm+ P ; v } ] ` M * DB2SECURITYLABEL DP#g{dk}]P4|,CPD5,G4CPa;\x,} GZ load |nP8(K usedefaults D~`M^N{,K1+9Cz5PD2+_T (CZ#$m)PT&4CJ(D2+jE#g{;PT&4CJ(D2+jE,G 4CP+;\x,"R&maLxxAB;P# g { * + } ] 0 k = x P \ # $ P D m P , " R d k } ] | ( } ] ` M * DB2SECURITYLABEL PD5,G4+}]ek=CmP1q-`,fr#g{CZ# $*0kPD2+jE(}]D~DCPPD2+jE)MGz\;4kD2+j E , G 4 C 2 + j E + CZ# $ C P # ( ; T . , | + 4 k } ] ` M * DB2SECURITYLABEL DP#)g{z^(4k\C2+jE#$DP,G4zzDa {!vZ#$4mD2+_TD4(==: v g{4(C_TD CREATE SECURITY POLICY od|, RESTRICT NOT AUTHO- RIZED WRITE SECURITY LABEL !n,G4+a\xP# v g{ CREATE SECURITY POLICY od4|,C!nr_|, OVERRIDE NOT AUTHORIZED WRITE SECURITY LABEL !n,G4}]D~PT&CPD2+jE+; vT,xz5PDT&4CJ(D2+jE+CZ#$CP#ZKivB,;a" vNNmsr/f#g{;PT&4CJ(D2+jE,G4CP+;\x,"R &maLxxAB;P# (g{"bBn 46 }]F/5CLr8OMN< +}]0k=}]`M* DB2SECURITYLABEL DPP1,1!ivBa+} ]D~PD5S*iIC2+jEDZ?m>D5JVZ}#+G,3)-< }]I\|,;P{,|GI\a; LOAD |nmsXbM*P(g{#g{" zKJb,k9C delprioritychar D~`M^N{T7#V{(g{EHZ P(g{#9C delprioritychar 1,|,ZV{(g{PDNNG#$mD2+_TPDP'2+jE,G4;aekCP,"R a5X/f(SQLSTATE 01H53)# 9I0k}]D~,d2+jEPD5G2+jE{F#*0kK`D~,X k9CD~`M^N{ seclabelname#9C seclabelname 1,}]`M* DB2SECURITYLABEL DyPP5+;S*|,VP2+jE{FDV{.# ?#g{;fZ_Py8>DCZ#$mD2+_T{FD2+jE,G4; a0kP,"Ra5X/f(SQLSTATE 01H53)# \xDP Z0kZd;\xDP+"MA*"D~rl#m(g{Z LOAD |nP8(K CD~rm),b!vZ\xPD-r#IZbvmsx;\xDP+"MA *"D~#%42+_TDP+"MAl#m# ":g{?jm|, XML P,G4;\8(l#m# >} TZyP>},dk}]D~ myfile.del +9C DEL q=#yP>}<+}]0k ={* REPS DmP,CmG9CTBod4(D: create table reps (row_label db2securitylabel, id integer, name char(30)) security policy data_access_policy TZK>},Y(dkD~|,1!q=D2+jE: db2 load from myfile.del of del modified by delprioritychar insert into reps TZK>},Y(dkD~|,2+jEV{.q=D2+jE: db2 load from myfile.del of del modified by seclabelchar insert into reps TZK>},Y(dkD~|,2+jEPD2+jE{F: db2 load from myfile.del of del modified by seclabelname insert into reps }]F/5CLrMN< 47 j6P0k"bBn ^[dk}]Gq_Pj6P5,: v Z%;Vx}]bP,1 CPU_PARALLELISM hC* 1 1,;T"P==&mP#Z KivB,+4UwPZ}]D~N}PDvV3r4~=X8(j6P5# v Z`Vx}]bP,g{j6P;ZV<|PT0fZ%VxzmLr(4,48( `vVxzmLrr anyorder D~`M^N{),G4+4UwPZ}]D~PD vV3r48(j6P5# +m0k=Vx}]bP1,g{CmZ}]bDVx|P_Pj6P"R48( identityoverride ^N{,G4;\8( SAVECOUNT !n#1Vx|PfZj6P" R}ZzIj651,ZAY;v}]bVxOS0kWNXBt/0kYwh*S 0kWN*<1XBt/{v0kYw,bb6E;I\PNN;Bc# ":g{{OBPyPu~,G4;Jm4P load RESTART Yw: v *0kDm;ZVx}]b73P,"R||,AY;vj6P,Cj6P;ZV <|PrIV<|PDzIP}C# v 48( identityoverride ^N{# v '\DO;v0kYw|(0kZ0kWNs'\D}]bVx# &D*"v load TERMINATE r REPLACE Yw# P}V`%EbD=(IC4r/+}]0k=|,j6PDmPDY w : identitymissing"identityignore M identityoverride D~`M^N{# 0k;Pj6PD}] g { d k } ] D ~ 4 | , N N j 6 P 5 ( u A 4 | , NULL 5 ),G 4 identitymissing ^N{IT9z|=cX0k|,j6PDm#}g,}: Robert, 45.2, J Mike, 76.9, K Leo, 23.4, I 0kKD~D;V=(G(} LOAD |nT=P>*0kDP,gBy>: db2 load from load.del of del replace into table1 (c1, c3, c4) +G,TZ|,m`PDm45,Ko(QT9C"R]Wvm#m;V0kKD~ D=(G9C identitymissing D~`M^N{,gBy>: db2 load from load.del of del modified by identitymissing replace into table1 K|n+:49dk}]D~|,j6P}],2& CvTb)}],"R&C*?;PzIj65#}g,C'I\*S|,TB}] D}]D~ (load.del) P+}]0k=H0(eD TABLE1 P: Robert, 1, 45.2, J Mike, 2, 76.9, K Leo, 3, 23.4, I g{C'a)D5 1"2 M 3 4CZj6P,G4IT"vTB LOAD |n: db2 load from load.del of del method P(1, 3, 4) replace into table1 (c1, c3, c4) , y , g { C m | , m ` P , G 4 K =(I \QT 9 C " R ] W v m # identityignore ^N{IT+o(r/*: db2 load from load.del of del modified by identityignore replace into table1 0k_PC'a)D5D}] identityoverride ^N{C4+C'a)D50k=|, GENERATED ALWAYS j 6PDmP#1Sm;}]b53(F}]"RXk+m(e* GENERATED ALWAYS 1,r_Z+9C ROLLFORWARD DATABASE |n DROPPED TABLE RECOVERY ! nV4D}]0k=mP1,K^N{G#PC#19CKK^N{1,+\xNN 4|,j6P}](r_|, NULL }])DP (SQL3116W)#9&C"b,9CK ^N{1,I\a%4 GENERATED ALWAYS PD(;TtT#ZKivB,4P load TERMINATE Yw,;sSE4P load INSERT r REPLACE Yw# zIP0k"bBn ^[dk}]Gq_PzIP5,}: 1, 5, J 2, 6, K 3, 7, I 0kKD~D;V=(G(} LOAD |nT=P>y*0kDP,gBy>: DB2 LOAD FROM load.del of del REPLACE INTO table1 (c1, c2, c3) +G,TZ|,m`PDm45,Ko(QT9C"R]Wvm#m;V0k KD~D=(G9C generatedmissing D~`M^N{,gBy>: DB2 LOAD FROM load.del of del MODIFIED BY generatedmissing REPLACE INTO table1 K|n+:49dk}]D~|,?jmP yPzIPD}],2&CvTb)}],"R&+Fc50k=?vzIP P#}g,g{*S|,TB}]D}]D~ (load.del) P+}]0k=H0 (eD TABLE1 P: 1, 5, 10, 15, J 2, 6, 11, 16, K 3, 7, 12, 17, I g{49CkzIP`XDD~`M^N{,G4C'a)DGU5 10"11 M 12(CZ g1)T0 15"16 M 17(CZ g2)+DM'zk V8 r|_f>D~qwdO9CD"bBn g{Z V7 r|Mf>DM'zk V8 r|_f>D~qw.dt/0kYw,G40 k5CLr+9|,zIPDmCZ“hCj{T]R”4,#g{IZ9CK V7 r| Mf>DM'z+}]0k=|,zIPDmP,Sx9m&Z“hCj{T]R”4 ,,G4"vTBodQkC4,"?FzI5: SET INTEGRITY FOR table-name IMMEDIATE CHECKED FORCE GENERATED; 9C CURSOR D~`M4F/}] (}Z9C LOAD |n18( CURSOR D~`M,IT+ SQL i/a{1S0k= ?jmP,x;X4(Pd: m ABC.TABLE1 P 3 P: v ONE INT v TWO CHAR(10) v THREE DATE m ABC.TABLE2 P 3 P: v ONE VARCHAR v TWO INT v THREE DATE 4PBP CLP |na+ ABC.TABLE1 PDyP}]0k= ABC.TABLE2 P: 52 }]F/5CLr8OMN< DECLARE mycurs CURSOR FOR SELECT TWO, ONE, THREE FROM abc.table1 LOAD FROM mycurs OF cursor INSERT INTO abc.table2 ":TO>}T>KgN(} CLP 4S SQL i/0k#+G,9IT(} db2Load API S SQL i/0k#(e sqlu_media_list a9D piSourceList T9C sqlu_statement_entry a9M SQLU_SQL_STMT iJ`M,"+ piFileType 5(e * SQL_CURSOR# 2. Y(4mk?jm;Z;,D}]bP,"R|GD(egBy>: }]b“dbsource”PDm ABC.TABLE1 P 3 P: v ONE INT v TWO CHAR(10) v THREE DATE }]b“dbtarget”PDm ABC.TABLE2 P 3 P: v ONE VARCHAR v TWO INT v THREE DATE ;*ztCK*O&\"R`?K}]4(“dsdbsource”),MITT4}]bywG F,;sTKGFywNj,"wCxP FROM CURSOR !nD LOAD |n,gT B>}y>: CREATE NICKNAME myschema1.table1 FOR dsdbsource.abc.table1 DECLARE mycurs CURSOR FOR SELECT TWO,ONE,THREE FROM myschema1.table1 LOAD FROM mycurs OF cursor INSERT INTO abc.table2 2IT9C DECLARE CURSOR odD DATABASE !n,gTB>}y>: DECLARE mycurs CURSOR DATABASE dbsource USER dsciaraf USING mypasswd FOR SELECT TWO,ONE,THREE FROM abc.table1 LOAD FROM mycurs OF cursor INSERT INTO abc.table2 9C DECLARE CURSOR odD DATABASE !n(Z9C0k API 1VF*6L CfiJ`M)kGF=(`H_P;)Ec: T\ T9C6LCfiJ`MD}]DCft\/IZ0kYwP#kGF=(` H,CfG<1*;Dc}|Y#Kb,14mk?jmj+`,XV}T>KgN9C DECLARE CURSOR odD DATABASE !n4(} CLP SkTQ`?}]bD SQL i/0k#+G,(}+ db2LoadStruct a9D piSourceList M piFileTypevalues Vp(e*9C sqlu_remotefetch_entry iJu?M SQLU_REMOTEFETCH iJu?,9I(} db2Load API 4SkTQ`?}]b D SQL i/0k# 2. gO;v>}y>,SQL i/D4P`M;h*k|GD?jP`Mj+`,,! \|GXkf]# ^F S9C DATABASE !n(eDNj0k(`1Z+ sqlu_remotefetch_entry iJu?k db2Load API dO9C)1,BP^FJC: 1. ;\,18( SOURCEUSEREXIT !n# 2. ;'V METHOD N !n# 3. ;'V usedefaults D~`M^N{# +%St"4G(m g{*0kDmGxP"4+%tTDG(mDWcm,"RTek==xP0kY w,G4+T]v==sx+%ASt"4G(m# Z]v+%Zd,kWcmPD7SPT&DP+7SAG(m#g{Wcm\sx 7S}]D?\Y,G4]v+%aHOl#g{9CG(m4"BdStSY_e /i/m,G42ITDxT\#2fZ;Jm]v+%Div,K1G(m+;j G*;j{#4,CONST_CHECKED PDG(VZ+_P5 F#ZK4,B,;\9 CG(m4"BdStSY_e/i/m,"R_e/i/m,$}Lh*j+" B# g{m&Z;j{4,"R8(K INCREMENTAL !n,+;\TmxP]v+%,G4 a5Xms#g{"zBPN;iv,53+XU1S}]+%"+m4,hC*; j{: v ZONTG(mDWcm4Pj{Tli.s,QZCWcmP4P0kf;Y w,r_Q$n NOT LOGGED INITIALLY WITH EMPTY TABLE !n# v G(mDSt_e/i/mr_G(mQ9C REPLACE r INSERT ==0k# v Zj{TliZd9C FULL ACCESS !n+%G(m.0,WcmQQk“hCj{ T]R”4,# v Q-TG]v==liKG(mDWcmDj{T# v |,G(mrdWcmDmUdQ0vA3v1dc,"RCG(m0dWcm; Z;,DmUdP# g{G(mZ SYSCAT.TABLES ?53"4i$yP}]# TB>}5wZG(m G1 0dStSY_e/i/m AST1 DWcm UT1 PxPD 0kekYw#ZK=8P,+T]v==li UT1 Dj{TT0"B AST1: 54 }]F/5CLr8OMN< LOAD FROM IMTFILE1.IXF of IXF INSERT INTO UT1; LOAD FROM IMTFILE2.IXF of IXF INSERT INTO UT1; SET INTEGRITY FOR UT1,G1 IMMEDIATE CHECKED; REFRESH TABLE AST1 INCREMENTAL; "BSt"4_e/i/m g{9C INSERT !n0k"4"B_e/i/mDWcm,"T9C REFRESH IMME- DIATE (eDSt_e/i/m4P SET INTEGRITY od,G4a53"4i$yP}]# TB>}5wZ_e/i/m AST1 DWcm UTI PxPD0kekYw#+li UT1 D}]j{T,"Ra+ UT1 CZ^}]F/==#;) AST1 D]v"Bj I,UT1 M+X4j+CJ4,#ZK=8P,+T]v==li UT1 Dj{TT0 "B AST1# LOAD FROM IMTFILE1.IXF of IXF INSERT INTO UT1; LOAD FROM IMTFILE2.IXF of IXF INSERT INTO UT1; SET INTEGRITY FOR UT1 IMMEDIATE CHECKED; REFRESH TABLE AST1; MDC M ITC "bBn +}]0k=`,/: (MDC) Mek1d/: (ITC) mP1,fZTB^F: v ;'V LOAD |nD SAVECOUNT !n# v IZb)m\m|GT:DICUd,yT;'V totalfreespace D~`M^N{# v MDC mr ITC mh* anyorder D~`M^N{#g{T MDC mr ITC m4 P0k,+48( anyorder ^N{,G45CLr+T=tCC^N{# T MDC r ITC m9C LOAD |n1,+4TB==&m(;}WN>}BG<# v g{Z4P0kYw0Cm4|,(;|,"R+(;|MX4G<<0kCm, G4+;0kdP;vxP(;|DG<,"R+Z>}WN>}d{G<# ":;P7PD}DG<# T\"bBn *a_ LOAD 5CLrZ0k_P`v,D MDC m1DT\,&Cvs util_heap_sz }]bdCN}5#1P|`ZfI)C5CLr9C1,MDC 0kc(DT\aT xa_#b+uYZ0kWN4P}]/:1DEL I/O N}#T V9.5 p,153P fZ|`ICZf1,LOAD |nD DATA BUFFER !nD5ITY1T,v util_heap_sz hC5#. IZyP MDC M ITC mG<#*K7#T\ rI4PD~(K&F*C'vZ)# C'vZ9C0k5CLr}ZA!D}]nd;vr`v|{\@#Z`Vx}] bP,I"PwCC'vZD`v5}T5Vdk}]D"PT# gZ 57 3D< 5 y>,0k5CLr4(;vr`v|{\@"\z;vxLT4P (FDI4PD~#Z0k5CLrA!}]D,1,C'vZ+}]nd=|{\ @P# 56 }]F/5CLr8OMN< nd=\@PD}]Xk438(D0k!n,|(D~`MMNND~`M^N {#0k5CLr;a1SA!8(D}]D~#Z4PC'vZ1,8(D}]D ~+w*Td?+]AC'vZ# wCC'vZ C'vZXkZ DB2 20? ... dP: < base pipename > G0k5CLr4(D|{\@Dy>{F,0k5CLr+Sbv|{\@ A!}]#0k5CLr*a)x LOAD |nD?v4D~4(;v\@,? v\@<7S .xxx w*a2,dP xxx Ga)D4D~Dw}#}g,g{ r LOAD |na)K 2 v4D~,"R+]AC'vZD Td?* pipe123,G4C'vZ&*dnd}]D=v|{\@* pipe123.000 M pipe123.001#ZVx}]b73P,0k5CLr+}]bV x (DBPARTITION) E .yyy 7SAy>\@{,SxzI\@{ pipe123.xxx.yyy# GzZsfDiJN}}?#   0 *+- ./0 9+:; <= < 5. 0k5CLrS\@A!+kD}]"TdxP&m# }]F/5CLrMN< 57 ... G LOAD |nP8(D;vr`v4D~DPm#?v4D~ G;vXb5,1tCK PARALLELIZE !n1,K5G#PC#K{}5(S 1 = N,dP N G\zDC'vZ\})j6}ZKPDC'vZDX(5 }#4tC PARALLELIZE !n1,K51!* 1# G;vXb5,1tCK PARALLELIZE !n1,K5G#PC#K5m>10 }ZKPDC'vZ\}#4tC PARALLELIZE !n1,K51!* 1# G;vXb5,1tCK PARALLELIZE !n1,K5G#PC#bG4PC' vZD}]bVx (DBPARTITION) E#4tC PARALLELIZE !n1,K51 !* 0# =S!nM&\ BZhvd{ SOURCEUSEREXIT $_!n: REDIRECT K!nJmz+}]+]A STDIN dz,r_SC'vZxLD STDOUT M STDERR dz6q}]# INPUT FROM BUFFER < buffer > Jm+E"1S+]AC'vZD STDIN dkw#Z\z4PC'vZDxL s,0k5CLr+q!bvBxLD STDIN D~hv{"(}a)D:ex +]#CC'vZA! STDIN Tq!CE"#0k5CLrv9C STDIN + DZ]"MAC'vZ,";abMr^DdZ]#}g,g{+C' vZhFIS STDIN A!=v5(;vKVZC'j6M;vKVZ\k), G49C C `4DC'vZI4PD~I\|,BPzkP: rc = read (stdin, pUserID, 8); rc = read (stdin, pPasswd, 8); C'IT9C INPUT FROM BUFFER !n4+]KE",gTB LOAD |ny >: LOAD FROM myfile1 OF DEL INSERT INTO table1 SOURCEUSEREXIT myuserexit1 REDIRECT INPUT FROM BUFFER myuseridmypasswd ":0k5CLr+ Ds!^F* LOB 5Dnss!#+Z|nP &mw (CLP) P, Ds!;^F* CLP odDnss!#Z CLP P,9(i v|,+3 ASCII V{#g{9C db2Load API wC0 k5CLr,r_9C INPUT FROM FILE !n,MIT\bb)Jb# INPUT FROM FILE < filename> Jm+M'KD~DZ]1S+]AC'vZD STDIN dkw#K!nk INPUT FROM BUFFER !n8uj+`,,+K!nI\b1Z CLP ^F#D~ {XkGj Jm+C'vZxLPD STDOUT M STDERR w6q=~qwKD~P#Z \z4PC'vZI4PD~DxLs,0k5CLr+ STDOUT M STDERR 58 }]F/5CLr8OMN< dzSbvBxLX(rA8(DD~{#K!nZwTMG" M Td?Vp43(;j6(S 1 = N)"C'vZ\} (N) T0KPC'v Z5}D}]bVx (DBPARTITION) E#z&C7#?vC'vZxL4A|{\@ DNN}]<;kd{"PxLX4#d;C'vZ&CLrITPm`=(4jI bnNq,+b)5T7#}];X4\Poz#}g,g{?v}]G<|,(; {}P5,G4C'vZ&CLrI9C M 5 T7#?vC'vZ5}+(;a{/5XAd|{\@#C'vZ&CLrI\4 gB==9C MODULUS tT: i = N = foreach record { if ((unique-integer MOD N) == i) { write this record to my named-pipe } } \zDC'vZxL}!vZT}]bVx8(DV<==: 1. gZ 60 3D< 6 y>,18(4x PARALLEL D PARTITION_AND_LOAD(1!5) r PARTITION_ONLY 1,+T?v$VxzmLr\z;vC'vZxL#. }]F/5CLrMN< 59 2. gZ 61 3D< 7 y>,18(xP PARALLEL D PARTITION_AND_LOAD(1!5) r PARTITION_ONLY 1,+T?vVxzmLr\z;vC'vZxL# >?@CG HI 0 @CG HI 1 2 @CG HI 3 @CG HI 4 @CG HI KLQ *+- ./0 THU HU HU 9+:; <= < 6. 8(4x PARALLEL D PARTITION_AND_LOAD(1!5)r PARTITION_ONLY 14PDwVNq# 60 }]F/5CLr8OMN< 3. gZ 62 3D< 8 y>,18( LOAD_ONLY r LOAD_ONLY_VERIFY_PART 1,+T? v0kzmLr\z;vC'vZxL# >?@CG HI 0 @CG HI 1 2 @CG HI 3 @CG HI 4 @CG HI KLQ *+- ./0 HU HU 9+:; 9+:; <= <= < 7. 8(xP PARALLEL D PARTITION_AND_LOAD(1!5)r PARTITION_ONLY 14PDwVNq# }]F/5CLrMN< 61 ^F v g{48( SOURCEUSEREXIT PARALLELIZE !n,G4;'V LOAD_ONLY M LOAD_ONLY_VERIFY_PART partitioned-db-cfg ==!n# >} >} 1:“0kC'vZ”E>,IS4iJD~D?vGwC0k5CLr,k9CkTB|n`FD |n: DB2 LOAD FROM /path/file1 OF DEL INSERT INTO schema1.table1 SOURCEUSEREXIT example1.pl REDIRECT OUTPUT TO FILE /path/ue_msgs.txt k"b,Xk+C'vZE>ECZ sqllib/bin/ D~PP,"h*4PmI(# example1.pl: Q Q >?@CG HI 0 @CG HI 1 @CG HI 2 @CG HI 3 @CG HI 4 Q Q KLQ *+- ./0 9+:; 9+:; 9+:; 9+:; <= <= <= <= < 8. 8( LOAD_ONLY r LOAD_ONLY_VERIFY_PART 14PDwVNq# 62 }]F/5CLr8OMN< #!/bin/perl # Filename: example1.pl # # This script is a simple example of a userexit for the Load utility # SOURCEUSEREXIT feature. This script will replace all tab characters ’\t’ # with comma characters ’,’ from every record of the source media file. # # To invoke the Load utility using this userexit, use a command similar to: # # db2 LOAD FROM /path/file1 OF DEL INSERT INTO schema1.table1 # SOURCEUSEREXIT example1.pl REDIRECT OUTPUT TO FILE /path/ue_msgs.txt # # The userexit must be placed into the sqllib/bin/ folder, and requires # execute permissions. #-------------------------------------------------------------------- if ($#ARGV < 5) { print "Invalid number of arguments:\n@ARGV\n"; print "Load utility should invoke userexit with 5 arguments (or more):\n"; print " "; print " ... "; print " "; print " \n"; die; } # Open the output fifo file (the Load utility is reading from this pipe) #----------------------------------------------------------------------- $basePipeName = $ARGV[0]; $outputPipeName = sprintf("%s.000", $basePipeName); open(PIPETOLOAD, ’>’, $outputPipeName) || die "Could not open $outputPipeName"; # Get number of Media Files #-------------------------- $NumMediaFiles = $ARGV[1]; # Open each media file, read the contents, replace ’\t’ with ’,’, send to Load #----------------------------------------------------------------------------- for ($i=0; $i<$NumMediaFiles; $i++) { # Open the media file #-------------------- $mediaFileName = $ARGV[2+$i]; open(MEDIAFILETOREAD, ’<’, $mediaFileName) || die "Could not open $mediaFileName"; # Read each record of data #------------------------ while ( $line = ) { # Replace ’\t’ characters with ’,’ #--------------------------------- $line =~ s/\t/,/g; # send this record to Load for processing #----------------------------------------- print PIPETOLOAD $line; } # Close the media file #--------------------- close MEDIAFILETOREAD; } # Close the fifo }]F/5CLrMN< 63 #--------------- close PIPETOLOAD; exit 0; 9C LIST UTILITIES |n4`S0kYw I9C LIST UTILITIES |n4`S}]bOD0kYwDxH# }L *9C LIST UTILITIES |n,k4PTBYw: "v LIST UTILITIES |n"8( SHOW DETAIL N}: list utilities show detail >} TB>}G9C LIST UTILITIES |n`S0kYwT\yqCDdv: ID = 10 Type = LOAD Database Name = TEST Member Number = 1 Description = OFFLINE LOAD DEL AUTOMATIC INDEXING REPLACE COPY NO BEER .TABLE1 Start Time = 08/16/2011 08:52:53.861841 State = Executing Invocation Type = User Progress Monitoring: Phase Number = 1 Description = SETUP Total Work = 0 bytes Completed Work = 0 bytes Start Time = 08/16/2011 08:52:53.861865 Phase Number [Current] = 2 Description = LOAD Total Work = 49900 rows Completed Work = 25313 rows Start Time = 08/16/2011 08:52:54.277687 Phase Number = 3 Description = BUILD Total Work = 2 indexes Completed Work = 0 indexes Start Time = Not Started d{0k"bBn "PTM0k LOAD 5CLr{C9C`v&mwr`vf"h8D2~dC,gTF`&mw (SMP) 73# (}9C LOAD 5CLr,P`V=(IC4"P&ms?}]#;V=(G(}9 C`vf"h8,bJmZ0kYwZd{C I/O "PT(kNDZ 65 3D< 9)#m ;V=(f0Z SMP 73P9C`v&mw,bJm{CVxZ"PT(kNDZ 65 3D< 10)#=V=(I;p9CTa_}]0kYH# 64 }]F/5CLr8OMN< Z0kYwZd4(w} +Z0kYwD9(WN9(w}#IZ LOAD |nP8(DV("w}==: 1. REBUILD#+X(yPw}# 2. INCREMENTAL#9CB}])9w}# 3. AUTOSELECT#0k5CLrT/v(G9C REBUILD 9G INCREMENTAL ==# AUTOSELECT G1!5#g{}Z4P LOAD REPLACE Yw,G4+9C REBUILD w }("==#qr,y]mPDVP}]?kB|0kD}]?DHJ4!q(" w}==#g{HJG#s,G4!q INCREMENTAL ("w}==#qr,!q REBUILD ("w}==# 4. DEFERRED#g{8(K==,G40k5CLr;a"T4(w}#w}+jG* h*"B,"RI\aZZ;NCJw}1?FX(#ZBPNN;VivB,; Jm9C DEFERRED !n: v 8(K ALLOW READ ACCESS !n(|;a,$w}"Rw}(hLrh*P'w }) v kTm(eKNN(;w} v }Z0k XML }](XML 76w}G(;D,"R1!ivB,;*ZmPm S XML P,Ma4(Cw}) VW VW VW I/O [Q I/O [Q I/O [Q < 9. Z0k}]1{C I/O "PT \]、`b f、 jq、v \]、`b f、 jq、v w@C（DEL、ASC、IXF、CURSOR） @CG \]、`b f、 jq、v \]、`b f、 jq、v < 10. Z0k}]1{CVxZ"PT }]F/5CLrMN< 65 Z!vZy!("w}==D`MDUd9CivMG<=f,8( ALLOW READ ACCESS !nD0kYwh*Xp"b#8(K ALLOW READ ACCESS !n1,0k5CLr+9 w}ICZi/,49}ZX(w}2GgK# 1&Z ALLOW READ ACCESS ==D0kYw8( INDEXING MODE INCREMENTAL !n1, LOAD 5CLr+4k3)U>GG<}?Ge k|D}?D;?V,"RK}?H`F SQL ekYwh*D}?*YC`#&Z ALLOW NO ACCESS =="R8(K INDEXING MODE INCREMENTAL !nD0kYwv4 k}#UdVdU>.bD!MU>G<# ":;PZ48( COPY YES "R logindexrebuild dCN}hC* ON 1,Eav VOviv# 1&Z ALLOW READ ACCESS ==D0kYw8( INDEXING MODE REBUILD !n1,B w}+Z-D;vG-}WN.sxP#Zw}4FWN*<.0,mT@ <==x(#4,Z{vw}4FWN|;\CZACJ#r*w}4FWN Gom4F,yTCmI\P\$;N1d;IC# ":g{53Y1mUdrw}mUdDdPN;mUdG DMS mUd,G 4S53Y1mUdA!I\,(#C}v=h49(m:0k} ]"9(w}MU/3FE"#baDP*# *G XML }]9(m6pVd1,0k5CLr9C?jmPfZD}]49(Vd (Y(K$HfZD}]G+f"ZCmPD}]`MDzm)#g{?jmP$H fZD}];;,G4;)0k5CLrTc;Ddk}]xPKIy,|Ma9( Vd#ZKivB,0k5CLrv9Cdk}]49(Vd# TZ XML }],0k5CLrvTdk}]xPIy# *6'Vxm4(Vd1,?vVx;S*;vm#;aPNNgVxVd,"R; aZ|,VdDVxO4(Vd#TZm}],*?vVxzIDVdvyZCVx P$HfZDm}](Zh*19yZQ0k}])#Z V9.7 FP1 0|_f>P,g {VxP$HfZD}]YZn!P5,G4vay]Q0kD}]zIVd#TZ XML }],*?vVxzIDVdyZ0k=CVxPD}]# 9C KEEPDICTIONARY !nD LOAD REPLACE ;*?jmtCK COMPRESS tT,G49C KEEPDICTIONARY !nD LOAD REPLACE Ma#tVPVd"9C|G49uQ0k}]#g{Vd;fZ,G 40k5CLr+*QtC COMPRESS tTDmzIBVd(Y(0k=m PD}],}1! XML f"TsPf"DmP}r XML D5}D$(P 5)#r*?jmPD}];f;,yT0k5CLrv9Cdk}]49( Vd#Z4(Vd.s,|a;ek=CmP"R0kYwLx# 9C RESETDICTIONARY !nD LOAD REPLACE 68 }]F/5CLr8OMN< 0k=r*K COMPRESS tTDmP1,9C RESETDICTIONARY !nP=V w*D,e#WH,Z LOAD REPLACE jIs,;*?jmPfZNb}?D} ],MaxPVd4(#2MG5,BD9uVdIyZ%v}]Pr%v XML D5#m;V,eG,g{vVBPNNiv,G4+>}VPVdx; GT|GxPf;(?jm+;Y_P9uVd): v TXUK COMPRESS tTDm4PCYw v 40kNNZ](cP),ZKivB ADM5591W +r!=(*U> ":g{Z4P9C RESETDICTIONARY !nD LOAD REPLACE .s"v LOAD TERMINATE Yw,G4+a>}NNVP9uVd,x;GTdxPf;# T\0l Vd4(aZTB=v=f0l0kYwDT\: v TZ LOAD INSERT Yw,Z9(m6p9uVd.0+(hyP$HfZDm}], x;vvG(h4(VdyhnMP5D}]?#rK,fEms!Dvs,xP bV(hyCD1d2vS# v 9(9uVd1h*d{&m,!\CZ9(VdD1dGnMhs# k9(Vd`XD3)YwI\a0l LOAD |n9CD CPU ?,0kYw(#k I/O s(#4,H}0kjI1{DDs?V1d(QZH}+}]4AEL=f#4( Vd#v1tCK}r V41,COPY YES EJC,"RIZ0kYwZda4FyP0k}],yT 9CKN}a5M0kT\#I/O n/vSI\a}Cm# SAVECOUNT 9CKN}4hCZ0kYwD0kWNZd(";BcD1ddt#*(" ;Bcx4Pn/,=h*(;)1d#g{xPC+51,0kT\asy B5#g{*0ks?P,G4(iz8(OsD SAVECOUNT 5(}g,Zf 0 1 ZuGmDT\B5 (XpGZ8( DETAILED INDEXES ALL 1),kZjI0kYwswC RUNSTATS 5CLr`H,9CKN}4U/}]V g{}Z4P ALLOW READ ACCESS 0k"R("w}==* REBUILD,G4K N}JmZ53Y1mUdPX(w},"Z0kYwDw}4FWN+d4 FXw}mUd# 1!ivB,+Z-0k5CLr;#t 3r,IZbyv;X4P#tC3ryhD,=,yT+aa_T\#+ G,g{*0kD}]xPK$HEr,G4 anyorder I\aF5$HECD 3r,9Csxi/2^(\fZ$HEr# ":g{ CPU_PARALLELISM * 1,G4 anyorder D~`M^N{;pwC, "R|k SAVECOUNT !n;f]# BINARYNUMERICS"ZONEDDECIMAL M PACKEDDECIMAL TZL($HDG(g ASCII (ASC) 4}],C~xFm>}V}]I\aa _0k1DT\#g{8(K packeddecimal D~`M^N{,G40k5C Lra9C9u.xFq=(?vVZ<=;)m>.xF}]#g{8(K zoneddecimal D~`M^N{,G40k5CLra9CVx.xFq=(? vVZ<;;)m>.xF}]#TZyPd{}V`M,g{8(K binarynumerics D~`M^N{,G40k5CLra9C~xFq=m>} ]# ": v Z8(K binarynumerics"packeddecimal r zoneddecimal D~`M^N {1,^[9C24=(,<9Cs2}((_VZZ0f)q=m>}V }]# v packeddecimal M zoneddecimal D~`M^N{%b# v packeddecimal M zoneddecimal D~`M^N{vJCZ.xF?jP, "R~xF}]Xkk?jP(e%d# v Z8(K binarynumerics"packeddecimal r zoneddecimal D~`M^N {1,Xk8( reclen D~`M^N{# FASTPARSE 9C1qX!Dww#g{*@*0kD}]P',G4;X*C0kqTO IID}]Gy4PG4`Do(li#B5O,u!o(liD6'IT+ 0kT\a_s< 10% r 20%#bIT(}9C fastparse D~`M^N{ 45V,C^N{ITuYT ASC M DEL D~PC'a)DP54PD}] li# NOROWWARNINGS Z0kYwZd,XZQ\xDPD/f{"+4k8(DD~P#+G,g {0k5CLrXk&ms?Q\xD"^'rQXODG<,G4I\aT 0kT\zz:f0l#g{$F=azzm`/f,G49C norowwarnings D~`M^N{4VFG}^'}]P Z4P0kYwslij{T%} 0kYwjIs,g{BPNN;vu~I",0kDmMa&Z READ r NO ACCESS ==BDhCj{T]R4,: v TCm(eKmliDM'z# v CmP}CCmDIz"4_e/i/mrIz"4G(m# v CmGG(mr_e/i/m# k0kDmT&D SYSCAT.TABLES u?D STATUS j>8>KCmDhCj{T]R4 ,#*C0kDmj+IC,STATUS 5Xk* N,ACCESS MODE 5Xk* F,bm>C mj+ICJ"&Z}#4,# g{0kDmxPIzm,G4IT8( SET INTEGRITY PENDING CASCADE N }T8>Gq&C"4+0kDmDhCj{T]R4,6*=Izm# g{0kDmxPP,IT9CTB$_DNqzV:hCj{T. NqzVIT853 "4i$yP}]# SET INTEGRITY od;aIZ>}%4} INSERT %"w,Sl#mPekP,;sX B4( INSERT %"w# Z0kYwZdxPmx( Zs`}ivB,0k5CLr9Cm6px(&\4^FTmDCJ#x(6p! vZ0kYwy&DWNT0GqQ+0kYw8(*JmACJ# ALLOW NO ACCESS ==D0kYwZ0kZdTm9C,6%bx((Z x()# Z ALLOW READ ACCESS ==D0kYw*<.0,0k5CLr+H}yPZC0kY w0*Zhv ALLOW READ ACCESS !n# Z0kYw4P}LP,Z0kYwt/0fZDm}]Mw}}]Ti/IS#k }: 1. 4(|,;v{}PDm: create table ED (ed int) 2. 0k}P: load from File1 of del insert into ED ... A!DP} =3 x}DP} =0 0kDP} =3 \xDP} =0 >}DP} =0 Qd5DP} =3 3. i/Cm: select * from ED ED ----------- 1 2 3 3 record(s) selected. 4. Z8(K ALLOW READ ACCESS !nDivB4P0kYw"0kmb=P}]: load from File2 of del insert into ED allow read access 5. ,1,9Cm;v,S,Z0kYw4P}LPi/Cm: select * from ED ED ----------- 1 2 3 3 record(s) selected. 6. H}0kYwjI,;si/Cm: select * from ED ED ----------- 1 76 }]F/5CLr8OMN< 2 3 4 5 5 record(s) selected. IZ ALLOW READ ACCESS !nJmC'ZNN1d(uAZ0kYw4P1r_Z0k Yw'\s)CJm}],yT,0ks?}]1,K!nG#PC#Z ALLOW READ ACCESS ==B,0kYwDP*@"Z&CLrDtk6p#4,_PNNtk6pD DAw !n,M aZ{vw}4FWN: }# “}#”4,G4(mUdsCmUdDu<4,,|8>10;P(l#)4 ,0lmUd# }Z0k “}Z0k”4,8>}ZmUdOxP0k#K4,;JmZ0kYwZd8 ]Stm#“}Z0k”mUd4,k“}Z0k”m4,(yP0kYwP<9 CK4,);,,r*v1TIV4}]b8(K COPY NO N}1,0k5C LrE9mUd&Z“}Z0k”4,#mUdZ0kYwVxZd+#V&Z K4,# 8]]R g{TIV4}]b4P0kYw"R8( COPY NO N},G4ZZ;Nd5 smUd+&Z“8]]R”mUd4,#;\|B&Z“8]]R”4,DmU d#(}8]mUd4I9mUdQk“8]]R”4,#IZ0kYw*<1 a|DmUd4,"R;\Xv,yT49!{0kYw,mUd2#V&Z “8]]R”4,# 4-]R g{9C COPY NO !nI&4PK0kYw"4-}]b,;s0vCYw, G4X*mUd+&Z“4-]R”4,#*9mUdQk“4-]R”4,,X k4P4-Yw# ":DB2 LOAD ;a+mUd4,hC*0k]Rr>}]R# 78 }]F/5CLr8OMN< mUd4,D>} g{+dkD~(staffdata.del)0k= NEWSTAFF mP,gBy>: update db cfg for sample using logarchmeth1 logretain; backup db sample; connect to sample; create table newstaff like staff; load from staffdata.del of del insert into newstaff copy no; connect reset; "Rr*m;va0""vBP|n: connect to sample; list tablespaces; connect reset; G4 USERSPACE1(y>}]bD1!mUd)+&Z“}Z0k”4,,"RZZ;N d5s,+&Z“8]]R”4,#Z0kYwjIs,LIST TABLESPACES |nmw USERSPACE1 VZ&Z“8]]R”4,: mUdj6 =2 {F = USERSPACE1 `M = }]b\mDUd Z] = yP@C}]#sMmUd# 4, = 0x0020 j85w: 8]]R 0kYwZdM.sDm4, Z0kYwZd,0k5CLr9Cm4,4#V}]b;BT#b)4,(}XF T}]DCJr}"C'Yw4pwC# *7(m4,,"v LOAD QUERY |n,C|n9li0kYwD4,#mIT,1& Z`V4,#LOAD QUERY |n5XD4,gBy>: }#4, “}#”4,G4(msCmDu<4,,|8>10;P(l#)4,0l m# ;ACJ g{8(K ALLOW READ ACCESS !n,G4m+&Z“;ACJ”4,#ZwC LOAD |n0fZDm}]Z0kYwKPZdI);ACJ#g{8(K ALLOW READ ACCESS !n"R0kYw'\,G4Z0kYw0fZDm}]Z JO"zs+LxI);ACJ# }Z0k “}Z0k”m4,8>}ZmOxP0k#Z0kYwI&jIs,0k5C Lr+}%K214,#+G,g{0kYw'\r;PO,G4m4,+| D*“0k]R”# }ZXBV" “}ZXBV"”m4,8>}ZmOxPXBV"#Z Redistribute 5CLrI &&mjm.s,C5CLr+}%K214,#+G,g{XBV"Yw' \r;PO,G4m4,+|D*“XBV"]R”# 0k]R “0k]R”m4,8>0kYw'\r;PO#IT4PBPdP;v=h4 }%“0k]R”4,: }]F/5CLrMN< 79 v RvJO-r#}g,g{0k5CLrD!KELUd,G4TmUdm S]w#;s,XBt/0kYw# v U90kYw# v T0kYw'\1y&mDGvmKP load REPLACE Yw# v 9CnBDmUdr}]b8],(} RESTORE DATABASE |nV4y0k DmDmUd,;s4Px;=DV4Yw# XBV"]R “XBV"]R”m4,8>XBV"Yw'\r;PO#IT4P REDISTRIB- UTE CONTINUE r REDISTRIBUTE ABORT Yw4}%“XBV"]R”4,# ;IXBt/0k &Z“;IXBt/0k”4,1,mQ?V0k,"R;Jm0kXBt/Y w#ZBf=VivB,ma&Z“;IXBt/0k”4,: v Z4\I&XXBt/rU9D'\0kYws,4P0vYw v y]m&Z“}Z0k”r“0k]R”4,14(D*z8]4P4-Yw m9+&Z“0k]R”4,#*9mQk“;IXBt/0k”4,,"v LOAD TERMINATE r LOAD REPLACE |n# hCj{T]R “hCj{T]R”4,8>Q0kDmP4-i$Dm109C 1 `w}#S V9.7 *<,1 `w};Y\' V#Z}6= V10 .0,z&+b) 1 `w}*;* 2 `w}#qr,WN CJm1,aT/+ 1 `w}X(* 2 `w}# PXZ}6}]b.0gN*; 1 `w}Dj8E",kND“+ 1 `w}* ;* 2 `w}”wb# ;IC T;IV4D0kYw4P0v+9m&Z“;IC”4,#&ZK4,1,m ;IC;Xk>}Cmr(}8]4-m# &Z`V4,DmD>} g{+|,s?}]DdkD~(staffdata.del)0k= NEWSTAFF mP,gBy >: connect to sample; create table newstaff like staff; load from staffdata.del of del insert into newstaff allow read access; connect reset; "Rr*m;va0""vBP|n: connect to sample; load query table newstaff; connect reset; LOAD QUERY |n+T> NEWSTAFF m&Z“;ACJ”M“}Z0k”4,: m4,: }Z0k ;ACJ 80 }]F/5CLr8OMN< 0kl#m 0kl#mGZ0kYwZd%4K(;w}fr"6'^FM2+_TDyPPD iO(f#IT(}9C LOAD |nD FOR EXCEPTION Sd48(0kl#m# ^F:l#m;\|,j6PrNNd{`MDzIP#g{wm|,j6P,G4 l#mP`&DP;\|,CPD`M"$HMIUTtT#Kb,l#m;\GV xm,2;\xP(;w}#mb,g{vVBPiv,G4;\8(l#m: v ?jm9C LBAC 2+T"RAY_P;v XML P# v ?jm*6'Vxm"RAY_P;v XML P# 0k5CLr9CDl#mk SET INTEGRITY od9CDl#mj+`,#|GC' 4(Dm,43}Z0kDmD(e,"|,;)=SDP# ITT}Z0kDmyZDmUd8(0kl#m,2ITTm;vmUd8(C m#Zb=VivB,<&CT,;v}]bVxi8(0kl#mM}Z0kD m,"7#b=vm9C`,DV<|#Kb,k7#l#mM}Z0kDm_P` ,DVx3dj6 (SYSIBM.SYSTABLES.PMAP_ID),CVx3dj6ZXBV"Yw (mS/>}}]bVxYw)ZdI\;,# N19Cl#m 10kD}]|,(;w}"RI\_PX4G<1,k9Cl#m#g{48(l #m,+4R=X4DG<,G40kYw+Lx4P,"Rv"vXZQ>}DX 4GG<# 0kYwjIs,IT9Cl#mPDE"4|}"zmsD}]#;s,IT+| }}D}]ek=mP# P+;7S=l#mPVPE"sf#IZ4xPli,;\7#m*U,yT;+ BE"mS=H00kYw5XD^'PP#g{;h*100kYw5XD^' P,G4ITZwC0k5CLr.0}%VPP#Kb,Z(e0kYw1,IT 8(Cl#mG<"V%}D1dT0y%4G}B~,yTg{Ps?G<%4(;Tu~,G4Z0kD >}WNI\amzU># TZZ9(w}0IZ}]^'x\xDNNP45,;a+|Gek=l#mP# 0k'\r;j{ XBt/POD0kYw g{Z0kYwZdvVJOrPO,G4IT9C0k5CLrU9CYw"XB 0kmrXBt/0kYw# g{0k5CLrr*C'ms(}g,}]D~;fZrP{^')x;\t/, G4Yw+U9"C?jm&Z}#4,# 0kYw*<1,?jm+&Z“}Z0k”4,#vVJO1,m4,+|D*“0k ]R”#*9mQkC4,,IT"v LOAD TERMINATE TXvYw""v LOAD REPLACE TXB0k{vm,r_"v LOAD RESTART# }]F/5CLrMN< 81 (#,ZKivB,nCXBt/0kYw#IZ0k5CLrS0kYwnsI& =oD;Cx;GSCYwD*7XBt/0kYw,yTbyvITZ!1d#Y wXBt/D<7;C!vZZ-<|nP8(DN}#g{8(K SAVECOUNT !n, "RO;v0kYwZ0kWN'\,G40kYw+Z|=oDns;v;BcX Bt/#qr,0kYwZI&=oDns;vWN(0k"9(r>}WN)*< 1XBt/# g{*0k XML D5,G4CP*TP;,#r*Z0k XML }]1;'V SAVECOUNT !n,yTZ0kWNZd'\D0kYw+*SYwDp<&XBt/# }gd{}]`M;y,g{Z9(WNZd0k'\,G4+Z REBUILD ==B9 (w},rKa(hCmTcS?;Pq!yPw}|;+G,2Xk(h?v XML D5Tq!w}|#(h XML D5TiRw}|Db;}L*sT|GXBxPo( Vv,bGI>_:DYw#xR,ngxrM76w}.`DZ? XML w}h*H X9,b2*s(h XDA Ts# bv}r^D0k5CLr4(DNNY1D~# g{BP|nzzD0kYw'\, LOAD FROM file_name OF file_type SAVECOUNT n MESSAGES message_file load_method INTO target_tablename zIT(}+8(D0k=( (load_method) f;* RESTART =(4XBt/CYw: LOAD FROM file_name OF file_type SAVECOUNT n MESSAGES message_file RESTART INTO target_tablename ;\XBt/D'\0k g{'\rPOD0kYwP9CDm&Z“;IXBt/0k”4,,G4;\XB t/CYw#r*BP-r,m+&ZC4,: v Z4I&XXBt/rU9D'\0kYws4P0vYw v y]m&Z“}Z0k”r“0k]R”4,14(D*z8]4P4-Yw &C"v LOAD TERMINATE r LOAD REPLACE |n# XBt/rU9 ALLOW READ ACCESS 0kYw 9IT9C ALLOW READ ACCESS N}XBt/rU98(K ALLOW READ ACCESS N} DQPOrQ!{D0kYw#9C ALLOW READ ACCESS N}Jmd{&CLrZ4P U9rXBt/Yw1i/m}]#TZ ALLOW READ ACCESS ==D0kYw,Zd5 }].0,CmT@<==x(# 82 }]F/5CLr8OMN< XZKNq g{w}Ts;ICrjG*^',G4;Jm ALLOW READ ACCESS ==D0kXBt /rU9Yw# g{-<0kYwZw}4FWN;POr!{,G4r*w}I\Qp5x;Jm ALLOW READ ACCESS ==DXBt/Yw# g{ ALLOW READ ACCESS ==D0kYwZ0kWN;POr!{,G4|+Z0kW NXBt/#g{|Z0kWNTbDNNWN;POr!{,G4|+Z9(WN XBt/#g{-<0kYw&Z ALLOW NO ACCESS ==,G41-<0kYw=oC c"Rw}P'1,+Z>}WN"zXBt/Yw#g{w}jG*^',G40 k5CLr+S9(WNXBt/0kYw# ":498(K INDEXING MODE INCREMENTAL N},yP0kXBt/Yw2a!q REBUILD ("w}==# "v LOAD TERMINATE |n(#a;CD~4V4}] DB2LOADREC "amd?C4j6|,0k1>;CE"DD~#Z0vV4YwZd, +9CKD~4R=0k1># DB2LOADREC _PBPw=fDE": v iJ`M v *9CDiJh8} v m0kYwZdzID0k1>D;C v 0k1>DD~{(g{JC) g{C;CD~;fZ,r_ZCD~PR;=%dDu?,G4+9CU>G

D~,"RD~ {(|(76)Xk`,# 3. g{ DB2LOADREC "amd?j6DD~|,^'Du?,G4+9CID0k1> ;CD~4a)E"Tf;^'u?# ;CD~a)KTBE"#0 5 vN}5XkP',|GC4j60k1>#yG;CD~4a)G) 5# 5. iJ`MITG>Xh8(L m>Ex"ELrmL)"TSM(A)rd{)&LD h8(O)#g{`M* L,G4h*;C},sz;Cu?#g{`M* A,G4 ;h*|`dk#g{`M* O,G4h*2mb{# 6. SHRlib N}8r\;f"0k1>}]Db# 84 }]F/5CLr8OMN< 7. g{Z8(K COPY NO r NONRECOVERABLE !nDivBwC0kYw,"RZY wjIs48]}]br\0lDmUd,G4^(+}]brmUd4-=0k YwjIsD1dc#4,^(9C0vV4Yw4XB4(}]brmUdT+ |GV4=0kYwjIsy&D4,#;\+}]brmUd4-=4P0kY w0D1dc# g{*9CX(D0k1>,G4IT9C}]bDV4z7G X# 0k*"D~ (}8( dumpfile D~`M^N{,ITr0k5CLr8>l#D~D{FM;C, 0k5CLra+\xDP4kCD~# ZVx}]b73PKP1,VxSzmLrr0kSzmLrI\a\xP#r K,T*"D~{8(D)9{j6KSzmLr`MT0zIl#D}]bVx E#}g,g{8(KTB*"D~5: dumpfile = "/u/usrname/dumpit" 0kSzmLrZ}]bVx 5 O\xDP+f"Z /u/usrname/dumpit.load.005 D ~P,0kSzmLrZ}]bVx 2 O\xDP+f"Z /u/usrname/ dumpit.load.002 D~P,VxSzmLrZ}]bVx 2 O\xDP+f"Z /u/usrname/dumpit.part.002 D~P,@K`F# TZ0kSzmLr\xDP45,g{P$H!Z 32768 VZ,G4a+{vG<4 F=*"D~P;g{,}K$H,Ma+P,N(|(GXE LO#&C\b!qyZxgD~53 (NFS) D76,qr,0kYwZdT\+wT 5M# }]F/5CLrMN< 85 /f: 4AK76DY1D~ZNNivB<;\[D#[Db)Y1D~+G< C5CLr\mwzzktI DB2 5CLr(|(0k5CLr)`X*DU>G<# BPU>GG0kYwDhCWND*<# – d5U>G<#KU>GhCWNDI&jI# – P9U>G<#KU>GhCWND'\#(r_,Z%;Vx}]b P,g{ZTom==^Dm.00khCWN'\,G4|+zI>X]Rd 5U>G<)# v 0kWN – 0k*<#KU>G0kYwD0kWND*<# – >X]Rd5U>G<#KU>G0kWNDI&jI# – P9U>G<#KU>G0kWND'\# v >}WN – 0k>}*<#KU>G}WND*<`X*#v1fZX4 w|51,Ea*<>}WN#Z>}WNZd,kTmG }Yw}ax#KU>G}WNDa2`X*#ZI&0kY wD0vV4Zd,+X44PK>}WN# TBPmEv0k5CLry]dk}]Ds!4(DU>G<: v +T0k5CLrZ DMS mUdPVdr>}D?vmUd)9}]i4(=vU >G<# v +*9CD?vj65i4(;vU>G<# v +*Z0kYwD>}WN>}D?v}]Prw}|4(U>G<# v +4(U>G}G)P# g{X(0k}]bVxOfZ}]bVx%},G4a+;uPXC}]b VxD/f4A0k{"D~# ANALYZE zInQV"3d(ZyP}]bVx.dyHXV"}])# EnMuo ZV[ LOAD 5CLrZxP`v}]bVxDVx}]b73PDP*MYw1, +9CTBuo: v -wLrVxG;v}]bVx,C',S=CVxT4P0kYw#Z PARTITION_AND_LOAD"PARTITION_ONLY M ANALYZE ==B,}G8(K LOAD |nD CLIENT !n,qrY(}]D~ZK}]bVxO#g{8( CLI- ENT,G4m>*0kD}]Z,SD6LM'zO# v Z PARTITION_AND_LOAD"PARTITION_ONLY M ANALYZE ==B,$Vxz mLrA!C'}]"T-7==+dV"xVxzmLr,s_+V rI4PD~(K&F*C'vZ)# }]F/5CLrMN< 87 ZVx}]b73P0k}] 9C LOAD 5CLr+}]0k=Vx}]b73P# *<.0 Z`Vx}]bP0km.0: v 7#}7hCK svcename }]b\mwdCN}M DB2COMM E*D~"amd?# K=h\X*,r* LOAD 5CLr9C TCP/IP +}]S$VxzmLr+dA VxzmLrT0SVxzmLr+dA0k}]bVx# v ZwC LOAD 5CLr0,Xk,SA(r\;~=,SA)*+}]0k=dP D}]b# v r* LOAD 5CLr"v COMMIT od,yTZ*<4P0kYw0,&C(} "v COMMIT r ROLLBACK odjIyPBq"MENNx(#g{9CDG PARTITION_AND_LOAD"PARTITION_ONLY r ANALYZE ==,G40kD}]D~Xk ZK}]bVxO,+ZBPivB}b: 1. Q8( CLIENT N},ZKivB}]Xk$tZM'zO; 2. dk4`M* CURSOR,ZKivB;PdkD~# v KP“hFKJLr”T7(?vmDnQ}]bVx#PX|`E",kND6J OoOMw{}]bT\7PD“hFKJLr”# ^F Z9C LOAD 5CLrTZ`Vx}]b73P0k}]1,BP^FJC: v 0kYwDdkD~;C;\GExh8# v ROWCOUNT N};\'V,}G}9C ANALYZE ==# HI Q HI Q THI Q Q Q Q < 13. Vx}]b load Ev. $VxzmLrA!4}],;sr=vVxzmLrPD?vVxzmLrw"MS| ;kD}],b=vVxzmLrV"}]"+C}]"Mx}v}]bVxPD;v}]bVx#?v}]bVxOD 0kzmLr0k}]# 88 }]F/5CLr8OMN< v g{?jm|,V"yhDj6P,"R48( identityoverride D~`M^N{, r_z}9C`v}]bVx4xPV";s0k}],G4;'VZ LOAD |nO T SAVECOUNT 9CsZ 0 D5# v g{V<||,j6P,G4;'V PARTITION_AND_LOAD ==# v LOAD_ONLY M LOAD_ONLY_VERIFY_PART ==;\k LOAD |nD CLIENT N}dO 9C# v LOAD_ONLY_VERIFY_PART ==;\k CURSOR dk4`MdO9C# v V"mstk== LOAD_ERRS_ONLY M SETUP_AND_LOAD_ERRS ;\k LOAD |nD ALLOW READ ACCESS M COPY YES N}dO9C# v g{ OUTPUT_DBPARTNUMS M PARTITIONING_DBPARTNUMS !n8(D}]bVx;X ~,G4`v0kYwI,1+}]0k=,;vmP#}g,g{mGZ}]b Vx 0 A 3 O(eD,G4;v0kYwIT+}]0k=}]bVx 0 M 1 P, x m ; v 0 k Y w I T + } ] 0 k = } ] b V x 2 M 3 P # g { PARTITIONING_DBPARTNUMS !n8(D}]bVxX~,G40kYwT/!q PARTITIONING_DBPARTNUMS N}(ZKivB,;PNN0kVxSzmLrQZk TKm4P)r'\(g{;PNNN})# S V9.7 FP6 *<,g{ PARTITIONING_DBPARTNUMS !n8(D}]bVxX~, G4 LOAD 5CLr+T/SI OUTPUT_DBPARTNUMS 8>D}]bVx"T!q PARTITIONING_DBPARTNUMS N}(ZKivB,;PNN0kVxSzmLrQZk TKm4P)r'\(g{;PNNN})# g{z*9C PARTITIONING_DBPARTNUMS !nT=8(Vx,G4?R(iz&C9 C_PyP"" LOAD |n(?v|n8(;,DVx)D!n#g{zvZ3)" "0k|nO8( PARTITIONING_DBPARTNUMS,rg{8(X~Vx,G4 LOAD | nAY+h**3)""0k!q8CVxZc,RC|nI\a+Y'\ (SQL2038N)# v TZg`v}]bVxDm45,;\+G(g ASCII (ASC) M(g ASCII (DEL) D~V<=b)mP#;\V< PC/IXF D~,+I9C LOAD_ONLY_VERIFY_PART = =D0kYw+ PC/IXF D~0k=V} BP>}5wgN9C LOAD |n4t/wV`MD0kYw#BP>}P9CD}] bP 5 v}]bVx:0"1"2"3 M 4#?v}]bVxX?< /db2/ data/#Z}]bVx 0"1"3 M 4 O(eK=vm TABLE1 M TABLE2#SM'z 0k}]1,C'\;CJ}}]bVxTbD6LM'z# V"M0k>} ZK=8P,z,S=;v}]bVx,C}]bVxI\G2I\;GC4 (e TABLE1 D}]bVx#}]D~ load.del ZK}]bVxD10$w ?}P,53TVx}]b73DyPdCN}9C1!5:MODE N }1!* PARTITION_AND_LOAD#OUTPUT_DBPARTNUMS N}1!*ZdO(eK }]F/5CLrMN< 89 TABLE1 DyP}]bVx#PARTITIONING_DBPARTNUMS 1!*y] LOAD | nfr(CZZ48(NN}]bVxDivB!q}]bVx)!qD}] bVx/O# *Z}]V} ZK=8P,z,S=;v}]bVx,C}]bVxI\G2I\;GC4 (e TABLE1 D}]bVx#}]D~ load.del ZK}]bVxD10$w ?D}]bVxE# Zv9C}]bVx 0(1! PARTITIONING_DBPARTNUMS 5)OKPD 1 v VxzmLrDivB,*+ load.del D~V<=}]bVx 1 M 3,k" vTB|n: Q Q >?@CG HI 0 @CG HI 1 2 @CG HI 3 @CG HI 4 @CG HI Q Q THI Q HI Q HI Q KLQ @C： LOAD.DEL *+- ./0 < 14. +}]0k=}]bVx 3 M 4 P#. K<5w"vTO|nszzDP*#}]+0k=}]bVx 3 M 4 P# 90 }]F/5CLr8OMN< LOAD FROM LOAD.DEL OF DEL REPLACE INTO TABLE1 PARTITIONED DB CONFIG MODE PARTITION_ONLY PART_FILE_LOCATION /db2/data OUTPUT_DBPARTNUMS (1,3) v0k>} g{Q-T PARTITION_ONLY ==4PK0kYw,"R*+?v0k}]bV xD /db2/data ??@CG HI 0 @CG HI 1 @CG HI 2 @CG HI 3 @CG HI 4 "“" Q "“" Q HI Q KLQ @C: LOAD.DEL *+- ./0 THI Q HU• @C: HU• @C: /db2/data/ LOAD.DEL.001 /db2/data/ LOAD.DEL.003 < 15. 9C;vVxzmLr+}]0k=}]bVx 1 M 3 P#. K<5w"vTO|nszzDP*#+9C}] bVx 0 OKPD 1 vVxzmLr+}]0k=}]bVx 1 M 3 P# }]F/5CLrMN< 91 *v0k=}]bVx 4 P,k"vTB|n: LOAD FROM LOAD.DEL OF DEL REPLACE INTO TABLE1 PARTITIONED DB CONFIG MODE LOAD_ONLY PART_FILE_LOCATION /db2/data OUTPUT_DBPARTNUMS (4) 0k;xV"3d7D$V"D~ IT9C LOAD |n4+;xV<7D0k}]D~1S0k=}v}]bVx P#g{}]D~Z?vC4(e TABLE1 D}]bVxOD /db2/data ? ?@CG HI 0 @CG HI 1 @CG HI 2 @CG HI 3 @CG HI 4 Q Q KLQ *+- ./0 HU• @C: HU• @C: HU• @C: HU• @C: /db2/data/ LOAD.DEL.000 /db2/data/ LOAD.DEL.001 /db2/data/ LOAD.DEL.003 /db2/data/ LOAD.DEL.004 < 16. +}]0k=dP(eKX(mDyP}]bVxP#. K<5w"vTO|nszzDP*#+V<=}]0k =yPC4(e TABLE1 D}]bVxP# 92 }]F/5CLr8OMN< LOAD FROM LOAD.DEL OF DEL modified by dumpfile=rejected.rows REPLACE INTO TABLE1 PARTITIONED DB CONFIG MODE LOAD_ONLY_VERIFY_PART PART_FILE_LOCATION /db2/data OUTPUT_DBPARTNUMS (1) ":g{8(K*"D~,G4+\x0k;tZ4}]bVxDP"+|G Ek*"D~# S6LM'z0k=`Vx}]b *+6LM'zODD~PD}]0k=`Vx}]bP,Xk8( LOAD |n D CLIENT N}#KN}8>}]D~;Z~qwVxO#}g: LOAD CLIENT FROM LOAD.DEL OF DEL REPLACE INTO TABLE1 ":;\+ LOAD_ONLY r LOAD_ONLY_VERIFY_PART ==k CLIENT N}dO 9C# SNj0k kZ%;Vx}]bP;y,ITSNj0k=`Vx}]bP#ZK>} P,TZ PARTITION_ONLY M LOAD_ONLY ==,PART_FILE_LOCATION N}X k8(jD~{#g{?jm|, LOB P,G4IT9C8(Dy>{F4 4(`vD~# *+od SELECT * FROM TABLE1 D&p/PDyPPVk$VxzmLrQA!D}]DWVZ }#b){"+;*"=$VxzmLr{"D~P#*Z0kYwZdi4KD ~DZ],k,S=-wLrVx"T?jm"v LOAD QUERY |n# v g{NkV<}LD}]bVx(I PARTITIONING_DBPARTNUMS !n(e)k0k} ]bVx(I OUTPUT_DBPARTNUMS !n(e);,,MaIZ CPU \ZyCivu Yxa_T\#+}]0k=`Vx}]bP1,T4NkV3v0kxLvm,kPO100kYw# 9C LOAD QUERY |n4ZVx}]b73P`S0kYw ZVx}]b73P4P0kYwZd,3)0kxLaZ|G4P1yZD}]b VxO4({"D~# b){"D~f"0kYw4PZdzIDyPN<{""/f{"Mms{"#C 'ITi4TB}v\zID{"D~D0kxL:0kzmLr"$VxzmLr MVxzmLr#;PZ0kYwjIs,{"D~DZ]EIC# Z0kYwZd,I,SAwv}]bVx"T?jm"v LOAD QUERY |n#S CLP P"vK|n1,K|n+T>I LOAD QUERY |n8(DmD}]bVxO10fZ DyP{"D~DZ]# }g,Z}]b WSDB P,m TABLE1 GZ}]bVx 0 A 3 O(eD#z+, SA}]bVx 0 ""vTB LOAD |n: load from load.del of del replace into table1 partitioned db config partitioning_dbpartnums (1) 94 }]F/5CLr8OMN< K|n+t/0kYw,CYw|(:Z}]bVx 0"1"2 M 3 OKPD0kzm Lr;Z}]bVx 1 OKPDVxzmLr;Z}]bVx 0 OKPD$Vxzm Lr# }]bVx 0 +|,$VxzmLrD{"D~T0C}]bVxO0kzmLrD{ "D~#*,1i4b)D~DZ],kt/Ba0"S CLP P"vBP|n: set client connect_node 0 connect to wsdb load query table table1 }]bVx 1 +|,0kzmLrD{"D~MVxzmLrD{"D~#*i4b) D~DZ],kt/Ba0"S CLP P"vBP|n: set client connect_node 1 connect to wsdb load query table table1 ":STATUS_INTERVAL 0kdC!nzID{"+vVZ$VxzmLr{"D~P# *Z0kYwZdi4b){",Xk,SA-wLrVx""v LOAD QUERY |n# #f{"D~DZ] g{(} db2Load API t/0kYw,G4Xk8({"!n(piLocalMsgFileName), +{"D~S~qw+d=M'z"f"B4T)i4# TZS CLP t/D`Vx}]b0kYw45,;aZXF(OT>r#t{"D~# *Z`Vx}]b0kjIs#fri4b)D~DZ],Xk8( LOAD |nD MESSAGES !n#g{9CKK!n,G40kYw;)jI,Ma+?v}]bVxO D{"D~+d=M'z"9C MESSAGES !nP8>Dy>{Ff"ZD~P#TZ `Vx}]b0kYw,BmP>K`&0kxLyzIDD~D{F: xL`M D~{ 0kzmLr .LOAD. VxzmLr .PART. $VxzmLr .PREP. }g,g{ MESSAGES !n8( /wsdb/messages/load,G4}]bVx 2 D0kzm Lr{"D~+G /wsdb/messages/load.LOAD.002# ":?R(iTS CLP Pt/D`Vx}]b0kYw9C MESSAGES !n# ZVx}]b73PLx"XBt/rU90kYw g{0kYwZVx}]b73P'\,G4SB4h*4PDYw!vZvVJO D1d# `Vx}]bPD0k}LI=vWNiI: 1. hCWN,ZCWNPq!}]bVx6pDJ4,}g,dv}]bVxODm x( }]F/5CLrMN< 95 (#,g{hCWN"zJO,;X4PXBt/MU9Yw#zh*4PDYw !vZT'\D0kYw8(Dmstk==# g{0kYw8(K;tkhCWNDms,G4+!{{v0kYw"R?v} ]bVxOmD4,<+Xv=CmZ4P0kYw.0y&D4,# g{0kYw8(K*tkhCWNDms,G4+ZhCWNQI&jID}] bVxOLx4P0kYw,+?v'\}]bVxODm<+Xv=CmZ4P 0kYw.0y&D4,#bb6Eg{3)VxZhCWN'\,xd{VxZ 0kWN'\,G4%v0kYwI\Z;,WN'\# 2. 0kWN,ZCWNPq=/}]"+|G0k=}]bVxODmP# Z`Vx}]b0kYwD0kWN,g{0kYwZAY;v}]bVxO' \,G4Xk"v LOAD RESTART r LOAD TERMINATE |n#r*`Vx}]bP D}]0kYw+(}%vBqjI,yTPX*4PKYw# g{zITbvVx**(kNDTB>})#g{S db2Load API "v LOAD |n,G4Vx**|,Z db2PartLoadOut a9D poAgentInfoList VNP# g{TZx(Vx,“zmLr`M”P;v“LOAD”u?,G4CVxQ=o0kW N,qrZhCWNvVJO#SQL zk*:}m>'\#ZTB>}P,0kYwZ 0kWNZVx 1 O'\# zmLr`M Zc SQL zk a{ ________________________________________________________________ LOAD 000 +00000000 Success. ________________________________________________________________ LOAD 001 -00000289 Error. May require RESTART. ________________________________________________________________ LOAD 002 +00000000 Success. ________________________________________________________________ LOAD 003 +00000000 Success. . . . V4"XBt/rU9'\D0kYw ZhCWN,;P ISOLATE_PART_ERRS !n8(* SETUP_ERRS_ONLY r SETUP_AND_LOAD_ERRS DD0kEa'\#TZZKWNZAY;vdv}]bVxO '\D0k45,IT"v LOAD REPLACE r LOAD INSERT |n#9C OUTPUT_DBPARTNUMS !n4v8(0kYwZdO'\DG)}]bVx# 96 }]F/5CLr8OMN< TZZ0kWNZAY;vdv}]bVxO'\D0k45,"v LOAD RESTART r LOAD TERMINATE |n# TZZhCWNZAY;vdv}]bVxO'\"RZ0kWNZAY;vdv} ]bVxO'\D0k45,h*4P=v0kYwTLx'\D0k - ;v0kYw CZhCWNJO,m;vCZ0kWNJO,gOyv#*P'X7zK`M'\ D0kYw,"v LOAD TERMINATE |n#+G,Z"vC|ns,zXk5wyPV x,r*;PTZhCWN'\DVxODmxPNN|D,"RQ7zZ0kWN '\DVxDyP|D# }g,Z}]b WSDB P,TABLE1 GZ}]bVx 0 A 3 O(eD#"vTB| n: load from load.del of del insert into table1 partitioned db config isolate_part_errs setup_and_load_errs ZhCWN,dv}]bVx 1 OvVJO#IZtkKhCWNms,yT0kYw Lx,+Z0kWNZVx 3 OvVJO#*Lx0kYw,&"vBP|n: load from load.del of del replace into table1 partitioned db config output_dbpartnums (1) load from load.del of del restart into table1 partitioned db config isolate_part_errs setup_and_load_errs ":TZ0kXBt/Yw,+9CZ LOAD RESTART |nP8(D!n,rK,b) !n&Ck-< LOAD |nP8(D!nj+`,,b;cG#X*# (FMf>f]T Z`Vx}]bP,DB2_PARTITIONEDLOAD_DEFAULT "amd?IC49-* DB2 Uni- versal Database™ V8 .0D0kP*# ":;Fv9C DB2_PARTITIONEDLOAD_DEFAULT "amd?"RZTsD"PfPI\ a+d}%# (}Z`Vx}]bP9-* LOAD |nD DB2 UDB V8 .0DP*,IT+xPP 'V<7DD~0k=%;}]bVxP,x;X8(NNd{Vx}]bdC! n#+ DB2_PARTITIONEDLOAD_DEFAULT D5hC* NO ITo=K?D#g{*\b^ DT%;}]bVx"v LOAD |nDVPE>,G4IT!q9CK!n#}g,* +V}: BP>}5wgNZ`Vx}]bP0k}]# }]bPDv}]bVx,d`ES 0 = 3#}]b WSDB GZyP}]bVxO( eD,m TABLE1 Z1!}]bVxiP,C}]bVxi2GZyP}]bVxO (eD# >} 1 *+C'}]D~ load.del PD}]0k= TABLE1 P(CD~Z}]bVx 0 O),k,S=}]bVx 0,;s"vTB|n: load from load.del of del replace into table1 g{0kYwI&,G4dv+gBy>: zmLr`M Zc SQL zk a{ ___________________________________________________ LOAD 000 +00000000 Success. ___________________________________________________ LOAD 001 +00000000 Success. ___________________________________________________ LOAD 002 +00000000 Success. ___________________________________________________ LOAD 003 +00000000 Success. ___________________________________________________ PARTITION 001 +00000000 Success. ___________________________________________________ PRE_PARTITION 000 +00000000 Success. ___________________________________________________ a{: I&jIK 4 v0k# ___________________________________________________ VxzmLrD**: A!DP} = 100000 \xDP} =0 VxDP} = 100000 0kzmLrD**: A!DP} = 100000 x}DP} =0 0kDP} = 100000 \xDP} =0 >}DP} =0 d5DP} = 100000 dv8>Z?v}]bVxOP;v0kzmLr,"R?v0kzmLrZ-wLrVxOKPK;v$VxzmLr,Z}]bVx 1 OKP K;vVxzmLr#b)xL $VxzmLrA!K 100,000 P,VxzmLrV} 2 ZTB>}P,T PARTITION_ONLY ==+}]0k= TABLE1 P#V<=dvD~ f"Z?vdv}]bVxOD /db/data ?: zmLr`M Zc SQL zk a{ ___________________________________________________ LOAD_TO_FILE 000 +00000000 Success. ___________________________________________________ LOAD_TO_FILE 001 +00000000 Success. ___________________________________________________ LOAD_TO_FILE 002 +00000000 Success. ___________________________________________________ LOAD_TO_FILE 003 +00000000 Success. ___________________________________________________ PARTITION 001 +00000000 Success. ___________________________________________________ PRE_PARTITION 000 +00000000 Success. ___________________________________________________ VxzmLrD**: A!DP} = 100000 \xDP} =0 VxDP} = 100000 dv8>Z?vdv}]bVxO$VxzmLrI&A!K 100,000 P,VxzmLrI &VQ0kP}**# >} 3 *0kZH0T>D PARTITION_ONLY 0kYwZdzIDD~,k"vTB|n: load from load.del of del replace into table1 partitioned db config mode load_only part_file_location /db/data load |nDdvgBy>: zmLr`M Zc SQL zk a{ ___________________________________________________ LOAD 000 +00000000 Success. ___________________________________________________ LOAD 001 +00000000 Success. ___________________________________________________ LOAD 002 +00000000 Success. ___________________________________________________ LOAD 003 +00000000 Success. ___________________________________________________ a{: I&jIK 4 v0k# ___________________________________________________ 0kzmLrD**: A!DP} = 100000 x}DP} =0 0kDP} = 100000 \xDP} =0 >}DP} =0 d5DP} = 100000 KdvT>?vdv}]bVxOD0kzmLrV} 4 g{"vTB LOAD |n: load from load.del of del replace into table1 "RdP;v0k}]bVxZ0kYwZdD!mUd,G4+5XTBdv: SQL0289N ;\ZmUd“DMS4KT”PVdB3# SQLSTATE=57011 zmLr`M Zc SQL zk a{ ________________________________________________________________ LOAD 000 +00000000 Success. ________________________________________________________________ LOAD 001 -00000289 Error. May require RESTART. ________________________________________________________________ LOAD 002 +00000000 Success. ________________________________________________________________ LOAD 003 +00000000 Success. ________________________________________________________________ PARTITION 001 +00000000 Success. ________________________________________________________________ PRE_PARTITION 000 +00000000 Success. ________________________________________________________________ a{: I&jIK 4 v0kPD 3 v# ________________________________________________________________ VxzmLrD**: A!DP} =0 \xDP} =0 VxDP} =0 0kzmLrD**: A!DP} =0 x}DP} =0 0kDP} =0 \xDP} =0 >}DP} =0 Qd5DP} =0 dv8>0kYw5XKms SQL0289#}]bVx**8>}]bVx 1 D!Ud# g{T}]bVx 1 ODmUd]wmSK|`Ud,G4IT4gB==XBt/0 kYw: load from load.del of del restart into table1 *Vx}]b730kdC!n: Pm`IC4^DVx}]b73PD0kYwDdC!n# MODE X 8(0k`Vx}]b10kYwICD==#PARTITION_AND_LOAD G1!5#P '5*: v PARTITION_AND_LOAD#T}]xPV<(PI\T"P==xPV<),"R ,1Zwv`&}]bVxO0k}]# v PARTITION_ONLY#T}]xPV<(PI\T"P==xPV<),"+dv 4k?v0k}]bVxO8(;CPDD~#TZ CURSOR TbDD~`M, ?v}]bVxODdvD~{q=* filename.xxx,dP filename G LOAD | nP8(DdkD~{,xxx G 3 ;D}]bVxE#TZ CURSOR D~`M, 100 }]F/5CLr8OMN< ?v}]bVxODdvD~{I PART_FILE_LOCATION !n7(#kND PART_FILE_LOCATION !nTKbPXgN8(?v}]bVxDV }G)P#g{X(0k}]bVxOfZ}]bVx%},G4a+;uP XC}]bVxD/f4A0k{"D~#?v}]bVxDdkD~{q= &CG filename.xxx,dP filename G LOAD |nP8(DD~{,xxx G 3 ;D}]bVxE#kND PART_FILE_LOCATION !nTKbPXgN8(?v }]bVxDVD~{,r_Z LOAD_ONLY ==,K{FGTZ?v}]bVx*A!DD ~D;C#9C PARTITION_ONLY ==1,g{?jm|, LOB P,G4IT9 C8(Dy>{F44(`vD~# TZ CURSOR TbDD~`M,g{48(K!n,r+9C10?<4f"V< =D~# OUTPUT_DBPARTNUMS X X m>}]bVxEPm#}]bVxEm>*4P0kYwD}]bVx#}] bVxEXkG(eKCmD}]bVxDS/#1!ivB,!qKyP}]b Vx#Xk+KPm(Z2(EP,"RPmnXkI:EVt#Jm8(6' (}g,(0, 2 to 10, 15))# PARTITIONING_DBPARTNUMS X X m>V<}LP9CD}]bVxEPm#Xk+KPm(Z2(EP,"RP mnXkI:EVt#Jm8(6'(}g,(0, 2 to 10, 15))#TV<}L8( D } ] b V x I \ k * 0 k D } ] b V x ; , # g { 4 8 ( PARTITIONING_DBPARTNUMS,G4 LOAD 5CLra7(h*`Yv}]bVxT 0*9CDv}]bVx,TcqCnQT\# g{Z LOAD |nP48( anyorder D~`M^N{,G4Z0ka0P+;9 C;vVxzmLr#Kb,g{vT OUTPUT_DBPARTNUMS !n8(K;v}]b Vx,r_0kYwD-wLrVx;G OUTPUT_DBPARTNUMS D*X,G4aZV < } L P 9 C 0 k Y w D - w L r V x # q r , Z V < } L P 9 C OUTPUT_DBPARTNUMS PDZ;v}]bVx(;G-wLrVx)# g{8(K anyorder D~`M^N{,G44TB==7(V<}LP9CD} ]bVx}:(OUTPUT_DBPARTNUMS PDVx}/4+1)# MAX_NUM_PART_AGENTS X 8(0ka0P*9CDnsVxzmLr}#1!5* 25# ISOLATE_PART_ERRS X 8>0kYwgNTwv}]bVxO"zDmswv4&#}G,18(K LOAD |nD ALLOW READ ACCESS M COPY YES N}(ZKivB,1!5* NO_ISOLATION),qr1!5* LOAD_ERRS_ONLY#P'5*: v SETUP_ERRS_ONLY#hCZdZ}]bVxO"zDms(}g,CJ}]bV x1"zDJb,r_CJ}]bVxODmUdrm1"zDJb)+A!`Y}]?1"v(*#F?%;GWVZ (MB)#1!5* 100 MB# P'5G 1 = 4000 .dD{}# PORT_RANGE X X m>C44(Z?(EWSVD TCP KZD6'#1!6'G 6000 = 6063# g{ZwC1(eK DB2ATLD_PORTS "amd?D5,G4C5+f; PORT_RANGE 0kdC!nD5#TZ DB2ATLD_PORTS "amd?,&C9CTBq=4a)6 ': Z CLP P,q=*: ( lower-port-number, higher-port-number ) CHECK_TRUNCATION 8(Lr&CZdk/dv1li}]GV"3dDdvD~{#+Z"v LOAD |nD}]bVxO4(dvD~ (Y(4PVxYwD}]bVxi|,C}]bVx)#g{Z4NkVxD} ]bVx(I PARTITIONING_DBPARTNUMS (e)OwC LOAD |n,G4aZ9C PARTITIONING_DBPARTNUMS N}(eDZ;v}]bVxO4(dvD~#y0kdkD~P;V"=`&V" 3du?DP}#KE"ITozzj6}]+n,"R9ITozz7(Gq& C9C5CLrD ANALYZE ==4zImDBV"3d#g{48(K!n,G4 LOAD 5CLrD1!P*G;zI"48(5,G4+Zdv}]bVxPmPDZ;v}]bVxOU/3 FE"# INGEST 5CLr INGEST 5CLr(P1F*,x}]ekr CDI)G;v_YDM'K DB2 5CL r,|IT+}]TwDN=SD~M\@Pek= DB2 ?jmP#r* INGEST 5 CLrITF/s?51}]x;Xx(?jm,yTz;h*Z}]w(TMIC T.dxP!q# INGEST 5CLr1Sek$H&mD}]r(} ETL $_rd{VNdvDD~e k#|ITVxKP,rK|IT&mw-\@D}]w#+TO_DYHek} ],cTndVx}]b73PDsM}]b# INGEST |naZ%v=hP9COMH}1d4|B?jm#INGEST 5CLr9CP x(,rK|kkT`,mDd{C'n/De;nY# hzK5CLr,zIT9C`FZ SQL DSZ4Tm4P DML Yw,x;Xx( ?jm#b)ekYw'VBP SQL od:INSERT"UPDATE"MERGE"REPLACE M DELETE#INGEST 5CLr9'V9C SQL mo=4y]`v}]VN9(wv P5# INGEST 5CLrDd{X*&\gB: v 41drP}xPd5# IT9C commit_count ekdCN}T44kDP}47 (d55J,2IT9C1! commit_period ekdCN}T48(D1d47(d 55J# 104 }]F/5CLr8OMN< v 'V+Q\xDG<4F=D~rmP,2'VOzb)G<#zIT8( INGEST | ngN&m INGEST 5CLr((} DUMPFILE N})r DB2((} EXCEPTION TABLE N})\xDP# v 'VXBt/MV4#1!ivB,ITSns;vd5cXBt/yP INGEST | n#Kb,g{zhCK retry_count ekdCN},G4 INGEST 5CLra" TS3)msPV4# INGEST |n'VBPdk}]q=: v (gD> v ;CD>M~xF v wV3rMq=DP }K#fmMGFTb,INGEST |n9'VBPm`M: v `,/: (MDC) Mek1d/: (ITC) m v 46'VxDm v 6'/:m (RCT) v (e* MAINTAINED BY USER D_e/i/m(MQT),|(\am# v Y1m v I|BDS<(x`MS<}b) %v INGEST |n+-z}vw*WN: 1. +d +dLrS}]4PA!,"+G!Za)Kk9C INGEST 5CLr`XDw*hCMYwNqD_6Ev# hCekPd~ 1. v(KP INGEST 5CLrD;C zITZVPzwOrS@"DzwOKPekw5#PX|`E",k NDZ 106 3D:v(KP INGEST 5CLrD;C; 2. 20 INGEST 5CLr(DB2 }]~qwKP1M'z M DB2 }]~q wM'z D;?V)# }]F/5CLrMN< 105 g{v(ZBD@"zwO20 INGEST 5CLr,kKPJCZ DB2 M 'zD203q#PX|`E",kND620 IBM Data Server Client7 PD“20 IBM }]~qwM'z(Linux M UNIX)”# *"CZndmDxL 1. (gPX*)bvzk3Jb y]dk}]"DB2 M'zT0 DB2 ~qwGq9C`,Dzk3,ZK P INGEST |n.0I\h*4P;)C'Yw#PX|`E",kNDZ 120 3D:INGEST 5CLrDzk3"bBn;# 2. hCT&mQ'\D INGEST |nDXBt/ *9ekYwITXBt/,h*Z"v INGEST |n.04(XBt/U >m#PX|`E",kNDZ 107 3D:4(XBt/m;# 3. `4 INGEST |n "vxPXhN}(}gdk4M}]`M)D INGEST |nT0wVI! N}#PX|no(MC(Dj8hv0>},kNDZ 108 3D:ek }];M6Command Reference7PD“INGEST”# 4. hCT&mxPPDekw5w g{*aIwC$H+4D INGEST |n,k*C|n4(;vE>,"Z h*1xPwC#PX|`E",kNDZ 124 3D:=8:9C INGEST 5CLr&mD~w; 4PYwNq v (gPX*)bvQ'\D INGEST |n g{ekw5'\,G4zIT!qXBt/rU9C|n#PX|`E ",kNDZ 115 3D:XBt/'\D INGEST Yw;rZ 116 3D:U 9'\DekYw;# v `S INGEST |n PX|`E",kNDZ 117 3D:`SekYw;# (I!)E/T\ v 4i INGEST |nDIw{dCN}# v ^D INGEST |nT{O_T\*s# PX|`E",kNDZ 120 3D:ekYwDT\"bBn;# v(KP INGEST 5CLrD;C DB2 M'z20P+|( INGEST 5CLrbv?~#zITSM'zr~qwKP INGEST 5CLr# XZKNq CZKP INGEST 5CLrD;CP=v!n: Z}]Vb73PDVP~qwO ZK`MDhCPCZKPekw5D;CP=v!n: 106 }]F/5CLr8OMN< v Z DB2 -wLrVx(&CLr+,SA"R-wzmyZD}]bVx~ qw)O v ZVP ETL(i!,d;M0k)~qwO ZBD~qwO ZK`MDhCPCZKPekw5D;CP=v!n: v Z;KP INGEST 5CLrD~qwO v Z2w\d{(CZ INGEST 5CLrD DB2 -wLrVxD~qwO# P;)rXa0lzv(20 INGEST 5CLrD;C: v T\:+ INGEST 5CLr20Z|T:D~qwOITqC;ar9C INGEST 5C Lrxzzd{QC# v WZ\m 4(XBt/m 1!ivB,g{ INGEST |n'\,G4ISns;vd5cXBt/b)|n;+ G,zh*H4(XBt/m,Kmf"V4 INGEST |nyhDE"# XZKNq vh4(XBt/m;N,"RCm+I}]bPDyP INGEST |n9C# INGEST 5CLr+9CKm4f"Sns;vd5cV44jID INGEST |nyh DE"# ":XBt/m;|,dkPD1>,;|,;)F}wT8>D)PQd5# ^F v (iz+XBt/mk INGEST 5CLry|BD?jmECZ,;mUdP#g{ ^(ECZ,;mUdP,k7#|,XBt/mDmUdk|,?jmDmUd _P`,D6p#}g,g{*4-r0vdP;vmUd,G4Xk+m;vm Ud24-r0v=`,cN#g{b=vmUdD6p;,"RzKPx RESTART CONTINUE !nD INGEST |n,G4 INGEST 5CLrI\'\rek;}7D} ]# v g{VQV4_T|(4F INGEST YwD?jm,G49Xk4FXBt/mT9 dk?jm#V,=# }L *4(XBt/m,k4PTBYw: v g{}Z9C V10.1 ~qw,kwC SYSPROC.SYSINSTALLOBJECTS f"}L: db2 "CALL SYSPROC.SYSINSTALLOBJECTS(’INGEST’, ’C’, tablespace-name, NULL)" v g{}Z9C V9.5"V9.7 r V9.8 ~qw,k"vTB SQL od: CREATE TABLE SYSTOOLS.INGESTRESTART ( JOBID VARCHAR(256) NOT NULL, APPLICATIONID VARCHAR(256) NOT NULL, FLUSHERID INT NOT NULL, FLUSHERDISTID INT NOT NULL, }]F/5CLrMN< 107 TRANSPORTERID INT NOT NULL, BUFFERID BIGINT NOT NULL, BYTEPOS BIGINT NOT NULL, ROWSPROCESSED INT NOT NULL, PRIMARY KEY (JOBID, FLUSHERID, TRANSPORTERID, FLUSHERDISTID)) IN DISTRIBUTE BY (FLUSHERDISTID); GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE SYSTOOLS.INGESTRESTART TO PUBLIC; a{ VZ&Z8(mUdP4(XBt/m SYSTOOLS.INGESTRESTART,"RzVZI KPIXBt/D INGEST |n# >} DBA F.+yP INGEST |nw*IXBt/D|nKP,yTC DBA h*H4( XBt/m: 1. DBA ,SA}]b: db2 CONNECT TO sample 2. DBA wCf"}L: db2 "CALL SYSPROC.SYSINSTALLOBJECTS(’INGEST’, ’C’, NULL, NULL)" B;=v24 7#+^DCXBt/mDNNC'<_PJ1(^: v g{ INGEST |n8( RESTART NEW,G4C'Xk_PTXBt/mD SELECT"INSERT"UPDATE M DELETE X(# v g{ INGEST |n8( RESTART TERMINATE,G4C'Xk_PTXBt/mD SELECT M DELETE X(# ek}] IT9C INGEST 5CLr(} SQL }iek"|BM>}4+}],x"k= DB2 mP,1=4P;P}]*9# *<.0 ZwC INGEST 5CLr0,Xk,SA+}y>: INGEST FROM FILE my_file.txt FORMAT DELIMITED INSERT INTO my_table; (iz9Z INGEST |nP8(;vx RESTART NEW N}DV{.: INGEST FROM FILE my_file.txt FORMAT DELIMITED RESTART NEW ’CDIjob001’ INSERT INTO my_table; 8(DV{.IT`o 128 vVZ#r*CV{.a(;6p INGEST |n,Z10Q 8( RESTART NEW !n+P4jID}]bP,CV{.ZyP INGEST |nPXkG (;D# >} y>ek>} BP>}S(gD>D~Pek}]: INGEST FROM FILE my_file.txt FORMAT DELIMITED INSERT INTO my_table; BP>}S|,I:EVt(1!5)DVND(gD>D~Pek}]#D ~PDVNT&ZmP# INGEST FROM FILE my_file.txt FORMAT DELIMITED ( $field1 INTEGER EXTERNAL, $field2 DATE ’mm/dd/yyyy’, $field3 CHAR(32) ) INSERT INTO my_table VALUES($field1, $field2, $field3); (g{2G>} BP>}ek}]D==kO;v>}`F,+VNIz_Vt# INGEST FROM FILE my_file.txt FORMAT DELIMITED by ’|’ ( $field1 INTEGER EXTERNAL, $field2 DATE ’mm/dd/yyyy’, $field3 CHAR(32) ) INSERT INTO my_table VALUES($field1, $field2, $field3); !TVN(eM VALUES Pm>} ZBP>}P,+mvgB(e: CREATE TABLE my_table ( c1 VARCHAR(32), c2 INTEGER GENERATED BY DEFAULT AS IDENTITY, c3 INTEGER GENERATED ALWAYS AS (c2 + 1), ); C'"vBP INGEST |n: }]F/5CLrMN< 109 INGEST FROM FILE my_file.txt FORMAT DELIMITED INSERT INTO mytable; v 1!VN(ePm+G: ( $C1 CHARACTER(32), $C2 INTEGER EXTERNAL, $C3 INTEGER EXTERNAL ) v INSERT odOD1! VALUES PmG: VALUES($C1, $C2, DEFAULT) k"b,Z}v5G DEFAULT,r*Q+T&ZVN $C3 DP(e* GENERATED ALWAYS#Q!TZDv5,r*C5;PVN# CZFcP5DnbVN>} BP>}k(g{2G>}`,,+;P0=vVNT&Z0=vmP (PROD_ID M DESCRIPTION),xZ}vmP (TOTAL_PRICE) D5+S# `}vVNxPFc INGEST FROM FILE my_file.txt FORMAT DELIMITED BY ’|’ ( $prod_ID CHAR(8), $description CHAR(32), $price DECIMAL(5,2) EXTERNAL, $sales_tax DECIMAL(4,2) EXTERNAL, $shipping DECIMAL(3,2) EXTERNAL ) INSERT INTO my_table(prod_ID, description, total_price) VALUES($prod_id, $description, $price + $sales_tax + $shipping); nd{VN>} BP>}S|,I:EVt(1!5)DVND(gD>D~Pek}]#D ~PDVNT&ZmP,+ZT&ZP 2 M 3 DVNkT&ZP 3 M 4 D VN.dfZnbVN# INGEST FROM FILE my_file.txt FORMAT DELIMITED ( $field1 INTEGER, $field2 CHAR(8), $filler1 CHAR, $field3 CHAR(32), $filler2 CHAR, $field4 DATE ) INSERT INTO my_table VALUES($field1, $field2, $field3, $field4); q=^N{>} BP>}SICzk3 850 D(gD>D~Pek}]#UZVNIC@=q =,V{MVN|(ZHEZ# INGEST FROM FILE my_file.txt FORMAT DELIMITED INPUT CODEPAGE 850 ( $field1 INTEGER EXTERNAL, $field2 DATE ’mm/dd/yyyy’, 110 }]F/5CLr8OMN< $field3 CHAR(32) ENCLOSED BY ’=’ ) INSERT INTO my_table VALUES($field1, $field2, $field3); ;C>} BP>}S|,;Z8(;CDVNDD~Pek}]#D~PDVNT&Z mP# INGEST FROM FILE my_file.txt FORMAT POSITIONAL ( $field1 POSITION(1:8) INTEGER EXTERNAL, $field2 POSITION(10:19) DATE ’yyyy-mm-dd’, $field3 POSITION(25:34) CHAR(10) ) INSERT INTO my_table VALUES($field1, $field2, $field3); DEFAULTIF >} K>}kO;v>}`F,+G1Z~vVNTUW*71,c!5CLra ek1!5: INGEST FROM FILE my_file.txt FORMAT POSITIONAL ( $field1 POSITION(1:8) INTEGER EXTERNAL, $field2 POSITION(10:19) DATE ’yyyy-mm-dd’ DEFAULTIF=’’, $field3 POSITION(25:34) CHAR(10) ) INSERT INTO my_table VALUES($field1, $field2, $field3); K>}kO;v>}`,,+1!8>{;Z}]P.sDPP: INGEST FROM FILE my_file.txt FORMAT POSITIONAL ( $field1 POSITION(1:8) INTEGER EXTERNAL, $field2 POSITION(10:19) DATE ’yyyy-mm-dd’ DEFAULTIF(35)=’’, $field3 POSITION(25:34) CHAR(10) ) INSERT INTO my_table VALUES($field1, $field2, $field3); `vdk4>} K>}S}v(gD>D~Pek}]: INGEST FROM FILE my_file.txt, my_file2.txt, my_file3.txt FORMAT DELIMITED ( $field1 INTEGER EXTERNAL, $field2 DATE ’mm/dd/yyyy’, $field3 CHAR(32) ) INSERT INTO my_table VALUES($field1, $field2, $field3); \@>} K>}S\@Pek}]: INGEST FROM PIPE my_pipe FORMAT DELIMITED ( $field1 INTEGER EXTERNAL, $field2 DATE ’mm/dd/yyyy’, }]F/5CLrMN< 111 $field3 CHAR(32) ) INSERT INTO my_table VALUES($field1, $field2, $field3); !n>} K>}S|,I:EVt(1!5)DVND(gD>D~Pek}]#D~ PDVNT&ZmP#C|n8(I DB2 \x(}g,IZ} K>}a"vxP8(ekw5j6D INGEST |n(1!ivBGIXBt/ D): INGEST FROM FILE my_file.txt FORMAT DELIMITED ( $field1 INTEGER EXTERNAL, $field2 DATE ’mm/dd/yyyy’, $field3 CHAR(32) ) RESTART NEW ’ingestcommand001’ INSERT INTO my_table VALUES($field1, $field2, $field3); g{C|nZjI.0U9,G4zIT9CBP|n4XBt/C|n: INGEST FROM FILE my_file.txt FORMAT DELIMITED ( $field1 INTEGER EXTERNAL, $field2 DATE ’mm/dd/yyyy’, $field3 CHAR(32) ) RESTART CONTINUE ’ingestcommand001’ INSERT INTO my_table VALUES($field1, $field2, $field3); XBt/U9>} K>}a"vkOfD“XBt/>}”`,D INGEST |n: INGEST FROM FILE my_file.txt FORMAT DELIMITED ( $field1 INTEGER EXTERNAL, $field2 DATE ’mm/dd/yyyy’, $field3 CHAR(32) ) RESTART NEW ’ingestcommand001’ INSERT INTO my_table VALUES($field1, $field2, $field3); 112 }]F/5CLr8OMN< g{C|nZjI.0U9"RzF.;XBt/C|n,G4zIT9CB P|ne}XBt/G<# INGEST FROM FILE my_file.txt FORMAT DELIMITED ( $field1 INTEGER EXTERNAL, $field2 DATE ’mm/dd/yyyy’, $field3 CHAR(32) ) RESTART TERMINATE ’ingestcommand001’ INSERT INTO my_table VALUES($field1, $field2, $field3); "vK|n.s,z+;YXBt/xPw5j6“ingestcommand001”D INGEST |n,+\;ZB INGEST |nD RESTART NEW N}P4CCV{.# XBErP>} K>}S|,I:EVtDVND(gD>D~Pek}]#Cm|,}P, "Rdk}]PVND3rkmPD3r`4# INGEST FROM FILE my_file.txt FORMAT DELIMITED ( $field1 INTEGER EXTERNAL, $field2 DATE ’mm/dd/yyyy’, $field3 CHAR(32) ) INSERT INTO my_table VALUES($field3, $field2, $field1); y> UPDATE"MERGE M DELETE >} BP>}a|Bdw|kdkD~P`&VN`{DmP# INGEST FROM FILE my_file.txt FORMAT DELIMITED ( $key1 INTEGER EXTERNAL, $key2 INTEGER EXTERNAL, $data1 CHAR(8), $data2 CHAR(32), $data3 DECIMAL(5,2) EXTERNAL ) UPDATE my_table SET (data1, data2, data3) = ($data1, $data2, $data3) WHERE (key1 = $key1) AND (key2 = $key2); r_ INGEST FROM FILE my_file.txt FORMAT DELIMITED ( $key1 INTEGER EXTERNAL, $key2 INTEGER EXTERNAL, $data1 CHAR(8), $data2 CHAR(32), $data3 DECIMAL(5,2) EXTERNAL ) UPDATE my_table SET data1 = $data1, data2 = $data2, data3 = $data3 WHERE (key1 = $key1) AND (key2 = $key2); K>}a+}]SdkD~O"=?jm#TZdw|VNkmP`{Ddk P,C>}a9CdkP4|BmP#TZd{dkP,C>}amSP=m P# }]F/5CLrMN< 113 INGEST FROM FILE my_file.txt FORMAT DELIMITED ( $key1 INTEGER EXTERNAL, $key2 INTEGER EXTERNAL, $data1 CHAR(8), $data2 CHAR(32), $data3 DECIMAL(5,2) EXTERNAL ) MERGE INTO my_table ON (key1 = $key1) AND (key2 = $key2) WHEN MATCHED THEN UPDATE SET (data1, data2, data3) = ($data1, $data2, $data3) WHEN NOT MATCHED THEN INSERT VALUES($key1, $key2, $data1, $data2, $data3); K>}a>}dw|kdkD~P`&w|VN`{DmP# INGEST FROM FILE my_file.txt FORMAT DELIMITED ( $key1 INTEGER EXTERNAL, $key2 INTEGER EXTERNAL ) DELETE FROM my_table WHERE (key1 = $key1) AND (key2 = $key2); 4= SQL >} },ZC>}P_P|, KEY"DATA M ACTION PDm#BP |na|Bdw|P (KEY) kdkD~P`&VN`{R ACTION PG“U” DmPD DATA P: INGEST FROM FILE my_file.txt FORMAT DELIMITED ( $key_fld INTEGER EXTERNAL, $data_fld INTEGER EXTERNAL ) UPDATE my_table SET data = $data_fld WHERE (key = $key_fld) AND (action = ’U’); BP>}kO;v>}`,,+1|%d"R ACTION PG“D”1,C>}a +PSmP>}: INGEST FROM FILE my_file.txt FORMAT DELIMITED ( $key_fld INTEGER EXTERNAL, $data_fld INTEGER EXTERNAL ) MERGE INTO my_table ON (keyl = $key_fld) WHEN MATCHED AND (action = ’U’) THEN UPDATE SET data = $data_fld WHEN MATCHED AND (action = ’D’) THEN DELETE; B;=v24 g{ INGEST |nI&jI,G4zIT4C(} RESTART NEW N}8(DV{.# g{ INGEST |n'\"Rz*XBt/C|n,G4zXk9C-<|nP8(DV {.48( RESTART CONTINUE !n# 114 }]F/5CLr8OMN< g{;rcXBt/Q'\D INGEST |n"R*e}XBt/mPDu?,kZ8( RESTART TERMINATE !nDivBXBKP INGEST |n# XBt/'\D INGEST Yw: g{ INGEST |nZjI.0'\,"Rz*XBt/C|n,kXB"vx RESTART CONTINUE !nD INGEST |n#KZ~v INGEST |naSns;vd5ct/,"R 2GIXBt/D# *<.0 CZX B t / ' \ D INGEST | n D C ' j 6 X k T X B t / U > m _ P SELECT"INSERT"UPDATE M DELETE X(# XZKNq 13v|n=oD~r\@)21,INGEST 5CLraO*C|nQjI#ZNNd{ ivB,INGEST 5CLr} BP INGEST |n'\: INGEST FROM FILE my_file.txt FORMAT DELIMITED ( $field1 INTEGER EXTERNAL, $field2 DATE ’mm/dd/yyyy’, $field3 CHAR(32) ) RESTART NEW ’ingestjob001’ INSERT INTO my_table VALUES($field1, $field2, $field3); DBA a|}G<# *<.0 U9'\D INGEST |nDC'j6XkTXBt/U>m_P SELECT M DELETE X(# }L *U9'\D INGEST Yw,kXB"v INGEST |n# 8(_PJ1V{.D RESTART TERMINATE N}# 116 }]F/5CLr8OMN< a{ XBt/D INGEST |njI.s,ITTsfD INGEST |n4C RESTART NEW V {.# >} BP INGEST |n'\: INGEST FROM FILE my_file.txt FORMAT DELIMITED ( $field1 INTEGER EXTERNAL, $field2 DATE ’mm/dd/yyyy’, $field3 CHAR(32) ) RESTART NEW ’ingestjob001’ INSERT INTO my_table VALUES($field1, $field2, $field3); DBA ;#{XBt/ INGEST |n,yT{G9CTB|n(K|n|( RESTART TER- MINATE N})xPU9: INGEST FROM FILE my_file.txt FORMAT DELIMITED ( $field1 INTEGER EXTERNAL, $field2 DATE ’mm/dd/yyyy’, $field3 CHAR(32) ) RESTART TERMINATE ’ingestjob001’ INSERT INTO my_table VALUES($field1, $field2, $field3); `SekYw I9C INGEST LIST r INGEST GET STATS |n4`S INGEST |nDxH# *<.0 *"v INGEST LIST M INGEST GET STATS |n,zh*%@D CLP a0,+XkZ KP INGEST |nDzwOKPb)a0# }L `SekYwD==P\`V: v *q!PX10}ZKPDyP INGEST |nDy>E",k9C INGEST LIST | n# v *q!PXX( INGEST |nr10}ZKPDyP INGEST |nD|`j8E", k9C INGEST GET STATS |n# v 9I9CSZ(}g,MON_GET_CONNECTION m/})4i/TB`S*X: – client_acctng – client_applname – appl_name – client_userid – client_wrkstnname }]F/5CLrMN< 117 >} TB>}T>K INGEST LIST |nD$Zdv: INGEST LIST Ingest job ID = DB21000:20101116.123456.234567:34567:45678 Ingest temp job ID = 1 Database Name = MYDB Input type = FILE Target table = MY_SCHEMA.MY_TABLE Start Time = 04/10/2010 11:54:45.773215 Running Time = 01:02:03 Number of records processed = 30,000 TB>}T>K INGEST GET STATS |nD$Zdv: INGEST GET STATS FOR 4 Ingest job ID = DB21000:20101116.123456.234567:34567:4567 Database = MYDB Target table = MY_SCHEMA.MY_TABLE1 Records/sec Flushes/sec Records/sec Flushes/sec since start since start since last since last Total records ---------------- ----------------- --------------- ---------------- ---------------- 54321 65432 76543 87654 98765 TB>}T>KgN9C MON_GET_CONNECTION m/}4q!Q^DDP}Md 5N}: SELECT client_acctng AS "Job ID", SUM(rows_modified) AS "Total rows modified", SUM(total_app_commits) AS "Total commits" FROM TABLE(MON_GET_CONNECTION(NULL, NULL)) WHERE application_name = ’DB2_INGEST’ GROUP BY client_acctng ORDER BY 1 Job ID Total rows modified Total commits ---------------------------------------------- ------------------- ------------- DB21000:20101116.123456.234567:34567:45678 92 52 DB21000:20101116.987654.234567:34567:45678 172 132 2 record(s) selected. INGEST 5CLr^FMV^T 9C INGEST 5CLr1,fZE;)&C*@D^F# IXBt/T v g{dk}]4`MQ|D,G4 INGEST 5CLrI\^(lb=C| D,"R+zIk'\D-<|n;,DdvP# m'V v INGEST 5CLr;'VT DB2 for Linux, UNIX and Windows m4PY w# v INGEST 5CLr;'VkTBPZ]DYw: – Q4(rywD+VY1m – `Mm – x`MS< 118 }]F/5CLr8OMN< dk`M"q=MP`M v INGEST 5CLr;'VBPP`M: – sTs`M(LOB"BLOB"CLOB M DBCLOB) – XML – a9/`M – _PC'(eD}]`MDP,C}]`MyZH0P>DNN`M v mb,INGEST 5CLrTzIP_PBP^F: – INGEST 5CLr;\T(e* GENERATED ALWAYS DPxP35# g{ INGEST |nPD SQL odG INSERT r UPDATE,x?jm_ P GENERATED ALWAYS P,G4}Gz4PBPdP;vYw,q rekr|BYw+'\ (SQL0798N) "R INGEST |nax: - S*|BDPDPmPT%CP# - Z INSERT r UPDATE odP,+ DEFAULT 8(*3xCPD5# – INGEST 5CLr;\+1!5MX(5DiO3x(e* GENER- ATED BY DEFAULT AS IDENTITY DP#g{ INGEST |nPD SQL odG INSERT r UPDATE,x?jm_P GENERATED BY DEFAULT AS IDENTITY P,G4}Gz4PBPdP;vYw,qrekr|B Yw+'\ (SQL0407N) "R INGEST |n+\xCG<: - S*|BDPDPmPT%CP# - Z INSERT r UPDATE odP,+ DEFAULT 8(*3xCPD5# - +Fca{@6;a* NULL Dmo=8(*3xCPD5#}g,g {mo=G $field1,G4 $field1 ZdkGekYw# v SET UTIL_IMPACT_PRIORITY |n;0l INGEST |n v util_impact_lim }]b\mwdCN};0l INGEST |n v }K CURRENT SCHEMA"CURRENT TEMPORAL SYSTEM_TIME M CURRENT TEMPORAL BUSINESS_TIME Tb,INGEST 5CLravT T4P SQL odP0lDs`}(CDfwDhC# ;c INGEST 5CLr^F v g{zek_P`vy>mDS<,G41dPDNNy>m\2+_T# $1,Xk9C`,D2+_T4#$b)y>m#(zT;ITC3)y >m&Z4#$4,,+G)\#$Dy>mXk9C`,D2+_T#) GF'V v g{ INGEST |n8(r_Z1!ivB8( RESTART NEW r RESTART CONTINUE !n,"R?jmGGFr|BGFDI|BS < , k 7 # * | , C G F D ~ q w ( e + DB2_TWO_PHASE_COMMIT ~qw!nhC*“Y”# }]F/5CLrMN< 119 v Z"v INGEST |n.0,;\9C SET SERVER OPTION 4tC= WNd5,bGr* SET SERVER OPTION |n;T CLP ,Sp wC,x INGEST |na("T:D,S#XkZ?mP,G 4IZ|BC MQT h*1d,yTT\aTx5M# Ps! TZPs!O!Dm,kvs commit_count ekdCN}DhC;TZPs! OsDm,ku! commit_count ekdCN}DhC# d{$w:X g{*9Cd{$w:X44P INGEST 5CLr,kvs commit_count } ]bdCN}DhC"u! commit_count ekdCN}DhC# INGEST 5CLrDzk3"bBn 1 INGEST 5CLr&mdk}]1,+f0}vzk3:&CLr(M'z)zk 3"dk}]zk3M}]bzk3# zk3 8(== 1!5 &CLr(M'z)zk3, Z CLP |nD~P9C (}10oT737( (}10oT737( dk}]zk3 INGEST | n O D INPUT CODEPAGE &CLrzk3 }]bzk3 Z CREATE DATABASE |nO8 ( 1208(Unicode D UTF-8 ` k) g{dk}]zk3k&CLrzk3;,,G4 INGEST 5CLraY1+&CLr zk32G*dk}]zk3,Tc DB2 +}]1SSdk}]zk3*;*}]b zk3#Z3)u~B,INGEST 5CLr^(2G&CLrzk3#ZKivB, INGEST 5CLraH+4(e* FOR BIT DATA DV{}]*;*&CLrzk 3,;sY+]x DB2#ZyPivB,g{4+P(e* FOR BIT DATA,G4 DB2 a+}]*;*}]bzk3# CLP |nD~zk3 INGEST 5CLrY( INGEST |nDD>IC&CLrzk3,.yxF# 120 }]F/5CLr8OMN< ?}b#?1 INGEST 5CLrh*HO INGEST |nP8(DV{.(}g, + DEFAULTIF V{kdk}]PDV{xPHO)1,INGEST 5CLra 4PNNX*Dzk3*;,T7#yHODV{.Z`,Dzk3P# INGEST 5CLrM DB2 <;aT.yxF#?4PNN*;# dk}]zk3 g{VNM|yZDmP<(e* FOR BIT DATA,G4 INGEST 5CLr M DB2 <;a4PNNzk3*;#}g,Y( INGEST |n+VN $c1 8 (xP C1,"RCVNMCP<(e* CHAR FOR BIT DATA#g{dkV N|, X’E9’,G4^[dk}]zk3r}]bzk3G24,DB2 }{wKbViv: v dk}]zk3* 819# v &CLrzk3* 850# v }]bzk3* 1208 (UTF-8)# v dk}]*“é”(xPXt{D“e”),CV{Zzk3 819 P* X’E9’,Z zk3 850 P* X’82’,Z UTF-8 P* X’C3A9’# BmT>K}]Z~qwODa{,|!vVN0/rPGq(e* FOR BIT DATA T0 INGEST 5CLrGqIT2G&CLrzk3: m 16. 1VNMP(e<(e* FOR BIT DATA 1DI\a{ VN(e P(e dk}](z k3 819) } ] Z INGEST 5C Lr+d*; =&CLrz k3 850 . sDa{ 1 INGEST 5 CLrIT2 G&CLrz k31}]Z ~qwODa { 1 INGEST 5CLr^( 2G&CLr zk31}] Z~qwOD a{ CHAR CHAR X’E9’ X’82’ X’C3A9’ X’C3A9’ CHAR FOR BIT DATA CHAR FOR BIT DATA X’E9’ X’E9’ X’E9’ X’E9’ CHAR FOR BIT DATA CHAR X’E9’ X’E9’ X’C3A9’ X’C39A’ (″Ú″) CHAR CHAR FOR BIT DATA X’E9’ X’82’ X’E9’ X’82’ ZDPPD}]G INGEST 5CLrZdIT2G&CLrzk31"MA DB2 DZ]#ZDPPD}]G INGEST 5CLrZd^(2G&CLrz k31"MDZ]#k"b,1VN(eMP(eD FOR BIT DATA tT ;,1,a{I\;,,gOmy># zk3ms g{dkzk3"&CLrzkr}]bzk3;`,,G4 INGEST 5CL rM/r DB2 +4Pzk3*;#g{ DB2 ;'VBPNNivBDzk3 * ; , G 4 INGEST 5 C L r a " v m s " R | n a x # }]F/5CLrMN< 121 m 17. BPivBh**; ZKivB,STB zk3*; *;= *;4P_ INGEST |n|,h* *;=dk}]zk 3DV{.r SQL j 6# &CLrzk3 dk}]zk3 INGEST 5CLr 5CLrIT+&C Lrzk3f2G* dk}]zk3# dkzk3 }]bzk3 DB2 5CLr^(2G& CLrzk3# dkzk3 &CLrzk3 INGEST 5CLr 5CLr^(2G& CLrzk3# &CLrzk3 }]bzk3 DB2 DB2 pureScale73PDekYw Z DB2 pureScale73P9C INGEST 5CLr1,h*: max(1, ((number of logical CPUs)/2)/(number of partitions) ) 2IT+KN}hC* 0,bm>yPVx9C;veULr# ?veULr: 1. 7(?vV<|Gq}C_P;v`&VNr#?5#bZBPivB+* true: v TZ INSERT od,PPm|,?vV<|,"RTZ?vV<|,VALUES P mPD`&n?GVN{r#?# v TZ UPDATE r DELETE od,WHERE =JtZCq= 122 }]F/5CLr8OMN< (dist-key-col1 = value1) AND (dist-key-col2 = value2) AND ... (dist-key-coln = valuen) [AND any-other-conditions] dP dist-keycol1 = dist-key-coln GyPV<|,"R?v value GVN{r# ?# v TZ MERGE od,Qwu~_PH0* UPDATE M DELETE T>Dq=# 2. g{?vV"|}CP;vT&VNr#?5,G4 INGEST 5CLr9CCV< |47(VxE,;s+G<7IACVxDdP;veULr# ":ZBPivB,INGEST 5CLr;a7(G}P,1Y|P 2 A 8: UPDATE my_table SET data = $data WHERE (key1 = $key1) AND (key9 = $key9); v ;vV<|T&Z`vVNr5,gTB>}y>: UPDATE my_table SET data = $data WHERE key1 = $key11 OR key1 = $key12; v ;vV<|T&Z;vmo=,gTB>}y>: INGEST FROM FILE ... INSERT INTO my_table(dist_key, col1, col2) VALUES($field1 + $field2, $col1, $col2); v V"|PD`M* DB2SECURITYLABEL# v kV"|`T&DVN_P}V`M,+V"|P`MGm;}V`Mr__P ;,+Hr!};# y> INGEST 5CLrE> IT9C INGEST 5CLry>E>4ZPBD~*&m1T/`4BD INGEST | n# y>E> ingest_files.sh G;v shell E>,|T/liBD~"zI INGEST | n4&mb)D~#CE>43r4PBPNq: 1. li?+Kv# ":CE>Y(8(D?# kT73^DCE> IT9C ingest_files.sh E>w*zT:DE>Dy!#TBGzXkTCE>wv DX*^D: v +y>5(4,}]b{FMm{)f;*zT:D5 v +y> INGEST |nf;*zT:D|n }]F/5CLrMN< 123 v 4(CE>P8(D?< CE>&m|,}]DD~Tnd%vm#*nd`vm,ITT*ndD?vmX 4CzF,r_9CzF;c/T&m`vm# y>=8 D5P|,K;vy>=8,T5wgN9y>E>JOZzD}]Vb4T/zI BD INGEST |n# =8:9C INGEST 5CLr&mD~w BP=8T>KgN+}]VbdCIT/ekxPPD}]D~w# Jb:Z3)}]VbP,D~+l,CZT/liBD~"zIBD INGEST |n"KP C|n#ingest_files.sh GK`E>D;vy>#z9h*4( crontab u?E\8 ( Shell E>&CKPD5J# ZC'5VKzF(4,E>M chrontab u?)T&mD~w.0,C'h*zcBP Hvu~M@5X5: v Z?j}]bPQ4(K?jm v INGEST 5CLrQI)9C(4,QZM'zO20"hCKC5CLr) v Q(}9CbTD~4V/KP INGEST |n,8(C|n"TdxPKi$ v Q4( INGEST |nP}CDTs(}g,l#m) v QZKP INGEST 5CLrD53O4(K crontab D~ v C'_PCZ4(dkD~"+dF=E>y9CD4?: a. f;BPy>Ddk5,T43C'D5: v INPUT_FILES_DIRECTORY v DATABASE_NAME v SCHEMA_NAME v TABLE_NAME v SCRIPT_PATH b. f;y> INGEST |n c. +E>mf* populate_table1_script 2. C'mS;vu?= crontab D~,T8(E>*KPD5J#r*C'*CE>? VSKP;N"?l 24 !1KP"?jPD?;l# 124 }]F/5CLr8OMN< d{}]F/!n (}9C ADMIN_MOVE_TABLE }L4T*z==F/m I(}9C ADMIN_MOVE_TABLE }L4T*zrQz==F/m#g{`TZI >"Ud"F/T\MBq*z,z|XSICT,k9CmD*zF/x;GmD QzF/# *<.0 k7#Pc;DELUd4]ImMw}D1>"G(mT0=SU>u?# XZKNq I(}wCf"}L;Nr`N4T*z==F/m,C}L4PD?vYw#Z4FW NZd,a9C%"w46qT4mD|D(|B"ekr>})"+dEC=G( mP#14FWNjIs,aT0S1>XEG(mP6qD|D#.s,f"}L a8Y94mQz"+4m{FMw}{F8(x0S1>0dw}#;s,90S m*z,Sxf;4m#1!ivB,a>}4m,+IT9C KEEP !n4Tm;v {F#tC4m# TZ;xw}(XpG(;w})Dm,k;*4P*zF/#T;x(;w}Dm 4P*zF/I\} >} 1:Z;9 T1 QzDivB,+ T1 mS#= SVALENTI F= ACCOUNT- ING mUdP#8( DATA"INDEX M LONG mUdT+mF/=BDmUd# CALL SYSPROC.ADMIN_MOVE_TABLE( ’SVALENTI’, ’T1’, ’ACCOUNTING’, ’ACCOUNTING’, ’ACCOUNTING’, ’’, ’’, ’’, ’’, ’’, ’MOVE’) >} 2:Z;9 T1 QzDivB,+ T1 mS#= EBABANI F= ACCOUNTING mUdP,"RZF/s#t-#9C COPY_USE_LOAD M LOAD_MSGPATH !n4hC0k{"D~76#8( DATA"INDEX M LONG m UdT+mF/=BDmUd#-} 3:Z,;mUdPF/ T1 m#+ T1 PD C1 P(9C;FvD}]`M LONG VARCHAR)|D*9Cf]D}]`M# CALL SYSPROC.ADMIN_MOVE_TABLE( ’SVALENTI’, ’T1’, ’’, ’’, ’’, ’’, ’’, ’’, ’C1 VARCHAR(1000), C2 INT(5), C3 CHAR(5), C4 CLOB’, ’’, ’MOVE’) ":ZKYwZd;\|DP{# >} 4:z(}TBod4( T1 m: CREATE TABLE T1(C1 BIGINT,C2 BIGINT,C3 CHAR(20),C4 DEC(10,2),C5 TIMESTAMP,C6 BIGINT GENERATED ALWAYS AS (C1+c2),C7 GRAPHIC(10),C8 VARGRAPHIC(20),C9 XML Z,;mUdZF/Cm,">}P C5 M C6: CALL SYSPROC.ADMIN_MOVE_TABLE( ’SVALENTI’, ’T1’, ’’, ’’, ’’, ’’, ’’, ’’, ’c1 BIGINT,c2 BIGINT ,c3 CHAR(20),c4 DEC(10,2),c7 GRAPHIC(10), c8 VARGRAPHIC(20),c9 XML’, ’’, ’MOVE’) >} 5:zD6'Vxm_PmUd TS1 M TS2 P(eD=v6'#+CmFAmU d TS3,+#t TS1 PDZ;v6'# CREATE TABLE "EBABANI "."T1" ( "I1" INTEGER , "I2" INTEGER ) DISTRIBUTE BY HASH("I1") PARTITION BY RANGE("I1") (PART "PART0" STARTING(0) ENDING(100) IN "TS1", PART "PART1" STARTING(101) ENDING(MAXVALUE) IN "TS2"); + T1 mS#= EBABANI FA TS3 mUd#8(Vx(e# DB2 "CALL SYSPROC.ADMIN_MOVE_TABLE (’EBABANI’, ’T1’, ’TS3’, ’TS3’, ’TS3’, ’’, }]F/5CLrMN< 127 ’’, ’(I1) (STARTING 0 ENDING 100 IN TS1 INDEX IN TS1 LONG IN TS1, STARTING 101 ENDING MAXVALUE IN TS3 INDEX IN TS3 LONG IN TS3)’, ’’, ’’, ’MOVE’)" IBM 4F$_(4i~) IBM a)K=Vw*D4Fbv=8:Q 4FM SQL 4F# Q 4FDw*i~* Q Capture LrM Q Apply Lr#SQL 4FDw*i~* Cap- ture LrM Apply Lr#b=V`MD4F<2m“4F(/`Sw”$_#IT9C4 FPDM ASNCLP |nPLr4hC"\mb)4Fi~# TBPmr*EvKb)4Fi~: Q Capture Lr A! DB2 V4U>"iRT DB2 4mywD|D,;s+Qd5D4}]*;*I T XML q="Tq!TQ"aD4mrSD#e# }L v 9C ADMIN_COPY_SCHEMA }LZ,;}]bP4F%v#=# v + db2move 5CLrk -co COPY YwdO9C,Tc+4}]bPD;vr`v #=4F=?j}]b# 4#=PDs?V}]bTs;4F=B#=BD?j}] b# JOoOa> ADMIN_COPY_SCHEMA }LM db2move 5CLrD?vm<"v SET INTEG- RITY od,T9?vmlb=;\'VDTs`M#COPY YwT +I&;G#a+Cmw*#fmXB 4(# ;,D5} g{4}]bk?j}]b;Z,;5}P,G4XkT4}]bxP`?# SCHEMA_MAP !n 9C SCHEMA_MAP !n48(?j}]bODd{#={F1,4F#=Y w+vTTs(eod4Pn!LHDbv,Tc+-<#={Ff;*B# ={F#}g,Z SQL }LDZ]PvVD-<#=DNN5}y;af;* B#={F#rK,4F#=YwI\^(XB4(b)Ts#d{>}I\ |(G(m"a{mM_e/i/m#jI4FYws,I9CmsD~PD DDL 4V/XB4(b)'\DTs# Ts.dD`%@5T 4F#=Yw"TTzcb)Ts.dD`%@5TD3r4XB4(Ts# }g,g{m T1 |,D3;P}CKC'(eD/} U1,G4+HXB4( U1,;sYXB4( T1#+G,?Db)}LGqQI&XXB 4(# PX|`E",kND ADMIN_COPY_SCHEMA }LM db2move 5CLr# 9C db2move 5CLrD#=4FD>} + db2move 5CLrk -co COPY YwdO9C,Tc+4}]bPD;vr`v#= 4F=?j}]b#Z("#M#=s,IT+|Cw4(Bf>D#e# >} 1:9C -c COPY !n TBG db2move -co COPY !nD;v>},|+#= BAR Sy>}]b4 F=?j}]b"+|X|{* FOO: db2move sample COPY -sn BAR -co target_db target schema_map "((BAR,FOO))" -u userid -p password 4(DB(?j)#=Tsk4#=PDTsDTs{`,,+0__P?j #=^({#IT4(xPr;xP4mPD}]Dm1>#4}]bM?j }]bITZ;,53O# >} 2:Z COPY YwZd8(mUd{F3d TB>}5wgNZ db2move COPY YwZd8(*9CDX(mUd{F3 130 }]F/5CLr8OMN< d,x;G453PDmUd#I8( SYS_ANY X|V48>&9C1!m Ud!qc(4!q?jmUd#Z>>}P,db2move 5CLr!q*Cw? jDNNICmUd: db2move sample COPY -sn BAR -co target_db target schema_map "((BAR,FOO))" tablespace_map "(SYS_ANY)" -u userid -p password SYS_ANY X|VICZyPmUd,r_ITT;)mUd8(X(3d," Td`mUd8(1!mUd!qc(: db2move sample COPY -sn BAR -co target_db target schema_map " ((BAR,FOO))" tablespace_map "((TS1, TS2),(TS3, TS4), SYS_ANY)" -u userid -p password b8>mUd TS1 3dA TS2 T0 TS3 3dA TS4,+d`mUd9C1 !mUd!qc(# >} 3:Z COPY Yws|DTsyP_ ZI&4P COPY Yws,IT|DZ?j#=P4(D?vBTsDyP _#?jTsD1!yP_G,SC'#g{8(KK!n,G4yP(+* FxBDyP_,gBy>: db2move sample COPY -sn BAR -co target_db target schema_map "((BAR,FOO))" tablespace_map "(SYS_ANY)" owner jrichards -u userid -p password ?jTsDByP_G jrichards# g{4#=M?j#=;Z;,D53O,G4XkZ?j53OwC db2move 5CLr#*+#=S;v}]b4FAm;v}]b,KYwh*+S4} ]b4FD#={FPm(C:EVt)M?j}]b{# *4F#=,kSYw53|na>{P"v db2move,gBy>: db2move dbname COPY -co COPY-options -u userid -p password db2move - }]bF/$_ T EXPORT"IMPORT r LOAD ==9CK$_1,+cZZ$w>OD DB2 }]b. dF/s?Dm#1T COPY ==9CK$_1,|+cZ4F#=# C$_+i/X(}]bD53?X DB2 } ]b;2IT+|G+dAm;v$w>=(,;sDyPm#TZX(Z IMPORT DYw,k9C -io !n# LOAD 0kZ?G(D~ db2move.lst PyP>DyPm#TZX(Z LOAD DYw,k9C -lo !n# COPY +#=4F=?j}]bP#?j}]bXkG>X}]b#9C -sn !n48(;Vr`V#=#PXX(Z COPY D!n,kND -co ! n#9C -tn r -tf !n,T LOAD_ONLY ==}Km#9C ADMIN_COPY_SCHEMA() f"}Lr_+ db2move 5CLrk -COPY !ndO9C1,Xk9C{* SYSTOOLSPACE DmUd# kNDTB?VTq!Z4P?nYwZdzIDD~DPm# -tc table-definers 1!5GyP(eLr# b;G;n EXPORT Yw#g{8(KK!n,G4;aD( eLry4(DG)m#g{48(K!n,G41!ivG9CyP(eL r#18(`v(eLr1,Xk+|GC:EVt*;(eLrj6.d; JmfZUq#IT+K!nk -tn table-names !n;pC4!q**“4 ^(”R -sn !n&CZ}K#=# TZm{1&CC |GD#=^({IC ″schema″.″table″ q=# -sn schema-names JCZ EXPORT D1!5GyP#=(+;JCZ COPY)# g{8(KK!n,G4+; vm,"R?vm<&Gj}: "SCHEMA1"."TABLE NAME1" "SCHEMA NAME77"."TABLE155" g{k COPY Yw;p8(,G49Xk8( -co ″MODE″ LOAD_ONLY copy- option,"R+vZ?j}]bOXBndG)ZD~P8(Dm#P>m{ 1&CC|GD#=^({IC ″schema″.″table″ q=# -io import-option 1!5* REPLACE_CREATE#kND“;Fv9C IMPORT |n!n CREATE M REPLACE_CREATE”TKb IMPROT CREATE /}DV^T# }]F/5CLrMN< 133 P'!n|(:INSERT"INSERT_UPDATE"REPLACE"CREATE M REPLACE_CREATE# -lo load-option 1!5* INSERT# P'!n*:INSERT M REPLACE# -co 1 db2move Yw* COPY 1,Itf -co .s8(BP!n: “TARGET_DB db name [USER userid USING password]” JmC'8(?j}]bD{F"C'j6M\k#(IT9CVP D -p M -u !n48(4}]bC'j6M\k)#USER USING S dGI!Sd#g{ USER 8(KC'j6,G4XkZ USING Sd sfa)\k,r_,g{48(\k,G4 db2move +a>dk\ kE"#.yTa>zdk\kE",Gr*TB?VyV[D2+ T-r#TZ COPY Yw,TARGET_DB G;vXk!qD!n# TARGET_DB ; \ k 4 } ] b ` , , " R X k G > X } ] b # ADMIN_COPY_SCHEMA }LITCZ4F,;}]bPD#=#COPY Yw*sAYdk;V#= (-sn) r;vm(-tn r -tf)# KP`v db2move |nT+#=S;v}]b4F=m;v}]b1 +}#=0kC#=X*DyPTs# “NONRECOVERABLE” K!nJmC'2G*9C COPY-NO 4jID0kYwD1!P*# Z1!P*B,+?FC'**0k=D?vmUdzI8]#18 (K NONRECOVERABLE X|V1,+;a?FC'"4zImUdD8 ]#+G,?R(iz!lzI8],T7#I}7XV4B4(D m#bG;vCZ COPY YwDI!!n# “OWNER” ZI&4P COPY Yws,JmC'|DZ?j#=P4(D?vB TsDyP_#?jTsD1!yP_+G,SC';g{8(KK !n,G4a+yP(*FxBDyP_#bG;vCZ COPY YwD I!!n# “TABLESPACE_MAP” Z4FZd,C'I8(*9CDmUd{F3d,x;G453P DmUd#b+G;)mUd3dD}i,"C(E(p4#}g, tablespace_map ((TS1, TS2),(TS3, TS4))#bb6Ea+mUd TS1 PDyPTs4F=?j}]bODmUd TS2,x+mUd TS3 P DTs4F=?jODmUd TS4#TZ ((T1, T2),(T2, T3)),+Z ?j}]bOD T2 PXB4(Z4}]bOD T1 PR=DyPT s,xZ?j}]bOD T3 PXB4(Z4}]bOD T2 PR=D yPTs#1!ivG9Ck4}]bPDmUd{`,DmUd {#ZKivB,;h*KmUdDdk3d#g{8(DmUd; fZ,G44F9CCmUdDTs+'\,"RaG<=msD~ P# C'9IT!q9C SYS_ANY X|V48>&9C1!mUd!qc (4!q?jmUd#ZKivB,db2move +\;!qNNICmU d 4 C w ? j # SYS_ANY X | V I CZy P m U d # > } : tablespace_map SYS_ANY#mb,C'ITT;)mUd8(X(3 d , " T d ` m U d 8 ( 1 ! m U d ! q c ( # } g : tablespace_map ((TS1, TS2),(TS3, TS4), SYS_ANY)#b8>mUd TS1 3dA TS2 T0 TS3 3dA TS4,+d`mUd+9C1!m Ud?j#IZ;I\P;vT“SYS”*7DmUd,rK+9C SYS_ANY X|V# bG;vCZ COPY YwDI!!n# }]F/5CLrMN< 135 “PARALLEL”number-of-threads 8(K!nI9#=PmD0kYwZ;(}?D_LP+%#number- of-threads 5D6'G 0-16 v g{48( PARALLEL,G4;a9CNN_LRa,x4P0k Yw# v g{Z;P;(}?D_LDivB8( PARALLEL,G4 db2move 5CLr+!q`&D5# v g{8( PARALLEL,Ra) number-of-threads,G4a9C8( _LD}?#g{ number-of-threads G 0 r 1,G4a,x4P0 kYw# v IT* number-of-threads 8(Dns5G 16# bG;vCZ COPY YwDI!!n# -l lobpaths TZ IMPORT M EXPORT,g{8(KK!n,G4|9+CZ XML 76#1 !5G10?<# K!n8(+4((w* EXPORT D;?V)rQw(w* IMPORT r LOAD D ;?V)LOB r XML D~DxT76{#18(`v761,Xk+|GC :EVt*;76.d;JmfZUq#g{8(K`v76,G4 EXPORT + T-7==9Cb)76#|a+;v LOB D54kZ;v76,+B;v LOB D54kZ~v76,TK`F,1=4kns;v76,;sV*<4 kZ;v76#TZ XML D5,iv`gK#(Z IMPORT r LOAD Zd) g{ZZ;v76PR;=D~,G4+9CZ~v76,TK`F# -u userid 1!5GQGzdk\k#byvG*K2+p{#(}|nPdk\kazz2+T Jb#}g,ps -ef |nMa+\kT>v4#+G,g{(}E>wCK db2move,G4+Xka)\k#g{Zk6L~qw`,DM'zO"v| n,G4&8(C'j6M\k# -aw Jm/f#g{48( -aw,G4Z} v *}vJCZ Windows Yw53),k"vTB|n: db2move sample import -l D:\LOBPATH1,C:\LOBPATH2 v *0k SAMPLE }]bPDyPm(+Z /home/userid/lobpath S?}vJCZ Linux M UNIX 53),k"vTB|n: db2move sample load -l /home/userid/lobpath,/tmp v *9C8(DC'j6M\kT REPLACE ==X==KP LOAD |n# v 9C db2move LOAD RT}]b(C}]bIV4)tCK logarchmeth1 1: }]F/5CLrMN< 137 – g{48( NONRECOVERABLE !n,G4+9C1! COPY NO !n db2move wC db2Load API,"RZC5CLrjI1,a+0kmyZDmUdCZ“8]]R ”4,(Xk4P}]brmUdj+8],E\9mUdQk“8]]R”4 ,)# – g{8(K NONRECOVERABLE !n,G4;a+mUdCZ“8]]R”4,,+G, g{Ts4PK0vV4,G4m+jG*;ICJRXk>}#PX“0kIV 4T”!nD|`E",kND“CZa_0kT\D!n”# v I(}Dd1!:eX IBMDEFAULTBP 0(}|BdCN} sortheap" util_heap_sz"logfilsiz M logprimary 4a_8(K IMPORT r LOAD YwD db2move |nDT\# v KP}]F/5CLr(}g,export M db2move)1,i/`kwI\a7(T MQT(ky>m`H)4PWci/|P'J#ZbVivB,i/+kT"BS YD MQT 4P,"R5CLrDa{I\;a<7Xm>WcmPD}]# v db2move |nZ DB2 M'zO;IC#g{SM'z"v db2move |n,G4z+ aU=TBms{":db2move is not recognized as an internal or external com- mand, operable program or batch file#*K\bKJb,IT1SZ~qwO" v db2move |n# 9C EXPORT 1h*D/zIDD~ v dk:^# v dv: EXPORT.out EXPORT YwDc\a{# db2move.lst -}D~r?<|nzzD53{"#v 14P EXPORT Yw"R8(K LOB 761,E9CK{"D~# 9C IMPORT 1h*D/zIDD~ v dk: 138 }]F/5CLr8OMN< db2move.lst EXPORT YwzzDdvD~# tabnnn.ixf EXPORT YwzzDdvD~# tabnnnc.yyy EXPORT YwzzDdvD~# v dv: IMPORT.out IMPORT YwDc\a{# tabnnn.msg `&mD44PX(r4- 4PX(r4-Yw1,Xk8(8]3qPf"Dom]wD;C,"RXk*? v*DdDmUda);ij{D]w# *<.0 v1H0Q9C DB2 BACKUP 5CLr8]K}]b1,E\4PX(r4-# XZKNq v g{}]bfZ,zXk\;,SAC}]bE\zIE>#rK,g{}]bh *}6r@#V4,G4XkZ"TzIX(r4-E>.0xPKYw# v g{}ZVx}]b73P$w,"R?j}]b;fZ,G4;\KPC|n4 ZyP}]bVxO,1zIX(r4-E>#`4,;N;\Z;v}]bVx OKPCZzIX(r4-E>D|n,S?# v Z"v RESTORE DATABASE |nTzIE>1,498(K REPLACE EXISTING N}, E>PvVD REPLACE EXISTING N}2a;"Mt# v *Ka_2+T,\k;avVZzIDE>P#zh*V/dk\k# v 4-E>|(z4-D?vmUdDf"wiX*# }L *9CE>44PX(r4-: 1. 9C RESTORE 5CLr4zIX(r4-E># IT(}|nP&mw (CLP) r db2Restore &CLr`LSZ (API) 4wC RESTORE 5CLr# TBG8(K REDIRECT N}M GENERATE SCRIPT N}D RESTORE DATABASE |n5}: db2 restore db test from /home/jseifert/backups taken at 20050304090733 redirect generate script test_node0000.clp K|n+ZM'zO4({* test_node0000.clp DX(r4-E># 2. ZD>`-wPr*X(r4-E>TxPyhD^D# IT^D: v 4-!n v T/f"76 v ]w# }g: db2 -tvf test_node0000.clp RESTORE DATABASE RESTORE DATABASE |nXB4(Qp5rY5D}]b,C}]bQ9C DB2 BACKUP 5CLrxP8]#4-D}]bk4(8]1>1y&D4,`,# K5CLr9IT4PBP~q: 140 }]F/5CLr8OMN< v 9Cm;3q42G}]br+8]1>4-AB}]b# v DB2 V9.8 PD4-5CLr^(CZ4-NNd{ DB2 m~f>O8]D8]3 q# v 4- DB2 V9.7 PZ DB2 V9.5 O8]D8]3q# – g{h*}]b}6,G4+Z4-Ywax1T/TdxPwC# v g{Z8]Yw1tCK}]bTxP0vV4,IZI&jI4-YwswC ROLLFORWARD 5CLr+C}]bD4,V4*T0D4,# v 4-mUd6p8]# v 9C TRANSPORT !n(Z DB2 V9.7 FP2 M|_f>D^)|P)+}]b8]3 qPD;imUd"f"iM SQL #=+dA}]b#Z DB2 pureScale 73P; 'V TRANSPORT !n# v g{"vK|n1C}]b{FfZ, G4|+f;MXB(eyPf"wi(Zz z8]3q1MfZ),}GIC'X(r# PX;,Yw53M2~=(.dD DB2 }]b53'VD4-YwDE",kND 6}]V4k_ICT8OMN<7PD:;,Yw53M2~=(.dD8]k4 -Yw;# 1Yw53rVs!(32 ;r 64 ;)fZnp1,;\4-v?3qrv6qkH0 3qDnpD3q(F*“nl3q”)# ZS;v73I&4-=m;v73s,ZxPGv?8]0,;JmxPv?8] rnl8]#(TZZ`,73P4P4-YwDiv,G4;fZbyDV^ T#) 49S;v73I&4-Yw=m;v73P,2h*"b:Lr|Z9C0XkX Bs((9C BIND |n"REBIND |nr db2rbind 5CLr);Xk>}"XB4( SQL }L;XkZB=(OX9yPb?b#(TZ4-=,;73Div,G4;f ZbyD"bBn#) kTVP}]bMVP]w4PD4-Yw4C`,D]wMmUd3d# kTB}]b4PD4-YwXBqCyP]w"X(E/DmUd3d#kT1Y ;vr`v]wDVP}]b4PD4-Yw2aXBqCyP]w"X(E/Dm Ud3d# wCr K|n;0lTd4PC|nDZc# z^(*z4- SYSCATSPACE# (^ *4-=VP}]b,k9CBPdP;n(^: v SYSADM v SYSCTRL v SYSMAINT }]F/5CLrMN< 141 *4-=B}]b,k9CBPdP;n(^: v SYSADM v SYSCTRL XhD,S S4-Yw`MD;,,yh,S2aPy;,: v *4-=VP}]b,h*}]b,S#K|nT/("k8(}]bD%b, S# v *4-=B}]b,h*5}M}]b,S#4(}]bh*5},S# *4-=;,Z105}D5}ODB}]b,XkWHkB}]b+$tD5} `,S#B5}I*>X5}r6L5}#105}GI DB2INSTANCE 73d?D5 (eD# v *xPlU4-,h*5}M}]b,S# |no( RESTORE DATABASE DB source-database-alias restore-options CONTINUE ABORT restore-options: USER username USING password REBUILD WITH ALL TABLESPACES IN DATABASE ALL TABLESPACES IN IMAGE EXCEPT rebuild-tablespace-clause rebuild-tablespace-clause TABLESPACE , ONLINE ( tablespace-name ) SCHEMA , ( schema-name ) HISTORY FILE COMPRESSION LIBRARY LOGS INCREMENTAL AUTO AUTOMATIC ABORT USE TSM open-sessions options XBSA SNAPSHOT LIBRARY library-name LOAD shared-library open-sessions options , FROM directory device TAKEN AT date-time TO target-directory DBPATH ON target-directory ON path-list DBPATH ON target-directory TRANSPORT STAGE IN staging-database USING STOGROUP storagegroup-name 142 }]F/5CLr8OMN< INTO target-database-alias LOGTARGET directory DEFAULT EXCLUDE INCLUDE FORCE NEWLOGPATH directory DEFAULT WITH num-buffers BUFFERS BUFFER buffer-size REPLACE HISTORY FILE REPLACE EXISTING REDIRECT GENERATE SCRIPT script PARALLELISM n COMPRLIB name COMPROPTS string WITHOUT ROLLING FORWARD WITHOUT PROMPTING rebuild-tablespace-clause: , TABLESPACE ( tablespace-name ) open-sessions: OPEN num-sessions SESSIONS !n: OPTIONS ″options-string″ @ file-name |nN} DATABASE source-database-alias y]d("8]D4}]bDp{# CONTINUE 8(QXB(eK]w,R&4P“X(r4-”YwPDns;=# ABORT KN}: v #9“X(r4-”Yw#1"zh*X4;vr`v=hDms1,KN} \PC#"v8(K ABORT !nD RESTORE DATABASE s,XkX4“X( r4-”YwD?;=,|(8(K REDIRECT !nD RESTORE DATABASE# v Zv?4-YwjI0+dU9# USER username j64-}]b1*9CDC'{# USING password CZO$C'{D\k#g{!TK\k,G4+a>C'dk# REBUILD WITH ALL TABLESPACES IN DATABASE Z4-3q1,9+4-}]b0dQ*DyPmUd#g{}]bQfZ, G4K4-+2GC}]b# }]F/5CLrMN< 143 REBUILD WITH ALL TABLESPACES IN DATABASE EXCEPT rebuild-tablespace- clause Z4-3q1,9+4-}]b0dQ*DyPmUd,PmP8(D}]b }b#g{}]bQfZ,G4K4-+2GC}]b# REBUILD WITH ALL TABLESPACES IN IMAGE 4-*4-D3qPvxPmUdD}]b#g{}]bQfZ,G4K4- +2GC}]b# REBUILD WITH ALL TABLESPACES IN IMAGE EXCEPT rebuild-tablespace- clause 4-*4-D3qPvxPmUdD}]b,PmP8(D}]b}b#g{ }]bQfZ,G4K4-+2GC}]b# REBUILD WITH rebuild-tablespace-clause 4-vxP;i8(DmUdD}]b#g{}]bQfZ,G4K4-+2 GC}]b# TABLESPACE tablespace-name CZ8(*4-DmUdD{FPm# g{8( TRANSPORT !n,G4h*mUd{F# SCHEMA schema-name CZ8(*4-D#=D{FPm# g{8( TRANSPORT !n,G4h*#={F#v18(K TRANSPORT !n, SCHEMA !nEP'# ONLINE KX|V;IZ4PmUd6D4-Yw1&C#8(CX|VI*z4-8 ]3q#bb6EZT8]3qxP4-1,d{zmxLI,SA}]b, x4-8(DmUd1,d{mUdPD}]+GICD# HISTORY FILE 8(KX|V,TS8]3qP;4-z7GD~D/O#g{8]3q;| ,NNU>D~,G44-Yw+'\#g{8(KK!n,G49Xk8( LOGTARGET !n# INCREMENTAL ;h*d{N},9C INCREMENTAL 4I8(V/[}4-Yw#ZV/4- Zd,C'XkT4-f0D?v3qV/"v?v4-|n#4UTB3r jIKYw:ns;v"Z;v"Z~v"Z}v,TK`F,"R|(ns ;v3q# INCREMENTAL AUTOMATIC/AUTO 8(T/[}4-Yw# INCREMENTAL ABORT 8(}ZxPDV/[}4-Ywl#P9# USE 144 }]F/5CLr8OMN< TSM 8(9C Tivoli Storage Manager (TSM) w*?jh84-}]b# XBSA 8(+9C XBSA SZ#“8]~q API”(XBSA)G;v*ED&C Lr`LSZ,Ih*}]f"\mD&CLrr$_xP8]ri 519C# SNAPSHOT 8(+SlU8]4-}]# ;\+ SNAPSHOT N}kTBN;N}dO9C: v INCREMENTAL v TO v ON v DBPATH ON v INTO v NEWLOGPATH v WITH num-buffers BUFFERS v BUFFER v REDIRECT v REPLACE HISTORY FILE v COMPRESSION LIBRARY v PARALLELISM v COMPRLIB v OPEN num-sessions SESSIONS v HISTORY FILE v LOGS mb,;\+ SNAPSHOT N}kNNf0=mUdPmD4-Yw(| ( REBUILD WITH !n);p9C# SlU8]3q4-}]1D1!P*GT9I}]bDyP76 (|(yP]w">Xm? (TZyPlU4-,LOGTARGET EXCLUDE G1!5,}GT=yw LOGTARGET INCLUDE)#g{a)K1dAG,G4+4-ClU8]3 q# LIBRARY library-name /I= IBM }]~qwDGJCZBPf"w2~D DB2 ACS API }/Lr: v IBM TotalStorage SAN Volume Controller v IBM Enterprise Storage Server®ME 800 v IBM System Storage® DS6000™ v IBM 53f"w DS8000® v IBM 53f"w N 5P v NetApp V 5P v NetApp FAS }]F/5CLrMN< 145 g{z_Pd{f"w2~T0JCZCf"w2~D DB2 ACS API }/Lr,G4zIT9C LIBRARY N}48( DB2 ACS API }/Lr# LIBRARY N}D5GbDjC'Ekm;Ex# P'Dl&!n*: c Lx - Lx9CzIK/f{"Dh8(}g,Z0OBExsL x)# d h8U9 - ;#99CzIK/f{"Dh8(}g,Z;Pd{Ex 1U9)# t U9 - ZC'4P3)I5CLrksDYw'\s,l#P94-Y w# LOAD shared-library 2mb(Z Windows Yw53O* DLL)D{F,C2mb|,*9CD) &L8]k4- I/O /}#C{FI|,j{76#g{4a)j{76,C 5+1!*C'vZLryZD76# TAKEN AT date-time }]b8]3qD1dAG#1dAGZI&jI8]YwsT>,"RG8 ]3qD76{D;?V#Tq= yyyymmddhhmmss 8(#9I8(?V1d AG#}g,g{fZ1dAGVp* 20021001010101 M 20021002010101 D = v ; , 8 ] 3 q , G 4 8 ( 20021002 + a < B 9 C 1 d A G * 20021002010101 D3q#g{48(KN}D5,4iJOXk;P;v8] 3q# TO target-directory KN}m>?j}]b?<#g{5CLr4-=;vVP}]b,+vTK N}#8(D}/wM?XD#g{8]3q|,tCKT/f" wD}]b,G4v|D}]b?<,x;|Dk}]bX*Df"76# 146 }]F/5CLr8OMN< DBPATH ON target-directory KN}m>?j}]b?<#g{5CLr4-=;vVP}]b,+vTK N}#8(D}/wM?XD#g{8]3q|(tCKT/f" wD}]b,R48( ON N},G4KN}k TO N}G,eJ,Rv}] b?<;|D,xk}]bX*Df"76;|D# ON path-list KN}XB(ek}]b`X*Df"76#g{}]b|,`vf"wi, G4K!na+yPf"wiX(r=8(D76,by,?vQ(ef"w i+9C path-list w*dBf"wi76#+KN}k4(ef"wir4t CT/f"wD}]b;p9C+X# g{9C REDIRECT !n8(K!n,G4K!naZu< RESTORE ... REDI- RECT |n5X=wC_0"vNN SET STOGROUP PATHS r SET TABLESPACE CONTAINERS od0z'#g{fsX(rNNf"wi7 6,G4b)^4a2GZu< RESTORE ... ON path-list |nP(eDNN7 6# Z4-YwZdQX(ed76DNNf"wi;Pksx0vYwZdXE DYw`XDNNf"76# g{ELOP;PC}]b,R48( DBPATH ON N},G4Z;v76Cw ?j}]b?<# TZ`Vx}]b,;\Z?}CY1}]b#+djIs;Yh*C} ]b,"R DBA I>}C}]b# g{48( STAGE IN !n,G4avVTBiv: v }]b{FDq=* SYSTGxxx,dP xxx G{}5# v +dYwjIsa>}Y1G(}]b# USING STOGROUP storagegroup-name TZT/f"mUdxT,b8>+k*+dDyPmUdX*D?jf"w i#g{48(Cf"wi,G4a9C?j}]bD108(D1!f"w i#KSdvJCZT/f"wmUd,RvZ#=+dYwZdP'# j6+ZdPf"mUd}]Df"wi#storagegroup-name Xkj6 TRANS- PORT D target-database-alias Yw1fZDf"wi#(SQLSTATE 42704)#b G;?V{F# LOGTARGET directory GlU4-: }]b~qwOVP?D~#g{8(C!n,G4+8]3qP|,DNNU>D ~i!A?j?<#g{48(C!n,+;i!8]3qP|,DU>D ~#*S8]3qPvi!U>D~,k8( LOGS !n#K!naT/+}] bVxEM$wj6mS=C76# DEFAULT +U>D~S8]3q4-=}]bD1!U>?? ?<,G4+4-b)U>?<#ELODVPU>?D~ g{k8]3qPDU>?<;"ze;,G4+#V;d#g{E LODVPU>????<#ELODVPU>?D~g{k8]3qPD 148 }]F/5CLr8OMN< U>?<;"ze;,G4+#V;d#g{4-KtZ}]bD7 6,"R+rK~=4-KU>?<,Sx?<;2G,G 4a5Xms# FORCE Z4-lU3q1,Jm2GMf;10}]bPDVPU>?<# g{48(K!n,G41ELODVPU>?D~klU 3qPDU>?4- YwIT2GMf;G)VPDU>?<# ":9CK!n1&qb!D,"RqX7#8]Mi5K4PV4 1yXhDyPU># ":g{4TlU4-8( LOGTARGET,G41! LOGTARGET ?<* LOGTARGET EXCLUDE# NEWLOGPATH directory Z4-YwsCZn/U>D~D?76;JOZ4 -Yws9C1I9CKN},}g,ZC76;YP'1rIm;}]b9 C1# DEFAULT 4-jIs,C}]b&C9C1!U>?< /home/db2user/db2inst/ NODE0000/SQL00001/LOGSTREAM0000 xPG<# WITH num-buffers BUFFERS +*9CD:ex}?#}GzT=Xdk;v5,qr DB2 }]b53+T /*KN}!qnQ5#S`v4A!}]1,rvSK PARALLELISM D5 1,I9COsD:ex}TDxT\# BUFFER buffer-size +CZ4-YwD:exs!(T3F)#}GzT=Xdk;v5,qr DB2 }]b53+T/*KN}!qnQ5#KN}Dn!5G 8 3# 4-:exs!XkGZ8]YwZd8(D8]:exs!D}{}6}# g{8(K;}7D:exs!,G4:ex+Vd*n!DIS\s!# REPLACE HISTORY FILE 8(4-Yw&C9C8]3qPDz7G\PC,bGr*|nP&mw+;aa>C'i$Gq>}KVP }]b#g{8(K WITHOUT PROMPTING N},G4;h*8( REPLACE EXISTING,+ZbVivB,g{"zK(#h*C'I$DB~,Ywa' \# REDIRECT 8(“X(r4-”Yw#*jI“X(r4-”Yw,ZK|ns&zP;vr `v SET TABLESPACE CONTAINERS |nr SET STOGROUP PATHS |n,;sz xP CONTINUE !nD RESTORE DATABASE |n#}g: }]F/5CLrMN< 149 RESTORE DB SAMPLE REDIRECT SET STOGROUP PATHS FOR sg_hot ON ’/ssd/fs1’, ’/ssd/fs2’ SET STOGROUP PATHS FOR sg_cold ON ’/hdd/path1’, ’/hdd/path2’ RESTORE DB SAMPLE CONTINUE g{ZzI8]3q.sX|{Kf"wi,G4I SET STOGROUP PATHS | n8(Df"wi{F8DG8]3qPDf"wi{F,x;GnB{F# XkS,;0Zr CLP a0wCk;v“X(r4-”Yw`XDyP|n# GENERATE SCRIPT script 9C8(DD~{4(X(r4-E>#E>{FITG`TDrxTD,E > + Z M ' K z I # g { ; \ Z M ' K 4 ( D ~ , + 5 X m s {" (SQL9304N)#g{D~QfZ,G4+2GfZDD~#kNDTB>} TKbx;=DC(E"# WITHOUT ROLLING FORWARD 8(ZI&4-}]bs,;*+C}]bCZ0v]R4,# g{I&jI4-Yws,C}]b&Z0v]R4,,G4XkwC ROLLFORWARD |n,E\YN9CC}]b# S*z8]3q4-1,g{8(K!n,G4a5Xms SQL2537N# g{8]3qG;vIV4D}]b,G4 WITHOUT ROLLING FORWARD ;\8 (*xP REBUILD !n# PARALLELISM n 8(+Z4-YwZd4(D:exY]LrD}?#}GzT=Xdk;v 5,qr DB2 }]b53+T/*KN}!qnQ5# COMPRLIB name 8>*CZ4Pb9DbD{F(}g,TZ Windows,* db2compr.dll;T Z Linux r UNIX 53,* libdb2compr.so)#K{FXkG}C~qwO 3vD~Dj<76#g{48(KN},G4 DB2 }]b53+"T9CC 3qPf"Db#g{8]49u,G4avTKN}D5#g{^(0k8 (Db,G44-Yw+'\# COMPROPTS string hv+]xb9bPDuC'# 150 }]F/5CLr8OMN< >} 1. ZTB>}P,}]b WSDB GZ`E* 0 A 3 Db 4 v}]bVxO(eD# ITSyP}]bVxCJ76 /dev3/backup#ITS /dev3/backup q!BPQ z8]3q: wsdb.0.db2inst1.DBPART000.200802241234.001 wsdb.0.db2inst1.DBPART001.200802241234.001 wsdb.0.db2inst1.DBPART002.200802241234.001 wsdb.0.db2inst1.DBPART003.200802241234.001 *H4-?,G4CYw4p4qRp;y#bGr* db2_all ;'VC'a># 2. TBG;vdMDX(r4-=8,CZp{* MYDB D}]b: a. "vxP REDIRECT !nD RESTORE DATABASE |n# restore db mydb replace existing redirect I&jI=h 1 .sRZjI=h 3 .0,(}"vTB|n4P94-Y w: restore db mydb abort b. TXkXB(e]wD?vmUd"v SET TABLESPACE CONTAINERS |n#} g: set tablespace containers for 5 using (file ’f:\ts3con1’ 20000, file ’f:\ts3con2’ 20000) *i$4-}]bD]wGqGZK=hP8(DG)]w,k"v LIST TABLESPACE CONTAINERS |n# c. ZI&jIK=h 1 M 2 .s,"v: restore db mydb continue bG“X(r4-”YwDns;=# d. g{=h 3 '\,r_g{P9K4-Yw,G4IS=h 1 *}GTIV4}]b?\xPDv?8]_TDy>#|(;v?\xP Dj{}]b8]Yw";v?lxPDG[}(nl)8]YwT0;vZ? \PZxPD[}(v?)8]Yw: }]F/5CLrMN< 151 (Sun) backup db mydb use tsm (Mon) backup db mydb online incremental delta use tsm (Tue) backup db mydb online incremental delta use tsm (Wed) backup db mydb online incremental use tsm (Thu) backup db mydb online incremental delta use tsm (Fri) backup db mydb online incremental delta use tsm (Sat) backup db mydb online incremental use tsm *TZGZegO4(D3qT/xP}]b4-,k"v: restore db mydb incremental automatic taken at (Fri) *TZGZegO4(D3qV/xP}]b4-,k"v: restore db mydb incremental taken at (Fri) restore db mydb incremental taken at (Sun) restore db mydb incremental taken at (Wed) restore db mydb incremental taken at (Thu) restore db mydb incremental taken at (Fri) 4. *zz|(U>D8]3q,T+MA6L>c: backup db sample online to /dev3/backup include logs *4-8]3q,ka) LOGTARGET 76"Z ROLLFORWARD Zd8(K76: restore db sample from /dev3/backup logtarget /dev3/logs rollforward db sample to end of logs and stop overflow log path /dev3/logs 5. *vS|,U>D8]3qPlwU>D~: restore db sample logs from /dev3/backup logtarget /dev3/logs 6. IT9C USE TSM OPTIONS X|V8( TSM E",T)4-Yw9C#Z Win- dows =(O,!T -fromowner !n# v 8((gV{.: restore db sample use TSM options ’"-fromnode=bar -fromowner=dmcinnis"’ v 8(j }#}]bnu9C;vf"76 /myPath0: 44( v Z?dv: restore db sample from /home/jseifert/backups taken at 20050301100417 redirect generate script SAMPLE_NODE0000.clp +`FZTB>}: -- **************************************************************************** -- ** T/4(DX(r4-E> -- **************************************************************************** UPDATE COMMAND OPTIONS USING S ON Z ON SAMPLE_NODE0000.out V ON; SET CLIENT ATTACH_DBPARTITIONNUM 0; SET CLIENT CONNECT_DBPARTITIONNUM 0; -- **************************************************************************** -- ** u’ 152 }]F/5CLr8OMN< -- USING '’ FROM '/home/jseifert/backups’ TAKEN AT 20050301100417 -- DBPATH ON '’ INTO SAMPLE -- NEWLOGPATH '/home/jseifert/jseifert/SAMPLE/NODE0000/LOGSTREAM0000/’ -- WITH BUFFERS -- BUFFER -- REPLACE HISTORY FILE -- REPLACE EXISTING REDIRECT -- PARALLELISM -- WITHOUT ROLLING FORWARD -- WITHOUT PROMPTING ; -- **************************************************************************** -- ** mUd(e -- **************************************************************************** -- **************************************************************************** -- ** mUd{F = SYSCATSPACE -- ** mUdj6 =0 -- ** mUd`M = 53\mUd -- ** mUdZ]`M = Nb}] -- ** mUd3s!(VZ) = 4096 -- ** mUd)9}]is!(3) =32 -- ** 9CT/f"w =No -- ** \3} = 5572 -- **************************************************************************** SET TABLESPACE CONTAINERS FOR 0 -- IGNORE ROLLFORWARD CONTAINER OPERATIONS USING ( PATH 'SQLT0000.0’ ); -- **************************************************************************** -- ** mUd{F = TEMPSPACE1 -- ** mUdj6 =1 -- ** mUd`M = 53\mUd -- ** mUdZ]`M = 53Y1}] -- ** mUd3s!(VZ) = 4096 -- ** mUd)9}]is!(3) =32 -- ** 9CT/f"w =No -- ** \3} =0 -- **************************************************************************** SET TABLESPACE CONTAINERS FOR 1 -- IGNORE ROLLFORWARD CONTAINER OPERATIONS USING ( PATH 'SQLT0001.0’ ); -- **************************************************************************** -- ** mUd{F = USERSPACE1 -- ** mUdj6 =2 -- ** mUd`M = 53\mUd -- ** mUdZ]`M = Nb}] -- ** mUd3s!(VZ) = 4096 -- ** mUd)9}]is!(3) =32 -- ** 9CT/f"w =No -- ** \3} =1 -- **************************************************************************** SET TABLESPACE CONTAINERS FOR 2 -- IGNORE ROLLFORWARD CONTAINER OPERATIONS USING ( PATH 'SQLT0002.0’ ); -- **************************************************************************** -- ** mUd{F = DMS -- ** mUdj6 =3 -- ** mUd`M = }]b\mUd }]F/5CLrMN< 153 -- ** mUdZ]`M = Nb}] -- ** mUd3s!(VZ) = 4096 -- ** mUd)9}]is!(3) =32 -- ** 9CT/f"w =No -- ** tCT/w{s! =No -- ** \3} = 2000 -- ** IC3} = 1960 -- ** _.;jG(3) =96 -- **************************************************************************** SET TABLESPACE CONTAINERS FOR 3 -- IGNORE ROLLFORWARD CONTAINER OPERATIONS USING ( FILE /tmp/dms1 1000 , FILE /tmp/dms2 1000 ); -- **************************************************************************** -- ** mUd{F = RAW -- ** mUdj6 =4 -- ** mUd`M = }]b\mUd -- ** mUdZ]`M = Nb}] -- ** mUd3s!(VZ) = 4096 -- ** mUd)9}]is!(3) =32 -- ** 9CT/f"w =No -- ** tCT/w{s! =No -- ** \3} = 2000 -- ** IC3} = 1960 -- ** _.;jG(3) =96 -- **************************************************************************** SET TABLESPACE CONTAINERS FOR 4 -- IGNORE ROLLFORWARD CONTAINER OPERATIONS USING ( DEVICE '/dev/hdb1’ 1000 , DEVICE '/dev/hdb2’ 1000 ); -- **************************************************************************** -- ** t/X(r4- -- **************************************************************************** RESTORE DATABASE SAMPLE CONTINUE; -- **************************************************************************** -- ** D~ax -- **************************************************************************** 9. T/f"w}]bOTB|nDE>dv: restore db test from /home/jseifert/backups taken at 20050304090733 redirect generate script TEST_NODE0000.clp +`FZTB>}: -- **************************************************************************** -- ** T/4(DX(r4-E> -- **************************************************************************** UPDATE COMMAND OPTIONS USING S ON Z ON TEST_NODE0000.out V ON; SET CLIENT ATTACH_MEMBER 0; SET CLIENT CONNECT_MEMBER 0; -- **************************************************************************** -- ** u’ -- USING '’ FROM '/home/jseifert/backups’ TAKEN AT 20050304090733 ON '/home/jseifert’ -- DBPATH ON INTO TEST -- NEWLOGPATH '/home/jseifert/jseifert/TEST/NODE0000/LOGSTREAM0000/’ -- WITH BUFFERS -- BUFFER -- REPLACE HISTORY FILE 154 }]F/5CLr8OMN< -- REPLACE EXISTING REDIRECT -- PARALLELISM -- WITHOUT ROLLING FORWARD -- WITHOUT PROMPTING ; -- ***************************************************************************** -- ** storage group definition -- ** Default storage group ID = 0 -- ** Number of storage groups = 3 -- ***************************************************************************** -- ***************************************************************************** -- ** Storage group name = SG_DEFAULT -- ** Storage group ID = 0 -- ** Data tag = None -- ***************************************************************************** -- SET STOGROUP PATHS FOR SG_DEFAULT -- ON ’/hdd/path1’ -- , ’/hdd/path2’ -- ; -- ***************************************************************************** -- ** Storage group name = SG_HOT -- ** Storage group ID = 1 -- ** Data tag = 1 -- ***************************************************************************** -- SET STOGROUP PATHS FOR SG_HOT -- ON ’/ssd/fs1’ -- , ’/ssd/fs2’ -- ; -- ***************************************************************************** -- ** Storage group name = SG_COLD -- ** Storage group ID = 2 -- ** Data tag = 9 -- ***************************************************************************** -- SET STOGROUP PATHS FOR SG_COLD -- ON ’/hdd/slowpath1’ -- ; -- **************************************************************************** -- ** mUd(e -- **************************************************************************** -- **************************************************************************** -- ** mUd{F = SYSCATSPACE -- ** mUdj6 =0 -- ** mUd`M = }]b\mUd -- ** mUdZ]`M = Nb}] -- ** mUd3s!(VZ) = 4096 -- ** mUd)9}]is!(3) =4 -- ** 9CT/f"w = Yes -- ** Storage group ID = 0 -- ** Source storage group ID = -1 -- ** Data tag = None -- ** tCT/w{s! = Yes -- ** \3} = 6144 -- ** IC3} = 6140 -- ** _.;jG(3) = 5968 -- **************************************************************************** -- **************************************************************************** -- ** mUd{F = TEMPSPACE1 -- ** mUdj6 =1 -- ** mUd`M = 53\mUd -- ** mUdZ]`M = 53Y1}] -- ** mUd3s!(VZ) = 4096 -- ** mUd)9}]is!(3) =32 -- ** 9CT/f"w = Yes -- ** \3} =0 -- **************************************************************************** -- **************************************************************************** -- ** mUd{F = USERSPACE1 -- ** mUdj6 =2 -- ** mUd`M = }]b\mUd -- ** mUdZ]`M = Nb}] -- ** mUd3s!(VZ) = 4096 -- ** mUd)9}]is!(3) =32 -- ** 9CT/f"w = Yes -- ** Storage group ID = 1 }]F/5CLrMN< 155 -- ** Source storage group ID = -1 -- ** Data tag = 1 -- ** tCT/w{s! = Yes -- ** \3} = 256 -- ** IC3} = 224 -- ** _.;jG(3) =96 -- **************************************************************************** -- **************************************************************************** -- ** mUd{F = DMS -- ** mUdj6 =3 -- ** mUd`M = }]b\mUd -- ** mUdZ]`M = Nb}] -- ** mUd3s!(VZ) = 4096 -- ** mUd)9}]is!(3) =32 -- ** 9CT/f"w =No -- ** Storage group ID = 2 -- ** Source storage group ID = -1 -- ** Data tag = 9 -- ** tCT/w{s! =No -- ** \3} = 2000 -- ** IC3} = 1960 -- ** _.;jG(3) =96 -- **************************************************************************** SET TABLESPACE CONTAINERS FOR 3 -- IGNORE ROLLFORWARD CONTAINER OPERATIONS USING ( FILE '/tmp/dms1’ 1000 , FILE '/tmp/dms2’ 1000 ); -- **************************************************************************** -- ** mUd{F = RAW -- ** mUdj6 =4 -- ** mUd`M = }]b\mUd -- ** mUdZ]`M = Nb}] -- ** mUd3s!(VZ) = 4096 -- ** mUd)9}]is!(3) =32 -- ** 9CT/f"w =No -- ** tCT/w{s! =No -- ** \3} = 2000 -- ** IC3} = 1960 -- ** _.;jG(3) =96 -- **************************************************************************** SET TABLESPACE CONTAINERS FOR 4 -- IGNORE ROLLFORWARD CONTAINER OPERATIONS USING ( DEVICE '/dev/hdb1’ 1000 , DEVICE '/dev/hdb2’ 1000 ); -- **************************************************************************** -- ** t/X(r4- -- **************************************************************************** RESTORE DATABASE TEST CONTINUE; -- **************************************************************************** -- ** D~ax -- **************************************************************************** 10. TBG9C SNAPSHOT !nD RESTORE DB |n>}: SlU3q4-U>?# db2 restore db sample use snapshot LOGTARGET INCLUDE without prompting ;4-U>?# db2 restore db sample use snapshot LOGTARGET EXCLUDE without prompting ;4-U>?#g{48( LOGTARGET,G41!5* LOGTARGET EXCLUDE# db2 restore db sample use snapshot without prompting 156 }]F/5CLr8OMN< Z4-|,`e;DU>??<,+;a># db2 restore db sample use snapshot LOGTARGET EXCLUDE FORCE without prompting Z4-|,`e;DU>??<,+;a># db2 restore db sample use snapshot LOGTARGET INCLUDE FORCE without prompting 11. TBG9CxP TRANSPORT REDIRECT !nD RESTORE |n4+dYwD>}: a);v4}]b (TT_SRC) 8]3q(f"76Z /src O)M;v?j}]b (TT_TGT)(f"76Z /tgt O): > RESTORE DB TT_SRC TABLESPACE (AS1) SCHEMA (KRODGER) TRANSPORT INTO TT_TGT REDIRECT SQL1277W }Z4PX(r4-Yw# mUd configuration can now be viewed and table spaces that do not use automatic storage can have their containers reconfigured. DB20000I QI&jI RESTORE DATABASE |n# +mUd“AS1”+d=]w76P,`FZ: /tgt/krodger/NODE0000/TT_TGT/ T0000003/C0000000.LRG *8(+dmUdD?jf"wi,I9C RESTORE |nD USING STOGROUP ! n#ZTB>}P,+mUd TS1 M TS2 4-= SG_COLD f"wiP: RESTORE DB TT_SRC TABLESPACE (TS1, TS2) SCHEMA (KRODGER) TRANSPORT INTO TT_TGT USING STOGROUP SG_COLD ":RESTORE |nD USING STOGROUP !nvZ+dYwZdP',R^(ZNN d{4-YwZdCZ8(?jf"wi# *4P=?j}]bD1!f"wiD+d,;h*8( USING STOGROUP !n: RESTORE DB TT_SRC TABLESPACE (TS3) SCHEMA (KRODGER) TRANSPORT INTO TT_TGT Z TRANSPORT YwZdZ RESTORE |nO8(Df"wi{F10XkZ?j }]bPxP(e#;XZ8]3qr4}]bPxP(e# g{9CN} AT DBPARTITIONNUM XB4(Q>}D}]bVx(IZCVxQp 5),G4K}]bVxPD}]b+&Z4-]R4,#ZXB4(}]bVx s,Xk"4ZK}]bVxO4-}]b# C(5w v q=* db2 restore db name D RESTORE DATABASE |n+9C}]b3q4P{ v}]b4-,"R+TmUd3qPDmUd4PmUd4-Yw#q=* db2 restore db name tablespace D RESTORE DATABASE |nT3qPDmUd4Pm Ud4-#mb,g{9CK|n1a)K;imUd,G44-b)T=P>D mUd# v ZxP*z8]D4-Yws,Xk4P0vV4# v IT9C OPTIONS N}Z'VzmZcD TSM 73PtC4-Yw#PX|`E ",kND:dC Tivoli Storage Manager M'z;wb# v g{8]3qG9uD,G4 DB2 }]b53alb=bViv,"Z4-}]0 T/b9}]#g{Z db2Restore API O8(b,G4+9CCb4b9}]#q r,+xPliT7(GqZ8]3qPf"Kb"bGqfZT0GqQ9C# ns,g{Z8]3qP;Pf"b,G4;\b9}],4-Yw'\# }]F/5CLrMN< 157 v g{*S8]3q4-9ub((}T=X8( COMPRESSION LIBRARY !nr(}~ =4P9u8]D}#4-),G4XkZ4P8]D=(MYw53O4P4- Yw#g{4P8]yCD=(k4P4-yCD=(;,,G44-Yw+' \,49 DB2 }]b53(#'Vf0=v53Dg=(4-`gK# v 8]D SMS mUd;\4-= SMS mUd#;\+|4-= DMS mUd,4. `;# v *S|,U>D~D8]3qP4-b)U>D~,Xk8( LOGTARGET !n,"a ) DB2 ~qwOfZDP'j<76#g{b)u~D~S3qP4k?j76#g{Z;|(U>D8]3q4-Zd8 ( LOGTARGET,G44-Yw+5Xms,;sY"T4-NNmUd}]#g{8 (^'r;AD LOGTARGET 76,G44-Yw2a'\"5Xms# v g{Z"v RESTORE DATABASE |n1,LOGTARGET 76PfZNNU>D~,G4 +rC'5X;u/fa>#g{8(K WITHOUT PROMPTING,G4+;5XK/f# v Z8( LOGTARGET D4-YwZd,g{^(i!NNU>D~,G44-Yw+' \"5Xms#g{}ZS8]3qPi!DNNU>D~k LOGTARGET 76PVP DD~,{,G44-Yw+'\,"5Xms#4-}]b5CLr;a2G LOGTARGET ?D~# v 9ITS8]3qPv4-#fDU>/#*8>v4-U>D~,} LOGTARGET 7 6.b,k8( LOGS !n#8(;x LOGTARGET 76D LOGS !n+D~1"zNNJb,4-Yw+"4U9"+5Xm s# v T/v?4-YwZd,vS8]3qPlw4-Yw?j3qP|,DU>D ~#;aSG)Pd8]3qPi!Pd3q(Zv?4-Yw&mZd}C)| ,DNNU>D~#V/v?4-YwZd,;&(}"vnU4-|n48( LOGTARGET 76# v }]bQzj{8]M}]bQzv?8]IT4-*|_D}]bf>,x*z 8]r;\#TZ`Vx}]b,XkH%@X4-??< - LOGTARGET EXCLUDE# g{ DB2 }]b\mwlb=Z*4-DNNd{76d2mKNNU>?< Dij6,G4a5Xms#ZKivB,Xk8( LOGTARGET INCLUDE r LOGTARGET INCLUDE FORCE,bGr*U>??<(wU >?<"5qU>??<)# g{z*4-U>??< k8]3qPDU>?<`e;,G4 DB2 }]b\mw+(fms#ZK` ivB,g{z8(K LOGTARGET INCLUDE FORCE,G4+{9Kms,;s$ H>}NNQfZDU>?<"S3q4-U>?<# fZ;VXbiv,4,8(K LOGTARGET EXCLUDE !nRU>?<76;Z }]b?<(}g,/NODExxxx/SQLxxxxx/LOGSTREAMxxxxx/)B1#ZKiv B,4-YwT+2GCU>?<,bGr*+4-}]b760dBfDy PZ]#g{ DB2 }]b\mwlb=KivRKU>?D~, G4+(fms#g{z8(K LOGTARGET EXCLUDE FORCE,G4+{9Km s,"R8]3qPDG)U>?<+2GELO`e;DU>?<# +dmUdM#= Xk8(mUdM#=Dj{Pm# +d1,?j}]bXk&Zn/4,# g{9CK*z8]3q,G4G(}]ba0vA8]a2#g{9CKQ z8]3q,G4;a4P0v&m# Z dftdbpath }]bN}8(D76B,a4(;vG(}]b,dP|,4 T8]3qD53?}K}]b# i! DDL 1h*G(}]b,C DDL CZZ*+dDmUdPXBzIT s# +dmUd1,DB2 }]b\mwa"T+_P%d3s!DZ;vIC:e X8(xy+dmUd#g{?j}]b4|,_Py+dmUdD%d3s !D:eX,G4I\a8(~XD:eX#~XD:eXGy+dmUdD Y1<;{#+djIs,Ili8(xy+dmUdD:eX#I"v ALTER TABLESPACE |n4|B:eX# g{}]b0vYwlb=mUd#=+dU>G<,G4+9`&DQ+d mUdQz,"9dxk>}]R4,#bGr*}]b;_PQ+dmUd Dj{U>4X(Q+dmUd0dZ]#zITZjI+dsFw?j}] bDj+8],Tcsx0vYw;a+#=+dc+kU>wP# +df"wi +dYw^(^D?j}]bD10(eDf"wi,R^(Z+dZdT= 4(Bf"wi# +dD1!?jf"wiGCYwD?j}]bD1!f"wi#9IT+Z +dYwZd*4-DyPmUdT=X(r=?j}]bODX(f"wi P# Z+dYwZd,1"v9C TRANSPORT REDIRECT !nD RESTORE |n1, T/f"wmUdD1!f"widC;G8]3qP|,DdC,xG?j }]bDf"wiMf"wi76#bGr*,Xk4-T/f"wmUd, "1SX(r=VPDf"wi76P,gZ?j}]bOy(e# }]F/5CLrMN< 159 `XE": (}]R I/O M*zVn5q'Vq!_ICT (}9C IBM }]~qwD]R I/O 'V,ITVnw}]bD5q1>,x;X9 C}]bQz#{CbV=(,ITZw}]bvVJO18Y4(;v8C}]b 4S\Yw# EL5qG+}],14k=v%@D2LPDxL#;v}]1>Gm;v}]1 >D5q#Vn5qGVk=v1>DxL# IT9CEL5q4,$w}]bD(z1>#IT9C IBM }]~qwD]R I/O &\4Vn}]bDw5q1>M(z5q1>,x;X9C}]bQz#Vnw} ]b1>M(z}]b1>s,Zw}]bvVJO1,(z}]bITS\Yw# g{;#{9C IBM }]~qwD BACKUP 5CLr48]sM}]b,I(}9 C]R I/O MVn5q&\y]5q3q4("1>#K=(9IT: v {}4TzzzwD8]Yw*z v a)KK!53D;vl]== v a)KTUP8CJO*FDlY5V#;h*u<4-Yw,g{$50vYw +}rv=Kms,XBuKh*VnD}]bDyPD~M?<# db2inidb - u,"&C=8 C}]b#;sIZw}]b1z1,+C8C}]bzfw}]b# ACS 8(*T}]bD ACS lU1>9C db2inidb |n44P STANDBY Y w#r*;\T9C SET WRITE SUSPEND | RESUME |n4(DVn5q} ]blU"v db2inidb |n,yTK!nGXhD# k ACS STANDBY !n;p9CT+ ACS lU1>CZ0v]R4,,T cITlU3qI&"v DB2 BACKUP |n#g{;9CK!n,G4" T,SAlU3qaCZ RESTORE_PENDING 4,, 9d^(Cw8]1>T)+4V49C# K&\G(E*kf"\mw(}g,IBM Tivoli Storage FlashCopy® Man- ager);%TzIyZ ACS lUD6X DB2 8]}kD#g{+K!n CZd{C>(20r^D ACS lU1>DZ],uA|(zI DB2 8 ])IDE"XB(;}]bD~#Z Z 162 3D:db2relocatedb - X(;}]b; PhvK configFile Dq=# }]F/5CLrMN< 161 9C5w "v db2inidbdatabase_alias as mirror |n0,k;*"v db2 connect todatabase-alias Yw#Zu}0vV 4Zdh*DU>D~#K,S+}]bhCX|;]R1D4,#g{}]b]R Zd;jG*;B,DB2 }]b53+Cva[:;PX*xP@#V4"eUU>T 8+49C#g{U>Q-;eU,"T0v;5XD SQL4970N ms{"PDa{# ZVx}]b73P,XkHZ?v}]bVxO"v db2inidb |n,;sE\9C 4TNN}]bVxDVn3q#9C db2_all |n,IZyP}]bVxO,1KP db2inidb# +G,g{9C RELOCATE USING !n,G4;\9C db2_all |n,1ZyPVxO KP db2inidb#Xk*?vVxa)@"DdCD~,CdCD~|,y|DD}]b VxD NODENUM 5#}g,g{*|D}]bD{F,b+0l?v}]bVx, "RXkZ?v}]bVxOD~19CKD~X|{]w76# g{}Zu?<)#K$_+T DB2 5}M}]b'VD~xP XhD|D# ZKP db2relocatedb |nT^D?j}]bDXFD~M*}].0,?j}]bX k&ZQz4,# 162 }]F/5CLr8OMN< db2relocatedb |nT}]bDD~MXFa9yvD|D;aG D~V4}]b1# (^ ^ |no( db2relocatedb -f configFilename |nN} -f configFilename 8(|,X(;}]b1yh*DdCE"DD~D{F#KD~{ITG` TD~{rxTD~{#dCD~Dq=*: DB_NAME=oldName,newName DB_PATH=oldPath,newPath INSTANCE=oldInst,newInst NODENUM=nodeNumber LOG_DIR=oldDirPath,newDirPath CONT_PATH=oldContPath1,newContPath1 CONT_PATH=oldContPath2,newContPath2 ... STORAGE_PATH=oldStoragePath1,newStoragePath1 STORAGE_PATH=oldStoragePath2,newStoragePath2 ... FAILARCHIVE_PATH=newDirPath LOGARCHMETH1=newDirPath LOGARCHMETH2=newDirPath MIRRORLOG_PATH=newDirPath OVERFLOWLOG_PATH=newDirPath ... dP: DB_NAME 8(*X(;D}]bD{F#g{*|D}]b{F,G4Xk, 18(I{FMB{F#bG;vXhVN# DB_PATH 8(*X(;D}]bD-<76#g{*|D}]b76,G4X k,18(I76MB76#bG;vXhVN# INSTANCE 8(}]byZD5}#g{*+}]bFAB5},G4Xk,1 8(I5}MB5}#bG;vXhVN# NODENUM 8(*|DD}]bZcDZcE#1!5* 0# LOG_DIR 8(U>76D;CD|D#g{*|DU>76,G4Xk,18 (I76MB76#g{U>76;Z}]b76B(ZKivB+ T/|B76),G4Kf6GI!D# }]F/5CLrMN< 163 CONT_PATH 8(mUd]wD;CD|D#Xk,18(I]w76MB]w7 6#g{*|D`v]w76,G4ITa)`v CONT_PATH P#g {]w76;Z}]b76B(ZKivB+T/|B76),G4 Kf6GI!D#g{*|D`v]w(b)]wD`,I76*; f;*;v+2B76),G4IT9C%v CONT_PATH u?#ZK ivB,IT,1ZI76MB76P9CGE(*)w*(d{# STORAGE_PATH 8(}]bDdP;vf"76D;CD|D#Xk,18(If" 76MBf"76#g{*|D`vf"76,G4ITa)`v STORAGE_PATH P#8(KN}I^DyPf"wiPDNNf"76# +G,8(KN}^(^D%vf"wiDf"76# ":+G,KN};JCZ9C AUTOMATIC STORAGE NO Sd4 (D}]b#!\IZ4(}]b18( AUTOMATIC STORAGE NO Sd,+(i;*9C AUTOMATIC STORAGE Sd,+4"PfI \a}%CSd# FAILARCHIVE_PATH 8(B;CTi5U>D~(g{}]b\mw4\+b)U>D~ i5Awi5;Cr(zi5;C)#v1*X(;D}]bhCK failarchpath dCN}1,E&8(KVN# LOGARCHMETH1 8(BDwi5;C#v1*X(;D}]bhCK logarchmeth1 d CN}1,E&8(KVN# LOGARCHMETH2 8(BD(zi5;C#v1*X(;D}]bhCK logarchmeth2 dCN}1,E&8(KVN# MIRRORLOG_PATH 8(5qU>76DB;C#CV{.Xk8r76{,"R|Xk *j<76{,x;G`T76{#v1*X(;D}]bhCK mirrorlogpath dCN}1,E&8(KVN# OVERFLOWLOG_PATH 8(B;CTiR0vYwyhDU>D~"f"Si5lwDU> D~,T0iRMf" db2ReadLog API yhDU>D~#v1*X( ;D}]bhCK overflowlogpath dCN}1,E&8(KVN# vTKUWPr_T"MV{(#)*7DP# >} >} 1 *+;Z /home/db2inst1 76OD db2inst1 5}PD}]b{F TESTDB| D* PRODDB,G4&4(TBdCD~: DB_NAME=TESTDB,PRODDB DB_PATH=/home/db2inst1 INSTANCE=db2inst1 NODENUM=0 164 }]F/5CLr8OMN< +CdCD~mf* relocate.cfg,"9CTB|n4|D}]bD~: db2relocatedb -f relocate.cfg >} 2 *+ DATAB1 }]bS /dbpath 76OD jsmith 5}FA prodinst 5}, k4PTBYw: 1. + /dbpath/jsmith ?} 3 PRODDB }]bfZZ /databases/PRODDB 76OD inst1 5}P#h*4 gBy>|D=vmUd]wD;C: v h*+ SMS ]w /data/SMS1 FA /DATA/NewSMS1# v h*+ DMS ]w /data/DMS1 FA /DATA/DMS1 # +om?} 4 }]b TESTDB fZZ db2inst1 5}P,"RGZ /databases/TESTDB 76 O4(D#;sZBP]wP4(KmUd: TS1 TS2_Cont0 TS2_Cont1 /databases/TESTDB/TS3_Cont0 /databases/TESTDB/TS4/Cont0 /Data/TS5_Cont0 /dev/rTS5_Cont1 + TESTDB FAB53#B53OD5}+* newinst,x}]bD;C+* /DB2# 1F/}]b1,Xk+ /databases/TESTDB/db2inst1 ? ZdCD~P#g{*+d`=v]wFAB53ODd{;C,G4XkZ dCD~PP>b=v]w# +om?} 5 TESTDB }]bZ}]bVx~qw 10 M 20 OP=v}]bVx#Zb= v}]bVx~qwO,5}* servinst,}]b76* /home/servinst#Z b=v}]bVx~qwO,}Z+}]bD{F|D* SERVDB,"R}Z +}]b76|D* /databases#mb,}]bVx~qw 20 ODU>?< }ZS /testdb_logdir |D* /servdb_logdir# IZ}ZTb=v}]bVxxP|D,rK,Xk*?v}]bVx4(; vdCD~,"RXkT_P`&dCD~D?v}]bVx~qwKP db2relocatedb# Z}]bVx~qw 10 O,+9CTBdCD~: DB_NAME=TESTDB,SERVDB DB_PATH=/home/servinst,/databases INSTANCE=servinst NODENUM=10 Z}]bVx~qw 20 O,+9CTBdCD~: DB_NAME=TESTDB,SERVDB DB_PATH=/home/servinst,/databases INSTANCE=servinst NODENUM=20 LOG_DIR=/testdb_logdir,/servdb_logdir >} 6 MAINDB }]bfZZ /home/maininst 76OD maininst 5}P#h*4 gBy>|DDvmUd]wD;C: h*+ /maininst_files/allconts/C0 FA /MAINDB/C0 h*+ /maininst_files/allconts/C1 FA /MAINDB/C1 h*+ /maininst_files/allconts/C2 FA /MAINDB/C2 h*+ /maininst_files/allconts/C3 FA /MAINDB/C3 Z+om?4F/D }]b#^(}%b)}C,"R^(ZK`,76P4(_Pb){FDB}] b#+G,IZm;76P4(_Pb){FD}]b# TZ(}9C ALTER TABLESPACE MANAGED BY AUTOMATIC STORAGE od 4*;*9CT/f"wDmUd,;\9C db2relocatedb |n4*dF/VPC' 4(D]w# g{*|D5},G4XkIB5}yP_4KPC|n# ZVx}]b73P,XkTh*|DD?v}]bVxKPK$_#Xk*?v} ]bVxa)@"DdCD~,CdCD~|,y|DD}]bVxD NODENUM 5#} g,g{*|D}]bD{F,b+0l?v}]bVx,"RXkZ?v}]bV xO;IYwD Ts,k9C -a N}#g{8( -a N},G4+vT -u N}# -z schema *_P8(D#={FDTszI DDL od#+dv^F*_P8(D#={ FDTs#dv;|(NN;IYwDTs#*T>;IYwDTs,k9C -a N}#g{48( -z N},G4+i!_PyP#={FDTs#g{8 ( -a N},G4+vT -z N}#TZ*O DDL od,2+vTKN}# -t Tname1 Tname2 ... TnameN *8(Dm0dStTszI DDL od#+dv^F*ZmPmP8(Dm, "R*yPC'8(DmDyPStTszI DDL od# nsm}G 30# 4gBy>8(Pm: v CUqVtm{# v 9C41\ (\) M+}E (″″) +xVs!4D{FM+VZV{/ (DBCS) {F(p4(}g,\″ MyTabLe \″)# v 9C41\M=T+}E+`%Jm{(p4(}g,″\″My Table\″″), T@9|nP&mw (CLP) +}ET4%v%JxPFc#g{;9C;T +}E(}g,″My Table″),G4yP%J<+*;*s4,"R db2look |n+iR%J+*s4Dm{(}g,MY TABLE)# g{,18(K -t N}M -l N},G4+'VVxm# IT9CI=?ViIDm{(q=* schema.table)4j+^(m{,x^h 9C -z schema N}#13vmDStTsyICD#=kCmD#=;,, "Rz*s*StTszI DDL od1,IT9CI=?ViIDm{#g{ 9C -z schema N}8(#=,G4CN}+E};_P`,8#=DStT s,Sx^(*b)StTszI DDL od# -tw Tname *d{Fk9C Tname 8(D#=`%dDmzI DDL od,"R*b)m DyPStTszI DDL od#Tname Xk;G%v5#Tname PDB._ V{(_)Im>Nb%vV{#YVE(%)m>;v|,cvrcvTO V{DV{.#8( -tw 1,+vT -t !n# IT9CI=?ViIDm{(q=* schema.table)4j+^(m{,x^h 9C -z schema N}#13vmDStTsyICD#=kCmD#=;,, 170 }]F/5CLr8OMN< "Rz*s*StTszI DDL od1,IT9CI=?ViIDm{#g{ 9C -z schema N}8(#=,G4CN}+E};_P`,8#=DStT s,Sx^(*b)StTszI DDL od# -ct 4Ts4(1dzI DDL od#Ts DDL odI\;T}7D@5X53 rT>#g{8( -ct N},G4 db2look |nv'VTB=SN}: -e"- a"-u"-z"-t"-tw"-v"-l"-noview M -wlm#g{+ -ct N}k -z M -t N}dO9C,G4 db2look |n+zI4FPXm"3FE"S<"PM w}D3FE"1h*D UPDATE od# -dp Z CREATE od.0zI DROP od#g{3;Ts@5Zy>}DTs, G4 DROP odI\^'#}g,g{m@5Z3;#=,G4^(>}C# =;g{P`M"/}"%"wrm@5Z3;C'(eD`Mr/},G4 ^(>}CC'(eD`Mr/}#TZ`Mm,+v*ymzI DROP TABLE HIERARCHY od#>}m1+}w}"w|Mb|T0}Cm# -v Vname1 Vname2 ... VnameN *8(DSozE"#g{8(KN},G4+vTyPd{N}# -ap zI+sF_Tkd{}]bTs`X*1h*D AUDIT USING od# -o Fname +dv4k Fname D~#g{48()9{,G4+9C .sql )9{#g{ 48(KN},G4+dv4kj,RCE>G(}9Cx -m N}D db2look |n4(D(}g,9bT}]bD?<3FE"kzz} ]bPD?<3FE"`%d),G4=v}]bXk9C`,Dzk/MX r# -l *BP}]bTszI DDL od: v C'(eDmUd v C'(eDf"wi v C'(eD}]bVxi v C'(eD:eX -x zIZ( DDL od,g GRANT od# \'VD(^|(: v P:UPDATE M REFERENCES v }]b:ACCESSCTRL, BINDADD, CONNECT, CREATETAB, CREATE_EXTERNAL_ROUTINE, CREATE_NOT_FENCED_ROUTINE, DATAACCESS, DBADM, EXPLAIN, IMPLICIT_SCHEMA, LOAD, QUIESCE_CONNECT, SECADM, SQLADM, WLMADM v b}( v +Vd? v w}:CONTROL v Lr|:CONTROL"BIND M EXECUTE v G+ v #=:CREATEIN"DROPIN M ALTERIN v 2+jE v rP:USAGE M ALTER v f"}L:EXECUTE v m : ALTER"SELECT"INSERT"DELETE"UPDATE"INDEX"REFERENCE M CONTROL v S<:SELECT"INSERT"DELETE"UPDATE M CONTROL v C'(eD/} (UDF):EXECUTE v C'(eD=(:EXECUTE v mUd:USE v $w:X:USAGE ":k -t r -tw N}dO9C1,KN};a*StTszIZ( DDL o d#9C -xdep N}4*8TsMStTszIZ( DDL od# -xdep *8TsMStTszIZ( DDL od,}g,GRANT od#g{48( -t r -tw N},G4avTKN}#\'VD(^|(: v P:UPDATE M REFERENCES v w}:CONTROL v f"}L:EXECUTE 172 }]F/5CLr8OMN< v m : ALTER"SELECT"INSERT"DELETE"UPDATE"INDEX"REFERENCE M CONTROL v mUd:USE v C'(eD/} (UDF):EXECUTE v C'(eD=(:EXECUTE v S<:SELECT"INSERT"DELETE"UPDATE M CONTROL -xd zIZ( DDL od,|(d(^I SYSIBM ZTs4(1ZhDTsDZ( DDL od# |;aT53?XM6L}]bXk9C `,D DB2 f># -w password 8( db2look |nCZG<6L53D\k#g{8(KN}M -i N},G 4IT6L53OD}]bKP db2look |n#>XM6L}]bXk9C` ,D DB2 f># -wlm zIX(Z WLM D DDL dv,CdvICZ*TBwnzI CREATE M ALTER od: v 1=< v ~q` v P5 v WLM B~`Sw v $w:X v $wYw/ v $w`/ -wrap T}L"%"w"S# }]F/5CLrMN< 173 -wrapper Wname TJCZ8(|0wD*OTszI DDL od#I\zID*O DDL od |(: v CREATE FUNCTION ... AS TEMPLATE v CREATE FUNCTION MAPPING v CREATE INDEX SPECIFICATION v CREATE NICKNAME v CREATE SERVER v CREATE TYPE MAPPING v CREATE USER MAPPING v CREATE WRAPPER v GRANT(TGF"~qwMw}DX() g{48(|0w{Fr8(K`v|0w{F,G4a5Xms# -server Sname T&CZ8(~qwD*OTszI DDL od#I\zID*O DDL od |(: v CREATE FUNCTION ... AS TEMPLATE v CREATE FUNCTION MAPPING v CREATE INDEX SPECIFICATION v CREATE NICKNAME v CREATE SERVER v CREATE TYPE MAPPING v CREATE USER MAPPING v CREATE WRAPPER v GRANT(TGF"~qwMw}DX() g{48(~qw{Fr8(`v~qw{F,G4a5Xms# -nofed 8(+;zINN*O DDL od#g{8(KN},G4avT -wrapper M -server N}# -fedonly 8(+vzI*O DDL od# -mod *?v#iT0?v#iP(eDyPTs} BP>}5wgN9C db2look |n: v *Ts(IC' walid Z}]b DEPARTMENT P4()zI DDL od#dv+ "MA db2look.sql D~# db2look -d department -u walid -e -o db2look.sql v *Ts(IC' walid Z}]b DEPARTMENT P4(,_P#={F ianhe)z I DDL od#dv+"MA db2look.sql D~# db2look -d department -u walid -z ianhe -e -o db2look.sql v zI UPDATE odT4F}]bTs(IC' walid Z}]b DEPARTMENT P 4()D3FE"#dv+"MA db2look.sql D~# db2look -d department -u walid -m -o db2look.sql v *Ts(IC' walid 4()zI DDL odT0zI UPDATE odT4FPX }]bTs(I,;C'4()D3FE"#dv+"MA db2look.sql D~# db2look -d department -u walid -e -m -o db2look.sql v *Ts(IyPC'Z}]b DEPARTMENT P4()zI DDL od#dv+" MA db2look.sql D~# db2look -d department -a -e -o db2look.sql v *yPC'(eD}]bVxi":eXMmUdzI DDL od#dv+"MA db2look.sql D~# db2look -d department -l -o db2look.sql v *kE/w`XD}]bM}]b\mwdCN}zI UPDATE od,T0*}] b DEPARTMENT PkE/w`XD"amd?zI db2set |n#dv+"MA db2look.sql D~# db2look -d department -f -o db2look.sql v *kE/w`XD"amd?zI db2set |n,T0*}]b DEPARTMENT z IBPod: – *yP}]bTszI DDL od – zI UPDATE odT4FPXyPmMw}D3FE" – zI GRANT Z(od – *kE/w`XD}]bM}]b\mwdCN}zI UPDATE od – *kE/w`XD"amd?zI db2set |n – *yPC'(eD}]bVxi":eXMmUdzI DDL od dv+"MA db2look.sql D~# db2look -d department -a -e -m -l -x -f -o db2look.sql v *}]b DEPARTMENT PDyPTs(|(I-<4(_4(DTs)zIyP Z( DDL od#(ZKivB,I SYSIBM Z4(Ts1Zhb)(^#)dv +"MA db2look.sql D~# db2look -d department -xd -o db2look.sql v *Ts(IyPC'Z}]b DEPARTMENT P4()zI DDL od#dv+" MA db2look.sql D~# db2look -d department -a -e -td % -o db2look.sql }]F/5CLrMN< 175 dvfsI) CLP A!: db2 -td% -f db2look.sql v *}]b DEPARTMENT PDTs4( DDL od,;|( CREATE VIEW od# dv+"MA db2look.sql D~# db2look -d department -e -noview -o db2look.sql v *}]b DEPARTMENT Pk8(m`XDTszI DDL od#dv+"MA db2look.sql D~# db2look -d department -e -t tab1 "\"My TaBlE2\"" -o db2look.sql v **O}]b FEDDEPART PDyP*OMG*OTszI DDL od#TZ*O DDL od,vzIG)JCZ8(|0w FEDWRAP D*O DDL od#dv+" MAjD~#IT*O}]b FEDDEPART KP TB53|n,+vzI`FZT4*OD}]bKPK|n1yzIDdv#d v+"MA out.sql D~# db2look -d feddepart -e -nofed -o out v *Z}]b DEPARTMENT P_P#={F walid DTszI DDL od#"aN N=xD XML #=M DTD 1h*DD~+D~s,zXk+ federated dCN}hC* YES,;sYKP CE>#*O73P'VTB db2look |nN}: -ap zI AUDIT USING od# -e **OTszI DDL od# -f S}]b\mwdCPi!k*O`XDE"# -m i!PXGFD3FE"# -x zI GRANT odTZhT*OTsDX(# -xd zI DDL odTcr*OTsmS53ZhDX(# -wlm zIX(Z WLM D DDL od# g{GFPM6LmPD}]`M;,,G4 db2look |n+*GFPzI ALTER COLUMN od# Xk^DdvE>Tc* CREATE USER MAPPING odmS6L\k# Xk(}rG)CZ+ DB2 5P5}(e*}]4D CREATE SERVER odmS AUTHORIZATION M PASSWORD,4^D db2look |ndvE># -tw !nDC(gBy>: v ** DEPARTMENT }]bPk{FT abc *7Dm`X*DTszI DDL od, "+dv"MA db2look.sql D~: db2look -d department -e -tw abc% -o db2look.sql v ** DEPARTMENT }]bPk9C d w*{FDZ~vV{Dm`X*DTsz I DDL od,"+dv"MA db2look.sql D~: db2look -d department -e -tw _d% -o db2look.sql v @@D)m{k Tname Td?y8(D#=`%d1,db2look |n+9C LIKE = J#r*9CK LIKE =J,yTg{ _ V{r % V{Gm{D;?V,G4X ktS _ r % .09C41\(\)*eV{#ZKivB,;\Z Tname P9C _ r % w*(d{#}g,** DEPARTMENT }]bPk{FDZ;vV{M ns;vV{y49CYVEDm`X*DTszI DDL od: db2look -d department -e -tw string\%string v Xk9C41\M+}E+xVs!4D{F"DBCS {FT0`%Jm{MS<{ F(p4#}g: \"My TabLe\" }]F/5CLrMN< 177 g{49C41\M+}E(g{+`VZV{/(MBCS)r+VZV{/ (DBCS){F(p4,"RC{F|,k!4V{`,DVZ,G4a+C{F* ;*s4"R db2look +iR_Py*;{FD}]bTs#rK,+;i! DDL od# v -tw !nITk -x !ndO9C(TzI GRANT X()"k -m !ndO9C (T5XmMP3FE")T0k -l !ndO9C(Tc*C'(eDmUd"} ]bVxiM:eXzI DDL)#g{+ -t !nk -tw !n;p8(,G4+v T -t !n(0dX*D Tname Td?)# v -tw !n;\CZ*;Z*O}]4"DB2 Universal Database for z/OS and OS/390"DB2 i f r DB2 Server for VSE & VM ODm(0dX*DTs)zI DDL# v v(} CLP 'V -tw !n# g{"TZ9CVx}]b73D53OzI DDL od,+T>;u/f{",x; GT>;n/}]bVxODmUdD DDL od#*7#*yPmUdzI}7D DDL od,Xk$nyP}]bVx# db2look |nvZ DB2 V9.5 r|_f>D}]bO\'V,+zITS|Mf>D DB2 M'z"vC|n#}g,'VS V9.1 M'zT V9.5 }]b"vK|n,+; 'VS V9.5 M'zT V9.1 }]b"vK|n# wC db2look 5CLr1,db2look |n*9C4d5Bq4(DNNTszI DDL od# i!`M*}iD2+jEi~D DDL od1,yi!DodI\^(zIK`i~, 4Ci~DZ?m>((C}iP*XD`k)kzTd"vK db2look |nD}]b PDi~DZ?m>(`%d#g{(}r2+jEi~mS;vr`v*XDdK Ci~,G4MI\vVbV;%d#ZK`ivB,S;vmPi!"Fky] db2look dv4(Dm;vmD}]+;PT&D2+jE5,rKa9TBmD#$ b=F5# `XE": GFPMw}{ |D(F&CLr INGEST 5CLr"}MO"# v ek5CLr'Vy]|,VN5Dmo=9lP5# v ek5CLrZKPek1Jmd{&CLr|B?jm# D~q=M}]`M D~# PC/IXF PC f>D/I;;q= (IXF),bGZ}]b\mwPxP}];;DW!q =#PC/IXF GT}]bmDa9/hv,C}]bm|,Z?mDb?m># CURSOR T SQL i/ywDNj#v0k5CLr'VKD~`M# 9C DEL r ASC }]D~q=1,&ZD~9C;P (LF) V{# – 4Td{Yw53DD>D~9CX5{/;P{ (CRLF) rP# v D~ax{ – 4T UNIX Yw53DD>D~;PD~ax{# – 4Td{Yw53DD>D~PD~ax{ (X’1A’)# IZ DEL D~,yTIT+|GS;vYw53+d=m;vYw5 3#g{TD>==+dD~,D~+dLrMIT&m@5ZYw53Dnp;T ~xF==+dD~1,;a4PPVt{MD~ax{*;Yw# }]F/5CLrMN< 181 ":g{V{}]VN|,PVt{,ZD~+dZdMa*;b)V{#Kn*; +|,8},G4|G FLOAT #?#g{|P!}cx ;P8},G4|G DECIMAL #?#g{|;P!}cM8},G4|G INTE- GER #?# v e I9C decpt D~`M^N{8(!}cV{# # .xF}VM!cM}V;X O*{}5# BLOB M CLOB C+}E.`DV{(g{( p4DV{}]# (grG(gV{.#CV{ .Cw}]bP5# }]F/5CLrMN< 183 m 22. DEL D~q=IS\D}]`Mq= (x) }]`M D5JVZ}#Y(C} E(″″)TC5xP(g# DECIMAL xP*,C54 ,}ZdP# GRAPHIC(vJCZ DBCS) #.xF}VM! cM}V;XO*{}5# LONG VARCHAR C+}E.`DV{(g{( p4DV{}]# (grG(gV{.#CV{ .Cw}]bP5# 184 }]F/5CLr8OMN< m 22. DEL D~q=IS\D}]`Mq= (x) }]`M #. xF}VM!cM}V;XO *{}5# TIME hh.mm.ss(!1VSk)#b GCV{(g{(p4D ISO q = D 1 d 5 # } g : “09.39.43” (grG(gV{.,CV{ .|,k?j}]bDXrz k;BDq=DUZ5# TIMESTAMP yyyy-mm-dd-hh.mm.ss.nnnnnn (jBU!1VSk"k)# CV{(g{(p4Dm>U ZM1dDV{.# (grG(gV{.,CV{ .|,If"Z}]bPD1 dAG5# VARCHAR C+}E.`DV{(g{( p4DV{}]# (grG(gV{.#X* 1,+XOV{.Tk}]b PDnsmH`%d# VARGRAPHIC(vJCZ DBCS) } DEL D~: TBG;v DEL D~>}#?;P}5wKG(gV{.D9C#IZV{}]|,:E,yTQ+P(g{| D*VE# Smith, Bob;4973;15.46 Jones, Bill;12345;16.34 Williams, Sam;452;193.78 ": 1. Uq(X’20’)@6;\w*P'(g{# 2. Z}Z;vV{0fDUqr_%*q5Pns;vV{sfDU q#;a>}%*q5Pd6kDUq# 3. IZdc(.)k1dAG5PDdce;,yT|;GP'DV{V{.(g{# 4. TZ? DBCS( D~ax#;a(#&C_P5D%*q1Y%*q5,2ITm>;.Uq# 8. IZ3)z7+V{VND$H^F* 254 r 255 vVZ,yT,?1!q(#}g, db2 load from ... modified by chardel0x0C coldelX1e ... }]F/ZdD(g{Jb +V{(g{ 1!ivB,TZ DEL D~DyZV{DVN,VNPDNNV{(g{5} #}g,Y(V{(g{G+}E,g{ Iam 6″ tall.,G4 DEL D~PDdvD>T>* ″Iam6″″ tall.″`4,g{ DEL D~PDdkD>* ″What a ″″nice″″ day!″,G4* What a ″nice″ day! nodoubledel I(}8( nodoubledel D~`M^N{T*+V{#T is a manager", +bM*TB=P:Vincent M is a manager,-rG E HZV{(g{(″)#g{9C delprioritychar,G4V{(g{(″) EHZP(g{(),bb6E,; DEL D~+}7X bM*;P:Vincent is a manager# G(g ASCII (ASC) D~q= G(g ASCII q=(TZP 54I(g{Vt# Z}]D~ G($ ASC D~#g{48(C^N{,G4m>C}]D~Gd$ ASC D~# G(g ASCII q=ITCZkNN9CP}]q=D ASCII z7(|(V&mw); ;}]#?v ASC D~;PPTVZ;CN=8(D;C#;PZDZ; v;C*VZ;C 1#?v;CTDZ;v*XGCPD*: ASC file ::= Row 1 data || Row delimiter || Row 2 data || Row delimiter || . . . }]F/5CLrMN< 187 Row n data Row i data ::= ASCII characters || Row delimiter Row Delimiter ::= ASCII line feed sequencea v a Y(G<(g{G;P{,4 ASCII x0A#Z Windows Yw53OzID}]I T9C+VZDX5{/;P{j<,4 0x0D0A#EBCDIC zk3D}]&C9C EBCDIC LF V{(0x25)w*G<(g{(I9C LOAD |nD codepage D~` M^N{0k EBCDIC }])#@6;a+G<(g{bMItZ}]VN# ASC }]`Mhv: m 23. ASC D~q=IS\D}]`Mq= }]`M UZ5DV{.,CUZ5Dq=k?j}]bDXrzk; B# *D6'ZDVN# DBCLOB( v J CZ DBCS) <}VZDV{.#f}VZDV{.^'"RG;IS\D#X *1,+XOP'V{.DR_?VTk?jPDnsmH`% d# DECIMAL S \ N N } V ` M (SMALLINT"INTEGER"BIGINT"DECIMAL r FLOAT)D# ?#g{wv5;Z*1d5DV{.,C1d5Dq=k?j}]bDXrzk; B# *D6'ZDVN# TIMESTAMP m>If"Z}]bPD1dAG5DV{.# *D6'ZDV N# VARCHAR ;vV{.#X*1,+XOV{.DR_Tk?jPDnsmH `%d#g{ ASC XOUW!nP',G4+%t-} ASC D~: }]F/5CLrMN< 189 TBG;v ASC D~>}#?;P{PP"V N(rC'8(D d{5)# 4. g{?jP;IU,G4"T+UWVN PC f>D IXF(PC/IXF)D~q=G}]b\mwT/I;;q= (IXF)}];;e 5a9DD`#IXF e5a9(EC4JmX5}]ba9k}]D;;#PC/IXF e 5a9Jm}]b\mwD3r|,BPG<`M: v ;vG<`M* H D7G< v ;vG<`M* T DmG< v `vG<`M* C DPhv{G<(mP?P;vG<) v `vG<`M* D D}]G<(mP?PI;vr`v D G)# ZvV H G<.sDNN;C,PC/IXF D~9I\|,G<`M* A D&CLrG <#PC/IXF D~PJmfZb)G<,T9&CLr\;Z PC/IXF D~P|(44 PC/IXF q=(eDd{}]#TZA! PC/IXF D~DNNLr,g{;Kb&CL rj6Z A G{*7#K8>{G;v{}5D 6 VZr RTkV{m>,C{}58( PC/IXF G{.sD?VD$H(T VZF),4\GU LOB D LLS# ?v XML PD D G XML }]5w{ (XDS) D$H,sftzC XDS >m# }g,TB XDS: XDS FIL="a.xml" OFF="1000" LEN="100" SCH="RENATA.SCHEMA" /> Z D G: 0x3D 0x00 XDS FIL="a.xml" OFF="1000" LEN="100" SCH="RENATA.SCHEMA" /> PC/IXF D~G,"ndK0,;&C+?CUWxP8>#;*4Z}]`M8>$HD;C9C dP;v}VVN(g IXFCLENG),M&CTdndUq#b)}VVN|(: IXFHRECL, IXFTRECL, IXFCRECL, IXFDRECL, IXFARECL, IXFHHCNT, IXFHSBCP, IXFHDBCP, IXFTCCNT, IXFTNAML, IXFCLENG, IXFCDRID, IXFCPOSN, IXFCNAML, IXFCTYPE, IXFCSBCP, IXFCDBCP, IXFCNDIM, IXFCDSIZ, IXFDRID ":}]b\mw PC/IXF D~q=k System/370 ;,# PC/IXF G<`M: PeVy> PC/IXF G<`M: v 7 v m v Phv{ }]F/5CLrMN< 191 v }] v &CLr DB2 9CTB_V&CLrS`M: v w} v cNa9 v Sm v Sx v U9 v j6 v DB2 SQLCA ?v PC/IXF G<`M;(e*;vVNrP,b)VNGXhD,"RXk4T>D 3rvV# HEADER RECORD FIELD NAME LENGTH TYPE COMMENTS ---------- ------- --------- ------------- IXFHRECL 06-BYTE CHARACTER G<$H IXFHRECT 01-BYTE CHARACTER G<`M =“H” IXFHID 03-BYTE CHARACTER IXF j6 IXFHVERS 04-BYTE CHARACTER IXF f> IXFHPROD 12-BYTE CHARACTER z7 IXFHDATE 08-BYTE CHARACTER 4kDUZ IXFHTIME 06-BYTE CHARACTER 4kD1d IXFHHCNT 05-BYTE CHARACTER W?G{#|I 6 vVZiI,TrRTkDV{4m>{}5,C{ }58(G<$H8>{.sD PC/IXF G4(z7Df>r"P f#}]b\mw9CKVN48>X(Z}]b\mwD}]DfZ# IXFHDATE 4kD~DUZ,q=* yyyymmdd# IXFHTIME 4kD~D1d,q=* hhmmss#KVNGI!D,"RITt*UW# 192 }]F/5CLr8OMN< IXFHHCNT KD~PZ;v}]G<.0D H"T M C G<}#A G<4|(ZKF} P# IXFHSBCP %VZzk3VN,|,;v%VZV{,CZm> SBCS CPGID r“00000”# DBCS CPGID r“00000”# {#|I 6 vVZiI,TrRTkDV{4m>{}5,C{ }58(G<$H8>{.sD PC/IXF GKVN,r_+|f"ZN}]D-<4#b;GNKV N,r_+|f"ZNwvPt T+ZS4BDPhv{(C)G}](D)GUW,x PC 8( PC/IXF D~PD }]9C IBM PC zwq=# IXFTLOC }]D;C#}]b\mwv'V5 I,m>C}]ZKD~Z?# IXFTCCNT KmPD C G<}#bG{}5DrRTkV{m># IXFTFIL1 UPVNhC*=vUqTkwz IXF D~PD#tVN`%d# IXFTDESC PXCmDhvT}]#b;GNKV N,r_+|f"ZN}]b,G4KVN|, NOT NULL WITH DEFAULT# IXFTPKNM Tm(eDw|D{F(g{fZ)#C{Ff"*T NULL axDV{.# IXFTDSPC #tKVNT)+49C# IXFTISPC #tKVNT)+49C# IXFTLSPC #tKVNT)+49C# COLUMN DESCRIPTOR RECORD FIELD NAME LENGTH TYPE COMMENTS ---------- ------- --------- ------------- IXFCRECL 006-BYTE CHARACTER G<$H IXFCRECT 001-BYTE CHARACTER G<`M =“C” IXFCNAML 003-BYTE CHARACTER P{$H 194 }]F/5CLr8OMN< IXFCNAME 256-BYTE CHARACTER P{ IXFCNULL 001-BYTE CHARACTER PJmU IXFCDEF 001-BYTE CHARACTER P_P1!5 IXFCSLCT 001-BYTE CHARACTER P!Pj> IXFCKPOS 002-BYTE CHARACTER w|PD;C IXFCCLAS 001-BYTE CHARACTER }]` IXFCTYPE 003-BYTE CHARACTER }]`M IXFCSBCP 005-BYTE CHARACTER %VZzk3 IXFCDBCP 005-BYTE CHARACTER +VZzk3 IXFCLENG 005-BYTE CHARACTER P}]$H IXFCDRID 003-BYTE CHARACTER “D”G{#|I 6 vVZiI,TrRTkDV{4m>{}5,C{ }58(G<$H8>{.sD PC/IXF G4rcCZJm!q}]PD3vPS/#4k PC/IXF D ~DLr&\GZKVNPf" Y#A! PC/IXF D~DLr&vTKVN# IXFCKPOS w|P|,DPD;C#P'56'Z 01 = 16 .d,r_g{P4|(Z w|P,G4P'5* N# IXFCCLAS *Z IXFCTYPE VNP9CD}]`MD`#}]b\mwv'VX5`M (R)# IXFCTYPE PD}]`M# IXFCSBCP |,;v%VZV{,CZm> SBCS CPGID#KVNT%VZV{}]8( CPGID,bViv-#vVZKPD D G DBCS CPGID#KVNT+VZV{}]8( CPGID,bViv-#vVZKPD D G#TZm;)d{}]`M,KVNV*=vSVN:3 vVZ CZ+H,2 vVZCZ!};;b)SVN#S V9.7 *<,TZ1dAG}]`M,KVN|,;vCZ8(1dAG+HD {}DrRTkV{m># IXFCDRID D G#IZ PC/IXF D~P9 CtI D G<4|,?P}]#KVN8(CZ}]PDtI D G3PD}]ZP}]DZ;v D G m}]PDdP;v D G< P#bGKP}]Z D G{;qr|+8r}]>m#g{3P|,d $}],G4}]>mT10$H8>{*7#D GKV N,r_+|f"ZND PC/IXF ;'V}i#rK,KVNXk|,m>c{ }5DV{# IXFCDSIZ ?v,Ds!r6'#KVND$H*?v, 5 vVZ#r*;'V}i(4 ,}Xk*c),yTKVND$H*c,"R5JO;fZ# DATA RECORD FIELD NAME LENGTH TYPE COMMENTS ---------- ------- --------- ------------- IXFDRECL 06-BYTE CHARACTER G<$H IXFDRECT 01-BYTE CHARACTER G<`M =“D” IXFDRID 03-BYTE CHARACTER “D”G{#|I 6 vVZiI,TrRTkDV{4m>{}5,C{ }58(G<$H8>{.sD PC/IXF G||,mD}]5# IXFDRID G# Pu?}]Dq=!vZCPGqIU: v g{CPIU(IXFCNULL VNhC* Y),G4Pu?}]|(U8> {#g{CP;*U,G48>{szX(Z}]`MDE",|(5J} ]b5#U8>{GI=vVZiID5,g{GU,G4hC* x’0000’, g{*U,G4hC* x’FFFF’# v g{CP;IU,G4Pu?}]v|(X(Z}]`MDE",|(5J }]b5# TZd$}]`M,X(Z}]`MDE"|(10$H8>{#10$H8 >{GI=vVZiID{},q=I IXFTMFRM VN8(# D G{#|I 6 vVZiI,TrRTkDV{4m>{}5,C{ }58(G<$H8>{.sD PC/IXF GbG;v&CLrG<#g{Lr; +e~&CLrj6zmD}]DZ]Mq=,G4+vTb)G<# IXFAPPID &CLrj6,j64( A Gr_4k A G IXFAIDXT 001-BYTE CHARACTER type of index IXFAPCTF 002-BYTE CHARACTER amount of pct free IXFAPCTU 002-BYTE CHARACTER amount of minpctused IXFAEXTI 001-BYTE CHARACTER reserved IXFACNML 006-BYTE SHORT INT length of name of the columns IXFACOLN varying CHARACTER name of the columns in the index +T?vC'(eDw}8(K`MD;vG<#KG{#|I 6 vVZiI,TrRTkDV{4m>{}5,C{ }58(G<$H8>{.sD PC/IXF GbG;v&CLrG<#g{Lr; +e~&CLrj6zmD}]DZ]Mq=,G4+vTb)G<# IXFAPPID &CLrj6,|+ DB2 j6*4(K A G{#|I 6 vVZiI,TrRTkDV{4m>{}5,C{ }58(G<$H8>{.sD PC/IXF GbG;v&CLrG<#g{Lr; +e~&CLrj6zmD}]DZ]Mq=,G4+vTb)G<# IXFAPPID &CLrj6,|+ DB2 j6*4(K A Gw}*cDP# DB2 SUBTABLE RECORD FIELD NAME LENGTH TYPE COMMENTS ---------- -------- --------- ------------- IXFARECL 006-BYTE CHARACTER G<$H IXFARECT 001-BYTE CHARACTER G<`M =“A” IXFAPPID 012-BYTE CHARACTER application identifier = ’DB2 02.00’ IXFAYTYP 001-BYTE CHARACTER application specific data type = ’Y’ IXFADATE 008-BYTE CHARACTER S“H”G<4kDUZ IXFATIME 006-BYTE CHARACTER S“H”G<4kD1d IXFASCHL 003-BYTE CHARACTER `M#={$H IXFASCHN 256-BYTE CHARACTER `M#={ IXFATYPL 003-BYTE CHARACTER `M{F$H IXFATYPN 256-BYTE CHARACTER `M{ IXFATABL 003-BYTE CHARACTER m{$H IXFATABN 256-BYTE CHARACTER m{ IXFAPNDX 010-BYTE CHARACTER 8mDSmw} IXFASNDX 005-BYTE CHARACTER starting column index of current table IXFAENDX 005-BYTE CHARACTER ending column index of current table +9CK`MD;vG<4hvcNa9PD3vSm#tZcNa9DyPSmG {#|I 6 vVZiI,TrRTkDV{4m>{}5,C{ }58(G<$H8>{.sD PC/IXF GbG;v&CLrG<#g{Lr; +e~&CLrj6zmD}]DZ]Mq=,G4+vTb)G<# IXFAPPID &CLrj6,|+ DB2 j6*4(K A G{#|I 6 vVZiI,TrRTkDV{4m>{}5,C{ }58(G<$H8>{.sD PC/IXF GbG;v&CLrG<#g{Lr; +e~&CLrj6zmD}]DZ]Mq=,G4+vTb)G<# IXFAPPID &CLrj6,|+ DB2 j6*4(K A G{#|I 6 vVZiI,TrRTkDV{4m>{}5,C{ }58(G<$H8>{.sD PC/IXF GbG;v&CLrG<#g{Lr; +e~&CLrj6zmD}]DZ]Mq=,G4+vTb)G<# IXFAPPID &CLrj6,|+ DB2 j6*4(K A G{#|I 6 vVZiI,TrRTkDV{4m>{}5,C{ }58(G<$H8>{.sD PC/IXF GbG;v&CLrG<#g{Lr; +e~&CLrj6zmD}]DZ]Mq=,G4+vTb)G<# IXFAPPID &CLrj6,|+ DB2 j6*4(K A Gj6P;1G GENERATED#yPd{5DbMb6 ECPD`M* GENERATED BY DEFAULT# IXFASTRT j6PD START AT 5,Cj6PGZ4(m1a)x CREATE TABLE o dD# IXFAINCR j6PD INCREMENT BY 5,Cj6PGZ4(m1a)x CREATE TABLE odD# 204 }]F/5CLr8OMN< IXFACACH j6PD CACHE 5,Cj6PGZ4(m1a)x CREATE TABLE od D#5“1”T& NO CACHE !n# IXFAMINV j6PD MINVALUE 5,Cj6PGZ4(m1a)x CREATE TABLE o dD# IXFAMAXV j6PD MAXVALUE 5,Cj6PGZ4(m1a)x CREATE TABLE o dD# IXFACYCL j6PD CYCLE 5,Cj6PGZ4(m1a)x CREATE TABLE od D#5“Y”T&Z CYCLE !n,xNNd{5T&Z NO CYCLE# IXFAORDR j6PD ORDER 5,Cj6PGZ4(m1a)x CREATE TABLE od D#5“Y”T&Z ORDER !n,xNNd{5T&Z NO ORDER# IXFARMRL IXFARMRK VNPD"M$H(TVZF)# IXFARMRK bGC'dkDkj6P`X*D"M#b;GN^(9C IXF D~4Zsx{#|G;vI 6 vVZiIDV{,C4m>{}5,C{} 58(G<$H8>{.sD PC/IXF GbG;v&CLrG<#g{Lr; +e~&CLrj6zmD}]DZ]Mq=,G4+vTb)G<# IXFAPPID &CLrj6,|+ DB2 j6*4(K“A”G -9 223 372 036 854 775 808 k 9 223 372 036 854 775 807 .dD{}# IXFCSBCP M IXFCDBCP ;Pbe,&C* c#IXFCLENG ;a;9C,&C|,UW# BLOB M CLOB 404 M 408 d$V{.#V{.Dns$H|,ZPhv {GmaSO10$H8> {w*0:,bG;v 4 VZ{},CZ8( V{.D$H(TVZF)#CV{.ZI IXFCSBCP 8>Dzk3P# TBhvvJCZ BLOB:g{ IXFCSBCP * c,G4V{.*;}],"R;&;NNd ;LrxP*;# TBhvvJCZ CLOB:g{ IXFCDBCP ;*c,G4V{.9I|, IXFCDBCP 8 >Dzk3PD+VZV{# BLOB_LOCATION _ SPECIFIER M DBCLOB_ LOCA- TION_ SPECIFIER 960"964 M 968 ($VN,;\,} 255 vVZ#LOB ;C 5w{ (LLS) Z IXFCSBCP 8>Dzk3 P#g{ IXFCSBCP *c,G4 LLS *;} ],"R;&;NNd;LrxP*;#g{ IXFCDBCP ;*c,G4V{.9I|, IXFCDBCP 8>Dzk3PD+VZV{# r* LLS D$Hf"Z IXFCLENG P,yT -< LOB D5J$H+a*'#r*+9C LLS D$H44( LOB,yT;&9C_PK `MDPD PC/IXF D~4XB4( LOB V N# 206 }]F/5CLr8OMN< m 24. PC/IXF }]`M (x) {F IXFCTYPE 5 hv BLOB_FILE" CLOB_FILE M DBCLOB_FILE 916"920 M 924 |, SQLFILE a9"RndK name_length M name VND($VN#Ca9D$H|, ZPhv{GDzk3P#g{ IXFCDBCP ;*c,G4D~{9I|, IXFCDBCP 8 >Dzk3PD+VZV{#g{ IXFCSBCP *c,G4D~{*;}],"R;&;NN d;LrxP*;# r*a9D$Hf"Z IXFCLENG P,yT -< LOB D5J$H+a*'#r*+9C $H sql_lobfile_len 44( LOB,yT;&9 C_P`M* BLOB_FILE"CLOB_FILE r DBCLOB_FILE DPD IXF D~4XB4( LOB VN# CHAR 452 ($V{.#CV{.$H|,ZPhv{G Dzk 3P#g{ IXFCDBCP ;*c,G4V{. 9I|, IXFCDBCP 8>Dzk3PD+V ZV{#g{ IXFCSBCP *c,G4V{.* ;}],"R;&;NNd;LrxP*;# DATE 384 {OqP_{zD1dc#?vUZG;v9 CzJjmaS O10$H8>{w*0:,bG;v 4 VZ {},CZ8(+VZV{.D$H(4,K {}D5GV{.$HD;k)#V{.Z C G 6 ' Z -2 147 483 648 k +2 147 483 647 .dD{}#IXFCSBCP M IXFCDBCP ;Pbe,&C*c#IXFCLENG ;a;9C,&C|,UW# LONGVARCHAR 456 d$V{.#V{.Dns$H|,ZPhv {GmaSO10$H8> {w*0:,bG;v 2 VZ{},CZ8( V{.D$H(TVZF)#CV{.ZI IXFCSBCP 8>Dzk3P#g{ IXFCDBCP ;*c,G4V{.9I|, IXFCDBCP 8 >Dzk3PD+VZV{#g{ IXFCSBCP *c,G4V{.*;}],"R;&;NN d;LrxP*;# 208 }]F/5CLr8OMN< m 24. PC/IXF }]`M (x) {F IXFCTYPE 5 hv LONG VARGRAPHIC 472 +VZV{Dd$V{.#Phv{GmaSO 10$H8>{w*0:,bG;v 2 VZ{ },CZ8(+VZV{.D$H(4,K{ }D5GV{.$HD;k)#V{.Z C G 6'Z -32 768 = +32 767 .dD{ }#IXFCSBCP M IXFCDBCP ;Pbe,& C*c#IXFCLENG ;a;9C,&C|,U W# TIME 388 {O 24 !11SD1dc#?v1dmaSO10$H8> {w*0:,bG;v 2 VZ{},CZ8( V{.D$H(TVZF)#CV{.ZI IXFCSBCP 8>Dzk3P#g{ IXFCDBCP ;*c,G4V{.9I|, IXFCDBCP 8 >Dzk3PD+VZV{#g{ IXFCSBCP *c,G4V{.*;}],"R;&;NN d;LrxP*;# }]F/5CLrMN< 209 m 24. PC/IXF }]`M (x) {F IXFCTYPE 5 hv VARGRAPHIC 464 +VZV{Dd$V{.#Phv{GmaSO 10$H8>{w*0:,bG;v 2 VZ{ },CZ8(+VZV{.D$H(4,K{ }D5GV{.$HD;k)#V{.Z C G ;vV8,CV8;Z PC/IXF }]`MX sPk}]b\mw}]`MXsPD;c&#“N”8>5CLr}Z4(B}] }]F/5CLrMN< 217 bm(+4(8>D}]`MD}]bP)#“E”8>5CLr}Z+}]D}]`MD}]bPGP'?j)# 2. V{.}]`MI(}zk3tT4xV#b)tTT>*PrT (SBCS,DBCS), dP: v SBCS *c5r8>V{}]`MD%VZzk3tTDGc5# v DBCS *c5r8>V{}]`MD+VZzk3tTDGc5# 3. g{Cm8>I+ PC/IXF V{P PC/IXF }]G{*7#bG;vI 6 vVZiIDV{,m >|, PC/IXF G<$HD{}5(TVZF),|;|(G<$H8>{>m,4 \G<$Hu% 6 vVZ#G<$HVNDC>GJm PC Lrj6G<_g# v *cZ9ud$}]Df"Ud,"R\bZVNVn*`vG<1D4S&m, PC/IXF ;'Vf> 0 IXF X G<,xG'V D Gzk3*;# k forcein D~`M^N{PXD}]`MD5+4-y4F#;a9Czkc3d 4xPzk373|D#TZ($?jP,CUqnd: v 1*PrT,dP x m>Gc%VZzk35, x y m>Gc+VZzk35#’-’ m>4(ezk35# 3. ZwVzk3tTTP9C;,V81kwwxP#;,DV8zm;,D5#} g,g{ PC/IXF }]`MT>* (x,y),x}]bPT>* (a,y),G4 x ;HZ a,+ PC/IXF D~M}]b_P`,D+VZzk35 y# 4. ;PV{M* ’-’# 6. a{D}]`MI forcein }]`MoePhvDfr7(# 220 }]F/5CLr8OMN< 7. \xa{GfrT^'r;f]}]`MD4&# Bf=vmT>: v Dzk3tTDVPmP#g{ PC/IXF }]`M^'r;f],G45CLr+\ xb)}]`M# m 31. CZ SBCS D4_P;f]}] `MD?j}]bP#Z SBCS r DBCS 73P9C forcein 1(Xp5w1} b),BP}]`MoeJC: v Z SBCS 73P,forcein Jm: – + PC/IXF BIT }]`M(TZ PC/IXF V{P,IXFCSBCP=0=IXFCDBCP) #“N”8>5CLr}Z4(B}]bm;“E”8>5CLr} Z+}]Zyv,Unicode }]b'V DEL"ASC M PC/IXF D~q=# 1S Unicode }]bXoT'V DB2 }]F/5CLra)KTB>XoT'V: v yj6D#=,r_(}w}]D~PD XML }]5w{yj6D#=#9IT 9C XMLPARSE !n8(XZ?v"Ud"F/T\MBq*zX*,k9C*zmF/x;GQz mF/# IwCC}L;Nr`N,TC}L4PD?vYw4P;NwC#9C`vwCJ mzPd{!q,}g,!{F/rXFN19?jmQzTxP|B# 226 }]F/5CLr8OMN< PXF/ XML }]DX*"bBn h*"b#Z**{F#,y,XMLFILE !n2a)K;V=(48( EXPORT 5CLr zID XML D~Dy>{F#1! LOB D~y>{FG{FG{F"SE Gnz*};}D`E)9{T0 .lob r .xml )9{iI# } ZTB>}P,yP LOB 5+4kD~ /mypath/t1export.del.001.lob,xyP XDM 5}+4kD~ /mypath/t1export.del.001.xml: EXPORT TO /mypath/t1export.del OF DEL MODIFIED BY LOBSINFILE SELECT * FROM USER.T1 ZTB>}P,Z;v LOB 5+4kD~ /lob1/t1export.del.001.lob,Z~v LOB 5+4kD~ /lob2/t1export.del.002.lob,Z}v LOB 5+=SA /lob1/ t1export.del.001.lob,ZDv LOB 5+=SA /lob2/t1export.del.002.lob,TK `F: EXPORT TO /mypath/t1export.del OF DEL LOBS TO /lob1,/lob2 MODIFIED BY LOBSINFILE SELECT * FROM USER.T1 ZTB>}P,Z;v XDM 5}+4kD~ /xml1/xmlbase.001.xml,Z~v XDM 5}+4kD~ /xml2/xmlbase.002.xml,Z}v XDM 5}+4k /xml1/ xmlbase.003.xml,ZDv XDM 5}+4k /xml2/xmlbase.004.xml,TK`F: EXPORT TO /mypath/t1export.del OF DEL XML TO /xml1,/xml2 XMLFILE xmlbase MODIFIED BY XMLINSEPFILES SELECT * FROM USER.T1 } TZ|,%v XML PD“mytable”mMTB IMPORT |n: IMPORT FROM myfile.del of del LOBS FROM /lobpath XML FROM /xmlpath MODIFIED BY LOBSINFILE XMLCHAR replace into mytable g{“myfile.del”|,TB}]: mylobfile.001.lob.123.456/ IMPORT 5CLr+"TSD~ /lobpath/mylobfile.001.lob PD~+F?* 123 & *< XML }]# XDS Gm>* XML jG(d{FG“XDS”)DV{.,|_PCZhvXZPP5J XML }]DE"DtT;bVE"f0|,5J XML }]DD~{,T0CD~Z XML }]D+F?M$H#TBPmPhvK XDS DtT# FIL |, XML }]DD~D{F#;\8(|{\@#;'VS|{\@"&"’ M ″)Xk} TB>}T> XDS vVZ(g ASCII }]D~P1Dy=#XML }]f"Z xmldocs.xml.001 D~PVZ+F?S 100 *m|,D+}EXkS6# "" TB>}T>j< SQL j6 ANTHONY.purchaseOrderTest#Z XDS P,xVs!4 Dj6?VXkEZ " V{5ed: "" i/M XPath }]#M I(}9CT SQL a)D XQuery /}r_(}1SwC XQuery 4CJ}]bmP D XML }]#i/M XPath }]#M(XDM)D5}I\Gq=Ks(D~"d1!tk6p"9C|GD5CLrT09C?D# s(D~(1!tk6p) 5CLr/?D db2ueiwi.bnd(CS) IMPORT/EXPORT#C4i/XZmPMw} DE"# db2uexpm.bnd(CS) EXPORT#C4ST}w}Mliwbhv SQL o(o(o(tSEB;P# ─── {Em>o(tSEO;P# ── {Em>o(Z.=_(w76)O# required_item I!nT>Zw76B=# required_item optional_item g{3vI!nT>Zw76O=,G4Z4P1Cn+;pwC,vCZa_IA TxQ# required_item optional_item g{zITS=nr`nPxP!q,G4|GaTQ~DN=vV# g{zXk!qdP;n,G4Q~nPD;n&T>Zw76O# required_item required_choice1 required_choice2 g{Iy]iv!qdP;n,G4yPQ~n+T>Zw76B=# required_item optional_choice1 optional_choice2 g{dP;nG1!5,G4Cn+T>Zw76O=,xd`n+T>Zw76B =# © Copyright IBM Corp. 1993, 2012 235 required_item default_choice optional_choice optional_choice g{;v}7SwIO=5X=s_,G4m>ITX49CCn#ZbVivB, wvX4n.dXkC;vr`vUqt*# required_item repeatable_item g{X4}7P|,;v:E,G4XkC:E+wvX4nVt*# required_item , repeatable_item g{X4}7;ZQ~nO=,G4m>zIT!q`vQ~n,r_X4!q%v n# X|VGy44#d?o(PIC'a)D{Fr5# g{T>Kjc{E"2(E"cuKc{r_d{byD{E,G4Xk+|Gw *o(D;?V4dk# P1,%vd?m>;v\sDo(N#}g,ZB jP parameter-block D{vo(N: required_item parameter-block parameter-block: parameter1 parameter2 parameter3 parameter4 “sn?{E”(*).dD`ZNIT4Nb3r8(# required_item item1 * item2 * item3 * item4 OIT4Nb3r8( item2 M item3#Bf=VivE"4PYw: v *U/k db2move |n`XDJbD}],k*A"vKK|nD?<#y]ZK| nP8(DYwR=BPD~: – TZ COPY Yw,iR{* COPY.timestamp.ERR M COPYSCHEMA.timestamp.MSG DD~#g{98(K LOAD_ONLY r DDL_AND_LOAD ==,9hiR{* LOADTABLE.timestamp.MSG DD~# – TZ EXPORT Yw,iR{* EXPORT.out DD~# – TZ IMPORT Yw,iR{* IMPORT.out DD~# – TZ LOAD Yw,iR{* LOAD.out DD~# v *U/k EXPORT"IMPORT r LOAD |n`XDJbD}],7(|nGq|( MES- SAGES N}#g{|(KN},G4U/dvD~#g{z;8(d{?Lr – LL v DB2 i. – PDF D~(IBX) – PDF D~(Z DB2 PDF DVD P) – !"fi. v |nPoz – |noz – {"oz ":DB2 E"PDwbD|B5JH PDF i.r2=4i.D|B5J_#*q!n BE",k20ICDD5|Br_ND ibm.com OD DB2 E"PD# zITZ_CJ ibm.com ODd{ DB2 c:http:// www.ibm.com/software/data/sw-library/# D54! RGG#XSzT DB2 D5D4!#g{zkMgNDF DB2 D5av(i,kr db2docs@ca.ibm.com "MgSJ~#DB2 D5!i+DAzDyP4!,+^(1S xzp4#k!I\a)_eD>},byRGE\|CXKbzyXDDJb#g {z*a)PX_ewbrozD~D4!,kSOjbM URL# k;*9CTOgSJ~X7k DB2 M''Vz9*5#g{zv=D5^(bvD DB2 M-kf># !\b)mj6i.P!"f,+I\4ZzyZzRrXxa)# ?N|BVa1,m%EDVaDnBf># ":DB2 E"PDD|B5JH PDF r2=4i.D|B5J_# © Copyright IBM Corp. 1993, 2012 239 m 34. 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# =< E. 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 ?: 242 }]F/5CLr8OMN< 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# =< E. 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# 244 }]F/5CLr8OMN< 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# =< E. 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 246 }]F/5CLr8OMN< =< F. yw >E"G*Z@za)Dz7M~q`4D#PXG IBM z7DE"GyZWNvf KD51DIqE"Raf1|B# IBM I\Zd{zRrXx;a)>D5PV[Dz7"~qr&\XT#PXz10 yZxrDz7M~qDE",krz1XD IBM zmI/#NNT IBM z7"L rr~qD}C"GbZw>r5>;\9C IBM Dz7"Lrr~q#;*;V8 IBM D*6z(,NN,H&\Dz7"Lrr~q,I\Q5Pr}Zjkk>D5Z]PXDwn({#a)>D5"4ZhC '9Cb)({DNNmI#zITCif==+mIi/Dy: IBM Director of Licensing IBM Corporation North Castle Drive Armonk, NY 10504-1785 U.S.A. PX+VZV{/ (DBCS) E"DmIi/,kkzyZzRrXxD IBM *6z( ?E*5,rCif==+i/Dy: Intellectual Property Licensing Legal and Intellectual Property Law IBM Japan, Ltd. 1623-14, Shimotsuruma, Yamato-shi Kanagawa 242-8502 Japan >un;JC"zrNNbyDunk1X(I;;BDzRrXx:International Busi- ness Machines Corporation“4V4”a)>vfo,;=PNNV`D(^[Gw>D9 G5,D)#$,|(+;^Z5,DPXGV("JzMJCZ3VX(C>D# $#3)zRrXxZ3);WP;Jmb}w>r5,D#$#rK>unI\; JCZz# >E"PI\|,JODBf>P#IBM ITf1T>JOPhvDz7M/rLrxPD xM/r|D,x;mP(*# >E"PTG IBM Web >cDNN}C<;G*K=cp{Ea)D,;TNN== d1TG) Web >cD#$#G) Web >cPDJO;GK IBM z7JOD;? V,9CG) Web >cx4DgU+IzTPP## IBM IT4|O*J1DNN==9CrV"zya)DNNE"x^kTzP#NN pN# © Copyright IBM Corp. 1993, 2012 247 >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- 248 }]F/5CLr8OMN< 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. =< F. yw 249 250 }]F/5CLr8OMN< w} [B] oz SQL od 241 s(D~ 5CLr9CD 233 j6G< 191 j6P }t/U>G< 86 m4, 0kYw 79 "PT LOAD 5CLr 64 ;IV4D}]b 0k!n 34 [C] cNa9G< 191 ek }] Vx}]b73 122 ek1d/: (ITC) m 0k 55 ek}] =8 124 X(;}]b|n 162 X(r4- 9CzIDE> 140 XBt/m 4( 107 u} 10 \ LBAC #$D 10 XML 7 f]T 97 (F 97 0k}] f>f]T 97 Ev 86, 93 `S 94 (F 97 ^F 88 (zf"wTs XML }]5w{ 229 4- DB2 }]bDgZf> 140 4-5CLr GENERATE SCRIPT !n 1 REDIRECT !n 1 4F $_ 128 [G] |B DB2 E"PD 242, 243 JOoO LL 245 *zE" 245 oO}] }]F/ 237 [H] P 129 [Q] (^ LOAD 38 [R] U>G< 0k5CLr 86 [S] zIP ek Vx}]b73 122 ( +d g=( 181 }]m>( (x) yZjEDCJXF (LBAC) (PC/IXF) 190 D~`M^N{ dumpfile 85 w} 253 Jb7( LL 245 ICDE" 245 [X] {" D~ ASC 189 DEL 185 F/}] } Vx}]b73 98 Ev 41 \ LBAC #$D}] 46 }]bVx 86, 93 9um 68 XML }] 40 0kYw XBt/ `Vx 95 Ev 81 JmACJ== 83 0k1>;CD~ 83 0kt/U>G< Ev 86 0k>}t/9%U>G< 86 0k5CLr j6P 48 mUd4, 78 mx( 75 m4, 79 4(w} 65 zk3 225 G< 86 >}WN 34 zIP 49 9C SOURCEUSEREXIT F/}] 56 }]bV4 34 w}4FWN 34 X( 37 D~q= 180 D~`M^N{ 69 Hvu~ 38 ^F 38 T\E/ 69 l#m 81 }Cj{T&\ mUd4, 78 m4, 79 Ev 73 *"D~ 85 0kWN 34 INGEST 5CLrHO 178 “;IXBt/0k”D0k 81 SmG< PC/IXF 191 T/4(Vd(ADC) }]F/ 68 V{. delimiter 185 A ADMIN_COPY_SCHEMA }L Ev 1 ASC }]`Mhv 188 ASC D~ q= 187 y> 189 C CDI Ev 104 commit_count dCN} T\w{ 120 CURSOR D~`M }]F/ 52 D DB2 3FE"M DDL i!$_|n 167 DB2 E"PD f> 241 |B 242, 243 db2inidb |n Ev 160 db2inidb |n (x) j8E" 160 DB2LOADREC "amd? V4}] 83 db2look |n j8E" 167 db2move |n Ev 1 #=4F>} 130 j8E" 131 db2relocatedb |n Ev 1 j8E" 162 DB2SECURITYLABEL }]`M 185 delprioritychar D~`M^N{ \ LBAC #$D}]E> 123 U9 116 INGEST 5CLr ek}] 108 XBt/ 115 XBt/m 107 w} 255 INGEST 5CLr (x) &mBD~ =8 124 ;CD~ 83 S seclabelchar D~`M^N{ }] 241 striptblanks D~`M^N{ \ LBAC #$D}]

下载文档，方便阅读与编辑

文档的实际排版效果，会与网站的显示效果略有不同！！

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

下载文档

相关文档