Chapter 7. Working with Database Objects

In this chapter we discuss the various objects that may exist in your database, such as tables, indexes, views, sequence objects, and stored procedures. We also describe the different data types supported by DB2. This chapter is closely related to Chapter 8, The DB2 Storage Model, where the implementation and manipulation of several of these objects is explained, and to Chapter 9, Leveraging the Power of SQL, which explains how to work with these database objects using the SQL language.

In this chapter you will learn about:

  • The big picture of the DB2 database objects

  • The definitions of databases, database partitions, partition groups, buffer pools, and table spaces

  • The DB2 data types

  • How to work with tables, ...

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.