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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Reorg Tablespace Command

Status
Not open for further replies.
TSch

TSch

Technical User
Jul 12, 2001
557
DE
Hi folks,

is there a way to reorg a certain tablespace using db2 command line ?

I know that you use "db2 reorg table xyz" to reorganize a certain table, but what would be the exact command to reorganize a whole tablespace ?

Regards
Thomas
 
Sort by date Sort by votes
Normally , I have a script that queries the DB2 elements and then generating the REORG TABLE / INDEX statements



Jack Vamvas

All the IT jobs in one place -
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

handle907
  • Locked
  • Question
Tablespace utilization rate is 80% but only few small tables there.
Replies
0
Views
96
handle907
handle907
DMo42
  • Locked
  • Question
DB2 11.1 SQL1022C There is not enough memory available to process the command
Replies
0
Views
160
DMo42
DMo42
cpu533
  • Locked
  • Question
table reorg request
Replies
2
Views
62
cpu533
cpu533
mpezeur
  • Locked
  • Question
coredump on DB2 v10.1 upgrade database command
Replies
2
Views
69
papadba
papadba
JMaria
  • Locked
  • Question
Calculation of Reorg times in DB2
Replies
1
Views
80
papadba
papadba

Part and Inventory Search

Sponsor

Back
Top