Archives of the TeradataForum

Message Posted: Wed, 08 Nov 2000 @ 21:07:35 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Claudia,

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 <> <>
                               ex : schmon -b 1 BATCH 10

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

Have fun...

DE LUCA CLAUDIO
ORACLE DBA

	<Prev	Next>		<<First	<Prev	Next>	Last>>