If you have already installed and configured the Cloud Manager Orchestration Server, it is still possible to configure an audit database.
On the Orchestration Server host machine, use your favorite editor to edit the script /opt/novell/zenworks/zos/server/conf/audit_db_prep.sql:
Replace the ${DB_NAME} variable with the PostgreSQL database name (for example, zos_db).
Replace the ${DB_USER} variable with the PostgreSQL schema owner name (for example, zos).
Use the following commands to run the modified script as the PostgreSQL database administrator:
su - postgres
psql -f audit_db_prep.sql
Use the following command to log into PostgreSQL, using the database name and schema owner substituted in Step 1 above:
su - postgres
psql -d zos_db -U zos -f audit_db_def.sql
Confirm that the database username and password match the values used when creating the schema owner database user in Section 5.4, Creating an Orchestration Server User for the PostgreSQL Database. In this example, the username is zos and the password is zos.
Confirm that the database username and password match the values you replaced in the variables of the .sql script. In this example, the username is zos and the password is zos.
Click
.The
check box is selected; the Orchestration Server is connected to the database so that any queued data and subsequent job, user, and resource events are written there.