8.12.2 Falsification prevented table

Organization of this subsection
(1) Limitations
(2) Execution conditions
(3) Reload-not-completed data status

(1) Limitations

Even when a deletion prevention duration is specified, pdrorg rearranges data; therefore, row data is deleted once. Falsification of data is prevented by executing the unload and reload operations one after another. You can perform only table reorganization (-k rorg) on a falsification prevented table. The table unload (-k unld) and reload (-k reld) operations are permitted only under specific conditions.

(a) For table reorganization (-k rorg)

During table reorganization, the following functions are disabled:

(b) For table unload operation (-k unld)

Basically, the table unload operation is prohibited for falsification prevented tables. However, you can unload a table for which the -W option has been specified.

(c) For table reload operation (-k reld)

Basically, the table reload operation is prohibited for falsification prevented tables. However, if a reload operation for table reorganization (-k rorg) terminates abnormally, you can re-execute that reload operation (-k reld). During such a re-execution, do not change any control statement or option other than the -k option (if execution with the unload and lobunld statements both specified results in an error, re-execute the operation with only one of those statements specified).

(2) Execution conditions

Before executing table reorganization (-k rorg) or a table reload operation (-k reld), you must use the pdhold command to shut down the RDAREA that contains a falsification prevented table (to protect its data from being compromised).

(3) Reload-not-completed data status

During reorganization of a falsification prevented table, the reload operation may not be completed due to an error. This status is called the reload-not-completed data status.

You can determine whether or not an RDAREA is in reload-not-completed data status from the results of RDAREA logical analysis or table analysis by pddbst. When the RDAREA is in reload-not-completed data status, you cannot use any of the following pdrorg functions: