sp_iqmpxvalidate Procedure

Checks multiplex configuration for inconsistencies.

Syntax

call dbo.sp_iqmpxvalidate( ‘show_msgs’ )

Applies to

Multiplex only.

Privileges

None.

Description

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.