Sybase IQ distributes user data across multiple disks at the application level by representing each device as a dbspace. A dbspace can be an operating system file or a raw disk partition. Dbspaces can contain both user data and internal database structures used for startup, recovery, backup, and transaction management.
PowerDesigner models dbspaces as tablespaces (see Tablespaces and Storages (PDM)with the following additional properties on the General tab:
Property | Description |
---|---|
Catalog store |
Specifies that the dbspace is created for the catalog store and will contain a single dbfile. If you select this option, you must specify a path to the file. Scripting name: CatalogStore |
Online |
Specifies that the dbspace is online. Scripting name: Online |
Read-only |
Specifies that the dbspace is read-only. Scripting name: ReadOnly |
Striping |
Specifies that the dbspace is available for striping. You can specify the size of the stripes. Scripting name: Striping |