DB2 sample tables

Much of the DB2® information refers to or relies on the DB2 sample tables. As a group, the tables include information that describes employees, departments, projects, and activities, and they make up a sample application that exemplifies many of the features of DB2.

Begin general-use programming interface information.

The sample storage group, databases, table spaces, tables, and views are created when you run the installation sample jobs DSNTEJ1 and DSNTEJ7. DB2 sample objects that include LOBs are created in job DSNTEJ7. All other sample objects are created in job DSNTEJ1. The CREATE INDEX statements for the sample tables are not shown here; they, too, are created by the DSNTEJ1 and DSNTEJ7 sample jobs.

Authorization on all sample objects is given to PUBLIC in order to make the sample programs easier to run. You can review the contents of any table by executing an SQL statement, for example SELECT * FROM DSN8A10.PROJ. For convenience in interpreting the examples, the department and employee tables are listed in full.

End general-use programming interface information.

Activity table (DSN8A10.ACT)
The activity table describes the activities that can be performed during a project.
Department table (DSN8A10.DEPT)
The department table describes each department in the enterprise and identifies its manager and the department to which it reports.
Employee table (DSN8A10.EMP)
The sample employee table identifies all employees by an employee number and lists basic personnel information.
Employee photo and resume table (DSN8A10.EMP_PHOTO_RESUME)
The sample employee photo and resume table complements the employee table.
Project table (DSN8A10.PROJ)
The sample project table describes each project that the business is currently undertaking. Data that is contained in each row of the table includes the project number, name, person responsible, and schedule dates.
Project activity table (DSN8A10.PROJACT)
The sample project activity table lists the activities that are performed for each project.
Employee-to-project activity table (DSN8A10.EMPPROJACT)
The sample employee-to-project activity table identifies the employee who performs an activity for a project, tells the proportion of the employee's time that is required, and gives a schedule for the activity.
Unicode sample table (DSN8A10.DEMO_UNICODE)
The Unicode sample table is used to verify that data conversions to and from EBCDIC and Unicode are working as expected.
Relationships among the sample tables
Relationships among the sample tables are established by foreign keys in dependent tables that reference primary keys in parent tables.
Views on the sample tables
DB2 creates a number of views on the sample tables for use in the sample applications.
Storage of sample application tables
Normally, related data is stored in the same database.
SYSDUMMYx tables
DB2 for z/OS provides a set of SYSDUMMYx catalog tables.

Parent topic: What is DB2 for z/OS?

Related concepts:

Phase 1: Creating and loading sample tables