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.
During table reorganization, the following functions are disabled:
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.
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).
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).
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: