The X-Files: Rebuild Index

Peter Adlersburg

The X-Files: Rebuild Index
Dear DB2-folks,

I recently had to repeat this recovery-task and managed to save about 24
hours of runtime by simply using this utility-syntax:

LISTDEF RECOVERY_TS
INCLUDE TABLESPACE DS01*.* PARTLEVEL
EXCLUDE TABLESPACE DS01ASS.* PARTLEVEL

LISTDEF RECOVERY_IX
INCLUDE INDEXSPACE DS01*.*
EXCLUDE INDEXSPACE DS01ASS.*

RECOVER LIST RECOVERY_TS
TORBA X'0996C76EAA30'

REBUILD INDEX LIST RECOVERY_IX
SORTDEVT SYSDA
SORTNUM 40

that means, if you can afford to rebuild your indexes without the partlevel
clause - do it!

kind regards and happy new year,

peter

______________________________________________________________________

* IDUG 2009 Melbourne, Australia * 18-20 March * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html