IB Issues

Same PUBSUB Domain Seen Mulitple Times on the Domain Status Page
We’ve configured to integration broker domains for our DB. One is running on host01, the other on host02. When I navigate to PeopleTools à Integration Broker -> Service Operations Monitor -> Administration->Domain Status page,
I should see only two Integration Broker Domains in the Domains section. Instead I am seeing 6. I’ve tried the following:
· Verified only the two IB application server domains have Pub/Sub services configured/running.
· Recycled all application server domains with cache cleared.
· Verified that no other application server domains are running up against the database.

Solution
The fact that duplicate rows were being entered into the tables update when Purge Domain Status push button is clicked, indicated that there was a problem with the keys/indexes on the tables. The key fields on the three tables involved are:PSAPMSGDOMSTAT - Machinename and appserver_path PSAPMSGDSPSTAT - DispatcherName , Machinename, appserver_pathPSAPMSGQUEUESET - DispatcherName , Machinename, appserver_path, dataseqno Since there are key fields, then there should be a key index for each of the tables. Using the SQL tool it was noted that none of the tables had the key index built.Without the indexes built duplicate rows were being inserted into the tables. Using Appdesigner create all indexes for these records

"Purge Domain Status" Fails to Remove all Domains
"Purge Domain Status" does not purge all domains from the domain status list. After hitting the refresh button, the secondary (new) domain comes back, but the domain is inactive. The expected behavior is that when "Purge Domain Status" is clicked, the primary (inactive) domain would disappear, and the secondary (new) domain would remain.

The following SQL can help to identify the invalid / incorrect data:
select * from PSAPMSGQUEUESET
select * from PSAPMSGDSPSTAT
select * from PSAPMSGDOMSTAT

delete the invalid rows which will resolve the issue
1) Clear the table manually using the following type of sql:
DELETE FROM PSAPMSGDSPSTAT WHERE MACHINENAME <>:1 OR (APPSERVER_PATH <>:2 AND MACHINENAME=:3)
DELETE FROM PSAPMSGDOMSTAT WHERE MACHINENAME <>:1 OR (APPSERVER_PATH <>:2 AND MACHINENAME=:3)
DELETE FROM PSAPMSGQUEUESET WHERE MACHINENAME <>:1 OR (APPSERVER_PATH <>:2 AND MACHINENAME=:3)
where MACHINENAME is the name of the machine of the appserver domain where the PIA request is handled.APPSERVER_PATH is the PS_SERVDIR of the appserver domain where the PIA request is handled.