Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>DB2 is a family of database servers developed by IBM. The supported platforms for DB2 servers are <a href="http://www-01.ibm.com/software/data/db2/zos/" rel="nofollow">z/OS</a> (formerly OS/390), <a href="http://www-01.ibm.com/software/data/db2/linux-unix-windows/" rel="nofollow">Linux, UNIX, and Windows</a> (referred to collectively as DB2 for LUW), and <a href="http://www-03.ibm.com/systems/i/software/db2/index.html" rel="nofollow">IBM i</a> (formerly OS/400 or i5/OS). Originally designed as a relational engine, IBM has expanded DB2's capabilities on some platforms to include <a href="http://www-01.ibm.com/software/data/db2/xml/" rel="nofollow">native XML database features</a> and an <a href="http://publib.boulder.ibm.com/infocenter/db2luw/v10r1/topic/com.ibm.swg.im.dbclient.rdf.doc/doc/c0059661.html" rel="nofollow">RDF-compliant graph store</a>. On the IBM i platform, <a href="http://www-03.ibm.com/systems/i/software/db2/db2faq.html" rel="nofollow" title="IBM DB2 for i: FAQs">DB2 for i</a> is tightly integrated into the operating system in a variety of ways, including a unique file system layer that allows database tables to be treated as structured files and vice versa.</p> <p>DB2 for LUW has different editions: <a href="http://www-01.ibm.com/software/data/db2/express/" rel="nofollow">Express-C</a>, <a href="http://www-01.ibm.com/software/data/db2/linux-unix-windows/edition-express.html" rel="nofollow">Express Edition</a>, <a href="http://www-01.ibm.com/software/data/db2/linux-unix-windows/edition-workgroup.html" rel="nofollow">Workgroup Server Edition</a>, <a href="http://www-01.ibm.com/software/data/db2/linux-unix-windows/edition-enterprise.html" rel="nofollow">Enterprise Server Edition</a> and <a href="http://www-01.ibm.com/software/data/db2/linux-unix-windows/edition-advanced-enterprise.html" rel="nofollow">Advanced Enterprise Server Edition</a>. Each of these editions has different engine capabilities and different limits on the amount of RAM and the number of CPU cores that DB2 can use. DB2 for LUW offers a smooth upgrade path for databases that were created in a lower edition of the product (e.g., going from Workgroup Server Edition to Enterprise Server Edition).</p> <p><a href="http://www-01.ibm.com/software/data/db2/express/" rel="nofollow">DB2 Express-C</a> is a no-cost DB2 engine that runs on Linux and Windows and is authorized for production use and redistribution. As part of the <a href="http://www-01.ibm.com/common/ssi/cgi-bin/ssialias?infotype=an&amp;subtype=ca&amp;appname=gpateam&amp;supplier=897&amp;letternum=ENUS213-210" rel="nofollow" title="IBM announcement letter for DB2 10.5 for Linux, UNIX, and Windows">DB2 10.5</a> release in June 2013, IBM extended the system resource limits for DB2 Express-C to allow the database engine to use up to 16GB RAM and two CPU cores, and set a maximum size of 15 terabytes per database.</p> <p>In October 2009, IBM introduced <a href="http://www-01.ibm.com/software/data/db2/linux-unix-windows/editions-features-purescale.html" rel="nofollow">DB2 pureScale</a>, a database cluster solution for AIX on <a href="http://www-03.ibm.com/systems/p/index.html" rel="nofollow">System p</a>, suitable for online transaction processing (OLTP) workloads. Linux x86_64 support for DB2 pureScale on IBM System x hardware was added in August 2010. IBM based the design of DB2 pureScale on the Parallel Sysplex implementation of DB2 data sharing on z/OS. DB2 pureScale provides a fault-tolerant, clustered database engine that uses low-latency RDMA messaging and <a href="http://www.ibm.com/systems/software/gpfs" rel="nofollow">GPFS shared storage</a> to present the appearance of a single, monolithic database to the application layer.</p> <p>To handle large data volumes and complex queries that are common to online analytical processing (OLAP), DB2 for LUW provides a shared-nothing clustering implementation known as the database partitioning feature (DPF), which uses hash key partitioning to evenly distribute a single copy of the database across multiple servers. Incoming queries are automatically multiplexed to access multiple partitions in parallel. DPF was introduced in 1994, as was at times rebranded as DB2 Parallel Edition, DB2 Extended Enterprise Edition, or InfoSphere Warehouse.</p> <p>The 10.5 version includes the BLU acceleration that consist in storing the data in columnar format. It allows to store data in rows or in columns and that improves the analytics performance.</p> <h3>Free DB2 Books</h3> <ul> <li><a href="http://public.dhe.ibm.com/software/dw/db2/express-c/wiki/Getting_Started_with_DB2_Express_v9.7_p4.pdf" rel="nofollow">Getting started with DB2 Express-C</a> (PDF)</li> <li><a href="http://public.dhe.ibm.com/software/dw/db2/express-c/wiki/Getting_Started_with_IBM_Data_Studio_for_DB2_p3.pdf" rel="nofollow">Getting started with IBM Data Studio for DB2</a> (PDF)</li> <li><a href="http://public.dhe.ibm.com/software/dw/db2/express-c/wiki/Getting_Started_with_DB2_App_Dev_p2.pdf" rel="nofollow">Getting started with IBM DB2 development</a> (PDF)</li> </ul>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTTagWiki
    1. USAngocA
    1. USKevin Beck
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload