ADSM-L

Re: Database and log format question.

2004-04-28 09:38:57
Subject: Re: Database and log format question.
From: Justin Bleistein <justin.bleistein AT SUNGARD DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 28 Apr 2004 09:34:53 -0400
3 hours? Wow!. What's are the hardware specs of your tsm server? What else
is going on, on that system (topas, if AIX, or top)?
I would probably consider running either a database audit or re-org, then
try mounting it again.
thanks!

      On more thing, are you starting the server up again in the foreground
or background?. If your initially trying to start it up in
the background, kill it and start it up in the foreground first then let it
do all of it's redo log record and undo passes, as well as log mount.
Then once it's up, and you get a tsm server prompt. Then halt the server
and restart it in the background for production operation
at that point. Just another thought.

--Justin Richard Bleistein


|---------+---------------------------->
|         |           "Remeta, Mark"   |
|         |           <MRemeta@SELIGMAN|
|         |           DATA.COM>        |
|         |           Sent by: "ADSM:  |
|         |           Dist Stor        |
|         |           Manager"         |
|         |           <[email protected]|
|         |           .EDU>            |
|         |                            |
|         |                            |
|         |           04/28/2004 09:19 |
|         |           AM               |
|         |           Please respond to|
|         |           "ADSM: Dist Stor |
|         |           Manager"         |
|         |                            |
|---------+---------------------------->
  
>------------------------------------------------------------------------------------------------------------------------------|
  |                                                                             
                                                 |
  |       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.