PRO restricted status
Persistent Read Only (PRO) restricted status indicates that only read access by SQL or utilities is allowed for the table space partition; all updates to the partition are prohibited.
SQL or utilities that attempt to update a partition that is in PRO status receive a resource unavailable error. When one or more partitions are in PRO status, run utilities that update data at the partition level.
PRO status is turned on by a system administrator or database administrator or by a product that runs with Db2 for z/OS®. PRO status can be set on a partition by using the REPAIR utility SET statement.
| Status | Abbreviation | Object affected | Corrective action |
|---|---|---|---|
| Persistent Read Only | PRO | Table space partition | Run REPAIR SET TABLESPACE with NOPRO. Important: Do not reset PRO status without the consent of the system administrator or database
administrator, because updates to the partition might cause data loss.
|