"To start a Secondary node in single-node mode (-iqmpx_sn 1) the override switch (-iqmpx_ov 1) should be used %1"
| Item | Description |
|---|---|
|
SQLCode |
-1013114L |
|
Constant |
EMSG_MPX_SECONDARY_NEED_OV_START_SINGLE |
|
SQLState |
QNA50 |
|
ODBC 2 State |
ERROR |
|
ODBC 3 State |
ERROR |
|
Sybase Error Code |
22017 |
|
Severity Code |
|
|
Parameter 1 |
location of the exception |
Secondary servers are not allowed to start with -iqmpx_sn 1. As the use of -iqmpx_sn 1 makes the server the owner of the IQ database it should not be used unless coordinator restore and failover operations have failed. If it becomes necessary to re-establish ownership of the database by a secondary server you can start the secondary server with -iqmpx_sn 1 only with override (-iqmpx_ov 1)