JMast
Reputable Poster
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
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