Dropping DB2 for Linux, UNIX, and Windows Databases
This section lists the DB2 for Linux, Windows, and UNIX databases that must be manually dropped by a DBA. This is the list of databases that were created by the JD Edwards EnterpriseOne Platform Pack installation on your Enterprise or Database Server for your JD Edwards EnterpriseOne installation, or from a previous JD Edwards EnterpriseOne installation.
By design, these databases are not automatically removed by the JD Edwards EnterpriseOne uninstallation program. You should have a DBA for your RDBMS manually remove any unused databases listed in the table below.
drop_db.sh
(run signed on as instance
owner)drop_db.bat
You should also be aware that
when you run the JD Edwards EnterpriseOne uninstaller, the directory structure
containing sample drop scripts is deleted.DB2 for Linux, Windows, and UNIX Database Name (Alias) |
JD Edwards EnterpriseOne Component |
Schema |
Tablespace |
JD Edwards EnterpriseOne Purpose |
---|---|---|---|---|
OWSH910 (JDE920) |
Foundation |
SVM920 |
svm910i svm910l svm910t4k svm910t32k |
Server Map |
SY910 |
sy920i sy920l sy920t4k sy920t32k |
System |
||
OL910 |
ol920i ol920l ol920t4k ol920t32k |
Object Librarian |
||
DD910 |
dd920i dd920l dd920t4k dd920t32k |
Data Dictionary |
||
OWSH910 (JDE920) |
Development Object Specifications |
DV910 |
dv920i dv920l dv920t4k dv920t32k |
Central Objects and Versions |
CRP Object Specifications |
PY910 |
py920i py920l py920t4k py920t32k |
||
Production Object Specifications |
PD920 |
pd920i pd920l pd920t4k pd920t32k |
||
Pristine Object Specifications |
PS910 |
ps920i ps920l ps920t4k ps920t32k |
||
OW_PROD (JDE_PROD) |
Production Environment |
PRODCTL |
prodctli prodctll prodctlt4k prodctlt32k |
Production Control Tables |
PRODDTA |
proddtai proddtal proddtat4k proddtat32k |
Production Data |
||
OW_DEV (JDE_DEV) |
Development Environment |
TESTCTL |
testctli testctll testctlt4k testctlt32k |
Development Control Tables |
TESTDTA |
testdtai testdtal testdtat4k testdtat32k |
Development Data |
||
OW_PS910 (JDE_P920) |
Pristine Environment |
PS910CTL |
ps920ctli ps920ctll ps920ctlt4k ps920ctlt32k |
Pristine Control Tables |
PS920DTA |
ps920dtai ps920dtal ps920dtat4k ps920dtat32k |
Pristine Data |
||
OW_CRP (JDE_CRP) |
Prototype Environment |
CRPCTL |
crpctli crpctll crpctlt4k crpctlt32k |
CRP Control Tables |
CRPDTA |
crpdtai crpdtal crpdtat4k crpdtat32k |
CRP Data |