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 

CLI in SAS Viya

Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.

Find more tutorials on the SAS Users YouTube channel.

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