7.18. Summary

This chapter discussed the concept of databases, database partitions, and the DB2 database objects. Among the DB2 database objects, it explained how to work with partition groups, table spaces, buffer pools, tables, views, indexes, schemas, stored procedures, and so on. Some of these objects are further explained in Chapter 8, The DB2 Storage Model.

The chapter also discussed the DB2 data types (DB2 built-in and user-defined types), which are used as ways to define the columns of a table or as parameters to stored procedures and functions.

There was a detailed explanation about table objects because there are many topics associated with tables, such as constraints, referential integrity, the use of NULLs, identity columns, and table ...

Get Understanding DB2®: Learning Visually with Examples now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.