O'Reilly logo

DB2® for z/OS® Version 8 DBA Certification Guide by Susan Lawson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required