Configuring an Existing Windchill SQL Server Database for use with SQL Server Always On
Complete the following steps to configure an existing Windchill SQL Server database for use with the SQL Server Always On configuration.
1. Stop Windchill.
2. Back up the existing Windchill database, and verify that the backup is valid.
|
|
PTC strongly recommends configuring the SQL Server Always On failover mode as automatic, with secondary replicas operating in synchronous availability mode to avoid any data inconsistencies immediately after a database failover. While assuring data consistency, this availability mode can negatively affect overall system performance.
|
4. Add the Windchill SQL Server database to the Always On availability group, and create an availability group listener.
5. From a Windchill shell, fun the following command to set the needed properties, replacing the variables with values appropriate for your system:
xconfmanager -s wt.pom.dbConnectionRetryCount=60 -t "db/db.properties"
xconfmanager -s wt.pom.jdbc.host="<Availability_Group_Listener_DNS_Name>:<Port_No>;DatabaseName=<Windchill_Database_Name>;MultiSubnetFailover=true" -t "db/db.properties"
xconfmanager -s wt.pom.jdbc.port="" -t "db/db.properties"
xconfmanager -s wt.pom.jdbc.service="" -t "db/db.properties"
xconfmanager –p
6. Start Windchill.
7. Verify that all Windchill functionality works as expected.
