MiniDoc - DB2 commandes

Ce document a été créé essentiellement par copier/coller depuis la documentation DB2-V6 de BOOKMGR.
Chacune de ces commandes DB2 a été reprise avec une description succinte et sa syntaxe. En cas de doute, il est impératif de consulter la documentation IBM de base.


Ne sont décrites ici que les commandes utiles au pilotage normal de DB2 sur notre site. Pour avoir une liste complète des commandes, consulter la documentation IBM.

ALTER BUFFERPOOL

Pour changer les attributs des buffers pool.

+------------------------------------------------------------------------+
¦                                                                        ¦
¦                                                                        ¦
¦ >>--ALTER BUFFERPOOL--(--bpname--)-----------------------------------> ¦
¦                                     +-VPSIZE(integer)-+                ¦
¦                                                                        ¦
¦ >--------------------------------------------------------------------> ¦
¦    +-VPTYPE----PRIMARY-----+  +-HPSIZE(integer)-+                      ¦
¦              +-DATASPACE-+                                             ¦
¦                                                                        ¦
¦ >--------------------------------------------------------------------> ¦
¦    +-VPSEQT(integer)-+  +-VPPSEQT(integer)-+                           ¦
¦                                                                        ¦
¦ >--------------------------------------------------------------------> ¦
¦    +-VPXPSEQT(integer)-+  +-HPSEQT(integer)-+  +-DWQT(integer)-+       ¦
¦                                                                        ¦
¦ >--------------------------------------------------------------------> ¦
¦    +-VDWQT(integer1,integer2)-+  +-CASTOUT(---YES---)-+                ¦
¦                                             +-NO--+                    ¦
¦                                                                        ¦
¦ >------------------------------------------------------------------->< ¦
¦    +-PGSTEAL----LRU----+                                               ¦
¦               +-FIFO-+                                                 ¦
¦                                                                        ¦
+------------------------------------------------------------------------+

ALTER GROUPBUFFERPOOL

+------------------------------------------------------------------------+
¦                                                                        ¦
¦                                                                        ¦
¦ >>--ALTER GROUPBUFFERPOOL--(----gbpname-----------)------------------> ¦
¦                               +-structure-name-+                       ¦
¦                                                                        ¦
¦ >--------------------------------------------------------------------> ¦
¦    +-GBPCACHE(---YES---)-+  +-AUTOREC(---YES---)-+                     ¦
¦                +-NO--+                 +-NO--+                         ¦
¦                                                                        ¦
¦ >--------------------------------------------------------------------> ¦
¦    +-RATIO(ratio)-+  +-CLASST(integer)-+  +-GBPOOLT(integer)-+         ¦
¦                                                                        ¦
¦ >------------------------------------------------------------------->< ¦
¦    +-GBPCHKPT(integer)-+                                               ¦
¦                                                                        ¦
+------------------------------------------------------------------------+

ALTER UTILITY

Permet de changer les paramètres d'une REOPRG en cpours

+------------------------------------------------------------------------+
¦                                                                        ¦
¦                                                                        ¦
¦ >>--ALTER--UTILITY--(--utility-id--)--REORG--------------------------> ¦
¦                                                                        ¦
¦ >--------------------------------------------------------------------> ¦
¦    +-DEADLINE(---NONE--------)-+  +-MAXRO(---integer---)-+             ¦
¦                +-timestamp-+               +-DEFER---+                 ¦
¦                                                                        ¦
¦ >------------------------------------------------------------------->< ¦
¦    +-LONGLOG(---CONTINUE---)-+  +-DELAY(---integer---)-+               ¦
¦               +-TERM-----¦                                             ¦
¦               +-DRAIN----+                                             ¦
¦                                                                        ¦
+------------------------------------------------------------------------+

ARCHIVE LOG

Permet de déclencher une archivelog.

+------------------------------------------------------------------------+
¦                                                                        ¦
¦                                                                        ¦
¦ >>--ARCHIVE LOG------------------------------------------------------> ¦
¦                                                                        ¦
¦    +-SCOPE(MEMBER)-------------------------------------+               ¦
¦ >--+---------------------------------------------------+------------>< ¦
¦    +-SCOPE(GROUP)--------------------------------------¦               ¦
¦    +-MODE(QUIESCE)-------------------------------------¦               ¦
¦    ¦                +-TIME(nnn)-+  ¦       +-NO--+   ¦ ¦               ¦
¦    ¦                               +-WAIT(---YES---)-+ ¦               ¦
¦    +-CANCEL OFFLOAD------------------------------------+               ¦
¦                                                                        ¦
+------------------------------------------------------------------------+

CANCEL THREAD

Permet de terminer un process en cours (attention aux conséquences).

+------------------------------------------------------------------------+
¦                                                                        ¦
¦                                                                        ¦
¦ >>--CANCEL----THREAD(token)----------------------------------------->< ¦
¦             +-DDF THREAD(---luwid---)-+  +-DUMP-+                      ¦
¦                           +-token-+                                    ¦
¦                                                                        ¦
+------------------------------------------------------------------------+

DISPLAY ARCHIVE

Pour obtenir des informations sur les archives

+------------------------------------------------------------------------+
¦                                                                        ¦
¦                                                                        ¦
¦ >>--DISPLAY ARCHIVE------------------------------------------------->< ¦
¦                                                                        ¦
+------------------------------------------------------------------------+

DISPLAY BUFFERPOOL

Donne des informations sur les bufferpools

+------------------------------------------------------------------------+
¦                         +-(--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

Donne des info dur les DB ou sur un de ses composants

+--------------------------------------------------------------------------------------------------------------------------------+
¦                                                                                                                                ¦
¦                                                                                                                                ¦
¦                           <-,-------------+                                                                                    ¦
¦ >>--DISPLAY DATABASE--(-----database-name---------)--------------------------------------------------------------------------> ¦
¦                         +-*---------------------¦                                                                              ¦
¦                         +-dbname1:dbname2-------¦                                                                              ¦
¦                         +-dbname*---------------¦                                                                              ¦
¦                         +-*dbname---------------¦                                                                              ¦
¦                         +-*dbname*--------------¦                                                                              ¦
¦                         +-*dbstring1*dbstring2*-+                                                                              ¦
¦                                                                                                                                ¦
¦ >----------------------------------------------------------------------------------------------------------------------------> ¦
¦    ¦ +-USE------¦                                                                ¦  ¦         <-,-------+           ¦          ¦
¦    ¦ +-CLAIMERS-¦                                                                ¦  +-PART(-----integer-----------)-+          ¦
¦    ¦ +-LOCKS----¦                                                                ¦          +-integer1:integer2-+              ¦
¦    ¦ +-LPL------¦                                                                ¦                                             ¦
¦    ¦ +-WEPR-----+                                                                ¦                                             ¦
¦    ¦                <-,----------+                                               ¦                                             ¦
¦    +-SPACENAM--(------space-name-------------------)-----------------------------¦                                             ¦
¦    ¦              +-*---------------------------¦     +------------------------+ ¦                                             ¦
¦    ¦              +-spacename1:spacename2-------¦       +-USE------¦  +-ONLY-+   ¦                                             ¦
¦    ¦              +-spacename*------------------¦       +-CLAIMERS-¦             ¦                                             ¦
¦    ¦              +-*spacename------------------¦       +-LOCKS----¦             ¦                                             ¦
¦    ¦              +-*spacename*-----------------¦       +-LPL------¦             ¦                                             ¦
¦    ¦              +-*spacestring1*spacestring2*-+       +-WEPR-----+             ¦                                             ¦
¦    ¦      (1)                                                                    ¦                                             ¦
¦    +-ONLY------------------------------------------------------------------------+                                             ¦
¦                                                                                                                                ¦
¦ >--------------------------------------------------------------------------------------------------------------------------->< ¦
¦    ¦        +-50------+   ¦  +-AFTER-+  +-ACTIVE-+  +-RESTRICT-+  +-ADVISORY-+  +-AREST-+                                      ¦
¦    +-LIMIT(-+-integer-+-)-+                                                                                                    ¦
¦             +-*-------+                                                                                                        ¦
+--------------------------------------------------------------------------------------------------------------------------------+

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

Affiche les connections en cours.

+------------------------------------------------------------------------+
¦                                                                        ¦
¦                                                                        ¦
¦                       +-(*)-----------------------------+              ¦
¦ >>--DISPLAY LOCATION--+---------------------------------+------------> ¦
¦                       ¦    <-,---------------------+    ¦              ¦
¦                       +-(------location-name----------)-+              ¦
¦                              +-partial-location*-¦                     ¦
¦                              +-<luname>----------¦                     ¦
¦                              +-ipaddr------------+                     ¦
¦                                                                        ¦
¦ >------------------------------------------------------------------->< ¦
¦    +-DETAIL-+                                                          ¦
¦                                                                        ¦
+------------------------------------------------------------------------+

DISPLAY LOG

Affiche des informations sur les taches d'OFFLOAD.

+------------------------------------------------------------------------+
¦                                                                        ¦
¦ >>--DISPLAY LOG----------------------------------------------------->< ¦
¦                                                                        ¦
+------------------------------------------------------------------------+

DISPLAY THREAD

Affiche les info sur les THREAD.

+------------------------------------------------------------------------+
¦                                                                        ¦
¦                                                                        ¦
¦ >>--DISPLAY THREAD---------------------------------------------------> ¦
¦                      ¦    <-,-----------------------+    ¦             ¦
¦                      +-(------connection-name----------)-¦             ¦
¦                      ¦      +-partial-connection*-+      ¦             ¦
¦                      +-(--*--)---------------------------+             ¦
¦                                                                        ¦
¦ >--------------------------------------------------------------------> ¦
¦    ¦       +-ACTIVE----+   ¦                                           ¦
¦    +-TYPE(-+-INDOUBT---+-)-+                                           ¦
¦            +-*---------¦                                               ¦
¦            +-INACTIVE--¦                                               ¦
¦            +-POSTPONED-+                                               ¦
¦                                                                        ¦
¦ >------------------------------------------------------------------->< ¦
¦    ¦               <-,---------------------+       ¦  +-DETAIL-+       ¦
¦    +---LOCATION(-------location-name-----------)---+                   ¦
¦      ¦           ¦   +-partial-location*-+   ¦   ¦                     ¦
¦      ¦           +-*-------------------------+   ¦                     ¦
¦      ¦        <-,----------------+               ¦                     ¦
¦      +-LUWID(----luwid-------------)-------------+                     ¦
¦                +-partial-luwid*-¦                                      ¦
¦                +-token----------+                                      ¦
¦                                                                        ¦
+------------------------------------------------------------------------+

DISPLAY TRACE

Affiche desinformations sur les traces actives.

+------------------------------------------------------------------------+
¦                                                                        ¦
¦                                                                        ¦
¦                    +-(--*--)-------+                                   ¦
¦ >>--DISPLAY TRACE--+---------------+---------------------------------> ¦
¦                    +-(--PERFM--)---¦                                   ¦
¦                    +-(--ACCTG--)---¦                                   ¦
¦                    +-(--STAT--)----¦                                   ¦
¦                    +-(--AUDIT--)---¦                                   ¦
¦                    +-(--MONITOR--)-+                                   ¦
¦                                                                        ¦
¦ >--------------------------------------------------------------------> ¦
¦    +-destination block-+  +-constraint block-+                         ¦
¦                                                                        ¦
¦ >------------------------------------------------------------------->< ¦
¦    +-DETAIL(output-type)-+  +-COMMENT(string)-+                        ¦
¦ destination block:                                                     ¦
¦                                                                        ¦
¦          <-,-----+                                                     ¦
¦ >--DEST(----GTF----)-------------------------------------------------> ¦
¦           +-SMF-¦                                                      ¦
¦           +-SRV-¦                                                      ¦
¦           +-OPn-+                                                      ¦
¦ constraint block:                                                      ¦
¦                                                                        ¦
¦          +-*-------------+            +-*-----------+                  ¦
¦          ¦ <-,---------+ ¦            ¦ <-,-------+ ¦                  ¦
¦ >--PLAN(-----plan-name-----)--AUTHID(-----auth-id-----)--------------> ¦
¦                                                                        ¦
¦           +-*-----------+         +-*-----------+                      ¦
¦           ¦ <-,-------+ ¦         ¦ <-,-------+ ¦                      ¦
¦ >--CLASS(-----integer-----)--TNO(-----integer-----)------------------> ¦
¦                                                                        ¦
¦              +-*-----------------+                                     ¦
¦              ¦ <-,-------------+ ¦                                     ¦
¦ >--LOCATION(-+---location-name---+-)---------------------------------> ¦
¦              +-<luname>----------¦                                     ¦
¦              +-nnn.nnn.nnn.nnn---+                                     ¦
¦                                                                        ¦
+------------------------------------------------------------------------+

DISPLAY UTILITY

Affiche des info sur les utilitaires actifs.

+------------------------------------------------------------------------+
¦                                                                        ¦
¦ >>--DISPLAY UTILITY--(---utility-id------------)---------------------> ¦
¦                        +-partial-utility-id*-¦                         ¦
¦                        +-*-------------------+                         ¦
¦                                                                        ¦
¦ >------------------------------------------------------------------->< ¦
¦    ¦         <-,---------+   ¦                                         ¦
¦    +-MEMBER(--member-name--)-+                                         ¦
¦                                                                        ¦
+------------------------------------------------------------------------+

MODIFY

Cette commande permet de modifier, terminer(ABEND) ou diagnotiquer les STC DB2.
Elle ne doit être utilisée que par les spécialistes.

SET ARCHIVE

Cette commande modifie le nombre maxi "tape archive log" et le temps de dé-allocation. A utiliser avec précaution et sur demande des experts.

+---------------------------------------------------------------------------------------------+
¦                                                                                             ¦
¦ >>--SET ARCHIVE-------------------------------------------------------------------------->< ¦
¦                  ¦  +-COUNT--(--integer--)-+  +-TIME(---minutes-----------------)-+  ¦      ¦
¦                  ¦                                    ¦          +-,seconds-+ ¦      ¦      ¦
¦                  ¦                                    +-,seconds--------------¦      ¦      ¦
¦                  ¦                                    +-1440------------------¦      ¦      ¦
¦                  ¦                                    +-NOLIMIT---------------+      ¦      ¦
¦                  +-DEFAULT-----------------------------------------------------------+      ¦
¦                                                                                             ¦
+---------------------------------------------------------------------------------------------+

SET LOG

Cette commande modifie la fréquence des "checkpoint". A utiliser avec précaution et sur demande expresse des experts.

 
+--------------------------------------------------------------------------------+
¦                                                                                ¦
¦ >>--SET LOG----LOGLOAD(integer)--------------------------------------------->< ¦
¦              +-SUSPEND----------¦                                              ¦
¦              +-RESUME-----------+                                              ¦
¦                                                                                ¦
+--------------------------------------------------------------------------------+

START DATABASE

Normalement, cette commande est utilisée après un "STOP DATABASE". Dans certains cas, cette commande est utilisée pour forcer ou retreindre les accès à une database.

+----------------------------------------------------------------------------------------------------------------------+
¦                                                                                                                      ¦
¦                                                                                                                      ¦
¦                         <-,-------------+                                                                            ¦
¦ >>--START DATABASE--(-----database-name---------)------------------------------------------------------------------> ¦
¦                       +-*---------------------¦                                                                      ¦
¦                       +-dbname1:dbname2-------¦                                                                      ¦
¦                       +-dbname*---------------¦                                                                      ¦
¦                       +-*dbname---------------¦                                                                      ¦
¦                       +-*dbname*--------------¦                                                                      ¦
¦                       +-*dbstring1*dbstring2*-+                                                                      ¦
¦                                                                                                                      ¦
¦ >----------------------------------------------------------------------------------------------------------------->< ¦
¦    ¦             <-,----------+                                                     ¦  ¦         +-RW----+   ¦       ¦
¦    +-SPACENAM(-----space-name------------------)------------------------------------+  +-ACCESS(-+-RO----+-)-+       ¦
¦                +-*---------------------------¦   ¦         <-,-------+           ¦               +-UT----¦           ¦
¦                +-spacename1:spacename2-------¦   +-PART(-----integer-----------)-+               +-FORCE-+           ¦
¦                +-spacename*------------------¦           +-integer1:integer2-+                                       ¦
¦                +-*spacename------------------¦                                                                       ¦
¦                +-*spacename*-----------------¦                                                                       ¦
¦                +-*spacestring1*spacestring2*-+                                                                       ¦
¦                                                                                                                      ¦
+----------------------------------------------------------------------------------------------------------------------+

START DB2

Cette commande démarre le sous-système DB2. Elle devrait être planifiée dans la séquence d'IPL.
Ne passer cette commande que sur demande express des experts.

+------------------------------------------------------------------------+
¦                                                                        ¦
¦                                                                        ¦
¦ >>--START DB2--------------------------------------------------------> ¦
¦                ¦       +-DSNZPARM----+   ¦                             ¦
¦                +-PARM(---module name---)-+                             ¦
¦                                                                        ¦
¦ >--------------------------------------------------------------------> ¦
¦    ¦         +-*-----+   ¦  +-MSTR(jcl-substitution)-+                 ¦
¦    +-ACCESS(---MAINT---)-+                                             ¦
¦                                                                        ¦
¦ >------------------------------------------------------------------->< ¦
¦    +-DBM1(jcl-substitution)-+  +-DIST(jcl-substitution)-+              ¦
¦                                                                        ¦
+------------------------------------------------------------------------+

START DDF

Démarre le DDF (distributed data facility) si pas démarré.

+------------------------------------------------------------------------+
¦                                                                        ¦
¦ >>--START DDF------------------------------------------------------->< ¦
¦                                                                        ¦
+------------------------------------------------------------------------+

START TRACE

Cette commande démarre une trace. A faire sur demande dex experts.

+------------------------------------------------------------------------+
¦                                                                        ¦
¦ >>--START TRACE--(---PERFM-----)-------------------------------------> ¦
¦                    +-ACCTG---¦                                         ¦
¦                    +-STAT----¦                                         ¦
¦                    +-AUDIT---¦                                         ¦
¦                    +-MONITOR-+                                         ¦
¦                                                                        ¦
¦ >--------------------------------------------------------------------> ¦
¦    +-destination block-+  +-constraint block-+                         ¦
¦                                                                        ¦
¦ >------------------------------------------------------------------->< ¦
¦    +-COMMENT(string)-+                                                 ¦
¦ destination block:                                                     ¦
¦                                                                        ¦
¦          <-,-----+                                                     ¦
¦ >--DEST(----GTF----)-------------------------------------------------> ¦
¦           +-SMF-¦                                                      ¦
¦           +-SRV-¦                                                      ¦
¦           +-OPn-¦                                                      ¦
¦           +-OPX-+                                                      ¦
¦ constraint block:                                                      ¦
¦                                                                        ¦
¦          +-*-------------+            +-*--------------------+         ¦
¦          ¦ <-,---------+ ¦            ¦ <-,----------------+ ¦         ¦
¦ >--PLAN(-----plan-name-----)--AUTHID(-----authorization-id-----)-----> ¦
¦                                                                        ¦
¦           +-*-----------+           +-*---------+                      ¦
¦           ¦ <-,-------+ ¦           ¦ <-,-----+ ¦  (1)                 ¦
¦ >--CLASS(-----integer-----)--IFCID(-----ifcid-----)------------------> ¦
¦                                                                        ¦
¦             +-*-------+           <-,-------------+                    ¦
¦ >--BUFSIZE(---k_bytes---)--TDATA(----CORRELATION----)----------------> ¦
¦                                    +-TRACE-------¦                     ¦
¦                                    +-CPU---------¦                     ¦
¦                                    +-DISTRIBUTED-+                     ¦
¦                                                                        ¦
¦ >--LOCATION(---*-------------------)---------------------------------> ¦
¦              ¦ <-,-------------+ ¦                                     ¦
¦              +---location-name---¦                                     ¦
¦              +-<luname>----------¦                                     ¦
¦              +-ipaddr------------+                                     ¦
¦                                                                        ¦
+------------------------------------------------------------------------+

STOP DATABASE

Cette commande rend une DB innacessible aux applications et aux utilitaires.

+------------------------------------------------------------------------------------------------------------+
¦                                                                                                            ¦
¦                                                                                                            ¦
¦                        <-,-------------+                                                                   ¦
¦ >>--STOP DATABASE--(-----database-name---------)---------------------------------------------------------> ¦
¦                      +-*---------------------¦                                                             ¦
¦                      +-dbname1:dbname2-------¦                                                             ¦
¦                      +-dbname*---------------¦                                                             ¦
¦                      +-*dbname---------------¦                                                             ¦
¦                      +-*dbname*--------------¦                                                             ¦
¦                      +-*dbstring1*dbstring2*-+                                                             ¦
¦                                                                                                            ¦
¦ >------------------------------------------------------------------------------------------------------->< ¦
¦    ¦             <-,----------+                                                     ¦  +-AT(COMMIT)-+      ¦
¦    +-SPACENAM(-----space-name------------------)------------------------------------+                      ¦
¦                +-*---------------------------¦   ¦         <-,-------+           ¦                         ¦
¦                +-spacename1:spacename2-------¦   +-PART(-----integer-----------)-+                         ¦
¦                +-spacename*------------------¦           +-integer1:integer2-+                             ¦
¦                +-*spacename------------------¦                                                             ¦
¦                +-*spacename*-----------------¦                                                             ¦
¦                +-*spacestring1*spacestring2*-+                                                             ¦
¦                                                                                                            ¦
+------------------------------------------------------------------------------------------------------------+

STOP DB2

Cette commande demande l'arrêt de DB2.

+------------------------------------------------------------------------+
¦                                                                        ¦
¦               +-MODE(QUIESCE)-+  +-CASTOUT(YES)-+                      ¦
¦ >>--STOP DB2--+---------------+--+--------------+------------------->< ¦
¦               +-MODE(FORCE)---+  +-CASTOUT(NO)--+                      ¦
¦                                                                        ¦
+------------------------------------------------------------------------+

STOP DDF

Pour arrêter le DDF.

+------------------------------------------------------------------------+
¦                                                                        ¦
¦               +-MODE(QUIESCE)----------------+                         ¦
¦ >>--STOP DDF--+------------------------------+---------------------->< ¦
¦               +-MODE(FORCE)------------------¦                         ¦
¦               +-MODE(SUSPEND)---CANCEL(n)----+                         ¦
¦                               +-WAIT(n)---+                            ¦
¦                                                                        ¦
+------------------------------------------------------------------------+

STOP TRACE

Cette commande arrête une trace active.

+------------------------------------------------------------------------+
¦                                                                        ¦
¦                                                                        ¦
¦ >>--STOP TRACE--(---PERFM-----)--------------------------------------> ¦
¦                   +-ACCTG---¦                                          ¦
¦                   +-STAT----¦                                          ¦
¦                   +-AUDIT---¦                                          ¦
¦                   +-MONITOR-¦                                          ¦
¦                   +-*-------+                                          ¦
¦                                                                        ¦
¦ >--------------------------------------------------------------------> ¦
¦    +-destination block-+  +-constraint block-+                         ¦
¦                                                                        ¦
¦ >------------------------------------------------------------------->< ¦
¦    +-COMMENT(string)-+                                                 ¦
¦ destination block:                                                     ¦
¦                                                                        ¦
¦          <-,-----+                                                     ¦
¦ >--DEST(----GTF----)-------------------------------------------------> ¦
¦           +-SMF-¦                                                      ¦
¦           +-SRV-¦                                                      ¦
¦           +-OPn-+                                                      ¦
¦ constraint block:                                                      ¦
¦                                                                        ¦
¦          +-*-------------+            +-*--------------------+         ¦
¦          ¦ <-,---------+ ¦            ¦ <-,----------------+ ¦         ¦
¦ >--PLAN(-----plan-name-----)--AUTHID(-----authorization-id-----)-----> ¦
¦                                                                        ¦
¦           +-*-----------+         +-*-----------+                      ¦
¦           ¦ <-,-------+ ¦         ¦ <-,-------+ ¦                      ¦
¦ >--CLASS(-----integer-----)--TNO(-----integer-----)------------------> ¦
¦                                                                        ¦
¦ >--LOCATION(---*-------------------)---------------------------------> ¦
¦              ¦ <-,-------------+ ¦                                     ¦
¦              +---location-name---¦                                     ¦
¦              +-<luname>----------¦                                     ¦
¦              +-ipaddr------------+                                     ¦
¦                                                                        ¦
+------------------------------------------------------------------------+

TERM UTILITY

Cette commande force l'arrêt d'un utilitaire actif. Attention aux conséquences. Mieux vaut RE-starter un utilitaire que de le stopper.
Ne passer cette commande que sur demande des experts

+------------------------------------------------------------------------+
¦                                                                        ¦
¦ >>--TERM UTILITY--(---utility-id------------)----------------------->< ¦
¦                     +-partial-utility-id*-¦                            ¦
¦                     +-*-------------------+                            ¦
¦                                                                        ¦
+------------------------------------------------------------------------+