-ACCESS DATABASE
<_ ,_____________ >>__ACCESS DATABASE__(______database-name_ǀ________)_______________________> ǀ_*_____________________ǀ ǀ_dbname1:dbname2_______ǀ ǀ_dbname*_______________ǀ ǀ_*dbname_______________ǀ ǀ_*dbname*______________ǀ ǀ_*dbstring1*dbstring2*_ǀ > _________________________________________________________________________> ǀ </_><_ ,________ ǀ ǀ_SPACENAM(_ ___space-name_ǀ________)_______________________________ǀ ǀ_*___________________________ǀǀ <_,_______ ǀ ǀ_spacename1:spacename2_______ǀǀ_PART(_ ___integer_ǀ_)_ǀ ǀ_spacename*__________________ǀ ǀ_int1:int2_ǀ ǀ_*spacename__________________ǀ ǀ_*spacename*_________________ǀ ǀ_*spacestring1*spacestring2*_ǀ >_____MODE(__OPEN_______)__________________________________________________>< ǀ_NGBPDEP_ǀ ǀ_STATS___ǀ
(This article is part of our Db2 Guide. Use the right-hand menu to navigate.)
-ALTER BUFFERPOOL
>>__ALTER BUFFERPOOL__(__bpname__)__ _________________ ____________________> ǀ_VPSIZE(integer)_ǀ >__________________________________________________________________________> ǀ ___*_______ ǀ ǀ ___*_______ ǀ ǀ_VPSIZEMIN_ǀ_(integer)_ǀ_ǀ ǀ_VPSIZEMAX_ǀ_(integer)_ǀ_ǀ >__ ____________________ __________________ _______________________________> ǀ_FRAMESIZE(__4K___)_ǀ ǀ_VPSEQT(integer)_ǀ ǀ_VPPSEQT(integer)_ǀ ǀ_1M_ǀ ǀ_2G_ǀ >__ ___________________ ___________________________________________________> ǀ_DWQT(integer)_ǀ ǀ_VDWQT(integer1,integer2)_ǀ >__ _________________________ _____________________________________________> ǀ_PGSTEAL__(____LRU_____)_ǀ ǀ_FIFO_ǀ ǀ_NONE_ǀ >__ ______________________________________________________________________>< ǀ __NO___ ǀ ǀ _NO__ ǀ ǀ_PGFIX__(_ǀ__YES__ǀ__)_ǀ ǀ_AUTOSIZE_(_ǀ_YES_ǀ_)_ǀ >__ ___________________ __________________________________________________> ǀ_SPSIZE(integer)_ǀ ǀ_SPSEQT(integer)_ǀ
-ACTIVATE
>>__ACTIVE FUNCTION LEVEL__(_function-level_)______________________________> ǀ_TEST_ǀ
-ACTIVATE NEW FUNCTION
>>__ACTIVE NEW FUNCTION___________________________________________________>
-ALTER GROUPBUFFERPOOL
>>__ALTER GROUPBUFFERPOOL__(__ _gbpname_______ ___)______________________> ǀ_sructure-name_ǀ >__ _____________________ __ ____________________ _______________________> ǀ_GBPCACHE(_ _YES_ _)_ǀ ǀ_AUTOREC(_ _YES_ _)_ǀ ǀ_NO__ǀ ǀ_NO__ǀ >__ ______________ __ ___________________ ______________________________> ǀ_RATIO(ratio)_ǀ ǀ_CLASST(Thr1, Thr2_ǀ ǀ_GBPOOLT(integer__ǀ >__ ___________________ ________________________________________________> ǀ_GBPCHKPT(integer)_ǀ
-ALTER UTILITY
>>__ALTER__UTILITY__(__utility-id__)__REORG______________________________> ǀ_REBUILD_ǀ >__ ___________________________ __ ______________________ _______________> ǀ_DEADLINE(_ _NONE______ _)_ǀ ǀ_MAXRO(_ _integer_ _)_ǀ ǀ_timestamp_ǀ ǀ_DEFER___ǀ >__ _________________________ __ ______________________ ________________>< ǀ_LONGLOG(_ _CONTINUE_ _)_ǀ ǀ_DELAY(___integer___)_ǀ ǀ_TERM_____ǀ ǀ_DRAIN____ǀ
-ARCHIVE LOG
>>__ARCHIVE LOG__________________________________________________________> _SCOPE(MEMBER)_____________________________________ >__ǀ___________________________________________________ǀ_________________>< ǀ_SCOPE(GROUP)______________________________________ǀ ǀ_MODE(QUIESCE)__ ___________ __ _________________ _ǀ ǀ ǀ_TIME(nnn)_ǀ ǀ _NO__ ǀ ǀ ǀ ǀ_WAIT(_ǀ_YES_ǀ_)_ǀ ǀ ǀ_CANCEL OFFLOAD____________________________________ǀ
-BIND PACKAGE
>>_BIND PACKAGE_(________________collection-id__)_____________________)_____> ǀ_location-name._ǀ ǀ_OWNER(authorization-id)_ǀ >________________________________enable-block___member-block________________> ǀ_QUALIFIER(qualifier-name)¬_ǀ >___________________________________________________________________________> ǀ_DEFER(PREPARE)__________ǀ ǀ_ACTION__(REPLACE)_____________________ǀ ǀ_NODEFER(PREPARE)________ǀ ǀ ǀ_REPLVER(version-id)_ǀ ǀ ǀ_DEFER (INHERITFROMPLAN)_ǀ ǀ_(ADD)___________________________ǀ >___________________________________________________________________________> ǀ _NO__ ǀ ǀ ǀ ǀ_CURRENTDATA (_ǀ_YES_ǀ_)ǀ ǀ__DECSTAT(__NO___)__ǀ ǀ_YES_ǀ >_ _________________________________________________________________________> ǀ _DRDA____ ǀǀ _1___ ǀǀ_DYNAMICRULES(_RUN_)_ǀ ǀ_DBPROTOCOL_(_ǀ_DRDACBF_ǀ_)_ǀǀ_DEGREE(_ǀ_ANY_ǀ_)_ǀ ǀ_BIND_______ǀ ǀ_DEFINEBIND_ǀ ǀ_DEFINERUN__ǀ ǀ_INVOKEBIND_ǀ ǀ_INVOKERUN__ǀ >___________________________________________________________________________> ǀ_ENCODING(_ _ASCII___)_ǀ ǀ _NO___ ǀ ǀ _I_ ǀ ǀ_EBCDIC__ǀ ǀ_EXPLAIN(_ǀ_YES__ǀ_)_ǀ ǀ_FLAG(_ǀ_W_ǀ_)_ǀ ǀ_UNICODE_ǀ ǀ_ONLY_ǀ ǀ_E_ǀ ǀ_ccsid___ǀ ǀ_C_ǀ >___________________________________________________________________________> ǀ_IMMEDWRITE_(__NO____)________ǀ ǀ_ISOLATION(_ _RR_ _)_ǀ ǀ_YES_____________ǀ ǀ_RS_ǀ ǀ_CS_ǀ ǀ_UR_ǀ ǀ_NC_ǀ __NONE__ >____________________________________ǀ________ǀ_____________________________> ǀ _NO__ ǀ ǀ_REOPT(_ǀ_ALWAYS_ǀ_)ǀ_OPTHINT__(_’hint-id’__)_ǀ ǀ_KEEPDYNAMIC(_ǀ_YES_ǀ_)_ǀ ǀ_ONCE___ǀ ǀ_AUTO___ǀ >___________________________________________________________________________> ǀ <_ ,______________ ǀ ǀ_RELEASE(_ _COMMIT___________)__ǀ ǀ_PATH(__ _schema-name_ ǀ_)_ǀ ǀ_DEALLOCATE______ǀ ǀ_USER________ǀ >___________________________________________________________________________> ǀ _NOPACKAGE_ ǀ ǀ _RUN__ ǀ ǀ_SQLERROR(_ǀ_CONTINUE__ǀ_)_ǀ ǀ_VALIDATE(_ǀ_BIND_ǀ_)_ǀ ǀ_CHECK_____ǀ >______________________________________________________rounding-block_______> ǀ _NO__ ǀǀ_GENERIC(_’string’_)_ǀ ǀ_EXTENDEDINDICATOR_ǀ_YES_ǀ_ǀ >___________________________________________________________________________> ǀ_CONCURRENTACCESSRESOLUTION_(_USECURRENTLYCOMMITTED_)_ǀ ǀ_WAITFOROUTCOME______ǀ >___________________________________________________________________________> ǀ _NONE__ ǀ ǀ _NONE__ ǀ ǀ_AREUSE_ǀ_ERROR_ǀ_ǀ ǀ_ACOMPARE_ǀ_WARN__ǀ_ǀ ǀ_WARN__ǀ ǀ_ERROR_ǀ >___________________________________________________________________________> ǀ _YES_ ǀ ǀ _YES__ ǀ ǀ_SYSTIMESENSITIVE(_ǀ_NO__ǀ_)_ǀ ǀ_BUSTIMESENSITIVE(_ǀ_NO__ǀ_)_ǀ >___________________________________________________________________________> ǀ _YES__ ǀ ǀ ǀ ǀ_ARCHIVESENSITIVE(_ǀ_NO__ǀ_)__ǀ ǀ_APPLCOMPAT(__V10R1__)_ǀ ǀ_V11R1_ǀ member-block: >____MEMBER(dbrm-member-name)________________________________________________> ǀ ǀ_LIBRARY(dbrm-library-name__ǀ ǀ ǀ_COPY(collection-id.package-id)___________________________________________ǀ ǀ ǀCOPYVER(ver-id)ǀǀ _COMPOSITE_ ǀ ǀ ǀ ǀOPTIONS(ǀ_COMMAND__ǀ)ǀ ǀ ǀ_DEPLOY(collection-id.package-id)_COPYVER(ver-id)_________________________ǀ enable-block: >>__ _______________________________________________________________________>< ǀ _ENABLE(*)________________________ ǀ ǀ ǀ <_,__________ ǀ <____________________________ ǀ ǀ ǀ_ _ENABLE__ __(___ _BATCH____ ǀ_)_ǀ________________________________ǀ_ǀ ǀ_DISABLE_ǀ ǀ_DLIBATCH_ǀ ǀ <_,_____________ ǀ ǀ_DB2CALL__ǀ ǀ_DLIBATCH(_connection-name_ǀ_)_ǀ ǀ_CICS_____ǀ ǀ_ <_,______ ǀ ǀ_IMS______ǀ ǀ_CICS(___applid_ǀ_)____________ǀ ǀ_IMSBMP___ǀ ǀ <_,_____ ǀ ǀ_IMSMPP___ǀ ǀ_IMSBMP(___imsid_ǀ_)___________ǀ ǀ_REMOTE___ǀ ǀ <_,_____ ǀ ǀ_RRSAF____ǀ ǀ_IMSMPP(___imsid_ǀ_)___________ǀ ǀ <_,________________ ǀ ǀ_REMOTE(___location-name_ _ǀ_)_ǀ ǀ___ǀ rounding-block: >>__ROUNDING__(__CEILING______)_____________________________________________>< ǀ_DOWN_____ǀ ǀ_FLOOR____ǀ ǀ_HALFDOWN_ǀ ǀ_HALFEVEN_ǀ ǀ_UP_______ǀ
-BIND PLAN
>>_BIND______________________________________________________________________> ǀ_PLAN(plan-name)_ǀǀ_OWNER(authroization-id)_ǀǀ_QUALIFIER(qual-name)_ǀ _NODEFER(PREPARE)_ >__enable-block__pklist-block_ǀ__________________ǀ___________________________> ǀ_DEFER(PREPARE)___ǀ ǀ _USE______ ǀ ǀ_ACQUIRE(_ǀ_ALLOCATE_ǀ_)ǀ >____________________________________________________________________________> ǀ _(__REPLACE__)__ ________ _ ǀ ǀ_CACHESIZE(decimal-value)_ǀ ǀ ǀ ǀ_RETAIN_ǀ ǀ ǀ ǀ_ACTION__ǀ_(ADD)_____________________ǀ ǀ >__ _________________________________________________________________________> ǀ _NO__ ǀ ǀ_CURRENTSERVER(location-name)_ǀ ǀ_CURRENTDATA(_ǀ_YES_ǀ_)_ǀ >__ _________________________________________________________________________> ǀ_DBPROTOCOL__(___DRDA______)_ǀ ǀ _1___ ǀ ǀ_DEGREE(_ǀ_ANY_ǀ_)_ǀ >__ _________________________________________________________________________> ǀ _EXPLICIT____ ǀ ǀ _RUN__ ǀ ǀ_DISCONNECT(_ǀ_AUTOMATIC___ǀ_)_ǀ ǀ_DYNAMICRULES(_ǀ_BIND_ǀ_)_ǀ ǀ_CONDITIONAL_ǀ >____________________________________________________________________________> ǀ_ENCODING(_ _ASCII___ _)_ǀ ǀ _NO__ ǀ ǀ _I_ ǀ ǀ_EBCDIC__ǀ ǀ_EXPLAIN(_ǀ_YES_ǀ_)_ǀ ǀ_FLAG(_ǀ_W_ǀ_)_ǀ ǀ_UNICODE_ǀ ǀ_E_ǀ ǀ_ccsid___ǀ ǀ_C_ǀ >__ _________________________________________________________________________> ǀ_IMMEDWRITE(_ _NO__ _)_ǀǀ_ISOLATION(_ _RR_ _)_ǀǀ _NO__ ǀ ǀ_YES_ǀ ǀ_RS_ǀ ǀ_KEEPDYNAMIC(_ǀ_YES_ǀ_)ǀ ǀ_CS_ǀ ǀ_UR_ǀ _NONE___ >_REOPT_(ǀ_ALWAYS_ǀ)_________________________________________________________> ǀ_ONCE___ǀ ǀ_OPTHINT_(_’hint-id’_)_ǀǀ <_ ,______________ ǀ ǀ_AUTO___ǀ ǀ_PATH(__ _schema-name_ ǀ_)_ǀ ǀ_USER________ǀ >____________________________________________________________________________> ǀ _COMMIT_____ ǀǀ _DB2_ ǀǀ _RUN__ ǀ ǀ_RELEASE(_ǀ_DEALLOCATE_ǀ_)_ǀǀ_SQLRULES(_ǀ_STD_ǀ_)ǀǀ_VALIDATE(_ǀ_BIND_ǀ_)_ǀ >___________________________________________________________________________>< ǀ_ROUNDING(___CEILING___)__ǀ ǀ _DISABLE_ ǀ ǀ_DOWN_____ǀ ǀ_PROGAUTH(_ǀ_ENABLE__ǀ_)_ǀ ǀ_FLOOR____ǀ ǀ_HALFDOWN_ǀ ǀ_HALFEVEN_ǀ ǀ_HALFUP___ǀ ǀ_UP_______ǀ >____________________________________________________________________________> ǀ_CONCURRENTACCESSRESOLUTION_(_USECURRENTLYCOMMITTED_)_ǀ ǀ_WAITFOROUTCOME______ǀ enable-block: >>_ ________________________________________________________________________>< ǀ _ENABLE(*)________________________ ǀ ǀ ǀ <_,_________ ǀ <___________________________ ǀ ǀ_ǀ_ _ENABLE__ __(___ _BATCH____ ǀ_)_ǀ________________________________ǀ_ǀ ǀ_DISABLE_ǀ ǀ_DLIBATCH_ǀ ǀ <_,_____________ ǀ ǀ_DB2CALL__ǀ ǀ_DLIBATCH(_connection-name_ǀ_)_ǀ ǀ_CICS_____ǀ ǀ <_,______ ǀ ǀ_IMS______ǀ ǀ_CICS(___applid_ǀ_)____________ǀ ǀ_IMSBMP___ǀ ǀ <_,_____ ǀ ǀ_IMSMPP___ǀ ǀ_IMSBMP(___imsid_ǀ_)___________ǀ ǀ_RRSAF____ǀ ǀ <_,_____ ǀ ǀ_IMSMPP(___imsid_ǀ_)___________ǀ Pklist-block: <_,__________________________________________________ >>_PKLIST(_____________________,_collection-id____package-id_ ____ǀ_)______>< ǀ_location-name._ǀ ǀ_*___________ǀ ǀ_*__________ǀ ǀ_*._____________ǀ
-BIND QUERY
>>__BIND QUERY_____________________________________________________________>< ǀ _NO___ ǀ ǀ_EXPLAININPUTSCHEMA(schema-name)_ǀ ǀ_LOOKUP(_ǀ_YES__ǀ__)_ǀ
-CANCEL THREAD
>>__CANCEL__ _THREAD(token)_________________________________________________> ǀ_DDFTHREAD(_ _luwid_ _)_ǀ ǀ_DUMP_ǀ ǀ_LOCAL_ǀ ǀ_NOBACKOUT_ǀ ǀ_token_ǀ >___________________________________________________________________________>< ǀ_FORCE_ǀ
/CHANGE IMS
>>__/CHANGE__ _SUBSYS__subsystem-name________________________ ____________> ǀ_SUBSYS__ALL___________________________________ǀ ǀ_SUBSYS__subsystem-name__OASN__schedule-number_ǀ >__RESET__________________________________________________________________><
DCLGEN
>>__DCLGEN__TABLE(_ _table-name_ _)__ ___________________ _______________> ǀ_view-name__ǀ ǀ_OWNER(owner-name)_ǀ >__ ___________________ ________________________________________________> ǀ_AT(location-name)_ǀ >__LIBRARY(library-name_ _______________ __ ___________ _)______________> ǀ_(member-name)_ǀ ǀ_/password_ǀ >__ _______________________ __ ________________________ ________________> ǀ _ADD_____ ǀ ǀ ǀ ǀ_ACTION(_ǀ_REPLACE_ǀ_)_ǀ ǀ_LANGUAGE(___PLI______)_ǀ ǀ_C______ǀ ǀ_IBMCOB_ǀ ǀ_CPP____ǀ >__ _______________ __ ___________________________ __ _______ __________> ǀ_NAMES(prefix)_ǀ ǀ_STRUCTURE(structure-name)_ǀ ǀ_APOST_ǀ ǀ_QUOTE_ǀ >__ ________________ __ _____________________ __________________________> ǀ _NO__ ǀ ǀ_DBCSSYMBOL(_ _G_ _)_ǀ ǀ_LABEL_ǀ_YES_ǀ__ǀ ǀ_N_ǀ >__ ______________________ __ _______________________ __________________> ǀ _YES_ ǀ ǀ _NO__ ǀ ǀ_DBCSDELIM(_ǀ_NO__ǀ_)_ǀ ǀ_COLUSUFFIX(_ǀ_YES_ǀ_)_ǀ >__ ___________________________________________________________________>< ǀ _NO__ ǀǀ _STD__ ǀǀ _NO_ ǀ ǀ_INDVAR(_ǀ_YES_ǀ_)_ǀǀ_RMARGIN_(_ǀ_WIDE_ǀ_)_ǀǀ_DCLBIT_(_ǀYES_ǀ_)_ǀ
/DISPLAY IMS
<_ ,______________ >>__/DISPLAY__ _SUBSYS___subsystem-name_ǀ______ _________________________> ǀ_SUBSYS__ALL____________________ǀ ǀ </_><_ ,______________ ǀ ǀ_OASNSUBSYS___subsustem-name_ǀ__ǀ ǀ_OASN__SUBSYS__ALL______________ǀ
-DISPLAY ACCEL
_(_*_)________________________ ǀ <_ ,______________ ǀ >>__DISPLAY__ACCEL _ǀ__(___accelerator-name_ǀ___)__ǀ_____________________> ǀ_DETAIL__ǀ >________________________________________________________________________> ǀ_LIST_(__*__________)_______ǀ ǀ ǀ ǀ_ACTIVE_ǀ ǀ _LOCAL_ ǀ ǀ_SCOPE__(_ǀ_GROUP_ǀ )_ǀ >_______________________________________________________________________>< ǀ ǀ ǀ_MEMBER(member-name)_ǀ
-DISPLAY ARCHIVE
>>__DISPLAY ARCHIVE_____________________________________________________><
-DISPLAY BUFFERPOOL
_(_ACTIVE__)______ >>__DISPLAY BUFFERPOOL__ǀ__________________ǀ____________________________> ǀ_(__*__)__________ǀ ǀ <_ ,______ ǀ ǀ_(____bpname_ǀ__)_ǀ >__ ________________________ __ ____________________ __________________> ǀ _INTERVAL_ ǀ ǀ _ACTIVE_ ǀ ǀ_DETAIL(_ǀ__________ǀ_)_ǀ ǀ_LIST(_ǀ________ǀ_)_ǀ ǀ_*________ǀ ǀ_*______ǀ _ACTIVE_ >__ ________ __(__ǀ________ǀ__)________________________________________> ǀ_LSTATS_ǀ ǀ_*______ǀ >__ _________________________________ _________________________________> ǀ _*_________________ ǀ ǀ ǀ_</_><_ ,_____________ ǀ ǀ ǀ_DBNAME(_ǀ___database-name_ǀ_ǀ_)_ǀ ǀ_name1:name2_______ǀ ǀ_name*_____________ǀ >__ ___________________ ____________ __ ___________________ ___________> ǀ _*______________ ǀ ǀ_GBPDEP(_ _YES_ _)_ǀ ǀ ǀ </_><_ ,__________ ǀ ǀ ǀ_NO__ǀ ǀ_SPACENAM(_ǀ___space-name_ǀ_ǀ_)_ǀ ǀ_name1:name2____ǀ ǀ_name*__________ǀ >__ _____________________ ____________________________________________>< ǀ_CASTOWNR(_ _YES_ _)_ǀ ǀ_NO__ǀ
-DISPLAY DATABASE
<_ ,_____________ >>__DISPLAY DATABASE__(_ ___database-name_ǀ_____ _)____________________> ǀ_*_____________________ǀ ǀ_dbname1:dbname2_______ǀ ǀ_dbname*_______________ǀ ǀ_*dbname_______________ǀ ǀ_*dbname*______________ǀ ǀ_*dbstring1*dbstring2*_ǀ >_ _ __________ ___________________________________________________________> ǀ ǀ_USE______ǀ ǀ ǀ ǀ_CLAIMERS_ǀ ǀ ǀ ǀ_LOCKS____ǀ ǀ ǀ ǀ_LPL______ǀ ǀ ǀ ǀ_WEPR_____ǀ ǀ ǀ </_><_ ,__________ ǀ ǀ_SPACENAM__(__ ___space-name_ǀ_______________)________________________ǀ ǀ ǀ_*__________________________ǀ ǀ______________________ǀ ǀ ǀ ǀ_spacename1:spacename2______ǀ ǀ_USE______ǀǀ_ONLY_ǀ ǀ ǀ ǀ_spacename*_________________ǀ ǀ_CLAIMERS_ǀ ǀ ǀ ǀ_*spacename_________________ǀ ǀ_LOCKS____ǀ ǀ ǀ ǀ_*spacename*________________ǀ ǀ_LPL______ǀ ǀ ǀ ǀ_*spacestring1*spacestring2_ǀ ǀ_WEPR_____ǀ ǀ ǀ_ONLY_________________________________________________________________ǀ >________________________________________________________________________>< ǀ <_,_______ ǀ ǀ ǀ ǀ_PART(_ ___integer_ǀ_______ _)_ǀ ǀ__OVERVIEW__ǀ ǀ_integer1:integer2_ǀ >________________________________________________________________________>< ǀ ǀ_50______ ǀ ǀ_LIMIT(_ǀ_integer_ǀ_)_ǀ ǀ_*_______ǀ >________________________________________________________________________>< ǀ_AFTER_ǀǀ_ACTIVE_ǀǀ_RESTRICT___(______)_ǀǀ_ADVISORY__(__ ___________)_ǀ ǀ <_,_____ ǀ ǀ <_,_____ ǀ ǀ_ACHKP___ǀ_ǀ ǀ___ICOPY_ǀ_ǀ ǀ_CHKP______ǀ ǀ___AUXW____ǀ ǀ_COPY______ǀ ǀ___ARBDP___ǀ ǀ_GRECP_____ǀ ǀ___AREO*___ǀ ǀ_LPL_______ǀ ǀ___AREOR___ǀ ǀ_RBDP______ǀ ǀ_RECP______ǀ ǀ_REORP_____ǀ ǀ_RO________ǀ ǀ_STOP______ǀ ǀ_UT________ǀ ǀ_UTRO______ǀ ǀ_UTRW______ǀ ǀ_UTUT______ǀ ǀ_UT*_______ǀ ǀ_WEPR______ǀ
-DISPLAY DDF
>>__DISPLAY DDF__________________________________________________________>< ǀ_ALIAS (alias-name)_ǀ ǀ_DETAIL_ǀ
-DISPLAY DYNQUERYCAPTURE
>>__DISPLAY DYNQUERYCAPTURE__ _________________________________ _________> ǀ _(*)_________________________ ǀ ǀ ǀ <_ ,___________________ ǀ ǀ ǀ_CNO(ǀ_(___integer___________ _ǀ_)_ǀ_ǀ
-DISPLAY FUNCTION SPECIFIC
>>__DISPLAY FUNCTION SPECIFIC____________________________________________> _(*.*)____________________________________ >__ǀ___________________________________________ǀ_________________________> ǀ <_ ,_________________________________ ǀ ǀ_(___ _schema.specific-function-name_ _ǀ_)_ǀ ǀ_schema.partial-name*__________ǀ >__ ______________________ ______________________________________________>< ǀ _LOCAL_ ǀ ǀ_SCOPE__(_ǀ_______ǀ_)_ǀ ǀ_GROUP_ǀ
-DISPLAY GROUP
>>__DISPLAY GROUP__ ________ ____________________________________________>< ǀ_DETAIL_ǀ
-DISPLAY GROUPBUFFERPOOL
>>__DISPLAY GROUPBUFFERPOOL__ ________________________________ __________> ǀ _(*)________________________ ǀ ǀ ǀ <_ ,__________________ ǀ ǀ ǀ_ǀ_(___ _gbpname________ _ǀ_)_ǀ_ǀ ǀ_structure-name_ǀ >__ _________________________ __ _______________________________ ______> ǀ _*_______ ǀ ǀ_MDETAIL__ __________________ _ǀ ǀ_TYPE__(__ǀ_GCONN___ǀ__)_ǀ ǀ _INTERVAL_ ǀ ǀ_MCONN___ǀ ǀ_(_ǀ__________ǀ_)_ǀ ǀ_NOCACHE_ǀ ǀ_*________ǀ >__ _______________________________ __ _________________________ ______> ǀ_GDETAIL__ __________________ _ǀ ǀ _NO__ ǀ ǀ _INTERVAL_ ǀ ǀ_CONNLIST__(__ǀ_YES_ǀ__)_ǀ ǀ_(_ǀ__________ǀ_)_ǀ ǀ_*________ǀ </_>
-DISPLAY LOCATION
_(*)____________________________ >>__DISPLAY LOCATION__ǀ_________________________________ǀ_______________> ǀ <_ ,_____________________ ǀ ǀ_DETAIL_ǀ ǀ_(____ _location-name_____ _ǀ__)_ǀ ǀ_partial-location*_ǀ ǀ___________ǀ ǀ_ipaddr____________ǀ </_>
-DISPLAY LOG
>>__DISPLAY LOG_________________________________________________________><
-DISPLAY PROCEDURE
_(*.*)______________________________ >>__DISPLAY PROCEDURE__ǀ____________________________________ǀ__________> ǀ <_ ,_________________________ ǀ ǀ__(___ _schema.procedure-name_ _ǀ_)_ǀ ǀ_schema.partial-name*__ǀ ǀ_procedure-name________ǀ ǀ_partial-name*_________ǀ >_____________________________________________________________________>< ǀ _LOCAL_ ǀ ǀ_SCOPE__(_ǀ_______ǀ_)_ǀ ǀ_GROUP_ǀ
-DISPLAY PROFILE
>>__DISPLAY PROFILE___________________________________________________><
-DISPLAY RLIMIT
>>__DISPLAY RLIMIT____________________________________________________><
-DISPLAY STATS
>>__DISPLAY_STATS__(_INDEXMEMORYUSAGE_)_______________________________>< ǀ_DIS___ǀ ǀ_IDXMEMUSE_____ǀ ǀ_LIMIT_(_integer_)_ǀ ǀ_,________ǀ
-DISPLAY THREAD
>>__DISPLAY THREAD___ ____________________________________ ___________> ǀ <_ ,_______________________ ǀ ǀ_(_____ _connection-name_____ _ǀ__)_ǀ ǀ ǀ_partial-connection*_ǀ ǀ ǀ_(__*__)____________________________ǀ >__ _______________________ __ _______________________ _______________> ǀ _LOCAL__ ǀ ǀ _ACTIVE____ ǀ ǀ_SCOPE__(_ǀ________ǀ_)_ǀ ǀ_TYPE(_ǀ_INDOUBT___ǀ_)_ǀ ǀ_GROUP__ǀ ǀ_*_________ǀ ǀ_INACTIVE__ǀ ǀ_POSTPONED_ǀ ǀ_PROC______ǀ ǀ_SYSTEM____ǀ >__ _______________________________________________ __ ________ ______> ǀ </_><_ ,_____________________ ǀ ǀ_DETAIL_ǀ ǀ_ _LOCATION(_ ___ _location-name_____ _ǀ_ _)_ _ǀ ǀ ǀ ǀ_partial-location*_ǀ ǀ ǀ ǀ ǀ_*_________________________ǀ ǀ ǀ <_,________________ ǀ ǀ_LUWID(__ _luwid__________ ǀ_)_____________ǀ ǀ_partial-luwid*_ǀ ǀ_token__________ǀ >__ _____________________________ ____________________________________>< ǀ <_,______ ǀ ǀ _512_____ ǀ ǀ_RRSURID_ _(__rrs-uridǀ_)_ __ǀ ǀ_LIMIT(_ǀ_integer_ǀ_)_ǀ ǀ_( * )__________ǀ ǀ_*_______ǀ
-DISPLAY TRACE
_(__*__)_______ >>__DISPLAY TRACE__ǀ_______________ǀ__ ______________________ ______> ǀ_(__PERFM__)___ǀ ǀ _LOCAL_ ǀ ǀ_(__ACCTG__)___ǀ ǀ_SCOPE__(_ǀ_______ǀ_)_ǀ ǀ_(__STAT___)___ǀ ǀ_GROUP_ǀ ǀ_(__AUDIT__)___ǀ ǀ_(__MONITOR__)_ǀ >__ ___________________ __ __________________ _____________________> ǀ_destination-block_ǀ ǀ_constraint block_ǀ >__ _____________________ __ _________________ ____________________>< ǀ_DETAIL(output-type)_ǀ ǀ_COMMENT(string)_ǀ ǀ_RMID_ǀ destination block: <_,_____ >>__DEST(__ _GTF_ ǀ_)_________________________________________________> ǀ_SMF_ǀ ǀ_SRV_ǀ ǀ_OPn_ǀ constraint block: _*_____________ _*__________________________ ǀ <_ ,_________ ǀ ǀ <_,______________________ ǀ >__PLAN(_ǀ___plan-name_ǀ_ǀ_)__PKGLOC(_ǀ__package-location________ǀ_ǀ_)__> ǀ_partial-package-location_ǀ _*______________ ǀ </_><_ ,_______ ǀ >__AUTHID(_ǀ___auth-id_ǀ____ǀ_)_________________________________________> ǀ_partial-userid_ǀ _*___________ _*___________ ǀ </_><_ ,_______ ǀ ǀ <_,_______ ǀ >__CLASS(_ǀ____integer_ǀ_ǀ_)__TNO(_ǀ___integer_ǀ_ǀ_)_____________________> _*_________________ _*_________________ ǀ </_><_ ,_____________ ǀ ǀ <_,________ ǀ >__LOCATION(_ǀ___location-name_ǀ_ǀ_)__USERID(ǀ___user-id__ǀ______ǀ_______> ǀ___________ǀ ǀ_partial-userid_ǀ ǀ_partial-element___ǀ ǀ_ipaddr____________ǀ ǀ_partial-ipaddr____ǀ _*_______________________ ǀ <_ ,________________ ǀ >__APPLNAME(_ǀ___application-name_ǀ_____ǀ_)______________________________> ǀ_partial-application-name_ǀ _*________________________ ǀ </_><_ ,________________ ǀ >__WRKSTN(_ǀ___workstation-name_ǀ_____ǀ_)________________________________> ǀ_partial-workstation-name_ǀ _*_________________________ ǀ </_><_ ,__________________ ǀ >__CONNID(_ǀ___connection-role-id_ǀ_____ǀ_)______________________________> ǀ_partial-connection-name____ǀ _*__________________________ ǀ </_><_ ,__________________ ǀ >__CORRID(_ǀ___correlation-role-id_ǀ_____ǀ_)_____________________________> ǀ_partial-correlation-name____ǀ _*____________________________ ǀ </_><_ ,__________________ ǀ >__ROLE(___ǀ___correlation-role___ǀ_______ǀ_)____________________________> ǀ_partial-correlation-role-id__ǀ ǀ_constraint block 2_ǀ constraint block 2: </_><_ ,________ <_,_____________ >__XPLAN(____plan-name_ǀ______)__XPKGLOC(___package-location_ǀ_______)____> ǀ_partial-plan-name_ǀ ǀ_partial-pkge-location_ǀ </_><_ ,____________________________ >__XPKGCOL(____package-collection-id_______ǀ__)___________________________> ǀ_partial-package-collection-id_ǀ </_><_ ,____________________________ >__XPKGPROG(____package-program-name________ǀ__)__________________________> ǀ_partial-package-program-name__ǀ </_><_ ,____________________________ >__AUTHID(______authorization-id____________ǀ__)__________________________> ǀ_partial-authorization-id______ǀ </_><_ ,_________ <_,____ >__XLOC(_____location-name_ǀ__________)__XUSERID_(______userid_ǀ______)___> ǀ_partial-location-name__ǀ ǀ_partial-userid_ǀ ǀ________________ǀ ǀ_partial _______ǀ ǀ_ipaddr_________________ǀ ǀ_partial-ipaddr_________ǀ <_ ,________________ >__XAPPNAME(_____application-name_ǀ_______)_______________________________> ǀ_partial-application-name_ǀ </_><_ ,________________ >__XWRKSTN(_____workstation-name_ǀ_______)________________________________> ǀ_partial-workstation-name_ǀ </_><_ ,_________________ >__XCONNID(_____connection-role-id_ǀ_______)______________________________> ǀ_partial-connection-name____ǀ </_><_ ,__________________ >__XCORRID(____correlation-role-id_ǀ_______)______________________________> ǀ_partial-correlation-name____ǀ </_><_ ,__________________ >__XROLE(_______correlation-role___ǀ_________)____________________________> ǀ_partial-correlation-role-id_ǀ </_></_></_>
-DISPLAY UTILITY
>>__DISPLAY UTILITY__(_ _utility-id__________ _)_________________________> ǀ_partial-utility-id*_ǀ ǀ_*___________________ǀ >___ _________________________ _________________________________________>< ǀ <_,_________ ǀ ǀ_MEMBER(__member-nameǀ_)_ǀ
DSN TSO
>>__DSN__ ______________________________________________________________> ǀ _DSN______________________ ǀ ǀ_SYSTEM(_ǀ_subsystem-name___________ǀ_)_ǀ ǀ_group-attachment-name____ǀ ǀ_subgroup-attachment-name_ǀ >__ ______________________ __ _______________ __________________________> ǀ _0_______ ǀ ǀ_TEST(integer)_ǀ ǀ_RETRY(_ǀ_integer_ǀ_)_ǀ >__ __________________ ________________________________________________>< ǀ _YES_ ǀ ǀ_ASUSER(userid)_ǀ ǀ_GROUP(_ǀ_NO__ǀ_)_ǀ
DSNC (CICS attachment facility)
>>__DSNC__ _____________ __db2-command_________________________________>< ǀ_destination_ǀ
DSNC DISCONNECT (CICS attachment facility)
>>__DSNC DISCONNECT__plan-name_________________________________________><
DSNC DISPLAY (CICS attachment facility)
>>__DSNC DISPLAY__ _PLAN__ ___________ _____________ __________________> ǀ ǀ_plan-name_ǀ ǀ ǀ_TRANSACTION__ ________________ _ǀ ǀ ǀ_transcation-id_ǀ ǀ ǀ_STATISTICS______________________ǀ >______________________________________________________________________>< ǀ_destination_ǀ
DSNC MODIFY (CICS attachment facility)
>>__DSNC MODIFY__ _DESTINATION__old__new_______________________________>< ǀ_TRANSCATION__transaction-id__integer_ǀ
DSNC STOP (CICS attachment facility)
_QUIESCE_ >>__DSNC STOP__ǀ_FORCE___ǀ______________________________________________><
DSNC START (CICS attachment facility)
>>__DSNC STRT__ ______ _________________________________________________>< ǀ_ssid_ǀ
DSNH (TSO CLIST)
>>__DSNH__INPUT(data-set-name)__________________________________________>< ǀ <_________________ ǀ ǀ___clist-parameter_ǀ_ǀ
END
>>__END_________________________________________________________________><
FREE STABILIZED DYNAMICQUERY (DSN)
>>__FREE STABLIZED DYNAMIC QUERY STBLGRP_______stabilization-group______> >_SDQSTMTID_(__statement-id__)__________________________________________> >_______________________________________________________________________> ǀ ___ALL__ ǀ ǀ _NO__ ǀ ǀ_PLANMGMTSCOPE (_ǀ________ǀ_)_ǀ ǀ__INVALID ONLY(_ǀ_____ǀ___)_ǀ____>< ǀ_INVALID_ǀ ǀ_YES_ǀ
FREE PACKAGE
>>__FREE PACKAGE___________________________________________________________> <_ ,_________________________________________________________________ >(___________________collection-id_._package-id________________________ǀ__)_> ǀǀ_location-name.ǀǀ_*___________ǀ ǀ_*________ǀ ǀ_.(_ _____________)_ǀ ǀ ǀ ǀ_version-id_ǀ ǀ ǀ ǀ_*__________ǀ ǀ ǀ_*____________________________________________________________________ǀ >___________________________________________________________________________>< ǀ _I_ ǀǀ _ALL______ _NO__ ǀ ǀ_FLAG(_ǀ_W_ǀ_)_ǀǀ_PLANMGMTSCOPE(_ǀ__________ǀ_)_____________(_ǀ_____ǀ_)_ǀ ǀ_E_ǀ ǀ_INACTIVE_ǀ ǀ ǀ _YES_ ǀ_C_ǀ ǀ_PREVIOUS_ǀ ǀ_INVALIDONLY_ǀ ǀ_ORIGINAL_ǀ
FREE PLAN
>>__FREE PLAN__(_ ___plan-name_ǀ_ _)__ _______________ ____________________>< ǀ_*_____________ǀ ǀ _I_ ǀ ǀ_FLAG(_ǀ_W_ǀ_)_ǀ ǀ_E_ǀ ǀ_C_ǀ
FREE QUERY
>>__FREE QUERY__FILTER(‘filter-name’)_____________________________________> ǀ_PACKAGE(package-name)_ǀ ǀ_QUERYID(number)_______ǀ ǀ_QUERYID(ALL)__________ǀ >>___________________,_collection-id_,__package-id_,_(_______________)____>< ǀ_location_name_ǀ ǀ_,___________ǀ ǀ_,_________ǀ ǀ_version-id_ǀ
-MODIFY DDF
>>__MODIFY DDF__ALIAS(alias-name)____ADD__________________________________> ǀ ǀ_DELETE_________________ǀ ǀ ǀ ǀ_START__________________ǀ ǀ ǀ ǀ_STOP___________________ǀ ǀ ǀ ǀ_CANCEL_________________ǀ ǀ ǀ ǀ_PORT(port-name)________ǀ ǀ ǀ ǀ_SECPORT(secport-name)__ǀ ǀ ǀ ǀ_NPORT__________________ǀ ǀ ǀ ǀ_NSECPORT_______________ǀ ǀ ǀ ǀ_IPV4(ipv4-address)_____ǀ ǀ ǀ ǀ_IPV6(ipv6-address)_____ǀ ǀ ǀ ǀ_NIPV4__________________ǀ ǀ ǀ ǀ_NIPV6__________________ǀ ǀ ǀ _BNDOPT__ ǀ ǀ__PKGREL(_ǀ_COMMITǀ_ǀ_)_________________________ǀ ǀ ǀ_BDNPOOL_ǀ ǀ ǀ_SESSIDLE_(_session-idle-limit)_________________ǀ
MODIFY IRLMPROC, ABEND
_,DUMP___ >>__MODIFY__irlmproc,ABEND_ǀ_________ǀ_____________________________________>< ǀ_,NODUMP_ǀ
MODIFY IRLMPROC, DIAG
>>__MODIFY__irlmproc,DIAG_ _,DELAY_ _______________________________________>< ǀ_,PLOCK_ǀ ǀ_,ALL___ǀ ǀ_,NONE__ǀ ǀ_,HANG__ǀ
MODIFY IRLMPROC, PURGE
>>__MODIFY__irlmproc,PURGE,db2name_________________________________________><
MODIFY IRLMPROC, SET
>>__MODIFY__irlmproc,SET__ _,DEADLOCK-nnnn_________________________________>< ǀ_,LTE=nnnn____________________ǀ ǀ_,PVT=nnnn____________________ǀ ǀ_,MVT=nnnnnU__________________ǀ ǀ_,TIMEOUT=nnnn,subsystem-name_ǀ ǀ _10__ ǀ ǀ_,TRACE=_ǀ_nnn_ǀ______________ǀ
MODIFY IRLMPROC, STATUS
_,irlmx__ >>__MODIFY__irlmproc,STATUS_ǀ________ǀ_____________________________________>< ǀ_,ALLD__ǀ ǀ_,ALLI__ǀ ǀ_,MAINT_ǀ ǀ_,STOR__ǀ ǀ_,TRACE_ǀ
-MODIFY TRACE (DB2)
_*___________ ǀ <_ ,_______ ǀ >>__MODIFY TRACE__(_ _PERFM___ _)__CLASS(_ǀ___integer_ǀ_ǀ_)________________> ǀ_ACCTG___ǀ ǀ_STAT____ǀ ǀ_AUDIT___ǀ ǀ_MONITOR_ǀ _*_______________ ǀ </_><_ ,___________ ǀ >__TNO(integer)__IFCID(_ǀ____ifcid_nbr__ǀ_ǀ_)_____________________________> ǀ_COMMENT(string)_ǀ </_>
REBIND PACKAGE
>>__REBIND PACKAGE__________________________________________________________> >>_(____________________collection-id__._package-id_ _______________________> ǀǀ_location-name._ǀ ǀ_*____________ǀ ǀ_*_________ǀǀ_.(______________)_ǀ ǀ ǀ ǀ_version-id_ǀ ǀ ǀ ǀ_*__________ǀ ǀ ǀ_*_____________________________________________________________________ǀ >_enable-block______plan-management-block_________acceleration-block________> >___________________________________________________________________________> ǀ_OWNER(auth-id)_ǀ ǀ_QUALIFIER(qualifier-name)_ǀ ǀ_CURRENTDATA(_YES__)_ǀ ǀ_NO_ǀ >___________________________________________________________________________> ǀ_DBPROTOCOL_(_DRDACBF_)_ǀǀ_DEFER(PREPARE)_________ǀ ǀ_DEGREE(_ _1___ _)_ǀ ǀ_DRDA_ǀ ǀ_NODEFER(PREPARE)_______ǀ ǀ_ANY_ǀ ǀ_DEFER(INHERITFROMPLAN)_ǀ >___________________________________________________________________________> ǀ_DYNAMICRULES(_RUN______)_ǀǀ_RELEASE(_COMMIT____)__ǀ ǀ_DECSTAT(__NO____)_ǀ ǀ_BIND___ǀ ǀ_DEALLOCATE__ǀ ǀ_YES_ǀ ǀ_DEFINE_ǀ ǀ_INVOKE_ǀ >___________________________________________________________________________> ǀ_ENCODING(_ _ASCII___)_ǀ ǀ _NO___ ǀ ǀ _I_ ǀ ǀ_EBCDIC__ǀ ǀ_EXPLAIN(_ǀ_YES__ǀ_)_ǀ ǀ_FLAG(_ǀ_W_ǀ_)_ǀ ǀ_UNICODE_ǀ ǀ_ONLY_ǀ ǀ_E_ǀ ǀ_ccsid___ǀ ǀ_C_ǀ >___________________________________________________________________________> ǀ_IMMEDWRITE_(__NO________________)_ǀ ǀ_ISOLATION(_ _RR_ _)_ǀ ǀ_YES_____________ǀ ǀ_RS_ǀ ǀ_INHERITFROMPLAN_ǀ ǀ_CS_ǀ ǀ_UR_ǀ ǀ_NC_ǀ >___________________________________________________________________________> ǀ _NO__ ǀ ǀ _NONE___ ǀ ǀ_OPTHINT_(_’hint-id’__)_ǀ ǀ_KEEPDYNAMIC(_ǀ_YES_ǀ_)_ǀ ǀ_REOPT(ǀ_ALWAYS_ǀ)_ǀ ǀ_ONCE___ǀ ǀ_AUTO___ǀ >___________________________________________________________________________> ǀ <_ ,______________ ǀ ǀ_PATHDEFAULT_ǀ ǀ _RUN__ ǀ ǀ_PATH(__ _schema-name_ ǀ_)_ǀ ǀ_VALIDATE(_ǀ_BIND_ǀ_)_ǀ ǀ_USER________ǀ >___________________________________________________________________________> ǀ _NO__ ǀǀ_GENERIC(‘string’)_ǀǀ_SWITCH_(__PREVIOUS_)_ǀ ǀ_EXTENDEDINDICATOR_ǀ_YES_ǀ_ǀ ǀ_ORIGINAL_ǀ >___________________________________________________________________________> ǀ_CONCURRENTACCESSRESOLUTION_(_CUSECURRENTLYCOMMITTED_)_ǀ ǀ_WAITFOROUTCOME_______ǀ >___________________________________________________________________________> ǀ _YES_ ǀ ǀ _YES_ ǀ ǀ_SYSTIMESENSITIVE(_ǀ_NO__ǀ_)_ǀ ǀ_BUSTIMESENSITIVE(_ǀ_NO__ǀ_)__ǀ >___________________________________________________________________________> ǀ _YES_ ǀ ǀ ǀ ǀ_ARCHIVESENSITIVE(_ǀ_NO__ǀ_)__ǀ ǀ_APPLCOMPAT(__V10R1__)_ǀ ǀ_V11R1_ǀ ǀ_V12R1_ǀ >___________________________________________________________________________> ǀ _YES_ ǀ ǀ_CONCENTRATESTMT(_ǀ_NO__ǀ_)_ǀ enable-block: >>__ ______________________________________________________________________>< ǀ _ENABLE(*)________________________ ǀ ǀ ǀ <_,__________ ǀ <____________________________ ǀ ǀ ǀ_ _ENABLE__ __(___ _BATCH____ ǀ_)_ǀ_______________________________ǀ_ǀ ǀ_DISABLE_ǀ ǀ_DLIBATCH_ǀ ǀ <_,_____________ ǀ ǀ_DB2CALL__ǀ ǀ_DLIBATCH(_connection-name_ǀ_)_ǀ ǀ_CICS_____ǀ ǀ <_,______ ǀ ǀ_IMS______ǀ ǀ_CICS(___applid_ǀ_)____________ǀ ǀ_IMSBMP___ǀ ǀ <_,_____ ǀ ǀ_IMSMPP___ǀ ǀ_IMSBMP(___imsid_ǀ_)___________ǀ ǀ_REMOTE___ǀ ǀ <_,_____ ǀ ǀ_RRSAF____ǀ ǀ_IMSMPP(___imsid_ǀ_)___________ǀ ǀ <_,________________ ǀ ǀ_REMOTE(___location-name_ _ǀ_)_ǀ ǀ___ǀ plan-management-block: >____________________________________________________________________________> ǀ ǀ ǀ _YES__ ǀ ǀ_PLANMGMT_(__BASIC______)_ǀ ǀ_APRETAINDUP_ǀ_NO__ǀ_ǀ ǀ_EXTENDED__ǀ ǀ_OFF_______ǀ >____________________________________________________________________________> ǀ _NONE__ ǀ ǀ _NONE__ ǀǀ _CURRENT__ ǀ ǀ_AREUSE_ǀ_ERROR_ǀ_ǀ ǀ_ACOMPARE_ǀ_WARN__ǀ_ǀǀ_APREUSESOURCE_(ǀ__________ǀ_ǀ ǀ_WARN__ǀ ǀ_ERROR_ǀ ǀ_ORIGINAL_ǀ acceleration-block: >____________________________________________________________________________> ǀ_GETACCELARCHIVE_(_________)_ǀǀ_QUERYACCELERATION_(_____________________ǀ_ǀ ǀ_NO__ǀ ǀ_NONE_______________ǀ ǀ_YES_ǀ ǀ_ENABLE_____________ǀ ǀ_ENABLEWITHFAILBACK_ǀ ǀ_ELIGIBLE___________ǀ ǀ_ALLǀ_______________ǀ </_>
REBIND PLAN
<_ ,_________ >>__REBIND PLAN__(_ ___plan-name_ǀ_ _)_______________________________________> ǀ_*_____________ǀ ǀ_OWNER(authorization-id)_ǀ >__ _________________________________________________________________________> ǀ_QUALIFIER (qualifier-name)_ǀ >____________________________________________________________________________> ǀ </_><_ ,_______________________________________________________ ǀ ǀ_PKLIST(___ ________________ __ _collection-id_ __ _.package-id_ _ǀ_)_ǀ ǀ ǀ_location-name._ǀ ǀ_*_____________ǀ ǀ_.*__________ǀ ǀ ǀ ǀ_*______________ǀ ǀ ǀ_NOPKLIST_____________________________________________________________ǀ >____________________________________________________________________________> ǀ_NODEFER(PREPARE)_ǀǀ_ACQUIRE(_ _USE______ )ǀǀ_CACHESIZE(decimal-value_ǀ ǀ_DEFER(PREPARE)___ǀ ǀ_ALLOCATE_ǀ >____________________________________________________________________________> ǀ_CURRENTDATA(_ _NO__ _)_ǀ ǀ_CURRENTSERVER(location-name)_ǀ ǀ_YES_ǀ >______________________________________ _____________________________________> ǀ_DBPROTOCOL__(__ _DRDA____ __)_ǀ ǀ_DEGREE(_ _1___ _)_ǀ ǀ_ANY_ǀ >____________________________________________________________________________> ǀ_DISCONNECT(_ _EXPLICIT____ _)_ǀ ǀ_DYNAMICRULES(_ _RUN__ _)_ǀ ǀ_AUTOMATIC___ǀ ǀ_BIND_ǀ ǀ_CONDITIONAL_ǀ >__ _________________________________________________________________________> ǀ_ENCODING(_ _ASCII___ _)_ǀ ǀ_EXPLAIN(_ _NO__ _)_ǀ ǀ _I_ ǀ ǀ_EBCDIC__ǀ ǀ_YES_ǀ ǀ_FLAG(_ǀ_W_ǀ_)_ǀ ǀ_UNICODE_ǀ ǀ_E_ǀ ǀ_ccsid___ǀ ǀ_C_ǀ >____________________________________________________________________________> ǀ_IMMEDIATE(_ _NO__ _)_ǀǀ_ISOLATION(_ _RR_ _)_ǀǀ _NO__ ǀ ǀ_YES_ǀ ǀ_RS_ǀ ǀ_KEEPDYNAMIC(_ǀ_YES_ǀ_)_ǀ ǀ_CS_ǀ ǀ_UR_ǀ >____________________________________________________________________________> ǀ _NONE___ ǀǀ_OPTHINT_(__’hint-id’__)_ǀǀ </_><_ ,_____________ ǀ ǀ_REOPT(ǀ_ALWAYS_ǀ_)ǀ ǀ_PATH(__schema-name__ǀ_)ǀ ǀ_ONCE___ǀ ǀ___USER_____ ǀ ǀ_AUTO___ǀ >____________________________________________________________________________> ǀ ǀ ǀ_RELEASE(_ _COMMIT_____ _)_ǀ ǀ_SQLRULES(_ _DB2_ _)_ǀ ǀ_PATHDEFAULT_ǀ ǀ_DEALLOCATE_ǀ ǀ_STD_ǀ >___________________________________________________________________________> ǀ_VALIDATE(_ _RUN__ _)_ǀ ǀ _DISABLE_ ǀ ǀ_BIND_ǀ ǀ_PROGGAUTH(_ǀ_ENABLE__ǀ_)_ǀ >___________________________________________________________________________> ǀ_CONCURRENTACCESSRESOLUTION_(_USECURRENTLYCOMMITTED_)_ǀ ǀ_WAITFOROUTCOME______ǀ enable-block: >>__ _______________________________________________________________________>< ǀ _ENABLE(*)________________________ ǀ ǀ ǀ <_,__________ ǀ <____________________________ ǀ ǀ_ǀ_ _ENABLE__ __(___ _BATCH____ ǀ_)_ǀ_______________________________ǀ_ǀ ǀ_DISABLE_ǀ ǀ_DLIBATCH_ǀ ǀ <_,_____________ ǀ ǀ_DB2CALL__ǀ ǀ_DLIBATCH(_connection-name_ǀ_)_ǀ ǀ_CICS_____ǀ ǀ <_,______ ǀ ǀ_IMS______ǀ ǀ_CICS(___applid_ǀ_)____________ǀ ǀ_IMSBMP___ǀ ǀ <_,_____ ǀ ǀ_IMSMPP___ǀ ǀ_IMSBMP(___imsid_ǀ_)___________ǀ ǀ_RRSAF____ǀ ǀ <_,_____ ǀ ǀ_IMSMPP(___imsid_ǀ_)___________ǀ
REBIND TRIGGER PACKAGE
>>_REBIND TRIGGER PACKAGE(___________________collection-id_._package-id_)_> ǀ_location-name._ǀ ǀ_*__________ǀ ǀ_*________ǀ >__________________________________________________________________________> ǀ_CURRENTDATA(_YES__)_ǀǀ_DECSTAT(_NO__)_ǀ ǀ_EXPLAIN(__YES___)_ǀ ǀ_NO_ǀ ǀ_YES__ǀ ǀ_NO___ǀ ǀ_ONLY_ǀ >__________________________________________________________________________> ǀ_PLANMGMT(__BASIC_____)_ǀ ǀ _YES_ ǀ ǀ _I_ ǀ ǀ_EXTENDED_ǀ ǀ_APRETAINDUP(_ǀ_NO__ǀ_ǀ ǀ_FLAG(_ǀ_W_ǀ_)ǀ ǀ_OFF______ǀ ǀ_WARN_ ǀ_E_ǀ ǀ_C_ǀ >__________________________________________________________________________> ǀ_IMMEDWRITE(_ _NO__ _)ǀ ǀ_ISOLATION(__RR__)_ǀǀ_RELEASE(___COMMIT_____)_ǀ ǀ_YES_ǀ ǀ_RS_ǀ ǀ_DEALLOCATE_ǀ ǀ_CS_ǀ ǀ_UR_ǀ ǀ_NC_ǀ >__________________________________________________________________________> ǀ_CONCURRENTACCESSRESOLUTION_(_USECURRENTLYCOMMITTED_)_ǀ ǀ_WAITFOROUTCOME______ǀ >__________________________________________________________________________> ǀ ǀ ǀ _NONE___ ǀ ǀ_PLANMGMT_(__BASIC______)_ǀ ǀ__APRETAINDUP_ǀ_WARN___ǀ_ǀ ǀ_EXTENDED__ǀ ǀ_ERROR__ǀ ǀ_OFF_______ǀ >___________________________________________________________________________> ǀ _NONE__ ǀ ǀ _NONE__ ǀǀ _CURRENT__ ǀ ǀ_AREUSE_ǀ_ERROR_ǀ_ǀ ǀ_ACOMPARE_ǀ_WARN__ǀ_ǀǀ_APREUSESOURCE_(ǀ__________ǀ_ǀ ǀ_WARN__ǀ ǀ_ERROR_ǀ ǀ_PREVIOUS_ǀ ǀ_ORIGINAL_ǀ >___________________________________________________________________________>< ǀ_SWITCH_(__PREVIOUS__)_ǀ ǀ_ORIGINAL_ǀ >___________________________________________________________________________> ǀ _YES_ ǀ ǀ _YES_ ǀ ǀ_SYSTIMESENSITIVE(_ǀ_NO__ǀ_)_ǀ ǀ_BUSTIMESENSITIVE(_ǀ_NO__ǀ_)__ǀ >___________________________________________________________________________> ǀ _YES_ ǀ ǀ ǀ ǀ_ARCHIVESENSITIVE(_ǀ_NO__ǀ_)__ǀ ǀ_APPLCOMPAT(__V10R1__)_ǀ ǀ_V11R1_ǀ ǀ_V12R1_ǀ
-RECOVER BSDS
>>__RECOVER BSDS____________________________________________________________><
RECOVER INDOUBT
>>__RECOVER INDOUBT__ ___________________ __ACTION(_ _COMMIT_ _)__________> ǀ_(connection-name)_ǀ ǀ_ABORT__ǀ <_ ,______________ >__ _ID(_ ___correlation-id_ǀ_ _)_ _____________________________________>< ǀ ǀ_*__________________ǀ ǀ ǀ <_,__________ ǀ ǀ_NID(___network-id_ǀ_)________ǀ ǀ <_,_______ ǀ ǀ_LUWID(__ _luwid_ ǀ_)_________ǀ ǀ_token¬_ǀ
-RECOVER POSTPONED
>>__RECOVER POSTPONED__ ________ _________________________________________>< ǀ_CANCEL_ǀ
-REFRESH DB2, EARLY
>>__REFRESH DB2, EARLY____________________________________________________><
-RESET GENERICLU
<_ ,________________ >>__RESET GENERICLU__ _(___ _luname_______ _ǀ_)_ _________________________>< ǀ ǀ_netid.luname_ǀ ǀ ǀ_(*)______________________ǀ
-RESET INDOUBT
>>__RESET INDOUBT__________________________________________________________> <_ ,______ >__ _LUNAME(_ ___luname_ǀ_ _)_ _______ ___________________________________>< ǀ ǀ_*__________ǀ ǀ_FORCE_ǀ ǀ ǀ <_,_____________ ǀ ǀ_LOCATION(___location-name_ǀ_)_____________________ǀ ǀ <_,____________________ ǀ ǀ_IPADDR(_ _______ipaddr..port_____ǀ_ _)_ _______ __ǀ ǀ ǀ_*________________________ǀ ǀ_FORCE_ǀ ǀ ǀ <_,_______ ǀ ǀ_LUWID(__ _luwid_ ǀ_)_ _________________________ __ǀ ǀ_token_ǀ ǀ_LOCATION(location-name)_ǀ
RUN
>>__RUN__ _PROGRAM(program-name)__ ________________ _ _____________________> ǀ ǀ_PLAN(plan-name_ǀ ǀ ǀ_CP__PLAN(plan-name)_______________________ǀ >__ _______________________ __ _________________________ __________________>< ǀ_LIBRARY(library-name)_ǀ ǀ_PARMS(parameter-string)_ǀ
-SET ARCHIVE
>>__SET ARCHIVE__ __ __________ __ _______________________________________>< ǀ ǀ_COUNT__(__integer__)_ǀǀ_TIME(_ _minutes_ __)_ǀ ǀ ǀ ǀ ǀ_,seconds_ǀ ǀ ǀ ǀ ǀ_,seconds____________ǀ ǀ ǀ ǀ_1440________________ǀ ǀ ǀ ǀ_NOLIMIT_____________ǀ ǀ ǀ_DEFAULT____________________________________________ǀ
-SET LOG
>>__SET LOG_______________LOGLOAD(integer)_________________________________> ǀ_SINGLE_ǀ ǀ ǀ_CHKTIME(integer)_ǀ ǀ ǀ_BOTH___ǀ ǀ_CHKTIME(integer)___________________________ǀ ǀ ǀ_LOGLOAD(integer)_ǀ ǀ ǀ_SUSPEND____________________________________ǀ ǀ_RESUME_____________________________________ǀ ǀ_NEWLOG_(_data-set-name_)_COPY_(_log-copy_)_ǀ
-SET SYSPARM
>>__SET SYSPARM__ _LOAD(_ _DSNZPARM_________ _)_ ________________________>< ǀ ǀ_load-module-name_ǀ ǀ ǀ_RELOAD_______________________ǀ ǀ_STARTUP______________________ǀ
SPUFI
>>__SPUFI________________________________________________________________><
/SSR
>>__/SSR__subsystem-command______________________________________________><
-START ACCEL
_(_*_)______________________________ ǀ <_ ,_____________ ǀ >>__START ACCEL_ǀ_(_ ___accelerator-name_ǀ______ _)__ǀ___________________> >________________________________________________________________________> ǀ _*_____________ ǀ ǀ _LOCAL_ ǀ ǀ_ACCESS_(_ǀ_MAINT_________ǀ__)_ǀ ǀ_SCOPE_(_ǀ_GROUP_ǀ_)_ǀ ǀ_EXPLAINNLY____ǀ >________________________________________________________________________>< ǀ <_,__________ ǀ ǀ_MEMBER(_____member-name__ǀ__)_ǀ
/START IMS
>>__/START_______________________________________________________________>< ǀ ǀ ǀ <_,_________________ ǀ ǀ ǀ ǀ ǀ_SUBSYS __subsystem-name_ǀ_ǀ ǀ_SUBSYS__ALL_______________ǀ
-START DATABASE
<_ ,_____________ >>__START DATABASE__(_ ___database-name_ǀ_____ _)________________________> ǀ_*_____________________ǀ ǀ_dbname1:dbname2_______ǀ ǀ_dbname*_______________ǀ ǀ_*dbname_______________ǀ ǀ_*dbname*______________ǀ ǀ_*dbstring1*dbstring2*_ǀ > _______________________________________________________________________> ǀ </_><_ ,________ ǀ ǀ_SPACENAM(_ ____space-name_ǀ________)________ǀ ǀ_*___________________________ǀ ǀ_spacename1:spacename2_______ǀ ǀ_spacename*__________________ǀ ǀ_*spacename__________________ǀ ǀ_*spacename*_________________ǀ ǀ_*spacestring1*spacestring2*_ǀ > _______________________________________________________________________> ǀ </_><_ ,____________ ǀ ǀ_CLONE_ǀ ǀ_PART(_ ___integer______ǀ____)_ǀ ǀ_integer1:integer2__ǀ __RW____ >_____ACCESS(_ǀ_RO____ǀ_)_______________________________________________>< ǀ_UT____ǀ ǀ_RREPL_ǀ ǀ_FORCE_ǀ
-START DB2
>>__START DB2__ _________________________________________________________> ǀ ǀ ǀ _DSNDECP___ ǀ ǀ_PARM(__module name__)_ǀ ǀ_DECP(_ǀ___________ǀ_)_ǀ ǀ_decp-name_ǀ >__ _____________________ __ __________________ ________________________> ǀ _*_____ ǀ ǀ _NO_________ ǀ ǀ_ACCESS(_ǀ_MAINT_ǀ_)_ǀ ǀ_LIGHT(_ǀ_YES________ǀ_)_ǀ ǀ_NOINDOUBTS_ǀ ǀ_CASTOUT____ǀ >__ ________________________ __ ________________________ _______________> ǀ_MSTR(jcl-substitution)_ǀ ǀ_DBM1(jcl-substitution)_ǀ >__ ________________________ ___________________________________________>< ǀ_DIST(jcl-substitution)_ǀ
-START DDF
>>__START DDF___________________________________________________________><
-START DYNQUERYCAPTURE
>>__START DYNQUERYCAPTURE__STBLGRP(stabilization-group)_________________> ǀ ______________________________________cache-snap_spec_______ ǀ ǀ _2_______ ǀ ǀ ǀ ǀ_ǀTHRESHOLD(_ǀ_integer_ǀ_)_ǀ ǀ ǀ_______________________________________________________________ǀ_____> ǀ_STMTID_(_integer_)____________________________________________ǀ ǀ_STMTTOKEN_(_string_constant_)_________________________________ǀ Cache-snap-spec: >_______________________________________________________________________> ǀ _*_____ ǀǀ _NO___ ǀǀ _LOCAL_ ǀ ǀ_CURSGLID(_ǀ_SQLID_ǀ_)_ǀǀ_MONITOR(_ǀ_YES__ǀ_)_ǀǀ_SCOPE_(_ǀ_GROUP_ǀ_)ǀ
-START FUNCTION SPECIFIC
>>__START FUNCTION SPECIFIC_____________________________________________> _(*.*)_____________________________________ >__ǀ___________________________________________ǀ________________________> ǀ <_ ,_________________________________ ǀ ǀ_(___ _schema.specific-function-name_ _ǀ_)_ǀ ǀ_schema.partial-name*__________ǀ ǀ >__ ____________________________________________________________________>< ǀ _LOCAL_ ǀ ǀ_SCOPE__(_ǀ_______ǀ_)_ǀ ǀ_GROUP_ǀ
-START admtproc
>>__START__irlmproc,__ _________________________________________________>< ǀ_TRACE=__ON______ǀ ǀ_OFF_ǀ
-START irlmproc
<_ ,__________________________ >>__START__irlmproc,__ ___________________________ǀ_____________________>< ǀ_DEADLOK=’iiii,kkkk’_______ǀ ǀ_IRLMGRP=’irlm-group-name__ǀ ǀ_IRLMID=n__________________ǀ ǀ_IRLMNM=irlmname¬___________ǀ ǀ_LOCKTABL=irlmltnm_________ǀ ǀ_MAXCSA=nnn________________ǀ ǀ_MAXUSRS=nnn_______________ǀ ǀ_PC=_ _YES_ _______________ǀ ǀ ǀ_NO__ǀ ǀ ǀ_PGPROT=_ _YES_ ___________ǀ ǀ ǀ_NO__ǀ ǀ ǀ_SCOPE=_ _LOCAL____ _______ǀ ǀ ǀ_GLOBAL___ǀ ǀ ǀ ǀ_NODISCON_ǀ ǀ ǀ_TRACE=_ _NO__ ____________ǀ ǀ_YES_ǀ
-START PROCEDURE
_(*.*)_____________________________ >>__START PROCEDURE__ǀ___________________________________ǀ_______________> ǀ <_ ,_________________________ ǀ ǀ_(___ _schema.procedure-name_ _ǀ_)_ǀ ǀ_schema.partial-name*__ǀ ǀ_procedure-name________ǀ ǀ_partial-name*_________ǀ >__ ______________________ ______________________________________________>< ǀ _LOCAL_ ǀ ǀ_SCOPE__(_ǀ_______ǀ_)_ǀ ǀ_GROUP_ǀ
-START PROFILE
>>__START PROFILE________________________________________________________><
-START RLIMIT
>>__START RLIMIT__ _______ ______________________________________________>< ǀ_ID=id_ǀ
-START TRACE
>>__START TRACE__(_ _PERFM___ _)__ ______________________ _______________> ǀ_ACCTG___ǀ ǀ _LOCAL_ ǀ ǀ_STAT____ǀ ǀ_SCOPE__(_ǀ_______ǀ_)_ǀ ǀ_AUDIT___ǀ ǀ_GROUP_ǀ ǀ_MONITOR_ǀ >__ ___________________ __ __________________ ___________________________> ǀ_destination block_ǀ ǀ_constraint block_ǀ ǀ_RMID_ǀ >__ _________________ ___________________________________________________>< ǀ_COMMENT(string)_ǀ ǀ_filtering block_ǀ destination block: <_,_____ >__DEST(__ _GTF_ ǀ_)_____________________________________________________> ǀ_SMF_ǀ ǀ_SRV_ǀ ǀ_OPn¬_ǀ ǀ_OPX_ǀ constraint block: _*_________________ _*__________________________ ǀ <_ ,_________ ǀ ǀ <_,______________________ ǀ >__PLAN(_ǀ___plan-name_ǀ_____ǀ_)_PKGLOC(_ǀ__package-location_______ǀ_ǀ_)__> ǀ_partial-plan-name_ǀ ǀ_partial-package-location_ǀ </_><_ ,__________________________ >___PKGCOL(____package-collection-id_______ǀ__)___________________________> ǀ_partial-package-collection-id_ǀ _*_____________________________ ǀ </_><_ ,________________________ ǀ >__PKGPROG(_ǀ__package-program-name______ǀ_ǀ_)____________________________> ǀ_partial-package-program-name_ǀ _*_____________ ǀ </_><_ ,_______ ǀ >__AUTHID(_ǀ___auth-id_ǀ____ǀ_)___________________________________________> ǀ_partial-authid_ǀ _*___________ _*___________ ǀ </_><_ ,_______ ǀ ǀ <_,_______ ǀ >__CLASS(_ǀ___integer_ǀ_ǀ_)__TNO(_ǀ___integer_ǀ_ǀ_)_______________________> _*_________________ ǀ </_><_ ,_____________ ǀ >__LOCATION(_ǀ___location-name_ǀ_ǀ_)______________________________________> ǀ___________ǀ ǀ_partial-element___ǀ ǀ_ipaddr____________ǀ ǀ_partial-ipaddr____ǀ _*_____________ ǀ <_ ,_______ ǀ >__USERID(_ǀ___user-id_ǀ____ǀ_)_________________________________________> ǀ_partial-userid_ǀ _*_______________________ ǀ </_><_ ,________________ ǀ >__APPLNAME(_ǀ___application-name_ǀ_____ǀ_)_____________________________> ǀ_partial-application-name_ǀ _*________________________ ǀ </_><_ ,_________________ ǀ >__CONNID(_ǀ___connection-role-id_ǀ____ǀ_)______________________________> ǀ_partial-connection-name___ǀ _*_________________________ ǀ </_><_ ,__________________ ǀ >__CORRID(_ǀ___correlation-role-id_ǀ____ǀ_)_____________________________> ǀ_partial-correlation-name___ǀ _*____________________________ ǀ </_><_ ,__________________ ǀ >__ROLE(___ǀ___correlation-role___ǀ_______ǀ_)___________________________> ǀ_partial-correlation-role-id__ǀ _*__________ ǀ </_><_ ,______ ǀ _*_______ >__IFCID(_ǀ___ifcid__ǀ_ǀ_)_BUFSIZE_(_ǀ_k_bytes_ǀ________________________> </_><_ ,____________ <_,__________ >__TDATA(__ _CORRELATION_ ǀ_)__AUDTPLCY(_ǀ_policy-name_ǀ_ASID(x’dddd’)___> ǀ_TRACE________ǀ ǀ_CPU__________ǀ ǀ_DISTRIBUTED__ǀ filtering block: </_><_ ,________ <_,____________ >__XPLAN(____plan-name_ǀ______)__XPKGLOC(___package-location_ǀ_______)____> ǀ_partial-plan-name_ǀ ǀ_partial-pkge-location_ǀ </_><_ ,____________________________ >__XPKGCOL(____package-collection-id_______ǀ__)___________________________> ǀ_partial-package-collection-id_ǀ </_><_ ,____________________________ >__XPKGPROG(____package-program-name________ǀ__)__________________________> ǀ_partial-package-program-name__ǀ </_><_ ,____________________________ >__XAUTHID(_____authorization-id____________ǀ__)__________________________> ǀ_partial-authorization-id______ǀ </_><_ ,_________ _<_,_____ >__XCLOC(____location-name_ǀ___________)__XUSERID_(_____userid_ǀ______)____> ǀ_partial-location-name__ǀ ǀ_partial-userid_ǀ ǀ________________ǀ ǀ_partial _______ǀ ǀ_ipaddr_________________ǀ ǀ_partial-ipaddr_________ǀ <_ ,________________ >__XAPPNAME(_____application-name_ǀ_______)________________________________> ǀ_partial-application-name_ǀ </_><_ ,________________ >__XWRKSTN(_____workstation-name_ǀ_______)_________________________________> ǀ_partial-workstation-name_ǀ </_><_ ,__________________ >__XCONNID(_____connection-role-id_ǀ_______)_______________________________> ǀ_partial-connection-name____ǀ </_><_ ,___________________ >__XCORRID(_____correlation-role-id_ǀ______)_______________________________> ǀ_partial-correlation-name____ǀ </_><_ ,__________________ >__XROLE(_______correlation-role___ǀ_________)_____________________________> ǀ_partial-correlation-role-id_ǀ </_></_></_>
-STOP ACCEL
_(_*_)______________________________ ǀ <_ ,_____________ ǀ >>__STOP ACCEL__ǀ_(_ ___accelerator-name_ǀ______ _)__ǀ____________________> >_________________________________________________________________________> ǀ _QUIESCE_______ ǀ ǀ _LOCAL_ ǀ ǀ_MODE_(_ǀ_FORCE_________ǀ__)_ǀ ǀ_SCOPE_(_ǀ_GROUP_ǀ_)_ǀ >_________________________________________________________________________> ǀ_MEMBER(member-name)_ǀ </_>
/STOP IMS
<_ ,______________ >>__STOP__ _SUBSYS____subsystem-name_ǀ_ __________________________________>< ǀ_SUBSYS__ALL________________ǀ
STOP admtproc
>>__STOP_____admtproc_____________________________________________________><
-STOP DATABASE
<_ ,_____________ >>__STOP DATABASE_(___database-name_ǀ________ _)__________________________> ǀ_*_____________________ǀ ǀ_dbname1:dbname2_______ǀ ǀ_dbname*_______________ǀ ǀ_*dbname_______________ǀ ǀ_*dbname*______________ǀ ǀ_*dbstring1*dbstring2*_ǀ >_______________________________________________________________________)___> ǀ </_><_ ,__________ ǀ ǀ_SPACENAM(_ ___space-name_ǀ______________ _)________________________ǀ ǀ_*___________________________ǀ ǀ <_,_______ ǀ ǀ_spacename1:spacename2_______ǀ ǀ_PART(___integer__ǀ_)_ǀ ǀ_spacename*__________________ǀ ǀ_int1:int2_ǀ ǀ_*spacename__________________ǀ ǀ_*spacename*_________________ǀ ǀ_*spacestring1*spacestring2*_ǀ >__________________________________________________________________________>< ǀ_CLONE_ǀ ǀ_AT(COMMIT)_ǀ
-STOP DB2
_MODE(QUIESCE)_ _CASTOUT(YES)_ >>__STOP DB2__ǀ_______________ǀ__ǀ______________ǀ_________________________>< ǀ_MODE(FORCE)___ǀ ǀ_CASTOUT(NO)__ǀ
-STOP DDF
_MODE(QUIESCE)________________ >>__STOP DDF__ǀ______________________________ǀ____________________________>< ǀ_MODE(FORCE)__________________ǀ ǀ_MODE(SUSPEND)_ _CANCEL(n)_ __ǀ ǀ_WAIT(n)___ǀ
-STOP DYNQUERYCAPTURE
>>__DISPLAY DYNQUERYCAPTURE__ ____________________________________________> ǀ _(*)_____________________ ǀ ǀ ǀ <_ ,_______________ ǀ ǀ ǀ_CNO(ǀ_(___integer_______ _ǀ_)_ǀ_ǀ >_________________________________________________________________________>< ǀ _LOCAL_ ǀ ǀ_SCOPE__(_ǀ_GROUP_ǀ_)_ǀ
-STOP FUNCTION SPECIFIC
>>__STOP FUNCTION SPECIFIC________________________________________________> _(*.*)_____________________________________ >__ǀ___________________________________________ǀ__________________________> ǀ <_ ,_________________________________ ǀ ǀ_(___ _schema.specific-function-name_ _ǀ_)_ǀ ǀ_schema.partial-name*__________ǀ >________________________________________________________________________>< ǀ _QUEUE__ ǀ ǀ _LOCAL_ ǀ ǀ_ACTION__(_ǀ_REJECT_ǀ_)_ǀ ǀ_SCOPE__(_ǀ_GROUP_ǀ_)_ǀ
STOP irlmproc
>>__STOP__irlmproc_______________________________________________________>
-STOP PROCEDURE
_(*.*)_____________________________ >>__STOP PROCEDURE__ǀ___________________________________ǀ________________> ǀ <_ ,_________________________ ǀ ǀ_(___ _schema.procedure-name_ _ǀ_)_ǀ ǀ_schema.partial-name*__ǀ ǀ_procedure-name________ǀ ǀ_partial-name*_________ǀ >__ ________________________ __ _____________________ ___________________>< ǀ _QUEUE__ ǀ ǀ _LOCAL_ ǀ ǀ_ACTION__(_ǀ_REJECT_ǀ_)_ǀ ǀ_SCOPE__(_ǀ_______ǀ_)_ǀ ǀ_GROUP_ǀ
-STOP PROFILE
>>__STOP PROFILE________________________________________________________><
-STOP RLIMIT
>>__STOP RLIMIT_________________________________________________________><
-STOP TRACE
>>__STOP TRACE__(_ _PERFM___ _)____________________________ASID(x’dddd’)___> ǀ_ACCTG___ǀ ǀ _LOCAL_ ǀ ǀ_STAT____ǀ ǀ_SCOPE__(_ǀ_______ǀ_)_ǀ ǀ_AUDIT___ǀ ǀ_GROUP_ǀ ǀ_MONITOR_ǀ ǀ_*_______ǀ <_ ,________ >___DEST____________ǀ_____________________________________________________> ǀ_GTF_____ǀ ǀ_constraint-block_ǀ ǀ_filtering-block_ǀ ǀ_SMF_____ǀ ǀ_SRV_____ǀ ǀ_OPn_____ǀ >_________________________________________________________________________> ǀ_RMID_ǀ ǀ_COMMENT(string)_ǀ constraint block: _*_________________ _*__________________________ ǀ </_><_ ,_________ ǀ ǀ <_,_____________________ ǀ >__PLAN(_ǀ___plan-name_ǀ_____ǀ_)_PKGLOC(_ǀ__package-location_______ǀ_ǀ_)____> ǀ_partial-plan-name_ǀ ǀ_partial-package-location_ǀ </_><_ ,___________________________ >___PKGCOL(____package-collection-id_______ǀ__)_____________________________> ǀ_partial-package-collection-id_ǀ _*____________________________ ǀ </_><_ ,________________________ ǀ >__PKGPROG(_ǀ__package-program-name______ǀ_ǀ_)______________________________> ǀ_partial-package-program-name_ǀ _*______________ ǀ </_><_ ,_______ ǀ >__AUTHID(_ǀ___auth-id_ǀ____ǀ_)___________________________________________> ǀ_partial-authid_ǀ _*___________ _*___________ ǀ </_><_ ,_______ ǀ ǀ <_,_______ ǀ >__CLASS(_ǀ___integer_ǀ_ǀ_)__TNO(_ǀ___integer_ǀ_ǀ_)_______________________> _*_________________ ǀ </_><_ ,_____________ ǀ >__LOCATION(_ǀ___location-name_ǀ_ǀ_)______________________________________> ǀ___________ǀ ǀ_partial-element___ǀ ǀ_ipaddr____________ǀ ǀ_partial-ipaddr____ǀ _*_____________ ǀ <_ ,_______ ǀ >__USERID(_ǀ___user-id_ǀ____ǀ_)___________________________________________> ǀ_partial-userid_ǀ _*________________________ ǀ </_><_ ,________________ ǀ >__APPLNAME(_ǀ___application-name_ǀ_____ǀ_)_______________________________> ǀ_partial-application-name_ǀ _*________________________ ǀ </_><_ ,________________ ǀ >__WRKSTN(_ǀ___workstation-name_ǀ_____ǀ_)_________________________________> ǀ_partial-workstation-name_ǀ _*_________________________ ǀ </_><_ ,__________________ ǀ >__CONNID(_ǀ___connection-role-id_ǀ_____ǀ_)_______________________________> ǀ_partial-connection-name____ǀ _*__________________________ ǀ </_><_ ,__________________ ǀ >__CORRID(_ǀ___correlation-role-id_ǀ_____ǀ_)______________________________> ǀ_partial-correlation-name____ǀ _*____________________________ ǀ </_><_ ,__________________ ǀ >__ROLE(___ǀ___correlation-role___ǀ_______ǀ_)_____________________________> ǀ_partial-correlation-role-id__ǀ _*_______________ ǀ </_><_ ,___________ ǀ >__AUDTPLCY(_ǀ___policy-name_ǀ_ǀ__________________________________________> filtering block: </_><_ ,________ <_,_____________ >__XPLAN(____plan-name_ǀ______)__XPKGLOC(___package-location_ǀ_______)____> ǀ_partial-plan-name_ǀ ǀ_partial-pkge-location_ǀ </_><_ ,____________________________ >__XPKGCOL(____package-collection-id_______ǀ__)___________________________> ǀ_partial-package-collection-id_ǀ </_><_ ,____________________________ >__XPKGPROG(____package-program-name________ǀ__)__________________________> ǀ_partial-package-program-name__ǀ </_><_ ,____________________________ >__XAUTHID(_____authorization-id____________ǀ__)__________________________> ǀ_partial-authorization-id______ǀ </_><_ ,_________ <_,_____ >__XCLOC(____location-name_ǀ___________)__XUSERID_(_____userid_ǀ______)____> ǀ_partial-location-name__ǀ ǀ_partial-userid_ǀ ǀ________________ǀ ǀ_partial _______ǀ ǀ_ipaddr_________________ǀ ǀ_partial-ipaddr_________ǀ <_ ,________________ >__XAPPNAME(_____application-name_ǀ_______)_______________________________> ǀ_partial-application-name_ǀ </_><_ ,________________ >__XWRKSTN(_____workstation-name_ǀ_______)________________________________> ǀ_partial-workstation-name_ǀ </_><_ ,__________________ >__XCONNID(_____connection-role-id_ǀ_______)______________________________> ǀ_partial-connection-name____ǀ </_><_ ,___________________ >__XCORRID(_____correlation-role-id_ǀ______)______________________________> ǀ_partial-correlation-name___ǀ </_><_ ,__________________ >__XROLE(________correlation-role___ǀ________)____________________________> ǀ_partial-correlation-role-id_ǀ </_></_></_>
-TERM UTILITY
>>__TERM UTILITY__(_ _utility-id__________ _)_____________________________> ǀ_partial-utility-id*_ǀ ǀ_*___________________ǀ
TRACE IMS
>>__/TRACE__SET_ _ON__ ___ ______________________________________________> ǀ_OFF_ǀ ǀ _ALL__ ǀ ǀ_TABLE_ǀ_SUBS_ǀ__ǀ >__ ___________________ ________________________________________________>< ǀ _NOLOG_ ǀ ǀ_OPTION_ǀ_LOG___ǀ__ǀ
TRACE CT
_,WRAP___ >>__TRACE CT,____ _WTRSTART-parmlibmem_ǀ_________ǀ______________________>< ǀ ǀ_,NOWRAP_ǀ ǀ ǀ_WTRSTOP=jobname________________________ǀ ǀ_ON,__COMP=irlmnm__ __________________ _ǀ ǀ ǀ_,SUB=(_ _DBM_ _)_ǀ ǀ ǀ ǀ_EXP_ǀ ǀ ǀ ǀ_INT_ǀ ǀ ǀ ǀ_SLM_ǀ ǀ ǀ ǀ_XCF_ǀ ǀ ǀ ǀ_XIT_ǀ ǀ ǀ_OFF____________________________________ǀ
</_>
</_>
</_>
</_>
</_>
</_>
</_>
</_>
</_>
</_>
</_>
</_>
</_>
</_>
</_>
</_>
</_>
</_>
</_>
</_>
</_>
</_>
</_>
</_>
</_>
</_>
Disclaimer: This Db2® 12 for z/OS Reference Guide was developed to help users in their daily activities in administrating and programming in Db2 for z/OS. There are no guarantees expressed or implied with the contents in this guide. We want to provide a quality and useful reference for users. Please notify us of any mistakes or errors in this reference guide at blogs@bmc.com. Db2 is a registered trademark of the IBM Corporation.
