Ensure you:
Check | Item |
---|---|
| Reviewed the P6 Reporting Database for ODS Installation and Configuration Guide. |
| Set the JAVA_HOME and PATH definition. Note: The config.cmd(.sh) needs JAVA_HOME set in order to launch. For example, in Windows, set JAVA_HOME=C:\Program Files\Java\jre1.6.0_37 |
| Determine your date range for your data warehouse. Note: Determine your date range before running the installer. This date range will include spread data and the start date and rolling date range of your data warehouse. See the P6 Reporting Database for ODS Installation and Configuration Guide for more information.
|
| Determine a reasonable date range setting. Note: If you set a large data range this will result in a very large amount of spread data. A large amount of spread data requires more database space, more hard drive space for temp files, and increased run times. Consider your date range carefully. Spreads outside of the date range will combine into one bucket at the beginning and end of the date range. |
| Consider the available disk space when you set the Logging level. Note: If DEBUG is set, the logs can become large. Oracle recommends INFO for a logging level unless troubleshooting is an issue. |
| Set the Java Max Heap setting to at least 4 GB of memory. Allow for more memory, if available, for the Java process. Note: The default for the Maximum Java Heap Size (MB) parameter is 1,204MB. The minimum value is 512MB. The value assigned must be a multiple of 512MB. The Planning and Sizing Guide references 1 GB, but notes that 1 GB may be inadequate for many datasets and may cause failures in the ETLCalc process. Oracle recommends starting with a minimum of 4 GB of memory for the Java process. |
| Have the P6 EPPM privuser username/password information available. |
| Have the ODS instance and System username/password information available. |
| Determine which P6 EPPM users will be reporting users. Note: Reporting users will have a database user created for them. That means you must set the report_user_flag field to ‘Y’ on the USERS table in the P6 EPPM database for all those users who will become reporting users. |
| Set the Bulk Load files location for the ETL process to a location with a large amount of available disk space. Note: These files can become large depending on the size of the database. You need ranges from a few gigs to many tens of gigabytes of available space. |
| Set Oracle database user requirements for users and passwords when creating the Oracle odsuser. |
Related Topics |
Legal Notices
Copyright © 1999, 2014,
Oracle and/or its affiliates. All rights reserved.
Last Published Friday, January 31, 2014