This week’s IDUG Db2 Tech Conference in Malta offers world-class education that not only brings DBAs and developers them up to date with Db2, but also helps them navigate the landscape of data science, fast data, regulatory compliance, and machine learning.
Referential integrity (RI) is the state in which all values of all foreign keys are valid. Both traditional RI and temporal RI are relationships between pairs of tables, in which the business rules are represented. In Db2 V8, informational RI (with NOT ENFORCED keyword) was added to benefit certain
With the temporal logical transaction support of Db2 12, Db2 allows an application to specify and manage the scope of temporal work easily and concisely. Both physical and temporal logical transactions can happen sequentially and/or concurrently without violating the integrity of the data. In additi
The IDUG Db2 Tech Conference is not only about Db2 anymore. In the past, the scope was limited to pure Db2-related in-depth functions and features for DBAs and application programmers. Today, IDUG offers a broader perspective, addressing additional topics.
This article is one in a series that focuses on improving performance in Db2 Warehouse. The first part provides some background information and lays out the first and most important aspect of query optimization, namely, cardinality estimation or estimating the number of rows in an execution plan.