If the write server of a multiplex fails in such a way that its SYSTEM dbspace and transaction log files cannot be recovered, you can use forced recovery and the sp_iqcheckdb option resetclocks as part of the process to convert one of the query servers to a write server. For the complete server conversion procedure, see the section “Replacing write servers” in Chapter 14, “Data Backup, Recovery, and Archiving” of the Sybase IQ System Administration Guide.
