Updating user dbspaces

Add a file to a user dbspace or add a new user dbspace. On the ADD FILE clause, specify either a full path to a raw device, or a soft link.

For example, this statement specifies a full path on a UNIX system:

ALTER DBSPACE mydbspace ADD FILE mydbfilename
'/dev/rdsk/c4t600A0B80005A7F5D0000024'

For example, this statement specifies a full path on a Windows system:

ALTER DBSPACE mydbspace ADD FILE mydbfilename
'\\\\.\\PhysicalDrive2'

For example, this statement specifies a soft link on a UNIX system:

ALTER DBSPACE mydbspace ADD FILE mydbfilename
'store/userdb1'

You do not need to synchronize or restart any secondary servers.