Pre-installation for the Primavera Data Warehouse Database

Reviewed the Primavera Analytics Planning and Sizing Guide for sizing and spacing guidelines.

Have a tablespace called STAR_DAT1.

Have a tablespace called STAR_HST1.

Set the tablespace with Auto Extend On.

Set the tablespace extent management to Local.

Set the characterset to UTF8 or WE8MSWIN1252. Primavera Analytics also supports the AL32UTF8 characterset.

Set the characterset to the same characterset used in the P6 EPPM and/or Primavera Unifier database.

Set the Primavera Data Warehouse tablespace to at least the same size as the P6 EPPM and/or Primavera Unifier database.

Run the queries to validate database settings. See Appendix B: Database Scripts For Validations for details.

Set datafiles to autoextensible.

Set maxbytes to the OS's maximum, which is typically 32 GB with minimum 2 files. Use 3 to 5 files for larger systems.

Run the queries to validate the UNDO Tablespace settings. See Appendix B: Database Scripts For Validations for details.

Run the queries to validate the SGA settings on the database. See Appendix B: Database Scripts For Validations for details.

Note: Larger systems require 8 GB.

Run the queries to validate the Archive Log Mode on the database. See Appendix B: Database Scripts For Validations for details.

Note: This should be in NON archive log mode.

Run the following SQL to verify the tablespace:

select s.tablespace_name, f.file_name, f.maxbytes, f.autoextensible from dba_data_files f inner join dba_tablespaces s on s.tablespace_name = f.tablespace_name where s.tablespace_name like '%STAR%';

Have both block buffer and individual process memory available.

Setup the database instance using Dedicated Server (not Shared Server).

For the MEMORY_TARGET variable, let the database server manage its own memory.

Can connect JDBC and OCI on the Star server.

Note: You can test the connection with a sample Java application.

Decided whether there will be multiple data sources. The sizing requirements will apply for each individual data source included.

Verified that you are using one of the following database versions.

See the Tested Configurations document for information on supported databases.