=> 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