Getting Started

About this task

HCL OneDB™ is offered as an hourly Amazon Machine Image (AMI). An AMI is an image applied to compute and memory resources which Amazon calls “EC2”. To place an order in your AWS account, navigate to Services > EC2. Click the Launch Instance button.

Procedure

  1. Navigate to AWS Marketplace.”
  2. Search for HCL OneDB and select the latest available version. (Delivery Method is AMI - Amazon Machine Image).
  3. Click on the Continue to Subscribe button and complete all selections.
  4. Proceed through the remaining steps to provision OneDB EC2 instance (virtual machine) on AWS.
  5. Connect to the virtual machine via a ssh program, using the private key for the keypair specified during your instance provisioning.

    SSH as the user “ubuntu”:

    $ ssh -i ~/.ssh/my_aws_private_key ubuntu@hostname-of-my-onedb-ec2
  6. After you are logged into the virtual machine, use the sudo command to become the user “Informix”. 
    $ sudo -u informix bash

    As the user Informix, you will be able to run the various OneDB commands, such as onstat, onmode, and oninit. The machine is configured with the OneDB server running and listening to the following client types on the respective ports:

    Protocol Without TLS With TLS Installation directory
    OneDB Server (SQLI) 9088 9089 /opt/hcl/onedb/server
    OneDB Mongo(WireListener) 27001 27002 /opt/hcl/onedb/apis/mongo
    OneDB REST 26001 26001 /opt/hcl/onedb/apis/rest
    OneDB Explore Server 28001 28002 /opt/hcl/onedb/explore

    To control the network traffic on the EC2 instance (to and from), it is preferable to use the Amazon “Security Group”, instead of an OS-based firewall configuration.

    For security reasons, the OS (Operating Systems) accounts on the AMI do not have a password, and the only account initially configured for inbound SSH is “ubuntu”. To allow a remote client to connect to the OneDB database server you can set a password on the desired OS account or create a database user via the CREATE USER STATEMENT.

    OneDB AMI can be ordered in all AWS regions and on all EC2 types. Since EC2 types have varying amounts of CPU and memory, several types and amounts of storage may be added to an EC2, tuning the OneDB Server to meet your needs (E.g., altering the number of CPU VPs, increasing the size of the buffer-pool, adding dbspaces on the desired storage devices).