Configuring Database Instance Settings

Contents

You will use the database instance settings to specify information about your database, such as name, description, schema. You can also use them to set your P6 Progress Reporter URL and specify whether you want to use auto start services.

To set your database instance settings:

1. Open the P6 Administrator application.
2. In the Configurations tab, expand your configuration.
3. Expand Database/Instance[n].
   1. In the Name field, enter the name of this database instance.

      Notes:

      • This determines how the database instance name will appear on the P6 login page.
      • The name can be a maximum of 32 characters.
   2. In the Description field, enter a description of this database instance.

      Note: The description can be a maximum of 128 characters.

   3. In the Public Group ID field, enter the database group ID of the privileged user account that will access the database.

      The default is 1.

   4. In the User Name field, enter the name used to establish a connection to the database.

      The default is pubuser, but if you created a custom Public User name, you should use your custom name.

   5. In the Password field, enter the Public User password used to establish a connection to the database.
   6. In the Timesheet URL field, enter the URL for invoking the P6 Progress Reporter module.

      To verify that the URL entered for this setting is valid, right-click over the setting, then select ‘Test Connection.’

      Example format:

      http://server name:listen port/pr

      Notes:

      • Do not put a / at the end of the URL.
      • The URL might be case-sensitive, depending on your application server configuration.
      • P6 will use this URL to access P6 Progress Reporter. A P6 user can access it from the Enter Time link in the "My Activities" portlet.
   7. In the Auto Start Services field, choose true to automatically start all services for this database when the application server starts. When this is true, all job services with a Concurrent Threads setting greater than zero will start when the application server starts.

      Set to true if you will use the Summarize or Apply Actuals features in P6 Professional.

      If set to false, you must manually log into the application before the services will start.

      Note: If you set Auto Start Services to false, job services will not start until someone logs into the application for the first time.