One of my table spaces had a total of 89.335.680 KB, with 74.727.520
KB free space (usage of 16,35%). I mean that a reorg could be a good
idea to free the space on the disk.
How to do that?
In the "Utility Guide and Reference" I can find the REORG command
description, but after all, I will start my commande:
db2 => REORG TABLESPACE SAPPA3.ZPA3#STABD SHRLEVEL REFERENCE
The answer of DB2 is:
SQL0104N An unexpected token "TABLESPACE" was found following
"REORG".
Expected tokens may include: "TABLE". SQLSTATE=42601
The REORG command doesn't have any effect on table space:
db2 => ? REORG
REORG {TABLE table-name Table-Clause | {INDEXES ALL FOR TABLE table-
name |
INDEX index-name [FOR TABLE table-name]} Index-Clause}
[On-DbPartitionNum-Clause]
Can somebody help me?
Thanks of all
Regards
Séverin