BookmarkSubscribeRSS Feed
esbabu
Fluorite | Level 6

Hello
I am trying to grasp a conceptual understanding of the concept of "in memory" table in SAS Viya.
Is all the data loaded into memory and resides there? If not were does data resides?
I would appreciate if any body can explain this.

2 REPLIES 2
SASKiwi
PROC Star

In-memory tables are used extensively in Viya and are managed by CAS servers. As soon as a CAS server is shut down, the tables disappear. To read the tables back into memory the CAS server needs to be started and the tables read back in from permanent storage.

 

However Viya also has Compute servers which function just like the SAS 9.4 ones where data is read from and written to permanent storage.

Sajid01
Meteorite | Level 14

In memory tables are actually are tables stored in SASHDAT format in the CAS_DISK_CACHE.
The address of this data table is mapped to the process space in memory (RAM). Look here for more details https://www.ibm.com/docs/es/aix/7.2?topic=memory-understanding-mapping 

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

Discussion stats
  • 2 replies
  • 449 views
  • 1 like
  • 3 in conversation