Checks multiplex configuration for inconsistencies.
call dbo.sp_iqmpxvalidate( ‘ show_msgs’ )
Multiple checks on tables SYS.SYSIQFILE and DBA.IQ_MPX_INFO, and SQL Remote configuration. May run on any server. Returns a result to the caller: severity. Values are:
Value |
Description |
|---|---|
0 |
No configuration errors |
1 |
Dynamic state is not as expected; for example, dbremote process not running |
2 |
Nonfatal configuration error; for example, multiplex operation impaired |
3 |
Fatal configuration problem; for example, one or more servers might not start |
If called interactively, the stored procedure also returns a table of the errors found, if any, unless the calling parameter is not 'Y'.
Each error indicates its severity. If there are no errors, the procedure returns “No errors detected”.
