October 2013
Beginner to intermediate
784 pages
20h 55m
English
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 ...