Preparing the files for your database administrator

Applies to: On premises

Your database administrator needs a set of scripts to create the database objects. You need to prepare the files and send them to your DBA with instructions on how to run the scripts.

Do this procedure if your organization's security policies require the separation of DBA and non-DBA tasks.

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

  1. Log on to the Db2® database server computer as a user with administrative privileges.
  2. Go to the /OP_<version>_Main/OP_<version>_Configuration/Database/DB2/INSTALL_SCRIPTS directory.
  3. 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.
  4. Edit the sql-wrapper.sql file.
    Restriction: Change only the parameters that are described in this step.

    These parameters are used by the scripts that your DBA will run.

    Table 1. Parameters in the sql-wrapper.sql file for Db2 databases
    Property Description
    opx_db2_instance_owner The database instance owner for OpenPages.
    The user that you specify must have the following authorities:
    • Releases prior to Db2 11.5.6: Both DBADM and SECADM authorities
    • Releases after Db2 11.5.7: DBADM, SECADM, and SYSADM authorities

      If you want to avoid the SYSADM requirement that was introduced in Db2 11.5.7, an alternative approach is to modify the DB2_ALTERNATE_AUTHZ_BEHAVIOUR registry variable to include the NOT_FENCED_ROUTINE_DBAUTH value. For more information, see the Db2 documentation.

    If your database administrator is going to run the DBA scripts for you, then you can leave this value empty when you run the non-DBA scripts.

    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
  5. If your database administrator is going to run the scripts that require DBA privileges, prepare the files for your database administrator.
    1. Go to the /OP_<version>_Main/OP_<version>_Configuration/Database/DB2/INSTALL_SCRIPTS directory.
    2. Open the op-dba-install-file-list.txt file.
    3. Send your DBA the sql-wrapper.sql file that you updated along with the files listed in the op-dba-install-file-list.txt file.
    4. Send your DBA the instructions to run the DBA scripts: Running the steps that require DBA privileges