Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Temporary mapping table

Status
Not open for further replies.
staland

staland

Technical User
Apr 22, 2003
9
DK
Hi
We're running DB2 v7 on z/OS

So far we've had one shared mapping table for running online reorg. I'm trying to change it so we can use a temporary table for the reorg jobs - that way we can run several reorg jobs simultaneously without having different mapping tables created.

But the mapping table needs an index ......

So my question is - how can I create / declare an index on a temporary table ??

Hope someone can answer

Helle
 
Status
Not open for further replies.

Similar threads

evr72
  • Locked
  • Question
Update field from one table with a join table
Replies
1
Views
205
evr72
evr72
MohanV
  • Locked
  • Question
Using table functions in Query
Replies
5
Views
229
fredericofonseca
fredericofonseca
pratimsingha
  • Locked
  • Question
Alternative of Select count(*) from TABLE
Replies
0
Views
183
pratimsingha
pratimsingha
usr1234
  • Locked
  • Question
does the setting PARALLEL_DEGREE=*OPTIMIZE helps the execution of an ALTER TABLE ?
Replies
0
Views
117
usr1234
usr1234
SE2097
  • Locked
  • Question
IBM DB2 On Cloud - How is table column name formatted?
Replies
0
Views
136
SE2097
SE2097

Part and Inventory Search

Sponsor

Back
Top