What Is Table Partitioning?

Table partitioning allows you to store data for a table across several data storage devices. With IBM DB2 for OS/390, a table is partitioned when you:

  • create the table in a partitioned table space, and

  • create a clustered index that specifies how the table data should be distributed across the partitions using the index key values.

    Note: IBM DB2 for OS/390 requires that the clustered index be created or dropped only when the table is created or dropped.

For more information on partitioning with IBM DB2, see the IBM DB2 Universal Database Administration Guide: Design and Implementation.

Prerequisite Knowledge for Working with Partitioning

Anyone who is considering implementing partitioning with Lawson must have expert knowledge of IBM DB2, including the IBM DB2 Command Line Processor, as well as be experienced in working with Lawson data and utilities.

The following utilities are used when working with partitioning. See the Lawson Administration: Server Setup and Maintenance guide for details.

  • dbdef

  • blddbdict

  • dbreorg

  • impexp

The verifyibm utility and the IBM database driver configuration file are also used with partitioning.

Before performing the partitioning implementation procedure, make sure you complete the planning steps. Implementing IBM DB2 for zSeries Partitioning