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.

Note: When removing DB2 for Linux, Windows, and UNIX, you must drop all the tables within the tablespaces you want to remove, then drop the tablespaces (which automatically removes the indexes).

Tip: The JD Edwards EnterpriseOne installer delivers sample scripts which you can use as examples of how to drop the databases. You should examine and edit these to suit your needs with the understanding that they have not been delivered 'ready to run '. You should pay attention to environment variables and arguments the scripts are expecting. Your DBA may prefer to drop the databases themselves instead of using scripts.Sample drop scripts are located in the DB2 for Linux, UNIX, and Windows database directory under the JD Edwards EnterpriseOne installation directory (E920):drop_db.sh (run signed on as instance owner)drop_db.batYou 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