Sybase Central may fail executing a CREATE DBSPACE command on a query server, causing the main dbspace count from a query server to differ from the count on the write server.
Trying to start the query server where the CREATE DBSPACE failed returns the error:
Query Server dbspace count differs from Write Server
In this case, executing sp_iqmpxvalidate on the write server returns a message like the following:
ERROR: Main dbspace counts for server UXIQIP393, write server mismatch in SYS.SYSIQFILE
CREATE DBSPACE may also fail on a query server if the file system permissions for a shared raw disk device are wrong at the query server, or if the pathname does not resolve to the same device where the write server created the dbspace.
The following actions resolve the problem:
Use Sybase Central to drop the query server and add it to the multiplex again, or
Use the stored procedure sp_iqmpxaliasdbspace on the write server interactively to create the necessary dbspace definitions for the query server, and then synchronize the query server.
Chapter 9, “System Procedures” in Sybase IQ Reference Manual
“Adding dbspaces” on page 219 in Sybase IQ System Administration Guide
