Structure of data in the database

Last Updated : Jun 28, 2024 |

CMS uses the Informix Dynamic Server (IDS) as a relational database. IDS manages CMS data in specific dbspaces.

Dbspace

A dbspace is a logical database that consists of one or more chunks. Dbspaces can exist across multiple disks. A CMS system contains the following dbspaces:

  • rootdbs

  • physdbs

  • logdbs

  • dbtemp

  • cmsdbs

    Important:

    Do not try to alter rootdbs, physdbs, logdbs, dbtemp, or cmsdbs.

Chunks

A chunk is a unit of disk space used to store database data that IDS manages. For CMS, each dbspace contains one chunk. The size of each chunk depends on the data requirement specification of CMS. The following figure shows an example of chunk sizing. IDS requires the rootdbs, physdb, and logdbs dbspaces, but these databases store minimal data. Dbspace dbtemp is larger and is used for temporary data space. Dbspace cmsdbs is the location that stores all CMS data and it contains the largest chunk of data.



Image shows how the cmsdbs is the largest portion of a chunk of data, followed by the dbtemp area