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@;VM.MARIST.EDU]On Behalf Of fenglimian Sent: Tuesday, November 05, 2002 8:14 PM To: [EMAIL PROTECTED] 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 [EMAIL PROTECTED] !!!!!!!!!!!!!!!!!!!!2002-11-06
