User's Manual

Agile 9.2.2.1
Defining the peupgrade.properties Parameters
Parameter Value Definition
pe.jdbc.url The JDBC connection string to the Program Execution database. The format is
jdbc:oracle:thin@
<SOURCE_DB_HOST_NAME>:<PORT>:<SID> where
SOURCE_DB_HOST_NAME is the hostname of the Program Execution database, PORT is the
listener port of the database (1521 is the default), and
SID is the database instance.
pe.jdbc.driver The database driver of the Program Execution database. The default is
oracle.jdbc.driver.OracleDriver.
pe.db.user The database user of the Program Execution database.
pe.db.password The encrypted database password of the Program Execution database. Use the encryptpwd utility
located in the $AUT_HOME\bin directory to encrypt the password.
pe.tns.name The TNS entry name in the Oracle Home of the Program Execution database.
pe.oracle.home The Oracle Home of the Program Execution database.
Note Use either double back slashes or a forward slash for
directory separation, for example, d:/oracle/ora92.
create.del.subclass If set to true, the Deliverables subclass will be created after upgrade for data currently in that
subclass. If set to false (default, the data currently in the Deliverables subclass will be migrated to
the Tasks subclass after upgrade.
generate.pe.reports If set to true, a report on any circular dependencies in the data is generated and no data is
migrated. If set to false, no report is generated and the data is migrated.
If you choose to have a report generated, AUT will stop. After viewing the report and correcting the
dependencies, change this parameter to false and run AUT again.
report.folder.location Location where you want the report to be generated.
pe.weekend.days Comma-separated numbers representing the weekend days in a week. The default days are
Saturday and Sunday. Format: 1,7
currency.description Base currency. The default is US Dollars (USD).
iFS Details*
copy.files If set to true, the file attachments are copied.
src.ifs.folder The mapped drive location of the local iFS files folder.
src.ifs.schema The database user of the Program Execution database.
dest.ifs.folder The path where the upgraded file vault will be located.
dest.ifs.schema The database user of the destination database.
*After the database is upgraded, you will need to run the IFS Reorganization tool to restructure the file vault
to match the current format. For more information on this tool, see the Installation Guide.
Page - 18 Database Upgrade Guide