Remove Cross Reference Facility

[JMast]

All,

I have recently taken on CNC and DBA duties here. I noticed that the Cross Reference Facility was created in PD. I have the following questions:

1. Is there an advantage to having it in PD? I would think having it in PY or DV would be fine. This would reduce the size of JDE_PD7334. This benefits backups/restores, disk space and future upgrades of Production.

2. I can see from searching the List, that tables F980011 and F980021 are involved. Are there any other considerations when removing Cross Ref?

3. My plan is to drop these tables in SQL Server and then regenerate in JDE. Any suggestions?

Thanks for the help,

Jer

 

[klwong]

1) I suppose it depends on who is using the cross reference. If only the developers are using it (as is usually the case), then DV and/or PY should be fine. Personally, I usually only build it for DV.

2) Only those 2 tables.

3) You could just do a "truncate table."

 

[JMast]

Ken,

Yep, only the developers are using it.

Thanks for the confirmation.

Jer