Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

DB2 Storage Engine

89 views
Skip to first unread message

sandro...@gmail.com

unread,
Aug 3, 2018, 9:37:05 AM8/3/18
to

Hello, I am doing an academic work, and one of the activities is to find out which storage engine Db2 used, I already researched a lot, but this information is not so easy to find as for example would be for DBMS MySQL, so I wonder if someone from here would have this information and can share it.
I thank you for your attention.

David Larochette

unread,
Aug 10, 2018, 3:09:15 PM8/10/18
to
Le 03-08-2018, sandro...@gmail.com <sandro...@gmail.com> a écrit :
>
> Hello, I am doing an academic work, and one of the activities is to find out which storage engine Db2 used, I already researched a lot, but this information is not so easy to find as for example would be for DBMS MySQL, so I wonder if someone from here would have this information and can share it.
> I thank you for your attention.

Not sure what you mean by storage engine. On z/OS, DB2 uses VSAM/LDS.
<http://www.redbooks.ibm.com/redpapers/pdfs/redp4187.pdf>

sandro...@gmail.com

unread,
Aug 11, 2018, 9:33:02 PM8/11/18
to
MySQL has the default Storage engine InnoDB and alternatives are Merge, Memory among others, so I would like to know if in DB2 Express you can choose other storage engines, and if not, what would be the name of the standard Storage Engine of 'IBM DB2 Express'.
:)

mike...@yahoo.com

unread,
Sep 27, 2018, 5:19:10 AM9/27/18
to
On Friday, 3 August 2018 14:37:05 UTC+1, SANDRO HAIDEN TEIXEIRA wrote:
> Hello, I am doing an academic work, and one of the activities is to find out which storage engine Db2 used, I already researched a lot, but this information is not so easy to find as for example would be for DBMS MySQL, so I wonder if someone from here would have this information and can share it.
> I thank you for your attention.

Db2 RDBMS is a proprietary set of products from IBM and it has at least three distinct separate source-code bases (for Z/OS mainframes, for i-Series (formerly AS/400), for Linux/Unix/Windows). Functionality differs between the platforms. The RDBMS engine is different for all three and is proprietary and trade secret of IBM.

The code that is in 'IBM Db2 Express' is the same as the code that is in Db2 for Linux/Unix/Windows (the licence controls which functionality is available, along with the hardware).

Depending on the licence and the hardware on which it runs, Db2 for Linux/Unix/Windows lets you choose row-based tables, column-based tables (in-memory ) and different physical layout options , including range-partitioning, logical-partitioning, physical partitioning. Db2-LUW does not offer different index types, regular indexes are B+ trees, unless the table is range-clustered. Indexes can be partitioned, and distributed (subject to licence and hardware).

Major Kong

unread,
Aug 21, 2019, 9:19:56 PM8/21/19
to
DB2 uses InnoDB2 engine. You can call IBM and ask for the source code of
InnoDB2 engine. There is a nice lady named Ginni Rometty who will gladly
send you the source code for DB2. You can call IBM at 877-426-6006, ask
for Ginni and tell her that Ethan sent you.



--
I love the smell of napalm in the morning!
(Appocalypse Now)
0 new messages