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?

Bill

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
fenglimian
Sent: Tuesday, November 05, 2002 8:14 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Help on DB2 restore USE TSM


Hi,Bill Boyer,
  If you want to rollforward ,you need set you database configuration
LOGRETAIN ON or UEREXIT ON,and you should compile "db2uext2.cadsm(you can
rename it db2uext2.c)",this file locate in path sqllib/samples/c.,then move
it to path sqllib/adm.





>Anyone out there able to help me on a DB2 restore?
>
>WHen I do the RESTORE DB USE TSM TAKEN ON <stamp>, and I know that the
>backup for this is on tape, I don't see the tape mount, but the restore
>completes successfully..or so it says. I see sessions starting/stopping for
>the instance, but I don't see any call for tape media.
>
>Then when I try to ROLLFORWARD, it sit there in a "DB pending" state.
>
>Can someone help me here? Or point me to a list?
>
>Bill Boyer
>DSS, Inc.

= = = = = = = = = = = = = = = = = = = =



!!!!!!!!!!!!!!!!fenglimian
!!!!!!!!!!!!!!!!fenglimian AT 163 DOT com
!!!!!!!!!!!!!!!!!!!!2002-11-06