Setting Up Your System › Setting Up Database Access › Utilizing Page Groups

Utilizing Page Groups

A page group is a physical database definition attribute set by the database administrator during database definition. The catalog and the target database can be in different page groups. Unless the Mixed Page Group feature of CA IDMS is activated, tables from mixed page groups cannot be accessed with a single request. Additionally, once a table from one page group has been accessed, a COMMIT command must be issued before a table from a different page group can be accessed.

To use data sources defining data from mixed page groups:

• Define a different data source and a different Accessible Tables View for each page group when the catalog contains definitions of tables from mixed page groups. Each Accessible Tables View should include tables from a single page group so that the end user cannot accidentally access mixed page groups after a table list function is performed.
• Use the Automatic Commit option when accessing tables in different page groups.

  Note: Automatic Commit is enabled by default, and can be disabled using an ODBC or JDBC function.

Mixed page groups are supported starting with CA IDMS r14.1, so these restrictions do not apply when the data source is on a 14.1 or later system and the Mixed Page Group Binds feature has been activated.

Note: For more information about using page groups, see the CA IDMS Database Administration Guide - Volume 1.