Set the MAXNUMMP to the number of drives you are willing to have this
node monopolize.  If you don't care that this node could grab all of the
drives in your library and leave everything else out in the cold, knock
yourself out.  If you want to force reasonability on your DBA's, set it
to a lower number and make sure they know what their limits are.
Of course, this assumes that there is a real good reason for sending all
your data straight to tape rather than using a diskpool.
Steve Schaub
Systems Engineer, WNI
BlueCross BlueShield of Tennessee
423-535-6574 (desk)
423-785-7347 (cell)
 

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Anker Lerret
Sent: Thursday, September 14, 2006 4:30 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] MAXNUMMP

> Is it possible that there are two or more sessions running for the TDP
client simultaneously?

Yes, absolutely.  The Oracle DBAs have observed that this happens most
frequently when there's media wait, in which case multiple log backups
could be running simultaneously.

How do others handle this?  Does it make sense to set MAXNUMMP to the
number of drives...or even higher?  I remember being very unhappy when I
set the value of MAXNUMMP to the number of drives, but I can't remember
what happened.  Maybe I was running into some other problem.

Thanks again for all the ideas,
anker
Please see the following link for the BlueCross BlueShield of Tennessee E-mail
disclaimer:  http://www.bcbst.com/email_disclaimer.shtm