topic Re: Cleanup CASUSER tables in Administration and Deployment

Cleanup CASUSER tables

bheinsius — Fri, 05 Aug 2022 15:55:12 GMT

Hi,

On Viya 4, as CAS memory is a scarce resource, we want to periodically cleanup in-memory CASUSER tables that are older than x days.

Since CASUSER is a Personal CASLIB, it is only accessible to the user who owns the CAS session.

Is there a way to do this centrally?

- Bart

Re: Cleanup CASUSER tables

sbxkoenk — Fri, 05 Aug 2022 17:12:11 GMT

Hello Bart,

Not sure about this. I guess more people will reply.

But consider telling your users about the lifetime parameter in the LoadTable action.

See this Communities Library Article for an explanation :

Tired of deleting temporary CAS tables? Let CAS do it for you.
Posted 11-19-2021 02:15 PM | by briankinnebrew (3513 views)
https://communities.sas.com/t5/SAS-Communities-Library/Tired-of-deleting-temporary-CAS-tables-Let-CAS-do-it-for-you/ta-p/781309

If you put lifetime on 180, your CAS table will disappear after 3 minutes (3 * 60 = 180).

Cheers,

Koen

Re: Cleanup CASUSER tables

bheinsius — Fri, 05 Aug 2022 18:26:57 GMT

Hi Koen,

Thanks for your reply. While that is an option I don't think this option is available for tables imported using the Viya interfaces or those loaded from SAS94 to CAS. Also it puts the responsibility for housekeeping with the users where we probably both know they are not so good at that 😉

A periodic restart of the CAS Server would do the job of course but that seems a bit rigorous.

Cheers,
Bart

Re: Cleanup CASUSER tables

sbxkoenk — Fri, 05 Aug 2022 18:40:44 GMT

Hello Bart,

Indeed, do not rely on the end-users for keeping the environment healthy. 😉

Most servers are patched (non-SAS stuff) and rebooted every month and then the memory is purged of course.

But a re-start also kicks out the tables that are in CAS (in memory) for a few minutes.

So re-starting is not the best option to do what you want to achieve.

In the job scheduler (see Environment Manager cog | gear icon), is a sample job :

But I do not know how to see its source code.

You can schedule it and read the LOG of course.
Maybe it can serve as inspiration (?).

Koen

Re: Cleanup CASUSER tables

sbxkoenk — Fri, 05 Aug 2022 18:54:15 GMT

On top of my previous reply (see just above!) :

Re: Cleanup CASUSER tables

bheinsius — Fri, 05 Aug 2022 20:11:29 GMT

Hi Koen,

This one tells how to do it:

Viya administrators can now get personal with users' Caslibs
By Gerry Nelson on SAS Users February 17, 2020
https://blogs.sas.com/content/sgf/2020/02/17/viya-administrators-personal-caslibs/

From there:

With the (super user) role assumed, the administrator can execute the accessControl.accessPersonalCaslibs action and the subsequent table.caslibinfo action returns all caslibs including any personal caslibs that existed when the session started.

Thanks!

Bart