pS2TITYTeT tTTT#T(T)T*T+T,T-T..T2?T<ITFXTPfTRpTUTZTdTnTTTTTTT T;TKTZTkTtTTTTTT TTT"T,T1T6!T@+TE>THITJ_TTgTYvT[T^ThTmTnToTpTrTtTwTyT|T#T3TFTUThTuTTTTTTTTTTT,T:TNTUTcTrTTT T!T"T#T$T&T'T0"T:1TDATGRTIaTNsTXTbTcTdTgTlTvT'T:TFTTTbTkT}TTTTTTTTT%T5TETTTfTuTTTTTTT T T T / T @ T R T h T | T T T T T T T T T# T8 TI T^ Tn T | T! T" T* S S VH V V Tc V S T T T VTTTpSTIVVTVLTTTTTIV{VVV1T tT T HV S TVBVTVS>SpSVTV8SV T >T!T"T#T$T%7T.kT/T8wT9T:GT;S<T=V>T?QV@VAVBt VL VM SN@!SO!SP!SQ?"SR"SS"VT#TU#V'#VP$T$V$V%T[%V%Vc&V'V4'V'V(V%(Va(V(V)Vw)V)V*TB*V*T*V!+V+Vh,V,V,V7-Vt-V-V.VO/V/V0Va0V0T1VJ1Vu1V1V1VZ2V2VH3V z3V 4V M4V 4T b5V5V5V5T6V<6Vi6V6V6V6V7V7T<7Vm7V7V7V7V7V 8V@,8Vg8T8T19TX9T9T9T:TF:T:Vj;V<Vr<V<Vp=V >V>V>Vx?V?Vq@V@VWT:WT;WT<WT=WT>WT?WT@ XTA5XTBXXTCXTDXTEXTFXTG%YTHrYTIYTJYTKZTL6ZTM7ZTNZZT\tZT]ZT^[T_[TzU[T{[T|[T}[T~[T\TH\TZ\T\\Tl\T\T\T\T]TA]T]T]T]T]T ^TH^T^T^T^T^T>_TU_Tw_T_T_T_T `TR`T`T`T$aTtaTaTbTjbTbTbTcTccTcTcT'dTddTdTdT-eT}eTeTfT\fTfTfTgTHgTgTgTgT$hTahThThT,iT|iTiTiT jTVjTjTjT0kTkTkTkT(lTelTlTlTmT+mTlmTmTmTmT@nTvnTnTnTnT&oTOoT oT oT pT pT SpT zpT pT pT pTB pTC 9qTD |qTL qTN qTO rTQ 2rTR krTS rTT rTV rT[ sT` 4sTc esTe sTh sTj sTk tTl QtTm tTn tTo uTp HuTq nuTr uTs uTt uTu :vTv vTy vTz vT~ vT BwT WwT wT wT wT wT xT 1xT TxT xT xT yT `yT yT yT zT LzT zT zT zT 1{T o{T {T {T {T '|T V|T |T |T }T }T Y}T }T }T ~T J~T ~T ~T ~T )T oT T T 'T jT T T T 1T vT T( T2 T3 NT< ~T= T> T? T@ RT] pT_ Td Ti փTs Tx T} DT nT T T T HT gT T T T "T LT uT T T ,T YT T T T T dT T T ҈T T :T wT T ˉT T 1T nT T T T !T aT T T /T vT T T T OT T ƍT T ET T ŽT T <T xT T ЏT T JT T ܐT T 6T T ˑT T ]T T T AT T ߓT T _T T ̔T T JT T ޕT )T iT T T T ET T T T 1T |T T T %T uT řT T TT T ۚT 'T oT TT T^ Tc DTh Tj Tk ɜTm ݜTn To _Tr sTs T| T T 4T rT T ٞT /T eT T T T T 1T IT T ܠT T :T `T T ǡT T T hT T ֢T $T kT T ΣT T 2T vT T ʤT T GT tT T T T T XT zT T ʦT T T "T `T T ާT T QT hT T ȨT T T T \T T T XT T T 8T T! T" T# IT$ T% T& T' iT( T) έT* T+ 6T, @T0 T: T= ʮT> TA TB 3TD WTN pTS TX TY TZ T[ T\ 7T] iT^ T_ T` Ta Tb %Tc &Td >Te rTf Tg Th Ti ߱Tj Tk Tl 7Tm 8Tn FTo Tp Tq Tr Ts Tt KTu LTv [Tw Tx Ty Tz T{ ?T| xT} yT~ T дT T T XT ZT dT uT T صT T =T T T T ѶT T T LT |T T T $T `T T T T ͸T T QT T T T T =T T ߺT 0T T һT #T tT żT T gT T T ZT T T MT T T @T T T 3T T T &T wT T T jT T T /T iT T T *T qT T T T QT T! T" T# #T$ [T% ]T& kT' T( T) .T* 0T+ =T, UT- WT. eT/ ~T0 T1 T2 T3 T4 VTH zTI TJ TK TL TM RTN TO TP ETQ TR TS 8TT TU TV +TW |TX TY TZ oT[ T\ T] bT^ T_ T` UTa Tb Tc Td ?Tp bTq Tr Ts Tt Tu /Tv zTw Tx Ty Tz 0T{ `T| T} T~ T T YT T T T T DT ^T T T T \T T T T T vT T T T CT jT T T 1T mT T T T XT vT T T T #T `T xT T T HT iT T T T 2T ~T T TT&TZTTTT<TTT,T|TTTlTT T \T!T"T#LT$T%T&<T'T(T),T*|T+T,T-lT.T/ T0\T1T2T3LT4T5T6<T7T8T9,T:|T;T<T=lT>T? T@\TATBTCLTDTETFTGTHTI@TJTKTL-TM|TN~TOTtTu\TvwTwTxTyTz<T{T|T}T~TT.TlTTT T T"T5TTTTT1TETT'TTTT T"TTTTTTTTTTTTTTzTT9TTT"TGTTTTTTTTITTTTTTTdTfTrTTTTTCSbTTTTTNTTT TTTTT>TBTETGTITKTMT~TTTTTT TETPT~TTTT S*SLSnSSSSSS:S\ThTqTTTTTTTTTT!T<TSS6uT7T;T<:T@]TATB TCw TD TE TrTsTtMTuTvTwTxTyTz,T{7T|uT}T~ThTT4TT<TT@$T-T?7T7T8Tz8T;T>T+BT2HT9NT?TTtTTTTTTYT^TcTcT)dTldSzdTdTdTdTeTCfT`fT}fTfTfTfTfTfTfTfTfTfTfTfTfTfTfTfTfTfTfTfTfTgS.gT7gTRgSsgSgSgShS,hSXhShShShSiS4iT_iSiSiSiTjS jSJjStjSjSjSjSkSHkStkSkSkSkTlTlT"lT2lSBlShlSlSlSlSmS&mSLmSrmSmTmSmS nS/nSUnS{nSnSnSnTnSoS?oSeoSoSoSoSoS#pT0pT:pTMpT^pTepTlpTppTpTqTnqTrTsTduTuSuSvS DvS uvS vS vS wS9wSjwSwSwSwS.xS_xSxSxSxS#ySTySyS*yS4yT5zT6NzT7zT>zT?zT@{T\#{T]c{S^{S`{Sa{Sb{Sc|S5|TX|Sv|S|S|T|S}TM}T}T}T:~TR~Ti~T~T~T!TPTTTTTTTT(TPTyTTTTTTT6TqTTpTzTTdTTT SMTZTTTTT T T TTCSqSTTRTLJS S!#S"QS#S(T)T*͈T+وT,T-T.T/ TNSOSSPSQTRÉTS߉TTTZT[8T\US]sS^S_S`͊SaSb Sc'SnEToWSpTqSrSsߋSt SuMSvSxTySzŒT{T|bT}T~ƎTNT֏T^T-TT˕TTQSiSSSٗSST<TTTTTT˜TƘTʘTΘTԘT֘TؘT T;THTSTqTtTxTzT|STSTS&SdSSTT`T S!ڛS"S#HS$S%S&S'$S([S)S*ɝS+S,7S-nS.S/ܞS0S1JS2S3S4S5&S{]T|T}S~SSRSSSTSBTrSSԢSS6SgSSɣSS+S\SSSS SQSSSSSFSwSSݦSS?SpSSҧSS4SeSSǨSS)SZSSSSSOSSSSSDSuSS׫SS9SjSS̬SS.S_SSSS#STSSSSSISzSSܯS S>SoSSѰSS3SdSSƱSS(SYSSSSSNSSSSSCStTSѴTS,SaSS˵SS5SjSSԶS S>SsSSݷSSGS|SSSSPSSSS$SYSSúSS -S bS S ̻S S6SkSSټSS?TMShSTTTTϽTT-T.T/T0-T15T2=T3OT4TT5ZT6`T7iT8wT9T:T;žT<T=T>'TIBTNhTOSPTQSRSSNSTSUSVSWSXCSYtSZS[S\S]8S^iS_SbScSdSe4SfWSgzShSiSjSkSl)SmLSnoSoSpTqSrSv TwTT-T?TMTYTcTqTTTTTTTTTT%T9TLT`TrTTTTTTTTT#T8TYSSSSSNSSSSSCStTSSS7ShSSSS,S]SSSS!SRSSSSSGSxSSS S<SmSSSS1SbSSSS&SWSSSSSLS}SSSSASrSSSS6SgSSSS+S\SSSS SQSSSS S FS wSSS S;SlSSSS0SaSSSS%SVSSS S!S"KS#|S$S%S*S+@S,qS-S.S/T02S1cS2S3S4S5'S6XS7S8S9S:S;MS<~S=S>S?S@BSAsSBSCSDSE7SFhSGSHSITJSKJSL{SMSNSOSP?SQpSRTSTTSUSV&SWWSXSYSZS\S]LS^}SpTqSrSs&StWSuSvSwSxSyLSz}S{S|S}S~KSSSS$S[TT=TT ThTSS4SeSSSS)SZSSSSSOTkSSSS/S`SSSS$SUSSSSSJS{S<S=S>S??S@pSASBSCSD4SEeSFSGSHSI)SJZSKSLSTTTTTTTTSZSSS TSOSSSS;SvSSS'SbSSSSKTUTvTTTTTTTTTTT T T T T TT#T.T;T@TFTLTVTdTpTyTTTTTTTT T!T"T#T$T2T3T4 T5T6T7T8$T91T;<T<CTeJTfPTWT^T&fT'S(S)S*S+-T,WS-S.T/S0S1S2 S3$S4?S5ZS6uS7S8S9S:S;S<S=1S>LS?gS@SASBSCTDTE!TFHTGoTHTITJTK TL2TMYTNTOTPTQTRTSTTTUTVTWTXTY"TZ,T[1T\9T]CT^KT_QS`SaSbScSdFSexTfTgThTiTjTkSlSTS4SiSSSS=SrSSSSFS{TT TPStSSS SH S} S S S SA Sr S T T T T S S@ Sq S T S S4 Se S S S S) SZ S S S SSOSS S S S DS uSSSS9SjSSSS.S_SSSS#S TS!S"S#S$S%IS&zT'T(T)T5T6T7T8T9T:T;T<T=TD TE-SF^SGSHSISJ"SKSSLSMSNSOSP5SQfSWTXTYSZS[*S\VS]S^S_S`Sa2Sb^ScSdSeSfSg:ThgTiTjTkTlTmHSn}SoTpSqSr,SsXStSuTvTwTxTyTzT{'T?TjSsTTTTGT|TTTTPTTTT$TYTTTT- Tb T T T!T6!Tk!T!T!T "T?"Tt"T"S"S#S-#SY#Sj#S#S#T#T$SC$St$S$S$S%S8%Si%S%T%S%S&SC&St&S&S&S'S8'Si'S'S'S'T(SA(Sr(S(T(S(S()SY)S)S)S)S*SN*S*S*S*S+T+T,+S]+S+S+S+S!,SR,S,S,S,S-SI-Sz-T-T-S.SB.Ss.S.S.S/S7/S h/S /S /S /T %0SV0S0S0S0S1SK1S|1T1T1T2TM2T2S2S2S3SH3Sy3S3S 3T!4S"34S#d4S$4S%4S&4S'(5S(Y5S)5S*5S+5S,6S-N6S.6S/6S06S17S2C7S3t7S47S57S68S788S8i8S98S:8SS8TT$9SUU9SV9SW9SX9SY:SZJ:S[{:S\:S]:S^;S_?;S`p;Sa;Tb;Sc<Sd3<Sed<Sf<Sg<Sh<Si(=SjY=Sk=Sl=Sm=Sn>SoN>Sp>Sq>Sr>Ss?StC?Sut?Sv?Sw?Sx@Sy8@Si@T@S@T@T@T@T@TATAT;ATBATXATjAT{ATATATATATASAS8!BS@BTOBTaBT|BTBTBTBTBTBT CT7CTaCTCTCTCT DT3DT]DTDTDTDTET/ETYETETETETFT+FTUFTFTFTFTFTFTFTGTBGTGT8HTgHTHTHTHTBITISITITISISITIT1JS@JSUJSJTJTJT)KT@KTKT KT! LT(HLT)LT*LT2'MT3tMT4MT5NT6ONT7NT8NT9OOT:OT;OT<;PT=PT>PT?/QT@MQTAOQTBcQTCQTFQTKQTPRTQbRTURTZRT_ STdSTiDSTjSTnSToTTs[TTxTTyTT}UTLUTUTUTVTFVTVTVT WTPWTWTWT&XTXTXT@XTE;YTFYTJZTTNZT^ZT`ZTc[TeF[Tf[Th[Ti\Tj@\To~\Tr\T\T8]Tv]T]T]T0^Tn^T^T^T&_Td_T_T_T`T\`T`T`TaTTaTaTaT bT LbT bT bT& cT' DcT( cT* cT, cT. !nTH!LnTM!nTR!nT\!oT]!DoT^!oT_!oT`!oTf!=pTj!{pTl!pTp!pTr!5qTs!sqTt!qTu!qTv!-rTw!krTx!rTy!rTz!%sT{!csT|!sT}!sT~!tT![tT!tT!tT!uT!SuT!uT!uT! vT!'vT!evT!vT!vT!wT!]wT!wT!wT!xT!VxT!xT!xT!yT!NyT!yT!yT!azT!zT!zT!{T!Y{T!{T!{T!|T!Q|T!|T!|T! }T!I}T!}T!}T!~T!A~T!~T!~T!~T!9T!wT!T!T!1T!oT!T!T!)T!gT!T!T!!T!_T!T!ۂT!T"WT"T"ӃT"T$"OT."T8"˄T:" TB"GTG"TH"ÅTI"TJ"?TK"}TL"TQ"TW"7T\"uT^"T`"Ta"/Tb"mTc"Td"Te"'Tf"eTg"Th"Ti"Tj"]Tt"Tu"يTv"T~"UT"T"ыT"T"MT"T"ɌT"T"ET"T"T"T"=T"{T"T"T"5T"sT"T"T"-T"kT"T"T"%T"cT"T"ߑT#T #[T#T#גT#T(#ST*#T2#ϓT<# TF#KTG#TI#ǔTK#TL#CTM#TN#TO#TP#;TQ#yTR#TZ#Td#3Ti#qTj#Tn#Ts#+Tt#iTx#T}#T##T#aT#T#ݙT#T#YT#T#՚T#T#QT#T#T#T#'T#eT#T#T#T#]T#T#ٝT#T#UT#T#ўT#T#MT#T#ɟT#T#ET#T#T#T#=T#{T#T#T#5T#sT#T#T#.T#lT#T#T#&T#dT#T#T#T#T# T#/T#YT#lT#T#T#T#T#ץT#T#T# T# T#T#T#T#T#T#T#T#"T#%T#'T#*T#FS#sS#S#S#ҦS#ST$TU$SV$<SW$fSX$SY$SZ$S[$S\$8S]$bS^$S_$S`$Sa$ Sb$4Sc$^Sd$Se$Sf$Sh$Ti$3Sj$]Sk$Sl$Sm$۪Sn$ So$?Sp$qSq$Sr$ͫSs$St$!Su$KSv$}S$T$T$)T$gT$T$T$!T$_T$T$ۮT$T$WT$T$ӯT$T$OT$T$ΰT$ݰT$T$ T$9T$[T${T$T%T%3V%T%T %յT'%V(%T)%$T*%+T+%4T,%CT-%RT.%^T/%cT0%mT1%~T2%T3%T4%ĶT5%V6%T7%V8%V9%qT:%{T;%T<%T=%+T>%@T?%IT@%STA%xVB%TC%TD%VE%ҹTF%VI%6TJ%T&XT&T&ԻT&T&,T&XT&T&T&ܼT&T&4T&`T&T&T&T&T&<T&hT&T&T&T&T&DT&pT&T&ȿT&T& T&LT&xT&T&T&T&(T&TT&T&T&T&T&1T&]T&T&T&T& T&9T&eT&T&T&T&T&AT&mT&T&T&T&T&IT&uT'T'T'T'[T'T'V'T'T'T'T'V'2V'T'T'lT'tT'BT'T'T']T'S'S'S (_T (T (S (S(&S(KS(pS(S(S(T(S(6S(XS(zT(T(T(T(T(T(T(T(($T)(AT*(^S+(vT,(T-(T.(S=(S>(S?($S@(USA(SB(SC(SD(SE(JSF({SG(SH(SI(SJ(?SK(pSL(SM(SN(SO(4SP(eSQ(SR(SS(ST((SU(YSV(SW(SX(SY(SZ(NS[(S\(S](S^(S_(CS`(tSa(Sb(Sc(Td(Se(MSf(Sg(Sh(Si(Sj(HSk(ySl(Sm(Sn( So(=Sp(nSq(St(Tu(Tv(Tx(Ty( Tz(-S{(bS|(S}(S~(S(6S(kS(S(S(S(3S(dS(S(S(S((S(YT(cT(hS(T(T(T(T(T(-T(?T(XT(hT({T(T(T(T(T(T(T(T(T(T(T(+T(5T7)NS8)S9)S:)S;)S<)CS=)tS>)S?)S@)SA)8SB)iSC)SD)SE)SF)-SG)^SH)SI)SJ)SK)"SL)SSM)SN)SO)SP)SQ)GSR)xSS)ST)SV) SW)<SX)mSY)SZ)S[)S\)1S])bS^)S_)S`)Sa)&Sb)VSc)Td)Te)Th)Ti)Tj)T)"T)5S)jS)S)S) S)>S)sS)S)S)S)1S)fS)T)S)S)S)PS)S)S)S)S)QS)S)S)S)!S)RS)T)T*T*T*T*T*T*T*T*T* T *T *,T *CT *[T *eT*rT*T*T0*T1*S2*S3*S4*S5**S6*ES7*`S8*{S9*S:*S;*S<*S=*S>*S?*7S@*RSA*mSB*SC*SD*SE*SF*TG*TH*BTI*iTJ*TK*TL*TM*TN*,TO*STP*zTQ*TR*TS*TT*TU*TV*TW*TX*TY*&TZ*/T[*8T\*CT]*MT^*RT_*ZT`*dTa*lTb*rSc*Sd*Se*Sf*Sg*Sh*Si*9Tj*PTk*cTl*Tm*Sn*Sp*Sq*Tr*'Ts*-Tt*4Tv*=T*WT*~S*S*S*S*RS*S+S+T+T+ T+T+T*+S++PS,+S-+S.+S/+S|.ES}.lS~.S.S.S.S..S.:S.aS.S.S.S.S.S.@S.gS.S.S.S.S.S.S.!S.'T.3S.ZS.S.S.TD/TE/SF/SG/%SH/DSI/cSJ/SK/SL/SM/SN/SO/SP/<SQ/jSR/SS/ST/Sv/Tw/Tx/T/T/#T/1T/HT/WT/\T/nT/sT/|T/T/T/T/T/T/T/T/T/T/T/T/T/T/ T/$T/;T/LT/cT/T/T/T/T/T/T/T/T/*T/AT/OT 0mT 0T0T0 T0"T07T0uT0T0T 0T!0HT*0{T+0T40T50> T60f T70 T80 T90 T:0 T>0 T?0J T@0 Tp0 Tq0 Tr0 Ts0 Tt05 Tu0A Tv0L Tw0W Tx0j Ty0u Tz0 T{0 T|0 T}0 T~0 T0 S0 S0* S0J T0 T0 T0 S0" S0F S0h S0 S0 T0 T0 T0T0DS0fS0S0S0T0-T0T0T0;T1T1T1WT1sT1T1T1T1_T1S 1S 1zS 1S 18S 1S1S1US1S1T1NT1T1+T1T1T1T1T1MT1T1QT1T1T16T1T1T1T19 T2 T2!T2!T2]!T2!T2!T2*"T2v"T2"T 2"T 2B#T 2#T 2#T 2$T2O$T2$T2$T2:%T2|%T2%T2%T2&T2>&T2&T2&Td2D'Te2'Tf2'Tg2'Vh2'Ti2f(Tj2o(Tk2(V>(V>?)Vt@)Vu@^*Vv@+VP+TQ+VR%,VS,VT8-TU-TV.TWH.TX.VY /VZ/T[/T\@0T]s0V^1V_a1V`1Va_2Vb 3Tc3Td+4Ve4Vf)5T5V56V6V<7V7V8V8V9TT9V9T9V0:V^:V:V :V!P;V";V#1<V${<V|<T}&=T~=V=V^>V>T>T??V?V@VS@V@T@TAViAVATBVPBTyBTBV:CVCTCTDTDTDTDETExEVFEVGEVH3FVIFTJFVK3GTLOGVuGVHTGHVHVIVQJVJVKV+LVLTtMV)NVNVOVVPVQVQVERVRVSTSVTV:UVpUVUTVVkWV XVXVYV(ZVZVZ[T[T+\V\T\V^]T]T]Vf^T^Vz_T `T`T`TLaT aTDB20000I The %1S command completed successfully.END-OF-STATEMENTINSERTSELECT or Yes No None "%1S" RETURN_STATUS: %2SDB20000I The %1S command completed successfully.DB21001E The option "%1S" specified after the 'db2' command or in the DB2OPTIONS variable is incorrect.DB21002E The parameter for option "%1S" specified after the 'db2' command or in the DB2OPTIONS variable is missing or incorrect.DB21003E The value "%1S" in "%2S" is not valid.DB21004E You cannot specify both an input file and a command when invoking the Command Line Processor.DB21005E An error occurred while accessing the file "%1S".DB21006E The input command is too long. The maximum length is %1S.DB21007E End of file reached while reading the command.DB21008E Commands can only be entered from the command line processor interactive mode or file input mode.DB21009E This command must be launched from a command window running with full administrative privileges.DB21010I Help given for "%1S".DB21011I In a partitioned database server environment, only the table spaces on the current node are listed.DB21015E The Command Line Processor backend process request queue or input queue was not created within the timeout period.DB21016E The Command Line Processor encountered a system error while sending the command to the backend process.DB21017E The Command Line Processor encountered a system error with the front-end process output queue. Reason code = %1S.DB21018E A system error occurred. The command line processor could not continue processing.DB21019E An error occurred while accessing the directory "%1S".DB21020E Unable to create the default message file "%1S".DB21021E No Admin Server instance is defined. The command failed.DB21022E Unable to switch to Administration Server instance "%1S".DB21023E The command is not valid when executed from Administration Server.DB21024I This command is asynchronous and may not be effective immediately.DB21025I One or more of the parameters submitted for immediate modification were not changed dynamically. Client changes will not be effective until the next time the application is started or the TERMINATE command has been issued. Server changes will not be effective until the next DB2START command.DB21026I One or more of the parameters submitted for immediate modification were not changed dynamically. For these configuration parameters, all applications must disconnect from this database before the changes become effective.DB21027E Isolation level may not be changed while connected to a database.DB21028E The cursor "%1S" has not been declared.DB21029E The cursor "%1S" has already been declared and opened.DB21030E The cursor "%1S" has not been opened.DB21031E The SQL statement using the cursor "%1S" ("%2S") returned:DB21032E You have already declared the maximum number of cursors.DB21033E The command is not valid for this database server.DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned:DB21035E The maximum number of items in the "%1S" list has been exceeded. The maximum number is "%2S".DB21036E The %1S command failed.DB21037W No data sources found.DB21040E Transaction number "%1S" is not a valid indoubt transaction number.DB21041W The following amount of indoubt transactions was not displayed: number "%1S"DB21042E Subcommand failed because it did not specify a transaction number.DB21043E "%1S" is not a valid request.DB21044E Cannot COMMIT transaction number %1S.DB21045E Cannot ROLLBACK transaction number %1S.DB21046E Cannot FORGET transaction number %1S.DB21050E "%1S" is not a valid SQLSTATE.DB21051E The command is not supported for this environment.DB21052I "%1S" has been submitted for execution.DB21053W Automatic escalation will occur when you connect to a database that does not support %1S.DB21054E The command line processor encountered a system error with the "%1S" command. Reason code = "%2S".DB21055W Command not valid for type 2 connections.DB21056W Directory changes may not be effective until the directory cache is refreshed.DB21057E Invalid tape device specified.DB21058E Invalid tape position specified.DB21059E Invalid tape blocksize specified.DB21060E General tape failure.DB21061E Command line environment not initialized.DB21070W One or more of the configuration parameters were set to AUTOMATIC in a case where the parameter does not support AUTOMATIC.DB21071W Configuration parameter values were changed on all nodes, however not all nodes were able to change the values dynamically.DB21080E No previous RESTORE DATABASE command with REDIRECT option was issued for this database alias, or the information about that command is lost.DB21081E No sections were found in the db2cli.ini file.DB21082E You don't have enough authority to run the UPDATE CLI CONFIGURATION command.DB21083E Section %1S not found.DB21084E NEW and CONFIRM passwords not the same.DB21085I This instance or install (instance name, where applicable: "%1S") uses "%2S" bits and DB2 code release "%3S" with level identifier "%4S".DB21086I The incremental RESTORE operation of this backup image completed successfully, but there are additional backup images that must be restored to complete the entire incremental RESTORE operation.Informational tokens are "%1S", "%2S", "%3S", and Fix Pack "%4S".Product is installed at "%1S".DB21089I DB2 Administration Server "%1S" uses DB2 code release "%2S" with level identifier "%3S". Informational tokens are "%4S", "%5S", and Fix Pack "%6S". Product is installed at "%7S". Product is installed at "%1S" with DB2 Copy Name "%2S".DB21100E Stored procedure "%1S" exists in multiple schemas.DB21101E Too few parameters were specified for stored procedure "%1S" (expected %2S).DB21102E Too many parameters were specified for stored procedure "%1S" (expected %2S).DB21103E The data type of parameter %1S is not supported by the CALL command in CLP.DB21104E Parameter %1S for stored procedure "%2S" should be an INPUT parameter.DB21105E Parameter %1S for stored procedure "%2S" should be an OUTPUT parameter.DB21106E Stored procedure "%1S" is undefined.DB21107E An error has occurred when accessing the file "%1S". Reason code: "%2S".DB21108E The request cannot be executed because the database server version does not support this functionality.DB21109E The syntax is incorrect for the "%1S" directive. Reason Code: "%2S".The variable "%1S" has been explicitly set and will not be affected by the configuration of the aggregate variable "%2S".DB21500I The DB2MSCS command completed successfully.DB21501E The db2mscs command failed because the following invalid option was specified: "%1S"DB21502E Cannot open the configuration file "%1S".DB21503E Not enough memory is available to process this command.DB21504E The value "%1S" specified for parameter "%2S" exceeded the maximum length for that parameter. The maximum length of the parameter is "%3S" bytes.DB21505E Parameter "%1S" must be specified before parameter "%2S" in the DB2MSCS configuration file "%3S".DB21506E The cluster "%1S" cannot be accessed. Ensure that the cluster name is correct and the cluster service on the current current machine has been started.DB21507E The instance name "%1S" is not valid.DB21509E The keyword "%1S" specified in configuration file "%2S" is only valid for the partitioned database instance.DB21510E Internet address "%1S" specified in configuration file "%2S" is not valid.DB21511E Node "%1S" does not exist.DB21512E The keyword "%1S" is not a valid DB2MSCS keyword.DB21513E The DB2MSCS utility failed to create MSCS group "%1S" because of system error: "%2S"DB21514E The DB2MSCS utility failed to complete because of system error: "%1S"DB21515E The required resource property specified by keyword "%1S" is missing for the resource "%2S".DB21516E DB2MSCS cannot bring resource "%1S" online. Ensure that the properties of the resource are set correctly.DB21517E MSCS Network "%1S" is not active.DB21518E There is no active MSCS network.DB21519E DB2MSCS cannot bring the resource "%1S" offline. Ensure that the properties of the resource are set correctly.DB21520E The DB2PATH profile variable is not defined.DB21521E DB2MSCS cannot read from file "%1S".DB21522E Cannot open machine registry for machine "%1S". Ensure that the machine is active and that the current logon account has Local Administrator authority.DB21523E Cannot close machine registry for machine "%1S". Ensure that the machine is active and that the current logon account has Local Administrator authority.DB21524E Failed to create the resource "%1S". System error: "%2S"DB21525E Failed to add dependency to the resource "%1S". System error: "%2S"DB21526E Failed to move resource "%1S". System error: "%2S"DB21527E No disk resource is specified for the group "%1S".DB21528E The value "%1S" specified for the INSTPROF_DISK keyword does not match any disk in the same group.DB21529E The DB2MSCS utility cannot access the registry of machine "%1S". Ensure that the machine is active and that the current logon account has Local Administrator authority.DB21530E The DB2MSCS utility cannot access the cluster registry for the cluster "%1S". Ensure that the cluster is active and the current logon account has Local Administrator authority.DB21531E Cannot obtain property for MSCS disk. System error: "%1S"DB21532E A internal error occurred. File: "%1S", Line "%2S". Please contact your IBM Service Representative.DB21533E An error occurred during the migration of the database manager instance, rc = "%1S".DB21534E An error occurred during addition of MSCS node to the database manager instance, rc = "%1S".DB21535E The instance-owning database partition server is not on the current machine.DB21536E The username "%1S" is not valid.DB21537E The password "%1S" is not valid.DB21538E The password for the account "%1S" has expired.DB21540E Group "%1S" requires at least one network name resource.DB21541E An error occurred when removing the MSCS node from the database manager instance, rc = "%1S".DB21542E An error occurred while attempting to remove failover support for the instance. Failover support is still active for this instance, rc = "%1S".DB21543E The resource name "%1S" does not match any IP resource in the same group.DB21544E The MSCS resource "%1S" already exists.DB21545E The module "%1S" was loaded, but the function "%2S" is not found. Ensure that you are running on the version of the database product that supports MSCS.DB21546E The module "%1S" could not be loaded.DB21547E Error occurred while moving group "%1S" to node "%2S". System error: "%3S"DB21548E A logon account for the DB2 service must be specified for a partitioned database system. Specify a valid logon account using the DB2_LOGON_USERNAME and DB2_LOGON_PASSWORD keywords.DB21549N Network name "%1S" specified for node "%2S" is not valid."Creating resource "%1S" of type "%2S""Creating resource group "%1S""Creating resource type "DB2 Server""Creating instance profile directory "%1S""Adding cluster node "%1S" to instance "%2S""Adding dependency to resource "%1S" on resource "%2S""Moving resource "%1S" to group "%2S""Moving group "%1S" to node "%2S""Deleting resource "%1S""Deleting group "%1S""Deleting resource type "DB2 Server""Removing cluster node "%1S" from instance "%2S""Bringing resource "%1S" online"Taking resource "%1S" offline"Clustering DB2 instance "%1S""Clustering DAS instance "%1S""Unclustering DB2 instance "%1S""Unclustering DAS instance "%1S"DB21600N The "%1S" command did not complete successfully.Allows applications to create, update, control, and manage relational databases.Allows applications to create, update, control, and manage a single database partition in a partitioned database system.Supports remote DB2 command execution.Supports local and remote database administrative requests.Indexes and searches text documents in DB2 databases.Monitors the DB2 server and databases for availability.DB22000E Error: The syntax of the DB2LSWTCH command is incorrect.DB22001E An error occurred during the initialization of the local switcher environment. No change was done to any copy on the system.DB22002E An error occurred during the promotion of the copy "%1S". The promotion will continue and this copy will be assigned as the default on the system.DB22003E An error occurred during the demotion of the DB2 copy "%1S". The demotion will be aborted and this copy will remain as the default on the system.DB22004I The copy "%1S" has been successfully demoted and is no longer the default DB2 copy on the system.DB22005I The copy "%1S" has been successfully promoted to be the default DB2 copy on the system.DB22006E An error occurred during the process of updating the global system environment variables to include the environment variables for the copy "%1S".DB22007E An error occurred during the process of updating the global system environment variables to remove the environment variables for the copy "%1S".DB22008E An error occurred when registering the IBM ODBC driver for the copy "%1S" as the default driver on the system.DB22009E An error occurred when unregistering the IBM ODBC driver for the copy "%1S" as the default driver on the system.DB22010E An error occurred when registering the IBM .NET data provider for the copy "%1S" in the global assembly cache.DB22011E An error occurred when unregistering the IBM .NET data provider for the copy "%1S" in the global assembly cache.DB22012E An error occurred when registering the IBM OLEDB provider for the copy "%1S" as the default provider on the system.DB22013E An error occurred when unregistering the IBM OLEDB provider of the copy "%1S" as the default provider on the system.DB22014E An error occurred during the update of the ODBC system DSN "%1S".DB22015E An error occurred during the operating system call "%1S". The operating system message is "%2S" and the return code is "%3S".DB22018E An error occurred while trying to start the DB2 Management Service of the copy "%1S".DB22019E An error occurred while trying to stop the DB2 Management Service of the copy "%1S".DB22020E The copy "%1S" is not the default DB2 copy and therefore cannot be demoted.DB22021E Another copy "%1S" is defined as the default DB2 copy on the system. Promotion of another copy cannot proceed unless the current default copy is demoted.DB22022E An error occurred while setting the "default" value under the HKLM\Sofware\IBM\InstalledCopied registry key to the name of the copy "%1S".DB22023E An error occurred while updating the "default" value under the HKLM\Sofware\IBM\InstalledCopied registry key to remove the name of the copy "%1S".DB22024E An error occurred while registering the COM server "%1S".DB22025E An error occurred while unregistering the COM server "%1S".DB22026E Error: The syntax of the db2swtch command is incorrect.DB22027E An error occurred when registering the performance counters for the copy "%1S".DB22028E An error occurred when unregistering the performance counters for the copy "%1S".DB22029E An error occurred when registering the DB2 system tray for the default instance of the copy "%1S".DB22030E An error occurred when unregistering the DB2 system tray for the copy "%1S".DB22031E An error occurred when modifying the display name of the shortcut group for the copy "%1S".DB22032I The copy "%1S" has been successfully demoted and is no longer the default IBM database client interface copy on the system.DB22033I The copy "%1S" has been successfully demoted and is no longer the default DB2 copy and IBM database client interface copy on the system.DB22034I The copy "%1S" has been successfully promoted to be the default IBM database client interface copy on the system.DB22035I The copy "%1S" has been successfully promoted to be the default DB2 copy and IBM database client interface copy on the system.DB22036E The copy "%1S" is not the default IBM database client interface copy and therefore cannot be demoted.DB22037E The copy "%1S" is not default DB2 copy and IBM database client interface copy and therefore cannot be demoted.DB22038E Another copy "%1S" is defined as default IBM database client interface copy on the system. Promotion of another copy cannot proceed unless the current default database client interface copy is demoted.DB22039E An error occurred while setting the "defaultClientInterfaceCopy" value under the HKLM\Sofware\IBM\InstalledCopied registry key to the name of the copy "%1S".DB22040E An error occurred while updating the "defaultClientInterfaceCopy" value under the HKLM\Sofware\IBM\InstalledCopied registry key to remove the name of the copy "%1S".DB22041E The DB2 copy "%1S" does not exist.DB22042E An error occurred when setting up the database manager instance configuration for the IBM Tivoli Monitoring for Databases: DB2 Agent in the copy "%1S".DB22043E An error occurred when removing the database manager instance configuration for the IBM Tivoli Monitoring for Databases: DB2 Agent in the copy "%1S".DB22044E An error occurred when creating the configuration file for the IBM Tivoli Monitoring for Databases: DB2 Agent in the default copy installation directory.DB22045E An error occurred when removing the configuration file for the IBM Tivoli Monitoring for Databases: DB2 Agent in the default copy installation directory.db2 [option ...] [db2-command | sql-statement | [? [phrase | message | sqlstate | class-code]]]option: -a, -c, -d, -e{c|s}, -finfile, -i, -lhistfile, -m, -n, -o, -p, -q, -rreport, -s, -t, -td;, -v, -w, -x, -y, -zoutputfile. Option Description Default Setting ------ ---------------------------------------- --------------- -a Display SQLCA OFF -c Auto-commit ON -d Retrieve and display XML declarations OFF -e Display SQLCODE/SQLSTATE OFF -f Read from input file OFF -i Display XML data with indentation OFF -l Log commands in history file OFF -m Display the number of rows affected OFF -n Remove new line character OFF -o Display output ON -p Display db2 interactive prompt ON -q Preserve whitespaces and linefeeds OFF -r Save output report to file OFF -s Stop execution on command error OFF -t Set statement termination character OFF -v Echo current command OFF -w Display FETCH/SELECT warning messages ON -x Suppress printing of column headings OFF -y Get SQL message text from server OFF -z Save all output to output file OFFNotes: Use the DB2OPTIONS environment variable to customize option defaults. A minus sign (-) immediately following an option letter turns the option off. An option takes on the opposite value if the minus sign (-) is changed to a plus (+). Use UPDATE COMMAND OPTIONS to change option settings in interactive or file input mode.Instructions for reading help screens: [ ] Encloses optional parameters { } Encloses mandatory parameters | Separates two or more items, only one of which may be chosen ... Indicates a repeatable parameter. KEY and RESERVED words are in uppercase - they are mandatory.For example, CONNECT TO database-alias [IN {SHARE | EXCLUSIVE} MODE] [USER username [USING password]]indicates that the following are valid statements: CONNECT TO sample CONNECT TO sample IN SHARE MODE CONNECT TO sample in EXCLUSIVE MODE CONNECT TO sample IN SHARE MODE USER smith USING pwwhile the following are invalid: CONNECT TO sample IN MODE (SHARE or EXCLUSIVE is required) CONNECT TO sample IN SHARE EXCLUSIVE MODE (cannot use SHARE and EXCLUSIVE) CONNECT TO sample USING pw (cannot use password without username)On some platforms, HELP is also available as a command to accessthe on-line Command Reference and the SQL Reference.The syntax of the HELP command is: HELP [character-string]NOTE: From the operating system prompt, prefix commands with 'db2'. Special characters MAY require an escape sequence (\), for example: db2 \? change database db2 ? change database xxx comment with \"text\"AUTOCONFIGURE autoconfigure-clause | REPORT EXISTING SUMMARY autoconfigure-clause: [USING config-keyword value [{config-keyword value}...]] APPLY {DB ONLY | DB ONLY ON CURRENT MEMBER | DB AND DBM | DB AND DBM ON CURRENT MEMBER | NONE} [report-clause] config-keyword: MEM_PERCENT, WORKLOAD_TYPE, NUM_STMTS, TPM, ADMIN_PRIORITY, IS_POPULATED NUM_LOCAL_APPS, NUM_REMOTE_APPS, ISOLATION, BP_RESIZEABLE. report-clause: REPORT FOR [MEMBER -1 | MEMBER -2 | MEMBER member-number1 | MEMBERS ({, member-number2}...)] [INCLUDE SUMMARY | EXCLUDE SUMMARY]ARCHIVE LOG FOR DATABASE database-alias [USER username [USING password]][On-DbPartitionNum-Clause] On-DbPartitionNum-Clause: ON {{DBPARTITIONNUM | DBPARTITIONNUMS} (db-partition-number [TO db-partition-number] , ... ) | ALL DBPARTITIONNUMS [EXCEPT {DBPARTITIONNUM | DBPARTITIONNUMS} (db-partition-number [TO db-partition-number] , ...)]}ADD DBPARTITIONNUM [LIKE DBPARTITIONNUM db-partition-number | WITHOUT TABLESPACES]ATTACH [TO node-name] [[USER username [{USING password [NEW new-password CONFIRM confirm-password] |CHANGE PASSWORD}]] | [ACCESSTOKEN accesstoken [ACCESSTOKENTYPE accesstokentype]] |[APIKEY apikey]]BIND {filename | @filelist} [ACTION {ADD | REPLACE [RETAIN {YES | NO}][REPLVER version-id]}] [APREUSE {YES | NO}] [BLOCKING {UNAMBIG | ALL | NO}][CLIPKG number-of-packages] [COLLECTION collection-id][CONCURRENTACCESSRESOLUTION {USE_CURRENTLY_COMMITTED | USE CURRENTLY COMMITTED USECURRENTLYCOMMITTED | WAIT_FOR_OUTCOME | WAIT FOR OUTCOME | WAITFOROUTCOME}][DATETIME {DEF | USA | EUR | ISO | JIS | LOC}] [DEGREE {1 | degree-of-parallelism | ANY}] [DYNAMICRULES {RUN | BIND | INVOKERUN | INVOKEBIND | DEFINERUN | DEFINEBIND}][EXPLAIN {NO | YES | REOPT | ALL | ONLY} [EXPLSNAP {NO | YES | REOPT | ALL}][EXTENDEDINDICATOR {NO | YES}][FEDERATED {NO | YES}] [FUNCPATH schema-name [ {,schema-name} ... ]][FEDERATED_ASYNCHRONY {ANY | number_of_atqs_in_the_plan}] [GENERIC string][GRANT {authid | PUBLIC}] [GRANT_GROUP group-name] [GRANT_USER user-name][GRANT_ROLE role-name] [INSERT {BUF | DEF}] [ISOLATION {CS | RR | UR | RS | NC}][MESSAGES message-file] [OPTPROFILE optimization-profile-name][OWNER authorization-id] [QUALIFIER qualifier-name][QUERYOPT optimization-level] [REOPT {NONE | ONCE | ALWAYS}][SQLERROR {NOPACKAGE | CHECK | CONTINUE}] [VALIDATE {RUN | BIND}][SQLWARN {NO | YES}] [STATICREADONLY {NO | YES | INSENSITIVE}][STRING_UNITS {SYSTEM | CODEUNITS32}] [TRANSFORM GROUP transform-group]******************************************************************************** The following options are valid only if connected to a host or iSeries Server*******************************************************************************[CCSIDG double-ccsid] [CCSIDM mixed-ccsid] [CCSIDS sbcs-ccsid][CHARSUB {DEFAULT | BIT | SBCS | MIXED}] [CNULREQD {YES | NO}][DBPROTOCOL {DRDA | PRIVATE}] [DEC {31 | 15}] [DECDEL {PERIOD | COMMA}][ENCODING {ASCII | EBCDIC | UNICODE | ccsid}][IMMEDWRITE {NO | YES | PH1}] [KEEPDYNAMIC {NO | YES}][OPTHINT hint-id] [OS400NAMING {SQL | SYSTEM}] [PATH schema-name][RELEASE {COMMIT | DEALLOCATE}][SORTSEQ {HEX | JOBRUN}] [STRDEL {APOSTROPHE | QUOTE}] [TEXT label]CALL procedure-name ( [argument [{, argument} ...]] )CATALOG APPC NODE node-name REMOTE symbolic-destination-name[SECURITY {NONE | SAME | PROGRAM}] [REMOTE_INSTANCE instance-name][SYSTEM system-name] [OSTYPE os-type] [WITH "comment string"]CATALOG [ADMIN] {TCPIP | TCPIP4 | TCPIP6} NODE node-name REMOTE hostname [SERVER service-name] [SECURITY {SOCKS | SSL}] [REMOTE_INSTANCE instance-name] [SYSTEM system-name] [OSTYPE os-type] [WITH "comment string"] Note: SERVER service-name is mandatory for CATALOG {TCPIP | TCPIP4 | TCPIP6} NODE and not allowed for CATALOG ADMIN {TCPIP | TCPIP4 | TCPIP6} NODE. SECURITY SOCKS is not allowed for CATALOG [ADMIN] TCPIP6 NODE.CATALOG DATABASE database-name [AS alias] [ON path | AT NODE node-name][AUTHENTICATION {SERVER | CLIENT | DCS | DCE SERVER PRINCIPAL principalname | KERBEROS TARGET PRINCIPAL principalname | SERVER_ENCRYPT | SERVER_ENCRYPT_AES | DCS_ENCRYPT | DATA_ENCRYPT | GSSPLUGIN}] [WITH "comment-string"]CATALOG GLOBAL DATABASE database-global-name AS aliasUSING DIRECTORY {DCE} [WITH "comment-string"]CATALOG DCS DATABASE database-name [AS target-database-name][AR arname] [PARMS "parameter-string"] [WITH "comment-string"]CATALOG NPIPE NODE node-name REMOTE computer-nameINSTANCE instance-name [SYSTEM system-name][OSTYPE os-type] [WITH "comment string"]CATALOG APPCLU NODE node-name [LOCAL local-lu] REMOTE partner-lu[MODE mode] [WITH "comment-string"]CATALOG APPN NODE node-name [NETWORK netid] REMOTE partner-lu[LOCAL local-lu] [TPNAME tp-name] [MODE mode][SECURITY {NONE | SAME | PROGRAM}] [LANADDRESS lan-adapter-address][CHGPWDLU change-password-lu] [WITH "comment-string"]CATALOG [ADMIN] LOCAL NODE node-name[INSTANCE instance-name] [SYSTEM system-name][OSTYPE os-type] [WITH "comment string"]UPDATE ALTERNATE SERVER FOR DATABASE database-aliasUSING HOSTNAME hostname PORT port-numberCHANGE DATABASE database COMMENT [ON path] WITH "comment-string"CHANGE {SQLISL | ISOLATION} TO {CS | RR | UR | RS | NC}CATALOG [USER | SYSTEM] ODBC DATA SOURCE data-source-name| ALL DATA SOURCES }UNCATALOG [USER | SYSTEM] ODBC DATA SOURCE data-source-nameLIST [USER | SYSTEM] ODBC DATA SOURCESCONNECT [USER username [{USING password [NEW new-password CONFIRM confirm-password] |CHANGE PASSWORD}]]CONNECT RESETCREATE TOOLS CATALOG catalog-name {CREATE NEW DATABASE database-name |USE EXISTING [TABLESPACE tblspace-name IN] DATABASE database-name}[FORCE] [KEEP INACTIVE]DEREGISTER [DB2 SERVER] [IN] NWBINDERY USER username [PASSWORD password]DEREGISTER [DB2 SERVER] [IN] LDAP NODE node-name[USER username [PASSWORD password]]DESCRIBE {[OUTPUT] {select-statement | call-statement | XQUERY XQuery-statement} |{TABLE | {[RELATIONAL DATA | XML DATA | TEXT SEARCH] INDEXES | DATA PARTITIONS} FOR TABLE} table-name [SHOW DETAIL]}DETACHDISCONNECT { server-name | CURRENT | ALL [SQL] }DROP DATABASE database-alias [AT DBPARTITIONNUM]DROP DBPARTITIONNUM VERIFYDROP TOOLS CATALOG catalog-name IN DATABASE database-name [FORCE]ECHO [character-string]EXPORT TO filename OF {IXF | DEL | WSF}[LOBS TO lob-path [ {,lob-path} ... ] ][LOBFILE lob-file [ {,lob-file} ... ] ][XML TO xml-path [ {,xml-path} ... ] ][XMLFILE filename [ {,filename} ... ] ][MODIFIED BY {filetype-mod ...}][XMLSAVESCHEMA][METHOD N ( column-name [ {,column-name} ... ] )] [MESSAGES message-file]{select-statement | XQUERY xquery-statement | HIERARCHY {STARTING sub-table-name |(sub-table-name [{, sub-table-name} ...])} [WHERE ...] } filetype-mod: NODOUBLEDEL, LOBSINFILE, CHARDELx, COLDELx, DECPLUSBLANK DECPTx, DATESISO, 1, 2, 3, 4, CODEPAGE=x, STRIPLZEROS, NOCHARDEL, LOBSINSEPFILES, XMLINSEPFILES, XMLCHAR, XMLGRAPHIC, XMLNODECLARATION, TIMESTAMPFORMAT=xFORCE APPLICATION {ALL | ( application-handle [ {,application-handle} ... ] )}[MODE ASYNC]GET ADMIN CONFIGURATION [FOR NODE node-name [USER username USING password]]GET CONNECTION STATEGET DATABASE CONFIGURATION [FOR database-alias] [SHOW DETAIL]GET DATABASE MANAGER CONFIGURATION [SHOW DETAIL]GET INSTANCEGET DATABASE MANAGER MONITOR SWITCHES[AT MEMBER member-number | GLOBAL]GET MONITOR SWITCHES[AT MEMBER member-number | GLOBAL]GET ROUTINE INTO filename FROM [SPECIFIC] PROCEDURE routine-name [HIDE BODY]GET SNAPSHOT FOR {DATABASE MANAGER | ALL [DCS] DATABASES |ALL [DCS] APPLICATIONS | ALL BUFFERPOOLS | [DCS] APPLICATION{APPLID appl-id | AGENTID appl-handle} | FCM FOR ALL DBPARTITIONNUMS |LOCKS FOR APPLICATION {APPLID appl-id | AGENTID appl-handle} |{ALL | [DCS] DATABASE | [DCS] APPLICATIONS | TABLES |TABLESPACES | LOCKS | BUFFERPOOLS | DYNAMIC SQL [write to file]}ON database-alias} [AT MEMBER member-number | GLOBAL]GET CLI CONFIGURATION [AT GLOBAL LEVEL] [FOR SECTION section-name]IMPORT FROM filename OF {IXF | ASC | DEL | WSF}[LOBS FROM lob-path [ {,lob-path} ... ] ] [XML FROM xml-path [ {,xml-path} ... ] ][MODIFIED BY filetype-mod ...][METHOD {L ( col-start col-end [ {,col-start col-end} ... ] )[NULL INDICATORS (col-position [ {,col-position} ... ] )] |N ( col-name [ {,col-name} ... ] ) |P ( col-position [ {,col-position} ... ] )}][XMLPARSE {STRIP | PRESERVE} WHITESPACE][XMLVALIDATE USING {XDS [DEFAULT schema-sqlid][IGNORE (schema-sqlid [ {,schema-sqlid} ... ])][MAP ((schema-sqlid,schema-sqlid) [ {(schema-sqlid,schema-sqlid)} ... ])] |SCHEMA schema-sqlid | SCHEMALOCATION HINTS }][ALLOW {NO | WRITE} ACCESS][COMMITCOUNT {n | AUTOMATIC}] [{RESTARTCOUNT | SKIPCOUNT} n][ROWCOUNT n] [WARNINGCOUNT n] [NOTIMEOUT] [MESSAGES message-file]{{INSERT | INSERT_UPDATE | REPLACE | REPLACE_CREATE}INTO {table-name [( insert-column , ... )] | hierarchy-description}| CREATE INTO {table-name [( insert-column , ... )] |hierarchy-description {AS ROOT TABLE | UNDER sub-table-name}[IN tablespace-name [INDEX IN tablespace-name] [LONG IN tablespace-name]]} filetype-mod: COMPOUND=x, INDEXSCHEMA=schema, FORCEIN, INDEXIXF, IMPLIEDDECIMAL, NOCHECKLENGTHS, NOEOFCHAR, NULLINDCHAR=x, RECLEN=x, STRIPTBLANKS, STRIPTNULLS, NO_TYPE_ID, NODOUBLEDEL, LOBSINFILE, USEDEFAULTS, CHARDELx, COLDELx, DLDELx, DECPLUSBLANK, DECPTx, DATESISO, DELPRIORITYCHAR, IDENTITYMISSING, IDENTITYIGNORE, GENERATEDMISSING, GENERATEDIGNORE, DATEFORMAT=x, TIMEFORMAT=x, TIMESTAMPFORMAT=x, KEEPBLANKS, CODEPAGE=x, NOROWWARNINGS, NOCHARDEL, NODEFAULTS, USEGRAPHICCODEPAGE, FORCECREATE, XMLCHAR, XMLGRAPHIC, SECLABELCHAR, SECLABELNAME hierarchy-description: {ALL TABLES | (sub-table-name [(insert-column, ...)], ...)} [IN] HIERARCHY {STARTING sub-table-name | (sub-table-name, ...)} INVOKE program-name [USING server-input-data]LIST ACTIVE DATABASES [AT MEMBER member-number | GLOBAL]LIST APPLICATIONS [FOR DATABASE database-alias][AT MEMBER member-number| GLOBAL] [SHOW DETAIL]LIST HISTORY {BACKUP | ROLLFORWARD | REORG |CREATE TABLESPACE | ALTER TABLESPACE | DROPPED TABLE | LOAD | RENAME TABLESPACE | ARCHIVE LOG}{ALL | SINCE timestamp |CONTAINING {schema.object_name | object_name}}FOR [DATABASE] database-aliasLIST DCS APPLICATIONS [SHOW DETAIL | EXTENDED]LIST COMMAND OPTIONSLIST DATABASE DIRECTORY [ON path]LIST DCS DIRECTORYLIST DRDA INDOUBT TRANSACTIONS [WITH PROMPTING]LIST INDOUBT TRANSACTIONS [WITH PROMPTING]LIST [ADMIN] NODE DIRECTORY [SHOW DETAIL]LIST DATABASE PARTITION GROUPS [SHOW DETAIL]LIST DBPARTITIONNUMSLIST PACKAGES [FOR {USER | ALL | SYSTEM | SCHEMA schema-name}] [SHOW DETAIL]LIST TABLES [FOR {USER | ALL | SYSTEM | SCHEMA schema-name}] [SHOW DETAIL]LIST TABLESPACES [SHOW DETAIL]LIST TABLESPACE CONTAINERS FOR tablespace-id [SHOW DETAIL]LIST INSTANCE [SHOW DETAIL]LOAD [CLIENT] FROM file/pipe/dev/cursor_name [ {,file/pipe/dev} ... ]OF {ASC | DEL | IXF | CURSOR}[LOBS FROM lob-path [ {,lob-path} ... ] ][XML FROM xml-path [ {,xml-path} ... ] ][MODIFIED BY filetype-mod [ {filetype-mod} ... ] ]][METHOD {L ( col-start col-end [ {,col-start col-end} ... ] ) [NULL INDICATORS (col-position [ {,col-position} ... ] )] | N ( col-name [ {,col-name} ... ] ) | P ( col-position [ {,col-position} ... ] )}][XMLPARSE {STRIP | PRESERVE} WHITESPACE][XMLVALIDATE USING {XDS [DEFAULT schema-sqlid][IGNORE (schema-sqlid [ {,schema-sqlid} ... ])][MAP ((schema-sqlid,schema-sqlid) [ {(schema-sqlid,schema-sqlid)} ... ])] |SCHEMA schema-sqlid | SCHEMALOCATION HINTS }][SAVECOUNT n][ROWCOUNT n] [WARNINGCOUNT n] [MESSAGES msg-file][TEMPFILES PATH pathname]{INSERT | REPLACE [{KEEPDICTIONARY | RESETDICTIONARY}] | RESTART | TERMINATE}INTO table-name [( insert-column [ {,insert-column} ... ] )][FOR EXCEPTION table-name [NOUNIQUEEXC NORANGEEXC]][STATISTICS {NO | USE PROFILE}][{COPY {NO | YES { USE TSM [OPEN num-sess SESSIONS] | TO dir/dev [ {,dir/dev} ... ] | LOAD lib-name [OPEN num-sess SESSIONS]}} | NONRECOVERABLE} ][HOLD QUIESCE] [WITHOUT PROMPTING] [DATA BUFFER buffer-size][SORT BUFFER buffer-size] [CPU_PARALLELISM n] [DISK_PARALLELISM n][FETCH_PARALLELISM {YES | NO}[INDEXING MODE {AUTOSELECT | REBUILD | INCREMENTAL | DEFERRED}][ALLOW NO ACCESS | ALLOW READ ACCESS [USE tblspace-name]][SET INTEGRITY PENDING CASCADE {DEFERRED | IMMEDIATE}] [LOCK WITH FORCE][SOURCEUSEREXIT executable [REDIRECT {[INPUT FROM {[BUFFER input-buffer] | [FILE input-file]} [OUTPUT TO FILE output-file]] [OUTPUT TO FILE output-file]] [PARALLELIZE]][[PARTITIONED DB CONFIG] partitioned-db-option [{partitioned-db-option}...]] filetype-mod: NOROWWARNINGS, ANYORDER, BINARYNUMERICS, CODEPAGE=x, DUMPFILE=x, FASTPARSE, NOHEADER, TOTALFREESPACE=x, INDEXFREESPACE=x, PAGEFREESPACE=x, FORCEIN, IMPLIEDDECIMAL, PACKEDDECIMAL, NOCHECKLENGTHS, NOEOFCHAR, NULLINDCHAR=x, RECLEN=x, STRIPTBLANKS, STRIPTNULLS, NODOUBLEDEL, LOBSINFILE, CHARDELx, COLDELx, DLDELx, DECPLUSBLANK, DECPTx, DATESISO, DELPRIORITYCHAR, USEDEFAULTS, DATEFORMAT=x, TIMEFORMAT=x, TIMESTAMPFORMAT=x, ZONEDDECIMAL, KEEPBLANKS, IDENTITYMISSING, IDENTITYIGNORE, IDENTITYOVERRIDE, GENERATEDMISSING, GENERATEDIGNORE, GENERATEDOVERRIDE, USEGRAPHICCODEPAGE, SECLABELCHAR, SECLABELNAME, XMLCHAR, XMLGRAPHIC, NOCHARDEL partitioned-db-option: PART_FILE_LOCATION x, OUTPUT_DBPARTNUMS x, PARTITIONING_DBPARTNUMS x, MODE x, MAX_NUM_PART_AGENTS x, OMIT_HEADER, ISOLATE_PART_ERRS x, STATUS_INTERVAL x, PORT_RANGE x, CHECK_TRUNCATION, MAP_FILE_INPUT x, MAP_FILE_OUTPUT x, TRACE x, NEWLINE, DISTFILE xLOAD QUERY TABLE table-name [TO local-message-file][NOSUMMARY | SUMMARYONLY] [SHOWDELTA]UPGRADE DATABASE database-alias [USER username [USING password]] [REBINDALL]{PREP | PRECOMPILE} filename [ACTION {ADD | REPLACE [RETAIN {YES | NO}][REPLVER version-id]}] [APREUSE {YES | NO}] [BINDFILE [USING bind-file]][BLOCKING {UNAMBIG | ALL | NO}] [CALL_RESOLUTION {IMMEDIATE | DEFERRED}][COLLECTION schema-name] [CONNECT {1 | 2}] [COMPATIBILITY_MODE ORA][CONCURRENTACCESSRESOLUTION {USE_CURRENTLY_COMMITTED | USE CURRENTLY COMMITTED| USECURRENTLYCOMMITTED | WAIT_FOR_OUTCOME | WAIT FOR OUTCOME | WAITFOROUTCOME}][DATETIME {DEF | USA | EUR | ISO | JIS | LOC}] [DECTYPE {NOCONVERT | CONVERT}][DEFERRED_PREPARE {NO | YES | ALL}] [DEGREE {1 | degree-of-parallelism | ANY}][DISCONNECT {EXPLICIT | CONDITIONAL | AUTOMATIC}][DYNAMICRULES {BIND | RUN | INVOKEBIND | INVOKERUN | DEFINEBIND | DEFINERUN}][EXPLAIN {NO | YES | REOPT | ALL | ONLY}] [EXPLSNAP {NO | YES | REOPT | ALL}][EXTENDEDINDICATOR {NO | YES}][FEDERATED {NO | YES}] [FUNCPATH schema-name [{,schema-name} ... ]][FEDERATED_ASYNCHRONY {ANY | number_of_atqs_in_the_plan}][GENERIC string] [INSERT {DEF | BUF}] [ISOLATION {CS |RR |UR |RS |NC}][LANGLEVEL {SAA1|MIA|SQL92E}] [LEVEL consistency-token] [LONGERROR {YES NO}][MESSAGES message-file] [NOLINEMACRO] [OPTLEVEL {0 | 1}] [OUTPUT filename][OPTPROFILE optimization-profile-name] [OWNER authorization-id][PACKAGE [USING package-name]] [PREPROCESSOR "preprocessor-command"][QUALIFIER qualifier-name] [QUERYOPT optimization-level][REOPT {NONE | ONCE | ALWAYS}][SQLCA {SAA | NONE}] [SQLERROR {NOPACKAGE | CHECK | CONTINUE}][SQLFLAG {MVSDB2V23 | MVSDB2V31 | MVSDB2V41 | SQL92E} SYNTAX][SQLRULES {DB2 | STD}] [SQLWARN {YES | NO}][STATICREADONLY {NO | YES | INSENSITIVE}] [STRING_UNITS {SYSTEM | CODEUNITS32}][SYNCPOINT {ONEPHASE | TWOPHASE | NONE}] [SYNTAX][TARGET {IBMCOB | MFCOB | MFCOB16 | C | CPLUSPLUS | FORTRAN | ANSI_COBOL |BORLAND_C | BORLAND_CPLUSPLUS}] [TRANSFORM GROUP transform-group][UNSAFENULL {NO | YES}] [VALIDATE {RUN | BIND}][WCHARTYPE {CONVERT | NOCONVERT}] [VERSION version-id]******************************************************************************** The following options are valid only if connected to a host or iSeries Server*******************************************************************************[CCSIDG double-ccsid] [CCSIDM mixed-ccsid] [CCSIDS sbcs-ccsid][CHARSUB {DEFAULT | BIT | SBCS | MIXED}] [CNULREQD {YES | NO}][DBPROTOCOL {DRDA | PRIVATE}] [DEC {31 | 15}] [DECDEL {PERIOD | COMMA}][ENCODING {ASCII | EBCDIC | UNICODE | ccsid}] [IMMEDWRITE {NO | YES | PH1}][KEEPDYNAMIC {NO | YES}] [OPTHINT hint-id] [OS400NAMING {SQL | SYSTEM}][PATH schema-name] [RELEASE {COMMIT | DEALLOCATE}][SORTSEQ {HEX | JOBRUN}] [STRDEL {APOSTROPHE | QUOTE}] [TEXT label]PRUNE HISTORY timestamp [WITH FORCE OPTION] [AND DELETE]PRUNE LOGFILE PRIOR TO log-file-namePUT ROUTINE FROM filename [OWNER new-owner [USE REGISTERS]]QUERY CLIENTQUIESCE DATABASE {IMMEDIATE | DEFER [WITH TIMEOUT minutes]}[FORCE CONNECTIONS]QUIESCE INSTANCE instance-name [USER user-name | GROUP group-name][RESTRICTED ACCESS] {IMMEDIATE | DEFER [WITH TIMEOUT minutes]}[FORCE CONNECTIONS]QUIESCE TABLESPACES FOR TABLE {tablename | schema.tablename} {SHARE | INTENT TO UPDATE | EXCLUSIVE | RESET}QUITREBIND [PACKAGE] package-name [VERSION version-id] [APREUSE {YES | NO}][RESOLVE {ANY | CONSERVATIVE}] [REOPT {NONE | ONCE | ALWAYS}][FUNCPATH schema-name [ {,schema-name} ... ]]REDISTRIBUTE DATABASE PARTITION GROUP db-partition-group{NOT ROLLFORWARD RECOVERABLE action [not-rollforward-recoverable-options]} | {action}[TABLE (table-name[{,table-name}...}) [ONLY | FIRST]][EXCLUDE (table-name [{,table-name} ...])][STOP AT local-isotime] action: {UNIFORM | USING DISTFILE distfilename} [add-drop-dbpartition] | USING TARGETMAP targetmapfilename | CONTINUE | ABORT add-drop-dbpartition: {ADD | DROP} {DBPARTITIONNUM | DBPARTITIONNUMS} (n [TO m] [{,n [TO m]} ...]) not-rollforward-recoverable-options: [DATA BUFFER n] [INDEXING MODE {REBUILD | DEFERRED} ][PRECHECK {YES | NO | ONLY}] [STATISTICS {USE PROFILE | NONE}] [QUIESCE DATABASE {YES|NO}|REGISTER [DB2 SERVER] [IN] NWBINDERY USER username [PASSWORD password]RELEASE { server-name | CURRENT | ALL [SQL] |[TO] SAVEPOINT savepoint-name }REFRESH LDAP { CLI CFG [AT {USER | GLOBAL} LEVEL]| DB DIRECTORY | NODE DIRECTORY }REORGCHK [{UPDATE | CURRENT} STATISTICS][ON {TABLE {USER | SYSTEM | ALL | table-name} | SCHEMA schema-name}]RESET ADMIN CONFIGURATION [FOR NODE node-name [USER username USING password]]RESET DATABASE CONFIGURATION FOR database-alias [MEMBER member-number]RESET DATABASE MANAGER CONFIGURATIONRESET MONITOR {ALL [DCS] | FOR [DCS] DATABASE database-alias}[AT MEMBER member-number | GLOBAL]RESTART DATABASE database-alias [USER username [USING password]][DROP PENDING TABLESPACES (tblspace-name [ {,tblspace-name} ... ])][WRITE RESUME]ROLLFORWARD DATABASE database-alias [USER username [USING password]][TO {isotime [ON ALL DBPARTITIONNUMS] [USING LOCAL TIME | USING UTC TIME]} | {END OF BACKUP [ON ALL DBPARTITIONNUMS]} | {END OF LOGS [On-DbPartitionNum-Clause]} [AND {COMPLETE | STOP}]] |[COMPLETE | STOP | CANCEL | {QUERY STATUS [USING LOCAL TIME | USING UTC TIME]} [On-DbPartitionNum-Clause]][TABLESPACE ONLINE | TABLESPACE (tblspace-name [ {,tblspace-name} ... ]) [ONLINE]][OVERFLOW LOG PATH (log-directory [{,log-directory ON DBPARTITIONNUM db-partition-number} ... ])][NORETRIEVE][RECOVER DROPPED TABLE dropped-table-id TO export-directory]On-DbPartitionNum-Clause: ON {{DBPARTITIONNUM | DBPARTITIONNUMS} (db-partition-number [TO db-partition-number] , ... ) | ALL DBPARTITIONNUMS [EXCEPT {DBPARTITIONNUM | DBPARTITIONNUMS} (db-partition-number [TO db-partition-number] , ...)]}SET CLIENT [CONNECT {1 | 2}] [DISCONNECT {EXPLICIT | CONDITIONAL | AUTOMATIC}][SQLRULES {DB2 | STD}][SYNCPOINT {ONEPHASE | TWOPHASE | NONE}] [CONNECT_MEMBER{n | CATALOG_MEMBER}][ATTACH_MEMBER n]SET CONNECTION server-nameSET UTILITY_PRIORITY TO level? [SQLSTATE] sqlstate{START DATABASE MANAGER | DB2START} [REMOTE [INSTANCE] instance-name{ADMINNODE node-name | HOSTNAME hostname} USER username USING password][ADMIN MODE {USER username | GROUP groupname }] [PROFILE profile] [INSTANCE ON hostname][[DBPARTITIONNUM | MEMBER | CF] db-partition-number] [ADD DBPARTITIONNUM HOSTNAME hostnameHOSTNAME hostname PORT logical-port [COMPUTER computer-name] [USER username][PASSWORD password] [NETNAME netname] [LIKE DBPARTITIONNUM db-partition-number | WITHOUT TABLESPACES]] | STANDALONE | RESTART [HOSTNAME hostname][PORT logical-port] [COMPUTER computer-name] [USER username] [PASSWORD password][NETNAME netname] ] ]{STOP DATABASE MANAGER | DB2STOP} [REMOTE [INSTANCE] instance-name{ADMINNODE node-name | HOSTNAME hostname} USER username USING password] [INSTANCE ON hostname [FORCE]][PROFILE profile] [[DBPARTITIONNUM | MEMBER | CF] db-partition-number | DROP DBPARTITIONNUMdb-partition-number | FORCE [[DBPARTITIONNUM | MEMBER | CF] db-partition-number] | QUIESCE [minutes]]STOP USING DATABASESTART HADR ON DATABASE database-alias [USER username [USING password]] AS{PRIMARY [BY FORCE] | STANDBY}STOP HADR ON DATABASE database-alias [USER username [USING password]]TAKEOVER HADR ON DATABASE database-alias [USER username [USING password]][BY FORCE [PEER WINDOW ONLY]]TERMINATESTART USING DATABASE database-alias [IN {SHARED | EXCLUSIVE} MODE]UNCATALOG DATABASE database-aliasUNCATALOG DCS DATABASE database-nameUNCATALOG LDAP DATABASE database-alias[USER username [PASSWORD password]]UNCATALOG LDAP NODE node-name[USER username [PASSWORD password]]UNCATALOG NODE node-nameUNQUIESCE DATABASEUNQUIESCE INSTANCE instance-nameRUNSTATS ON {TABLE | VIEW} table-name [USE PROFILE | statistics-options]statistics-options:[table-object-options] [ALLOW {WRITE | READ} ACCESS][table-sampling-options] [index-sampling-options][profile-options] [UTIL_IMPACT_PRIORITY [priority]]table-object-options:[{FOR index-clause [EXCLUDING XML COLUMNS] | [column-stats-clause] [EXCLUDING XML COLUMNS] [AND index-clause]}]table-sampling-options:[TABLESAMPLE {BERNOULLI | SYSTEM} (numeric-literal)[REPEATABLE (integer-literal)]]index-sampling-options:[INDEXSAMPLE {BERNOULLI | SYSTEM} (numeric-literal)profile-options:[{SET PROFILE [NONE | ONLY] | UPDATE PROFILE [ONLY] | UNSET PROFILE}]index-clause:[[SAMPLED | UNSAMPLED] DETAILED] {INDEXES | INDEX} {ALL | index-name[{,index-name}...]}columns-stats-clause:[ON {{ALL | KEY} COLUMNS [AND COLUMNS (column-option [{,column-option}...])] |COLUMNS (column-option [{,column-option}...])}] [distribution-clause]column-option:{column-name [LIKE STATISTICS] | (column-name [{,column-name}...])}distribution-clause:WITH DISTRIBUTION [ON {{ALL | KEY} COLUMNS [AND COLUMNS (dist-column[{,dist-column}...])] | COLUMNS (dist-column [{,dist-column}...]) }][DEFAULT [NUM_FREQVALUES number] [NUM_QUANTILES number]]dist-column:{column-name | (column-name [{,column-name}...])} [NUM_FREQVALUES number][NUM_QUANTILES number]UPDATE ALTERNATE SERVER FOR LDAP DATABASE database-aliasUSING {options ...} [USER username [PASSWORD password]] options: NODE node-name GWNODE gateway-nodeUPDATE CLI CONFIGURATION [AT {USER | GLOBAL} LEVEL] FOR SECTION section-nameUSING {CLI-keyword value ...}UPDATE HISTORY {FOR object-part | EID eid} WITH {LOCATION new-locationDEVICE TYPE new-device-type | COMMENT new-comment | STATUS new-status} new-device-type: (D)isk, dis(K)ette, (T)ape, (A)DSM, (U)ser exit, (O)therUPDATE LDAP NODE node-name[HOSTNAME host-name] [SVCENAME service-name] | [NNAME server-nname] | [IPX_ADDRESS ipx-address] | [NETWORK netid] [PARTNERLU partner-lu] [MODE mode][TPNAME tp-name] [SECURITY {NONE | SAME | PROGRAM}] [LANADDRESS lan-adapter-address] [CHGPWDLU change-password-lu] [WITH "comment-string"] [USER username [PASSWORD password]]UPDATE MONITOR SWITCHES USING {switch-name {ON | OFF} ...}[AT MEMBER member-number | GLOBAL] switch-name: BUFFERPOOL, LOCK, SORT, STATEMENT, TABLE, TIMESTAMP, UOWUPDATE DATABASE CONFIGURATION [FOR database-alias] [MEMBER member-number]USING {config-keyword value ...} [IMMEDIATE | DEFERRED] config-keyword: ALT_COLLATE, APPLHEAPSZ, APPL_MEMORY, ARCHRETRYDELAY, AUTORESTART, AUTO_REVAL, AUTO_DB_BACKUP, AUTO_DEL_REC_OBJ, AUTO_MAINT, AUTO_PROF_UPD, AUTO_REORG, AUTO_RUNSTATS, AUTO_STATS_PROF, AUTO_SAMPLING, AUTO_STATS_VIEWS, AUTO_STMT_STATS, AUTO_CG_STATS, AUTO_TBL_MAINT, AVG_APPLS, BLK_LOG_DISK_FUL, BLOCKNONLOGGED, BUFFPAGE, CATALOGCACHE_SZ, CHNGPGS_THRESH, COPYPROTECT, CUR_COMMIT, DATABASE_MEMORY, DBHEAP, DB_MEM_THRESH, DEC_ARITHMETIC, DECFLT_ROUNDING, DFT_DEGREE, DFT_EXTENT_SZ, DFT_LOADREC_SES, DFT_MTTB_TYPES, DFT_PREFETCH_SZ, DFT_QUERYOPT, DFT_REFRESH_AGE, DFT_SQLMATHWARN, DIR_OBJ_NAME, DISCOVER_DB, DLCHKTIME, DYN_QUERY_MGMT, ENABLE_XMLCHAR, FAILARCHPATH, HADR_LOCAL_HOST, HADR_LOCAL_SVC, HADR_PEER_WINDOW, HADR_REMOTE_HOST, HADR_REMOTE_INST, HADR_REMOTE_SVC, HADR_SYNCMODE, HADR_TIMEOUT, INDEXREC, INDEXSORT, LOCKLIST, LOCKTIMEOUT, LOGARCHMETH1, LOGARCHMETH2, LOGARCHCOMPR1, LOGARCHCOMPR2, LOGARCHOPT1, LOGARCHOPT2, LOGBUFSZ, LOGFILSIZ, LOGINDEXBUILD, LOGPRIMARY, LOGSECOND, MAXAPPLS, MAXFILOP, MAXLOCKS, MAX_LOG, MINCOMMIT, MIRRORLOGPATH, MULTIPAGE_ALLOC, NEWLOGPATH, NUMARCHRETRY, NUM_DB_BACKUP, NUM_FREQVALUES, NUM_IOCLEANERS, NUM_IOSERVERS, NUM_LOG_SPAN, NUM_QUANTILES, OVERFLOWLOGPATH, PAGESIZE, PCKCACHESZ, REC_HIS_RETENTN, RESTRICT_ACCESS, SELF_TUNING_MEM, SEQDETECT, SHEAPTHRES_SHR, SMTP_SERVER, SOFTMAX, SORTHEAP, SQL_CCFLAGS, STAT_HEAP_SZ, STMT_CONC, STMTHEAP, TRACKMOD, TSM_MGMTCLASS, TSM_NODENAME, TSM_OWNER, TSM_PASSWORD, UTIL_HEAP_SZ, VENDOROPT, WLM_COLLECT_INT, MON_REQ_METRICS, MON_ACT_METRICS, MON_OBJ_METRICS, CF_DB_MEM_SZ, CF_GBP_SZ, CF_SCA_SZ, CF_LOCK_SZ, CF_CATCHUP_TRGT, MON_UOW_DATA, MON_LOCKTIMEOUT, MON_DEADLOCK, MON_LOCKWAIT, MON_LW_THRESH, MON_PKGLIST_SZ, MON_LCK_MSG_LVL, SECTION_ACTUALS, CONNECT_PROC, SYSTIME_PERIOD_ADJ, MON_UOW_PKGLIST, MON_UOW_EXECLIST, LOG_DDL_STMTS, LOG_APPL_INFO, MON_RTN_EXECLIST, CF_DEDA_RATIO, DFT_SCHEMAS_DCC,HADR_SPOOL_LIMIT, HADR_TARGET_LIST, HADR_REPLAY_DELAY, MON_RTN_DATA, DFT_TABLE_ORG, STRING_UNITS, NCHAR_MAPPING, TIER2_BP_PATH, TIER2_BP_SIZE, EXTENDED_ROW_SZ, OPT_DIRECT_WRKLD, PAGE_AGE_TRGT_MCR, PAGE_AGE_TRGT_GCR, CF_TRANSPORT_METHOD, ENCRLIB, ENCROPTS, PL_STACK_TRACE, HADR_SSL_LABEL, WLM_AGENT_LOAD_TRGT, WLM_ADMISSION_CTRL, WLM_CPU_SHARES, WLM_CPU_SHARE_MODE, WLM_CPU_LIMIT, DDL_CONSTRAINT_DEF, DDL_COMPRESSION_DEF, LOG_DISK_CAP NOTE: Some config-keywords are platform/node specific and may not be available on all platforms.INSPECT {CHECK {DATABASE [BEGIN TBSPACEID [OBJECTID ]] [CATALOG TO TABLESPACE CONSISTENCY] |TABLESPACE {NAME | TBSPACEID }[BEGIN OBJECTID ] [CATALOG TO TABLESPACE CONSISTENCY] |TABLE {NAME [SCHEMA ] | TBSPACEID OBJECTID }} [FOR ERROR STATE ALL][LIMIT ERROR TO {DEFAULT | | ALL}] [] |FORMAT XML IN {NAME [SCHEMA ] | TBSPACEID OBJECTID }[{LOGICAL | PHYSICAL}] PAGES FIRST [NUMBER ][PASSWORD ]}{ROWCOMPESTIMATE TABLE {NAME [SCHEMA ] |TBSPACEID OBJECTID }}RESULTS [KEEP] [] Level-Clause: [EXTENTMAP ] [DATA ] [BLOCKMAP ] [INDEX ] [LONG ] [LOB ] [XML ] [COL ] [INDEXDATA] Level-Value: {NORMAL | NONE | LOW} Format-Value: {BRIEF | DETAIL | HEX} On-DbPartitionNum-Clause: ON {{DBPARTITIONNUM | DBPARTITIONNUMS} (db-partition-number [TO db-partition-number] , ... ) | ALL DBPARTITIONNUMS [EXCEPT {DBPARTITIONNUM | DBPARTITIONNUMS} (db-partition-number [TO db-partition-number] , ...)]}UPDATE DATABASE MANAGER CONFIGURATION [MEMBER member-number]USING {config-keyword value ...} [IMMEDIATE | DEFERRED] config-keyword: AGENTPRI, AGENT_STACK_SZ, ALTERNATE_AUTH_ENC, ALT_DIAGPATH, ASLHEAPSZ, AUDIT_BUF_SZ, AUTHENTICATION, CATALOG_NOAUTH, CLNT_KRB_PLUGIN, CLNT_PW_PLUGIN, COMM_BANDWIDTH, CONN_ELAPSE, CPUSPEED, DATAFLOWENCRYPT, DFTDBPATH, DFT_ACCOUNT_STR, DFT_MON_BUFPOOL, DFT_MON_LOCK, DFT_MON_SORT, DFT_MON_STMT, DFT_MON_TABLE, DFT_MON_UOW, DIAGLEVEL, DIAGPATH, DIAGSIZE, DIR_CACHE, DISCOVER, DISCOVER_COMM, DISCOVER_INST, FCM_NUM_BUFFERS, FCM_NUM_CHANNELS, FCM_PARALLELISM, FEDERATED, FEDERATED_ASYNC, FED_NOAUTH, FENCED_POOL, GROUP_PLUGIN, HEALTH_MON, INDEXREC, INSTANCE_MEMORY, INTRA_PARALLEL, JAVA_HEAP_SZ, JDK_PATH, KEEPFENCED, LOCAL_GSS_PLUGIN, MAXAGENTS, MAXCAGENTS, MAX_CONNECTIONS, MAX_CONNRETRIES, MAX_COORDAGENTS, MAX_LOGICAGENTS, MAX_QUERYDEGREE, MAX_TIME_DIFF, MON_HEAP_SZ, NOTIFYLEVEL, NUMDB, NUM_INITAGENTS, NUM_INITFENCED, NUM_POOLAGENTS, RQRIOBLK, RSTRT_LIGHT_MEM, SHEAPTHRES, SPM_LOG_PATH, SPM_LOG_SIZE, SPM_MAX_RESYNC, SPM_NAME, SSL_CIPHERSPECS, SSL_CLNT_KEYDB, SSL_CLNT_STASH, SSL_SVCENAME, SSL_SVR_KEYDB, SSL_SVR_LABEL, SSL_SVR_STASH, SSL_VERSIONS, START_STOP_TIME, SVCENAME, SVRCON_AUTH, SVRCON_GSSPLUGIN_LIST, SVRCON_PW_PLUGIN, SVR_PLUGIN_MODE, SYSADM_GROUP, SYSCTRL_GROUP, SYSMAINT_GROUP, SYSMON_GROUP, TM_DATABASE, TP_MON_NAME, TRUST_ALLCLNTS, TRUST_CLNTAUTH, UTIL_IMPACT_LIM, CF_MEM_SZ, CF_NUM_WORKERS, CF_DIAGPATH, CF_DIAGLEVEL, CF_NUM_CONNS, WLM_DISPATCHER, WLM_DISP_CONCUR, WLM_DISP_CPU_SHARES, WLM_DISP_MIN_UTIL, COMM_EXIT_LIST, KEYSTORE_TYPE, KEYSTORE_LOCATION, FCM_BUFFER_SIZE. NOTE: Some config-keywords are platform/node specific and may not be available on all platforms.UPDATE ADMIN CONFIGURATION USING {config-keyword value ...}[FOR NODE node-name [USER username USING password]] config-keyword: AUTHENTICATION, CONTACT_HOST, DASADM_GROUP, DAS_CODEPAGE, DAS_TERRITORY, DB2SYSTEM, DISCOVER, EXEC_EXP_TASK, JDK_PATH, JDK_64_PATH, SCHED_ENABLE, SMTP_SERVER, TOOLSCAT_DB, TOOLSCAT_INST, TOOLSCAT_SCHEMA NOTE: Some config-keywords are platform/node specific and may not be available on all platforms.INITIALIZE TAPE [ON ] [USING ] is a valid tape device name default on Windows NT is \\.\TAPE0 is the blocking factor for the tape must be a factor of, or multiple of 4096 default is the default blocksize for the deviceSET TAPE POSITION [ON ] TO is a valid tape device name default on Windows NT is \\.\TAPE0 is the tape mark to position to 1 = first position, 2 = second position etcREWIND TAPE [ON ] is a valid tape device name default on Windows NT is \\.\TAPE0ACTIVATE DATABASE database-alias [USER username [USING password]]DEACTIVATE DATABASE database-alias [USER username [USING password]] [[MEMBER] membernumber] [FORCE]SET RUNTIME DEGREE FOR { ALL | ( application-handle [{, application-handle} ...] ) } TO degreeSET TABLESPACE CONTAINERS FOR tablespace-id[{REPLAY | IGNORE} ROLLFORWARD CONTAINER OPERATIONS]USING {AUTOMATIC STORAGE | ( {PATH 'container-string' [{, PATH 'container-string'}...] |{FILE | DEVICE} 'container-string' number-of-pages [{, {FILE | DEVICE} 'container-string' number-of-pages}...]}} )CATALOG LDAP DATABASE database-name [AS alias][AT NODE node-name] [GWNODE gateway-node][AR arname] [PARMS "parameter-string"][AUTHENTICATION {SERVER | CLIENT | DCS | DCE SERVER PRINCIPAL principalname| KERBEROS TARGET PRINCIPAL principalname | SERVER_ENCRYPT | SERVER_ENCRYPT_AES| DCS_ENCRYPT | DATA_ENCRYPT | GSSPLUGIN}][WITH "comment-string"] [USER username [PASSWORD password]]CATALOG LDAP NODE node-name [AS node-alias][USER username [PASSWORD password]]SET WORKLOAD TO { SYSDEFAULTADMWORKLOAD | AUTOMATIC }PING database-alias [REQUEST packet-size] [RESPONSE packet-size] [number-of-iterations [TIME|TIMES]]SET WRITE RESUME FOR DATABASESET UTIL_IMPACT_PRIORITY FOR TO {EDIT | E} [EDITOR editor] [command-number]{HISTORY | H} [REVERSE | R] [num-commands]{RUNCMD | R} [command-number]SET STOGROUP PATHS FOR storagegroup-name ON path[{,path}...]XQUERY XQuery-statementREGISTER [DB2 SERVER] [IN] [ADMIN] LDAP {NODE|AS} node-name [PROTOCOL {APPN NETWORK netid PARTNERLU partner-lu MODE mode [TPNAME tp-name] [SECURITY {NONE | SAME | PROGRAM}] [LANADDRESS lan-adapter-address][CHGPWDLU change-password-lu] | NPIPE | {TCPIP | TCPIP4 | TCPIP6} [HOSTNAME host-name] [SVCENAME service-name] [SECURITY SOCKS] } [REMOTE computer-name] [INSTANCE instance-name] [NODETYPE {SERVER|MPP|DCS}][OSTYPE ostype] [WITH "comment-string"] [USER username [PASSWORD password]]SET SERVEROUTPUT {ON | OFF}SET SQLCOMPAT {PLSQL | DB2}SET WRITE SUSPEND FOR DATABASE [ INCLUDE LOGS | EXCLUDE LOGS ] db2 [option ...] [db2-command | sql-statement | [? [phrase | message | sqlstate | class-code]]]option: -a, -c, -d, -e{c|s}, -finfile, -i, -lhistfile, -o, -m, -n, -p, -q, -rreport, -s, -t, -td;, -v, -w, -x, -zoutputfile.db2-command: ACTIVATE DATABASE GET CONTACTS REFRESH LDAP ADD CONTACT GET/UPDATE DB CFG REGISTER LDAP ADD CONTACTGROUP GET/UPDATE DBM CFG REGISTER XMLSCHEMA ADD DBPARTITIONNUM GET DBM MONITOR SWITCHES REGISTER XSROBJECT ADD XMLSCHEMA GET DESCRIPTION FOR HEALTH REORG INDEXES/TABLE ARCHIVE LOG GET NOTIFICATION LIST REORGCHK ATTACH GET HEALTH SNAPSHOT RESET ADMIN CFG AUTOCONFIGURE GET INSTANCE RESET ALERT CFG BACKUP DATABASE GET MONITOR SWITCHES RESET DB CFG BIND GET RECOMMENDATIONS RESET DBM CFG CATALOG APPC NODE GET ROUTINE RESET MONITOR CATALOG APPN NODE GET SNAPSHOT RESTART DATABASE CATALOG DATABASE HELP RESTORE DATABASE CATALOG DCS DATABASE HISTORY REWIND TAPE CATALOG LDAP DATABASE IMPORT ROLLFORWARD DATABASE CATALOG LDAP NODE INITIALIZE TAPE RUNCMD CATALOG LOCAL NODE INSPECT RUNSTATS CATALOG NPIPE NODE LIST ACTIVE DATABASES SET CLIENT LIST COMMAND OPTIONS LIST APPLICATIONS SET RUNTIME DEGREE CATALOG ODBC DATA SOURCE LIST DATABASE DIRECTORY SET TABLESPACE CONTAINERS CATALOG TCPIP NODE LIST DB PARTITION GROUPS SET TAPE POSITION CHANGE DATABASE COMMENT LIST DBPARTITIONNUMS SET UTIL_IMPACT_PRIORITY CHANGE ISOLATION LEVEL LIST DCS APPLICATIONS SET WRITE COMPLETE XMLSCHEMA LIST DCS DIRECTORY START DATABASE MANAGER CREATE DATABASE LIST DRDA INDOUBT START HADR CREATE TOOLS CATALOG LIST HISTORY STOP DATABASE MANAGER DEACTIVATE DATABASE LIST INDOUBT TRANSACTIONS STOP HADR DECOMPOSE XML DOCUMENT LIST NODE DIRECTORY TAKEOVER HADR DECOMPOSE XML DOCUMENTS LIST ODBC DATA SOURCES TERMINATE DEREGISTER LIST PACKAGES/TABLES UNCATALOG DATABASE DESCRIBE LIST TABLESPACE CONTAINERS UNCATALOG DCS DATABASE DETACH LIST TABLESPACES UNCATALOG LDAP DATABASE DROP CONTACT LIST UTILITIES UNCATALOG LDAP NODE DROP CONTACTGROUP LOAD UNCATALOG NODE DROP DATABASE LOAD QUERY UNCATALOG ODBC DATA DROP DBPARTITIONNUM PING UNQUIESCE DATABASE DROP TOOLS CATALOG PREP/PRECOMPILE UNQUIESCE INSTANCE ECHO PRUNE HISTORY/LOGFILE UPDATE ALERT CFG EDIT PUT ROUTINE UPDATE COMMAND OPTIONS EXPORT QUERY CLIENT UPDATE CONTACT FORCE APPLICATION QUIESCE DATABASE UPDATE CONTACTGROUP GET/UPDATE ADMIN CFG QUIESCE INSTANCE UPDATE NOTIFICATION LIST GET ALERT CFG QUIESCE TABLESPACES UPDATE HISTORY GET/UPDATE CLI CFG QUIT UPDATE LDAP NODE GET CONNECTION STATE REBIND UPDATE MONITOR SWITCHES GET CONTACTGROUP RECOVER UPGRADE DATABASE GET CONTACTGROUPS REDISTRIBUTE DB PARTITION XQUERY Note: Some commands are operating system specific and may not be available. For further help: ? db2-command - help for specified command ? OPTIONS - help for all command options ? HELP - help for reading help screens The preceding three options can be run as db2