MAX_TEMP_SPACE_PER_CONNECTION option

[SybDBA]

Dear All,

Is There any Way by which we can restrict  max temp use on user level  on Sybase IQ 15.4 ??

can we set MAX_TEMP_SPACE_PER_CONNECTION option for it ?

Thanks & Regards,

Pankaj

[tayeb_hadjou]

Hi Pankaj,

Yes, you can use this option.

As DBA, you can set it for a user, a group or public (All users).

Set option <user_or_group>.Max_Temp_Space_Per_Connection=Value (unit is MB)

As a user you can set it in temporary only for current sql connection, for tests purpose for example.

set temporary option Max_Temp_Space_Per_Connection=Value;

When the limit is reached, the query is rejected with message :

"The current operation has been cancelled: Max_Temp_Space_Per_Connection exceeded!"

Regards,

Tayeb.

[SybDBA]

Thanks Tayeb for your prompt response.

Regards,

Pankaj