Recreating all OW indexes, OW Xe

sv800

Active Member
Tech-Folks:
I want to rebuild all OW indexes.
We had reviewed DBCC Reindex command and
KG Doc oti-00-0123 Re-creating large amounts of OneWorld indexes.
This procedures runs an R98404 UBE.
I'm wondering how much will take to recreate all indexes.
Can somebody estimates time and resources consumption...

S. Vargas
OW Xe, Windows 2000, Update 1, SQL 2000, WTS-Citrix

The Premier Group
 
Hi S. Vargas,

It depends how big you database is. When I ran this UBE, it took about 6-7 hours on a SQL Server 2000, 4 processor. It worked great.

Thanks

Adrian Valentim
Valmatrix Consulting Inc.
 
Keep in mind that the R98404 UBE uses the F9843 table in the System data source (JDE7333) for a list of tables. This is a Pristine table and does not include any tables added later. We create table lists from each of our environments and temporarily replace the data in the F9843 table with the appropriate list when running the process. Fortunately, only the first column (JSOBNM) is unique. The only other column that needs to be populated is JSCNVTYP. You plug it with the number 4.

There is another UBE, R9698712, designed for creating all primary keys. We have never used it so I can't tell you if it has any issues.


Ray W. Justus
Kitchell Corporation
1707 East Highland Avenue, Suite 100
Phoenix, AZ 85016-4668
(602) 631-6157
 
Back
Top