i think you need to use the commit=yes in your db restore command. This
way tsm knows you are done restoring your db.

Otto Schakenbos
System Administrator

TEL: +49-7151/502 8468
FAX: +49-7151/502 8489
MOBILE: +49-172/7102715
E-MAIL: oschakenbos AT teleflex DOT com

TFX IT-Service AG
Fronackerstrasse 33-35
71332 Waiblingen
GERMANY




Nghia Tran Dai wrote:

Hi all,
I use TSM ver 5.1.7
The database and log file of my TSM server were lost. I backuped database (volume 
history, device configuration file) and now I use them to restore database of TSM server. 
But I get error message when I start "TSM server 1" service  after restored 
database successfully.


I did as following:

C:\Program Files\tivoli\tsm\server>dsmserv format 1 C:\tsmdata\server1\log1.dsm
9 1 C:\tsmdata\server1\db1.dsm 13
ANR0900I Processing options file C:\Program Files\tivoli\tsm\server\dsmserv.opt.
ANR7800I DSMSERV generated at 12:02:29 on Aug 21 2002.
Tivoli Storage Manager for Windows
Version 5, Release 1, Level 5.0
Licensed Materials - Property of IBM
5698-ISE (C) Copyright IBM Corporation 1999,2002. All rights reserved.
U.S. Government Users Restricted Rights - Use, duplication or disclosure
restricted by GSA ADP Schedule Contract with IBM Corporation.
Allocated space for C:\tsmdata\server1\log1.dsm: 9437184 bytes.
Allocated space for C:\tsmdata\server1\db1.dsm: 13631488 bytes.
ANR0300I Recovery log format started; assigned capacity 8 megabytes.
ANR0301I Recovery log format in progress; 4 megabytes of 8.
ANR0301I Recovery log format in progress; 8 megabytes of 8.
ANR0302I Recovery log formatting took 0 milliseconds.
ANR0303I Format rate:     1.$ pages/second.
ANR0304I Page service time:     0.0 ms.
ANR0305I Recovery log format complete.
ANR0306I Recovery log volume mount in progress.
ANR0353I Recovery log analysis pass in progress.
ANR0354I Recovery log redo pass in progress.
ANR0355I Recovery log undo pass in progress.
ANR0352I Transaction recovery complete.
ANR0992I Server installation complete.

C:\Program Files\tivoli\tsm\server>dsmserv restore db volumenames=C:\tsmdata\ser
ver1\83828523.dbb devclass=filedev1 commit=no
ANR0900I Processing options file c:\program files\tivoli\tsm\server1\dsmserv.op-
t.
ANR7800I DSMSERV generated at 12:02:29 on Aug 21 2002.
Tivoli Storage Manager for Windows
Version 5, Release 1, Level 5.0
Licensed Materials - Property of IBM
5698-ISE (C) Copyright IBM Corporation 1999,2002. All rights reserved.
U.S. Government Users Restricted Rights - Use, duplication or disclosure
restricted by GSA ADP Schedule Contract with IBM Corporation.
ANR8200I TCP/IP driver ready for connection with clients on port 1500.
ANR0200I Recovery log assigned capacity is 8 megabytes.
ANR0201I Database assigned capacity is 12 megabytes.
ANR4621I Database backup device class FILEDEV1.
ANR4622I   Volume 1: C:\TSMDATA\SERVER1\83828523.DBB.
ANR4632I Starting point-in-time database restore (no commit).
ANR8340I FILE volume C:\TSMDATA\SERVER1\83828523.DBB mounted.
ANR1363I Input volume C:\TSMDATA\SERVER1\83828523.DBB opened (sequence number 
1).
ANR4646I Database capacity required for restore is 12 megabytes.
ANR4638I Restore of backup series 1 operation 0 in progress.
ANR1364I Input volume C:\TSMDATA\SERVER1\83828523.DBB closed.
ANR4640I Restored 258 pages from backup series 1 operation 0.
ANR4633I Point-in-time database restore (no commit) complete.

I don't know how to deal with this problem. Could you help me ?

Thanks in advanced,

Nghiatd