sp_iqmpxvalidate procedure

Function

Checks multiplex configuration for inconsistencies.

Syntax

call dbo.sp_iqmpxvalidate( ‘show_msgs’ )

Permissions

DBA authority required. Users without DBA authority must be granted EXECUTE permission to run the stored procedure.

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.