Adding a Db2 environment
This topic describes how to add a Db2 Staging environment.
Prerequisites
Make sure that the staging environment in question meets the requirements described in Requirements for Db2 Hosts and Databases
Procedure
Login to the Delphix Management application.
Click Manage.
Select Environments.
Next to Environments, click the Actions (...) menu and select Add Environment.
In the Add Environment dialog, select Unix/Linux in the menu.
Select Standalone Host.
Click Next.
Enter a Name for the environment.
Enter the Host IP address or hostname.
Enter the SSH port. The default value is 22.
Enter an OS Username for the environment. For more information about the environment user requirements, see Requirements for Db2 Hosts and Databases
Select Login Type. — Username and Password - enter the OS username and password — Username and Public Key - enter the OS username. — Password Vault - select from an existing Enterprise Password Vault
warning : Currently, the Enterprise Password Vault option is not supported.
Info : Using Public Key Authentication
If you want to use public-key authentication for logging into your Unix-based environment, there are two options: use the engine's key pair or provide a key pair for this environment.
To use the engine's key pair:
Select Public Key for the Login Type.
Click View Public Key.
Copy the public key that is displayed, and append it to the end of your
~/.ssh/authorized_keys
file. If this file does not exist, you will need to create it.Run chmod 600 ~/.ssh/authorized_keys to allow only the file's owner to read and write to it (make sure the file is owned by the user).
Run chmod 755 ~ to restrict access to the user's home directory so no other user may write to it.
Run chmod 700 ~/.ssh so that others cannot write to it. The ~/.ssh directory cannot be writable by group or other users. Otherwise, authentication will fail.
As an alternative, you can provide a key pair specific for this environment via the API or CLI. See Option 2 in this CLI Cookbook article for instructions.
For Password, enter the password associated with the user in step 11.
Using Public-Key Authentication:
Run chmod 600 ~/.ssh/authorized_keys to allow only the file's owner to readand write privileges to it (make sure the file is owned by the user).
Run chmod 755 ~ to restrict access to the user's home directory so no other user may write to it.
Run chmod 700 ~/.ssh so that others cannot write to it. The ~/.ssh directory cannot be writable by group or other users. Otherwise, authentication will fail.
You can also add public key authentication to an environment user's profile by using the command-line interface, as explained in the topic CLI Cookbook: Setting Up SSH Key Authentication for UNIX Environment Users
For Password Login, click Verify Credentials to test the username and password.
Enter a Toolkit Path (make sure the toolkit path does not have spaces).
For more information about the toolkit directory requirements, see Requirements for Db2 Hosts and Databases
To provide your own Oracle Java select the Provide my own JDK checkbox and click Next.
In the Java Development Kit tab enter the absolute path to your Oracle JDK and click Next.
Click Submit.
As the new environment is added, you will see two jobs running in the Delphix platform Job History, one to Create and Discover an environment, and another to Create an environment. When the jobs are complete, you will see the new environment added to the list in the Environments tab. If you do not see it, click the Refresh icon in your browser.
Post-requisites
To view information about an environment after you have created it:
Click Manage.
Select Environments.
Select the environment name.