Modify Recovery

Go Up to Available object actions by DBMS

The Modify Recovery Wizard lets you delete records from SYSIBM.SYSCOPY, related log records from SYSIBM.SYSLGRNX, and entries from the DBD. You can delete records based on a specific age or based on the date the record was written.

You should run the wizard regularly to clear outdated information from SYSIBM.SYSCOPY and SYSIBM.SYSLGRNX. These tables, and particularly SYSIBM.SYSLGRNX, can become very large and take up considerable amounts of space. By deleting outdated information from these tables, performance for processes that access data from these tables can be improved.

Platform Availability

• DB2 z/OS

To Run the Modify Recovery Utility

1. Initiate a Modify Recovery action against a tablespace. For more information see Initiating an object operation.
2. Use the following table as a guide to understanding and modifying settings in the Modify Recovery Utility wizard:

Step	Settings and tasks
1	Select tablespaces	Displays the available tablespaces.
	Add	Opens the Object Selector Dialog Box.
	Delete	Deletes the selected items.
2	Delete history record(s) by	Age lets you delete history records by age, specifying a Number of Days between 1 and 32767. Date lets you delete all records written before a specified Date in eight digit format yyyymmdd (e.g. 20000218).

3. When ready, click Finish.