List the volumes together, separated by a comma:

dsmserv restore db devc=<file_device_class>
vol=/var/tsmdbbk/morning/06902830.dbb,/var/tsmdbbk/morning/06903334.dbb
commit=yes

Nick Cassimatis
877-462-6709   T/L 930-1720
nickpc AT us.ibm DOT com

He who laughs last has a good backup.



                                                                       
             Lawrence Clark                                            
             <Larry_Clark@THRU                                         
             WAY.STATE.NY.US>                                           To
             Sent by: "ADSM:           ADSM-L AT VM.MARIST DOT EDU            
             Dist Stor                                                  cc
             Manager"                                                  
             <[email protected]                                     Subject
             .EDU>                     Re: TSM DB restore              
                                                                       
                                                                       
             01/28/2005 12:42                                          
             PM                                                        
                                                                       
                                                                       
             Please respond to                                         
             "ADSM: Dist Stor                                          
                 Manager"                                              
                                                                       
                                                                       




Well, close.........
It completed volume 1 then terminated.
I ran the restore for the 2nd volume but it wanted volume 1 again.
How do you make it wait for the 2nd volume?

ANR4639I Restored 2272320 of 3083481 database pages.
ANR4639I Restored 2348608 of 3083481 database pages.
ANR1365I Volume /var/tsmdbbk/06902830.dbb closed (end reached).
ANR4584E Database restore terminated - incomplete input volume list.

[tsmserv2] /usr/tivoli/tsm/server/bin # var/tsmdbbk/06903334.dbb
commit=yes  <
ANR0000W Message repository for language AMENG does not match program
level.
ANR0000I Message repository's compile date: Tue Dec 16 08:49:40 2003
ANR0000I Program's message timestamp:       Tue Jun 10 01:10:49 2003
ANR7800I DSMSERV generated at 10:00:19 on Jun 13 2003.

Tivoli Storage Manager for AIX-RS/6000
Version 5, Release 2, Level 0.0

Licensed Materials - Property of IBM

(C) Copyright IBM Corporation 1999,2003. All rights reserved.
U.S. Government Users Restricted Rights - Use, duplication or
disclosure
restricted by GSA ADP Schedule Contract with IBM Corporation.

ANR0900I Processing options file dsmserv.opt.
ANR7811I Direct I/O will be used for all eligible disk files.
ANR8200I TCP/IP driver ready for connection with clients on port 1500.
ANR0200I Recovery log assigned capacity is 1960 megabytes.
ANR0201I Database assigned capacity is 12784 megabytes.
ANR4621I Database backup device class ADSMDBBK.
ANR4622I   Volume 1: /var/tsmdbbk/06903334.dbb.
ANR4630I Starting point-in-time database restore (commit).
ANR0300I Recovery log format started; assigned capacity 1960
megabytes.
ANR8340I FILE volume /var/tsmdbbk/06903334.dbb mounted.
ANR1368W Input volume /var/tsmdbbk/06903334.dbb contains sequence
number 2; vo
lume sequence number 1 is required.



>>> mark.stapleton AT BERBEE DOT COM 01/28/2005 10:56:42 AM >>>
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On
Behalf Of Lawrence Clark
>We have set up a backup TSM server for DR purposes.
>TSM has been installed to the same level and a database
>created of a size larger than the production TSM database, all
>DB volumes are formatted.
>
>On the production  side, the database is backed up to disk.
>This is then copied over to a 2nd AIX server...now the backup
>TSM server.
>
>Looking in the manual, it appears the database restore assumes
>the files will be on a cartridge.
>
>Questions:
>- should the server be down to restore the database?
>- what is the format of the command in an AIX environment to
>restore the db if the files are under /var/tsmdbbk/morning as so:
>-rw-------   1 root     sys      9663676416 Jan 28 04:08 06902830.dbb
>-rw-------   1 root     sys      2981181842 Jan 28 04:11 06903334.dbb

Yes, the server must be down, and no, the backup(s) don't have to be
on
a cartridge.

Assuming that there are intact and update volume history and device
configuration files, the command is basically

  dsmserv restore db todate=today source=dbbackup

If the volume history file is not present, the commands would be

  dsmserv restore db devc=<file_device_class>
    vol=/var/tsmdbbk/morning/06902830.dbb

followed by

  dsmserv restore db devc=<file_device_class>
    vol=/var/tsmdbbk/morning/06903334.dbb commit=yes

(All commands assume that you have a device configuration file
present,
and in the directory that your dsmserv.opt file points at.) The
<file_device_class> is the same devclass that you use to run the db
backups. Don't forget the commit flag for the last volume. If you
don't
put that in, you'll get to do the entire restore again.

--
Mark Stapleton (stapleton AT berbee DOT com)
Berbee Information Networks
Office 262.521.5627