SYSIQFILE system table

CREATE TABLE SYS.SYSIQFILE (
	file_id	 SMALLINT NOT NULL,
	start_block rowid NOT NULL,
	block_count rowid NOT NULL,
	create_time TIMESTAMP NOT NULL,
	segment_type CHAR(8) NOT NULL,
	allocated CHAR(1) NOT NULL,
	server_name				CHAR(30) NOT NULL,
	file_name				CHAR(128) NOT NULL,
	data_offset				UNSIGNED INT NOT NULL,
	PRIMARY KEY ( file_id )
	UNIQUE ( server_name, file_name )
)

Every database consists of one or more operating system files. Each dbspace and IQ Message file is recorded in SYSIQFILE (corresponding to a same entry in SYSFILE).

For multiplex, each server has unique entries in SYSIQFILE for its dbspace files. The rows in SYSIQFILE for a multiplex write server are maintained just like those for a nonmultiplex server. You must update the SYSIQFILE table on each server in a multiplex environment once it is modified (through CREATE or DROP DBSPACE commands) on any server, so that the tables contain identical information.

The initial CREATE or DROP DBSPACE must occur on the server that writes to the file (the specific server for IQ Temporary dbspaces, the write server for IQ Main dbspaces). That entry must then also be added to SYSIQFILE on each of the other servers. Sybase Central procedures that create and drop dbspaces, including the procedure that adds a new query server to the multiplex, maintain this agreement.