SAS Viya in memory tables

[sathya66]

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,

SS

[gwootton]

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

[sbxkoenk]

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-...

Good luck,

Koen