topic Re: SAS Viya in memory tables in Administration and Deployment

SAS Viya in memory tables

sathya66 — Thu, 22 Sep 2022 15:12:23 GMT

Hi All,

We were agreed that SAS viya would be 6 monthly outage. The problem for us is losing all in-memory tables when Viya is restarted. Can we do backs up in-memory tables then restores them after a restart.

I know SAS Viya won't need outage when we are doing hotfixes/patching but we are planning outages for server maintenance (ex:linux patching, etc )

Thanks,

Re: SAS Viya in memory tables

gwootton — Thu, 22 Sep 2022 15:32:14 GMT

Have you seen this post? https://communities.sas.com/t5/Administration-and-Deployment/Modify-casstartup-usermods-lua-to-load-cas-table-automatically/td-p/785734

Re: SAS Viya in memory tables

sbxkoenk — Thu, 22 Sep 2022 15:55:00 GMT

Hello ,

See here for the "manual" way :

CAS User’s Guide -- CASUTIL Procedure

SAVE Statement
The SAVE statement creates a permanent copy of an in-memory table. The in-memory table is saved to the data source that is associated with the caslib.
LOAD Statement
The LOAD statement reads data from a file in a caslib’s data source, a libref, or a client-side file and loads it into memory on SAS Cloud Analytic Services.
Example 4: Saving and Loading Encrypted SASHDAT Files
https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/casref/p1et7qytnh6dvbn1urs5rhw5uyf7.htm

When understanding this, try to automate with the article proposed by @gwootton :

title : Modify casstartup_usermods.lua to load cas table automatically from SASHDAT files after restart

https://communities.sas.com/t5/Administration-and-Deployment/Modify-casstartup-usermods-lua-to-load-cas-table-automatically/td-p/785734

Good luck,

Koen