Re: DB2 Storage Engine

Newsgroups	comp.databases.ibm-db2
Date	2018-09-27 02:19 -0700
References	<f7c3b21f-4086-4727-9336-af5ca0c0675e@googlegroups.com>
Message-ID	<cd03b221-55c4-4e2e-bbed-75222ac86383@googlegroups.com> (permalink)
Subject	Re: DB2 Storage Engine
From	mikeodba@yahoo.com

Show all headers | View raw

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

Back to comp.databases.ibm-db2 | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

DB2 Storage Engine sandrohc2010@gmail.com - 2018-08-03 06:37 -0700
  Re: DB2 Storage Engine David Larochette <david@larochette.me> - 2018-08-10 19:09 +0000
    Re: DB2 Storage Engine sandrohc2010@gmail.com - 2018-08-11 18:33 -0700
  Re: DB2 Storage Engine mikeodba@yahoo.com - 2018-09-27 02:19 -0700
  Re: DB2 Storage Engine Major Kong <learn.to@love.thebomb.invalid> - 2019-08-22 01:19 +0000

csiph-web