| Author |
Message |
Topic: Recovery to PIT |
LEO
Replies: 2
Views: 1730
|
Forum: Database Posted: Fri Feb 09, 2007 11:05 am Subject: Recovery to PIT |
Kolusu,
Thanks for your reply. If there is an image copy, can't we use RECOVER to LASTFULLCOPY statement. But is there a way to apply the log to reach the point before pgm starts. Please advise.
T ... |
Topic: Recovery to PIT |
LEO
Replies: 2
Views: 1730
|
Forum: Database Posted: Thu Feb 08, 2007 2:47 pm Subject: Recovery to PIT |
HI,
I have a DB2 update program that ran for some time and then abended due to some problem. Now I would like recover the tables to previous point in time, i.e before the update program's run. What ... |
Topic: Recover Tablespace issue |
LEO
Replies: 8
Views: 5007
|
Forum: Database Posted: Tue Jan 23, 2007 9:50 am Subject: Recover Tablespace issue |
Excellent CZerfas !!!! I got the answer. That's a wonderful explanation
Thanks Kolusu for your prompt reply!! |
Topic: Recover Tablespace issue |
LEO
Replies: 8
Views: 5007
|
Forum: Database Posted: Mon Jan 22, 2007 3:53 pm Subject: Recover Tablespace issue |
Both are the same as shown below. I am wondering why this is happening ?
-DMTE DSNUCASA - RECOVER OF TABLESPACE Z013225.PLANTBLH WILL PROCEED TO LOG POINT X'C007ABF44680'
== Table: SYSIBM.SY ... |
Topic: Recover Tablespace issue |
LEO
Replies: 8
Views: 5007
|
Forum: Database Posted: Mon Jan 22, 2007 3:09 pm Subject: Recover Tablespace issue |
Kolusu,
The last QUIESCE point is taken during the last full Image copy as shown below
DSNUGUTC - QUIESCE TABLESPACE Z013225.PLANTBLH
-DMTA DSNUQUIA - QUIESCE SUCCESSFUL FOR TABLESPACE Z0132 ... |
Topic: Recover Tablespace issue |
LEO
Replies: 8
Views: 5007
|
Forum: Database Posted: Mon Jan 22, 2007 11:14 am Subject: Recover Tablespace issue |
Thanks Kolusu, it worked with TOLASTFULLCOPY.
But I have another doubt related to this - the above link also mentions the below example :
Example 1: Recovering a table space. The following contr ... |
Topic: Recover Tablespace issue |
LEO
Replies: 8
Views: 5007
|
Forum: Database Posted: Sun Jan 21, 2007 3:39 pm Subject: Recover Tablespace issue |
Hi,
I have taken Imagecopy of the tablespace , it went thru fine. After that I did some deletions on the underlying tables in tablespace and commited the changes. But I want to restore the tables t ... |
Topic: DB2 Partition Tables |
LEO
Replies: 5
Views: 2974
|
Forum: Database Posted: Fri Jul 21, 2006 1:31 pm Subject: DB2 Partition Tables |
| Thanks alot |
Topic: DB2 Partition Tables |
LEO
Replies: 5
Views: 2974
|
Forum: Database Posted: Wed Jul 19, 2006 4:53 pm Subject: DB2 Partition Tables |
Hi,
I would like to know if there is way to find out the PART VALUES that were used while creating partition index ?
I have access to platinum ? I could see that there are 100 partitions in the ... |
Topic: Handle condition |
LEO
Replies: 1
Views: 2229
|
Forum: CICS and Middleware Posted: Thu Apr 13, 2006 4:52 pm Subject: Handle condition |
Hi,
I HAVE THE FOLLOWING CODE. When RECORD-NOT-FOUND condition is raised it is going to 7700- para and then to 7800- para. It is not getting back to 2000- para. Any idea why this is happening ? Ple ... |
Topic: DDIO error? |
LEO
Replies: 4
Views: 5228
|
Forum: Problem Determination Posted: Mon Jan 30, 2006 4:43 pm Subject: DDIO error? |
| Have you included the loadlib in Xpeditor setup ?? |
| |