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 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:

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