Chapter 4. Database Objects
• Understanding data structures
• Managing database objects
• Creating database objects: data types, tables and table spaces, aliases and synonyms, constraints, views, materialized query tables, indexes, databases, storage groups, and sequence objects
• Database design and implementation
DB2 is a relational database that consists of one or more tables made up of rows and columns. The tables are created and accessed using the industry-standard Structured Query Language. Data in these tables is accessed via content, not location. This chapter looks at the structures in a DB2 subsystem and those that make up a DB2 database.
Many of these objects can be directly referenced from an SQL statement; therefore, it is important ...
Get DB2® for z/OS® Version 8 DBA Certification Guide 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.
