IBM Support

[Db2] Install Db2 on Linux using X Window GUI Setup wizard from a remote Windows machine with VNC

Question & Answer


Question

At the manual page, Db2 Setup wizard, it says:
-----
The Db2 Setup wizard is a GUI installer available on Linux, UNIX, and Windows operating systems. The Db2 Setup wizard provides an easy-to-use interface for installing Db2 database products and executing initial setup and configuration tasks.
-----
Also, found another page, Plan your Db2 pureScale Feature installation (AIX), it says:
-----
Installing the Db2 pureScale Feature by using the Db2 Setup wizard requires an X Window System (X11) or Virtual network computing (VNC) session to display the graphical user interface (GUI).
-----
But we could not find out exact steps to install Db2 on RHEL by using graphical user interface (GUI) Setup wizard from a remote Windows machine.  Could you help?
 

Answer

Here is an example scenario for using two separated machines.  One is located in a factory or a cloud (virtual) environment as RHEL 8.4 server system and the other one is located in an office as Windows 10 machine.  If you follow steps, you can install Db2 on the RHEL by using Db2 Setup wizard GUI with Virtual network computing (VNC) method.  In this article, both machines need to connect the internet for download packages and Db2 products on the RHEL server, and VNC on the Windows machine.  In this article, the RHEL 8.4 server's IP address is 192.168.0.1.  The steps are verified on RHEL 8.4 and Db2 V11.5.6.0.  However, it can be used on AIX and other Linux or UNIX environments and Db2 versions by replacing equivalent tools or commands on that platform.  For more information about system requirements, see System requirements for IBM Db2 for Linux, UNIX, and Windows.
1. Configure the RHEL server system box.
1.1 Check current RHEL box is configured as graphical or not by running root user:
# systemctl get-default
  * It returns run level, one of:
"graphical.target": graphical multiuser system configuration
"multi-user.target": non-graphical multiuser system configuration
"rescure.target": rescue shell, single user configuration
"emergency.target": emergency shell
  * If you receive "graphical multiuser system configuration", you can go to step 2.   
  * If not, need to follow next steps for installing and configuring GUI.
  * In this article, '#' represents root user and '$' is for the instance owner command prompt.
1.2 Check current Installed Environment Groups and Available Environment Groups by running root user:
# dnf group list
  Example output:
Available Environment Groups:
   Server with GUI
   Server
   Workstation
   Custom Operating System
   Virtualization Host
Installed Environment Groups:
   Minimal Install
Installed Groups:
   Legacy UNIX Compatibility
   Container Management
   System Tools
   Development Tools
Available Groups:
   Java Browser
   Java Base
   Misc
     :
  * At "Installed Environment Groups" section, it says "Minimal Install" only.
     It means there is no GUI environment. If so, you need to install GUI packages by installing "Server with GUI" or "Workstation" at "Installed Environment Groups".  To install one of them, go to step 1.3.  
     If there is "Server with GUI" or "Workstation", you can go to step 1.4.
1.3 To install "Workstation" Environment group, run root user:
# dnf groupinstall "Workstation"
  * You must need to connect the internet to run the command. 
  * Look at installation messages carefully to install it and follow message if any.
    If you have any trouble, contact your system administrator.
  * If you want, select "Server with GUI" instead of "Workstation", see manual about differences.
1.4 Change default run level to graphical by running root user:
# systemctl set-default graphical
  Then, reboot the box to effect the changing:
# reboot
  When it back online, check current run level by root user:
# systemctl get-default
2. Install and configure VNC server at Linux.
2.1 Install VNC Server, TigerVNC at Linux by running root user:
# yum install tigervnc-server
  * You must need to connect the internet to run the command. 
  * Look at installation messages carefully to install it and follow message if any.
     If you have any trouble, you must contact your system administrator or Tiger VNC provider.
2.2 Check the version of the installed Tiger VNC server:
# yum list installed | grep tiger
  * At the time being, version is 1.11.0-6.el8.
2.3 Read Tiger VNC HOWTO.md and configure by root user:
# cat /usr/share/doc/tigervnc/HOWTO.md
  As described, add one line to the /etc/tigervnc/vncserver.users file:
  Example:
# vi /etc/tigervnc/vncserver.users
  Then, add one line:
:1=root
2.4 As described, save the config file:
  Example:
# mkdir /root/.vnc
# vi /root/.vnc/config
  Then, write two lines:
geometry=1600x900
session=gnome
2.5 Set password for VNC session by running root user:
# vncpasswd
  * Type the password two times and then type 'n' for view-only password.
2.6 Start VNC server by running root user:
# systemctl start vncserver@:1
  * If you reboot the Linux box, you need to manually start VNC server again.
 
3. Install and start to use X Window by using VNC session from the Windows 10 client machine.
3.1 Searching "UltraVNC" at the internet, download, and install it.
  At the time being, try UltraVNC_1_2_24_winX64.exe.
3.2 From Explorer, click right mouse button on "UltraVNC_1_2_24_winX64.exe" and select run as administrator to install.
3.3 From Windows menu -> click UltraVNC -> click UltraVNC Viewer (select "UltraVNC Viewer", no sub title)
3.4 At the "VNC Server name" field, type the server address and add trailing ':1'.
  Example:
192.168.0.1:1
  Then, click "Connect" (no additional option or setting).
3.5 When you are asked to enter password, enter the password that you set at step 1.8 by vncpasswd command -> click "Log On" ->
  Wait for 20 seconds at least since it takes some time for first-time connection about initialization works ->
  [Welcome] window -> it means GUI works fine at the RHEL server ->
           Click one of languages in the list for configuration -> click "Next" ->
  [Input] window -> select one of key boards -> click "Next" ->
  [Privacy] window -> select "ON" or "OFF" -> click "Next" ->
  [Online Account] window -> click "Skip" (if you do not need it) -> 
  [Ready] window -> click "Start to use Red Hat Enterprise Linux" to start ->
  [Getting Started] window -> click upper right of the window 'x' sign to close.
  * Even if you already have "Server with GUI" or "Workstation" but the "Welcome" window never opens, close all and follow all steps in this article to make sure all packages are installed.
  * We do not suggest that use any specific third-party VNC tools or commands.  This article is just for an example usage.
  * If you cannot start GUI, you must contact your system administrator or VNC support team for further help.
* All necessary actions for the Windows 10 client side are finished here.
4. Install Db2 on Linux box by using Db2 Setup Wizard with X Window VNC session from remote Windows 10 machine.
4.1 In the VNC session GNOME, continuing from step 2.5, open a browser, go to the URL, and download one of Db2 products from DB2 Fix Packs by version for DB2 for Linux, UNIX, and Windows.
       
  Example:
  Click V11.5.6.0, click Linux 64-bit,x86-64 on AMD64 and Intel EM645.  Then, click "DB2 Server Fix Pack" at "Servers" section to download v11.5.6_linuxx64_server_dec.tar.gz and saved at Linux box "/prod" directory.
  * If you want to open Japanese Db2 Setup Wizard, click language menu at the top of screen and select Japanese.
  * If you need to type ASCII instead of Japanese Kana, click language menu at the upper right of the screen, select "Input Mode" and then click "Direct Input".
4.2 At the upper left of the screen, click "Activities" and then click "Terminal" from menu to open a terminal window.  Then, decompress it by root user:
# cd /prod
# dd if=./v11.5.6_linuxx64_server_dec.tar.gz | gtar xvfz -
  Then, run db2setup by root user to start Db2 Setup Wizard:
# cd server_dec
# ./db2setup
  * Run "export LANG=ja_JP.utf8" before you execute db2setup to use Japanese language for installation.
  * If it does not work properly, you must go to the location of the RHEL server physically, and verify at the console whether it works fine or not.
     If Db2 Setup Wizard does not work at the Linux console, without any VNC session, contact Db2 technical support with a valid contact.
4.3 When your environment is good enough to start GUI, windows open as follows:
  [Welcome] window -> click "New Install" ->
  [Choose a Product] window -> select "DB2 Version 11.5.6.0 Server Editions" -> click "Next" ->
  [Configuration] window -> select "Typical" and check "I agree" (leave others as it is) -> click "Next" ->
  [Instance owner] window -> Enter password (leave others as it is) -> click "Next" ->
  [Fenced User] window -> Enter password (leave others as it is) -> click "Next" ->
  [Response File and Summary] window -> (leave options as it is) -> click "Finish" ->
  [Installing DB2 Server Edition] status window -> wait for some time ->
  [Setup complete] window -> click "Finish"
        
4.4 Optional. At the step 4.2 terminal, follow to verify Db2 server by the instance owner:
    
# su - db2inst1
$ db2level
$ db2sampl
$ db2 connect to sample ; db2 "select * from employee" ; db2 terminate
$ db2stop
$ exit
  * The instance db2inst1 is started already by db2setup.
  * Run "export LANG=ja_JP.utf8"  before you execute db2level to use Japanese language.
        
5. Stop root user VNC logon.
  If you want to stop root user VNC logon, remove all lines from /etc/tigervnc/vncserver.users file.
 

[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"ARM Category":[{"code":"a8m500000008PknAAE","label":"Install\/Migrate\/Upgrade"}],"ARM Case Number":"","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"}],"Version":"All Versions"}]

Document Information

Modified date:
07 October 2021

UID

ibm16496553