in RAM operation of DB2

hi,

for DB2, any feature/way to move all DB2 files on RAM , not just logical table / objects?
LVL 1
marrowyungSenior Technical architecture (Data)Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
marrowyungSenior Technical architecture (Data)Author Commented:
hi,

any update for me ?
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

Kent OlsenData Warehouse Architect / DBACommented:
Any hardware layer that can persist across a power loss is independent of the database layer.  Persistent memory will do that, but it's generally slower than RAM and not appropriate for use as a server's RAM.  Another issue with using persistent memory as system RAM is that there is no guarantee that any process assigned a CPU (executing code and not in an idle or wait state) is stable.  If a process is updating a page, what items have been changed?  Do all items in the block reflect the before update or after update values?  Have all of the block chain edits completed or is the chain corrupt?

Current best technology is still multiple servers and multiple instances with both systems making the same updates.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
marrowyungSenior Technical architecture (Data)Author Commented:
"but it's generally slower than RAM and not appropriate for use as a server's RAM. "

any comparison on how SLOWER it is ?

"not appropriate for use as a server's RAM.  "

then why vendor still use it ? must be good to use! but still much faster than SSD, right?

"Another issue with using persistent memory as system RAM is that there is no guarantee that any process assigned a CPU (executing code and not in an idle or wait state) is stable.  If a process is updating a page, what items have been changed?  Do all items in the block reflect the before update or after update values?  Have all of the block chain edits completed or is the chain corrupt?"

so it only exists in that kind of RAM, so I think OS will take care of it ? like SUSE linux persistent memory support ?

"Current best technology is still multiple servers and multiple instances with both systems making the same updates."

horizontal scale out....
0
marrowyungSenior Technical architecture (Data)Author Commented:
tks.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
DB2

From novice to tech pro — start learning today.