IBM DB2 Advanced on Microsoft Azure

Microsoft Azure Installation and Support guide

1. Overview

This guide will provide step by step instructions how to start using the installed products on your Microsoft Azure instance.

This Virtual Machine image offer contains a ready-to-run IBM DB2 product at the selected version. In order to use this image, you need to launch it with your selected type, and log in via SSH to create and configure your database. 

Visit the IBM DB2 Advanced Edition pages on the Microsoft Azure Marketplace

2. Launching an instance

In order to launch IBM DB2, a few settings need to be configured on the Azure console as follows:

  1. Open new Azure Virtual Machine wizard;
  2. Select the DB2 Azure image based on your requirements from gallery;
  3. Choose VM name, size, Authentication user and credentials. The Standard DS2V2/General Purpose type or larger is recommended when running IBM DB2.  Basic DS1V2 is the minimal requirement, Larger instances may be required based on the number of resources required;
  4. Define cloud service DNS name, Regions and open endpoint ports.
Port 22 to connect via SSH (enabled by default), 
Ports 50000 to connect to default database,
Port 9090 to reach RapidDeploy web console (enabled by default), 
Port 20000 and 20100 to open for RapidDeploy Remote Agent (optional).

3. Initial login and setup

The IBM DB2 product is shipped with a base binary installation. On the first login to the instance, you will be placed into a console wizard, which will guide you through the process of configuring your installation. The following is an overview of the steps you will be guided through to get started with the installed products on the instance.
    1. Log onto the instance via SSH with your Azure user and credentials. Once the instance has started up (you can see it by having “Running” status in Azure console), you can connect to the instance via any SSH client. You can log in to your instance with provisioned Azure username and the credentials which can be based on password or certificate file.
    2. You should see the MidVision banner and then you are placed in a setup wizard.
      Welcome to                                                                                                                                             
      
       __  __ _     ___     ___     _                    ____ _                 _
      |  \/  (_) __| \ \   / (_)___(_) ___  _ __        / ___| | ___  _   _  __| |
      | |\/| | |/ _` |\ \ / /| / __| |/ _ \| '_ \ _____| |   | |/ _ \| | | |/ _` |
      | |  | | | (_| | \ V / | \__ \ | (_) | | | |_____| |___| | (_) | |_| | (_| |
      |_|  |_|_|\__,_|  \_/  |_|___/_|\___/|_| |_|      \____|_|\___/ \__,_|\__,_|
      
                                                             A MidVision Service
      
              * WebSite: https://www.midvisioncloud.com/ibm-websphere-on-amazon-web-services/
              * Support: http://support.midvision.com/redmine/projects/devtestcloud
              * Forum:   https://www.midvisioncloud.com/community      
      
      Please run 'sudo su - db2inst1' to start using provided services.
      
      Welcome, this is MidVisionCloud RapidDeploy and  IBM DB2 image first run configuration
      
      Note that you can rerun this configuration wizard again by executing /home/db2inst1/firstrunsetup.sh script
      
      Configuration steps
      1. Set RapidDeploy framework initial password
      2. Open ports on RHEL firewall
    3. Once the admin user is logged in, please log in as the ‘db2inst1’ user via the command ‘sudo su – db2inst1’.
    4. You are placed in a setup wizard.
    5. Set initial password for RapidDeploy user “mvadmin
    6. Choose which ports to open on Red Hat Linux firewall. You should open port 9090 for the RapidDeploy web console if required. You should open the required ports for default database, typically 50000.
    7. The wizard finishes with the following output:
      Configuration finished, you may now start using RapidDeploy services and other software. Web user interfaces are available on:
      DB2 sample database JDBC url: jdbc:db2://[publicip]:50000/SAMPLE (use db2inst1 user credentials)
      RapidDeploy: [publicip]:9090/MidVision
      
      Note that initially db2inst1 user password is empty. You are free to change it if necessary.
    8. You can test the connection to db2 SAMPLE database using following commands:
      [db2inst1@hostname ~]$ db2
      (c) Copyright IBM Corporation 1993,2007
      Command Line Processor for DB2 Client 11.1.3.3
      
      You can issue database manager commands and SQL statements from the command 
      prompt. For example:
          db2 => connect to sample
          db2 => bind sample.bnd
      
      For general help, type: ?.
      For command help, type: ? command, where command can be
      the first few keywords of a database manager command. For example:
       ? CATALOG DATABASE for help on the CATALOG DATABASE command
       ? CATALOG          for help on all of the CATALOG commands.
      
      To exit db2 interactive mode, type QUIT at the command prompt. Outside 
      interactive mode, all commands must be prefixed with 'db2'.
      To list the current command option settings, type LIST COMMAND OPTIONS.
      
      For more detailed help, refer to the Online Reference Manual.
      
      db2 => connect to SAMPLE
      
         Database Connection Information
      
       Database server        = DB2/LINUXX8664 11.1.3.3
       SQL authorization ID   = DB2INST1
       Local database alias   = SAMPLE
      

4. Accessing the web console

4.1 Access the RapidDeploy Web Console

RapidDeploy server and agent will start up automatically when you start your instance. You can access the web console on:

http://[publicip]:9090/MidVision

Note: make sure you have port 9090 open in your Security group when trying to access RapidDeploy web console. For the first time, you can set the password for the default username ‘ mvadmin ‘. You can prevent auto starting RapidDeploy on instance startup by removing it from the system chkconfig list.

[db2inst1@ ] sudo systemctl disable rapiddeploystart.service
 

5. Maintaining the installation

The following sections cover some of the activities you might want to perform after the instance has been started.
  • db2inst1: This is the default user, which you can log in as. It is permitted to use all SUDO rights. To switch to the root user, type “sudo su“.
  • root:      This is the superuser in linux systems. You can log in as any other user without using passwords. E.g: “su db2inst1

RHEL instances are shipped with a firewall by default to protect your machine. For security reasons, the instance is only accessible via SSH (port 22) at first, so further ports can be opened on the firewall as needed. You will need to open all the ports in this internal firewall, which you have open in your Security group. There is a script placed in the user home of the db2inst1 user (/home/db2inst1), which is also the starting location when logged in. You will need to be the root user to run this script. Example usage:

[db2inst1@ ] sudo ./open-firewall.sh 9090
Open firewall port 9090 iptables: Saving firewall rules to /etc/sysconfig/iptables:[ OK ]
 

There are a few scripts and other files in db2inst1 and root users home directory, which will need to remain unchanged in order to keep the provided scripts working. There are a set of scripts in db2inst1 home directory. Those scripts are executed when logging into the instance controlled by  .bash_profile , but you can also execute them manually whenever they are needed. There are some hidden files used as well,  .firstrun  indicates that the setup wizard has already ran once.

To restart RapidDeploy manually from the filesystem, use the rapiddeploy linux service. The RapidDeploy version is 5.0. RapidDeploy home is located at /var/rd/midvision Example usage:

[db2inst1@ ] sudo service rapiddeploystart start 
[db2inst1@ ] sudo service rapiddeploystart stop

The RapidDeploy server uses an in-memory database, so your RapidDeploy framework needs to be shut down properly to save your work. This happens when the instance is stopping or when calling the stop service manually from the command line. Note that on instance restart, unsaved data will be lost.

For security reasons, you will need to change the default password (default value is ‘mvadmin‘) for user mvadmin. This will be requested the first time only when you log in to the RapidDeploy server.

6. Troubleshooting

6.1 Session loss during setup

If you lose your SSH connection to the target instance during the first run setup script execution (e.g. as a result of a network problem), we advise you to delete and recreate the Microsoft Azure instance and run the script again.

6.2 Contacting MidVision support

Please visit our support website.