 |
 |
Archives of the TeradataForum
Message Posted: Thu, 17 Jun 1999 @ 19:36:38 GMT
| Subj: | | V2R3 Fair Share Scheduler |
| |
| From: | | Howard Rogers |
All,
Does anybody out there have any experience with the new V2R3 Fair Share Scheduler? We have a large 5150 warehouse running V2R3, and we're
(unwisely?) trying to add some online transaction applications to an already-busy ad-hoc warehouse system. Our ace-in-the-hole: V2R3 Fair
Share Scheduler (we hope!). According to the documentation, we should be able to setup resource partitions, and create performance groups
and allocation groups which will allow us to control the allocation of system resources. It is our intention to setup "online" and "batch"
resource partitions, with appropriate resource allocations, which will ensure that our online transactions always get top priority - even
during prime-time batch updates to the warehouse. And, we want to ensure that in the event no online transactions are running, batch gets
access to the entire machine's resources.
Am I dreaming? The only documentation I've been able to get a hold of regarding the setup and usage of the V2R3 FairShare Scheduler is
in the "Teradata RDBMS User Utilities" manual. If you've worked you're way through it at all, it's pretty complex. Any firsthand tips or
experience would be appreciated...
Howard Rogers
Senior Technical Specialist
Teradata Technical Services
IBM Global Services / AT&T
| |
