Multi-User mode is required to execute this command. Execute the REORG function using the following command format.
►►─ REORG OPTION2=BACKUPONLY,DBID=n,AREA=a ─ ,DEVICE= ─┬─ DISK ─┬─────────────► ├─ TAPE ─┤ └─ Snnn ─┘ ►─ ,DTFNAME=bbbbbbb,INNUM=n ─┬───────────────────┬───────────────────────────► └─ ,BLKSIZE=nnnnn, ─┘ ►─┬───────────────────────┬─┬────────────────────────┬─┬────────────┬────────► └─ ,LABEL= ─┬─ YES ◄ ─┬─┘ └─ ,REWIND= ─┬─ YES ◄ ─┬─┘ └─ ,CYCLE=n ─┘ └─ NO ────┘ └─ NO ────┘ ►─┬──────────────┬───────────────────────────────────────────────────────────►◄ └─ ,SEQBUFS=n ─┘
Command
Invokes the REORG function.
Required Keywords
Specifies the type of REORG.
BACKUPONLY
(No default)
Identifies the database selected for REORG.
DATACOM-ID of the database
(No default)
Identifies the area to be backed up.
DATACOM-NAME of the area in the database specified in the DBID= parameter
(No default)
When DEVICE=TAPE is specified, the system logical unit (SYS) number must be 10 (SYS010).
Use the Snnn entry to specify a specific SYS number (for tape only). For TAPE or Snnn this number is first the subtask then next sequential numbers are used for succeeding tasks. For example, with a specification of DEVICE=TAPE,INNUM=4 (where INNUM= specifies the number of subtasks to backup data), the output file SYS numbers that are expected are 10,11,12,13.
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.
A reporting only option is available, if you use REORG OPTION2=BACKUPONLY and either DTFNAME=* or DTFNAME** as described in the following:
DTFNAME=*
Specifies that a report is to be generated, with the key values selected for each Native Key sequence ID, by providing starting and ending key values, in character and hexadecimal formats. If the starting and ending values are identical, no rows are found. The generated report can be used to assist in key selection if you prefer to back up the data using the FIRSTKEY/LASTKEY options of the BACKUP function.
DTFNAME=**
Specifies a report that can be used for debugging. It shows the full starting key to be assigned to each task, when running the REORG with a proper DTFNAME.
Any name valid to JCL specifications (1-5 characters, the number of the subtask based on INNUM= being suffixed as 1 through 25)
Note: There is also the special case of the use of * or ** (as previously described).
(No default)
Specifies the number of subtasks to backup.
Note: If you are partitioning by some portion of Native Key, running a REORG DTFNAME=*,INNUM=n (where n is the number of partitions) gives the current way to break up the data set.
A number, 1 through 25
(No default)
Optional Keywords
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
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 DEVICE=TAPE (either TAPE or the Snnn form), specifies whether or not tape labels are to be processed. We recommend that labeled tapes always be used.
Note: LABEL= has no effect when DEVICE=DISK.
NO or YES
YES
Specifies the minimum number of high-level index entries per task, to divide work. This specification is used during the backup phase of the REORG function.
2 through 99
5
Specifies the number of sequential buffers for each Multi-User Facility task that is backing up data. Even though allowed by the DBURTBL macro, in this case the value of SEQBUFS= may not be a minus number. To specify minus numbers, add 128. The default of 256 is equivalent to -128 (a negative 128). If you specify less than 8 for SEQBUFS=, the specification is rounded up to a value of 8.
0 through 256
256
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
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|