1.01 Domain Level Queries

1.1 Check Master Domain Election of Node (on Multi Node Setup)

				
					Select * from ISP_MASTER_ELECT_LOCK
				
			

1.2 Check Master Selection of Host, Node and Port Details (Domain tables)

				
					Select * from ISP_MASTER_ELECTION
				
			

1.3  Repository Information

				
					SELECT PCSF_DOMAIN AS DOMAIN, REPOSITORY_NAME, DB_USER FROM OPB_REPOSIT_INFO
				
			

1.4 List Service Names, Grid, License Name and Service Type (Domain tables)

				
					SELECT
PSD_DISCRIMINATOR AS SERVICE_TYPE,
POS_NAME AS SERVICE_NAME,
POD_GRIDNAME AS GRIDNAME,
POD_LICENSENAME AS LICENSENAME,
POD_SERVICETYPE AS SERVICETYPE,
POD_SERVICEVERSION AS
SERVICEVERSION
FROM PO_DOMAINOBJ
ORDER BY 1,2