Database properties

The database properties are defined only for library servers.

Procedure

  1. On the Database page, select the Database Engine.

    If you select Oracle, there are no other options that you can specify on the Database page. Click Next to continue configuring the instance.

  2. If you plan to use Tivoli® Storage Manager to maintain Db2® archived log files and backup image files, select the Use TSM for Db2 files option.
  3. Click Advanced Database Options.
    The Advanced Options dialog box appears.
  4. Configure the database options:
    • Db2:
      • Database Location

        Physically separating the database, the directories that contain the log files, and other system and application data improves performance and helps recovery.

      • Primary Log File Path
      • Archive Log Path (Or Archive Log TSM Option File, if you selected the Use TSM for Db2 files option on the Database page. The TSM for Db2 client options file is usually different from the client options file that is used to maintain application group data.)
      • Log File Size
      • Number of Primary Log Files
    • SQL Server:
      • Database Path

        Physically separating the database, the directories that contain the log files, and other system and application data improves performance and helps recovery.

      • Database Size
      • Transaction Log Path
      • Log File Size
      • Number of Log Files
  5. Click OK to close the Advanced Options dialog box and return to the Database page.
    If the Database Engine is Db2, optionally define Db2 File Systems. You can add one or more table space file systems to the list. After you create the instance, the first table space file system that you define holds control information and cannot be altered or removed. After you create the instance, you can always add more table space file systems to the list.

    Storing application group data in table space file systems is optional, but highly recommended. See your database management product documentation for more information about table spaces.

  6. Click Next to continue.