Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

How to reorg tablespace

86 views
Skip to first unread message

Severin

unread,
Jan 7, 2009, 8:58:18 AM1/7/09
to
Hello,

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

Mark A

unread,
Jan 7, 2009, 10:28:35 AM1/7/09
to
I think you are trying to work on DB2 for Linux, UNIX, and Windows using a
manual for DB2 for z/OS. These are different products and you need the
correct manual/documentation.


0 new messages