Topic
1 reply Latest Post - ‏2014-07-10T09:56:35Z by NenadV
X7EE_Boris_Liao
X7EE_Boris_Liao
1 Post
ACCEPTED ANSWER

Pinned topic Is there something like in-memory database in DB2 for zOS?

‏2013-11-16T08:10:15Z |

Hi,

I am trying to design a table structure in DB2/zOS to support real time update of business data.

The data are like <name1,value>, <name2, value>,.......<name100,value>. And they are updated frequently like once per second.

The query can be performed both on current value and past values depending on the timestamp, so the historic data should also be stored.

To my knowledge, the mainstream solution for this problem is  in-memory database, such as the Oracle TimesTen In-Memory Database.

We use two tables to support our need:

1. TABLE-CURRENT, stores the current value, indexed on data name, provides query on current value.

2. TABLE_HISTORIC, stores the past values, indexed on data name and timestamp, provides query on historic values.

Usually, TABLE-CURRENT is kept in memory for realtime performance.

The question is that, is there something similar as in-memory database in DB2/zOS?

Or is it OK that we just keep TABLE-CURRENT as regular db2 table?

THANKS VERY MUCH!

 

BRs,

Boris

  • NenadV
    NenadV
    3 Posts
    ACCEPTED ANSWER

    Re: Is there something like in-memory database in DB2 for zOS?

    ‏2014-07-10T09:56:35Z  in response to X7EE_Boris_Liao

    You can create an in-memory bufferpool (PGSTEAL(NONE)) and put your tablespace/table in it. Must ensure that the bufferpool is lagre enough and that you have sufficient real memory on system.

     

    Regards