Indexes generation

Hi list,

I'm searching an automatism for indexes generation for all tables into PD7333, PRODCTL and PRODDTA. I can make this with OMW for PD7333 and PRODCTL, but for PRODDTA....
Can you help me?

Thanks a lot.
OW Xe SP23. Oracle 9.2.0.1. Win2kSP4. Citrix Metaframe FR3

Hi Luca,

Take a look at BSFN B9800200, function CreateIndex, it
recreates all indexes for a given table.
Retrieve table names from F9860, filter those who belong
to PRODDTA, and then execute this BSFN on them.

You can use R98404. Make sure you research it's use as it is a little tricky. Ensure you understand what role the F9843 plays in the process.



[ QUOTE ]
Hi list,

I'm searching an automatism for indexes generation for all tables into PD7333, PRODCTL and PRODDTA. I can make this with OMW for PD7333 and PRODCTL, but for PRODDTA....
Can you help me?

Thanks a lot.
OW Xe SP23. Oracle 9.2.0.1. Win2kSP4. Citrix Metaframe FR3

[/ QUOTE ]

Hi Sebastian,

I've not experience with BSFN. I've seen B9800200 has CreateIndex function, but how can execute it on those tables who belong to PRODDTA, PRODCTL and PD7333?

Thanks

I've tried to execute R98404, but when I run XJDE0001 version system says to me that there are no data selection. Probably I must change something into data selection?

Thanks

Hi,

You (or someone else) will have to create a custom report
to run that BSFN, or well you can try with R98404.

Hi Sebastian,

I've tried with R98404, but every data selection I change, response is "No Data Selected". I've tried to put in Data Selection only "Where BC Conversion Type (F9843) is equal to "4"".
Where I'm wrong?

Thanks

This report works a little oddly. To properly execute the R98404 you must insert into the F9843 table the names of the tables you wish to re-index.

insert into sys7334.F9843 values ('F0101',' ',' ',4,0,' ',' ',' ',0,' ',' ',' ',' ',' ',0,0,' ',0)
insert into sys7334.F9843 values ('F0911',' ',' ',4,0,' ',' ',' ',0,' ',' ',' ',' ',' ',0,0,' ',0)


Oh, make sure you run the R98404 locally.



[ QUOTE ]
I've tried to execute R98404, but when I run XJDE0001 version system says to me that there are no data selection. Probably I must change something into data selection?

Thanks

[/ QUOTE ]

Luca,

There are 2 other reports also that can be used to re-generate indexes. Have a look at these 2 reports. I Used them in 8.10. Not sure from which release onward they are available

R9698712 - to create all Primary Keys
R9698713 - Index Recreation

I have used the R9698713...it works fine....it would build indexes based on the information available in the Central Objects table..F98713 If i remember correctly...and for ERP 8.0 and below JDE doesnt ship an OCM mappings for F98713, so you should point that to the CO datasource. Also add F98710, F98711 and F98712.

Thanks to all!

I've tried with R9698712 and R9698713, and I've seen great improvements.
I'm working with BSFN B9800200 too.