REFRESH-pending status

When Db2 marks an object in REFRESH-pending (REFP) status, it also puts the object in RECOVER-pending (RECP) or REBUILD-pending (RBDP or PSRBD) status.

To reset REFP status, take the actions that are described in the following table.

Table 1. Resetting REFRESH-pending status
Status Abbreviation Object affected Corrective action
REFRESH-pending REFP Table space Run the RECOVER utility or the LOAD utility with REPLACE.
REFRESH-pending REFP Index Run the REBUILD INDEX utility.