Archives of the TeradataForum
Message Posted: Wed, 08 Nov 2000 @ 21:07:35 GMT
First, Sorry about my very poor English !
Tom has right, so in a first help, below some command to begin, you have to know that using SCHMON is a 'must' for the DBA. Since I'm using this tool we run 50 % more jobs, however online user are more happy of their response time !
TIP : use the more partition and allocation group you can, like this it's more easy to reduce the consumption of only one user !
to create a second partition : schmon -b 1 <
Be sure to keep your default partition for online user with a high weight, 100 will be good !
- Now you have to create your news allocation groups, you have already 4 allocation for the default partition :
to create allocation : schmon -a 5 N DEF 2 (5 means the fifth allocation, DEF the policy, 2 the weight)
schmon -a 6 N DEF 6 SCHMON -a 7 N DEF 18 schmon -a 8 N DEF 56
4 allocation by partition : to represent $L $M $H $R
- Now you have to create the performance groups to use the partition via the allocation group
schmon -p 8 BATCHL 1 0 R 0 5 5 means the allocation group 5 schmon -p 9 BATCHlow$ 1 1 R 0 5 schmon -p 10 BATCHM 1 2 R 0 6 schmon -p 11 BATCHmed$ 1 3 R 0 6 schmon -p 12 BATCHH 1 4 R 0 7 schmon -p 13 BATCHhigh$ 1 5 R 0 7 schmon -p 14 BATCHR 1 6 R 0 8 schmon -p 15 BATCHrush$ 1 7 R 0 8
Now if you want the user mybatch use the BATCH partition : modify user mybatch as account='$BATCHL$';
At the next logon mybatch will use the allocation group 5 in the partition BATCH, if you want to discrease the consumption of the partition batch : discrease the weight of the partition : schmon -b 1 BATCH 2, if you want to stop mybatch :
schmon -a 5 N ABS 1. But avoid to use the ABS policy, only when your system is completely hang ! always play with the weight of the partition -> more you have partition more you have control.
But we are talking about weight not threshold ! the partition with the smallest weight can use all the CPU of the system !just because nobody is working in an another partition !
Before all read the very good presentation of Carrie Ballinger, ask it to your NCR Representative
DE LUCA CLAUDIO
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|