Modifying a table space

Use Modify Table Space window to modify a table space. A modify table space deletes image copy rows from catalog tables SYSIBM.SYSCOPY and SYSIBM.SYSLGRNX. You should modify your table spaces regularly to clear outdated information from SYSIBM.SYSCOPY and SYSIBM.SYSLGRNX. These tables, particularly SYSIBM.SYSLGRNX, can become very large and take up considerable amounts of space. By deleting outdated information from these tables, you can help improve performance for processes that access data from these tables.

Authorities and privileges

To modify a table space:

  1. Open the Modify Table Space window.

  2. Select to modify all partitions or data sets, or select a particular partition or data set number.

  3. Determine the criteria for deleting records from catalog table SYSIBM.SYSCOPY. There are three options:

    1. Delete SYSCOPY records that are older than a specified number of days. Type the number of days as an integer. This number can range from 0 to 32767. Records created today are of age 0, and cannot be deleted by this option.
    2. Delete SYSCOPY records that were written before a specified date. The date is an integer with the form of either an 8- or 6- character format. You must specify a year (yyyy or yy), month (mm), and day (dd) in the form yyyymmdd or yymmdd.
    3. Delete all records, regardless of their age or date.

  4. Click OK.

Related information