Important We are integrating BMC AMI LOBMaster technology into the BMC AMI Reorg product and discontinuing BMC AMI LOBMaster as a separate product. For the latest integrated documentation, see BMC AMI Reorg for Db2 13.1.

REORG TABLESPACE[S]

This specification tells BMC AMI Reorg which table space or group of table spaces to reorganize.

databaseName.tableSpaceName

You must specify both the database name and the table space name. The default name is DSNDB04.

Important

The database name specifies the database to be reorganized. It cannot be DSNDB01, DSNDB06, DSNDB07.

Related topics

REORG-TABLESPACE-option-descriptions

REORG-TABLESPACE-syntax-diagrams

databasePattern.tableSpacePattern

You can use the percent (%) and underscore (_) symbols as wildcards to construct an SQL query that obtains all table spaces that match the specified pattern:

  • Use % to represent any character string.
  • Use _ to represent a single character.

A line will print on SYSPRINT and SUMMARY for each object found.

Specify databaseName.% to reorganize all the table spaces in a database. In the following example, every table space beginning with the character 'A' in the database BIGDBASE will be reorganized:

REORG TABLESPACE BIGDBASE.A%

OBJECTSET objectSetName

Specify the name of an existing object set to have BMC AMI Reorg reorganize all table spaces defined in that object set.

You can define object sets in the DASD MANAGER PLUS for Db2 product. For more information about object sets using DASD MANAGER PLUS, see the Defining and maintaining object sets.

You cannot use the following options when using an object set:

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*