Removes unneeded multiplex-related objects in the database.
dbo.sp_iqmpxmakeclean()
The sp_iqmpxmakeclean procedure removes the following unneeded multiplex-related objects in the database:
Extra rows in IQ_MPX_STATUS
Any dbspace with a non-empty server_name that is not a query server in IQ_MPX_INFO
CONNECT privilege for any user MpxRemoteUserNN that is not in IQ_MPX_INFO.
Any remote user with an address like '<write_server_home>/repDirs%' and any corresponding subscriptions.
Be careful using this procedure; it may have consequences you did not intend.