**please note my email address change**
If you recover TOCOPY then you are not recovering TORBA or
TOLOGPOINT, and your recovery is by definition _not_ to a point of
consistency. DB2 will always set CHKP on an index in this recovery
Computer Systems Manager
5 Manhattan West (33rd St at 10th Ave)
New York, NY 10001-2632
[cid:[login to unmask email]
From: Bharath Nunepalli [mailto:[login to unmask email]
Sent: Wednesday, August 23, 2017 11:35 AM
To: [login to unmask email]
Subject: [DB2-L] - Index in CHKP
I did Tablespace and Index recovery TOCOPY using SHARELEVEL
REFERENCE image copies.
Both, Tablespace and Index are in same list.
After the recovery is done, noticed that Index is in CHKP.
As per IBM resource center, Index can be in CHKP if
1. you did not recover the table space in the same list.
2. you specified the table space and the index, but the recovery
point in time was not a point of consistency
But, none of the above is applicable in this case.
So, any ideas why the Index is in CHKP after Index recovery?
-----End Original Message-----
**This e-mail, including any attachments, may be confidential,
privileged, or otherwise legally protected. It is intended only for
the addressee. If you received this e-mail in error or from someone
who was not authorized to send it to you, do not disseminate, copy,
or otherwise use this e-mail or its attachments. Please notify the
sender immediately by reply e-mail and delete the e-mail from your