setupDatabase properties and arguments

The properties in the setupDatabase.properties file configure the behavior of several command-line scripts:

  • Deployment scripts
  • Schema migration scripts
  • DDL-generation scripts
  • User-defined function scripts

Many of these property settings can be overridden by command-line arguments at run time. The following tables include the property name and, when applicable, the associated script argument.

Database connection properties

Script argument Property Description
--driverJAR pega.jdbc.driver.jar

Path and file name of the JDBC driver.

IBM Db2 for z/OS requires the following JAR files: db2jcc4.jar and db2jcc_license_cisuz.jar

--driverClass pega.jdbc.driver.class Class of the JDBC driver
--dbType pega.database.type Database vendor type. Enter one of the following values:

IBM Db2 for Linux, UNIX, and Windows: udb

Microsoft SQL Server: mssql

Oracle: oracledate

PostgreSQL: postgres

IBM Db2 for z/OS: db2zos

--dbURL pega.jdbc.url The database JDBC URL.

For more information, see your deployment guide.

--dbUser pega.jdbc.username User name of the Deployment user.
--dbPassword pega.jdbc.password Password of the Deployment user. For encrypted passwords, leave this blank.
--adminPassword pega.admin.password For new installations only. The initial password for [email protected]. If you do not set this password before you install, the installation fails.
--connProperties jdbc.custom.connection.properties Optional: Semicolon-delimited list of custom JDBC properties for installations.

(for example: prop1=value;prop2=value;prop3=value)

--rulesSchema rules.schema.name In a single schema environment, sets rules schema and data schema.

In a split-schema configuration, sets the rules schema only.

--dataSchema data.schema.name For split-schema configurations only, sets the data schema name.
--customerDataSchema customerdata.schema.name An optional customer data schema separate from the default Pega data schema.
--tempDir user.temp.dir Optional: The location of the temp directory. Set this location to any accessible location.

For example, C:\TEMP.

  pega.zos.properties The full path and file name to the IBM Db2 for z/OS DB2SiteSpecific.properties file.

For information about the upgrade properties see your Upgrade Guide.