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 Chapters 8, 9, and 10. Chapter 8, The DB2 Storage Model, explains the implementation and manipulation of several of these objects. Chapter 9, Leveraging the Power of SQL, explains how to work with these database objects using the SQL language, and Chapter 10, Mastering the DB2 pureXML Support, discusses how to work with XML documents in DB2.

In this chapter you will learn about:

  • The big picture of the DB2 database objects

  • The definitions of databases, database partitions, ...

Get Understanding DB2®: Learning Visually with Examples, Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.