All four editions provide the same full-function database management system, but they differ from each other in terms of connectivity options, licensing agreements, and additional function. Check constraints allow you to specify a range of values allowed in one or more columns of every row of a table.ĭB2 comes in the following editions: DB2 Express, DB2 Workgroup Server Edition, DB2 Enterprise Server Edition, and DB2 Personal Edition. Check constraints are provided to enforce rules not covered by uniqueness or referential integrity. Referential constraints let you define relationships between and within tables by requiring that all values of a given column of a table also exist in some other table or column. Tables, instances, directories, storage objects, configuration files, andĭB2 provides unique constraints to ensure that the values in a set of columns are unique and not null for all rows in the table. Objects, data integrity, object relational capabilities, system catalog The basic elements used by DB2 Universal Database include database System catalogs, directories, and configuration files. The basic elements of a database engine are database objects, All data access takes place through the SQL Management, ensures data integrity and data protection, and providesĬoncurrency control. It, generates packages, generates optimized paths, provides transaction It manages the data, controls all access to The database engine provides the base functions of the DB2 relationalĭatabase management system. Management system include the database engine and facilities to accessĭata such as the Command Center, Command Line Processor, the ControlĬenter, and application interfaces. The major components of the DB2 Universal Database relational database The DB2 products for the distributed platforms share the same source code. Internally, the DB2 products that run on the mainframe platforms (MVS, z/OS, iSeries, and so on) differ from the products that run on distributed platforms (Linux, Unix, and Windows). It can be scaled from hand-held computers to single processors to clusters of computers and is multimedia-capable with image, audio, video, and text support.ĭB2 is optimized for each platform to maximize performance.

DB2 Universal Database is a Web-enabled relational database management system that supports data warehousing and transaction processing.

Db2 universal database 9