Oppolzer - Informatik / Blog

R.B. wrote:

One ROT I have heard of is MAXTEMPS should be set to the old 4k
Page limit size in your V8 DB2 - Not sure I 100% agree but you could also
set it 33% of available allocated work sizes...

R.B.


From: J.A.
Sent: Wednesday, April 18, 2012 1:24 PM
To: DB2-L@lists.idug.org
Subject: [DB2-L] - RE: Regressive Testing Impact - query

Hi,

Our installation shows up like :

MAXTEMPS=0,
MAXTEMPS_RID=NOLIMIT,

Totally there is no limit at all. Any suggestions on keeping a value but I agree
that IBM gives out a value from 0 to 2147483647. Does this parameter saves
from exhausting the ASM ?

Regards,

J.

-----End Original Message-----