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

Jan 14 '08 #1

James

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

Jan 15 '08 #2