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