ADSM-L

Re: Database and log format question.

2004-04-28 09:29:04
Subject: Re: Database and log format question.
From: Daniel Sparrman <Daniel.Sparrman AT EXIST DOT SE>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 28 Apr 2004 15:27:08 +0200
Hi 

When referring to "mounting the logs", do you mean the recovery log mount 
which is initiated during dsmserv startup?

The db volumes you lost, do you have fresh copies of theese? As I 
understand it, you need to do a database restore, which for me means that 
your databas is unusable. In this case, you should define the new volumes, 
do a dsmserv format, and then do the restore. If you choose to do a commit 
of the logs, then the answer is yes, this will take a very long time, as 
TSM will need to commit everything that is stored in your log(13GB:s).

If you're running TSM on a UNIX box, easiest thing todo is to check your 
IO stats to see wether or not the database disks are used. If you dont 
have any activity, there's a large possibility that the dsmserv process 
has hung.

Best Regards

Daniel Sparrman
-----------------------------------
Daniel Sparrman
Exist i Stockholm AB
Propellervägen 6B
183 62 TÄBY
Växel: 08 - 754 98 00
Mobil: 070 - 399 27 51



"Remeta, Mark" <MRemeta AT SELIGMANDATA DOT COM> 
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
2004-04-28 15:19
Please respond to
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>


To
ADSM-L AT VM.MARIST DOT EDU
cc

Subject
Database and log format question.






Yesterday morning I had an incident and lost one of the drives I had about
half my database volumes defined on.
I'm in the process of reformatting the log and database volumes so I can 
do
a database restore.
The database is 100gb and my log size is 13gb.
It's been mounting the log volumes for over 3 hours now.
Does anyone have any experience with a database this large in as far as
approximately how long it will take to format and mount the database/log
volumes?


Thanks in advance,
Mark Remeta


Confidentiality Note: The information transmitted is intended only for the
person or entity to whom or which it is addressed and may contain
confidential and/or privileged material. Any review, retransmission,
dissemination or other use of this information by persons or entities 
other
than the intended recipient is prohibited. If you receive this in error,
please delete this material immediately.