Reducing the MAXPARTITIONS value for a partition-by-growth table space

You can use either the AL line command or the ALT line command to change the MAXPARTITIONS value of a partition-by-growth (PBG) table space. In both situations, an ALTER TABLESPACE statement is used to change the table space; the table space is not dropped and recreated.

AL method

Procedure

To reduce the MAXPARTITIONS value by using the AL line command:

  1. On the Table Spaces (ADB21S) panel, issue the AL line command against the table space for which you want to reduce the MAXPARTITIONS value.
  2. On the Alter Table Space (ADB21SA) panel, type a new value in the Max Partitions field, and press Enter.

    An ALTER TABLESPACE statement is executed and the MAXPARTITIONS value is reduced.

ALT method

Procedure

To reduce the MAXPARTITIONS value by using the ALT line command:

  1. On Table Spaces (ADB21S) panel, issue the ALT line command against the table space for which you want to reduce the MAXPARTITIONS value.
  2. On the Redefine Table Space (ADB21SAR) panel, type a new value in the Max Partitions field, and enter NEXT on the command line.
  3. Generate an ALT job.

    In this case, Db2 Admin Tool determines that this change can be made with an ALTER TABLESPACE statement and issues the statement.