> You sound like your infrastructure is more steady-state than
> mine. 90% of my daily workload comes in between 1700 and 2300, so I
> don't do copies hourly.
Yes, that's a wicked tight window you have! My backup window is
wider--about 1700-0700, so I go ahead and let the copies run hourly all
night.
>> I understand that the COPYSTGPOOL drives count against MAXNUMMP
>> (which is counter-intuitive to me), so I haven't had the nerve to
>> try this.
>
> Oh, it works pretty well, with a few glaring exceptions.
I think I could survive the TDP failures; our DBAs allocate enough log
space that the databases can survive the odd TDP failure. I never have
been able to understand the MAXNUMMP business, though. I asked about it
on here a while back and got several good and sensible-sounding responses,
but I still couldn't get my head around it. I guess I'm just thick.
anker
|