Mainframe Blog

Commands in Db2 12

11 minute read
Stephen Watts

-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.

Order now! Get your free Db2 collateral from BMC!

Get your free Reference Guide and Catalog Tables Poster for z/OS from BMC. This collateral helps Db2 for z/OS users with daily activities in administering and programming for Db2 on z/OS.


These postings are my own and do not necessarily represent BMC's position, strategies, or opinion.

See an error or have a suggestion? Please let us know by emailing blogs@bmc.com.

BMC Brings the A-Game

BMC works with 86% of the Forbes Global 50 and customers and partners around the world to create their future. With our history of innovation, industry-leading automation, operations, and service management solutions, combined with unmatched flexibility, we help organizations free up time and space to become an Autonomous Digital Enterprise that conquers the opportunities ahead.
Learn more about BMC ›

About the author

Stephen Watts

Stephen Watts (Birmingham, AL) contributes to a variety of publications including, Search Engine Journal, ITSM.Tools, IT Chronicles, DZone, and CompTIA.