Puntos clave: Db2 12 para z/OS proporciona comandos esenciales para una gestión eficaz de bases de datos, cubriendo operaciones como iniciar, detener y modificar la configuración de la base de datos. La guía incluye una sintaxis detallada de comandos para optimizar tareas administrativas.
- Comandos para gestionar pools de búfer, utilidades y estados de bases de datos.
- Orientación sobre cómo utilizar funciones específicas de Db2 para una administración eficiente.
-ACCEDER A LA BASE DE DATOS
<_ ,_____________ >>__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___ǀ
-ALTER PISCINA DE BUFFER
>>__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)_ǀ
-ACTIVAR
>>__ACTIVE FUNCTION LEVEL__(_function-level_)______________________________>
ǀ_TEST_ǀ
-ACTIVAR NUEVA FUNCIÓN
>>__ACTIVE NEW FUNCTION___________________________________________________>
-ALTER GRUPO DE BUFFERPOOL
>>__ALTER GROUPBUFFERPOOL__(__ _gbpname_______ ___)______________________>
ǀ_sructure-name_ǀ
>__ _____________________ __ ____________________ _______________________>
ǀ_GBPCACHE(_ _YES_ _)_ǀ ǀ_AUTOREC(_ _YES_ _)_ǀ
ǀ_NO__ǀ ǀ_NO__ǀ
>__ ______________ __ ___________________ ______________________________>
ǀ_RATIO(ratio)_ǀ ǀ_CLASST(Thr1, Thr2_ǀ ǀ_GBPOOLT(integer__ǀ
>__ ___________________ ________________________________________________>
ǀ_GBPCHKPT(integer)_ǀ
-ALTERAR UTILIDAD
>>__ALTER__UTILITY__(__utility-id__)__REORG______________________________>
ǀ_REBUILD_ǀ
>__ ___________________________ __ ______________________ _______________>
ǀ_DEADLINE(_ _NONE______ _)_ǀ ǀ_MAXRO(_ _integer_ _)_ǀ
ǀ_timestamp_ǀ ǀ_DEFER___ǀ
>__ _________________________ __ ______________________ ________________>< ǀ_LONGLOG(_ _CONTINUE_ _)_ǀ ǀ_DELAY(___integer___)_ǀ
ǀ_TERM_____ǀ
ǀ_DRAIN____ǀ
-REGISTRO DE ARCHIVO
>>__ARCHIVE LOG__________________________________________________________>
_SCOPE(MEMBER)_____________________________________
>__ǀ___________________________________________________ǀ_________________>< ǀ_SCOPE(GROUP)______________________________________ǀ
ǀ_MODE(QUIESCE)__ ___________ __ _________________ _ǀ
ǀ ǀ_TIME(nnn)_ǀ ǀ _NO__ ǀ ǀ
ǀ ǀ_WAIT(_ǀ_YES_ǀ_)_ǀ ǀ
ǀ_CANCEL OFFLOAD____________________________________ǀ
-PAQUETE DE VINCULACIÓN
>>_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_______ǀ
-PLAN UNIÓN
>>_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._ǀ ǀ_*___________ǀ ǀ_*__________ǀ
ǀ_*._____________ǀ
-CONSULTA DE ENLACE
>>__BIND QUERY_____________________________________________________________>< ǀ _NO___ ǀ ǀ_EXPLAININPUTSCHEMA(schema-name)_ǀ
ǀ_LOOKUP(_ǀ_YES__ǀ__)_ǀ
-CANCELAR HILO
>>__CANCEL__ _THREAD(token)_________________________________________________>
ǀ_DDFTHREAD(_ _luwid_ _)_ǀ ǀ_DUMP_ǀ ǀ_LOCAL_ǀ ǀ_NOBACKOUT_ǀ
ǀ_token_ǀ
>___________________________________________________________________________>< ǀ_FORCE_ǀ
/CAMBIO 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______________ǀ
-PANTALLA DE PANTALLA
_(_*_)________________________
ǀ <_ ,______________ ǀ >>__DISPLAY__ACCEL _ǀ__(___accelerator-name_ǀ___)__ǀ_____________________>
ǀ_DETAIL__ǀ
>________________________________________________________________________>
ǀ_LIST_(__*__________)_______ǀ ǀ ǀ
ǀ_ACTIVE_ǀ ǀ _LOCAL_ ǀ
ǀ_SCOPE__(_ǀ_GROUP_ǀ )_ǀ
>_______________________________________________________________________>< ǀ ǀ
ǀ_MEMBER(member-name)_ǀ
-ARCHIVO DE VISUALIZACIÓN
>>__DISPLAY ARCHIVE_____________________________________________________><
-CONJUNTO DE BUFFERS DE PANTALLA
_(_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__ǀ
-BASE DE DATOS DE VISUALIZACIÓN
<_ ,_____________ >>__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______ǀ
-PANTALLA DF
>>__DISPLAY DDF__________________________________________________________>< ǀ_ALIAS (alias-name)_ǀ ǀ_DETAIL_ǀ
-CAPTURA DE PANTALLA DYNQUERYCAPTURE
>>__DISPLAY DYNQUERYCAPTURE__ _________________________________ _________>
ǀ _(*)_________________________ ǀ
ǀ ǀ <_ ,___________________ ǀ ǀ
ǀ_CNO(ǀ_(___integer___________ _ǀ_)_ǀ_ǀ
-FUNCIÓN DE VISUALIZACIÓN ESPECÍFICA
>>__DISPLAY FUNCTION SPECIFIC____________________________________________>
_(*.*)____________________________________
>__ǀ___________________________________________ǀ_________________________>
ǀ <_ ,_________________________________ ǀ ǀ_(___ _schema.specific-function-name_ _ǀ_)_ǀ ǀ_schema.partial-name*__________ǀ >__ ______________________ ______________________________________________>< ǀ _LOCAL_ ǀ
ǀ_SCOPE__(_ǀ_______ǀ_)_ǀ
ǀ_GROUP_ǀ
-GRUPO DE VISUALIZACIÓN
>>__DISPLAY GROUP__ ________ ____________________________________________>< ǀ_DETAIL_ǀ
-GRUPO DE BUFFERPOOL DE VISUALIZACIÓN
>>__DISPLAY GROUPBUFFERPOOL__ ________________________________ __________>
ǀ _(*)________________________ ǀ
ǀ ǀ <_ ,__________________ ǀ ǀ ǀ_ǀ_(___ _gbpname________ _ǀ_)_ǀ_ǀ ǀ_structure-name_ǀ >__ _________________________ __ _______________________________ ______>
ǀ _*_______ ǀ ǀ_MDETAIL__ __________________ _ǀ
ǀ_TYPE__(__ǀ_GCONN___ǀ__)_ǀ ǀ _INTERVAL_ ǀ
ǀ_MCONN___ǀ ǀ_(_ǀ__________ǀ_)_ǀ
ǀ_NOCACHE_ǀ ǀ_*________ǀ
>__ _______________________________ __ _________________________ ______>
ǀ_GDETAIL__ __________________ _ǀ ǀ _NO__ ǀ
ǀ _INTERVAL_ ǀ ǀ_CONNLIST__(__ǀ_YES_ǀ__)_ǀ
ǀ_(_ǀ__________ǀ_)_ǀ
ǀ_*________ǀ
-UBICACIÓN DE VISUALIZACIÓN
_(*)____________________________
>>__DISPLAY LOCATION__ǀ_________________________________ǀ_______________>
ǀ <_ ,_____________________ ǀ ǀ_DETAIL_ǀ
ǀ_(____ _location-name_____ _ǀ__)_ǀ
ǀ_partial-location*_ǀ
ǀ___________ǀ
ǀ_ipaddr____________ǀ
-MOSTRAR REGISTRO
>>__DISPLAY LOG_________________________________________________________><
-PROCEDIMIENTO DE VISUALIZACIÓN
_(*.*)______________________________
>>__DISPLAY PROCEDURE__ǀ____________________________________ǀ__________>
ǀ <_ ,_________________________ ǀ ǀ__(___ _schema.procedure-name_ _ǀ_)_ǀ ǀ_schema.partial-name*__ǀ ǀ_procedure-name________ǀ ǀ_partial-name*_________ǀ >_____________________________________________________________________>< ǀ _LOCAL_ ǀ
ǀ_SCOPE__(_ǀ_______ǀ_)_ǀ
ǀ_GROUP_ǀ
-PERFIL DE PANTALLA
>>__DISPLAY PROFILE___________________________________________________><
-LÍMITE DE VISUALIZACIÓN
>>__DISPLAY RLIMIT____________________________________________________><
-ESTADÍSTICAS DE VISUALIZACIÓN
>>__DISPLAY_STATS__(_INDEXMEMORYUSAGE_)_______________________________>< ǀ_DIS___ǀ ǀ_IDXMEMUSE_____ǀ ǀ_LIMIT_(_integer_)_ǀ
ǀ_,________ǀ
-HILO DE VISUALIZACIÓN
>>__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_ǀ_)_ǀ
ǀ_( * )__________ǀ ǀ_*_______ǀ
-TRAZA DE VISUALIZACIÓN
_(__*__)_______
>>__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_ǀ
-UTILIDAD DE PANTALLA
>>__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 (instalación de adscripción CICS)
>>__DSNC__ _____________ __db2-command_________________________________>< ǀ_destination_ǀ
Desconexión del DNC (instalación de conexión CICS)
>>__DSNC DISCONNECT__plan-name_________________________________________><
Pantalla DSNC (instalación de accesorio CICS)
>>__DSNC DISPLAY__ _PLAN__ ___________ _____________ __________________>
ǀ ǀ_plan-name_ǀ ǀ
ǀ_TRANSACTION__ ________________ _ǀ
ǀ ǀ_transcation-id_ǀ ǀ
ǀ_STATISTICS______________________ǀ
>______________________________________________________________________>< ǀ_destination_ǀ
Modificación del DSNC (Instalación de anexo CICS)
>>__DSNC MODIFY__ _DESTINATION__old__new_______________________________>< ǀ_TRANSCATION__transaction-id__integer_ǀ
PARADA DEL DSNC (instalación de adjunto CICS)
_QUIESCE_
>>__DSNC STOP__ǀ_FORCE___ǀ______________________________________________><
DSNC Comienza (instalación de adscripción CICS)
>>__DSNC STRT__ ______ _________________________________________________>< ǀ_ssid_ǀ
DSNH (TSO CLIST)
>>__DSNH__INPUT(data-set-name)__________________________________________>< ǀ <_________________ ǀ
ǀ___clist-parameter_ǀ_ǀ
FIN
>>__END_________________________________________________________________><
DYNAMICQUERY ESTABILIZADA LIBRE (DSN)
>>__FREE STABLIZED DYNAMIC QUERY STBLGRP_______stabilization-group______>
>_SDQSTMTID_(__statement-id__)__________________________________________>
>_______________________________________________________________________>
ǀ ___ALL__ ǀ ǀ _NO__ ǀ
ǀ_PLANMGMTSCOPE (_ǀ________ǀ_)_ǀ ǀ__INVALID ONLY(_ǀ_____ǀ___)_ǀ____>< ǀ_INVALID_ǀ ǀ_YES_ǀ
PAQUETE GRATUITO
>>__FREE PACKAGE___________________________________________________________>
<_ ,_________________________________________________________________ >(___________________collection-id_._package-id________________________ǀ__)_>
ǀǀ_location-name.ǀǀ_*___________ǀ ǀ_*________ǀ ǀ_.(_ _____________)_ǀ ǀ
ǀ ǀ_version-id_ǀ ǀ
ǀ ǀ_*__________ǀ ǀ
ǀ_*____________________________________________________________________ǀ
>___________________________________________________________________________>< ǀ _I_ ǀǀ _ALL______ _NO__ ǀ
ǀ_FLAG(_ǀ_W_ǀ_)_ǀǀ_PLANMGMTSCOPE(_ǀ__________ǀ_)_____________(_ǀ_____ǀ_)_ǀ
ǀ_E_ǀ ǀ_INACTIVE_ǀ ǀ ǀ _YES_
ǀ_C_ǀ ǀ_PREVIOUS_ǀ ǀ_INVALIDONLY_ǀ
ǀ_ORIGINAL_ǀ
PLAN GRATUITO
>>__FREE PLAN__(_ ___plan-name_ǀ_ _)__ _______________ ____________________>< ǀ_*_____________ǀ ǀ _I_ ǀ
ǀ_FLAG(_ǀ_W_ǀ_)_ǀ
ǀ_E_ǀ
ǀ_C_ǀ
CONSULTA GRATUITA
>>__FREE QUERY__FILTER(‘filter-name’)_____________________________________>
ǀ_PACKAGE(package-name)_ǀ
ǀ_QUERYID(number)_______ǀ
ǀ_QUERYID(ALL)__________ǀ
>>___________________,_collection-id_,__package-id_,_(_______________)____>< ǀ_location_name_ǀ ǀ_,___________ǀ ǀ_,_________ǀ ǀ_version-id_ǀ
-MODIFICAR 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)_________________ǀ
MODIFICAR IRLMPROC, ABEND
_,DUMP___
>>__MODIFY__irlmproc,ABEND_ǀ_________ǀ_____________________________________>< ǀ_,NODUMP_ǀ
MODIFICAR IRLMPROC, DIAG
>>__MODIFY__irlmproc,DIAG_ _,DELAY_ _______________________________________>< ǀ_,PLOCK_ǀ
ǀ_,ALL___ǀ
ǀ_,NONE__ǀ
ǀ_,HANG__ǀ
MODIFICAR IRLMPROC, PURGAR
>>__MODIFY__irlmproc,PURGE,db2name_________________________________________><
MODIFICAR IRLMPROC, ESTABLECER
>>__MODIFY__irlmproc,SET__ _,DEADLOCK-nnnn_________________________________>< ǀ_,LTE=nnnn____________________ǀ
ǀ_,PVT=nnnn____________________ǀ
ǀ_,MVT=nnnnnU__________________ǀ
ǀ_,TIMEOUT=nnnn,subsystem-name_ǀ
ǀ _10__ ǀ
ǀ_,TRACE=_ǀ_nnn_ǀ______________ǀ
MODIFICAR IRLMPROC, ESTADO
_,irlmx__
>>__MODIFY__irlmproc,STATUS_ǀ________ǀ_____________________________________>< ǀ_,ALLD__ǀ
ǀ_,ALLI__ǀ
ǀ_,MAINT_ǀ
ǀ_,STOR__ǀ
ǀ_,TRACE_ǀ
-MODIFICAR TRAZA (DB2)
_*___________
ǀ <_ ,_______ ǀ >>__MODIFY TRACE__(_ _PERFM___ _)__CLASS(_ǀ___integer_ǀ_ǀ_)________________>
ǀ_ACCTG___ǀ
ǀ_STAT____ǀ
ǀ_AUDIT___ǀ
ǀ_MONITOR_ǀ
_*_______________
ǀ <_ ,___________ ǀ >__TNO(integer)__IFCID(_ǀ____ifcid_nbr__ǀ_ǀ_)_____________________________>
ǀ_COMMENT(string)_ǀ
PAQUETE DE REBINDING
>>__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ǀ_______________ǀ
PLAN DE REBINDING
<_ ,_________ >>__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_ǀ_)___________ǀ
PAQUETE DE DISPARADOR DE REVINCULACIÓN
>>_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_ǀ
-RECUPERAR BSDS
>>__RECOVER BSDS____________________________________________________________><
RECUPERACIÓN INDOUBT
>>__RECOVER INDOUBT__ ___________________ __ACTION(_ _COMMIT_ _)__________>
ǀ_(connection-name)_ǀ ǀ_ABORT__ǀ
<_ ,______________ >__ _ID(_ ___correlation-id_ǀ_ _)_ _____________________________________>< ǀ ǀ_*__________________ǀ ǀ
ǀ <_,__________ ǀ
ǀ_NID(___network-id_ǀ_)________ǀ
ǀ <_,_______ ǀ
ǀ_LUWID(__ _luwid_ ǀ_)_________ǀ
ǀ_token¬_ǀ
-RECUPERACIÓN POSPUESTA
>>__RECOVER POSTPONED__ ________ _________________________________________>< ǀ_CANCEL_ǀ
-ACTUALIZAR DB2, ANTICIPADO
>>__REFRESH DB2, EARLY____________________________________________________><
-REINICIAR GENERICLU
<_ ,________________ >>__RESET GENERICLU__ _(___ _luname_______ _ǀ_)_ _________________________>< ǀ ǀ_netid.luname_ǀ ǀ
ǀ_(*)______________________ǀ
-REINICIA INDOUBT
>>__RESET INDOUBT__________________________________________________________>
<_ ,______ >__ _LUNAME(_ ___luname_ǀ_ _)_ _______ ___________________________________>< ǀ ǀ_*__________ǀ ǀ_FORCE_ǀ ǀ
ǀ <_,_____________ ǀ
ǀ_LOCATION(___location-name_ǀ_)_____________________ǀ
ǀ <_,____________________ ǀ
ǀ_IPADDR(_ _______ipaddr..port_____ǀ_ _)_ _______ __ǀ
ǀ ǀ_*________________________ǀ ǀ_FORCE_ǀ ǀ
ǀ <_,_______ ǀ
ǀ_LUWID(__ _luwid_ ǀ_)_ _________________________ __ǀ
ǀ_token_ǀ ǀ_LOCATION(location-name)_ǀ
CORRE
>>__RUN__ _PROGRAM(program-name)__ ________________ _ _____________________>
ǀ ǀ_PLAN(plan-name_ǀ ǀ
ǀ_CP__PLAN(plan-name)_______________________ǀ
>__ _______________________ __ _________________________ __________________>< ǀ_LIBRARY(library-name)_ǀ ǀ_PARMS(parameter-string)_ǀ
-ARCHIVO DE SETS
>>__SET ARCHIVE__ __ __________ __ _______________________________________>< ǀ ǀ_COUNT__(__integer__)_ǀǀ_TIME(_ _minutes_ __)_ǀ ǀ
ǀ ǀ ǀ_,seconds_ǀ ǀ ǀ
ǀ ǀ_,seconds____________ǀ ǀ
ǀ ǀ_1440________________ǀ ǀ
ǀ ǀ_NOLIMIT_____________ǀ ǀ
ǀ_DEFAULT____________________________________________ǀ
-ESTABLECER REGISTRO
>>__SET LOG_______________LOGLOAD(integer)_________________________________>
ǀ_SINGLE_ǀ ǀ ǀ_CHKTIME(integer)_ǀ ǀ
ǀ_BOTH___ǀ ǀ_CHKTIME(integer)___________________________ǀ
ǀ ǀ_LOGLOAD(integer)_ǀ ǀ
ǀ_SUSPEND____________________________________ǀ
ǀ_RESUME_____________________________________ǀ
ǀ_NEWLOG_(_data-set-name_)_COPY_(_log-copy_)_ǀ
-ESTABLECER 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__ǀ__)_ǀ
/Comienza IMS
>>__/START_______________________________________________________________>< ǀ ǀ
ǀ <_,_________________ ǀ
ǀ ǀ ǀ
ǀ_SUBSYS __subsystem-name_ǀ_ǀ
ǀ_SUBSYS__ALL_______________ǀ
-BASE DE DATOS DE INICIO
<_ ,_____________ >>__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)_ǀ
-INICIAR DDF
>>__START DDF___________________________________________________________><
-INICIAD LA CAPTURA DE DYNQUERY.
>>__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_ǀ_)ǀ
-FUNCIÓN ESPECÍFICA DE INICIO
>>__START FUNCTION SPECIFIC_____________________________________________>
_(*.*)_____________________________________
>__ǀ___________________________________________ǀ________________________>
ǀ <_ ,_________________________________ ǀ ǀ_(___ _schema.specific-function-name_ _ǀ_)_ǀ ǀ_schema.partial-name*__________ǀ ǀ >__ ____________________________________________________________________>< ǀ _LOCAL_ ǀ
ǀ_SCOPE__(_ǀ_______ǀ_)_ǀ
ǀ_GROUP_ǀ
-INICIAR 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_ǀ
-INICIAR EL PROCEDIMIENTO
_(*.*)_____________________________
>>__START PROCEDURE__ǀ___________________________________ǀ_______________>
ǀ <_ ,_________________________ ǀ ǀ_(___ _schema.procedure-name_ _ǀ_)_ǀ ǀ_schema.partial-name*__ǀ ǀ_procedure-name________ǀ ǀ_partial-name*_________ǀ >__ ______________________ ______________________________________________>< ǀ _LOCAL_ ǀ
ǀ_SCOPE__(_ǀ_______ǀ_)_ǀ
ǀ_GROUP_ǀ
-PERFIL INICIAL
>>__START PROFILE________________________________________________________><
-START RLIMIT
>>__START RLIMIT__ _______ ______________________________________________>< ǀ_ID=id_ǀ
-INICIAR RASTREO
>>__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_ǀ
-PARA 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_____________________________________________________><
-BASE DE DATOS DE PARADAS
<_ ,_____________ >>__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)_ǀ
-PARA 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)___ǀ
-DETENGAN LA CAPTURA DE LA DINAQUERÍA
>>__DISPLAY DYNQUERYCAPTURE__ ____________________________________________>
ǀ _(*)_____________________ ǀ
ǀ ǀ <_ ,_______________ ǀ ǀ ǀ_CNO(ǀ_(___integer_______ _ǀ_)_ǀ_ǀ >_________________________________________________________________________>< ǀ _LOCAL_ ǀ
ǀ_SCOPE__(_ǀ_GROUP_ǀ_)_ǀ
-FUNCIÓN DE PARADA ESPECÍFICA
>>__STOP FUNCTION SPECIFIC________________________________________________>
_(*.*)_____________________________________
>__ǀ___________________________________________ǀ__________________________>
ǀ <_ ,_________________________________ ǀ ǀ_(___ _schema.specific-function-name_ _ǀ_)_ǀ ǀ_schema.partial-name*__________ǀ >________________________________________________________________________>< ǀ _QUEUE__ ǀ ǀ _LOCAL_ ǀ
ǀ_ACTION__(_ǀ_REJECT_ǀ_)_ǀ ǀ_SCOPE__(_ǀ_GROUP_ǀ_)_ǀ
STOP irlmproc
>>__STOP__irlmproc_______________________________________________________>
-PROCEDIMIENTO DE PARADA
_(*.*)_____________________________
>>__STOP PROCEDURE__ǀ___________________________________ǀ________________>
ǀ <_ ,_________________________ ǀ ǀ_(___ _schema.procedure-name_ _ǀ_)_ǀ ǀ_schema.partial-name*__ǀ ǀ_procedure-name________ǀ ǀ_partial-name*_________ǀ >__ ________________________ __ _____________________ ___________________>< ǀ _QUEUE__ ǀ ǀ _LOCAL_ ǀ
ǀ_ACTION__(_ǀ_REJECT_ǀ_)_ǀ ǀ_SCOPE__(_ǀ_______ǀ_)_ǀ
ǀ_GROUP_ǀ
-PERFIL DE PARADA
>>__STOP PROFILE________________________________________________________><
-STOP RLIMIT
>>__STOP RLIMIT_________________________________________________________><
-DETÉN EL RASTREO
>>__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_ǀ
-UTILIDAD TEMPORAL
>>__TERM UTILITY__(_ _utility-id__________ _)_____________________________>
ǀ_partial-utility-id*_ǀ
ǀ_*___________________ǀ
TRACE IMS
>>__/TRACE__SET_ _ON__ ___ ______________________________________________>
ǀ_OFF_ǀ ǀ _ALL__ ǀ
ǀ_TABLE_ǀ_SUBS_ǀ__ǀ
>__ ___________________ ________________________________________________>< ǀ _NOLOG_ ǀ
ǀ_OPTION_ǀ_LOG___ǀ__ǀ
TRACE TC
_,WRAP___
>>__TRACE CT,____ _WTRSTART-parmlibmem_ǀ_________ǀ______________________>< ǀ ǀ_,NOWRAP_ǀ ǀ
ǀ_WTRSTOP=jobname________________________ǀ
ǀ_ON,__COMP=irlmnm__ __________________ _ǀ
ǀ ǀ_,SUB=(_ _DBM_ _)_ǀ ǀ
ǀ ǀ_EXP_ǀ ǀ
ǀ ǀ_INT_ǀ ǀ
ǀ ǀ_SLM_ǀ ǀ
ǀ ǀ_XCF_ǀ ǀ
ǀ ǀ_XIT_ǀ ǀ
ǀ_OFF____________________________________ǀ
Aviso legal: Esta Guía de Referencia de Db2® 12 para z/OS fue desarrollada para ayudar a los usuarios en sus actividades diarias en la administración y programación en Db2 para z/OS. No son garantías expresadas ni implícitas con el contenido de esta guía. Queremos proporcionar una referencia de calidad y útil para los usuarios. Por favor, notifícanos cualquier error o error en esta guía de referencia en blogs@bmc.com. Db2 están una marca registrada de IBM Corporation.
Guía Db2
- Db2 12 para z/OS: Una introducción
- Funciones escalares en Db2 12
- Cómo leer diagramas sintácticos de IBM<sup>®</sup> para Db2 12
- Elementos del lenguaje en Db2 12
- Funciones agregadas en Db2 12
- Funciones de tabla y fila en Db2 12
- Consultas en Db2 12
- Comandos en Db2 12
- Sentencias de control SQL en Db2 12
- Explica las tablas en Db2 12
- DSNZPARM en Db2 12
- Parámetros de enlace en Db2 12
- Límites de Db2 en Db2 12
- Área de Comunicación SQL (SQLCA) en Db2 12
- REXX SQLCA en Db2 12
- Obtén diagnósticos en Db2 12
- IFCIDS en Db2 12
- Tablas de catálogo en Db2 12
- Excepciones en Db2 12
- Tablas del Repositorio de Esquemas XML en Db2 12
- Estadísticas actualizables del catálogo en Db2 12
- IBM Utilities en Db2 12
- Códigos de retorno positivo SQL en Db2 12
- Códigos de retorno de errores SQL en Db2 12
Estas publicaciones son mías y no representan necesariamente la posición, estrategias u opinión de BMC.