Mainframe Blog

IBM Utilities in Db2 12

11 minute read
Stephen Watts

(This article is part of our Db2 Guide. Use the right-hand menu to navigate.)

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. This collateral helps Db2 for z/OS users with daily activities in administering and programming for Db2 on z/OS.


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

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

BMC Brings the A-Game

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

About the author

Stephen Watts

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