MAS DevOps Ansible Collection Ansible CLI
Home suite_db2_setup_for_facilities Role Variables Example Playbook License

suite_db2_setup_for_facilities¤

This role shouldn't need to exist, it should be part of the Facilities operator, but is not so we have to do it as a separate step in the install flow for now. The role will install DB2 with the required properties and perform some initial setup on the Db2 instance that is needed to prepare it for use with the Real estate and Facilities application.

The role will copy scripts into the Db2 pod and execute it inside the container, this script will perform a number of configuration changes to the database as well as configuring the tablespaces for Maximo Real estate and facilities because the operator is not yet able to do this itself.

Role Variables¤

db2_instance_name¤

The name of the db2 instance to execute the setup in.

  • Required
  • Environment Variable: DB2_INSTANCE_NAME
  • Default Value: None

db2_namespace¤

The namespace where the Db2 instance is running.

  • Optional
  • Environment Variable: DB2_NAMESPACE
  • Default Value: db2u

db2_username¤

The username that will be used to connect to the database specified by db2_dbname.

  • Optional
  • Environment Variable: None
  • Default Value: tridata

db2_dbname¤

The name of the database in the instance to connect to when executing the setup script.

  • Optional
  • Environment Variable: None
  • Default Value: BLUDB

db2_schema¤

The name of the Manage schema where the hack should be targeted in.

  • Optional
  • Environment Variable: None
  • Default Value: TRIDATA

db2_tablespace_data_size¤

The size of the tablespace data in the database.

  • Optional
  • Environment Variable: DB2_TABLESPACE_DATA_SIZE
  • Default Value: 5000 M

db2_tablespace_index_size¤

The size of the tablespace indexes in the database.

  • Optional
  • Environment Variable: DB2_TABLESPACE_INDEX_SIZE
  • Default Value: 5000 M

db2_config_version¤

Version of the enhanced DB2 parameters, currently support 1.0.0

  • Required
  • Environment Variable: DB2_CONFIG_VERSION
  • Default: 1.0.0

enforce_db2_config¤

Flag to indicate restart the DB2 instance or not, the enhanced DB2 parameters required restart DB2 instance, this will cause downtime, should execute during customer maintenance window or newly created DB2 instance if set to True

  • Required
  • Environment Variable: ENFORCE_DB2_CONFIG
  • Default: True

Example Playbook¤

- hosts: localhost
  any_errors_fatal: true
  vars:

    # Configuration for the Db2 cluster
    db2_namespace: db2u
    db2_instance_name: db2u-db01
    db2_dbname: BLUDB

  roles:
    - ibm.mas_devops.suite_db2_setup_for_facilities

License¤

EPL-2.0