Removing Custom Path Code PRS7333

Hi All,

We have a custom pathcode PRS7333. Now this pathcode is not used. We want to remove this pathcode from system.
The database size of this pathcode is 36 GB.

Complete Clean Up need to de done from Database Server, Enterprise Server and Deployment Server.

Since I am performing this activity at client side, I need suggestion from all of you Gurus.
I know lot of people have done this. If anyone have a document on same then please attach them.

Setup Information:
Windows NT 2000 Server – DS and ES
ES/Database on same box
Database : Oracle 8i

Hi,

Stop JDE services, then you got to remove :

a. Packages

a.1.Login to Deployment on DEP environment and delete
all packages belonging to PRS7333 pathcode.
a.2.On your ES, check that there's no PRS7333 packages
under \jdeedwardsoneworld\ddp\b7333\packages
a.3.On your DS, check that there's no PRS7333 packages
under \\deployment\b7333\prs7333\package

b.Pathcodes

b.1.Drop the folder \\deployment\b7333\prs7333
b.2 On the ES, drop the folder \jdedwardsoneworld\ddp\
b7333\prs7333
b.3.On your Fat clients and Citrix check that there are
no more \b7\prs7333 folders
b.4.Remove any JAS instance that points to PRS7333
b.5 Go to your DEP environment, GH9053, Environment
Master and drop PRS7333 entry
b.6 From DEP environment, goto GH9053, Pathcode Master
and drop PRS7333 entry
b.7 Drop any OCM entry pointing to PRS7333 environment
on both server and system.
b.8. Check that none of your server or client JDE.INI
point to PRS7333 pathcode or environment, if so make them
point somewhere else (PD7333, PY7333, etc).

c.OL Entries :
c.1 DELETE FROM OBJ7333.F9861 WHERE SIPATHCD='PRS7333'

d.Central Objects

Drop all PRS7333 tables (typically F98710 to F989999,
plus F983051, F98BLOB, F98305V, F9698710 and F9698712)

e.Data Sources
e.1 Remove Central Objects - PRS7333 and Versions - PRS7333
from both your Planner, System and Server Data Sources

Restart services and cross your fingers