Preparing to run the non-DBA database scripts

Applies to:

Edit the sql-wrapper.sql file to specify the values for your environment.

This procedure is optional. Instead of running scripts, you can complete the database setup when you install OpenPages®.

About this task

The sql-wrapper.sql file contains information that is used by the database scripts. You need to enter the values for your environment, such as the name of the database instance for OpenPages.

When you install OpenPages, use the same values that you set in the sql-wrapper.sql file.

Procedure

Log on to the Db2® database server computer as the Db2 database administrator (DBA).
Go to the /OP_<version>_Main/OP_<version>_Configuration/Database/DB2/INSTALL_SCRIPTS directory.
Verify that you have write permission on the sql-wrapper.sql file. If not, change the permission on the file by using the chmod command.

Edit the sql-wrapper.sql file to ensure that the variables are set correctly for your environment.

Edit the following parameters, if needed:

Table 1. Parameters in the sql-wrapper.sql file for Db2 databases
Property	Description
`opx_db2_instance_owner`	The database instance owner for OpenPages.
`opx_db2_server_name`	The database server name
`opx_db2_port_number`	The database port number, for example `50000`
`opx_db2_db_name`	The name of the OpenPages database.
`opx_db_owner`	The schema owner of the OpenPages database.
`opx_dflt_stor_srv_root`	The path to the OpenPages storage directory. Example: `define opx_dflt_stor_srv_root='/home/opuser/OP/OpenPages/openpages-storage'`
`opx_op_admin_name`	The OpenPages administrator user name
`opx_op_admin_pwd`	The OpenPages administrator password
`opx_base_currency_iso_code`	The base currency For example, if you use Euros as your base currency, change the default ISO currency code from `USD` to `EUR`. `define opx_base_currency_iso_code='EUR'`

If you want to load custom data during the database setup process, see Loading custom data (Db2 and Oracle).