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

DB2 Reorg of Tables and recreation of indexes

Status
Not open for further replies.
kozlow

kozlow

MIS
Mar 3, 2003
326
US
I created a script that runs a reorgchk of tables.

It then decides if the table needs to be reorged.
Checks the Indexes and decides if any need to be recreated.

It then drops / creates the selected indexes (adds the associated table to the select tables).
REORGS the selected tables by it primary index.
Runs RUNSTATS on the selected tables.

I have not been able to figure or find out if it is better to reorg the indexes then the tables or the tables then the indexes.

Any advantage to one way or the other?
 
Status
Not open for further replies.

Similar threads

P
  • Locked
  • Question
DB2 LUW SYSCATSPACE is full
Replies
0
Views
377
prashant_0701
P
tekpr00
  • Locked
  • Question
Adding storage to DB2 PureScale Cluster
Replies
0
Views
292
tekpr00
tekpr00
Rohit K Gupta
  • Locked
  • Question
DB2 Equivalent of IGNORE_DUP_KEY
Replies
0
Views
132
Rohit K Gupta
Rohit K Gupta
gdg1976
  • Locked
  • Question
db2 sql extract double rows (different in case sensitive) 1
Replies
6
Views
240
mikrom
mikrom
walter.weinmann
  • Locked
  • Question
Docker Iage IBM Db2 11.5.6.0: Insufficient data. ERRORCODE=-4499, SQLSTATE=08001
Replies
0
Views
298
walter.weinmann
walter.weinmann

Part and Inventory Search

Sponsor

Back
Top