• DB2 Storage Engine

    From sandrohc2010@gmail.com@21:1/5 to All on Fri Aug 3 06:37:02 2018
    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.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From David Larochette@21:1/5 to All on Fri Aug 10 19:09:13 2018
    Le 03-08-2018, sandrohc2010@gmail.com <sandrohc2010@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>

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From sandrohc2010@gmail.com@21:1/5 to All on Sat Aug 11 18:33:00 2018
    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'.
    :)

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From mikeodba@yahoo.com@21:1/5 to SANDRO HAIDEN TEIXEIRA on Thu Sep 27 02:19:08 2018
    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).

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Major Kong@21:1/5 to All on Thu Aug 22 01:19:46 2019
    On Fri, 03 Aug 2018 06:37:02 -0700, sandrohc2010 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 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)

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)