Reorg index not using tempspace?

[alexhguerra]

Hello

Is it possible that a reorg index doesnt use a sys temporary
tablespace and use the index tablespace in a reorg index? (db2 udb v8
fixpack 12 - there are 2 8k system tablespaces on this DB)

The command is REORG INDEXES ALL FOR TABLE xxx.xxx ALLOW WRITE ACCESS

Thanks

[James]

Re: Reorg index not using tempspace?

Try this command,
REORG INDEXES ALL FOR TABLE xxx.xxx USE tbspac ALLOW WRITE ACCESS