Checks multiplex configuration for inconsistencies.
call dbo.sp_iqmpxvalidate( ‘show_msgs’ )
DBA authority required. Users without DBA authority must be granted EXECUTE permission to run the stored procedure.
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.
