Disaster recovery question.

Ali OZTURK

Disaster recovery question.
Hi,
I have a quick question.

When recovering SYSUTILX,DBD01,SYSCOPY, How db2 find the
information to read directly specific active log or archive log ?
For example, Since last taken image copy for these tablespaces, several
(or many) archive log process might been run.When doing recover,
Is db2 search all of them, or access directly active/archive log that
belongs image copy records for these tablespaces ?

Any help or comment will be appreciated.
Thanks.

Ali Ozturk
DB2 DBA
Pamukbank



Michael Ebert

Re: Disaster recovery question.
(in response to Ali OZTURK)
Image Copy information for these TSs is not recorded in SYSCOPY. Instead
the IC information is put in the DB2 Log. When recovering these TSs, DB2
searches the logs backwards until it finds the Image copy information. So
it's a good idea to copy these often.

Dr. Michael Ebert
DB2 Database Administrator
aMaDEUS Data Processing
Erding / Munich, Germany



From: Ali OZTURK <[login to unmask email]>@RYCI.COM on 12/12/2001
17:41 ZE2
Please respond to DB2 Data Base Discussion List <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>

To:
[login to unmask email]


cc:









Subject:
Disaster recovery question.

Hi,
I have a quick question.

When recovering SYSUTILX,DBD01,SYSCOPY, How db2 find the
information to read directly specific active log or archive log ?
For example, Since last taken image copy for these tablespaces, several
(or many) archive log process might been run.When doing recover,
Is db2 search all of them, or access directly active/archive log that
belongs image copy records for these tablespaces ?

Any help or comment will be appreciated.
Thanks.

Ali Ozturk
DB2 DBA
Pamukbank


options or to cancel your subscription visit the



Barb Milligan

Re: Disaster Recovery Question
(in response to Michael Ebert)
We test D/R twice a year so I do this a lot.
You must add the archive tape to the BSDS so that DB2 knows about it.
The SYSUTILX, DBD01 and SYSCOPY must be restored in a specific
order and that is documented pretty well in section 4 of the
administration guide for V5.

Barb







Date: Wed, 12 Dec 2001 17:41:58 +0200
From: Ali OZTURK <[login to unmask email]>
Subject: Disaster recovery question.

Hi,
I have a quick question.

When recovering SYSUTILX,DBD01,SYSCOPY, How db2 find the
information to read directly specific active log or archive log ?
For example, Since last taken image copy for these tablespaces, several
(or many) archive log process might been run.When doing recover,
Is db2 search all of them, or access directly active/archive log that
belongs image copy records for these tablespaces ?=20

Any help or comment will be appreciated.
Thanks.

Ali Ozturk=20
DB2 DBA
Pamukbank



Chris Parker

Re: Disaster recovery question.
(in response to Barb Milligan)
Assuming nothing has changed since the last time I looked into this, the rba
of the log record containing the most recent SYSCOPY row information for the
tablespace is retained within an area of DB2 memory that is saved during
checkpoint processing and rebuilt during system startup. DB2 will use this
rba/lrsn to determine where to start reading the log for the first "SYSCOPY
ROW" in the log. This log record contains a pointer to the previous RBA
that contains the next row and so on backward through the log until a valid
copy is found to begin the recovery processes. So, to answer your question,
all of the archive logs should not be accessed since the last copy when
scanning for the SYSCOPY information. However, once the starting point is
found, all logs from there to your recovery endpoint will be read during
logapply.

-----Original Message-----
From: Ali OZTURK [mailto:[login to unmask email]
Sent: Wednesday, December 12, 2001 9:42 AM
To: [login to unmask email]
Subject: Disaster recovery question.


Hi,
I have a quick question.

When recovering SYSUTILX,DBD01,SYSCOPY, How db2 find the
information to read directly specific active log or archive log ?
For example, Since last taken image copy for these tablespaces, several
(or many) archive log process might been run.When doing recover,
Is db2 search all of them, or access directly active/archive log that
belongs image copy records for these tablespaces ?

Any help or comment will be appreciated.
Thanks.

Ali Ozturk
DB2 DBA
Pamukbank



http://www.ryci.com/db2-l. The owners of the list can be reached at
[login to unmask email]