8.9.1 Format

This section explains the format of the pdrorg command. In the following table, each number corresponds to the number assigned to each option.

Options in bold are important or mandatory.

No.Format
1pdrorg
-k processing-type
2[-c object-of-processing]
3

[-t {[authorization-identifier.]table-identifier|[authorization-identifier.]all
|table-identifier[,table-identifier]...}]

4[-r RDAREA-name]
5[-l log-acquisition-method]
6[-i index-creation-method]
7

[-W {{dat|extdat}[,[separator-character][,{cr|crlf}][,sup]]
      |bin[ -w]
      |fixtext[,[padding-character][,{cr|crlf}]]}]

8[-g]
9[-j]
10[-u authorization-identifier]
11

    [-n {batch-output-local-buffer-sectors-count[,div]|
      batch-output-local-buffer-sectors-count,[div],local-buffer-sectors-count-for-random-access |
      ,,local-buffer-sectors-count-for-random-access}]

12[-f unload-data-file-type-or-LOB-data-unload-file-type]
13[-b unload-sequence]
14[-s]
15[-o]
16[-m[ progress-message-output-interval][,information-message-output-suppression-level]]
17

[-X response-monitoring-time-for-server-to-server-communication]

18[-q generation-number]
19control-information-filename
Note
Be sure to specify control-information-filename as the last option.
Relationships between functions and options of pdrorg

The following table shows the relationships between the functions and options of the pdrorg command:

Optionspdorg's functions
Table reorgTable unldgTable reldgData dict tbl reorgBatch index creationIndex re-creationIndex reorg
-kRRRRRRR
-cOOOR------
-tRRRORRR
-rOOO--------
-lO--OOOOO
-iO--O--------
-W--O----------
-gOOO--------
-jOOO--------
-uOOOOOOO
-nOOO--OO--
-fOOOO------
-bOO----------
-SOO----------
-oO--O--OOO
-mOOOOOO--
-XOOOOOOO
-qOOO--OOO
control-information-filenameRRRRRRR

R: Required

O: Optional

--: Not specifiable