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

• Normalization and Denormalization

• Assuring Data Integrity in DB2

• Views, Aliases, and Synonyms

• Index Guidelines

• Naming Conventions

• Miscellaneous DDL Guidelines

You must make many choices when implementing DB2 objects. The large number of alternatives can intimidate the beginning user . By following the data definition guidelines in this chapter, you can ensure that you make the proper physical design decisions. Rules are provided for selecting the appropriate DB2 DDL parameters, choosing the proper DB2 objects for your application, and implementing a properly designed physical database.