ADSM-L

Re: Help on DB2 restore USE TSM

2002-11-07 10:08:59
Subject: Re: Help on DB2 restore USE TSM
From: Zig Zag <veritrash AT YAHOO DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 7 Nov 2002 07:08:07 -0800
Had to do this last year.

Restore <DIRS> from B/U client.
Restore <DB Partitions> from API client.
Restore <DB LOGS> and append.

No problems.

Your comand looks like your trying to restore the TSM DB.. ? .. ?
--- asr AT UFL DOT EDU wrote:
> => On Wed, 6 Nov 2002 09:43:44 -0500, Bill Boyer <bill.boyer AT VERIZON DOT 
> NET> said:
>
> > That's all configured and working. I'm trying to verify the whole process by
> > doing a restore and rollforward. The backups and log archives are flowing
> > with no problems.
>
> > When I run the RESTORE DB command, I see the sessions with the TSM server,
> > but I don't see any that go into MediaW state for a tape mount. The RESTORE
> > DB command comes back with successful. When I issue the ROLLFORWARD DB
> > command it says OK, but when I ROLLFORWARD DB TMD QUERY STATUS, it's just
> > sitting there with a status of "DB Pending".
>
> > I don't understand why the sessions don't ask for the tape, but the restore
> > says it worked. Right now my DB is sitting in a rollforward pending state
> > and not available. Good thing it's a test DB and instance, huh?
>
> > Is there anyone out there that has successfully done DB2 backups AND
> > RESTORES using TSM?
>
>
> I've done DB/2 backups and restores to move databases before; I'll be doing
> rollforward recovery experimentation tomorrow, as a matter of fact.
>
> For me the major hurdle was really figuring out where the configuration was
> happening.  The brainstorm (obvious in retrospect) was that you have to set
> the environment correctly in the shell that _STARTS_ the database.
>
> The environment of the shell running the backup command is nearly irrelevant.
>
>
> - Allen S. Rout


__________________________________________________
Do you Yahoo!?
U2 on LAUNCH - Exclusive greatest hits videos
http://launch.yahoo.com/u2

<Prev in Thread] Current Thread [Next in Thread>