Please see remarks below.

-----Original Message-----
From: Andrew Raibeck [mailto:storman AT US.IBM DOT COM]
Sent: Thursday, October 09, 2003 12:04 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: DB Mirroring Help Urgently needed - [was Re: how to disable
T SM db mirroring?]


>- Can you show the output from a DIR command of the "phantom" volume file?

The original file does not exist (drive failure).  The new volume to be used
is per the pathname below.

>- Can you show the output from the DELETE DBVOLUME command?

ANR2431E DELETE DBVOLUME: Volume F:\ADSM_SERVER\DB\DB5.DSM is not a defined
database volume.

>- Can you show the output from QUERY DBVOLUME F=D?

Volume Name (Copy 1): F:\ADSM_SERVER\DB\DB5.DSM
         Copy Status: Off-Line
Volume Name (Copy 2): E:\ADSM_SERVER\DB\DB5COPY.DSM
         Copy Status: Sync'd
Volume Name (Copy 3):
         Copy Status: Undefined
Available Space (MB): 30,000
Allocated Space (MB): 30,000
     Free Space (MB): 0



>About the only other thing I can suggest is to create a new database
>volume and mirror that are the same size as the DB5COPY.DSM volume on E:.
>Don't make them a mirror of DB5COPY.DSM, but make them new database
>volumes. Don't extend the db, but then do a DELETE DBVOLUME for the
>DB5COPY.DSM volume. Once that volume is deleted, do you still see the
>"phantom" volume?

Tried this before but without mirroring, although I did extend the database.
Will try again without extending and try.  It would not let me before
reporting that the mirror was not sync'd so would not delete the
DB5COPY.DSM.

>I don't know what else to tell you. Unfortunately you are running a 3.1
>server (if I recall from previous discussion), so you are long out of
>support.

...yup...

>Regards,

>Andy

>Andy Raibeck
>IBM Software Group
>Tivoli Storage Manager Client Development
>Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
>Internet e-mail: storman AT us.ibm DOT com

>The only dumb question is the one that goes unasked.
>The command line is your friend.
>"Good enough" is the enemy of excellence.




"Ward, Stuart" <Wards AT BMCMASK DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
10/09/2003 07:21
Please respond to "ADSM: Dist Stor Manager"

        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        Re: DB Mirroring Help Urgently needed - [was Re:
how to disable T SM         db mirroring?]


With respect, that is not really my issue - although the v3.1 manual does
say to do so for DB and Log volumes in addition to the other types you
rightly specify.

I am having trouble bringing the sync'd mirror status back up as the 'F'
volume is not coming back online.  Seems whatever I try, ADSM reports that
it is not a 'defined database volume'.  The volume physically exists again
(after DR) in that specified location and the set up was working for over
a
year previously.  At some point it must have been defined to be able to
create the mirror in the first place.

Rebooting the server with the volume in place does not prompt the app to
bring it back online by itself.

Regards

Stu

-----Original Message-----
From: Stapleton, Mark [mailto:stapleto AT BERBEE DOT COM]
Sent: Thursday, October 09, 2003 10:08 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: DB Mirroring Help Urgently needed - [was Re: how to disable
TSM db mirroring?]


From: Ward, Stuart [mailto:Wards AT BMCMASK DOT COM]
>Volume Name      Copy    Volume Name       Copy    Volume Name       Copy
(Copy 1)          Status  (Copy 2)          Status  (Copy 3) Status
----------------  ------  ----------------  ------  ----------------
------
F:\ADSM_SERVER\-  Off-L-  E:\ADSM_SERVER\-  Sync'd Undef-
 DB\DB5.DSM        ine     DB\DB5COPY.DSM ined



10/07/2003 11:45:20   ANR2017I Administrator ADMIN issued command: VARY
ONLINE
                       F:\ADSM_SERVER\DB\DB5.DSM

10/07/2003 11:45:20   ANR2422E VARY ONLINE: Volume
F:\ADSM_SERVER\DB\DB5.DSM
is
                       not a defined disk volume.<



You don't vary on a db volume; you varyon file volumes for a disk-based
storage pool. To enable new db volumes, you extend the db.

--

Mark Stapleton (stapleton AT berbee DOT com)






Confidentiality Notice:  The information contained in this e-mail and any
attachments may be legally privileged and confidential.  If you are not an
intended recipient, you are hereby notified that any dissemination,
distribution or copying of this e-mail is strictly prohibited.  If you
have
received this e-mail in error, please notify the sender and permanently
delete the e-mail and any attachments immediately.  You should not retain,
copy or use this e-mail or any attachment for any purpose, nor disclose
all
or any part of the contents to any other person.


Confidentiality Notice:  The information contained in this e-mail and any
attachments may be legally privileged and confidential.  If you are not an
intended recipient, you are hereby notified that any dissemination,
distribution or copying of this e-mail is strictly prohibited.  If you have
received this e-mail in error, please notify the sender and permanently
delete the e-mail and any attachments immediately.  You should not retain,
copy or use this e-mail or any attachment for any purpose, nor disclose all
or any part of the contents to any other person.