Enable SSL for DB2 HADR Communication
Encrypt DB2 HADR Database Setup without Downtime
In blog DB2 Native Encryption, How to Encrypt DB2 Database, How to Encrypt DB2 Database using Centralized KeyStore we went through DB2 Native Encryption and understood step by step process to encrypt DB2 standalone database using both Local KeyStore and Centralized KeyStore. Encrypting DB2 standalone database involve downtime. In this blog we will go through step by step process to encrypt DB2 database in HADR setup without Downtime, before we proceed I would suggest to check above blogs to understand DB2 Native encryption and steps to configure it.
In this blog we will use 2 Local KeyStore, one for Primary and other for Standby. You can use shared Local KeyStore as well, by creating KeyStore on shared File System.
We will consider a 2 node HADR setup with below configuration:
Shared Folder Access in Oracle Virtual Box Linux VM
You might be in a situation in which you need a shared file system between multiple VM or between your VM and host OS on which you can perform both read and write operation simultaneously. Oracle Virtual Box has a answer to this in form of Shared Folder feature but to use Shared Folder feature in your VM, you must install Virtual Box Guest Additions. This simple looking Virtual Box Guest additions is quiet complicated to setup in Linux VM, it becomes even more complicated if you are not a Linux admin. In this blog we will go through step by step process to setup Virtual Box Guest Additions and Add a Shared Folder in VM and access it.
Step1: Prerequisite
To configure Virtual Box Guest Addition, you need to have kernel-devel, gcc, make and elfutils-libelf-devel package installed. Run below command to check if packages are already present.
yum list gcc make kernel-devel elfutils-libelf-devel
SQL1768N Unable to start HADR. Reason code = "5"
While initializing DB2 HADR you might receive error SQL1768N Unable to start HADR. Reason code = "5". There are multiple scenario in which you might receive SQL1768N Reason Code 5. In this blog we will go through scenarios in which you might get this error and solution to fix it. IBM documentation list below explanation for this error:
ChoudharySumit.com Completed 4 Months
Today 7th Jan 2021 ChoudharySumit.com completed 4 months since first blog was published. ChoudharySumit.com is extremely thankful and overwhelmed to share below statistics:
If you want to ask or inquire about something that is in your mind please do not hesitate to contact me
If you liked this blog and interested in knowing more about DB2, please subscribe by clicking on Subscribe to ChoudharySumit.com by Email.
Download IBM DB2
As part of your day to day activity as DB2 DBA, you might have come across requirement to install specify version of DB2, apply DB2 fix pack, install DB2 client on application servers or provide DB2 drivers to application team. In this blog we will go through step by step process to download DB2 LUW engine, db2 fix pack, db2 clients and drivers.
To download IBM DB2 LUW visit below URL
https://www.ibm.com/support/pages/download-db2-fix-packs-version-db2-linux-unix-and-windows
From this URL, you can check End of Support date for DB2 version and also download DB2 LUW products.