Knowledge

IBM Db2

Source đź“ť

1158:(IOT), industrial, telecommunications, financial services, online retail and other industries needing to perform real-time analytics on streamed high volume, high velocity data. It became publicly available in June 2017. It can store and analyze 250 billion events in a day with just 3 server nodes with its high speed data capture and analytics capabilities. The need to support AI and machine learning was envisioned from the start by including IBM Watson Studio into the product, and integrating Jupyter notebooks for collaborative app and model development. Typically combined with streaming tools, it provides persistent data by writing the data out to object storage in an open data format (Apache Parquet). Built on Spark, Db2 Event Store is compatible with Spark Machine Learning, Spark SQL, other open technologies, as well as the Db2 family Common SQL Engine and all languages supported – including Python, GO, JDBC, ODBC, and more. 2646: 336: 152: 4591: 4571: 3113: 3123: 25: 3133: 4581: 726:, in which a single large database is partitioned across multiple DB2 servers that communicate over a high-speed interconnect. This DB2 edition was eventually ported to all Linux, UNIX, and Windows (LUW) platforms, and was renamed to DB2 Extended Enterprise Edition (EEE). IBM now refers to this product as the Database Partitioning Feature (DPF) and bundles it with their flagship DB2 Enterprise product. 353: 100: 714:
environment), and DB2/VM (for the VM operating system). IBM lawyers stopped this handy naming convention from being used and decided that all products needed to be called "product FOR platform" (for example, DB2 for OS/390). The next iteration of the mainframe and the server-based products was named DB2 Universal Database (or DB2 UDB).
587:. At the time, IBM didn't believe in the potential of Codd's ideas, leaving the implementation to a group of programmers not under Codd's supervision. This led to an inexact interpretation of Codd's relational model that matched only part of the prescriptions of the theory; the result was Structured English QUEry Language or 826:. This allows users on the IBM i platform and users on other platforms to access these files through the MySQL interface. On IBM i and its predecessor OS/400, DB2 is tightly integrated into the operating system, and comes as part of the operating system. It provides journaling, triggers and other features. 2089:
Since the 1970s, when IBM Research invented the Relational Model and the Structured Query Language (SQL), IBM has developed a complete family of RDBMS software. Development started on mainframe platforms such as Virtual Machine (VM), Virtual Storage Extended (VSE), and Multiple Virtual Storage (MVS).
1420:
Db2 can be administered from either the command-line or a GUI. The command-line interface requires more knowledge of the product but can be more easily scripted and automated. The GUI is a multi-platform Java client that contains a variety of wizards suitable for novice users. Db2 supports both SQL
1309:
On January 30, 2006, IBM announced a special free version of DB2 Express edition called DB2 Express-C. The DB2 Express-C edition was created for the 8.2 release of IBM Db2. After this Db2 Express-C was created for all new DB2 versions: 9.1 (codenamed "Viper"), 9.5 (codename "Viper 2"), 9.7 (codename
1296:
IBM Db2 Community edition, as of version 11.5.1, has no limit on the database size. Some previous version 11.5 point releases imposed a limit of 100 GB on the database size. The database engine does not limit the number of concurrent user connections. A prior free Db2 version, the IBM DB2 Express-C,
1292:
On June 27, 2019, IBM released Db2 V11.5, a Db2 update designed to deliver enhancements to help automate data management, eliminate ETL, and support artificial intelligence data workloads. Along with the update, IBM unveiled streamlined offerings. The Db2 Community Edition replaces the Express-C and
628:
operating systems in 1981. In 1976, IBM released Query by Example for the VM platform where the table-oriented front-end produced a linear-syntax language that drove transactions to its relational database. Later, the QMF feature of DB2 produced real SQL, and brought the same "QBE" look and feel to
1145:
Through the integration with the IBM Common SQL Engine, Big SQL was designed to work with all the Db2 family of offerings, as well as with the IBM Integrated Analytics System. Big SQL is a part of the IBM Hybrid Data Management Platform, a comprehensive IBM strategy for flexibility and portability,
594:
When IBM released its first relational-database product, they wanted to have a commercial-quality sublanguage as well, so they overhauled SEQUEL and renamed the revised language Structured Query Language (SQL) to differentiate it from SEQUEL, and also because the acronym "SEQUEL" was a trademark of
1318:
The Db2 Standard Edition is available as a perpetual software license for production and non-production use for up to 16 processor cores and 128 GB RAM with IBM support. For production use, Db2 Standard Edition can be licensed based on a Virtual Processor Core metric, wherein it is licensed by the
870:
In 1999, GA of V6. It added object-relational support. "Objects" here mean data items longer than 32K (up to then the maximal length of a table row, more precisely a table record), such as images, videos, or text. DB2 could now store and handle such objects. Furthermore, it added trigger support.
1087:
Elasticity: Db2 Warehouse on Cloud offers independent scaling of storage and compute, so organizations can customize their data warehouses to meet the needs of their businesses. For example, customers can burst on compute during peak demand, and scale down when demand falls. Users can also expand
1044:
Autonomous cloud service: Db2 Warehouse on Cloud runs on an autonomous platform-as-a-service, and is powered by Db2's autonomous self-tuning engine. Day-to-day operations, including database monitoring, uptime checks and failovers, are fully automated. Operations are supplemented by a DevOps team
850:
Db2 (now short for the former "Db2 for LUW") is a relational database that delivers advanced data management and analytics capabilities for transactional workloads. This operational database is designed to deliver high performance, actionable insights, data availability and reliability, and it is
944:
Db2 Warehouse uses Docker containers to run in multiple environments: on-premise, private cloud and a variety of public clouds, both managed and unmanaged. Db2 Warehouse can be deployed as software only, as an appliance and in Intel x86, Linux and mainframe platforms. Built upon IBM's Common SQL
829:
In early 2012, IBM announced the next version of DB2, DB2 10.1 (code name Galileo) for Linux, UNIX, and Windows. DB2 10.1 contained a number of new data management capabilities including row and column access control which enables 'fine-grained' control of the database and multi-temperature data
983:
Encryption: Db2 on Cloud complies with data protection laws and includes at-rest database encryption and SSL connections. The Db2 on Cloud high availability plans offer rolling security updates and all database instances include daily backups. Security patching and maintenance is managed by the
908:
Increases in computational power resulted in an explosion of data inside businesses generally and data warehouses specifically. Warehouses grew from being measured in GBs to TBs and PBs. As both the volume and variety of data grew, Db2 Warehouse adapted as well. Initially purposed for star and
1327:
The Db2 Advanced Edition is available only as a component of the IBM Hybrid Data Management Platform (HDMP). Within HDMP, Db2 is available both as a perpetual software license AND a monthly subscription for unrestricted production and non-production use with premium IBM support. For both HDMP
713:
Eventually, IBM decided to rewrite the software completely. The new version of Database Manager were called DB2/2 and DB2/6000 respectively. Other versions of DB2, with different code bases, followed the same '/' naming convention and became DB2/400 (for the AS/400), DB2/VSE (for the DOS/VSE
1059:
Manage highly concurrent workloads: Db2 Warehouse on Cloud includes an Adaptive Workload Management technology that automatically manages resources between concurrent workloads, given user-defined resource targets. This technology ensures stable and reliable performance when tackling highly
798:
In June 2009, IBM announced "Cobra", the codename for DB2 9.7 for LUW. DB2 9.7 added data compression for database indexes, temporary tables, and large objects. DB2 9.7 also supported native XML data in hash partitioning (database partitioning), range partitioning (table partitioning), and
904:
Traditional transaction processing databases were not able to provide the insight business leaders needed to make data-informed decisions. A new approach was needed to aggregate and analyze data from multiple transactional sources to deliver new insights, uncover patterns, and find hidden
799:
multi-dimensional clustering. These native XML features allow users to directly work with XML in data warehouse environments. DB2 9.7 also added several features that make it easier for Oracle Database users to work with DB2. These include support for the most commonly used SQL syntax,
1141:
Users (data scientists and analysts) can run smarter ad hoc and complex queries supporting more concurrent users with less hardware compared to other SQL options for Hadoop. Big SQL provides an ANSI-compliant SQL parser to run queries from unstructured streaming data using new APIs.
1137:
Big SQL offers a single database connection or query for disparate sources such as HDFS, RDMS, NoSQL databases, object stores and WebHDFS. Exploit Hive, Or to exploit Hbase and Spark and whether on the cloud, on premises or both, access data across Hadoop and relational data bases.
1063:
Built-in machine learning and geospatial capabilities: Db2 Warehouse on Cloud comes with in-database machine learning capabilities that allow users to train and run machine learning models on Db2 Warehouse data without the need for data movement. Examples of algorithms include
975:
Elasticity: Db2 on Cloud offers independent scaling of storage and compute through the user interface and API, so businesses can burst on compute during peak demand and scale down when demand falls. Storage is also scalable, so organizations can scale up as their storage needs
1305:
On June 27, 2019, IBM announced a special free version of Db2 Database called Db2 Community edition. The Db2 Community edition was created for the 11.5 release of IBM Db2. The Db2 Community Edition replaced the previously free version of IBM Db2 known as DB2 Express-C.
1091:
Data security: Data is encrypted at-rest and in-motion by default. Administrators can also restrict access to sensitive data through data masking, row permissions, and role-based security, and can utilize database audit utilities to maintain audit trails for their data
901:"Data warehousing" was first mentioned in a 1988 IBM Systems Journal article entitled, "An Architecture for Business Information Systems." This article illustrated the first use-case for data warehousing in a business setting as well as the results of its application. 552:
Unlike other database vendors, IBM previously produced a platform-specific Db2 product for each of its major operating systems. In the 1990s IBM began producing a more unified Db2 with a mostly common code base for Linux, Unix and Windows. DB2 for System z and DB2 for
854:
The Db2 database software includes advanced features such as in-memory technology (IBM BLU Acceleration), advanced management and development tools, storage optimization, workload management, actionable compression and continuous data availability (IBM pureScale).
987:
High availability options: Db2 on Cloud provides a 99.99% uptime service level agreement on the high availability option. Highly available option allows for updates and scaling operations without downtime to applications running on Db2 on Cloud, using Db2's HADR
818:
implementation of DB2 data sharing on the mainframe. DB2 pureScale provides a fault-tolerant architecture and shared-disk storage. A DB2 pureScale system can grow to 128 database servers, and provides continuous availability and automatic load balancing.
1013:
Server control: Db2 Hosted provides custom software for direct server installation. This reduces application latency and integrates with a business's current data management setup. Db2 Hosted offers exact server configuration based on the needs of the
830:
management that moves data to cost effective storage based on how "hot" or "cold" (how frequently the data is accessed) the data is. IBM also introduced "adaptive compression" capability in DB2 10.1, a new approach to compressing data tables.
874:
In 2001, GA of V7. It added, e.g., dynamic allocation of data sets (~files on z/OS), and the ability to let utilities run on lists of tablespaces. Furthermore real-time statistics, scrollable cursors, and initial Unicode support.
979:
Backups and Recovery: Db2 on Cloud provides several disaster recovery options: (1) Fourteen days' worth of back-ups, (2) point in time restore options, (3) 1-click failover to the DR node at an offsite data center of user's
1319:
total count of processor cores in a non-partitioned physical server, or virtual cores assigned to a virtual server. For non-production use, Db2 Standard Edition can be licensed based on the total count of authorized users.
2274: 905:
relationships among the data. Db2 Warehouse, with its capabilities to normalize data from multiple sources, performs sophisticated analytic and statistical modeling, provides businesses these features at speed and scale.
945:
engine, Db2 Warehouse queries data from multiple sources—Oracle, Microsoft SQL Server, Teradata, open source, Netezza and others. Users write a query once and data returns from multiple sources quickly and efficiently.
863:
In 1995, GA (general availability) of V4. It introduced "data sharing": several DB2 engines access the same data. Advantages: performance and availability (if one DB2 engine fails or is migrated to the next version).
1084:. Db2 Warehouse on Cloud also supports spatial analytics with Esri compatibility, supporting Esri data types such as GML, and supports native Python drivers and native Db2 Python integration into Jupyter Notebooks. 1288:
features. It provides all core capabilities of Db2 but is limited to 4 virtual processor cores, 16 GB of instance memory, has no enterprise-level support, and no fix packs. There is no limit on the database size.
2612: 1659: 1594:
Later versions of Db2 added functionality and complexity to the execution of SQL. Multiple errors or warnings could be returned by the execution of an SQL statement; it may, for example, have initiated a
2582: 2090:
In 1983, DB2 for MVS Version 1 was born. "DB2" was used to indicate a shift from hierarchical databases, like the Information Management System (IMS) popular at the time, to the new relational databases.
1328:
perpetual license and subscription offerings, FlexPoints need to be bought. FlexPoints are generic licensing credits that can be used to deploy any Db2-family software product or cloud service offering.
1773: 803:
syntax, scripting syntax, and data types from Oracle Database. DB2 9.7 also enhanced its concurrency model to exhibit behavior that is familiar to users of Oracle Database and Microsoft SQL Server.
2449: 1134:
engine delivering massively parallel processing (MPP) and advanced data query. Additional benefits include low latency, high performance, security, SQL compatibility and federation capabilities.
1858: 884:
In 2010, GA of V10. It added, e.g., Temporal Tables (e.g., row history), security features like separation of system and security administrators, and RCAC (row column access control).
842:
On June 27, 2019, IBM released Db2 11.5, the AI Database. It added AI functionality to improve query performance as well as capabilities to facilitate AI application development.
2133: 2214:"IBM Db2 13 for z/OS delivers leading-edge AI innovations and enhancements, reinforcing it as the foundation for enterprise computing within the hybrid cloud and digital world" 2221: 2192: 1732: 1261:
Db2 11.5 for Linux, UNIX and Windows, contains all of the functionality and tools offered in the prior generation of DB2 and InfoSphere Warehouse on Linux, UNIX and Windows.
2604: 2501: 1651: 4677: 722:
In the mid-1990s, IBM released a clustered DB2 implementation called DB2 Parallel Edition, which initially ran on AIX. This edition allowed scalability by providing a
544:
until 2017, when it changed to its present form. (In the early days, it was sometimes wrongly styled as DB/2 - in a false derivation from the operating system OS/2 .)
1056:
that features four key optimizations: (1) a columnar organized storage model, (2) in-memory processing, (3) querying of compressed data sets, and (4) data skipping.
2026: 991:
Data federation: A single query displays a view of all data by accessing data distributed across Db2 on-premises and/or Db2 Warehouse on-premises or in the cloud.
35: 2578: 3345: 1764: 1049: 2162: 1425:. DB2 has a native implementation of XML data storage, where XML data is stored as XML (not as relational data or CLOB data) for faster access using XQuery. 1967: 1599:
and other SQL statements. Instead of the original SQLCA, error information should now be retrieved by successive executions of a GET DIAGNOSTICS statement.
890:
In 2016, GA of V12. It added, e.g., RESTful services; and usage of AI to optimize the selection of the access path to the data, thus enhancing performance.
2723: 1611: 1255: 1130:
In 2018, the IBM SQL product was renamed and is now known as IBM Db2 Big SQL (Big SQL). Big SQL is an enterprise-grade, hybrid ANSI-compliant SQL on the
4682: 1854: 1231:
Db2 for z/OS is available in its traditional product packaging, or in the Value Unit Edition, which allows customers to instead pay a one-time charge.
2427:
Db2 for z/OS is a relational database that you can use to maintain large volumes of data with a high level of availability, security, and performance.
2415: 780:-related improvements for z/OS, more self-tuning and self-managing features, additional 64-bit exploitation (especially for virtual storage on z/OS), 1098:: Db2 Warehouse on Cloud is optimized for polyglot persistence of data, and supports relational (columnar and row-oriented tables), geospatial, and 4687: 3756: 3169: 2706: 2439: 2103: 4667: 1180:
to indicate comparable functionality to DB2 on other platforms. Despite this name, it is not based on Db2 code, but instead it evolved from the
2718: 2048: 1621: 698:
IBM extended the functionality of Database Manager a number of times, including the addition of distributed database functionality by means of
4535: 1088:
storage capacity as their data volumes grow. Customers can scale their data warehouse through the Db2 Warehouse on Cloud web console or API.
878:
In 2004, GA of V8. It added, e.g., 64-bit support. New index types (notably DPSI), recursive SQL. Internal catalog is converted to Unicode.
4692: 3560: 568:, a researcher working for IBM, described the theory of relational databases, and in June 1970, published the model for data manipulation. 1616: 50: 3781: 2125: 1569:
statement was executed. The primary, but not singularly useful, error diagnostic is held in the field SQLCODE within the SQLCA block.
3913: 3891: 3360: 749:, and in the following years incorporated Informix technology into the DB2 product suite. DB2 can technically be considered to be an 2384: 2213: 2077: 2462:
IBM z/VSE V6.2 is capable as of December 1, 2017, when used in .... Db2 Server for VSE and VM and Db2 Server for VSE Client Edition
2184: 1911: 707: 2531: 1740: 3555: 691:. An earlier version of the code that would become DB2 LUW (Linux, Unix, Windows) was part of an Extended Edition component of 4027: 2493: 1285: 784:
performance enhancements for z/OS, and continued convergence of the SQL vocabularies between z/OS and distributed platforms.
471: 290: 745:
and IBM followed suit by changing their database engines to be capable of object–relational extensions. In 2001, IBM bought
3162: 3116: 3771: 3189: 2789: 2678: 909:
snowflake schemas, Db2 Warehouse now includes support for the following data types and analytical models, among others:
4634: 4524: 2364: 2022: 1495: 1238:
Warehouse, which offers data warehouse capabilities. InfoSphere Warehouse is available for z/OS. It includes several
1048:
Optimized for analytics: Db2 Warehouse on Cloud delivers high performance on complex analytics workloads by utilizing
4258: 4172: 3833: 3482: 3296: 2553: 72: 1808: 4662: 4104: 466: 285: 2154: 4614: 4604: 4594: 4131: 3155: 3136: 2842: 2243: 54: 4609: 4304: 4294: 4192: 3375: 3266: 3093: 2740: 1993:
SIGFIDET '71 Proceedings of the 1971 ACM SIGFIDET (Now SIGMOD) Workshop on Data Description, Access and Control
1936: 1838: 1713: 1626: 1464: 750: 738: 606:
to utilize their GUI interface and encapsulating SQL platform that had already been in use since the mid-80s.
4497: 4263: 3525: 3286: 3032: 1472: 1457: 1020:
Elasticity: Db2 Hosted allows for independent scaling of compute and storage to meet changing business needs.
811: 630: 579:, to implement Codd's concepts. A key development of the System R project was the Structured Query Language ( 994:
Private networking: Db2 on Cloud can be deployed on an isolated network that is accessible through a secure
4624: 4619: 4228: 2405: 1251: 584: 3027: 4121: 4013: 3420: 3058: 2777: 1484: 1468: 723: 394: 190: 141: 1269:
IBM offers three editions: Db2 Community Edition, Standard Server Edition, and Advanced Server Edition.
4492: 4476: 4018: 3973: 3901: 2981: 2971: 2747: 2332: 680: 483: 309: 2303: 3606: 3068: 2801: 1522: 1356:
IBM has developed many Db2 versions under a code name, and documentation can be related to that name
1065: 764:
was announced in early 2007. IBM claimed that the new DB2 was the first relational database to store
603: 238: 4629: 4410: 4218: 4073: 3400: 1453: 1243: 1235: 881:
In 2007, GA of V9. It added, e.g., Trusted Context (a security feature), and "native XML" support.
839:
In mid-2017, IBM re-branded its DB2 and dashDB product offerings and amended their names to "Db2".
417: 178: 807: 335: 151: 4471: 4177: 4051: 3017: 2671: 1631: 1492: 995: 957:
is a fully managed, cloud SQL database with a high-availability option featuring a 99.99 percent
638: 961:. Db2 on Cloud offers independent scaling of storage and compute, and rolling security updates. 4502: 4273: 4089: 3791: 3098: 3053: 2730: 1208: 1081: 1561:) structure was once used exclusively within a Db2 program to return error information to the 4672: 4518: 4483: 4109: 4068: 3699: 3425: 3178: 3073: 2827: 788: 773: 757: 634: 625: 529: 4338: 4248: 4202: 4197: 4003: 3801: 3746: 3729: 3572: 3126: 3063: 2945: 2915: 2784: 2735: 1506: 1239: 1095: 1069: 1033:
is a fully managed, elastic, cloud data warehouse built for high-performance analytics and
815: 730: 629:
DB2. The inspiration for the mainframe version of DB2's architecture came in part from IBM
302: 86: 2111: 1117:
Deployable on multiple cloud providers: Db2 Warehouse on Cloud is currently deployable on
792: 683:. This process occurred through the 1990s. An implementation of DB2 is also available for 8: 4512: 4374: 4309: 4114: 4057: 4023: 3083: 2976: 2961: 2888: 2713: 2651: 2380: 2073: 1562: 1488: 1224: 1118: 1077: 965: 305: 4487: 4462: 4362: 4344: 4008: 3078: 3022: 2991: 2940: 2832: 2772: 2664: 2645: 2523: 2475: 2266: 2004: 1959: 1903: 1880: 1768: 1155: 1073: 806:
In October 2009, IBM introduced its second major release of the year when it announced
742: 703: 444: 221: 1681: 1579:
A positive number means successful execution with one or more warnings. An example is
583:). To apply the relational model, Codd needed a relational-database language he named 4599: 4546: 4440: 4435: 4299: 4223: 3818: 3786: 3694: 3626: 3611: 3518: 3460: 3365: 2898: 2752: 2360: 1907: 1834: 1709: 1554: 1006:
is an unmanaged, hosted version of Db2 on Cloud's transactional, SQL cloud database.
746: 668: 425: 278: 186: 2008: 1674: 644:
The name DB2 (IBM Database 2), was first given to the Database Management System or
557:, however, remained independent implementations and as a result, they use different 4657: 4529: 4332: 4324: 4253: 4155: 4083: 3684: 3641: 3636: 3395: 3350: 3088: 2935: 2925: 2893: 2270: 2258: 1996: 1963: 1951: 1895: 1855:"DB2 database -> does it continue to be platform-specific? (iSeries, LUW, z/OS)" 1596: 1526: 1280:
is a free-to-download, free-to-use edition of the IBM Db2 database, which has both
1034: 1030: 795:, Simplified Management, Business Critical Reliability, and Agile XML development. 781: 777: 610: 525: 478: 459: 432: 297: 274: 262: 258: 197: 4507: 4420: 4243: 4182: 3828: 3751: 3621: 3324: 3210: 2996: 2966: 2920: 2701: 2354: 1991:
Codd, E.F. (1971). "A data base sublanguage founded on the relational calculus".
1703: 1534: 1167: 836:
On 12 April 2016, IBM announced DB2 LUW 11.1, and in June 2016, it was released.
596: 558: 517: 513: 270: 266: 42: 810:. DB2 pureScale is a cluster database for non-mainframe platforms, suitable for 4556: 4430: 4425: 4386: 4314: 4268: 4187: 3896: 3776: 3550: 3542: 3271: 3048: 2986: 2930: 2903: 2796: 2757: 1590:, which means a lock timeout (or deadlock) has occurred, triggering a rollback. 1514: 1487:, and many other programming languages. Db2 also supports integration into the 1461: 676: 449: 46: 2656: 717: 4651: 4405: 4380: 4350: 4136: 3857: 3796: 3704: 3679: 3594: 3276: 2867: 2852: 1510: 1181: 656: 565: 2000: 4574: 4368: 4356: 3961: 3956: 3935: 3511: 3477: 3435: 3281: 1281: 1053: 576: 1955: 1899: 787:
In October 2007, IBM announced "Viper 2", the codename for DB2 9.5 on the
702:(DRDA) that allowed shared access to a database in a remote location on a 655:
For some years DB2, as a full-function DBMS, was exclusively available on
4584: 4445: 4415: 4238: 4126: 3850: 3845: 3616: 3147: 2857: 2837: 1798: 1310:"Cobra"), 10.01 (codename "Galileo"), 10.5 (codename "Kepler") and 11.1. 1247: 954: 867:
In 1997, GA of V5. It added, e.g., online reorganization of tablespaces.
2262: 4167: 4160: 4094: 3840: 3661: 3651: 3430: 3001: 2910: 2872: 2847: 1602:
See SQL return codes for a more comprehensive list of common SQLCODEs.
1003: 617: 360: 107: 494: 3925: 3918: 3734: 3656: 3646: 1218: 245: 206: 2185:"IBM aims to meld Db2 with machine learning, data science workflows" 1335:
Improves application performance and analytics for faster decisions.
4541: 4289: 4233: 3998: 3983: 3966: 3811: 3739: 3709: 3487: 3340: 2862: 2817: 2687: 1518: 756:
In mid-2006, IBM announced "Viper", the codename for DB2 9 on both
734: 572: 1586:
A negative number means unsuccessful with an error. An example is
1509:
focused on applications that access data. pureQuery supports both
4551: 3993: 3988: 3930: 3761: 3689: 3415: 3409: 3390: 3385: 3291: 1445: 1441: 621: 210: 3978: 3951: 3908: 3886: 3806: 3492: 3440: 3405: 3380: 2767: 1422: 1173: 1172:
In 1994, IBM renamed the integrated relational database of the
1131: 958: 814:(OLTP) workloads. IBM based the design of DB2 pureScale on the 800: 706:. (Note that DRDA is based on objects and protocols defined by 226: 1765:"The Executive Computer; Bringing Point-and-Click Ease to ..." 1338:
Delivers high availability and disaster recovery capabilities.
571:
In 1974, the IBM San Jose Research Center developed a related
564:
DB2 traces its roots back to the beginning of the 1970s, when
3599: 3370: 2762: 1449: 1437: 1197:
Db2 for Linux, UNIX and Windows (informally known as Db2 LUW)
1099: 823: 684: 672: 554: 421: 234: 202: 182: 2324: 851:
supported across Linux, Unix and Windows operating systems.
609:
In parallel with the development of SQL, IBM also developed
3823: 3766: 3355: 3222: 2822: 2639: 2295: 1476: 1433: 1429: 1212: 1201: 1114:) models. All data is subject to advanced data compression. 1111: 1107: 769: 761: 718:
Db2 for LUW (aka: Db2 on distributed platforms) - evolution
699: 692: 688: 664: 660: 645: 533: 437: 413: 352: 320: 214: 99: 833:
In June 2013, IBM released DB2 10.5 (code name "Kepler").
3534: 2557: 2444: 2410: 1803: 1566: 1530: 1502: 1480: 1347:
Improves productivity and reduces administration efforts.
1103: 765: 649: 588: 580: 537: 521: 365: 230: 112: 1881:"A Relational Model of Data for Large Shared Data Banks" 953:
Db2 on Cloud: Formerly named "dashDB for Transactions",
637:, and its dedicated database-manipulation language, IBM 2244:"An Architecture for a Business and Information System" 822:
In 2009, it was announced that DB2 can be an engine in
659:. Later, IBM brought DB2 to other platforms, including 3503: 2325:"Apache Spark - Unified Analytics Engine for Big Data" 2104:"Technical Tour of DB2 10 and InfoSphere Warehouse 10" 1045:
that are on-call to handle unexpected system failures.
1612:
Comparison of relational database management systems
1184:
integrated database. The product is currently named
616:
IBM's first commercial relational-database product,
53:, and by adding encyclopedic content written from a 1935:Chamberlin, Donald D.; et al. (October 1981). 1344:
Interfaces with a variety of data more efficiently.
1297:supported up to 16 GB RAM and two CPU cores. 887:In 2013, GA of V11. It added, e.g., JSON support. 4678:Relational database management software for Linux 2554:"Db2 database product editions and Db2 offerings" 2023:"SQL SERVER – What is SQL? How to pronounce SQL?" 772:-related improvements for distributed platforms, 4649: 3757:Criminal Reduction Utilising Statistical History 1786:relational data base management ... I.B.M.'s DB2 1557:is error handling. The SQL communications area ( 1146:strong data integration and flexible licensing. 1017:Encryption: Db2 Hosted supports SSL connections. 2686: 2494:"IBM Db2 on Cloud Comes to Amazon Web Services" 2352: 2101: 893:On May 31, 2022, IBM released Db2 13 for z/OS. 2155:"How IBM Is Turning Db2 into an 'AI Database'" 2049:"Relational Models Viable in Commercial World" 1752:Since the introduction of DB2 in 1983, IBM ... 1701: 1622:List of relational database management systems 3519: 3163: 2672: 1652:"IBM Database 2 (DB2) Release 1 Is Announced" 2346: 2241: 1733:"The Evolution of DB2 for z/OS Optimization" 1331:Db2 Advanced Edition offers these benefits: 1272: 1052:, a collection of technologies pioneered by 741:by introducing their Universal Server, both 700:Distributed Relational Database Architecture 532:features and non-relational structures like 2521: 1617:Comparison of database administration tools 1322: 1313: 1002:Db2 Hosted: Formally named "DB2 on Cloud", 858: 613:(QBE), the first graphical query language. 3526: 3512: 3177: 3170: 3156: 2679: 2665: 2644: 1934: 1705:A Complete Guide to DB2 Universal Database 948: 540:. The brand name was originally styled as 334: 150: 85:"DB2" redirects here. For other uses, see 4683:Client-server database management systems 3361:Hierarchical and recursive queries in SQL 1154:Db2 Event Store targets the needs of the 1024: 73:Learn how and when to remove this message 1828: 1415: 708:Distributed Data Management Architecture 4688:Proprietary database management systems 2534:from the original on September 14, 2017 1517:. pureQuery provides access to data in 1341:Provides a secure, flexible environment 1029:Formerly named "dashDB for Analytics", 768:"natively". Other enhancements include 4668:Relational database management systems 4650: 2585:from the original on February 21, 2022 2476:"IBM Db2 on Cloud Review & Rating" 2452:from the original on November 28, 2021 1937:"A History and Evaluation of System R" 34:contains content that is written like 3892:Center for The Business of Government 3507: 3151: 2660: 2473: 2467: 2242:Devlin, B. A.; Murphy, P. T. (1988). 1776:from the original on October 30, 2018 1286:relational database management system 648:in 1983 when IBM released DB2 on its 4580: 2615:from the original on 28 January 2021 2046: 1990: 1878: 18: 4693:IBM Information Management software 3132: 2047:Basu, Dipankar (October 25, 1982). 1548: 1496:integrated development environments 964:Db2 on Cloud is deployable on both 13: 2182: 1829:Kageyama, Yukihisa (Dec 1, 1989). 1720:DB2 for MVS (later OS/390) in 1983 1662:from the original on 13 April 2023 1293:the Developer Community editions. 1191: 1149: 737:and made their database engine an 14: 4704: 3561:PC business acquisition by Lenovo 3297:IBM Information Management System 2631: 2356:Inside the AS/400, Second Edition 1833:. McGraw-Hill Education (India). 1543:IBM Data Studio pureQuery Runtime 573:Database Management System (DBMS) 4590: 4589: 4579: 4570: 4569: 4259:Sabre airline reservation system 4105:Thomas J. Watson Research Center 3131: 3121: 3112: 3111: 2605:"Getting Started with pureQuery" 1572:The SQL return code values are: 1168:IBM i § Database management 1161: 896: 351: 98: 23: 16:Relational model database server 3772:Information Management Software 3216:Db2 for Linux, UNIX and Windows 3122: 2597: 2571: 2546: 2515: 2504:from the original on 2019-08-20 2486: 2432: 2418:from the original on 2019-05-03 2398: 2387:from the original on 2021-12-14 2373: 2335:from the original on 2020-09-02 2317: 2306:from the original on 2019-09-10 2288: 2277:from the original on 2023-08-13 2235: 2224:from the original on 2022-08-17 2206: 2195:from the original on 2019-10-01 2176: 2165:from the original on 2019-06-16 2147: 2136:from the original on 2019-08-20 2118: 2095: 2080:from the original on 2012-01-13 2066: 2040: 2029:from the original on 2016-06-29 2015: 1984: 1973:from the original on 2013-10-01 1928: 1917:from the original on 2019-08-09 1861:from the original on 2018-08-25 1811:from the original on 2018-08-25 968:and Amazon Web Services (AWS). 937:In-memory analytical processing 931:Embedded Spark Analytics engine 845: 4525:International chess tournament 4305:Globally integrated enterprise 4295:Commercial Processing Workload 2102:IBM Corporation (2012-04-25). 1872: 1847: 1822: 1791: 1757: 1725: 1695: 1644: 1627:List of column-oriented DBMSes 1121:and Amazon Web Services (AWS). 940:Predictive Modeling algorithms 528:, but was extended to support 1: 4264:Scanning tunneling microscope 3287:IBM Query Management Facility 3232: 2652:Db2 - IBM Data for developers 1637: 1576:0 means successful execution. 1351: 1125: 996:Virtual Private Network (VPN) 812:online transaction processing 524:. It initially supported the 2474:Baker, Pam (July 23, 2018). 1583:, which means no rows found. 1553:An important feature of Db2 1537:environment as delivered in 1300: 7: 4132:Canada Head Office Building 4122:Cambridge Scientific Center 4014:Science Research Associates 3782:Mainframe operating systems 3474:Other IBM database products 3421:Transparent data encryption 2688:Database management systems 1605: 1264: 724:shared-nothing architecture 377:; 41 years ago 124:; 41 years ago 10: 4709: 4193:Virtual Universe Community 3914:International subsidiaries 3834:Service Automation Manager 3376:Object–relational database 3094:Object–relational database 2126:"IBM Db2 Joins the AI Age" 1165: 793:key themes for the release 547: 84: 4565: 4454: 4396: 4323: 4282: 4211: 4145: 4041: 3944: 3879: 3870: 3722: 3672: 3587: 3580: 3571: 3541: 3470: 3449: 3333: 3321:InfoSphere Data Architect 3315:Data Studio Administrator 3305: 3253: 3231: 3203: 3185: 3107: 3069:Federated database system 3041: 3010: 2954: 2881: 2810: 2802:Blockchain-based database 2694: 2074:"Introduction to DB2 UDB" 1944:Communications of the ACM 1888:Communications of the ACM 1879:Codd, E. F. (June 1970). 1539:IBM Data Studio Developer 1278:IBM Db2 Community Edition 1273:IBM Db2 Community Edition 934:Multi-Parallel Processing 695:called Database Manager. 604:Metaphor Computer Systems 489: 477: 465: 455: 443: 431: 409: 405: 393: 389: 371: 359: 350: 315: 296: 284: 254: 244: 239:IBM Power microprocessors 220: 213:. Historical support for 196: 174: 170: 147: 140: 136: 118: 106: 97: 4219:Automated teller machine 4173:The Great Mind Challenge 3556:Mergers and acquisitions 3401:Spatial reference system 2611:. IBM. 20 October 2009. 2353:Frank G. Soltis (1997). 1656:IBM Offering Information 1323:IBM Db2 Advanced Edition 1314:IBM Db2 Standard Edition 859:Db2 for z/OS - evolution 4663:Cross-platform software 4178:Linux Technology Center 3533: 2001:10.1145/1734714.1734718 1702:Don Chamberlin (1998). 1632:Data Language Interface 984:database administrator. 949:Db2 on Cloud/Db2 Hosted 620:, was released for the 157:; 10 months ago 4503:Dynamic infrastructure 4468:Big Blue sports teams 4274:Universal Product Code 3190:Information Management 3179:IBM Db2 product family 3099:Transaction processing 3054:Database normalization 2997:Query rewriting system 1040:Key features include: 1031:Db2 Warehouse on Cloud 1025:Db2 Warehouse on Cloud 971:Key features include: 4635:Vacuum tube computers 4519:IBM and the Holocaust 4484:Common Public License 4369:Louis V. Gerstner Jr. 4152:Academy of Technology 3607:Power microprocessors 3426:User-defined function 3318:Data Studio Developer 3074:Referential integrity 2579:"Db2 Download Centre" 1956:10.1145/358769.358784 1900:10.1145/362384.362685 1416:Technical information 1060:concurrent workloads. 789:distributed platforms 774:business intelligence 758:distributed platforms 635:hierarchical database 55:neutral point of view 4249:Magnetic stripe card 4198:World Community Grid 4074:Toronto Software Lab 3730:Carbon Design System 3685:Cell microprocessors 3272:InfoSphere Warehouse 3064:Distributed database 2448:. October 10, 2017. 1772:. January 22, 1995. 1737:IBM Systems magazine 1096:Polyglot persistence 1050:IBM BLU Acceleration 760:and z/OS. DB2 9 for 731:Informix Corporation 652:mainframe platform. 516:products, including 87:DB2 (disambiguation) 4513:GUIDE International 4375:Samuel J. Palmisano 4234:Electronic keypunch 4058:One Atlantic Center 4028:Weather Underground 4024:The Weather Company 3084:Relational calculus 2962:Concurrency control 2263:10.1147/sj.271.0060 2251:IBM Systems Journal 1708:. Morgan Kaufmann. 1682:"Db2 Documentation" 1563:application program 1521:and in-memory Java 1225:Amazon Web Services 916:Non-Relational data 791:. There were three 347: 306:commercial software 94: 47:promotional content 4615:Personal computers 4605:Midrange computers 4595:Navigational boxes 4488:IBM Public License 4463:A Boy and His Atom 4421:Michelle J. Howard 4363:John Fellows Akers 4345:T. Vincent Learson 4052:1250 RenĂ©-LĂ©vesque 3792:Planning Analytics 3079:Relational algebra 3023:Query optimization 2828:Armstrong's axioms 2560:. January 12, 2024 2524:"IBM Db2 for z/OS" 2025:. 14 August 2007. 1769:The New York Times 1368:Stinger - 8.1, 8.2 1254:acceleration, and 1156:Internet of things 743:Oracle Corporation 671:servers, and then 599:aircraft company. 345: 155:/ 15 November 2023 92: 49:and inappropriate 4645: 4644: 4610:Operating systems 4472:American football 4441:Joseph R. Swedish 4436:Martha E. Pollack 4339:Thomas Watson Jr. 4300:Customer engineer 4224:Cynefin framework 4110:Hakozaki Facility 4069:Rome Software Lab 4037: 4036: 3866: 3865: 3819:Rational Software 3718: 3717: 3700:Personal Computer 3695:Midrange computer 3501: 3500: 3461:IBM Data Magazine 3366:Materialized view 3246:Enterprise Server 3240:Express/Express-C 3145: 3144: 2753:Wide-column store 2748:Document-oriented 2522:IBM Corporation. 1555:computer programs 1428:Db2 has APIs for 1256:in-line analytics 1242:features such as 1066:Association Rules 747:Informix Software 530:object–relational 507: 506: 343: 342: 142:Stable release(s) 83: 82: 75: 4700: 4593: 4592: 4583: 4582: 4573: 4572: 4333:Thomas J. Watson 4254:Relational model 4203:Think conference 4084:330 North Wabash 4004:Microelectronics 3877: 3876: 3802:Quantum Platform 3747:Cognos Analytics 3585: 3584: 3578: 3577: 3528: 3521: 3514: 3505: 3504: 3396:Spatial database 3346:Blu Acceleration 3254:Related products 3243:Workgroup Server 3172: 3165: 3158: 3149: 3148: 3135: 3134: 3125: 3124: 3115: 3114: 3089:Relational model 3059:Database storage 2936:Stored procedure 2681: 2674: 2667: 2658: 2657: 2648: 2643: 2642: 2640:Official website 2625: 2624: 2622: 2620: 2601: 2595: 2594: 2592: 2590: 2575: 2569: 2568: 2566: 2565: 2550: 2544: 2543: 2541: 2539: 2519: 2513: 2512: 2510: 2509: 2490: 2484: 2483: 2471: 2465: 2464: 2459: 2457: 2440:"IBM z/VSE V6.2" 2436: 2430: 2429: 2424: 2423: 2402: 2396: 2395: 2393: 2392: 2377: 2371: 2370: 2350: 2344: 2343: 2341: 2340: 2329:spark.apache.org 2321: 2315: 2314: 2312: 2311: 2292: 2286: 2285: 2283: 2282: 2248: 2239: 2233: 2232: 2230: 2229: 2210: 2204: 2203: 2201: 2200: 2180: 2174: 2173: 2171: 2170: 2151: 2145: 2144: 2142: 2141: 2122: 2116: 2115: 2110:. Archived from 2099: 2093: 2092: 2086: 2085: 2076:. Apr 22, 2005. 2070: 2064: 2063: 2061: 2059: 2044: 2038: 2037: 2035: 2034: 2019: 2013: 2012: 1988: 1982: 1981: 1979: 1978: 1972: 1941: 1932: 1926: 1925: 1923: 1922: 1916: 1885: 1876: 1870: 1869: 1867: 1866: 1851: 1845: 1844: 1826: 1820: 1819: 1817: 1816: 1795: 1789: 1788: 1783: 1781: 1761: 1755: 1754: 1749: 1748: 1739:. Archived from 1729: 1723: 1722: 1699: 1693: 1692: 1690: 1688: 1678: 1672: 1671: 1669: 1667: 1648: 1597:database trigger 1589: 1582: 1549:Error processing 1234:Db2 also powers 1035:machine learning 816:Parallel Sysplex 782:stored procedure 778:data warehousing 611:Query by Example 526:relational model 518:database servers 503: 500: 498: 496: 484:Proprietary EULA 433:Operating system 385: 383: 378: 355: 348: 346:IBM Db2 for z/OS 344: 339: 338: 331: 328: 326: 324: 322: 310:Proprietary EULA 198:Operating system 165: 163: 162:15 November 2023 158: 154: 132: 130: 125: 102: 95: 91: 78: 71: 67: 64: 58: 36:an advertisement 27: 26: 19: 4708: 4707: 4703: 4702: 4701: 4699: 4698: 4697: 4648: 4647: 4646: 4641: 4561: 4547:SHARE computing 4508:GlobalFoundries 4450: 4398: 4392: 4319: 4278: 4269:Financial swaps 4244:Hard disk drive 4207: 4141: 4115:Yamato Facility 4033: 3940: 3872: 3862: 3829:Tivoli Software 3714: 3668: 3567: 3537: 3532: 3502: 3497: 3466: 3445: 3329: 3325:Toad (software) 3301: 3249: 3227: 3199: 3181: 3176: 3146: 3141: 3103: 3049:Database models 3037: 3006: 2992:Query optimizer 2967:Data dictionary 2950: 2921:Transaction log 2877: 2833:Codd's 12 rules 2806: 2736:Column-oriented 2702:Object-oriented 2690: 2685: 2638: 2637: 2634: 2629: 2628: 2618: 2616: 2603: 2602: 2598: 2588: 2586: 2577: 2576: 2572: 2563: 2561: 2552: 2551: 2547: 2537: 2535: 2520: 2516: 2507: 2505: 2492: 2491: 2487: 2472: 2468: 2455: 2453: 2438: 2437: 2433: 2421: 2419: 2404: 2403: 2399: 2390: 2388: 2379: 2378: 2374: 2367: 2351: 2347: 2338: 2336: 2323: 2322: 2318: 2309: 2307: 2294: 2293: 2289: 2280: 2278: 2246: 2240: 2236: 2227: 2225: 2212: 2211: 2207: 2198: 2196: 2183:Dignan, Larry. 2181: 2177: 2168: 2166: 2153: 2152: 2148: 2139: 2137: 2132:. 4 June 2019. 2130:InformationWeek 2124: 2123: 2119: 2100: 2096: 2083: 2081: 2072: 2071: 2067: 2057: 2055: 2045: 2041: 2032: 2030: 2021: 2020: 2016: 1989: 1985: 1976: 1974: 1970: 1950:(10): 632–646. 1939: 1933: 1929: 1920: 1918: 1914: 1883: 1877: 1873: 1864: 1862: 1853: 1852: 1848: 1841: 1827: 1823: 1814: 1812: 1797: 1796: 1792: 1779: 1777: 1763: 1762: 1758: 1746: 1744: 1731: 1730: 1726: 1716: 1700: 1696: 1686: 1684: 1680: 1679: 1675: 1665: 1663: 1658:. 7 June 1983. 1650: 1649: 1645: 1640: 1608: 1587: 1580: 1551: 1505:'s data access 1418: 1392:Andromeda - 12? 1389:Nebula - 11.5.4 1386:Cancun - 10.5.4 1354: 1325: 1316: 1303: 1275: 1267: 1194: 1192:Other Platforms 1170: 1164: 1152: 1150:Db2 Event Store 1128: 1027: 951: 922:Geospatial data 913:Relational data 899: 861: 848: 751:object–SQL DBMS 739:object-SQL DBMS 720: 597:Hawker Siddeley 550: 520:, developed by 514:data management 512:is a family of 493: 401: 381: 379: 376: 372:Initial release 333: 319: 166: 161: 159: 156: 128: 126: 123: 119:Initial release 90: 79: 68: 62: 59: 40: 28: 24: 17: 12: 11: 5: 4706: 4696: 4695: 4690: 4685: 4680: 4675: 4670: 4665: 4660: 4643: 4642: 4640: 4639: 4638: 4637: 4632: 4627: 4622: 4617: 4612: 4607: 4602: 4587: 4577: 4566: 4563: 4562: 4560: 4559: 4554: 4549: 4544: 4539: 4532: 4530:Lucifer cipher 4527: 4522: 4515: 4510: 4505: 4500: 4495: 4490: 4481: 4480: 4479: 4474: 4466: 4458: 4456: 4452: 4451: 4449: 4448: 4446:Peter R. Voser 4443: 4438: 4433: 4431:Andrew Liveris 4428: 4426:Arvind Krishna 4423: 4418: 4413: 4408: 4402: 4400: 4394: 4393: 4391: 4390: 4387:Arvind Krishna 4384: 4378: 4372: 4366: 4360: 4354: 4348: 4342: 4336: 4329: 4327: 4321: 4320: 4318: 4317: 4312: 4307: 4302: 4297: 4292: 4286: 4284: 4280: 4279: 4277: 4276: 4271: 4266: 4261: 4256: 4251: 4246: 4241: 4236: 4231: 4226: 4221: 4215: 4213: 4209: 4208: 4206: 4205: 4200: 4195: 4190: 4188:Smarter Planet 4185: 4180: 4175: 4170: 4165: 4164: 4163: 4153: 4149: 4147: 4143: 4142: 4140: 4139: 4134: 4129: 4124: 4119: 4118: 4117: 4112: 4107: 4099: 4098: 4097: 4092: 4087: 4080:IBM Buildings 4078: 4077: 4076: 4071: 4065:Software Labs 4063: 4062: 4061: 4055: 4054:, Montreal, QC 4045: 4043: 4039: 4038: 4035: 4034: 4032: 4031: 4021: 4019:Service Bureau 4016: 4011: 4009:Product Center 4006: 4001: 3996: 3991: 3986: 3981: 3976: 3974:Ambra Computer 3971: 3970: 3969: 3964: 3954: 3948: 3946: 3942: 3941: 3939: 3938: 3933: 3928: 3923: 3922: 3921: 3911: 3906: 3905: 3904: 3894: 3889: 3883: 3881: 3874: 3868: 3867: 3864: 3863: 3861: 3860: 3855: 3854: 3853: 3843: 3838: 3837: 3836: 3826: 3821: 3816: 3815: 3814: 3809: 3799: 3794: 3789: 3784: 3779: 3777:Lotus Software 3774: 3769: 3764: 3759: 3754: 3749: 3744: 3743: 3742: 3732: 3726: 3724: 3720: 3719: 3716: 3715: 3713: 3712: 3707: 3702: 3697: 3692: 3687: 3682: 3676: 3674: 3670: 3669: 3667: 3666: 3665: 3664: 3659: 3654: 3649: 3644: 3639: 3631: 3630: 3629: 3624: 3614: 3609: 3604: 3603: 3602: 3591: 3589: 3582: 3575: 3569: 3568: 3566: 3565: 3564: 3563: 3553: 3547: 3545: 3539: 3538: 3531: 3530: 3523: 3516: 3508: 3499: 3498: 3496: 3495: 3490: 3485: 3480: 3475: 3471: 3468: 3467: 3465: 3464: 3457: 3453: 3451: 3447: 3446: 3444: 3443: 3438: 3433: 3428: 3423: 3418: 3413: 3403: 3398: 3393: 3388: 3383: 3378: 3373: 3368: 3363: 3358: 3353: 3348: 3343: 3337: 3335: 3331: 3330: 3328: 3327: 3322: 3319: 3316: 3313: 3309: 3307: 3303: 3302: 3300: 3299: 3294: 3289: 3284: 3279: 3274: 3269: 3267:DB2 Everyplace 3264: 3261: 3257: 3255: 3251: 3250: 3248: 3247: 3244: 3241: 3237: 3235: 3229: 3228: 3226: 3225: 3219: 3213: 3207: 3205: 3201: 3200: 3198: 3197: 3192: 3186: 3183: 3182: 3175: 3174: 3167: 3160: 3152: 3143: 3142: 3140: 3139: 3129: 3119: 3108: 3105: 3104: 3102: 3101: 3096: 3091: 3086: 3081: 3076: 3071: 3066: 3061: 3056: 3051: 3045: 3043: 3042:Related topics 3039: 3038: 3036: 3035: 3030: 3025: 3020: 3018:Administration 3014: 3012: 3008: 3007: 3005: 3004: 2999: 2994: 2989: 2987:Query language 2984: 2979: 2974: 2969: 2964: 2958: 2956: 2952: 2951: 2949: 2948: 2943: 2938: 2933: 2928: 2923: 2918: 2913: 2908: 2907: 2906: 2901: 2896: 2885: 2883: 2879: 2878: 2876: 2875: 2870: 2865: 2860: 2855: 2850: 2845: 2840: 2835: 2830: 2825: 2820: 2814: 2812: 2808: 2807: 2805: 2804: 2799: 2794: 2793: 2792: 2782: 2781: 2780: 2770: 2765: 2760: 2755: 2750: 2745: 2744: 2743: 2733: 2728: 2727: 2726: 2721: 2711: 2710: 2709: 2698: 2696: 2692: 2691: 2684: 2683: 2676: 2669: 2661: 2655: 2654: 2649: 2633: 2632:External links 2630: 2627: 2626: 2596: 2570: 2545: 2514: 2485: 2466: 2431: 2406:"Db2 for z/OS" 2397: 2372: 2366:978-1882419661 2365: 2359:. Duke Press. 2345: 2316: 2287: 2234: 2220:. 2022-04-05. 2205: 2175: 2161:. 2019-06-04. 2146: 2117: 2114:on 2012-04-25. 2094: 2065: 2039: 2014: 1983: 1927: 1894:(6): 377–387. 1871: 1846: 1839: 1821: 1799:"Db2 on Cloud" 1790: 1756: 1724: 1714: 1694: 1673: 1642: 1641: 1639: 1636: 1635: 1634: 1629: 1624: 1619: 1614: 1607: 1604: 1592: 1591: 1584: 1577: 1550: 1547: 1417: 1414: 1413: 1412: 1409: 1406: 1405:Sequoia - 11.1 1403: 1394: 1393: 1390: 1387: 1384: 1381: 1380:Galileo - 10.1 1378: 1375: 1372: 1369: 1366: 1353: 1350: 1349: 1348: 1345: 1342: 1339: 1336: 1324: 1321: 1315: 1312: 1302: 1299: 1274: 1271: 1266: 1263: 1236:IBM InfoSphere 1229: 1228: 1221: 1215: 1205: 1198: 1193: 1190: 1166:Main article: 1163: 1160: 1151: 1148: 1127: 1124: 1123: 1122: 1115: 1093: 1089: 1085: 1061: 1057: 1046: 1026: 1023: 1022: 1021: 1018: 1015: 1009:Key features: 1000: 999: 992: 989: 985: 981: 977: 950: 947: 942: 941: 938: 935: 932: 929: 926: 923: 920: 917: 914: 898: 895: 860: 857: 847: 844: 719: 716: 677:Linux on IBM Z 657:IBM mainframes 549: 546: 505: 504: 491: 487: 486: 481: 475: 474: 469: 463: 462: 457: 453: 452: 450:z/Architecture 447: 441: 440: 435: 429: 428: 411: 407: 406: 403: 402: 399: 397: 395:Stable release 391: 390: 387: 386: 373: 369: 368: 363: 357: 356: 341: 340: 317: 313: 312: 300: 294: 293: 288: 282: 281: 256: 252: 251: 248: 242: 241: 224: 218: 217: 200: 194: 193: 176: 172: 171: 168: 167: 148: 145: 144: 138: 137: 134: 133: 120: 116: 115: 110: 104: 103: 81: 80: 51:external links 31: 29: 22: 15: 9: 6: 4: 3: 2: 4705: 4694: 4691: 4689: 4686: 4684: 4681: 4679: 4676: 4674: 4671: 4669: 4666: 4664: 4661: 4659: 4656: 4655: 4653: 4636: 4633: 4631: 4628: 4626: 4623: 4621: 4618: 4616: 4613: 4611: 4608: 4606: 4603: 4601: 4598: 4597: 4596: 4588: 4586: 4578: 4576: 4568: 4567: 4564: 4558: 4555: 4553: 4550: 4548: 4545: 4543: 4540: 4538: 4537: 4533: 4531: 4528: 4526: 4523: 4521: 4520: 4516: 4514: 4511: 4509: 4506: 4504: 4501: 4499: 4496: 4494: 4491: 4489: 4485: 4482: 4478: 4475: 4473: 4470: 4469: 4467: 4465: 4464: 4460: 4459: 4457: 4453: 4447: 4444: 4442: 4439: 4437: 4434: 4432: 4429: 4427: 4424: 4422: 4419: 4417: 4414: 4412: 4409: 4407: 4406:Thomas Buberl 4404: 4403: 4401: 4395: 4388: 4385: 4382: 4381:Ginni Rometty 4379: 4376: 4373: 4370: 4367: 4364: 4361: 4358: 4355: 4352: 4351:Frank T. Cary 4349: 4346: 4343: 4340: 4337: 4334: 4331: 4330: 4328: 4326: 4322: 4316: 4313: 4311: 4308: 4306: 4303: 4301: 4298: 4296: 4293: 4291: 4288: 4287: 4285: 4281: 4275: 4272: 4270: 4267: 4265: 4262: 4260: 4257: 4255: 4252: 4250: 4247: 4245: 4242: 4240: 4237: 4235: 4232: 4230: 4227: 4225: 4222: 4220: 4217: 4216: 4214: 4210: 4204: 4201: 4199: 4196: 4194: 4191: 4189: 4186: 4184: 4181: 4179: 4176: 4174: 4171: 4169: 4166: 4162: 4159: 4158: 4157: 4154: 4151: 4150: 4148: 4144: 4138: 4137:IBM Rochester 4135: 4133: 4130: 4128: 4125: 4123: 4120: 4116: 4113: 4111: 4108: 4106: 4103: 4102: 4100: 4096: 4093: 4091: 4088: 4086:, Chicago, IL 4085: 4082: 4081: 4079: 4075: 4072: 4070: 4067: 4066: 4064: 4060:, Atlanta, GA 4059: 4056: 4053: 4050: 4049: 4047: 4046: 4044: 4040: 4029: 4025: 4022: 4020: 4017: 4015: 4012: 4010: 4007: 4005: 4002: 4000: 3997: 3995: 3992: 3990: 3987: 3985: 3982: 3980: 3977: 3975: 3972: 3968: 3965: 3963: 3960: 3959: 3958: 3955: 3953: 3950: 3949: 3947: 3943: 3937: 3934: 3932: 3929: 3927: 3924: 3920: 3917: 3916: 3915: 3912: 3910: 3907: 3903: 3900: 3899: 3898: 3895: 3893: 3890: 3888: 3885: 3884: 3882: 3878: 3875: 3869: 3859: 3856: 3852: 3849: 3848: 3847: 3844: 3842: 3839: 3835: 3832: 3831: 3830: 3827: 3825: 3822: 3820: 3817: 3813: 3810: 3808: 3805: 3804: 3803: 3800: 3798: 3795: 3793: 3790: 3788: 3787:Mashup Center 3785: 3783: 3780: 3778: 3775: 3773: 3770: 3768: 3765: 3763: 3760: 3758: 3755: 3753: 3750: 3748: 3745: 3741: 3738: 3737: 3736: 3733: 3731: 3728: 3727: 3725: 3721: 3711: 3708: 3706: 3703: 3701: 3698: 3696: 3693: 3691: 3688: 3686: 3683: 3681: 3678: 3677: 3675: 3671: 3663: 3660: 3658: 3655: 3653: 3650: 3648: 3645: 3643: 3640: 3638: 3635: 3634: 3632: 3628: 3625: 3623: 3620: 3619: 3618: 3615: 3613: 3612:Power Systems 3610: 3608: 3605: 3601: 3598: 3597: 3596: 3593: 3592: 3590: 3586: 3583: 3579: 3576: 3574: 3570: 3562: 3559: 3558: 3557: 3554: 3552: 3549: 3548: 3546: 3544: 3540: 3536: 3529: 3524: 3522: 3517: 3515: 3510: 3509: 3506: 3494: 3491: 3489: 3486: 3484: 3481: 3479: 3476: 3473: 3472: 3469: 3463: 3462: 3458: 3455: 3454: 3452: 3448: 3442: 3439: 3437: 3434: 3432: 3429: 3427: 3424: 3422: 3419: 3417: 3414: 3411: 3407: 3404: 3402: 3399: 3397: 3394: 3392: 3389: 3387: 3384: 3382: 3379: 3377: 3374: 3372: 3369: 3367: 3364: 3362: 3359: 3357: 3354: 3352: 3349: 3347: 3344: 3342: 3339: 3338: 3336: 3332: 3326: 3323: 3320: 3317: 3314: 3311: 3310: 3308: 3304: 3298: 3295: 3293: 3290: 3288: 3285: 3283: 3280: 3278: 3275: 3273: 3270: 3268: 3265: 3262: 3260:DB2 Alphablox 3259: 3258: 3256: 3252: 3245: 3242: 3239: 3238: 3236: 3234: 3230: 3224: 3220: 3217: 3214: 3212: 3209: 3208: 3206: 3202: 3196: 3193: 3191: 3188: 3187: 3184: 3180: 3173: 3168: 3166: 3161: 3159: 3154: 3153: 3150: 3138: 3130: 3128: 3120: 3118: 3110: 3109: 3106: 3100: 3097: 3095: 3092: 3090: 3087: 3085: 3082: 3080: 3077: 3075: 3072: 3070: 3067: 3065: 3062: 3060: 3057: 3055: 3052: 3050: 3047: 3046: 3044: 3040: 3034: 3031: 3029: 3026: 3024: 3021: 3019: 3016: 3015: 3013: 3009: 3003: 3000: 2998: 2995: 2993: 2990: 2988: 2985: 2983: 2980: 2978: 2975: 2973: 2970: 2968: 2965: 2963: 2960: 2959: 2957: 2953: 2947: 2944: 2942: 2939: 2937: 2934: 2932: 2929: 2927: 2924: 2922: 2919: 2917: 2914: 2912: 2909: 2905: 2902: 2900: 2897: 2895: 2892: 2891: 2890: 2887: 2886: 2884: 2880: 2874: 2871: 2869: 2868:Surrogate key 2866: 2864: 2861: 2859: 2856: 2854: 2853:Candidate key 2851: 2849: 2846: 2844: 2841: 2839: 2836: 2834: 2831: 2829: 2826: 2824: 2821: 2819: 2816: 2815: 2813: 2809: 2803: 2800: 2798: 2795: 2791: 2788: 2787: 2786: 2783: 2779: 2776: 2775: 2774: 2771: 2769: 2766: 2764: 2761: 2759: 2756: 2754: 2751: 2749: 2746: 2742: 2739: 2738: 2737: 2734: 2732: 2729: 2725: 2722: 2720: 2717: 2716: 2715: 2712: 2708: 2705: 2704: 2703: 2700: 2699: 2697: 2693: 2689: 2682: 2677: 2675: 2670: 2668: 2663: 2662: 2659: 2653: 2650: 2647: 2641: 2636: 2635: 2614: 2610: 2606: 2600: 2584: 2580: 2574: 2559: 2555: 2549: 2533: 2529: 2525: 2518: 2503: 2499: 2495: 2489: 2481: 2477: 2470: 2463: 2451: 2447: 2446: 2441: 2435: 2428: 2417: 2413: 2412: 2407: 2401: 2386: 2383:. IBM. 2019. 2382: 2376: 2368: 2362: 2358: 2357: 2349: 2334: 2330: 2326: 2320: 2305: 2301: 2297: 2291: 2276: 2272: 2268: 2264: 2260: 2256: 2252: 2245: 2238: 2223: 2219: 2215: 2209: 2194: 2190: 2186: 2179: 2164: 2160: 2156: 2150: 2135: 2131: 2127: 2121: 2113: 2109: 2105: 2098: 2091: 2079: 2075: 2069: 2054: 2053:Computerworld 2050: 2043: 2028: 2024: 2018: 2010: 2006: 2002: 1998: 1994: 1987: 1969: 1965: 1961: 1957: 1953: 1949: 1945: 1938: 1931: 1913: 1909: 1905: 1901: 1897: 1893: 1889: 1882: 1875: 1860: 1856: 1850: 1842: 1836: 1832: 1831:CICS Handbook 1825: 1810: 1806: 1805: 1800: 1794: 1787: 1775: 1771: 1770: 1766: 1760: 1753: 1743:on 2018-10-30 1742: 1738: 1734: 1728: 1721: 1717: 1711: 1707: 1706: 1698: 1683: 1677: 1661: 1657: 1653: 1647: 1643: 1633: 1630: 1628: 1625: 1623: 1620: 1618: 1615: 1613: 1610: 1609: 1603: 1600: 1598: 1585: 1578: 1575: 1574: 1573: 1570: 1568: 1564: 1560: 1556: 1546: 1544: 1540: 1536: 1532: 1528: 1524: 1520: 1516: 1512: 1508: 1504: 1501:pureQuery is 1499: 1497: 1494: 1493:Visual Studio 1490: 1486: 1482: 1478: 1474: 1470: 1466: 1463: 1459: 1455: 1451: 1447: 1443: 1439: 1435: 1431: 1426: 1424: 1410: 1407: 1404: 1401: 1400: 1399: 1398: 1391: 1388: 1385: 1383:Kepler - 10.5 1382: 1379: 1376: 1374:Viper 2 - 9.5 1373: 1370: 1367: 1364: 1363: 1362: 1361: 1357: 1346: 1343: 1340: 1337: 1334: 1333: 1332: 1329: 1320: 1311: 1307: 1298: 1294: 1290: 1287: 1283: 1279: 1270: 1262: 1259: 1257: 1253: 1249: 1245: 1241: 1237: 1232: 1226: 1222: 1220: 1216: 1214: 1210: 1206: 1203: 1199: 1196: 1195: 1189: 1187: 1186:IBM Db2 for i 1183: 1182:IBM System/38 1179: 1175: 1169: 1162:Db2 for IBM i 1159: 1157: 1147: 1143: 1139: 1135: 1133: 1120: 1116: 1113: 1109: 1105: 1101: 1097: 1094: 1090: 1086: 1083: 1079: 1075: 1071: 1067: 1062: 1058: 1055: 1051: 1047: 1043: 1042: 1041: 1038: 1036: 1032: 1019: 1016: 1012: 1011: 1010: 1007: 1005: 997: 993: 990: 986: 982: 978: 974: 973: 972: 969: 967: 962: 960: 956: 946: 939: 936: 933: 930: 927: 924: 921: 918: 915: 912: 911: 910: 906: 902: 897:Db2 Warehouse 894: 891: 888: 885: 882: 879: 876: 872: 868: 865: 856: 852: 843: 840: 837: 834: 831: 827: 825: 820: 817: 813: 809: 808:DB2 pureScale 804: 802: 796: 794: 790: 785: 783: 779: 775: 771: 767: 763: 759: 754: 752: 748: 744: 740: 736: 732: 727: 725: 715: 711: 709: 705: 701: 696: 694: 690: 686: 682: 678: 674: 670: 666: 662: 658: 653: 651: 647: 642: 640: 636: 632: 627: 623: 619: 614: 612: 607: 605: 600: 598: 595:the UK-based 592: 590: 586: 582: 578: 574: 569: 567: 566:Edgar F. Codd 562: 560: 556: 545: 543: 539: 535: 531: 527: 523: 519: 515: 511: 502: 492: 488: 485: 482: 480: 476: 473: 470: 468: 464: 461: 458: 454: 451: 448: 446: 442: 439: 436: 434: 430: 427: 423: 419: 415: 412: 408: 404: 398: 396: 392: 388: 374: 370: 367: 364: 362: 358: 354: 349: 337: 330: 318: 314: 311: 307: 304: 301: 299: 295: 292: 289: 287: 283: 280: 276: 272: 268: 264: 260: 257: 253: 249: 247: 243: 240: 236: 232: 228: 225: 223: 219: 216: 212: 208: 204: 201: 199: 195: 192: 188: 184: 180: 177: 173: 169: 153: 146: 143: 139: 135: 121: 117: 114: 111: 109: 105: 101: 96: 88: 77: 74: 66: 56: 52: 48: 44: 38: 37: 32:This article 30: 21: 20: 4673:IBM software 4534: 4517: 4498:Deep Thought 4461: 4389:(since 2020) 4357:John R. Opel 4315:Think slogan 4156:Deep Thunder 3962:Kaleida Labs 3957:AIM alliance 3642:Q System Two 3637:Q System One 3459: 3436:XML database 3282:IBM OMEGAMON 3215: 3194: 2617:. Retrieved 2608: 2599: 2589:February 21, 2587:. Retrieved 2573: 2562:. Retrieved 2548: 2536:. Retrieved 2527: 2517: 2506:. Retrieved 2497: 2488: 2479: 2469: 2461: 2454:. Retrieved 2443: 2434: 2426: 2420:. Retrieved 2409: 2400: 2389:. Retrieved 2375: 2355: 2348: 2337:. Retrieved 2328: 2319: 2308:. Retrieved 2299: 2290: 2279:. Retrieved 2254: 2250: 2237: 2226:. Retrieved 2217: 2208: 2197:. Retrieved 2188: 2178: 2167:. Retrieved 2158: 2149: 2138:. Retrieved 2129: 2120: 2112:the original 2107: 2097: 2088: 2082:. Retrieved 2068: 2058:February 23, 2056:. Retrieved 2052: 2042: 2031:. Retrieved 2017: 1992: 1986: 1975:. Retrieved 1947: 1943: 1930: 1919:. Retrieved 1891: 1887: 1874: 1863:. Retrieved 1849: 1830: 1824: 1813:. Retrieved 1802: 1793: 1785: 1778:. Retrieved 1767: 1759: 1751: 1745:. Retrieved 1741:the original 1736: 1727: 1719: 1704: 1697: 1685:. Retrieved 1676: 1664:. Retrieved 1655: 1646: 1601: 1593: 1571: 1565:after every 1558: 1552: 1542: 1538: 1500: 1427: 1419: 1408:Cypress - 12 1397:Db2 for z/OS 1396: 1395: 1371:Viper - 9.1. 1359: 1358: 1355: 1330: 1326: 1317: 1308: 1304: 1295: 1291: 1282:XML database 1277: 1276: 1268: 1260: 1233: 1230: 1185: 1177: 1171: 1153: 1144: 1140: 1136: 1129: 1054:IBM Research 1039: 1028: 1008: 1001: 970: 963: 955:Db2 on Cloud 952: 943: 928:Apache Spark 907: 903: 900: 892: 889: 886: 883: 880: 877: 873: 869: 866: 862: 853: 849: 846:Db2 Database 841: 838: 835: 832: 828: 821: 805: 797: 786: 755: 728: 721: 712: 697: 654: 643: 615: 608: 601: 593: 570: 563: 551: 541: 509: 508: 501:/db2-for-zos 456:Available in 361:Developer(s) 255:Available in 149:11.5.9  108:Developer(s) 69: 60: 45:by removing 41:Please help 33: 4630:Typewriters 4536:Mathematica 4477:Rugby union 4416:Alex Gorsky 4383:(2012–2020) 4377:(2002–2011) 4371:(1993–2002) 4365:(1985–1993) 4359:(1981–1985) 4353:(1973–1981) 4347:(1971–1973) 4341:(1956–1971) 4335:(1914–1956) 4283:Terminology 4239:Floppy disk 4183:SkillsBuild 4146:Initiatives 4127:IBM Hursley 4101:Facilities 3752:Connections 3622:FlashSystem 3312:Data Studio 3263:DB2 Connect 3137:WikiProject 3028:Replication 2916:Transaction 2858:Foreign key 2838:CAP theorem 2785:Multi-model 2609:www.ibm.com 2498:www.ibm.com 2480:PC Magazine 2381:"Db2 for i" 2218:www.ibm.com 1780:October 29, 1687:15 November 1411:Apollo - 13 1377:Cobra - 9.7 1248:data mining 1204:(mainframe) 1082:NaĂŻve Bayes 1037:workloads. 988:technology. 675:(including 602:IBM bought 303:Proprietary 4652:Categories 4625:System/370 4620:System/360 4411:David Farr 4310:e-business 4212:Inventions 4161:Develothon 4042:Facilities 3902:Promontory 3897:Consulting 3478:Cloudscape 3456:ChannelDB2 3431:View (SQL) 3002:Query plan 2955:Components 2873:Unique key 2790:comparison 2724:comparison 2714:Relational 2707:comparison 2564:2024-06-07 2508:2019-08-20 2456:August 24, 2422:2018-08-24 2391:2021-12-14 2339:2019-09-09 2310:2019-09-09 2281:2019-09-07 2228:2022-06-21 2199:2019-08-20 2169:2019-08-20 2140:2019-08-20 2084:2010-03-29 2033:2018-08-24 1977:2013-02-18 1921:2013-02-18 1865:2018-08-24 1840:0070336377 1815:2018-08-24 1747:2018-10-29 1715:1558604820 1638:References 1352:Code names 1126:Db2 BigSQL 1102:document ( 1092:warehouse. 1078:Regression 1004:Db2 Hosted 959:uptime SLA 669:MS Windows 410:Written in 175:Written in 63:March 2022 43:improve it 4493:Deep Blue 4399:directors 3858:WebSphere 3797:PureQuery 3705:Selectric 3680:Blue Gene 3595:Mainframe 3450:Community 3277:PureQuery 3211:Db2 for i 3204:Platforms 3011:Functions 2946:Partition 2773:In-memory 2731:Key–value 2296:"RStudio" 2257:: 60–80. 1908:207549016 1519:databases 1219:IBM Cloud 1119:IBM Cloud 1014:business. 966:IBM Cloud 733:acquired 585:DSL/Alpha 499:/products 207:Unix-like 4575:Category 4542:IBM Plex 4397:Board of 4290:Big Blue 4090:Honolulu 3999:Merative 3984:EduQuest 3967:Taligent 3936:Research 3873:entities 3871:Business 3812:OpenQASM 3740:Cloudant 3710:ThinkPad 3633:Quantum 3581:Hardware 3573:Products 3488:Informix 3334:Features 3233:Editions 3221:DB2 for 3117:Category 3033:Sharding 2889:Relation 2863:Superkey 2818:Database 2811:Concepts 2613:Archived 2583:Archived 2532:Archived 2502:Archived 2450:Archived 2416:Archived 2385:Archived 2333:Archived 2304:Archived 2275:Archived 2222:Archived 2193:Archived 2163:Archived 2159:Datanami 2134:Archived 2078:Archived 2027:Archived 2009:32077291 1968:Archived 1912:Archived 1859:Archived 1809:Archived 1774:Archived 1666:13 April 1660:Archived 1606:See also 1525:via its 1507:platform 1365:Xperanto 1265:Editions 1207:Db2 for 1200:Db2 for 919:XML data 735:Illustra 710:(DDM).) 577:System R 445:Platform 426:assembly 400:13.1 279:Japanese 222:Platform 187:assembly 4658:IBM DB2 4585:Commons 4552:ScicomP 4095:Seattle 4048:Towers 3994:Lexmark 3989:Kyndryl 3931:Red Hat 3880:Current 3851:Granite 3846:Watsonx 3762:Fortran 3690:PowerPC 3617:Storage 3588:Current 3551:History 3543:History 3416:SQL/XML 3410:SQL/PSM 3391:Quiesce 3386:pureXML 3351:Trigger 3341:B+ tree 3292:MongoDB 3195:IBM Db2 3127:Outline 2926:Trigger 2882:Objects 2619:11 June 2581:. IBM. 2538:Sep 14, 2528:ibm.com 2300:RStudio 2271:5401521 2108:ibm.com 1964:1202171 1535:runtime 1523:objects 1489:Eclipse 1446:Fortran 1301:History 1223:Db2 on 1217:Db2 on 1178:DB2/400 1074:k-means 980:choice. 925:RStudio 622:DOS/VSE 575:called 559:drivers 548:History 490:Website 479:License 460:English 380: ( 316:Website 298:License 275:Russian 263:Spanish 259:English 211:Windows 160: ( 127: ( 93:IBM Db2 4557:Unions 4168:Fellow 3979:Cognos 3952:AdStar 3945:Former 3909:Kenexa 3887:Apptio 3841:Watson 3807:Qiskit 3673:Former 3662:Condor 3652:Osprey 3627:DS8000 3441:XQuery 3406:SQL PL 3381:PL/SQL 2941:Cursor 2899:column 2768:NewSQL 2363:  2269:  2007:  1995:: 35. 1962:  1906:  1837:  1712:  1533:, and 1473:Python 1458:Delphi 1423:XQuery 1211:& 1174:OS/400 1132:Hadoop 1080:, and 801:PL/SQL 679:) and 667:, and 626:VM/CMS 618:SQL/DS 589:SEQUEL 332:  271:German 267:French 250:1.6 GB 227:x86-64 4455:Other 3926:Press 3919:India 3735:Cloud 3723:Other 3657:Heron 3647:Eagle 3600:IBM Z 3371:NoSQL 3306:Tools 3218:(LUW) 2931:Index 2894:table 2797:Cloud 2763:NoSQL 2758:Graph 2695:Types 2267:S2CID 2247:(PDF) 2189:ZDNet 2005:S2CID 1971:(PDF) 1960:S2CID 1940:(PDF) 1915:(PDF) 1904:S2CID 1884:(PDF) 1559:SQLCA 1527:tools 1438:COBOL 1402:Eagle 1227:(AWS) 1100:NoSQL 1070:ANOVA 976:grow. 824:MySQL 729:When 685:z/VSE 673:Linux 555:IBM i 472:RDBMS 291:RDBMS 235:SPARC 203:Linux 4600:FOSS 4325:CEOs 4229:DRAM 3824:SPSS 3767:ILOG 3356:DRDA 3223:z/OS 2982:ODBC 2972:JDBC 2911:View 2848:Null 2843:CRUD 2823:ACID 2778:list 2741:list 2719:list 2621:2016 2591:2022 2540:2019 2458:2018 2361:ISBN 2060:2013 1835:ISBN 1782:2018 1710:ISBN 1689:2023 1668:2023 1588:-911 1581:+100 1541:and 1531:APIs 1515:.NET 1513:and 1511:Java 1491:and 1485:Ruby 1477:Perl 1469:Java 1462:.NET 1434:PL/I 1430:Rexx 1421:and 1284:and 1252:OLAP 1202:z/OS 1112:BSON 1108:JSON 770:OLTP 762:z/OS 693:OS/2 689:z/VM 687:and 681:PDAs 665:UNIX 661:OS/2 646:DBMS 639:DL/I 633:, a 624:and 536:and 534:JSON 497:.com 467:Type 438:z/OS 414:PL/X 382:1983 375:1983 327:/db2 325:.com 323:.ibm 286:Type 246:Size 215:OS/2 191:Java 129:1983 122:1983 3535:IBM 3483:IMS 2977:XQJ 2904:row 2558:IBM 2445:IBM 2411:IBM 2259:doi 1997:doi 1952:doi 1896:doi 1804:IBM 1567:SQL 1503:IBM 1481:PHP 1465:CLI 1450:C++ 1442:RPG 1360:Db2 1244:ETL 1209:VSE 1176:to 1104:XML 766:XML 753:. 704:LAN 650:MVS 631:IMS 581:SQL 542:DB2 538:XML 522:IBM 510:Db2 495:ibm 422:C++ 366:IBM 321:www 231:x86 183:C++ 113:IBM 4654:: 3493:U2 2607:. 2556:. 2530:. 2526:. 2500:. 2496:. 2478:. 2460:. 2442:. 2425:. 2414:. 2408:. 2331:. 2327:. 2302:. 2298:. 2273:. 2265:. 2255:27 2253:. 2249:. 2216:. 2191:. 2187:. 2157:. 2128:. 2106:. 2087:. 2051:. 2003:. 1966:. 1958:. 1948:24 1946:. 1942:. 1910:. 1902:. 1892:13 1890:. 1886:. 1857:. 1807:. 1801:. 1784:. 1750:. 1735:. 1718:. 1654:. 1545:. 1529:, 1498:. 1483:, 1479:, 1475:, 1471:, 1467:, 1460:, 1456:, 1452:, 1448:, 1444:, 1440:, 1436:, 1432:, 1258:. 1250:, 1246:, 1240:BI 1213:VM 1188:. 1110:, 1106:, 1076:, 1072:, 1068:, 663:, 641:. 591:. 561:. 424:, 420:, 416:, 308:, 277:, 273:, 269:, 265:, 261:, 237:, 233:, 229:, 209:, 205:, 189:, 185:, 181:, 4486:/ 4030:) 4026:( 3527:e 3520:t 3513:v 3412:) 3408:( 3171:e 3164:t 3157:v 2680:e 2673:t 2666:v 2623:. 2593:. 2567:. 2542:. 2511:. 2482:. 2394:. 2369:. 2342:. 2313:. 2284:. 2261:: 2231:. 2202:. 2172:. 2143:. 2062:. 2036:. 2011:. 1999:: 1980:. 1954:: 1924:. 1898:: 1868:. 1843:. 1818:. 1691:. 1670:. 1454:C 998:. 776:/ 418:C 384:) 329:/ 179:C 164:) 131:) 89:. 76:) 70:( 65:) 61:( 57:. 39:.

Index

an advertisement
improve it
promotional content
external links
neutral point of view
Learn how and when to remove this message
DB2 (disambiguation)

Developer(s)
IBM
Stable release(s)
Edit this on Wikidata
C
C++
assembly
Java
Operating system
Linux
Unix-like
Windows
OS/2
Platform
x86-64
x86
SPARC
IBM Power microprocessors
Size
English
Spanish
French

Text is available under the Creative Commons Attribution-ShareAlike License. Additional terms may apply.

↑