BookmarkSubscribeRSS Feed
sathya66
Barite | Level 11

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

2 REPLIES 2
gwootton
SAS Super FREQ
Have you seen this post? https://communities.sas.com/t5/Administration-and-Deployment/Modify-casstartup-usermods-lua-to-load-...
--
Greg Wootton | Principal Systems Technical Support Engineer
sbxkoenk
SAS Super FREQ

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

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 824 views
  • 4 likes
  • 3 in conversation