- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 09-22-2022 11:12 AM
(1081 views)
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
Greg Wootton | Principal Systems Technical Support Engineer
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
Good luck,
Koen