IBM DB2 Administration Guide: Installation, Upgrade and Configuration of IBM DB2 on RHEL 8, Windows 10 and IBM Cloud (English Edition)

By A S Bluck

IT professionals and software architects are overloaded with knowledge due to the rapid advancement of technology and the launch of new Cloud-based services. This book provides helpful instructions for installing and configuring IBM Database on multiple operating systems and enterprise platforms. The book's troubleshooting sections are designed to increase IT support productivity and speed up problem resolution.

Software Architects, Installation specialists, database developers, and IBM Document, Case, and Workflow management software developers can all benefit from this book. This book offers a centralised resource that discusses the most recent version of IBM software that readers can use on the most recent versions of Red Hat Linux and IBM Cloud platforms.

This book is intended to provide a thorough introduction that will allow an IT expert to understand the installation of a wide range of IBM Software products. It includes information on online references and step-by-step processes for installing a wide range of IBM Software products.

• Language: English
• Publisher: BPB Online LLP
• Release date: Aug 9, 2022
• ISBN: 9789355511799

Book preview

CHAPTER 1

Getting Started with IBM Resources for DB2

Introduction

This chapter covers the Bill of Materials for the IBM Information Management Products to be installed, with the download site URLs, product codes, descriptions, and size and name of the download gzip tar files for each Software Download. It also describes the summary contents of each of the available IBM Redbook publications (if any) that supports the use of the IBM software products listed.

Structure

In this chapter, we will discuss the following topics:

Download location, estimated download time, and version

License requirements UVU PVU

Fix pack location and versions

End of life support

Compatibility matrix URLs

RedBook URL locations

ResearchGate publications

Compatibility issues and support limitations for the products listed

Supporting database, web application and operating system version limitations for the products

Component interactions with system architecture diagrams and performance issues

Upgrade paths and supported versions for the upgrade

Version End-of-life and roadmaps

Downloading the IBM eAssembly components for Linux

Product searching procedures,

Product code lists - identifying the correct downloads

IBM download director installation and use

License restrictions

IBM download and licensing jar files for DB2

License tool

IBM Installation Manager download options and procedure

RedHat Linux download and use of Subscription Manager

Use of ftp/sftp, VMware mapped folders, and ssh/scp for file copy

Objectives

After studying this chapter, you will be able to identify the version of DB2 required for support of a number of the leading IBM Software Application Systems, including the following:

IBM FileNet for Document Management and Storage

IBM Business Automation Workflow

IBM Case Management

IBM DB2 Graph and Jupyter Notebooks

1.1 Download location, estimated download time, and version

The IBM FileNet latest release, with the supporting DB2, has the dependencies and related IBM Software Products covered by the IBM Cloud Pak for Automation URL reference:

https://www.ibm.com/support/pages/ibm-cloud-pak-automation-v2002-download-document

The following table extracts list the Part Numbers for the DB2 packages that can be used.

For the Activation License Key and DB2 11.5 on Windows, for the IBM Business Automation Workflow V20.0.0.1 Multiplatform Multilingual eAssembly the part numbers are as shown in Table 1.1 below:

Table 1.1: Part Numbers for Windows Server and the General License

For Db2 11.5 on a VMware Linux server (on a Windows server host), use this:

Table 1.2: Part Number for the Linux Db2 11.5 software installation package

For the IBM Filenet Multiplatform V5.5.5 Multilingual eAssembly, use this:

Table 1.3: The Part Numbers for IBM FileNet V 5.5.5 compatible DB2 11.1 installation

The full screenshots for the step-by-step download of the DB2 10.5 base version (Part Number CIXV0ML) are covered on pages 107-108 of the document DB210.5InstallationonRHEL8.0_V1.docx, which can be downloaded from the URL, https://doi.org/10.13140/RG.2.2.10491.67369

(Titled, DB2 10.5 Installation on CENTOS 8.0 V1)

The URL https://www.ibm.com/support/pages/download-ibm-filenet-content-manager-version-555 lists all the components supported for the latest version of IBM FileNet Content Manager 5.5.5.

Search using the CJ7I9ML Part Number, as shown in the table:

IBM FileNet Content Platform Engine 5.5.5

Table 1.4: The Part Number and description displayed in the search results

Do this using the link https://www-356.ibm.com/partnerworld/partnertools/eorderweb/ordersw.do.

To log in, then scroll down and use Find By Part Number or Find by the search string, for example, IBM DB2 10.5 for IBM Filenet 5.5.5.

This finds the following:

Figure 1.1: The current main e-Assembly Part Number (CJ7J3ML) for IBM FileNet V 5.5.5

Searching for DB2 using the Ctrl / F key within the browse page of the list of software packages gives DB2, latest version 11.1; the recommended supporting version for this version of IBM Cloud Pak for Automation v20.0.2 Filenet 5.5.5:

Figure 1.2: The list of DB2 Software Packages required for IBM FileNet Version 5.5.5

In the preceding list, the estimated download time can be seen by clicking on the Download estimate link in Figure 1.2.

The preceding boxes can be ticked to select these packages for download. The IBM FileNet e-Assemblies can be navigated by clicking on the links as highlighted in Figure 1.3:

Figure 1.3: The eAssembly link can be selected to show the specific package options

For example, the top Linux option expands, using Open URL in a new tab to:

Figure 1.4: The four Linux eAssembly options for IBM Filenet 5.5.5 are displayed

Download director status is shown for all the packages selected:

Figure 1.5: The 5 selected software packages are downloaded for DB2 and IBM FileNet

The Details button shows the list of files downloaded:

Figure 1.6: The highlighted DB2 V 11.1 License and Linux packages are downloaded

Highlighted above is the DB2 11.1 version supporting the IBM Filenet V5.5.5 software. The DB2 Graph container support download procedures (using docker) can be found in the URL link page, as follows:

https://www.ibm.com/docs/en/db2/11.5?topic=graph-setting-up-db2

1.2 License requirements UVU PVU

The License Agreement details for DB2 can be found by clicking on the License Agreement link in the Software Catalog entry list, for example:

Figure 1.7: The license agreement details link for each of the DB2 packages

1.3 Fix Pack Location and versions

To download DB2 11.5 recommended fix packs, go to:

http://www.ibm.com/support/docview.wss?uid=swg21321001

Download Fix Packs (if required)

REF: https://www.ibm.com/support/pages/download-db2-fix-packs-version-db2-linux-unix-and-windows

For the current Fix Packs from IBM FixPack Central, follow this URL browse page:

https://www.ibm.com/support/fixcentral/swg/selectFixes?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/DB2&release=11.5.*&platform=Linux+64-bit,x86_64&function=all

1.4 End of Life support

The End of Life support is as shown in the following table (as defined in the URL link in section 1.3):

Table 1.5: The table of End of Life dates for DB2 versions

1.5 Compatibility matrix URLs

For IBM FileNet 5.2.0, 5.2.1, and 5.5.0 systems, you can dynamically generate up-to-date system requirement reports by using the IBM software product compatibility reports using the URL http://pic.dhe.ibm.com/infocenter/prodguid/v1r0/clarity/softwareReqsForProduct.html.

Enter the search string IBM FileNet Content Manager 5.5.5.

Then, select version 5.5.5 from the dropdown (for compatibility with IBM Cloud Pak for Automation V20.0.0.1). Note that there are later versions, currently up to 5.5.8 for standalone versions of IBM FileNet Content Manager.

Figure 1.8: The main version selections for the compatibility matrix report search

Select a subset of the Compatibility options (as required). We selected the Linux Operating system only, and the following server components:

Configuration Manager

Content Platform Engine

Content Platform Engine Bulk Import Tool

FileNet Deployment Manager

Thick Client Process Designer

For the Containers, we selected just two of the options:

Content Platform Engine Container

Content Services GraphQL

For the capabilities section, we selected Databases and Java SDK. And for the final All Supported services, we selected:

Runtime Environment

Reporting and Analysis

Content Sources

Accessibility

Then, just click on the Submit command button to generate an example Compatibility Matrix report. The Operating system tab shows that RedHat Linux 8.0 base is supported. Also, there is a link to the list of Linux additional library packages that are required (https://www.ibm.com/support/pages/node/713759)

The pre-requisites tab of the Compatibility Matrix report has a table showing that most releases of DB2 from 10.5 onwards are compatible with IBM FileNet Content Manager 5.5.5 (Though it should be noted that the EOL on the DB2 version may mean some of the DB2 version components won't be fully supported!)

Table 1.6: The list of supported DB2 versions from the Compatibility Matrix report

1.6 RedBook URL locations

There is a Free Download of this Red Book covering DB2 10.1 (note that this is an early version, no longer supported by IBM):

http://www.redbooks.ibm.com/abstracts/sg248032.html?Open

Unleashing DB2 10 for Linux, UNIX, and Windows (August 2012)

ISBN 0738437107

This book is 10 years old and designed to illustrate examples of DB2 features, such as security, adaptive data compression, and the advantages of STT (system-period temporal tables) and BTT (Bitemporal temporal table) example designs.

It also covers the parallels with the Oracle Database system and comparative SQL structures and commands to enable migration to Db2. The version of DB2 at 10.1 is also very dated (2012) compared to the versions 10.5 through to 11.5 covered in this book.

1.7 ResearchGate publications

The list of our relevant DOI referenced publications on ResearchGate is as follows:

Audit System setup on an IBM DB2 11.5 Database on RedHat Linux RHEL 8.0 using the Go Language (https://doi.org/10.13140/RG.2.2.34136.93449)

Upgrade of IBM FileNet systems from DB2 10.5 FP 10 to latest DB2 11.5 version on RedHat RHEL 8.0 (https://doi.org/10.13140/RG.2.2.29470.69441)

IBM BAW 18.0 Installation phase1 preprint with the install of IBM Workflow Center 8.6.1.19002 (https://doi.org/10.13140/RG.2.2.27345.89440)

DB2 10.5 Installation on CENTOS 8.0 V1 (https://doi.org/10.13140/RG.2.2.10491.67369)

IBM Cloud Private P8 Container CPIT Installation on RedHat Enterprise Linux 8.0 (https://doi.org/10.13140/RG.2.2.27358.18246)

The following table describes the relevant publications referencing DB2. The DOI URL to the ResearchGate publications always has a prefix of http://dx.doi.org/ to which is appended the first column suffix, for example http://dx.doi.org/10.13140/RG.2.2.34136.93449 for download of the Audit System setup:

Table 1.7: The ResearchGate publication list and relevant pages for DB2

1.8 Compatibility issues and support limitations for the products listed

See section 1.5 Compatibility Matrix URLs, for details, for IBM FileNet 5.2.0, 5.2.1, and 5.5.0 systems, you can dynamically generate up-to-date system requirement reports by using the IBM software product compatibility reports.

1.8.1 Supporting database, web application, and operating system version limitations for the products

The Content Search is sometimes required to be Case Insensitive; the following procedure can be followed to implement this. This procedure will allow search text entered to find and retrieve an IBM Content Manager Document using one of the document properties to match the required property held in the DB2 database, irrespective of how the Case of the text is held.

So, for example, if a document's Publisher property was searched using the text bpb publications, then this would still return all documents matching the text even if the actual Publisher property for the document on the Database was held as BPB Publications.

Support for DB2 10.5 LUW or later requires Content Platform Engine 5.2 FP2 or later.

To create an expression-based index for a class property, when force case-insensitive search is in effect, the steps are as follows.:

Connect to the object store database by using the appropriate DB2 database tool.

Run a command with the following syntax:

CREATE INDEX idx_name ON table_name(LOWER(column_name))

Where the table_name is the one that contains the column. For example, the table DocVersion is for documents, table Generic is for custom objects, and table Container is for folders.

And where column_name is the name of the property column. The name of the index, idx_name is created as shown in the following example:

CREATE INDEX lc_lname ON DocVersion(LOWER(lname))

Extended Row Size Support changes are described as follows, when using DB2 10.5 LUW with IBM FileNet Content Platform Engine. DB2 10.5 LUW extended row size support can now be used to support Content Platform Engine tables with the total sum of column allocation sizes exceeding 32KB. This support requires the IBM FileNet CPE 5.2 FP2 release or later.

DB2 10.5 LUW now supports an extended row size. This can allow properties to be created without exceeding the record length limit for the page size (32 KB) because column allocation sizes are no longer counted against the limit during column creation. If an updated or inserted value results in the sum of the bytes consumed across all columns exceeding the physical record length limit of the page size, a descriptor (24 bytes) to an off-row location is stored in the column instead of by DB2.

Extended row size is on by default for new DB2 10.5 LUW installations. For databases upgraded to DB2 10.5 LUW and later, from earlier releases of DB2, the following command can be used to enable extended row size support:

UPDATE DATABASE CONFIGURATION FOR dbName USING EXTENDED_ROW_SZ ENABLE

Support for DB2 10.5 LUW requires the IBM FileNet CPE 5.2 FP2 release or later. When a new FileNet Document, Folder, or Custom Object property is added to a class, the Content Platform Engine (CPE) server will determine if extended row size is enabled for the database. This requires SELECT privileges on a view, which is granted by default:

SELECT ON SYSIBMADM.DBCFG

If extended row size is enabled in DB2, even with table overflow enabled on an object store, no tables will be overflowed by the CPE when a property is added to a class. All columns will be added to the original table.

If extended row size is not enabled or the view permission has been revoked, systems will behave as before - rows are then limited to 32KB (when a column is created), and tables will overflow if enabled on an object store.

For systems that have existing overflow tables and have upgraded to DB2 10.5 and have enabled extended row size support, new columns will be added to the original table, not the overflow table. Only if the CPE determines that a property can reuse an existing column that is no longer used will new properties be associated with the overflow table.

1.8.2 Component interactions with system architecture diagrams and performance issues

The following URL describes the DB2 architecture and shows an overview diagram:

https://www.ibm.com/docs/en/db2/11.5?topic=architecture-db2-process-overview

The following URL provides an introduction to DB2 performance tuning: https://www.ibm.com/docs/en/db2/11.5?topic=fundamentals-performance-tuning#c0005414

A set of Db2 command line processor (CLP) scripts referenced as db2mon can be used to collect monitoring data for a specific period. This is covered in detail in the URL:

https://www.ibm.com/docs/en/db2/11.5?topic=tuning-collecting-reporting-performance-monitor-data

1.9 Upgrade paths and supported versions for upgrade

The following link is to a word document (UpgradeofIBMFileNetsystemsfromDB210.5FP10tolatestDB211.5versiononRedHatLinuxRHEL8.0.docx) that describes a detailed upgrade from DB2 10.5 to DB2 11.5

http://dx.doi.org/10.13140/RG.2.2.29470.69441

(See page 5, and Pages 8-27 and 34-77)

1.10 Version End-of-life and roadmap

The following link shows a full list of the DB2 Version End-of-life support:

http://www.ibm.com/support/docview.wss?uid=swg21321001

1.11 Downloading the IBM eAssembly components for Linux

IBM download procedures are covered in detail in the BPB book, Installation, and Configuration of IBM Watson Analytics and StoredIQ in Chapter 1, Getting Started With IBM Resources for Analytics, section 1.4 IBM Watson, sub-section 1.4.1.1 Downloads. (BPB Publications, ISBN 9390684498, 9789390684496).

The eAssembly component product codes for Linux are shown by first searching for the latest DB2 Linux database using the search string for DB2 V11.5 as follows, using the link:

https://www-356.ibm.com/partnerworld/partnertools/eorderweb/ordersw.do

The following search text, highlighted in figure, is entered:

Figure 1.9: The text entered in the Product name box dynamically populates the select list

Then, select IBM DB2 Advanced Edition V11.5 for IBM Cloud Pak for Data Db2 V11.5 Multiplatform Multilingual eAssembly, and then click on the + opener in the following browser page listing line:

Figure 1.10: The DB2 V11.5 software package eAssembly with the + opener

Then, select a Linux or Windows system (we selected as follows):

Figure 1.11: Download for file db2oltp-icp4d_11.5_linux_x86-64.tar.gz

For the file name and size, click on the View details link. The Data Server Manager server V2.1.5.3 for Linux is selected:

Figure 1.12: Download for file ibm-dsm-linux-x86_64.tgz

The Data Server Manager server V2.1.5.3 for Windows is selected:

Figure 1.13: Download for file ibm-dsm-win64.zip

The DB2 backup (trial version) is selected for download (product code CC1Q8ML):

Figure 1.14: Download for file DB2MB_LUW3.5_Linux_X86_Trial.tar.tar.gz

The DB2 recovery command line client for the Linux trial version is selected for download (product code CC1R1ML):

Figure 1.15: Download for file IBM_DB2_RE_EXP_LUW_CLC_V5.5.tar.tar.gz

The DB2 recovery command line client for the Windows trial version is selected for download (product code CC1R4ML):

Figure 1.16: Download for file IBM_DB2_RE_LUW_CLC_V5.5_WIN_T.zip

The DB2 Server Version 11.5 for Linux (product code CC1U0ML) is selected for download:

Figure 1.17: Download for file DB2_Svr_11.5_Linux_x86-64.tar.gz

The DB2 Server Version 11.5 for Windows (product code CC1U4ML) is selected for download:

Figure 1.18: Download for file DB2_Svr_11.5_Win_x86-64.zip

The supporting IBM SDK for Java Version 8 on Windows download is selected (product code CND15ML), and the Linux version download is selected (product code CND18ML):

Figure 1.19: Download for files sdk.repo.8030.java8.win.zip and sdk.repo.8030.java8.linux.zip, respectively

The DB2 Data Studio Client Version 4.1.3 for Windows (product code CNN7LML) and the Linux version (product code CNN7MML) is selected:

Figure 1.20: Download for files DATA_STUDIO_CLIENT_V4.1.3_FOR_WIN.zip and DATA_STUDIO_CLIENT_V4.1.3_FOR_LIN.tar.gz, respectively

The supporting software packages, IBM WebSphere Application Server V9.0 (product code CNXH6ML) and the IBM DB2 Advanced Edition VPC License activation option (product code CC1VRML) are selected:

Figure 1.21: Download for files WAS_V9.0_MPML.zip and DB2_DAE_Activation_11.5.zip, respectively

Click to agree to download:

Figure 1.22: Select I agree and then click on the Download now command button

You may get a pop-up window:

Figure 1.23: The pop-up window appears as shown; click on OK

Download and click on the file to launch the Download Director Java application:

Figure 1.24: The browser status bar on the left shows the file to open

The Java IBM Download Director application pop-up window is displayed:

Figure 1.25: The pop-up window shows the Run Command button to start the Downloads

Download Director DB2 11.5 Download List of files:

Figure 1.26: The Downloaded list of files is shown on clicking the Details command button

1.11.1 Product searching procedures

To search for the IBM Product details, start at the URL:

https://www.ibm.com/support/pages/downloading-ibm-db2-version-115-linux-unix-and-windows

This shows a step-by-step procedure and has a full list of all the product codes to use for searching in the IBM Software Catalog.

1.11.2 Product code lists - identifying the correct downloads

To download a trial version of a DB2 database installation package, go to

https://www.ibm.com/analytics/db2/trials

To download DB2 recommended fix packs, go to the following link to see the recommended Fix Packs:

http://www.ibm.com/support/docview.wss?uid=swg21321001

Currently these are:

DB2 Version 11.5 Mod 7 Fix Pack 0

DB2 Version 11.1 Mod 4 Fix Pack 6

DB2 Version 10.5 Fix Pack 11

Or for more details:

https://www.ibm.com/support/pages/download-db2-fix-packs-version-db2-linux-unix-and-windows

1.11.3 IBM Download Director installation and use

IBM download procedures are covered in detail in the BPB book, Installation, and Configuration of IBM Watson Analytics and StoredIQ in Chapter 1, Getting Started With IBM Resources for Analytics, section 1.4 IBM Watson, sub-section 1.4.1.1 Downloads. (BPB Publications, ISBN 9390684498, 9789390684496).

1.11.4 License restrictions

The licensing for DB2 is based on Processor Value Units (PVUs).

The URL is as follows with details on how to estimate the PVU usage:

https://www.ibm.com/software/passportadvantage/pvu_licensing_for_customers.html#fullsubcap

1.11.5 IBM download and licensing jar files for DB2

Unzip the License Activation file:

unzip DB2_ESE_PVU_Activation_11.5.zip

Figure 1.27: The License Activation file is unzipped before installing DB2

Then, run the installer:

[root@ECMUKDEMO6 server_dec]# ./db2_install

Read the license agreement file in the db2/license directory.

........................................................................

To accept those terms, enter yes. Otherwise, enter no to cancel the install process. [yes/no]

yes

Default directory for installation of products - /opt/ibm/db2/V11.5

........................................................................

Install into default directory (/opt/ibm/db2/V11.5) ? [yes/no]

yes

Specify one of the following keywords to install DB2 products.

SERVER

CONSV

CLIENT

RTCL

Enter help to redisplay product names.

Enter quit to exit.

........................................................................

SERVER

........................................................................

Do you want to install the DB2 pureScale Feature? [yes/no]

no

DB2 installation is being initialized.

Total number of tasks to be performed: 58

Total estimated time for all tasks to be performed: 2819 second(s)

Task #1 start

Description: Checking license agreement acceptance

Estimated time 1 second(s)

Task #1 end

1.11.6 License tools

To use the DB2 database, the user must have a valid license. The procedures for obtaining and applying DB2 license files are covered in this URL link:

https://www.ibm.com/docs/en/db2/11.5?topic=installation-db2-database-product-licensing-support

1.12 IBM Installation Manager download options and procedure

For the full screenshots, see pages 50 –60 of the downloadable document:

http://dx.doi.org/10.13140/RG.2.2.29470.69441

Entitled Upgrade of IBM FileNet systems from DB2 10.5 FP 10 to latest DB2 11.5 version on RedHat Linux RHEL 8.0 (this downloads the document UpgradeofIBMFileNetsystemsfromDB210.5FP10tolatestDB211.5versiononRedHatLinuxRHEL8.0.docx)

Unpack the installation zipped file,

DATA_STUDIO_CLIENT_V4.1.3_FOR_LIN.tar.gz

tar -zxvf DATA_STUDIO_CLIENT_V4.1.3_FOR_LIN.tar.gz

Launch the IBM Installation Manager installer:

./imLauncherLinux.sh

Select the options required.

Click on Install.

Click on Finish.

Data Studio 4.1.3 Client is now installed and accessible (note that Data Studio 4.1.2 client is also still available).

1.13 RedHat Linux download and use of Subscription Manager

This section is covered in the free download from the URL: https://doi.org/10.13140/RG.2.2.21708.16001 titled Case Manager 5.3.3 Installation on RHEL 8.0 with Content Navigator 3.0.6.

(NB above describes the installation of the base RHEL 8.0 Linux system on pages 7 to 38 of the downloaded document, CaseManagerInstallationonRHEL8.0_V3.docx)

For CentOS 8.x, the support is now only via CentOS stream unless a change to a different compatible Linux Distro is preferred.

The steps for this change are as follows:

Note: Remember to back up the whole system first! Shutdown any running services as far as possible:

Shut Down Watson:

[root@ecmukdemo20 bin]# ./engine-shutdown

Is it okay to shut down Engine? [y/N] y

2022/01/09 14:06:02 Engine is shutting down

2022/01/09 14:06:02 Attempting to shut down Engine nicely

2022/01/09 14:06:04 The embedded web server is stopping

2022/01/09 14:06:06 Engine has been shutdown

[root@ecmukdemo20 bin]# pwd

/opt/ibm/WEX/Engine/bin

[root@ecmukdemo20 bin] # su - esadmin

[esadmin@ecmukdemo20 bin]$ esadmin system stopall

Etc…

FFQC5397W All of the required system services were stopped.

Start the conversion of CentOS 8.0 to CentOS Stream:

Run the dnf command to update the packages on CentOS 8

(Run as root on my system):

dnf update

Note that you get an error similar to the following output:

Error:

Problem: package docker-ce-3:20.10.12-3.el7.x86_64 requires containerd.io >= 1.4.1, but none of the providers can be installed

- cannot install the best update candidate for package docker-ce-18.06.3.ce-3.el7.x86_64

- package containerd.io-1.4.10-3.1.el7.x86_64 is excluded

- package containerd.io-1.4.11-3.1.el7.x86_64 is excluded

Etc…

- package containerd.io-1.4.9-3.1.el7.x86_64 is excluded

(try to add '--skip-broken' to skip uninstallable packages or '--nobest' to use not only best candidate packages)

Then I tried with the following version:

dnf update --nobest

(Which completed OK on our system) Note this update needs a few additional confirmations and does update a large number of packages (2021 listed on my system, ecmukdemo20)

NOTE: If the following error is encountered attempting to use the above updates, for example using the command

yum update

CentOS-8 - AppStream 70 B/s | 38 B 00:00

Error: Failed to download metadata for repo 'AppStream': Cannot prepare internal mirrorlist: No URLs in mirrorlist

Then use the commands as follows:

cd /etc/yum.repos.d/

sed -i 's/mirrorlist/#mirrorlist/g' /etc/yum.repos.d/CentOS-*

sed -i 's|#baseurl=http://mirror.centos.org|baseurl=http://vault.centos.org|g' /etc/yum.repos.d/CentOS-*

yum update -y

The above commands :

Comment out all the mirrorlist lines for all the .repo files.

Change all occurrences of the base URL for the http://mirror.centos.org (which no longer exists on the internet) in the .repo files to the new base URL, http://vault.centos.org.

Then, reboot the Linux box using the shutdown command or the reboot command:

shutdown

(Then power up again)

Verify the release of CentOS 8 used:

more /etc/centos-release

[root@ecmukdemo20 ~]# more /etc/centos-release

CentOS Linux release 8.5.2111

Install the CentOS-Stream release file by typing the following commands

cd /etc/yum.repos.d/

sed -i 's/mirrorlist/#mirrorlist/g' /etc/yum.repos.d/CentOS-*

sed -i 's|#baseurl=http://mirror.centos.org|baseurl=http://vault.centos.org|g' /etc/yum.repos.d/CentOS-*

dnf in centos-release-stream

Gives

[root@ecmukdemo20 ~]# dnf in centos-release-stream

CentOS Linux 8 - AppStream                      5.2 MB/s | 8.4 MB     00:01

CentOS Linux 8 - BaseOS                         3.1 MB/s | 4.6 MB     00:01

Extra Packages for Enterprise Linux Modular 8 - 916 kB/s | 979 kB     00:01

Dependencies resolved.

Etc

Installing:

centos-release-stream     x86_64     8.1-1.1911.0.7.el8   extras        11k

Etc…

Installed:

centos-release-stream-8.1-1.1911.0.7.el8.x86_64

Complete!

[root@ecmukdemo20 ~]#

Remove the CentOS 8 repo and replace it with the CentOS Stream repo:

dnf swap centos-linux-repos centos-stream-repos

Figure 1.28: The CentOS stream repo is ready to be swapped in

Installed:

centos-stream-release-8.6-1.el8.noarch   centos-stream-repos-8-3.el8.noarch

Removed:

centos-linux-repos-8-3.el8.noarch

Migrate CentOS 8 installation to CentOS stream. First, list repos by running:

dnf repolist

Upgrading CentOS 8 to CentOS Stream. Get the packages for CentOS Stream ABI/API. This will upgrade packages to match the new ABI/API:

dnf distro-sync --nobest

Reboot the system again. Run:

systemctl reboot

For verification, run this command:

cat /etc/centos-release

Figure 1.29: The CentOS 8.0 system is updated to CentOS Stream release 8

1.14 Use of ftp/sftp, VMware mapped folders, and ssh/scp for file copy

Installation of sftp used for Linux is described on pages 61 to 64 of the downloaded document, CaseManagerInstallationonRHEL8.0_V3.docx.

Conclusion

In this chapter, we covered the Bill of Materials for the DB2 software required for the related IBM Information Management Products to be installed, with the download site URLs, Product Codes, Descriptions, and size and name of the download gzip tar files for each Software Download. We also covered the update of a CentOS 8.0 system to CentOS Stream.

In the next chapter, we will cover the RedHat 8.0 .iso disk image installation, Windows 10 system installation and OpenShift 4 containers used for the products listed in this chapter.

Points to remember

Remember to back up the whole system before upgrading a CentOS 8.x system to a CentOS stream.

DB2 11.1 is the earliest fully supported Database version.

IBM announced Continuing Support for Db2 versions 8.2, 9.1, and 9.5 will be discontinued on September 30, 2022.

See https://www.ibm.com/support/pages/db2-continuing-support

The IBM Continuing Support offering does not include the following:

Voice and electronic access support for code-related problems

Development analysis of new defects

Development of or packaging fixes that are not already available

Support for bundled or included IBM programs (for example, Supporting programs or Other IBM Programs identified in the License Information for the Db2 program) and third-party components

Infrastructure that is not included in the software version's Hardware and Software Requirement page

Patching any database files for recovery purposes

Note that Db2 versions that are past their EOS date may contain defects, errors, or security vulnerabilities that will not be fixed as part of Continuing Support.

End of Support dates for Db2 LUW are here: https://www.ibm.com/support/pages/node/578841

There are later IBM FileNet Content Manager versions than those covered in this chapter (Higher than Version 5.5.5 for IBM Cloud Pak for Automation V20.0.0.1) currently up to 5.5.8 for standalone versions of IBM FileNet Content Manager.

The policy files can be downloaded for an IBM JRE from the following ZIP file:

https://public.dhe.ibm.com/ibmdl/export/pub/systems/cloud/runtimes/java/security/jce_policy/

Multiple choice questions

What is the earliest DB2 version fully supported by IBM (as of January 2022)?

DB2 10.5

DB2 11.1

DB2 11.5

DB2 9.5

What does EOS mean with regard to DB2?

The date DB2 stops working

The last date on which you are entitled to base support from IBM

End of IBM extended support

Withdrawal of IBM Continuing Support

What does PVU stand for?

Processor Validation Units

Publicly Verified Users

Processor Value Units

Processor Value Usage

What Linux command would you use to install IBM Installation Manager?

./imLauncherLinux.sh

./db2_install

dnf update

dnf in centos-release-stream

Answers

b

b

c

a

Questions

How much disk space would you provision for the downloads recommended in this chapter? (Hint: There are 21 files referenced).

What website could you browse to view any IBM software compatibility issues and limitations for products that are using Db2 as the database?

Where would you find the IBM JRE's unlimited jurisdiction policy files, and where would you place them?

Describe the use of the DB2 extended row size feature.

Key terms

User Value Unit (UVU) and Processor Value Unit (PVU) for licensing most IBM Software Products. Covered in detail in the link:

https://www.ibm.com/software/passportadvantage/about_software_licensing.html.

Red Hat Enterprise Linux (RHEL) operating system a derivative of Open-Source Linux

Structured Query Language (SQL): The commands that are used to manage the querying, creation, deletion, and modification of rows of data in a relational database such as DB2.

Java Runtime Environment (JRE): A software layer that runs on top of a computer's operating system software to support Java.

Uniform Resource Locator (URL): The web link address to a specific browser page on the internet.