image_pdfimage_print

 

BACKUP SYSTEM

                   .-FULL-----.
>>-BACKUP SYSTEM--+-----------+--+-----------------------+------------------>
                  ‘-DATA ONLY-‘  +-ESTABLISH INCREMENTAL-+
                                 ‘-END INCREMENTAL-------’

>--+---------------------------------------------------------------------+-->
   +--ALTERNATE_CP (copy-pool)--+-----------------+--+----------------+--+
                                ‘-DBBSG(stogroup)-‘  ‘-LGBSG(stogroup-‘
>--+-----------------------------------------------------------+----------->< +--FORCE----------------------------------------------------+ +--DUMP--+-------------------+--+-------+-------------------+ ǀ ‘- dumpclass-spec---+ ‘-FORCE-‘ ǀ ‘-DUMPONLY--+-------------------------+-+------------------+’ ‘- TOKEN- (X’byte-string’)’ ‘- dumpclass-spec –‘ dumpclass-spec: >--DUMPCLASS-(--dc1---)---------------------------------------------------->< ǀ-dc2-ǀ
              ǀ-dc3-ǀ
              ǀ-dc4-ǀ
              ǀ-dc5-ǀ

CATMAINT

>>-CATMAINT—UPDATE--+------------------------------------------------------->
                    ǀ                            ǀ
                    ‘—LEVEL—(--catalog-level--)--'
>--+------------------------------------------------+----------------------->
   ǀ        .--------------------------------------. ǀ
   ǀ        V                                      ǀ ǀ
   +-SCHEMA----SWITCH(schema_name,new_schema_name)-+-+
   ǀ                 .-,---------.                   ǀ
   ǀ                 V           ǀ                   ǀ
   ‘-OWNER—FROM--(----owner_name-+--)—TO ROLE--------’
>--+-------------------------------------------+-+-----------------------+->< ǀ      .---------------------------------.  ǀ ǀ_UTILX__BASIC__________ǀ
   ǀ      V                                 ǀ  ǀ        ǀ_EXTENDED_ǀ
   ‘-VCAT---SWITCH(vcat_name,new_vcat_name)-+-‘         ǀ_RESET____ǀ

CHECK DATA

               .--------------------------------------.
               V                                      ǀ
>>-CHECK--DATA----table-space-spec--+---------------+-+--------------------->
                                    ‘-PART--integer-‘ .
                                                    .--SHRLEVEL-REFERENCE-.
>-+-------------------------+----------+-+-------+--+---------------------+->
  ǀ-INCLUDE-XML-TABLESPACES-+---ALL----ǀ ‘-CLONE-‘  ‘--SHRLEVEL--CHANGE---’
                            ǀ-xml-spec-ǀ
               .-SCOPE--PENDING-----.
>--drain-spec--+--------------------+--------------------------------------->
               ‘-SCOPE--+-AUXONLY-+-‘
                        +-ALL-----+
                        ‘-REFONLY-‘
   .-AUXERROR--REPORT--------.
>--+-------------------------+---------------------------------------------->
   ‘-AUXERROR--INVALIDATE----’
   .-LOBERROR--REPORT-----.  .-XMLERROR--REPORT-----.
>--+----------------------+--+----------------------+----------------------->
   ‘-LOBERROR--INVALIDATE-‘  ‘-XMLERROR--INVALIDATE-‘

>--+-------------------------------------------------------+---------------->
   ǀ                 .-----------------------------------. ǀ
   ǀ                 V                                   ǀ ǀ
   ‘-FOR--EXCEPTION----IN--table-name1--USE--table-name2-+-‘
    .-DELETE--NO---------------.  .-EXCEPTIONS--0-------.
>--+---------------------------+--+---------------------+------------------->
   ǀ              .-LOG--YES-  ǀ  ‘-EXCEPTIONS--integer-‘
   ‘-DELETE--YES--+----------+-‘
                  ‘-LOG--NO--’
   .-ERRDNN--SYSERR-.
>--+----------------+------------------------------------------------------->
   ‘-ERRDNN--ddname-‘
   .-WORKDDN--SYSUT1--,--SYSUT2----------.
>--+-------------------------------------+---------------------------------->
   ‘-WORKDDN--+-ddname1--,--ddname2----+-‘
              ǀ          .-,--SYSUT2-. ǀ
              +-ddname1--+-----------+-+
              ǀ .-SYSUT1-.             ǀ
              ‘-+--------+--,--ddname2-‘
>--+------------------------+--+-----------------------+-------------------->
   ǀ           .-SYSPUNCH-. ǀ  ‘-SORTDEVT--device-type-‘
   ‘-PUNCHDDN--+-ddname---+-‘
>--+------------------+---------------------------------------------------->< ‘-SORTNUM--integer-‘

CHECK INDEX

>>-CHECK--INDEX------------------------------------------------------------->
>-+-LIST—listdef-name----------------------------------------------------+-->
  +-(-index-name-+--------------+-)--------------------------------------+
  ǀ              ‘-PART-integer-‘                                        ǀ
  ‘-(ALL)-TABLESPACE-+----------------+-table-space-name-+-------------+-‘
                     ‘-database-name.-‘                  ‘-PART-integer’
              .-SHRLEVEL--REFERENCE-.
>--+-------+--+---------------------+--------------------------->
   ‘-CLONE-‘  ‘-SHRLEVEL--CHANGE----’
   .-DRAIN_WAIT--IRLMRWT value-. .-RETRY--UTIMOUT value-.
>--+---------------------------+--+----------------------+------>
   ‘-DRAIN_WAIT--integer-------’ ‘-RETRY--integer-------’
                             .-WORKDDN--SYSUT1-.
>--+----------------------+--+-----------------+---------------------------->
   ‘-RETRY_DELAY--integer-‘  ‘-WORKDDN--ddname-‘
>--+-----------------------+--+------------------+-------------------------->
   ‘-SORTDEVT--device-type-‘  ‘-SORTNUM--integer-‘
>--+-----------------------+----------------------------------------------->< ‘-PARALLEL-num-subtasks-‘ 


CHECK LOB

                                     .-SHRLEVEL—REFERENCE-.
>>-CHECK—LOB--lob-table-space-spec--+---------------------+-----------------> 
                                    ‘-SHRLEVEL--CHANGE----’
               .-EXCEPTIONS--0-------.
>--drain-spec--+---------------------+-------------------------------------->
               ‘-EXCEPTIONS--integer-‘
>--+------------------------+--+-----------------------+-------------------->
   ǀ           .-SYSPUNCH-. ǀ  ‘-SORTDEVT--device-type-‘
   ‘-PUNCHDDN--+-ddname---+-‘
>--+------------------+----------------------------------------------------->
   ‘-SORTNUM--integer-‘

Lob-table-space-spec:
>-TABLESPACE-+---------------+-lob-table-space-name--+-------+-------------->
             ‘-database-name-‘                       ‘-CLONE-‘



drain-spec:
   .-DRAIN_WAIT--IRLMRWT value-. .-RETRY--UTIMOUT value-.
>--+---------------------------+--+----------------------++-----------------+>
   ‘-DRAIN_WAIT--integer-------’ ‘-RETRY--integer-------’ ‘-RETRY_DELAY-int-‘


COPY

                                         .-FULL--YES-----------.
>>-+-LIST--listdef-name--ǀ data-set-spec ǀ--+------------------+--------------------------------+----->
   ǀ                                        +-FULL--NO---------+                                ǀ
   ǀ                                        ‘-ǀ changelimit-spec ǀ-‘                            ǀ
   ǀ .-----------------------------------------------------------------------------------------+ǀ
   ǀ V                       .-FULL--YES------------.  .DSNUM--ALL----------.                  ǀ
   ‘---+-table-space-spec-+--+----------------------+--+--------------------+--data-set-spec-+-‘
       ‘-index-name-spec-‘   +-FULL--NO-------------+  ǀ                    ǀ
                             ‘-ǀ changelimit-spec ǀ-‘  ‘-DSNUM--integer-----'

>--+----------------------------------------------------------------+-------->
   ‘-PARALLEL-+---------------+-+---------------------------------+-‘
              ‘-(num-objects)-‘ ‘-TAPEUNITS--(--num-tape-units--)-‘

                 (2)  .-SYSTEMPAGES--YES-.
>--+-----------+------+------------------+----------------------------------->
   ‘-CHECKPAGE-‘      ‘-SYSTEMPAGES--NO--’

>--+--------------------------------------------------+--------------------->< ǀ .-NO---------. ǀ ‘-FLASHCOPY--+-YES--------+--+-------------------+-‘ ‘-CONSISTENT-‘ ‘-FGCOPYDDN(ddname)-‘ Concurrent-spec: >>-+-LIST--listdef-name--data-set-spec----------------------------------+---->
   ǀ .----------------------------------------------------------------. ǀ
   ǀ V                       .-DSNUM--ALL----------.                  ǀ ǀ
   ‘---+-table-space-spec-+--+---------------------+--data-set-spec-+-‘
       ‘-index-name-spec--'  ‘-DSNUM--integer------’

>--data-set-spec--FILTERDDN--(ddname)--CONCURRENT--------------------------->< Data-set spec: >>-+-COPYDDN(-+-ddname1-------+---------+-+-)-+------------------------------------------+-+----->< ǀ          ǀ               ‘-,ddname-‘ ǀ   ‘-RECOVERYDDN(-+-ddname3--+----------+-+-)-‘ ǀ
   ǀ          ‘-,ddname2------------------’                  ǀ          ‘-,ddname4-‘ ǀ     ǀ
   ǀ                                                         ‘-,ddname4--------------’     ǀ
   ‘-RECOVERYDDN(-ǀ-ddname3--+----------+-+-)----------------------------------------------’
                  ǀ           ‘-,ddname4-‘ ǀ
                  ‘-ddname4---------------’

COPYTOCOPY

>>-COPYTOCOPY--------------------------------------------------------------->
>--+-LIST--listdef-name--from-copy-spec--data-set-spec------+---+-------+--->
   ǀ .----------------------------------------------------. ǀ   ‘-CLONE-‘
   ǀ V                                                    ǀ ǀ
   ‘---+-ts-num-spec-----+--from-copy-spec--data-set-spec-+-‘
       ‘-index-name-spec-‘

ts-num-spec:
                                                     .-DSNUM--ALL----.
>>-TABLESPACE--+----------------+-table-space-name--+----------------+------>
               ‘-database-name.-‘                   ‘-DSNUM--integer-‘

Index-name-spec:
                                                            .-DSNUM-ALL----.
>>-+-INDEXSPACE-------+----------------+--index-space-name-++--------------+>
   ǀ                  ‘-database-name.-‘                   ǀ’-DSNUM-integer’
   ‘-INDEX--+-------------+--index-name--------------------’
            ‘-creator-id.-‘



From-copy-spec:
   .-FROMLASTCOPY-----------------------------------------------------.
>>-+------------------------------------------------------------------+---->< +-FROMLASTFULLCOPY-------------------------------------------------+ +-FROMLASTINCRCOPY-------------------------------------------------+ +-FROMLASTFLASHCOPY------------------------------------------------+ ‘-FROMCOPY-------dsn--+------------------------------------------+-‘ ‘-FROMVOLUME--+-CATALOG------------------+-‘ ‘-volser--+--------------+-‘ ‘-FROMSEQNO--n-‘ Data-set-spec >>-+-COPYDDN(-+-ddname1-------+---------+-+-)-+------------------------------------------+-+----->< ǀ          ǀ               ‘-,ddname-‘ ǀ   ‘-RECOVERYDDN(-+-ddname3--+----------+-+-)-‘ ǀ
   ǀ          ‘-,ddname2------------------’                  ǀ          ‘-,ddname4-‘ ǀ     ǀ
   ǀ                                                         ‘-,ddname4--------------’     ǀ
   ‘-RECOVERYDDN(-ǀ-ddname3--+----------+-+-)----------------------------------------------’
                  ǀ           ‘-,ddname4-‘ ǀ
                  ‘-ddname4---------------’

DIAGNOSE

>>-DIAGNOSE--+-diagnose statement-+----------------------------------------->< ‘-END----------------’ Diagnose-statement: >>-+---------------------+--------------------------------------------------->
   ǀ .-,-------.         ǀ
   ǀ V         ǀ         ǀ
   ‘-TYPE(---integer-+-)-‘
>--+------------------------------------+------------------------------------>
   ‘-ALLDUMPS-+-----------------------+-‘
              ǀ .-,-------------.     ǀ
              ǀ V               ǀ     ǀ
              ‘-(---X’abend-code’-+-)-‘
>--+-----------------------------------+------------------------------------->
   ‘-NODUMPS-+-----------------------+-‘
             ǀ .-,-------------.     ǀ
             ǀ V               ǀ     ǀ
             ‘-(---X’abend-code’-+-)-‘
>--+-------------------+--+----------------+--+-----------------+----------->< ‘-display statement-‘ ‘-wait statement-‘ ‘-abend statement-‘ Display-statement: >>-DISPLAY------------------------------------------------------------------->
>--+-OBD-+------------------+-table-space-name-+---------+-+-------+---+---->< ǀ ‘-database-name--.-‘ +-ALL-----+ ‘-CLONE-‘ ǀ ǀ +-TABLES--+ ǀ ǀ ‘-INDEXES-‘ ǀ +-SYSUTIL-----------------------------------------------------------+ +-MEPL--------------------------------------------------------------+ +-AVAILABLE---------------------------------------------------------+ ‘-DBET-+-DATABASE--database-name------------------------+-+-------+-‘ +-TABLESPACE-+----------------+-table-space-name-+ ‘-CLONE-‘ ǀ ‘-database-name.-‘ ǀ ‘-INDEX--index-name------------------------------’ Wait-statement: .---------------------------------------------------. V ǀ >>-WAIT----+-MESSAGE--message-id--+-------------------+------+-+------------->< ǀ ‘-INSTANCE--integer-‘ ǀ ‘-TRACEID--+-X’trace-id’-+--+-------------------+-‘ ‘-integer-----’ ‘-INSTANCE--integer-‘ Abend-statement: >>-ABEND--+-MESSAGE--message-id--+-------------------+------+--+--------+---->< ǀ                      ‘-INSTANCE--integer-‘      ǀ  ‘-NODUMP-‘
          ‘-TRACEID--+-X’trace-id’-+--+-------------------+-‘
                     ‘-integer-----’  ‘-INSTANCE--integer-‘

EXEC SQL

>>-EXEC--SQL--+-declare-cursor-spec--------------+--ENDEXEC----------------->< ‘-non-select dynamic SQL statement-‘ Declare-cursor-spec: >>-DECLARE--cursor-name--CURSOR--FOR--select-statement----------------------><

LISTDEF

                        .----------------.
                        V                ǀ
>>-LISTDEF--list-name------list-options--------------------------------------> 

List-options:
>-+INCLUDE+-+-----------+-+-LIST-ref-list-+-+---------------++----+-+-----+-+->
  ‘EXCLUDE’ ǀ           ǀ ‘-init-obj-spec-‘ ‘CLONED-+-YES-+-‘’-RI-‘ +-ALL-+
            ‘-type-spec-‘                           ‘-NO--’         +-BASE+
                                                                    +-LOB-+
                                                                    ‘-XML-‘

    .-DEFINED YES-.
>--+-------------+--+---------+----------------------------------------------->
   +-DEFINED NO--+  +-HISTORY-+
   ‘-DEFINED ALL-‘  ‘-ARCHIVE-‘

>--+----------------+--+-------------------+--------------------------------->< ‘-BASIC--+-NO--+-‘ ‘-EXTENDED--+-NO--+-‘ ‘-YES-‘ ‘-YES-‘ Init-obj-spec >>-+-DATABASE--database-name-+--+--------------------+----------------------->< +-table-space-spec--------+ ‘-PARTLEVEL--+-----+-‘ +-index-space-spec--------+ ‘-(n)-‘ +-table-spec--------------+ +-index-spec--------------+ Table-space-spec: TABLESPACE--+----------------+--table-space-name----------------------------->< ‘-database-name.-‘ Index-space-spec: >>-INDEXSPACE--+----------------+--index-space-name-------------------------->< ‘-database-name.-‘ Table-spec: >>-TABLE--+-------------+--table-name---------------------------------------->< ‘-creator-id.-‘ Index-space: >>-INDEX--+-------------+--index-name---------------------------------------->< ‘-creator-id.-‘


LOAD

         .-DATA-.  .-INDDN--SYSREC---------.
>>-LOAD--+------+--+-----------------------+--+-----------+------>
                   +-INDDN--ddname---------+  ‘-PREFORMAT-‘
                   +-INCURSOR--cursor-name-+ 

                                    .-PRESORTED--NO--.
>--+-----------------------------+--+----------------+----------->
   ǀ                 .-1-------. ǀ  ‘-PRESORTED--YES-‘
   ‘-COPYDICTIONARY--+-integer-+-‘


>--+------------------------------+--+--------------------+------>
   ‘-PARALLEL--+----------------+-‘  ‘-ROWFORMAT--+-BRF-+-‘
               ‘-(num-subtasks)-‘                 ‘-RRF-‘

>--+----------------------------------+--ǀ resume-spec ǀ--------->
   ‘-RBALRSN_CONVERSION--+-NONE-----+-‘
                         +-BASIC----+
                         ‘-EXTENDED-‘
>--ǀ flashcopy-spec ǀ--+----------------+--+-------+------------->
                       ‘-KEEPDICTIONARY-‘  ‘-REUSE-‘

   .-LOG--YES----------------.
>--+-------------------------+--ǀ workddn-spec ǀ----------------->
   ‘-LOG--NO--+------------+-‘
              ‘-NOCOPYPEND-‘

                   (1)
   .-SORTKEYS--0-------.                   .-FLOAT(S390)-.
>--+-------------------+--ǀ format-spec ǀ--+-------------+------->
   +-SORTKEYS--NO------+                   ‘-FLOAT(IEEE)-‘
   ‘-SORTKEYS--integer-‘

   .-EBCDIC--.
>--+---------+--+----------------------+--+--------+------------->
   +-ASCII---+  ǀ        .-,-------.   ǀ  ‘-NOSUBS-‘   
   ‘-UNICODE-‘  ǀ        V         ǀ   ǀ
                ‘-CCSID(---integer-+-)-‘

   .-ENFORCE-CONSTRAINTS-.  .-ERRDDN--SYSERR-.
>--+---------------------+--+----------------+------------------->
   ‘-ENFORCE--NO---------’  ‘-ERRDDN--ddname-‘ 

   .-MAPDDN--SYSMAP-.  .-DISCARDDN--SYSDISC-.
>--+----------------+--+--------------------+-------------------->
   ‘-MAPDDN--ddname-‘  ‘-DISCARDDN--ddname--’

   .-DISCARDS--0-------.
>--+-------------------+--+-----------------------+-------------->
   ‘-DISCARDS--integer-‘  ‘-SORTDEVT--device-type-‘

>--+------------------+------------------------------------------>
   ‘-SORTNUM--integer-‘

>--+-----------------------------------------------------+------->
   ‘-CONTINUEIF(start-+------+-)=-+-X’byte-string’-----+-‘
                      ‘-:end-‘    ‘-‘character-string’-‘

>--+--------------+--+-------------------+----------------------->
   ‘-IGNORE(WHEN)-‘  ‘-ǀ decfloat-spec ǀ-‘

>--+-------------------+----------------------------------------->
   ‘-ǀ override-spec ǀ-‘

   .-INDEXDEFER--NONE-------------------.
>--+------------------------------------+------------------------>
   ‘-INDEXDEFER--+-NPI-+--+-----------+-‘
                 ‘-ALL-‘  ‘-NONUNIQUE-‘

>--+-------------------------------+----------------------------->
   ‘-IMPLICIT_TZ—‘timezone-string’-‘

   .---------------------.
   V                     ǀ
>----ǀ INTO-TABLE-spec ǀ-+-------------------------------------->< Resume-spec: .-RESUME--NO--. .-SHRLEVEL-NONE-. >>-+------------+-+---------------+-+---------+--+---------+-+--------+-+->< ǀ ‘-REPLACE-‘ ‘copy-spec’ ‘-stats-‘ ǀ ǀ .-BACKOUT--NO------. .-SHRLEVEL--NONE---. ǀ ‘-RESUME--YES--+------------------+--+------------------+------------’ ǀ .-YES-. ǀ ‘-SHRLEVEL--CHANGE-‘ ‘-BACKOUT--+-----+-‘ Labelled-duration-expression >>-+-CURRENT_DATE--------------------------+------------------------------>
   ‘-CURRENT_TIMESTAMP--+----------------+-‘
                        ‘-WITH TIME ZONE-‘


   .-------------------------------------.
   V                                     ǀ
>----+- + -+--constant--+-YEAR---------+-+------------------>< ‘- - -‘ +-YEARS--------+ +-MONTH--------+ +-MONTHS-------+ +-DAY----------+ +-DAYS---------+ +-HOUR---------+ +-HOURS--------+ +-MINUTE-------+ +-MINUTES------+ +-SECOND-------+ +-SECONDS------+ +-MICROSECOND--+ +-MICROSECONDS-+ Workddn-spec: .-WORKDDN(SYSUT1,SORTOUT)--------------. >>-+--------------------------------------+------------------>
   ‘-WORKDDN--+-(ddname1,ddname2)-------+-‘
              ǀ          .-,SORTOUT-.   ǀ
              +-(ddname1-+----------+-)-+
              ǀ   .-SYSUT1-.            ǀ
              ‘-(-+--------+-,ddname2)--’

Copy-spec:
>>-+-------------------------------------+------------------->
   ǀ         .-(SYSCOPY)---------------. ǀ
   ‘-COPYDDN-+-------------------------+-‘
             +-(ddname1-+----------+-)-+
             ǀ          ‘-,ddname2-‘   ǀ
             ‘-(,ddname2)--------------’

>--+------------------------------------+------------------->< ‘-RECOVERYDDN(ddname3-+----------+-)-‘ ‘-,ddname4-‘ Flashcopy-spec: .-FLASHCOPY--NO-------------------------------------------------. >>-+---------------------------------------------------------------+->< ‘-FLASHCOPY--+-YES--------+--+--------------------------------+-‘ ‘-CONSISTENT-‘ ‘-FCCOPYDDN--(--template-name--)-‘ Stats-spec: >>-STATISTICS--+---------------------+--+---------------------+--->
               ‘-ǀ stat-table-spec ǀ-‘  ‘-ǀ stat-index-spec ǀ-‘

   .-REPORT--NO--.  .-UPDATE--ALL-----------.
>--+-------------+--+-----------------------+--------------------->
   ‘-REPORT--YES-‘  ‘-UPDATE--+-ACCESPATH-+-‘ 
                              +-SPACE-----+
                              +-NONE------+  
   .-INVALIDATECACHE-NO--.
>--+---------------------+--+-------------------------+------------>
   ‘-INVALIDATECACHE YES-‘  ‘-HISTORY--+-ALL--------+-‘
                                       +-ACCESSPATH-+
                                       +-SPACE------+
                                       ‘-NONE-------’

>--+----------------------+--------------------------------------->< ‘-FORCEROLLUP--+-YES-+-‘ ‘-NO--’ Stat-table-spec: .-TABLE--(--ALL--)-. >>-+-+-------------------+--+-----------------+--+-------------+-+->< ǀ ‘-SAMPLE--integer-‘ ‘-USE PROFILE-‘ ǀ ǀ .----------------------------------------------------. ǀ ǀ V ǀ ǀ ‘---TABLE--(--table-name--)--+-----------------------+-+------’ ‘-ǀ table-stats-spec ǀ-‘ Table-stats-spec: .-COLUMN—ALL--------------------. >>-+-----------------+--+-------------------------------+------->
   ‘-SAMPLE--integer-‘  ǀ            .-,-----------.    ǀ
                        ǀ            V             ǀ    ǀ
                        ‘-COLUMN--(----column-name-+--)-‘

>--+--------------------------------------------------------------+->< ǀ .-,--------------------------------------------------------. ǀ ǀ ǀ .-,-----------. ǀ ǀ ǀ V V ǀ ǀ ǀ +---COLGROUP--(----column-name-+--)--ǀ colgroup-stats-spec ǀ-+-+ ‘-USE PROFILE--------------------------------------------------’ Colgroup-stats-spec: >>-+--------------------------------------------+--------------->
   ‘-FREQVAL--+-------------------------------+-‘
              ǀ                (1)  .-MOST--. ǀ
              ‘-COUNT--integer------+-------+-‘
                                    +-BOTH--+
                                    ‘-LEAST-‘
>--+--------------------------------------+-------------------->< ǀ .-NUMQUANTILES--100-----. ǀ ‘-HISTOGRAM--+-----------------------+-‘ ‘-NUMQUANTILES--integer-‘ Stat-index-spec: .-INDEX--(--ALL--)-. >>-+--+--------------------ǀ correlation-stats-spec ǀ--------+->< ǀ .----------------------------------------. ǀ ǀ V ǀ ǀ ‘-INDEX--(----index-name--ǀ correlation-stats-spec ǀ-+--)-‘ Correlation-stats-spec: .-KEYCARD-----. >>-+-------------+--------------------------------------->


   .-FREQVAL--NUMCOLS--1--COUNT--10---------------------------------.
>--+----------------------------------------------------------------+-->
   ǀ .------------------------------------------------------------. ǀ
   ǀ V                                                            ǀ ǀ
   ‘---FREQVAL--NUMCOLS--integer--+-------------------------------+-+-‘
                                  ǀ                (2)  .-MOST--. ǀ

                                  ‘-COUNT--integer------+-------+-‘
                                                        +-BOTH--+
                                                        ‘-LEAST-‘
              .-NUMCOLS--1--NUMQUANTITIES--100--------------.
>--HISTOGRAM--+---------------------------------------------+-->< ǀ .-NUMQUANTILES--100-----. ǀ ‘-NUMCOLS--integer--+-----------------------+-‘ ‘-NUMQUANTILES--integer-‘ Format-spec: >>-+----------------------------------------------------------------------------------+->< ‘-FORMAT-+-UNLOAD----------------------------------------------------------------+-‘ +-SQL/DS----------------------------------------------------------------+ +-INTERNAL--------------------------------------------------------------+ ǀ .-COLDEL--‘,’----. .-CHARDEL--‘”’-----. .-DECPT--‘.’---. ǀ +-DELIMITED--+----------------+--+------------------+--+--------------+-+ ǀ ‘-COLDEL--coldel-‘ ‘-CHARDEL--chardel-‘ ‘-DECPT--decpt-‘ ǀ ‘-SPANNED--+-YES-+------------------------------------------------------’ ‘-NO--’ Decfloat-spec: >--+-----------------------------------------+----------------------->
   ‘-DECFLOAT_ROUNDMODE--+-ROUND_CEILING---+-‘
                         +-ROUND_DOWN------+
                         +-ROUND_FLOOR-----+
                         +-ROUND_HALF_DOWN-+
                         +-ROUND_HALF_EVEN-+
                         +-ROUND_HALF_UP---+
                         ‘-ROUND_UP--------'

Override-spec:
                  V------------------.
>>-OVERRIDE--(----+-SYSTEMPERIOD-----+-+--)------------------------->< +-IDENTITY---------+ +-TRANSID----------+ ‘-NONDETERMINISTIC-‘ INTO-TABLE-spec: >>-INTO--TABLE—table-name--+---------------+---+-----------------+------>
                           ‘PERIODOVERRIDE-‘   ‘-TRANSIDOVERRIDE-‘
   .-IGNOREFIELDS--NO--.
>--+-------------------+------------------------------------------------>
   ‘-IGNOREFIELDS--YES-‘

>--+-------------------------------------------------------------------------------+->
   ǀ                                           .-INDDN -SYSREC------------------.  ǀ
   ‘-PART—integer--+-----------+--resume-spec--+---------------------------------+-‘
                   ‘-PREFORMAT-‘               +-INDDN-ddname-+------------------+-+
                                               ǀ              ‘-DISCARDDN—ddname-‘ ǀ
                                               ‘-INCURSOR--cursor-name-------------’
>--+-----------------+---+--------------------------------------+------------------->
   ‘-NUMRECS—integer-‘   ‘-WHEN-+-SQL/DS=’table-name’-----------+-‘
                         ‘-field selection criterion-‘
>--+-----------------------------+------------------------------------------------>< ǀ .-,-------------------. ǀ ǀ V ǀ ǀ ‘-(---field specification-+-)-‘ >--+------------------------------------------------------------------------>< ǀ .-,-------------------. ǀ ǀ V ǀ ǀ ‘-(---field specification-+-)-‘ Resume-spec: .-RESUME--NO-----. >>-+-+----------------+-+-----------------------------------+-+------->
   ǀ                    ‘-REPLACE--+-------+--+-----------+-‘ ǀ
   ǀ                               ‘-REUSE-‘  ‘-copy-spec-‘   ǀ
   ‘-RESUME--YES----------------------------------------------’

>--+----------------+------------------------------------------>< ‘-KEEPDICTIONARY-‘ Field selection criterion: >>-+-field-name--------+--=--+-X’byte-string’-----+------------>< ‘-(start-+------+-)-‘ +-‘character-string’-+ ‘-:end-‘ +-G’graphic-string’--+ +-N’graphic-string’--+ Field specification: >>-field-name-spec-------------------------------------->

>--+--------------------------------------------------------------------------------->
   +-CHAR--+----------------------------------------------------------+--------------+
   ǀ       +-BIT-(length)-strip-spec----------------------------------+              ǀ
   ǀ       +-CCSID 1208—strip-spec------------------------------------+              ǀ
   ǀ       +-MIXED--strip-spec----------------------------------------+              ǀ
   ǀ       +-BLOBF-+---------------------+-+-----------+--------------+              ǀ
   ǀ       ǀ       ‘-PRESERVE WHITESPACE-‘ ‘-BINARYXML-‘              ǀ              ǀ
   ǀ       +-CLOBF-+-------+-+---------------------+-+--------------+-+              ǀ
   ǀ       ǀ       ‘-MIXED-‘ ‘-PRESERVE WHITESPACE-‘ ‘-CCSID 1208-‘   ǀ              ǀ
   ǀ       ‘-DBCLOBF-+---------------------+-+------------+-----------’              ǀ
   ǀ                 ‘-PRESERVE WHITESPACE-‘ ‘-CCSID 1200-‘                          ǀ
   +-VARCHAR--+--------------------------------------------------------+--strip-spec-+
   ǀ          +-BIT----------------------------------------------------+             ǀ
   ǀ          +-CCSID 1208---------------------------------------------+             ǀ
   ǀ          +-MIXED--------------------------------------------------+             ǀ
   ǀ          +-BLOBF-+---------------------+-+-----------+------------ǀ             ǀ
   ǀ          ǀ       ‘-PRESERVE WHITESPACE-‘ ‘-BINARYXML-‘            ǀ             ǀ
   ǀ          +-CLOBF-+----------------------------------------------+-+             ǀ
   ǀ          ǀ       ‘-+-------+-+---------------------+-+------------'             ǀ
   ǀ          ǀ         ‘-MIXED-‘ ‘-PRESERVE WHITESPACE-‘ ‘-CCSID 1208-‘             ǀ
   ǀ          ‘-DBCLOBF-+---------------------+-+------------+--------------’        ǀ
   ǀ                    ‘-PRESERVE WHITESPACE-‘ ‘-CCSID 1200-‘                       ǀ
   +-GRAPHIC-+----------+-+----------+-strip-spec-+------------+---------------------+
   ǀ         ‘-EXTERNAL-‘ ‘-(length)-‘            ‘-CCSID 1200-‘                     ǀ
   +-VARGRAPHIC--strip-spec--+------------+------------------------------------------+
   ǀ                         ‘-CCSID 1200-‘                                          ǀ
   +-SMALLINT------------------------------------------------------------------------+
   +-INTEGER-+-----------------------+-----------------------------------------------+
   ǀ         ‘-EXTERNAL-+----------+-‘                                               ǀ
   ǀ                    .-(length)-‘                                                 ǀ
   +-BIGINT--------------------------------------------------------------------------+
   +-BINARY-+----------+-strip-spec--------------------------------------------------+
   ǀ        ‘-(length)-‘                                                             ǀ
   +-+-VARBINARY------+--strip-spec--------------------------------------------------+
   ǀ ‘-BINARY VARYING-‘                                                              ǀ
   +-decimal-spec--------------------------------------------------------------------+
   +-FLOAT-+----------+-+----------+-------------------------------------------------+
   ǀ       ‘-EXTERNAL-‘ ‘-(length)-‘                                                 ǀ
   +-DATE--EXTERNAL--+---------------------+-----------------------------------------+
   ǀ                 ‘-(-+-length------+-)-‘                                         ǀ
   ǀ                     ‘-date-format-‘                                             ǀ
   +-TIME--EXTERNAL--+--------------------------+------------------------------------+
   ǀ                 ‘-(-+-length-----------+-)-‘                                    ǀ
   ǀ                     ‘-timestamp-format-‘                                        ǀ
   +-TIMESTAMP-WITH-TIME-ZONE--EXTERNAL--+----------+--------------------------------+
   ǀ                                     ‘-(length)-‘                                ǀ
   +-ROWID---------------------------------------------------------------------------+
   +-BLOB----------------------------------------------------------------------------+
   +-CLOB-+-----------------------+--------------------------------------------------+
   ǀ      ‘-MIXED--+------------+-‘                                                  ǀ
   ǀ               ‘-CCSID 1208-‘                                                    ǀ
   +-DBCLOB-+------------+-----------------------------------------------------------+
   ǀ        ‘-CCSID 1208-‘                                                           ǀ
   ǀ           .-(34)-------------------.                                            ǀ
   +-DECFLOAT--+------------------------+--------------------------------------------+
   ǀ           +-(16)-------------------+                                            ǀ

   ǀ           ‘-EXTERNAL--+----------+-‘                                            ǀ
   ǀ                       ‘-(length)-‘                                              ǀ
   ‘-XML--+---------------------+--+-----------+-------------------------------------'
          ‘-PRESERVE WHITESPACE-‘  ‘-BINARYXML-‘  

>--+--------------------------------------+------------------->< +-NULLIF--field selection criterion----+ ‘-DEFAULTIF--field selection criterion-‘ Field name spec: >>-field-name--+-----------------------------------+---------------->< +-POSITION(start-+------+-)---------+ ǀ ‘-:end-‘ ǀ ‘-CONSTANT(-+-‘string’----------+-)-‘ +-X’hex-string’-----+ +-integer-----------+ +-CURRENT DATE------+ +-CURRENT TIME------+ +-CURRENT TIMESTAMP-+ ‘-NULL--------------’ Strip-spec: >>-+-------------------------------------------+--------------------->
   ǀ        .-BOTH ----.                       ǀ
   ‘-STRIP--+----------+--+------------------+-‘
            +-TRAILING-+  ǀ             (1)  ǀ
            ‘-LEADING--’  +-‘strip-char’-----+
                          ‘-X’strip-char’----’
>--+----------+----------------------------------------------------->< ‘-TRUNCATE-‘ Decimal-spec: .-PACKED----------------------------. >>-DECIMAL-+-----------------------------------+-------------------->< +-ZONED-----------------------------+
           ‘-EXTERNAL-+----------------------+-‘
                      ǀ         .-,0-----.   ǀ
                      ‘-(length-+--------+-)-‘
                                ‘-,scale-‘

MERGECOPY

>>-MERGECOPY----------------------------------------------------------------->
>--+-LIST--listdef-name--------------------------------------------------+--->
   ǀ                                                  .-DSNUM--ALL-----. ǀ
   ‘-TABLESPACE--+----------------+-table-space-name--+----------------+-‘
                 ‘-database-name.-‘                   ‘-DSNUM--integer-‘
              .-WORKDDN--SYSUT1-.
>--+-------+--+-----------------+-------------------------------------------->
   ‘-CLONE-‘  ‘-WORKDDN--ddname-‘
     .-NEWCOPY--NO-.  .-COPYDDN--SYSCOPY-------------------.
>--+-+-------------+--+------------------------------------+-------------+->< ǀ                  +-COPYDDN(ddname1-+----------+-)-----+             ǀ
   ǀ                  ǀ                 ‘-,ddname2-‘       ǀ             ǀ
   ǀ                  +-COPYDDN(,ddname2)------------------+             ǀ
   ǀ                  ‘-RECOVERYDDN(ddname3-+--------+-)-‘ ǀ             ǀ
   ǀ                                        ‘,ddname4’     ǀ             ǀ
   ǀ             .-COPYDDN--SYSCOPY-----------.                          ǀ
   ‘-NEWCOPY-YES-+----------------------------+--+-+--------------------+’
                 +-COPYDDN(ddname1-+---------+-)-+ ‘-RECOVERYDDN(ddname3)’
                 ǀ                 ‘,ddname2-‘   ǀ              ‘,ddname4’
                 ‘-COPYDDN(,ddname2)-------------’

MODIFY RECOVERY

>>-MODIFY--RECOVERY--------------------------------------------------------->
>--+-LIST--listdef-name------------------------------+---------------------->
   ‘-TABLESPACE--+----------------+-table-space-name-‘
                 ‘-database-name.-‘
   .-DSNUM--ALL-----.
>--+----------------+--+-------+-------------------------------------------->
   ‘-DSNUM--integer-‘  ‘-CLONE-‘
>--+----------------+--+-------+-------------------------------------------->
   ‘-DELETDS-‘  ‘-NOCOPYPEND-‘
>--+-DELETE-+------------------+----------------------+-------------------->< ǀ        +-AGE-+-integer-+--+                      ǀ
   ǀ        ǀ     ‘-(*)-----’  ǀ                      ǀ
   ǀ        ‘-DATE-+-integer-+-‘                      ǀ
   ǀ               ‘-(*)-----’                        ǀ
   ‘-RETAIN----+-LAST--(--integer-)---------------+---'
               +-LOGLIMIT-------------------------+
               ‘-GDGLIMIT-+---------------------+-‘
                          +-LAST--(--integer--)-+
                          ‘-LOGLIMIT------------’


MODIFY STATISTICS

>>-MODIFY--STATISTICS------------------------------------------------------->
>--+-LIST-- listdef-name------------------------------+--------------------->
   +-TABLESPACE--+----------------+--table-space-name-+
   ǀ             ‘-database-name.-‘                   ǀ
   +-INDEXSPACE--+----------------+--index-table-name-+
   ǀ             ‘-database-name.-‘                   ǀ
   ‘-INDEX--+-------------+--index-name---------------’
            ‘-creator-id.-‘
>--DELETE-+-ALL--------+--+-AGE-+-(integer)-+--+--------------------------->< +-ACCESSPATH-+  ǀ     ‘-(*)-------’  ǀ
          ‘-SPACE------’  ‘-DATE-+-(integer)-+-‘
                                 ‘-(*)-------’


OPTIONS

>>-OPTIONS---------------------------------------------------------------->
>+-+---------+-+-----------------+-+-------------------+-+------------+-+->< ǀ ‘-PREVIEW-‘ ‘-LISTDEFD-ddname-‘ ‘-TEMPLATEDD-ddname-‘ ‘-event-spec-‘ ǀ +-OFF------------------------------------------------------------------+ ‘-KEY--key-value-------------------------------------------------------’ Event-spec .-ITEMERROR,HALT-. .-WARNING,RC4-. >>-EVENT--(--+----------------+--+---+--+-------------+--)---------------->< ‘-ITEMERROR,SKIP-‘  ‘-,-‘  +-WARNING,RC0-+
                                        +-WARNING,RC8-‘

QUIESCE

>>-QUIESCE------------------------------------------------------------------>
>--+-LIST—listdef-name----------------------------------------------------+->
   ǀ .------------------------------------------------------------------  ǀ
   ǀ V                                                                  ǀ ǀ
   ǀ---+-TABLESPACE-+----------------+-table-space-name-+--------------++-‘
       ǀ            ‘-database-name.-‘                  ‘-PART-integer-‘ ǀǀ
       ǀ-TABLESPACESET-+------------+-+----------------+-table-space-name-ǀ
                       ‘-TABLESPACE-‘ ‘-database-name.-‘
              .-WRITE--YES-.
>--+-------+--+------------+------------------------------------------------->< ‘-CLONE-‘  ‘-WRITE--NO--'

REBUILD INDEX

>>-REBUILD----------------------------------------------------------------------------->

                 .-,-------------------------------------------.
                 V                                             ǀ
>--+-INDEX--+-(----creatorid.index-name------+---------------+-+--)-+----------------+->
   ǀ        ǀ                                ‘-PART--integer-‘      ǀ                ǀ
   ǀ        +-(ALL)--table-space-spec-------------------------------+                ǀ
   ǀ        ‘-LIST--listdef-name------------------------------------’                ǀ
   ǀ                  .-,-----------------------------------------------.            ǀ
   ǀ                  V                                                 ǀ            ǀ
   ‘-INDEXSPACE--+-(----+----------------+--index-space-name--+--------------+-+--)-+’
                 ǀ      ‘-database-name.-‘                    ‘-PART—integer-‘      ǀ
                 +-(ALL)--table-space-spec------------------------------------------+
                 ‘-LIST--listdef-name-----------------------------------------------’

   .-SHRLEVEL--REFERENCE-----------.
>--+-------------------------------+--drain-spec--+-------+------------------->
   ‘-SHRLEVEL--CHANGE--change-spec-‘              ‘-CLONE-‘

   .-SCOPE--ALL-----.
>--+----------------+--+-------+--+-----------------------+------------------->
   ‘-SCOPE--PENDING-‘  ‘-REUSE-‘  ‘-SORTDEVT--device-type-‘

>--+------------------+--+------------+--------------------------------------->
   ‘-SORTNUM--integer-‘  ‘-stats-spec-‘

   .-FLASHCOPY--NO-------------------------------------------------.
>--+---------------------------------------------------------------+----------->
   ‘-FLASHCOPY--+-YES--------+--+--------------------------------+-‘
                ‘-CONSISTENT-‘  ‘-FCCOPYDDN--(--template-name--)-‘

   .-PARALLEL--(0)----------------.
>--+------------------------------+-------------------------------------------->
   ‘-PARALLEL--(--num-subtasks--)-‘

>--+----------------------------------+---------------------------------------->
   ‘-RBALRSN-CONVERSION--+-NONE-----+-‘
                         +-BASIC----+
                         ‘-EXTENDED-‘


Table-space-spec

>>-TABLESPACE--+----------------+--table-space-name-------------->
               ‘-database-name.-‘

>--+--------------+--------------------------------------------->< ‘-PART—integer-‘ Change-spec: .-MAXRO--integer-. .-LONGLOG--CONTINUE-. >>-+----------------+--+-------------------+--------------------->
   ‘-MAXRO--DEFER---’  +-LONGLOG--TERM-----+  
                       ‘-LONGLOG--DRAIN----’

   .-DELAY--1200----.
>--+----------------+-------------------------------------------->< ‘-DELAY--integer-‘ Drain-sec: .-DRAIN_WAIT--IRLMRWT value-. .-RETRY--UTIMOUT value-. >>-+---------------------------+--+----------------------+------->
   ‘-DRAIN_WAIT--integer-------’  ‘-RETRY--integer-------’

>--+----------------------+-------------------------------------->< ‘-RETRY_DELAY--integer-‘ Stats-spec: .-REPORT--NO--. >>-STATISTICS--+-------------+--correlation-stats-spec------------>
               ‘-REPORT--YES-‘

   .-UPDATE—ALL-------------.  .-INVALIDATECACHE NO--.
>--+------------------------+--+---------------------+------------>
   ‘-UPDATE--+-ACCESSPATH-+-‘  ‘-INVALIDATECACHE YES-‘
             +-SPACE -----+
             ‘-NONE-------’

>--+-------------------------+--+----------------------+--------->< ‘-HISTORY--+-ALL--------+-‘ ‘-FORCEROLLUP--+-YES-+-‘ +-ACCESSPATH-+ ‘-NO--’ +-SPACE -----+ ‘-NONE-------’ Correlation-stats-spec: .-KEYCARD-----. >--+-------------+---------------------------------------------->

   .-FREQVAL--NUMCOLS--1--COUNT--10-------------------------------------.
>--+--------------------------------------------------------------------+-->
   ǀ .----------------------------------------------------------------. ǀ
   ǀ V                                                                ǀ ǀ
   ‘---FREQVAL--NUMCOLS--integer--+---------------------------------+-+-‘
                                  ǀ                       .-MOST--. ǀ
                                  ‘-COUNT--integer--------+-------+-‘
                                                          +-BOTH--+
                                                          ‘-LEAST-‘

              .-NUMCOLS--1--NUMQUANTILES--100----------------.
>--HISTOGRAM--+----------------------------------------------+-->< ǀ                   .-NUMQUANTILES--100------. ǀ
              ǀ-NUMCOLS--integer--+------------------------+-‘
                                  ‘-NUMQUANTILES--integer-‘


RECOVER

>>-RECOVER------------------------------------------------------------------->
>--+-+-LIST—listdef-name------------------+--list-options-spec-+------------->
   ǀ ǀ .--------------------------------. ǀ                    ǀ
   ǀ ǀ V        .-DSNUM--ALL----------. ǀ ǀ                    ǀ
   ǀ ‘---object-+---------------------+-+-‘                    ǀ
   ǀ            ‘-DSNUM--integer------’                        ǀ
   ǀ         .-DSNUM--ALL----------.                           ǀ
   +-object--+---------------------+--recover-options-spec-----+
   ǀ         ‘-DSNUM--integer------’                           ǀ
   ‘-object--PAGE--page-number--+----------+-------------------’
                                ‘-CONTINUE-‘
                                .-LOGRANGES--YES-----.
>--+-------+--+--------------+--+--------------------+---------------------->< ‘-CLONE-‘ +-LOCALSITE----+ ǀ ǀ ‘-RECOVERYSITE-‘ ‘-LOGRANGES--NO------’ Object: >>-+-TABLESPACE--+----------------+-table-space-name-+---------------------->< ǀ ‘-database-name.-‘ ǀ +-INDEXSPACE--+----------------+-index-space-name-+ ǀ ‘-database-name.-‘ ǀ ‘-INDEX--+-------------+-index-name---------------’ ‘-creator-id.-‘ List-options-spec: .-BACKOUT--NO------. >>-+------------------+--------------------------------------------------->
   ǀ          .-YES-. ǀ
   ‘-BACKOUT--+-----+-‘
>--+-----------------------------------------------------------------+---->
   ǀ                       .-VERIFYSET--YES-.  .-ENFORCE--YES-.      ǀ
   +-TORBA—X’byte-string’--+----------------+--+--------------+------+
   ǀ                       ‘-VERIFYSET--NO--’  ‘-ENFORCE--NO--’      ǀ
   ǀ                            .-VERIFYSET--YES-.  .-ENFORCE--YES-. ǀ
   ‘-TOLOGPOINT—X’byte-string’--+----------------+--+--------------+-‘
                                ‘-VERIFYSET--NO--'  ‘-ENFORCE--NO--'
>--+-non-LOGONLY-options-spec-+------------------------------------------->< ‘-LOGONLY------------------’ Non-LOGONLY-options-spec: >>-+-------+--+-----------------+------------------------------------------>
   ‘-REUSE-‘  ‘-CURRENTCOPYONLY-‘
>--+----------------------------------------------------------------+------>
   ‘-PARALLEL-+---------------+-+---------------------------------+-‘
              ‘-(num-objects)-‘ ‘-TAPEUNITS--(--num-tape-units--)-‘
>--+-------------------------------+--------------------------------------->
   ‘-RESTOREBEFORE--X'byte-string’-‘
>--+--------------------------------+-------------------------------------->
   ‘-FROMDUMP--+------------------+-‘
               ‘-DUMPCLASS--(dcl)-‘
>--+-----------------------------+----------------------------------------->
   ‘-FLASHCOPY_PPRCP--+-NO-----+-‘
                      +-PMNO---+
                      +-PMPREF-+
                      +-PMREQ -+
>--+-------------------------+--------------------------------------------->
   ‘-ALTERNATE_CP(copy-pool)-‘

Recover-options-spec:
           .-DSNUM--ALL---------.
>>-object--+--------------------+------------------------------------------>
           ǀ                (1) ǀ
           ‘-DSNUM--integer-----’

>--+-TOCOPY--data-set--+-----------------+--tocopy-options-spec-+->< ǀ ‘-image-copy-spec-‘ ǀ +-TOLASTCOPY--topcopy-options-spec---------------------------+ +-TOLASTFULLCOPY--tocopy-options-spec------------------------+ ‘-ERROR--RANGE-----------------------------------------------’ Tocopy-options-spec .-ENFORCE--YES-. >>-+-------+--+-----------------+--+--------------+------------->
   ‘-REUSE-‘  ‘-CURRENTCOPYONLY-‘  ‘-ENFORCE--NO--'

>--+------------------------+----------------------------------->
   ‘-NOSYSCOPY--+---------+-‘
                +-INLCOPY-+
                ‘-FCCOPY--'

>--+----------------------------+------------------------------>< ‘-FLASHCOPY_PRCP--+-NO-----+-‘ +-PMNO---+ +-PMPREF-+ ‘-PMREQ –‘ Image-copy-spec: >>-TOVOLUME-+-CATALOG----------------------+------------------->< ‘-vol-ser-+------------------+-‘
                      ‘-TOSEQNO--integer-‘

REORG INDEX

>>-REORG--+-INDEX--LIST--listdef-name-+--+-------+--+-------+------------->
          ‘-index-name-spec-----------’  ‘-REUSE-‘   ‘-CLONE-‘

   .-SHRLEVEL NONE-----------------------------------------------.
>--+-------------------------------------------------------------+-------->
   ‘-SHRLEVEL-+-REFERENCE--deadline-spec--drain-spec-----------+-‘
              ‘-CHANGE--deadline-spec--drain-spec--change-spec-‘

   .-FASTSWITCH YES----.
>--+-------------------ǀ-------------------------------------------------->
   ‘-FASTSWITCH NO-----’

                                                   .-FORCE—NONE----.
>--+------------------------------------------+----+---------------+------->
   ‘-LEAFDISTLIMIT-+---------+-+------------+-‘    +-FORCE—READERS-+
                   ‘-integer-‘ ‘-REPORTONLY-‘      ‘-FORCE--ALL----’

   .-UNLOAD—CONTINUE-------.
>--+-----------------------+--+-----------------+-------------------------->
   ‘-UNLOAD--+-PAUSE-----+-‘  ‘-stats-spec------'
             ‘-ONLY------’
   .-WORKDDN--(SYSUT1)-.
>--+-------------------+--+-----------+------------------------------------>
   ‘-WORKDDN--(ddname)-‘  ‘-PREFORMAT-‘
>--+--------------------------------------------------+------------------->< ǀ .-NO---------. ǀ ‘-FLASHCOPY--+-YES--------+--+-------------------+-‘ ‘-CONSISTENT-‘ ‘-FCCOPYDDN(ddname)-‘ >--+----------------------------------+----------------------------------->< ‘-RBALRSN_CONVERSION--+-NONE-----+-‘ +-BASIC----+ ‘-EXTENDED-‘ Index-name-spec >>-+-INDEX-+-------------+-index-name---------------+----------------------> 
   ǀ       ‘-creator-id.-‘                          ǀ
   ‘-INDEXSPACE-+----------------+-index-space-name-‘
                ‘-database-name.-‘
>--+---------------+------------------------------------------------------>< ‘-PART--integer-‘ Deadline-spec .-DEADLINE--NONE----------------------------. >>-+-------------------------------------------+-------------------------->< .-DEADLINE--+-timestamp-------------------+-‘ ‘-labeled-duration-expression-‘ Drain-spec >>-+---------------------+--------+----------------+----------------------->
   ‘-DRAIN_WAIT--integer-'        ‘-RETRY--integer-‘


                                    _TIMEOUT TERM---
>--+----------------------+--------ǀ----------------(--------------------->< ‘-RETRY_DELAY--integer-‘ ǀ-TIMEOUT ABEND__ǀ Change-spec .-DRAIN--ALL-----. >>-+------------------------+--+----------------+--------------------------->
   ǀ                    (1) ǀ  ‘-DRAIN--WRITERS-‘
   ‘-MAXRO--+-integer-+-----'
            ‘-DEFER---’

   .-LONGLOG--CONTINUE--.  .-DELAY--1200----.
>--+--------------------+--+----------------+------------------------------->
   ‘-LONGLOG--+-TERM--+-‘  ‘-DELAY--integer-‘
              ‘-DRAIN-‘

   .-LOGRANGES--YES-.
>--+----------------+------------------------------------------------------->
   ‘-LOGRANGES--NO--'

   .-SWITCHTIME--NONE---------------------------------------------------.
>--+--------------------------------------------------------------------+->< ǀ .-NEWMAXRO--NONE----. ǀ ‘-SWITCHTIME--+-timestamp-------------------+--+-------------------+-‘ ‘-labeled-duration-expression-‘ ‘-NEWMAXRO--integer-‘ Labelled-duration-expression >>-+-CURRENT_DATE------------------------------------------------------------>
   ‘-CURENT_TIMESTAMP---+----------------+-----'
                        ‘-WITH TIME ZONE-‘
   .-------------------------------------.
   V                                     ǀ
>----+- + -+--constant--+-YEAR---------+-+---------------------------------->< +-YEARS--------+ +-MONTH--------+ +-MONTHS-------+ +-DAY----------+ +-DAYS---------+ +-HOUR---------+ +-HOURS--------+ +-MINUTE-------+ +-MINUTES------+ +-SECOND-------+ +-SECONDS------+ +-MICROSECOND--+ +-MICROSECONDS-+ Stats-spec .-REPORT--NO--. >>-STATISTICS--+-------------+--correlation-stats-spec----------------------->
               ‘-REPORT--YES-‘
   .-UPDATE-ALL-------------.
>--+------------------------+--+-------------------------+------------------->
   ‘-UPDATE--+-ACCESSPATH-+-‘  ‘-HISTORY--+-ALL--------+-‘
             +-SPACE------+               +-ACCESSPATH-+
             ‘-NONE-------'               +-SPACE------+
                                          ‘-NONE-------'
>--+----------------------+------------------------------------------------->< ‘-FORCEROLLUP--+-YES-+-‘ ‘-NO--' Correlation-stat-spec .-FREQVAL--NUMCOLS--1--COUNT--10-----------------. >>-+---------+---------------------------------------+----------------------->< ‘-KEYCARD-‘ ǀ .------------------------------------------. ǀ ǀ V ǀ ‘-----FREQVAL--NUMCOLS--integer--COUNT—integer-+-‘ .-NUMCOLS--1--NUMQUANTILES—100----------------. >--HISTOGRAM--+---------------------------------------------+-->
              ǀ                   .-NUMQUANTILES--100-----. ǀ
              ‘-NUMCOLS--integer--+-----------------------+-‘
                                  ‘-NUMQUANTILES--integer-‘


REORG TABLESPACE

>>-REORG—TABLESPACE---------------------------------------------------------->
                     .-PARALLEL-YES-.
>-+-LIST-listdef-name-+ -------------+----------------------------------+--->
  ǀ                  ‘-PARALLEL-NO--'                                   ǀ
  ‘-+----------------+-table-space-name-+-----------------------------+-‘
    ‘-database-name.-‘                  ǀ      .-,---------------------.ǀ
                                        ǀ      V                       ǀǀ
                                        ‘-PART---+-integer-----------+-+’
                                                 ‘-integer1:integer2-‘

                         .-SCOPE ALL-----.
>--+-------+--+-------+--+---------------+----------------------------------->
   ‘-CLONE-‘  ‘-REUSE-‘  ‘-SCOPE PENDING-‘

                                            _DROP PART NO__
>--+---------------------------------+-----ǀ---------------ǀ----------------->
   ǀ            .-SORTCLUSTER--NO--. ǀ     }_DROP PART YES_ǀ
   ‘-REBALANCE--+------------------+-‘
                ‘-SORTCLUSTER--YES-‘


                             .-YES-.     
   .-LOG--YES-.  .-SORTDATA--+-NO--+-.
>--+----------+--+-------------------+--+----------+------------------------->
   ‘-LOG--NO--’                         ‘-NOSYSREC-‘
                  .-AUTOESTSPACE YES-.
>--ǀ copy-spec ǀ--+------------------+--------------------------------------->
                  ‘-AUTOESTSPACE NO--’

  .-SHRLEVEL NONE-------------------------------------------------------.
>--------------------------------------------------------------------------->
  ‘-SHRLEVEL--+-REFERENCE--ǀ deadline-spec ǀ--ǀ drain-spec ǀ--------------+->
              ‘-CHANGE-ǀdeadline-specǀ--ǀdrain-specǀ--ǀtable-change-specǀ-‘

   .-FASTSWITCH YES-.  .-AUX NO--.     .-FORCE--NONE----.
>--+----------------+--+---------+-----+----------------+------------------->
   ‘-FASTSWITCH NO--.  –‘AUX YES-‘     +-FORCE--READERS-+
                                       ‘-FORCE--ALL-----’

>--+------------------+----------------------------------------------------->
   +-SORTNPSI--AUTO---+
   +-SORTNPSI--YES----+
   ‘-SORTNPSI--NO-----’

>--+-------------------------------------------------------------------+----->
   ǀ               .-10------.              .-10------.                ǀ
   ‘-OFFPOSTLIMIT--+---------+-INDREFLIMIT--+---------+-+------------+-‘
                   ‘-integer-‘              ‘-integer-‘ ‘-REPORTONLY-‘
     .-UNLOAD--CONTINUE--.
>--+-+-------------------+--+----------------+--+---------------------+-+--->
   ǀ ǀ               (1) ǀ  ‘-KEEPDICTIONARY-‘  ‘-ǀ statistics-spec ǀ-‘ ǀ
   ǀ ‘-UNLOAD--PAUSE-----'                                              ǀ
   +-UNLOAD--ONLY-------------------------------------------------------+
   ‘-UNLOAD--EXTERNAL--+-------+--+-------------------------+-----------'
                       ‘-NOPAD-‘  ǀ .---------------------. ǀ
                                  ǀ V                     ǀ ǀ
                                  ‘---ǀ FROM-TABLE-spec ǀ-+-‘



   .-PUNCHDDN--SYSPUNCH-.  .-DISCARDDN--SYSDISC-.
>--+--------------------+--+--------------------+---------------------------->
   ‘-PUNCHDDN--ddname---'  ‘-DISCARDDN--ddname--’
>--+------------------------------+------------------------------------------>
   ‘-ǀ reorg tablespace options ǀ-‘
>--+---------------------------------------------+--------------------------->
   ǀ                     .---------------------. ǀ
   ǀ                     V                     ǀ ǀ
   ‘-DISCARD--+-------+----ǀ FROM-TABLE-spec ǀ-+-‘
              ‘-NOPAD-‘
   .-PARALLEL—0-------------------.
>--+------------------------------+------------------------------------------>
   ‘-PARALLEL--(--num-subtasks--)-‘


Copy-spec

   .-COPYDDN(SYSCOPY)---------------------.
>>-+--------------------------------------+---------------------------------->
   ‘-COPYDDN(-+-ddname1--+----------+-+-)-‘
              ǀ          ‘-,ddname2-‘ ǀ
              ‘-,ddname2--------------’
>--+-----------------------------------+------------------------------------->
   ‘-RECOVERDDN(ddname3-+----------+-)-‘
                        ‘-,ddname4-‘
>--+--------------------------------------------------+--------------------->< ǀ .-NO---------. ǀ ‘-FLASHCOPY--+-YES--------+--+-------------------+-‘ ‘-CONSISTENT-‘ ‘-FCCOPYDDN(ddname)-‘ Deadline-spec .-DEADLINE--NONE----------------------------. >>-+-------------------------------------------+---------------------------->< ‘-DEADLINE--+-timestamp-------------------+-‘ ‘-labeled-duration-expression-‘ Drain-spec >>-+---------------------+------+----------------+-------------------------->
   ‘-DRAIN_WAIT--integer-‘      ‘-RETRY--integer-‘

                                 .-TIMEOUT--TERM--.
>--+----------------------+------+----------------+------------------------->
   ‘-RETRY_DELAY--integer-‘      ‘-TIMEOUT--ABEND-‘

   .-LOGRANGES--YES-.  .-DRAIN_ALLPARTS--NO--.
>--+----------------+--+---------------------+------------------------------->
   ‘-LOGRANGES--N0--’  ‘-DRAIN_ALLPARTS--YES-‘

   .-SWITCHTIME--NONE---------------------------------------------------.
>--+--------------------------------------------------------------------+->< ǀ .-NEWMAXRO--NONE----. ǀ ‘-SWITCHTIME--+-timestamp-------------------+--+-------------------+-‘ ‘-labeled-duration-expression-‘ ‘-NEWMAXRO--integer-‘ Change-spec: .-MAXRO--------------. .-DRAIN--ALL-----. >>-+--------------------+--+----------------+------------------------------>
   ‘-MAXRO--+-integer-+-‘  ‘-DRAIN--WRITERS-‘
            ‘-DEFER---’

   .-LONGLOG--CONTINUE--.  .-DELAY--1200----.
>--+--------------------+--+----------------+------------------------------>
   ‘-LONGLOG--+-TERM--+-‘  ‘-DELAY--integer-‘
              ‘-DRAIN-‘

Map-spec:
>>-+--------------------------------+-------------------------------------->< +-MAPPINGTABLE--table-name-------+ +-MAPPINGDATABASE--database-name-‘ Labelled-duration-expression >>-+-CURRENT_DATE----------------------------------------------------------->
   ‘-CURRENT_TIMESTAMP---+----------------+-----'
                         ‘-WITH TIME ZONE-‘
   .-------------------------------------.
   V                                     ǀ
>----+- + -+--constant--+-YEAR---------+-+--------------------------------->< +-YEARS--------+ +-MONTH--------+ +-MONTHS-------+ +-DAY----------+ +-DAYS---------+ +-HOUR---------+ +-HOURS--------+ +-MINUTE-------+ +-MINUTES------+ +-SECOND-------+ +-SECONDS------+ +-MICROSECOND--+ +-MICROSECONDS-+ Statistics-spec >>-STATISTICS---------------------------------------------------------------->
     .-TABLE--(--ALL--)-.
>--+-+------------------+--+-----------------+---------+--------------------->
   ǀ                       ‘-SAMPLE--integer-‘         ǀ
   ǀ .-----------------------------------------------. ǀ
   ǀ V                                               ǀ ǀ
   ‘---TABLE--(--table-name--)--ǀ table-stats-spec ǀ-+-‘

     .-INDEX--(--ALL--)-.
>--+-+------------------+--ǀ correlation-stats-spec ǀ--------+--------------->
   ǀ           .-,--------------------------------------.    ǀ
   ǀ           V                                        ǀ    ǀ
   ‘-INDEX--(----index-name--ǀ correlation-stats-spec ǀ-+--)-‘

   .-REPORT--NO--.  .-UPDATE—ALL-------------.
>--+-------------+--+------------------------+------------------------------->
   ‘-REPORT--YES-‘  ‘-UPDATE--+-ACCESSPATH-+-‘
                              +-SPACE------+
                              ‘-NONE-------’

>--+-------------------------+--+----------------------+--------------------->< ‘-HISTORY--+-ALL--------+-‘ ‘-FORCEROLLUP--+-YES-+-‘ +-ACCESSPATH-+ ‘-NO--' +-SPACE------+ ‘-NONE-------’ Stat-table-spec .-TABLE--(--ALL--)-. >>-+-+------------------+--+-----------------+--+-------------+-+->< ǀ ‘-SAMPLE--integer-‘ ‘-USE PROFILE-‘ ǀ ǀ .---------------------------------------------------. ǀ ǀ V ǀ ǀ ‘---TABLE--(--table-name--)--+----------------------+-+------’ ‘-ǀ table-stats-spec ǀ-‘ Table-stats-spec .-COLUMN--ALL-------------------. >>-+-----------------+--+-------------------------------+-------->
   ‘-SAMPLE--integer-‘  ǀ            .-,-----------.    ǀ
                        ǀ            V             ǀ    ǀ
                        ‘-COLUMN--(----column-name-+--)-‘

>--+--------------------------------------------------------------+->< ǀ .-,--------------------------------------------------------. ǀ ǀ ǀ .-,-----------. ǀ ǀ ǀ V V ǀ ǀ ǀ +---COLGROUP--(----column-name-+--)--ǀ colgroup-stats-spec ǀ-+-+ ‘-USE PROFILE--------------------------------------------------’ Colgroup-stats-spec: >>-+--------------------------------------------+------------->
   ‘-FREQVAL--+-------------------------------+-‘
              ǀ                     .-MOST--. ǀ
              ‘-COUNT--integer------+-------+-‘
                                    +-BOTH--+
                                    ‘-LEAST-‘

>--+--------------------------------------+-------------------->< ǀ .-NUMQUANTILES--100-----. ǀ ‘-HISTOGRAM--+-----------------------+-‘ ‘-NUMQUANTILES--integer-‘ Stat-index-spec .-INDEX--(--ALL--)-. >>-+-+------------------+--ǀ correlation-stats-spec ǀ--------+->< ǀ .-,--------------------------------------. ǀ ǀ V ǀ ǀ ‘-INDEX--(----index-name--ǀ correlation-stats-spec ǀ-+--)-‘ Correlation-stats-spec: .-KEYCARD-----. >>-+-------------+------------------------------------------------>

   .-FREQVAL--NUMCOLS--1--COUNT—10-------------------------------------.
>--+-------------------------------------------------------------------+->
   ǀ .---------------------------------------------------------------. ǀ
   ǀ V                                                               ǀ ǀ
   ‘---FREQVAL--NUMCOLS--integer--+--------------------------------+-+-‘
                                  ǀ                      .-MOST--. ǀ
                                  ‘-COUNT--integer-------+-------+-‘
                                                         +-BOTH--+
                                                         ‘-LEAST-‘

              .-NUMCOLS--1--NUMQUANTILES—100----------------.
>--HISTOGRAM--+---------------------------------------------+-->
              ǀ                   .-NUMQUANTILES--100-----. ǀ
              .-NUMCOLS--integer--+-----------------------+-’
                                  ‘-NUMQUANTILES--integer-‘


FROM-TABLE spec

>>-FROM--TABLE--table-name--------------------------------------------------->
>--+--------------------------------------+--------------------------------->< ‘-WHEN--(--selection-condition-spec--)-‘ Selection-condition spec >>-+-predicate-----------+-------------------------------------------------->
   ‘-selection condition-‘
    .--------------------------------------.
    V                                      ǀ
>----+-----------------------------------+-+------------------------------->< ‘-+-AND-+--+-predicate------------+-‘ ‘-OR--’ ‘-selection condition-‘ Predicate >>-+-basic predicate---+--------------------------------------------------->< +-BETWEEN predicate-+ +-IN predicate------+ +-LIKE predicate----+ ‘-NULL predicate----’ Basic predicate >>-column-name--+- = --+---------------------------------------------------->
                +- <> -+
                +- > --+
                +- < --+ +- >= -+
                ‘- < = -‘ >--+-constant--------------------+----------------------------------------->< ‘-labeled-duration-expression-‘ Between predicate >>-column-name--+-----+--BETWEEN-------------------------------------------->
                ‘-NOT-‘
>--+-constant--------------------+--AND------------------------------------->
   ‘-labeled-duration-expression-‘
>--+-constant--------------------+----------------------------------------->< ‘-labeled-duration-expression-‘ IN predicate .-,--------. V ǀ >>-column-name--+-----+--IN--(---constant-+-)------------------------------>< ‘-NOT- ‘ LIKE predicate >>-column-name--+-----+--LIKE--string-constant------------------------------>
                ‘-NOT-‘
>--+-------------------------+--------------------------------------------->< ‘-ESCAPE--string-constant-‘ NULL predicate >>-column-name--IS--+-----+--NULL------------------------------------------>< ‘-NOT-‘ Reorg tablespace options .-UNLDDN--SYSREC-. >>-+----------------+--+-----------------------+---------------------------->
   ‘-UNLDDN--ddname-‘  ‘-SORTDEVT--device-type-‘
>--+------------------+--+-----------+-+-----------------+------------------>
   ‘-SORTNUM--integer-‘  ‘-PREFORMAT-‘ ‘-ROWFORMAT-+-BRF-‘
                                                   ǀ-RRF-ǀ
>--+----------------------------------+------------------------------------>< ‘-RBALRSN_CONVERSION--+-NONE-----+-‘
                         +-BASIC----+
                         ‘-EXTENDED-‘

REPAIR

>>-REPAIR------------------------------------------------------------------->
>--+---------------------------------------------------+-------------------->
   ǀ                             .-------------------. ǀ
   ǀ .-OBJECT-. .-LOG--YES-.     V                   ǀ ǀ
   +-+--------+-+----------+-+---+-set statement-+-+-+-+
   ǀ            ‘-LOG--NO--' ǀ   ‘-locate block--’   ǀ ǀ
   ǀ                         ǀ   ‘-dbd-statement-----’ ǀ
   +-level-id statement--------------------------------+
   +-versions statement--------------------------------+
   ‘-catalog statement---------------------------------+
>--+-------+--------------------------------------------------------------->< ‘-CLONE-‘ Level-id statement >>-LEVELID------------------------------------------------------------------>
>--+-TABLESPACE--+----------------+-table-space-name-+---------------------->
   ǀ             ‘-database-name.-‘                  ǀ
   ‘-index-name-spec---------------------------------’
>--+---------------+------------------------------------------------------->< ‘-PART--integer-‘ Versions statement >>-VERSIONS----------------------------------------------------------------->
>--+-TABLESPACE--+----------------+-table-space-name-+--------------------->< ǀ ‘-database-name.-‘ ǀ ‘-index-name-spec---------------------------------’ Catalog statement >>-CATALOG--TABLESPACE--+----------------+-table-space-name----------------->
                        ‘-database-name.-‘
>--+------+----------------------------------------------------------------->
   ‘-TEST-‘


Index-name spec
>>-+-INDEX-+-------------+-index-name---------------+---------------------->< ǀ ‘-creator-id.-‘ ǀ ‘-INDEXSPACE-+----------------+-index-space-name-‘ ‘-database-name.-‘ Set statement >>-SET--------------------------------------------------------------------------------->

>+-ǀtable-space-specǀ-+---------------+-+-NOCOPYPEND------+-----------------------+---->< ǀ ‘-PART--integer-‘ +-NORCVRPEND------+ ǀ ǀ +-NOCHECKPEND-----+ ǀ ǀ +-NOAUXWARN-------+ ǀ ǀ +-NOAUXCHKP-------+ ǀ ǀ +-NOAREORPENDSTAR-+ ǀ ǀ +-NOAREORPEND-----+ ǀ ǀ +-PRO-------------+ ǀ ǀ +-NOPRO-----------+ ǀ ‘-+-INDEX-+-(index-name-+---------------+-)-+----------- +-+-NOCOPYPEND------+-‘ ǀ ǀ ‘-PART--integer-‘ ǀ ǀ +-NORCVRPEND------+ ǀ ‘-(--ALL--)--ǀ table-space-spec ǀ-‘ ǀ +-NORBDPEND-------+ ‘-INDEXSPACE-+-(-+-----------+-index-space+-----------+)-+-NOCHECKPEND-----+ ǀ ‘-database.-‘ ‘-PART-int’ ǀ +-NOAREORPENDSTAR-+ ‘-(--ALL--)—table-space-spec-------------’ +-NOAREORPEND-----+ +-RBDPEND---------+ ‘-PSRBDPEND-------’ Table-space-spec: >>-TABLESPACE--+----------------+-table-space-name---------------------------->< ‘-database-name.-‘

REPORT

>>-REPORT------------------------------------------------------------------->
                                                 .-INDEX NONE-.
>-+-RECOVERY-+-TABLESPACE+-LIST-listdef-name---+-+-----------+-+-+----+-+-->< ǀ ǀ ‘-tablespace-name-spec’ ‘-INDEX ALL-‘ ǀ ‘info’ ǀ ǀ ‘-index-list-spec---------------------------------’ ǀ ‘-TABLESPACESET--+------------+--table-space-name-spec--+----------+--’ ‘-TABLESPACE-‘ ‘-SHOWDSNS-‘ Index-list-spec >>-+-INDEXSPACE--+-+----------------+-index-space-name-+-+----------------->< ǀ ǀ ‘-database-name.-‘ ǀ ǀ ǀ ‘-LIST—listdef-name-------------------’ ǀ ‘-INDEX--+-+-------------+-index-name-+---------------’ ǀ ‘-creator-id.-‘ ǀ ‘-LIST--listdef-name---------’ Info-options .-DSNUM--ALL-----. >>-+----------------+--+---------+--+---------+----------------------------->
   ‘-DSNUM--integer-‘  ‘-CURRENT-‘  ‘-SUMMARY-‘
                                    .-ARCHLOG--1-------.
>--+-----------+--+--------------+--+------------------+------------------->< ‘-LOCALSITE-‘ ‘-RECOVERYSITE-‘ ‘-ARCHLOG--+-2---+-‘ ‘-ALL-‘ Table-space-name-spec >>-+----------------+--table-space-name------------------------------------>< ‘-database-name.-‘


RESTORE SYSTEM

>>-RESTORE SYSTEM-------------------------------------------------------->
>--+-ǀ non-LOGONLY spec ǀ---------------------------------------+------->< ‘-LOGONLY--+-----------------------------------------------+-‘ ‘-SWITCH VCAT--+--------------------------+-‘ ‘-SYSVALUEDDN(ddname)-‘ Non-LOGONLY spec >>-+-------------------------+------------------------------------------->
   ‘-ALTERNATE_CP(copy-pool)-‘
>--+--------------------------------+------------------------------------>
   ‘-RESTOREBEFORE-- X’byte-string’-‘
>-+--------------------------------------------------------------------+->
  +-FROMDUMP-+-----------------++-----------------++-------------------+-+
  ǀ          ‘-DUMPCLASS-(dcl)-‘’-RSA-(key-label)-‘‘—TAPEUNITS-+-------+-‘
  ǀ                                                            ‘units’   ǀ
  ‘-FLASHCOPY_PPRCP--+-NO-----+------------------------------------------’
                     +-PMNO---+
                     +-PMPREF-+
                     ‘-PMREQ –‘


RUNSTATS

>>-RUNSTATS--TABLESPACE--+-ǀ listdef-spec ǀ-----+----------------------->
                         ‘-ǀ table-space-spec ǀ-‘

   .-ǀ statistics-spec ǀ-. 
>--+---------------------+--------------------------------------------->< ‘-ǀ reset-spec ǀ------’ Listdef-spec .-INVALIDATECACHE NO--. >>-LIST--listdef-name--+---------------------+------------------------->< ‘-INVALIDATECACHE YES-‘ Table-space-spec >>-+----------------+-table-space-name---------------------------------->
   ‘-database-name.-‘

>--+-------------------------------------+------------------------------>
   ǀ                .-FORCEROLLUP--NO--. ǀ
   ‘-PART--integer--+------------------+-‘
                    ‘-FORCEROLLUP--YES-‘

   .-INVALIDATECACHE NO--.
>--+---------------------+--------------------------------------------->< ‘-INVALIDATECACHE YES-‘ Statistics-spec >>-+--------------------------------------------------+----------------->
   ǀ             .-(ALL)-.                            ǀ
   +-TABLE-------+-------+--ǀ all-tables-spec ǀ-------+
   ǀ .-,--------------------------------------------. ǀ
   ǀ V                                              ǀ ǀ
   ‘---TABLE------table-name--ǀ named-tables-spec ǀ-+-‘

>--+-------------------------------------------------------------+-->
   ‘-+-INDEX------(--ALL--)--ǀ correlation-stats-spec ǀ--------+-‘
     +-INDEX--(--*------)--ǀ correlation-stats-spec ǀ----------+
     ǀ           .-,--------------------------------------.    ǀ
     ǀ           V                                        ǀ    ǀ
     ‘-INDEX--(----index-name--ǀ correlation-stats-spec ǀ-+--)-‘
                       
                       .-REGISTER--YES-.
   .-SHRLEVEL--CHANGE -+---------------+-.
   ǀ                   ‘-REGISTER--NO--’ ǀ  .-REPORT--NO--.
>--+-------------------------------------+--+-------------+----->
   ‘-SHRLEVEL--REFERENCE-----------------’  ‘-REPORT--YES-‘

   .-UPDATE--ALL----------------.
>--+----------------------------+----ǀ history-spec ǀ----------->
   ‘---UPDATE--+-ACCESSPATH-+---’
               +-SPACE------+
               ‘-NONE-------’

>--+-----------------------+----------------------------------->< ‘-SORTDEVT--device-type-‘ All-tables-spec >>---+-ǀ sample-spec ǀ--+----------------------+-+------------->< ǀ ‘-ǀ use-profile-spec ǀ-‘ ǀ ‘-DELETE PROFILE----------------------------’ Named-tables-spec >>-+-ǀ sample-spec ǀ----------+-ǀ column-spec ǀ--+-------------------+---+-+->< ǀ ǀ ‘-ǀ colgroup-spec ǀ-‘ ǀ ǀ ǀ ǀ ǀ ǀ ǀ ‘---ǀ use-profile-spec ǀ-----------------’ ǀ +-ǀ column-spec ǀ--+-------------------+--+--------------------------+--+ ǀ ‘-ǀ colgroup-spec ǀ-‘ ǀ ǀ ǀ ǀ ‘-ǀ set-profile-spec ǀ-----’ ǀ ǀ ǀ ‘-DELETE PROFILE--------------------------------------------------------’ Sample-spec >>-+-----------------------------------------------------------------+->< ǀ .-25------. ǀ +-SAMPLE--+---------+---------------------------------------------+ ǀ ‘-integer-‘ ǀ ǀ .-AUTO------------. ǀ ‘-TABLESAMPLE SYSTEM--+-numeric-literal-+--+--------------------+-‘ ‘-REPEATABLE-integer-‘ Use-profile-spec >>-USE PROFILE----------+--------------------+----------------->< ‘-INCLUDE--+-(NPI)-+-‘ ‘-NPI---’ Column-spec: .-COLUMN--(--ALL--)-----------------. >>-+-----------------------------------+------------------------>
   ǀ            .-,---------------.    ǀ
   ǀ            V                 ǀ    ǀ
   ‘-COLUMN--(----column-name-----+--)-‘

>--+------------------+---------------------------------------->< ‘-SORTNUM--integer-‘ Colgroup-spec: .-------------------------------------------------------. ǀ .-,-----------. ǀ V V ǀ ǀ >>---COLGROUP--(----column-name-+--ǀ colgroup-stats-spec ǀ-+->< Colgroup-stats-spec: >>-+-------------------------------------------+--------------->
   ‘-FREQVAL -+------------------------------+-‘
              ǀ                    .-MOST--. ǀ
              ‘-COUNT--integer-----+-------+-‘
                                   +-BOTH--+
                                   ‘-LEAST-‘

>--+--------------------------------------+-------------------->< ǀ .-NUMQUANTILES--100-----. ǀ ‘-HISTOGRAM--+-----------------------+-‘ ‘-NUMQUANTILES--integer-‘ Correlation-stats-spec: >>-+-------------+--------------------------------------------->
   ‘-KEYCARD-----’

   .-----------------------------------------------------------------.
   V .-FREQVAL -NUMCOLS--1--COUNT--10--MOST------------------------. ǀ
>----+-------------------------------------------------------------+-+-->
     ‘-FREQVAL -NUMCOLS--integer--+------------------------------+-‘
                                  ǀ                    .-MOST--. ǀ
                                  ‘-COUNT--integer-----+-------+-‘
                                                       +-BOTH--+
                                                       ‘-LEAST-‘

   .---------------------------------------------------------------------.
   V                                                                     ǀ
>----+-----------------------------------------------------------------+-+->< ǀ .-NUMCOLS--1--NUMQUANTITIES--100-------------------. ǀ ‘-HISTOGRAM--+--------------------------------------------------+-‘ ǀ .-NUMQUANTILES--100-----. ǀ ‘-NUMCOLS--integer-------+-----------------------+-‘ ‘-NUMQUANTILES--integer-‘ Set-profile-spec: >>-+-SET--PROFILE--+-------------------------+-+----------------->< ǀ ǀ (1) ǀ ǀ ǀ ‘-FROM EXISTING STATS-----' ǀ ‘-UPDATE—PROFILE----------------------------’ History-spec .-HISTORY--NONE-----------. >>-----+-------------------------+------------------------------->< ‘-HISTORY--+-ALL--------+-‘
                  +-ACCESSPATH-+
                  ‘-SPACE------’

STOSPACE

                         .-,-------------.
                         V               ǀ
>>-STOSPACE--STOGROUP(-+---stogroup-name-+-+-)--------------------------------->< ‘-+-----------------’


TEMPLATE

>>-TEMPLATE--template-name--DSN—name-expression--------------------------------->
>--+----------------+--+--------------+----------------------------------------->
   ‘-common-options-‘  +-disk-options-+
                       ‘-tape-options-‘
>--+-----------------------------------------+---------------------------------->
   ‘-SUBSYS--name--LRECL--int--RECFM--+----+-‘
                                      +-F--+
                                      +-FB-+
                                      +-V--+
                                      ‘-VB-‘
>--path-expression------------------------------------------------------------->< Name-expression .-.--------------------. V ǀ >>---qualifier-expression-+----------------------------------------------------->
>--+----------------------------+---------------------------------------------->< ‘-(parenthetical-expression)-‘ Qualifier expression .----------------------------------------------------. V ǀ >>---+-character-expression---------------------------+-+---------------------->< ‘-&variable-+---------------------------+-.------' ‘-(start-+---------+-)------' ‘-,length-‘ Common-options .-UNIT--SYSALLDA-. >>-+----------------+--+-----------------+-------------------------------------->
   ‘-UNIT--name-----’  ‘-MODELDB--dsname-‘
   .-BUFNO—30-------.
>--+----------------+--+----------------+--+----------------+------------------->
   ‘-BUFNO--integer-‘  ‘-DATACLAS--name-‘  ‘-MGMTCLAS--name-‘
>--+----------------+--+---------------+---------------------------------------->
   ‘-STORCLAS--name-‘  +-RETPD integer-+
                       ‘-EXPDL’ date’--’
>--+-------------------------+--+-----------------+----------------------------->
   ǀ            .-,------.   ǀ  ‘-VOLCNT--integer-‘
   ǀ            V        ǀ   ǀ
   ‘-VOLUMES--(---volser-+-)-‘
                       .-GDGLIMIT--99------.
>--+----------------+--+-------------------+----------------------------------->
   ‘-UNCNT--integer-‘  ‘-GDGLIMIT--integer-‘
>--+-----------------------------------------------------+--------------------->
   ‘-DISP--(--+-NEW-+--,--+-DELETE--+--,--+-DELETE--+--)-‘
              +-OLD-+     +-KEEP----+     +-KEEP----+
              +-SHR-+     +-CATLG---+     +-CATLG---+
              ‘-MOD-‘     ‘-UNCATLG-‘     ‘-UNCATLG-‘
>--+--------------------------------+--+-----------------+-------------------->< ‘-LIMIT(n-+-CYL-+-,new_template)-‘ ‘-TIME--+-LOCAL-+-‘ +-GB--+ ‘-UTC---’ ‘-MB--' Disk-options .-SPACE—CYL-------------------------------. >>-+-----------------------------------------+--------------------------------->
   ‘-SPACE--+---------------------+--+-CYL-+-‘
            ‘-(primary,secondary)-‘  +-TRK-+
                                     ‘-MB--'
   .-PCTPRIME--100-----.
>--+-------------------+--+-------------------+-------------------------------->
   ‘-PCTPRIME--integer-‘  ‘-MAXPRIME--integer-‘
   .-NBRSECND--10------.
>--+-------------------+--+--------------+------------------------------------->
   ‘-NBRSECND--integer-‘  ‘-DIR--integer-‘
>--+----------------------+--------------------------------------------------->< ‘-DSNTYPE--+-LIBRARY-+-‘ +-PDS-----+ +-HFS-----+ +-NULL----+ +-BASIC---+ +-LARGE---+ +-EXTREQ--+ ‘-EXTPREF-‘ Tape-options .-STACK--NO--. .-TRTCH--NONE-------. >>-+------------+--+----------------+--+-------------------+------------------>< ‘-STACK--YES-‘ ‘-JES3DD--ddname-‘ ‘-TRTCH--+-COMP---+-‘ ‘-NOCOMP-‘ Path-expression >>-PATH—pathname-------------------------------------------------->

.-FILEDATA--RECORD--RECFM--VB--LRECL--32756-------.
>--+-------------------------------------------------+------------>
   ‘-FILEDATA--+-TEXT---+--RECFM--+-VB-+--LRECL--int-‘
               ‘-BINARY-‘         +-V--+
                                  +-FB-+
                                  ‘-F--'

   .-PATHOPTS--(--+-ORDONLY------------+--)-.
   ǀ              ‘-OCREAT,OWRONLY-----'    ǀ
>--+----------------------------------------+--------------------->
   ǀ              .-,-------------.         ǀ
   ǀ              V .-ORDONLY---. ǀ         ǀ
   ‘-PATHOPTS--(----+-OCREAT----+-+--)------’
                    +-OWRONLY---+
                    ‘-ONONBLOCK-‘ 

   .-PATHMODE--(SIRUSR)-------------.
>--+--------------------------------+----------------------------->
   ǀ              .-,----------.    ǀ
   ǀ              V            ǀ    ǀ
   ‘-PATHMODE--(----+-SIRUSR-+-+--)-‘
                    +-SIWUSR-+
                    +-SIXUSR-+
                    +-SIRWXU-+
                    +-SIRGRP-+   
                    +-SIWGRP-+
                    +-SIXGRP-+
                    +-SIRWXG-+
                    +-SIROTH-+
                    +-SIWOTH-+
                    +-SIXOTH-+
                    +-SIRWXO-+

   .-PATHDISP--(KEEP,KEEP)---------------------.
>--+-------------------------------------------+--------------->< ‘-PATHDISP--(--+-KEEP---+--,--+-KEEP---+--)-‘
   ‘-DELETE-‘     ‘-DELETE-‘


UNLOAD

                                    .---------------------.
                                    V                     ǀ
>>-UNLOAD--+-DATA--from-table-spec----+-----------------+-+-+------------------>
           ǀ                          ‘-from-table-spec-‘   ǀ
           ǀ              .---------------------.           ǀ
           ǀ              V                     ǀ           ǀ
           +-source-spec----+-----------------+-+-----------+
           ǀ                ‘-from-table-spec-‘             ǀ
           ‘-LIST--listdef-name-----------------------------’

>--unload-spec--+-------+----------------------------------------------------->< ‘-CLONE-‘ Source-spec >>-TABLESPACE--+----------------+-tablespace-name------------------------------>
               ‘-database-name.-‘
>--+------------------------+-------------------------------------------------->
   ǀ-PART-+-integer-------+-‘
          ‘-int1--:--int2-‘

>-+----------------------------------------------------------------------+->< +-FROMCOPY--data-set-name-+------------------------------------------+-+ ǀ ‘-FROMVOLUME-+-CATALOG-------------------+-‘ ǀ ǀ ‘-vol-ser--+--------------+-‘ ǀ ǀ ‘-FROMSEQNO--n-‘ ǀ ‘-FROMCOPYDDN--ddname--------------------------------------------------’ Unload-spec .-PUNCHDDN--SYSPUNCH----------. >>-+-----------------------------+--------------------------------------------->
   ‘-PUNCHDDN--+-ddname--------+-‘
               ‘-template-name-‘
   .-UNLDDN--SYSREC------------.
>--+---------------------------+--+---------+---------------------------------->
   ‘-UNLDDN--+-ddname--------+-+  +-EBCDIC--+
             ‘-template-name-‘    +-ASCII---+
                                  ‘-UNICODE-‘
                                                      ‘-SPANNED NO--'
>--+----------------------+--+--------+--+-------+----+-------------+--------->
   ǀ        .-,-------.   ǀ  ‘-NOSUBS-‘  ‘-NOPAD-‘    ‘-SPANNED YES-‘
   ǀ        V         ǀ   ǀ
   ‘-CCSID(---integer-+-)-‘
>+-----------------------------------------------------------------------+-->
 ǀ            .-COLDEL--‘,’----.  .-CHARDEL--‘”’-----.  .-DECPT--‘.’---. ǀ
 ‘-DELIMITED--+----------------+--+------------------+--+--------------+-‘
              ‘-COLDEL--coldel-‘  ‘-CHARDEL--chardel-‘  ‘-DECPT--decpt-‘
   .-FLOAT--S390-.  .-MAXERR--1-------.
>--+-------------+--+-----------------+------------------------------------->
   ‘-FLOAT--IEEE-‘  ‘-MAXERR--integer-‘
   .-SHRLEVEL--CHANGE--ISOLATION--CS--+------------------+-.
   ǀ                                  ‘-SKIP LOCKED DATA-‘ ǀ
>--+-------------------------------------------------------+---------------->
   ‘-SHRLEVEL-+-CHANGE--ISOLATION-UR-+---------------------’
>-+--------------------------------------+-+-----------------------------+-->
  ‘-DECFLOAT_ROUNDMODE-+-ROUND_CEILING---’ ‘-IMPLICIT_TZ-timezone-string-‘
                       +-ROUND_DOWN------+
                       +-ROUND_FLOOR-----+
                       +-ROUND_HALF_DOWN-+
                       +-ROUND_HALF_EVEN-+
                       +-ROUND_HALF_UP---+
                       +-ROUND_UP--------+
>--+--------------------------------+---------------------------------------->
   ‘-IMPLICIT_TZ--‘timezone-string’-‘
   .-PARALLEL--0-----------.
>--+-----------------------+------------------------------------------------>< ‘-PARALLEL—num-subtasks-‘ From-table spec >>-FROM--TABLE--table-name--------------------------------------------------->
   .-HEADER--OBID-------------------------.
>--+--------------------------------------+---------------------------------->
   ‘-HEADER--+-NONE---------------------+-‘
             ‘-CONST--+-‘string’------+-‘ 
                      ‘-X’hex-string’-‘
>--+-----------------+--+----------------+----------------------------------->
   ‘-SAMPLE--decimal-‘  ‘-LIMIT--integer-‘
>--+-----------------------------+------------------------------------------->
   ǀ   .-,-------------------.   ǀ
   ǀ   V                     ǀ   ǀ
   ‘-(---field-specification-+-)-‘
>--+-----------------------------+------------------------------------------>< ‘-WHEN--(selection-condition)-‘ Field spec .-POSITION(*)-----. >>-field-name--+-----------------+------------------------------------------>
               ‘-POSITION(start)-‘
>--+-----------------------------------------------------------------+---->< +-CHAR-+----------+-+-------------------------------------------+-+ ǀ ‘-(length)-‘ +-TRUNCATE----------------------------------+ ǀ ǀ ‘-+-BLOBF---+--template-name---+-----------+ ǀ ǀ +-CLOBF---+ ‘-BINARYXML-‘ ǀ ǀ ‘-DBCLOBF-‘ ǀ +-VARCHAR-+----------+-+----------------------------------------+-+ ǀ ‘-(length)-‘ +-strip-spec-----------------------------+ ǀ ǀ ‘-+-BLOBF---+-template-name-+------------+ ǀ ǀ +-CLOBF---+ ‘-BINARYXML-‘ ǀ ǀ ‘-DBCLOBF-‘ ǀ +-GRAPHIC-+----------+-+----------+-+----------+------------------+ ǀ ‘-EXTERNAL-‘ ‘-(length)-‘ ‘-TRUNCATE-‘ ǀ +-VARGRAPHIC-+----------+-strip-spec------------------------------+ ǀ ‘-(length)-‘ ǀ +-SMALLINT--------------------------------------------------------+ +-INTEGER--+-----------------------+------------------------------+ ǀ ‘-EXTERNAL-+----------+-‘ ǀ ǀ ‘-(length)-‘ ǀ +-BIGINT----------------------------------------------------------+ +-BINARY-+----------+-+----------+--------------------------------+ ǀ ‘-(length)-‘ ‘-TRUNCATE-‘ ǀ +-+-VARBINARY------+----------------------------------------------+ ǀ ‘-BINARY VARYING-‘ ǀ +-strip-spec------------------------------------------------------+ ǀ .-PACKED---. ǀ +-DECIMAL--+----------+--+-----------------------+----------------+ ǀ +-ZONED----+ ǀ .-,0-----. ǀ ǀ ǀ ‘-EXTERNAL-‘ ‘-(length)-+--------+-)-‘ ǀ ǀ ‘-,scale-‘ ǀ +-FLOAT-+----------+-+----------+---------------------------------+ ǀ ‘-EXTERNAL-‘ ‘-(length)-‘ ǀ +-DOUBLE----------------------------------------------------------+ +-REAL------------------------------------------------------------+ +-DATE--EXTERNAL--+----------+------------------------------------+ ǀ ‘-(length)-‘ ǀ +-TIME--EXTERNAL--+----------+------------------------------------+ ǀ ‘-(length)-‘ ǀ +-TIMESTAMP--EXTERNAL--+----------+-------------------------------+ ǀ ‘-(length)-‘ ǀ +-TIMESTAMP WITH THE ZONE EXTERNAL----+----------+----------------+ ǀ ‘-(length)-‘ ǀ +-CONSTANT--+-‘string’------+-------------------------------------+ ǀ ‘-X’hex-string’-‘ ǀ +-ROWID-----------------------------------------------------------+ +-BLOB-+----------+-+----------+----------------------------------+ ǀ ‘-(length)-‘ ‘-TRUNCATE-‘ ǀ +-CLOB-+----------+-+----------+----------------------------------+ ǀ ‘-(length)-‘ ‘-TRUNCATE-‘ ǀ +-DBCLOB-+----------+-+----------+--------------------------------+ ǀ ‘-(length)-‘ ‘-TRUNCATE-‘ ǀ ǀ .-(34)-------------------. ǀ +-DECFLOAT--+------------------------+----------------------------+ ǀ +-(16)-------------------+ ǀ ǀ ‘-EXTERNAL--+----------+-+ ǀ ǀ ‘-(length)-‘ ǀ ‘-XML--+-----------+----------------------------------------------’ ‘-BINARYXML-‘ Strip spec >>-+--------------------------------------------+---------------------------->
   ǀ        .-BOTH----.                         ǀ
   ‘-STRIP--+----------+--+-------------------+-‘
            +-TRAILING-+  ǀ                   ǀ
            ‘-LEADING--'  +-‘strip-char’------+
                          ‘-X’strip-char’-----’


Selection-condition spec
>>-+-predicate-----------+--------------------------------------------------->
   ‘-selection condition-‘
    .-------------------------------------.
    V                                     ǀ
>----+----------------------------------+-+--------------------------------->< ‘-+-AND-+--+-predicate-----------+-‘ ‘-OR--' ‘-selection condition-‘ Predicate >>-+-basic predicate---+---------------------------------------------------->< +-BETWEEN predicate-+ +-IN predicate------+ +-LIKE predicate----+ +-NULL predicate----+ Basic predicate >>-column-name--+- = --+------------------------------------------------------>
                +- <> -+
                +- > --+
                +- < --+ +- >= -+
                ‘- < = -‘ >--+-constant--------------------+----------------------------------------->
   ‘-labeled-duration-expression-‘   


IN predicate
                               .-,--------.
                               V          ǀ
>>-column-name--+-----+--IN--(---constant-+-)------------------------------>< ‘-NOT-‘ LIKE predicate >>-column-name--+-----+--LIKE--string-constant----------------------------->
                ‘-NOT-‘
>--+-------------------------+-------------------------------------------->< ‘-ESCAPE--string-constant-‘ NULL predicate >>-column-name--IS--+-----+--NULL----------------------------------------->< ‘-NOT-‘ Labeled-duration-expression >>-+-CURRENT_DATE----------------------------+----------------------------->
   ‘-CURRENT_TIMESTAMP----+----------------+-‘
                          ‘-WITH TIME ZONE-‘	
   .-------------------------------------.
   V                                     ǀ
>----+- + -+--constant--+-YEAR---------+-+-------------------------------->< +-YEARS--------+
                        +-MONTH--------+
                        +-MONTHS-------+
                        +-DAY----------+
                        +-DAYS---------+
                        +-HOUR---------+
                        +-HOURS--------+
                        +-MINUTE-------+
                        +-MINUTES------+
                        +-SECOND-------+
                        +-SECONDS------+
                        +-MICROSECOND--+
                        +-MICROSECONDS-+

Disclaimer: This Db2® 12 for z/OS Reference Guide was developed to help users in their daily activities in administrating and programming in Db2 for z/OS. There are no guarantees expressed or implied with the contents in this guide. We want to provide a quality and useful reference for users. Please notify us of any mistakes or errors in this reference guide at blogs@bmc.com. Db2 is a registered trademark of the IBM Corporation.

Order Now! Get your free Db2 collateral from BMC!

Get your free Reference Guide and Catalog Tables Poster for z/OS from BMC.
Order Now ›
Last updated: 04/01/2019

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

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

About the author

Stephen Watts

Stephen Watts

Stephen Watts (Birmingham, AL) has worked at the intersection of IT and marketing for BMC Software since 2012.

Stephen contributes to a variety of publications including CIO.com, Search Engine Journal, ITSM.Tools, IT Chronicles, DZone, and CompTIA.