Adding Dbfiles to Shared Dbspaces

Perform these steps in Interactive SQL or Sybase Central.

Prerequisites

When adding space to IQ_SHARED_TEMP, consider the distributed query processing workload. Dbspace commands on IQ_SHARED_TEMP require SPACE ADMIN authority.

Task

Connect to the coordinator.
Add the file. On the ADD FILE clause, specify either a full path to a raw device, or a soft link. These examples specify full paths:
Platform Syntax
UNIX
ALTER DBSPACE IQ_SHARED_TEMP ADD FILE mydbfilename '/dev/rdsk/c4t600A0B80005A7F5D0000024'
Windows
ALTER DBSPACE IQ_SHARED_TEMP ADD FILE mydbfilename '\\\\.\\PhysicalDrive2'
This example specifies a soft link on a UNIX system:
```
ALTER DBSPACE IQ_SHARED_TEMP ADD FILE mydbfilename
'store/userdb1'
```
You need not synchronize or restart any secondary servers.
Confirm that the file is visible to all secondary nodes:
```
sp_iqmpxfilestatus
```
Shared files on IQ_SYSTEM_MAIN and user main dbspaces are implicitly read-write. Dbfiles on IQ_SHARED_TEMP are created read-only. If the dbfile is on a shared temporary dbspace, alter the new file to read-write status:
```
ALTER DBSPACE IQ_SHARED_TEMP ALTER FILE mydbfilename
READWRITE
```

Platform	Syntax
UNIX	ALTER DBSPACE IQ_SHARED_TEMP ADD FILE mydbfilename '/dev/rdsk/c4t600A0B80005A7F5D0000024'
Windows	ALTER DBSPACE IQ_SHARED_TEMP ADD FILE mydbfilename '\\\\.\\PhysicalDrive2'

Next

If an error is returned regarding the file status issues from one or more nodes, run the sp_iqmpxfilestatus procedure to troubleshoot and correct problems. If you postpone correction, you can force read-write status on IQ_SHARED_TEMP dbfiles:

ALTER DBSPACE IQ_SHARED_TEMP ALTER FILE mydbfilename
FORCE READWRITE

Use of the FORCE READWRITE clause returns an error on IQ_SYSTEM_MAIN and user main dbfiles.

Never enter ALTER DBSPACE ADD FILE when connected using -iqro. ALTER DBSPACE ADD FILE returns the error Modifications not permitted for read-only database if the server is started with the -iqro option.