Chapter 5. Data Definition Guidelines

In This Chapter

• An Overview of DB2 Database Objects

• DB2 Databases

• Creating and Using DB2 Table Spaces

• DB2 Storage and STOGROUPs

• Table Guidelines

• General Table Guidelines

• Normalization and Denormalization

• Assuring Data Integrity in DB2

• Referential Integrity

• Views, Aliases, and Synonyms

• Index Guidelines

• Naming Conventions

• Miscellaneous DDL Guidelines

You must make many choices when implementing database objects for any DBMS. As such, the large number of alternatives when building your DB2 databases can intimidate the beginning user. Sometimes, it can intimidate more advanced users, too! By following the data definition guidelines in this chapter, you can ensure that you make the ...

Get DB2 Developer’s Guide: A Solutions-Oriented Approach to Learning the Foundation and Capabilities of DB2 for z/OS, Sixth 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.

Start your free trial