Chapter 7. Working with Database Objects
In this chapter, we discuss how to create and work with databases. First, we explain how DB2 stores database objects on disk and memory with an introduction to different concepts such as automatic storage, storage groups, table spaces, and buffer pools. Then we describe the various database objects that can be created in the database, such as tables, indexes, and views. The chapter assumes you have basic knowledge of the Structure Query Language (SQL); if not, refer to Appendix B, “Introduction to SQL.”
In this chapter, you learn about
• The big picture of DB2 databases and database objects
• Database creation and structure
• The definitions of database partitions, partition groups, table spaces, buffer ...
Get DB2 Essentials: Understanding DB2 in a Big Data World, Third Edition 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.
