Writer instructions | |
|---|---|
Page title | For most spaces, this page must be titled Space announcements. For spaces with localized content, this page must be titled Space announcements l10n. |
Purpose | Provide an announcement banner on every page of your space. |
Location | Move this page outside of your home branch. |
Guidelines | |
Reorganizing table spaces
Use the following procedure to reorganize simple, segmented, or partitioned table spaces.
Before you begin
BMC AMI Reorg automatically produces an image copy after each reorganization. Use the OUTPUT-command-for-BMC-AMI-Reorg or XCPYDYNM-dynamic-image-copy-data-set-allocation-automation-control-point to allocate data sets for the image copies.
If you are reorganizing partition-by-growth (PBG) table spaces, see Reorganizing-partition-by-growth-PBG-table-spaces.
If you are reorganizing XML table spaces, see Reorganizing-XML-table-spaces.
If you are reorganizing LOB table spaces, see Reorganizing-LOB-table-spaces.
To reorganize table spaces
Create a REORG TABLESPACE statement as follows:
To reorganize
Do this
Example
A simple table space
Create a basic REORG TABLESPACE statement
REORG TABLESPACE NWDB.ALLACCTSA set of table spaces but exclude specific table spaces within the set
Include an EXCLUDE-TABLESPACE clause.
REORG TABLESPACE ADMINDB.CAR%
EXCLUDE TABLESPACE ADMINDB.CARMIDSZ
EXCLUDE TABLESPACE ADMINDB.CARLUXRY
EXCLUDE TABLESPACE ADMINDB.CARUVSA table space but send discards to a data set based on specific criteria
Include a Discard specification clause and a WHERE clause.
//OBSOLETE DD DISP=SHR,DSN=ADMIN.CENTRAL.DISCARDS
//SYSIN DD *
REORG TABLESPACE DB9900.CENTRAL
DISCARDDN(OBSOLETE)
DISCARD FROM TABLE DB9900.CENTRAL_INV_TBL WHERE (SKU > '592032')Physical partitions of a partitioned table space (a single partition, a range, or a mixture of both)
Include an PART or PARTS keyword. PART and PARTS are interchangeable.
Specifies a single partition:
REORG TABLESPACE NWDB.ALLACCTS PART(7)Specifies a range of partitions by including the starting and ending partition numbers, separated by a colon:REORG TABLESPACE NWDB.ALLACCTS PARTS(2:8)
Specifies a mixture of single partitions and ranges:REORG TABLESPACE NWDB.ALLACCTS PART(2,5:9,12,15:22,25,30)
Logical partitions of a partitioned table space (a single partition, a range, or a mixture of both)
Include an LPART or LPARTS keyword. LPART and LPARTS are interchangeable.
Specifies a single partition:
REORG TABLESPACE NWDB.ALLACCTS LPART(7)Specifies a range of partitions by including the starting and ending partition numbers, separated by a colon:REORG TABLESPACE NWDB.ALLACCTS LPARTS(2:8)
Specifies a mixture of single partitions and ranges:REORG TABLESPACE NWDB.ALLACCTS LPART(2,5:9,12,15:22,25,30)
- Run the statement.