how to clean a user's maxperm

Database
Enthusiast

how to clean a user's maxperm

I have moved 5G permspace under user A for his stored procedures. After he finished the task, he dropped his procedures and I tried to move out this 5G permspace back to other database. Move space succeeded, but I noticed that Teradata administrator still shows that there is about 40 bytes maxperm under this user.
has any body encounered that before?
Besides, we are using V2R5. At the time this user was running his procedures, one node of our teradata database down and then the whole system down. Our maitenance guys said 'There was a problem with node 1-5 accessing VPROCS due to a DR in the PDE portion of the database. The DR is fixed in the latest patches for 5.1.2.' Could anybody explain that too..

Thanks,
4 REPLIES
Teradata Employee

Re: how to clean a user's maxperm

Hello,

What is the CurrentPerm for that user?

MaxPerm is the maximum perm-space in bytes, ever occupied. It is not the current perm-space!

HTH.

Regards,

Adeel
Enthusiast

Re: how to clean a user's maxperm

Adeel seems to be confusing MaxPerm with PeakPerm.

You can change MaxPerm to anything you want using the MODIFY USER statement.

Teradata Employee

Re: how to clean a user's maxperm

Exactly ... Jim Chapman is right ... my bad!! :(
Enthusiast

Re: how to clean a user's maxperm

Thank you guys. I used modify user to change the permanent space to 0 bytes