DB2 Storage Engine

[s***@gmail.com]

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]

Post by s***@gmail.com
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>

[s***@gmail.com]

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'.
:)

[m***@yahoo.com]

Post by s***@gmail.com
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]

Post by s***@gmail.com
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 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.