I guess I'm further along but after I got the database restored I tried to 
restart the TSM box and it's not coming up. 

I'm getting:

ANR0238E A database recovery task is prohibiting activation of TSMDB1 with
sqlcode -1117.

Not much success getting an idea what that actually means...

Any suggestions? 


David Tyree 
System Administrator 
South Georgia Medical Center 
229.333.1155 

-----Original Message-----
From: Tyree, David 
Sent: Thursday, November 13, 2014 16:23
To: 'ADSM: Dist Stor Manager'
Subject: RE: corrupted db on test system

I manually put the tape in the library and then did some hacking around in the 
devconfig file to tell TSM just where the tape was. 

Fired off the restore db command again and I saw the library mount the correct 
tape. 

Now I'm seeing a db restore running so I think I'm in business now. 

I understand that a db restore takes about 2 to 3 times as long as a db backup 
so it should finish in about 3 hours or so...

Thanks for pointing me in the right direction. 

David Tyree 
System Administrator 
South Georgia Medical Center 
229.333.1155 

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Thomas Denier
Sent: Thursday, November 13, 2014 15:46
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] corrupted db on test system

----David Tyree wrote-----

                We are running TSM v6.3.1 on a test box and we had a drive fail 
and it has a corrupted database now and won't start.

                I did the "dsmserv remove db tsmdb1" to get rid of the old 
database and now I'm about to start the actual database restore.
                While I was waiting for the offsite database backup tape to be 
brought back onsite I issued the "dsmserv restore db" to see what would happen. 
It failed like I expected because it couldn't find the tape in the library.
                At least it's seeing the library and all the drives.
                My question is how do I check in that tape to the library?
I can physically put the tape in the library but until TSM knows that it's 
actually checked in I'm stuck.
TSM won't see it until it's checked in but TSM is down.

                How would I be able to read that tape once I get it on site?

The restore process gets all its information about tape volumes from the volume 
history file and possibly the device configuration file.

One approach recommended by some TSM sites is to use a device configuration 
file modified to show a manual library and then use a library control utility 
to mount the tape when requested.

If you want to use a device configuration files that shows the actual library 
type, the process depends on the type of library.

For a SCSI library you would need to get the tape into the library and add a 
volume location record for the volume to the device configuration file.

For a 3494 I think you would just need to put the volume in the library and use 
a library control utility to set the category appropriately.

Thomas Denier
Thomas Jefferson University Hospital
The information contained in this transmission contains privileged and 
confidential information. It is intended only for the use of the person named 
above. If you are not the intended recipient, you are hereby notified that any 
review, dissemination, distribution or duplication of this communication is 
strictly prohibited. If you are not the intended recipient, please contact the 
sender by reply email and destroy all copies of the original message.

CAUTION: Intended recipients should NOT use email communication for emergent or 
urgent health care matters.