Nunepalli – that is correct – unless you have a tool
from an ISV supporting this. I know of one where you can use SQL
like predicates to do selective clean up of SYSCOPY entries.
From: Bharath Nunepalli [mailto:[login to unmask email]
Sent: Tuesday, January 30, 2018 5:18 PM
To: [login to unmask email]
Subject: [DB2-L] - MODIFY RECOVERY to delete LB/RP image copy
CAUTION: This email originated from outside of CA. Do not click
links or open attachments unless you recognize the sender and know
the content is safe.
My requirement is to delete only the entries for LB/RP image copies
As per my understanding, MODIFY RECOVERY can delete entries based
on age or date but not based on ICTYPE.
Is that correct? Just want to make sure I didn't miss anything
about MODIFY RECOVERY utility.
Senior DB2 DBA.
-----End Original Message-----