You can execute this command in either Single User or Multi-User mode. To create a backup of a data area, execute DBUTLTY using the following command. You can code multiple EXCLUDE= or INCLUDE= keywords.
Back Up All Areas in Database (z/VSE)
►►─ BACKUP ─┬──────────────────┬─ DBID=n,DEVICE= ─┬─ DISK ─┬──────────────────► └─ BLKSIZE=nnnnn, ─┘ ├─ TAPE ─┤ └─ Snnn ─┘ ►─ ,DTFNAME=bbbbbbb ─┬───────────────────────┬─┬────────────────────┬────────► └─ ,CMPRS= ─┬─ YES ◄ ─┬─┘ │ ┌────────────────┐ │ └─ NO ────┘ ├─▼─ ,EXCLUDE=ccc ─┴─┤ │ ┌────────────────┐ │ └─▼─ ,INCLUDE=ccc ─┴─┘ ►─┬───────────────────────┬─┬────────────────────────┬───────────────────────► └─ ,LABEL= ─┬─ YES ◄ ─┬─┘ └─ ,REWIND= ─┬─ YES ◄ ─┬─┘ └─ NO ────┘ └─ NO ────┘ ►─┬────────────────┬─ ,SEQ=NATIVE ───────────────────────────────────────────►◄ └─ ,SEQBUFS=nnn ─┘
Back Up Single Area in Database (z/VSE)
►►─ BACKUP ─ AREA=aaa, ─┬──────────────────┬─ DBID=n,DEVICE= ─┬─ DISK ─┬──────► └─ BLKSIZE=nnnnn, ─┘ ├─ TAPE ─┤ └─ Snnn ─┘ ►─ ,DTFNAME=bbbbbbb ─┬───────────────────────┬─┬────────────────────┬────────► └─ ,CMPRS= ─┬─ YES ◄ ─┬─┘ │ ┌────────────────┐ │ └─ NO ────┘ ├─▼─ ,EXCLUDE=ccc ─┴─┤ │ ┌────────────────┐ │ └─▼─ ,INCLUDE=ccc ─┴─┘ ►─┬───────────────────────┬─┬───────────────┬─┬──────────────┬───────────────► └─ ,LABEL= ─┬─ YES ◄ ─┬─┘ └─ ,FIRSTKEY=n ─┘ └─ ,LASTKEY=n ─┘ └─ NO ────┘ ►─┬───────────────────────┬─┬────────────────────────┬───────────────────────► └─ ,MULTUSE= ─┬─ NO ──┬─┘ └─ ,REWIND= ─┬─ YES ◄ ─┬─┘ └─ YES ─┘ └─ NO ────┘ ►─┬────────────────┬─ ,SEQ=NATIVE ───────────────────────────────────────────►◄ └─ ,SEQBUFS=nnn ─┘
Back Up Data Area Physical (z/VSE)
►►─ BACKUP ─┬─────────────┬─┬──────────────────┬──────────────────────────────► └─ AREA=aaa, ─┘ └─ BLKSIZE=nnnnn, ─┘ ►─ DBID=n,DEVICE= ─┬─ DISK ─┬─ ,DTFNAME=bbbbbbb ─────────────────────────────► ├─ TAPE ─┤ └─ Snnn ─┘ ►─┬───────────────────────┬─┬────────────────────┬───────────────────────────► └─ ,CMPRS= ─┬─ YES ◄ ─┬─┘ │ ┌────────────────┐ │ └─ NO ────┘ ├─▼─ ,EXCLUDE=ccc ─┴─┤ │ ┌────────────────┐ │ └─▼─ ,INCLUDE=ccc ─┴─┘ ►─┬────────────────────────────┬─┬───────────────────────┬───────────────────► └─ ,IOERROR= ─┬─ NOSKIP ◄ ─┬─┘ └─ ,LABEL= ─┬─ YES ◄ ─┬─┘ └─ SKIP ─────┘ └─ NO ────┘ ►─┬──────────────────────┬─┬────────────────────────┬────────────────────────► └─ ,RECID= ─┬─ NO ◄ ─┬─┘ └─ ,REWIND= ─┬─ YES ◄ ─┬─┘ └─ YES ──┘ └─ NO ────┘ ►─┬────────────────┬─ ,SEQ=PHYSICAL ─┬───────────────────────┬───────────────►◄ └─ ,SEQBUFS=nnn ─┘ └─ ,UPDATE= ─┬─ NO ◄ ─┬─┘ └─ YES ──┘
Command
Invokes the BACKUP function.
Required Keywords
Identifies the database for the area to be read.
Valid DATACOM-ID of an existing database
(No default)
Specifies the device type for the output data set.
When DEVICE=TAPE is specified, the system logical unit (SYS) number must be 5 (SYS005).
Use the Snnn entry to specify a specific SYS number (for tape only).
DISK, TAPE, Snnn (Certain values from previous versions are still accepted but are treated as DISK.)
(No default)
Specifies the JCL TLBL/DLBL name for the output data set. If DEVICE=TAPE, this name must match the name which you code in your JCL TLBL statement; otherwise, this name must match the name you code in your JCL DLBL statement.
Any name valid to z/VSE JCL specifications
(No default)
Optional Keywords
Identifies the data area to be backed up. If you omit this keyword, each area in the database is opened, backed up, and closed, in turn.
Note: If you specify MULTUSE=, you must also specify an area name.
A 3-character name of an area
(No default)
Indicates the block size for the output data set. For best performance, use 32767 when going to tape and the largest block size which uses all of a track when going to disk.
Note: If the block size is not large enough to contain the largest record in the area (see the following formula), DBUTLTY terminates abnormally.
Calculate the minimum block size for the output data set as follows:
A + C + 30
where:
A is the length of the largest record in the area,
C is 0, if the data is not compressed, or
C is (A/128) + 1, if the data is compressed.
A 1- to 5-digit number
4096 (for DEVICE=DISK), or
32767 (for DEVICE=TAPE)
If you specify a block size with this parameter, the utility ignores any BLKSIZE parameter in the JCL. If you do not specify a block size with this parameter, the utility uses the BLKSIZE specified in the JCL if one exists. In the absence of either this parameter or a specification in the JCL, the utility uses the default value.
Specifies, for compressed tables, whether the output is to remain compressed or is to be expanded. This parameter has no effect on tables that are not defined with compression.
Specifies that DBUTLTY write the data "as is" from the area to the sequential output file. That is, a compressed table remains compressed on the output data set.
Specifies that DBUTLTY write the data in expanded form to the sequential output file. The NO option should be used only when the data being produced is intended to be used as input to a user-written program or if the table is to be redefined with a different combination of CA Datacom/DB compression and user compression options than the current definition.
Note: You must not specify CMPRS=NO and RECID=YES.
NO or YES
YES
Specifies the name of the table that is not to be backed up. To indicate more than one table, code the EXCLUDE= parameter more than once.
Tables that are excluded lose their data when DBUTLTY reloads from that backup. Use the EXTRACT function instead of the BACKUP function for single table recovery.
This parameter is mutually exclusive with the INCLUDE= parameter.
If neither EXCLUDE= nor INCLUDE= is specified, all the tables are backed up.
Specify a table name within the area (or database if omitting AREA=)
(No default)
These keywords allow you to select a segment of a table or area by Native Key (SEQ=NATIVE) value to be processed for BACKUP. The BACKUP function normally defaults to include the full Native Key range from low values to high values. FIRSTKEY= overrides the default starting position while LASTKEY= overrides the default ending position, limiting the records retrieved for output to the BACKUP file. If one keyword is specified and the other is not specified, a default value is selected for the missing keyword. Normal CA Datacom key lengths are from 1 through 180 bytes. The key value data entered for FIRSTKEY= and LASTKEY= can be from 0 (zero) through 59 bytes long. You only need to code the number of positions of the key value that are significant to you, but be aware that the value coded is left justified regardless of key field data type. The utility pads the low order or remaining positions of the key value with low values on FIRSTKEY= and high values on LASTKEY=. To back up the entire area in one step, specify neither FIRSTKEY= nor LASTKEY=. Alternately, you could specify FIRSTKEY=00 and/or LASTKEY=00 which causes processing to start at low values and end at high values. The length of zero indicates that the padded key values (low values and high values) are to be used.
The data is not edited or interpreted. Therefore, if the key value data you need to enter is in binary, you must set up the JCL using a hexadecimal mode display and enter the key value data in hexadecimal. This data can contain blanks, commas, and any other special characters. CA Datacom/DB cannot edit this data for syntax, so the control statement can look invalid, especially when it includes blanks or commas or key value data containing English words. For example, FIRSTKEY=12121212121212 means the length is 12, key value is 121212121212. Another example, FIRSTKEY=10FIRSTKEY10 means the length is 10, key value is FIRSTKEY10.
A 2-byte length (in the range of 00 through 59) followed by a character string of key value bytes (for the length specified) that represents the key value.
The starting/ending position of the full Native Key range from low values to high values.
Specifies the name of a table to be backed up. To indicate more than one table, code the INCLUDE= parameter more than once.
This parameter is mutually exclusive with the EXCLUDE= parameter.
If neither INCLUDE= nor EXCLUDE= is specified, the entire area is backed up.
Any table name within the area
(No default)
(Not valid if AREA= keyword is omitted.) Specifies how CA Datacom/DB is to handle I/O errors during a backup. Specify this option only for a physical sequence backup.
A value of SKIP causes CA Datacom/DB to issue a console message, produce a Master List dump, and skip the block in which an I/O error occurs when the utility encounters an I/O error while reading a data block.
The utility does not skip I/O errors to other data sets or the control block of the data area. When an I/O error does occur and the SKIP value is in force, the utility exits with a good completion code since this value overrides the error condition.
If an I/O error does not occur and the value SKIP is in force, DBUTLTY issues a warning message at the end of the execution. The utility cancels the job. This prevents accidental skipping of records.
In either case, the backup is a correct, complete backup. If a skip does occur during the backup, the Master List dump and warning message provide a basis for reconstructing the missing information.
Note: IOERROR=SKIP is not recommended and exists only to assist you in salvaging as much data as possible, if all backup tapes are defective. Frequent backups eliminate the risk associated with lost data and are preferable to the IOERROR option.
SKIP or NOSKIP
NOSKIP
See the description of FIRSTKEY=/LASTKEY= given previously.
If DEVICE=TAPE (either TAPE or the Snnn form), LABEL= specifies whether tape labels are to be processed. We recommended that labeled tapes always be used.
Note: LABEL= has no effect when DEVICE=DISK.
NO or YES
YES
(For area level DBUTLTY control only.) If you specify MULTUSE=, you must also specify an area name, but do not specify SEQ=PHYSICAL.
For more information on area level DBUTLTY control, see Area Level DBUTLTY Control.
NO or YES
NO
Specifies whether the record location information is to be backed up as part of each output record.
To create a physical sequence backup that can later be used with a forward recovery operation, specify RECID=YES.
Note the following:
NO or YES
NO
If DEVICE=TAPE (either TAPE or the Snnn form), YES indicates the tape is to be rewound before OPEN and after CLOSE. NO indicates no rewind before OPEN or after CLOSE. NO allows the stacking of backups on one tape.
Note: REWIND= has no effect when DEVICE=DISK.
NO or YES
YES
Indicates the sequence in which the input data is to be processed and written to the backup data set. For details on retrieval sequence, see Backup Format.
Specifies that DBUTLTY read the Index and retrieve the data in Native Key sequence. When using SEQ=NATIVE, you can use the FIRSTKEY=/LASTKEY= optional keywords to select only a portion of the table or area.
Specifies that DBUTLTY not read the Index. The output has no logical sequence but does follow the physical track sequence.
Note: Do not specify SEQ=PHYSICAL if you specify MULTUSE=.
NATIVE or PHYSICAL
NATIVE
If specified, SEQBUFS= must range from 0-256, even numbers only. We recommended for best performance to specify SEQBUFS=128 or SEQBUFS=256. If memory is limited and slower performance is acceptable, lower numbers should be used.
If MULTUSE= is omitted or specified as NO, the default is SEQBUFS=8. Any value specified for SEQBUFS= less than 8 is forced up to 8. Any value greater than 128 is forced to 128. If the number of data buffers (specified with the DATANO= parameter in the DBMSTLST macro) used by this DBUTLTY was specified as 192 or more, those data buffers are used and no additional memory is allocated. The SEQBUFS= value is edited and ignored (for best performance) without a larger DATANO= parameter value specification. The DATANO= buffers are also used if they are equal to or greater than the SEQBUFS= value multipled by 1.5. Otherwise, the number of SEQBUFS= is allocated as additional sequential buffers with additional memory required.
If MULTUSE=YES is specified, the default is SEQBUFS=128. If SEQBUFS= is specified as 0-8, it is rounded up to 8. If SEQBUFS= is specified as 130-134, it is rounded up to 136, in which case no read-ahead nor multi-block reads occur. If SEQBUFS= is specified as 2-128 (even numbers only), that many private sequential buffers are allocated (memory must be available) in the MUF address space. Read ahead is done. Multiple blocks are read with each I/O when possible to reduce elapsed times and CPU times with the number per I/O as one-half of the SEQBUFS. If set as 130-256, no private sequential buffers are allocated, normal existing data buffers are used in the MUF address space. This function shares those buffers with all other tasks using MUF. If set as 132-256, read ahead is done, and multiple blocks are read with each I/O to reduce elapsed times and CPU times with the number per I/O as the SEQBUFS number minus 128 and one-half of that result. The maximum blocks per read I/O is always 64.
0-256 (even numbers only)
128
Indicates whether the database can be open for update at the start or during the backup.
Note: Only valid if SEQ=PHYSICAL.
Allows tables in the database to be updated and allows the INIT or LOAD functions on the data area during the backup.
Specifies that CA Datacom/DB determines that the data area is loaded with a loaded Index and that the database is not open for update. During the backup, the database may not be opened for update.
NO or YES
NO
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|