sp_iqmpxvalidate Procedure

Checks multiplex configuration for inconsistencies.

Syntax

call dbo.sp_iqmpxvalidate( ‘show_msgs’ )

Applies to

Multiplex only.

Privileges

You must have EXECUTE privilege on the system procedure.

Remarks

Executes multiple checks on tables SYS.SYSIQDBFILE and other multiplex events and stored procedures. May run on any server. Returns a severity result to the caller; values are:

Value	Description
0	No errors detected
1	Dynamic state is not as expected.
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, 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.