Dbspaces (IQ)

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 allows you to allocate tables and tables partitions, columns and column partitions, indexes, join indexes, keys, and references to specific dbspaces from each object's property sheet.

Creating a Dbspace

PowerDesigner models dbspaces as tablespaces with additional properties. You can create a dbspace in any of the following ways:

Select Model > Tablespaces to access the List of Tablespaces, and click the Add a Row tool.
Right-click the model (or a package) in the Browser, and select New > Tablespace.

Dbspace Properties

PowerDesigner models dbspaces as tablespaces (see Tablespaces and Storages (PDM)) with the following additional properties on the General tab (v15.0 and higher):

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: CatalogStoreDisplay
File path	Specifies a physical file path for the dbspace. Scripting name: As
Online	Specifies that the dbspace is online. Scripting name: Online
Read-only	Specifies that the online dbspace is read-only. Scripting name: ReadOnly
Striping	Specifies that the dbspace is available for striping. Scripting name: Striping
Stripe size (in kb)	Specifies the size of the stripes. Scripting name: Stripesizekb

In addition, the following tabs are available:

Cost - allows you to specify the cost per GB of storage for the dbspace (see Tablespace and Storage Properties).
DBFiles - lists the dbfiles associated with the dbspace.

DBSpace Files

PowerDesigner models dbspace files as extended objects with a stereotype of <<DBSpaceFile>> with the following additional properties on the General tab (v15.0 and higher):

Property	Description
Path	Specifies the file path to the dbspace file. Scripting name: FilePath
Read-only	Specifies that the resource is read-only. Scripting name: ReadOnly
Size	Specifies that the size of the dbspace file. Scripting name: Size, SizeUnit
Reserve	Specifies the size of space to reserve, so that the dbspace can be increased in size in the future. Scripting name: Reserve, ReserveUnit