Balancing the I/O activities

About this task

If you have a large number of UDRs that span multiple extents, you can spread the system catalog tables across separate physical devices (chunks) within the same dbspace to balance the I/O activities.

To spread user-defined routine catalogs across devices:

Procedure

  1. Create the dbspace for the UDR system catalog tables with several chunks. Create each chunk for the dbspace on a separate disk.
  2. Use the CREATE DATABASE statement with the IN dbspace clause to isolate the system catalog tables in their own dbspace.
  3. Load approximately half of your UDRs with the CREATE PROCEDURE or CREATE FUNCTION statement.
  4. Create a temporary table in the dbspace with an extent size large enough to use the remainder of the disk space in the first chunk.
  5. Load the remainder of the UDRs. The last half of the routines should spill into the second chunk.
  6. Drop the temporary table.