Manually Creating the Database Schema
If you choose not to load data using the installer, you must manually load it after the installer installs your solution using the instructions in the section
Database Initializing and Data Loading. However, in certain scenarios additional steps are needed to complete your installation. These scenarios are;
• You choose to not automatically create schema and load data when installing using the installer.
• You choose to not automatically create schema and load data when adding to an existing Servigistics InService installation, using the installer.
• You choose to skip loading base data using installer.
Loading e3c Schema
1. Open a Windchill shell by executing one of the following commands from a command shell:
On UNIX/Linux:
<WT_HOME>/bin/windchill --java=<JAVA_HOME>/bin/java shell
On Windows:
<WT_HOME>/bin/windchill.bat --java=<JAVA_HOME>\bin\java.exe shell
2. Load the database schema of Servigistics InService by executing the following command:
<swDir>/utilities/ant/bin/ant -v -f <swDir>/utilities/create3cSchema.xml
-DswDir=<swDir> -Dhostname=<dbhost> -Dport=<dbport> -Dtype=<database Type>
-Dvendor=<database Vendor> -Dsid=<dbname>
-DdbName=<dbname>-Duser_CMIDB=<cmi_username> -Duser_3CDB=<e3c_username>
-Duser_CMIDB=<cmi_username> -Duser_E3CDB=<e3c_username>
-Duser_TitanDB2=<titandb2_username>
-Duser_TitanDB=<titandb_username> -Dpassword_CMIDB=<cmi_password>
-Dpassword_E3CDB=<e3c_password>
-Dpassword_TitanDB2=<titandb2_password> -Dpassword_TitanDB=<titandb_password>
where, <swDir> = Location of the software directory<dbhost> = Database hostname as entered in the installer during install<dbport> = Database port as entered in the installer during install<database Type> = Type of the installed database, for example, Oracle, SQL, or PostgreSQL<database Vendor> = Vendor of the database, for example, Oracle, Microsoft, or PostgreSQL<dbname> = Global Database Name (SID) or Service Name as enetered in the installer during install<cmi_username> = CMI schema user name as entered in the installer during install<e3c_username> = E3C schema user name as entered in the installer during install<titandb2_username> = TitanDB2 schema user name as entered in the installer during install
Examples of databases:
• Oracle:
/data/ptcG800/InService/InS_SW/SW/utilities/ant/bin/ant -v -f
/data/ptcG800/InService/InS_SW/SW/utilities/create3cSchema.xml
-DswDir=/data/ptcG800/InService/InS_SW/SW
-Dhostname=hrz-slmorcl12 -Dport=1521
-Dtype=thin -Dvendor=oracle
-Dsid=orcl12.ptcnet.ptc.com
-DdbName=orcl12.ptcnet.ptc.com
-Duser_CMIDB=TESTXCMI -Duser_E3CDB=TESTXE3C
-Duser_TitanDB2=TESTXT2 -Duser_TitanDB=TESTXT1
-Dpassword_CMIDB=TESTXCMI
-Dpassword_E3CDB=TESTXE3C
-Dpassword_TitanDB2=TESTXT2
-Dpassword_TitanDB=TESTXT1
• SQL Server:
D:\ptcG656\InService\InS_SW\SW\utilities\ant\bin\ant -v -f
D:\ptcG656\InService\InS_SW\SW\utilities\create3cSchema.xml
-DswDir=D:\ptcG656\InService\InS_SW\SW -Dhostname=PAWSSV-SLM04T.ptcnet.ptc.com
-Dport=1433
-Dtype=sqlserver
-Dvendor=microsoft
-Dsid=testdb
-DdbName=testdb
-Duser_CMIDB=TESTXCMI
-Duser_E3CDB=TESTXE3C
-Duser_TitanDB2=TESTXT2
-Duser_TitanDB=TESTXT1
-Dpassword_CMIDB=TESTXCMI
-Dpassword_E3CDB=TESTXE3C
-Dpassword_TitanDB2=TESTXT2
-Dpassword_TitanDB=TESTXT1
• PostgreSQL:
D:\ptcG761\InService\InS_SW\SW\utilities\ant\bin\ant -v -f
D:\ptcG761\InService\InS_SW\SW\utilities\create3cSchema.xml
-DswDir=D:\ptcG761\InService\InS_SW\SW
-Dhostname=pawssv-pgs01w.ptcnet.ptc.com
-Dport=5432
-Dtype=postgresql
-Dvendor=postgresql
-Dsid=postgres
-DdbName=postgres
-Duser_CMIDB=ptc_pub01w761_cmi
-Duser_E3CDB=ptc_pub01w761_e3c
-Duser_TitanDB2=ptc_pub01w761_titan
-Duser_TitanDB=ptc_pub01w761_titan
-Dpassword_CMIDB=ptc_pub01w761_cmi
-Dpassword_E3CDB=ptc_pub01w761_e3c
-Dpassword_TitanDB2=ptc_pub01w761_titan2
-Dpassword_TitanDB=ptc_pub01w761_titan