Role upgrade_ibm_db2_client 

The client software for IBM Db2 for LUW is needed to access a remote Db2 database from an SAP Application Server running on IBM AIX. It can be downloaded from the Software Distribution Center in the SAP Support Portal (SWDC) as a zip file or as ISO image (DVD).

For preventive maintenance, it is advised to upgrade the IBM Db2 client from time to time with the latest version. The role upgrade_ibm_db2_client is used to upgrade an existing IBM Db2 client from a downloaded zip file or DVD. The role is not intended to install the IBM Db2 client on a system where it has not been installed previously. For details about the IBM Db2 client and dependencies with SAP software, check the SAP documentation, for example Upgrade to Db2 V11.5 Client.

To upgrade the IBM Db2 client software from a zip file, you must have downloaded the zip file into a directory <mount_DVD_Dir>. When you unzip the file, a directory with the name of the zip file will be created underneath <mount_DVD_Dir>. For example, the file 51055624.ZIP will be extracted into directory <mount_DVD_Dir>/51055624. Specify this directory as value for variable upgdb2_mount_dir.

To upgrade the IBM Db2 client software from an ISO image (DVD), you must have downloaded the DVD into a directory <mount_DVD_Dir>. Specify this directory as value for variable upgdb2_mount_dir.

Prior to the installation of the new client software, the role upgrade_ibm_db2_client is checking the validity of upgdb2_sid and the the existence of subdirectory DATA_UNITS/CLIENT in the directory specified by variable <upgdb2_mount_dir>. The next step depends on the value of variable upgdb2_java_only. If the value is "yes" (Java only system), only the JDBC driver will be updated with the command:

./db6_update_client.sh -j

For any other value of variable upgdb2_java_only, the complete client software will be updated with the command:

./db6_update_client.sh -u

For more information and the latest version of the db6_update_client scripts, see SAP Note 1365982.

Table of contents

Role upgrade_ibm_db2_client

Requirements 

This role is intended for the operating system IBM AIX. The target system must be enabled to execute Ansible playbooks. For details, see the prerequisites section in Ansible Content for IBM Power Systems - AIX with SAP Software.

Tags 

The following tag can be specified optionally. Omitting the tag or specifying tag -t all has the same effect.

Tag	Usage
`upgrade_ibm_db2_client`	The IBM Db2 Client will be updated

Variables 

Variable	Usage	Required
`upgdb2_sid`	SAPSID for user <upgdb2_sid>adm	Yes
`upgdb2_mount_dir`	Directory where the IBM Db2 client software is located	Yes
`upgdb2_java_only`	“yes”: Install the client for a JAVA only system. Other value: Install the client for an ABAP or dual stack system.	Yes

Defaults 

None.

Dependencies 

None.

Example Playbook 

The example playbook is used to update the IBM Db2 database client software for SAP system PD1 with a new version on several hosts. It is based on the assumption that a configuration file and an inventory file with contents similar to the configuration documentation exist in the current directory. The ISO image (DVD) for the database client software must have been downloaded from the SAP Software Distribution Center and stored in the directory /software/db2_client. The playbook is located in the current directory, named upgrade_ibm_db2_client.yml and has the following contents:

- name: Upgrade IBM Db2 Client
  hosts: ibmaix_servers
   vars:
   - upgdb2_sid: "PD1"
   - upgdb2_mount_dir: "/software/db2_client"
   - upgdb2_java_only: "no"
  roles:
   - role: <ansible_dir>/roles/upgrade_ibm_db2_client

To execute this playbook, enter the command:

ansible-playbook --verbose -t upgrade_ibm_db2_client upgrade_ibm_db2_client.yml