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