467,877 Members | 1,221 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,877 developers. It's quick & easy.

Reorg index not using tempspace?

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
  • viewed: 2042
Share:
1 Reply
Try this command,
REORG INDEXES ALL FOR TABLE xxx.xxx USE tbspac ALLOW WRITE ACCESS
Jan 15 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

27 posts views Thread by Raquel | last post: by
2 posts views Thread by TomHorner | last post: by
1 post views Thread by hikums | last post: by
16 posts views Thread by andy.standley | last post: by
3 posts views Thread by datapro01 | last post: by
2 posts views Thread by EpsilonAurigae | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.