• Status: Open
  • Priority: Low
  • Security: Public
  • Views: 28
  • Last Modified:

in RAM operation of DB2

hi,

for DB2, any feature/way to move all DB2 files on RAM , not just logical table / objects?
0
marrowyung
Asked:
marrowyung
2 Comments
 
Kent OlsenData Warehouse Architect / DBACommented:
Hi marrowyung,

DB2 refers to its buffer area as the bufferpool.  It's just a large chunk of memory where data pages are placed when read from disk or after being updated to be written back to disk  All of the major DBMS use a similar technique.

The files themselves are not memory resident.  It kind of defeats the purpose of a database engine to have a server so large that all of the files reside in memory.

Can you provide a little more detail on what you're trying to do?

Thanks,
Kent
0
 
marrowyungSenior Technical architecture (Data)Author Commented:
"All of the major DBMS use a similar technique."

yeah ! but that one is more on cache level and all of them do it in table level. it is too common.

MariaDB and NDB cluster can do it too.

"The files themselves are not memory resident.  It kind of defeats the purpose of a database engine to have a server so large that all of the files reside in memory.
"
I just want to know if we can find a solution that can break this kind of more than 40 years old computer science problem: RAM can't hold data once it is power off!

now we have RAM call persistent memory, which can do it. so I am wondering if DB2 world can do it.
0

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now