Pool creation - Checking values in the database

Before you begin

Before creating pools, ensure data in the following database tables is correct:

dynamic domain manager: DWB.PPS_PRODUCT_PROPERTIES
master domain manager: mdl.OPR_OBJ_PROPERTIES

About this task

To check current values for the dynamic domain manager, run the following query on the database of the dynamic domain manager:

db2 "select PPS_PROPERTY_NAME,PPS_PROPERTY_VALUE from DWB.PPS_PRODUCT_PROPERTIES"

This example applies to Db2, but you can apply it to any supported database by using the appropriate syntax.

The expected values are as follows:

DomainManager.Workstation.Name [https://domainmanager.workstation.name/]: This is the workstation name of the new dynamic domain manager. Verify the current value is the expected one. You can obtain this value using the conman command line or from the MDL.WKS_WORKSTATIONS table on the master domain manager.
MasterDomainManager.HostName: This is the full qualified host name or the IP of the new master domain manager. Verify the current value is the expected one. You can obtain this value using the conman command line or from the MDL.WKS_WORKSTATIONS table on the master domain manager.
MasterDomainManager.Name [https://masterdomainmanager.name/]: This is the workstation name of the new master domain manager. Verify the current value is the expected one. You can obtain this value using the conman command line or from the MDL.WKS_WORKSTATIONS table on the master domain manager.
MasterDomainManager.URIs: This is the list of the master domain managers to be contacted by the dynamic domain manager The list must contain in the first position the new master domain manager and in second position the new backup master domain manager, for example https://wa-server.example.com:31116/JobManagerRESTWeb/JobScheduler/resource.
DomainManager.Workstation.Address: This is the full qualified host name or the IP address of the new dynamic domain manager.

To check current values for the master domain manager, run the following query on the database of the master domain manager:

db2 "select * from mdl.OPR_OBJ_PROPERTIES where OPR_OBJECT_TYPE='W'"

This example applies to Db2, but you can apply it to any supported database.

The relevant part is column OPR_VALUE. The format of the URI should be similar to the following example, containing the hostname or IP address of master domain manager and backup master domain manager.

https://wa-server.example.com:31116/JobManagerRESTWeb/JobScheduler 
[https://wa-server.example.com:31116/JobManagerRESTWeb/JobScheduler];
https://127.0.0.1:31116/JobManagerRESTWeb/JobScheduler 
[https://127.0.0.1:31116/JobManagerRESTWeb/JobScheduler]

Note: The whole address must be on a single line.