Prerequisite Installation Steps

Before you begin implementing IBM DB2 for OS 390, make sure you complete the following:

• Plan the logical structure of the database:

  • Determine which tables should be partitioned.

  • Determine the range of key column values present in each partitioned table.

• Plan the physical structure of the database:

  • Determine the total space requirement for the database.

  • Determine the space requirement for each table you plan to partition.

    Note: The schema derived at this point determines the physical distribution of the data on the set of partitions defined for the table.

  • Determine the number of partitions necessary to reflect the range of key column values.

  • Create the physical database.

  • Create the partitioned table spaces.

  • Create the database directory entry for the new database on the client platform.

  • Verify connectivity between the client and the OS/390 server; at the prompt, type:

    db2 connect to databasename user username using password