IBM DB2 Connection Enterprise Edition connects LAN-based systems and their desktop applications to your company's mainframe and minicomputer host databases. Now you can consolidate your host access through a gateway that makes it easy to deploy web and multi tier applications.
Software & terms:
Charm for IBM DB2 Connect Enterprise Edition 11.1.1 ( IBM DB2 CENT )
IBM DB2 Connect Enterprise Edition
IBM DB2 Connect Enterprise Edition connects LAN-based systems and their desktop applications to your company's mainframe and minicomputer host databases. Now you can consolidate your host access through a gateway that makes it easy to deploy web and multitier applications. This solution includes IBM Data Studio and the InfoSphere Optim pureQuery Runtime environment, which can significantly improve the way databases are developed, tested and deployed. DB2 Connect Enterprise Edition is provided as part of this charm.
More information available at the IBM Knowledge Center
The charm installs
DB2 Connect Enterprise Edition Version 11.1 Mod1 Fix pack1 as there are installation issues on Ubuntu Z if we install Base Version
11.1.0. To get this version i.e.
126.96.36.199, user needs to download the required packages from IBM Fix Central site.
User can download the
Activation key for IBM DB2 Connect Enterprise Edition. User can download the license key from Passport Advantage site. Without
Activation key, the installed product is of
The part number for
IBM DB2 Connect Enterprise Edition 188.8.131.52 is
The user will need to procure the appropriate license to be able to download and use IBM DB2 Connect Enterprise Edition.
To acquire and download DB2 Connect Enterprise Edition, follow instructions available at Product Page DB2 Conn or Product Page Express.
Support&downloads in Product Page DB2 Connect gives different options for downloading the packages.
Download steps for IBM DB2 Connect Enterprise Edition 11.1.1 using Passport Advantage as mentioned in Downloading IBM DB2 Connect Enterprise Edition 11.1.1 . To get more information on accessing Passport Advantage please visit the link Accessing Passport Advantage.
To install the downloaded binaries you must agree to the IBM DB2 Connect Enterprise Edition license. You can view the full license for DB2 Connection Enterprise Edition by visiting the Software license agreements search website. Search for "DB2 Connection Enterprise Edition 11.1.1" and choose the license that applies to the version you are using.
In case you already have an IBM account and cannot download the product or for other error during SW download, please refer to the IBM Support Site to solve the error.
Memory and Disk Requirements
At a minimum, a DB2 Connect Enterprise Edition At a minimum, a DB2 database system requires 256 MB of RAM. For a system running just a DB2 product and the DB2 GUI tools, a minimum of 512 MB of RAM is required. However, 1 GB of RAM is recommended for improved performance. These requirements do not include any additional memory requirements for other software that is running on your system. For IBM® data server client support, these memory requirements are for a base of five concurrent client connections. For every additional five client connections, an additional 16 MB of RAM is required.
On Linux and UNIX operating systems, if the temporary directory (default: /tmp) is a mounted drive, all users must be able to directly execute binaries. (For example, if /tmp is a mounted drive, do not specify the noexec parameter with the mount command when you create the drive). The /tmp space that is required for a DB2® pureScale® environment is 2 GB, and for environments other than a DB2 pureScale environment the space required is 512 MB. The /var directory requires 512 MB of free space. More information on this can be found in Memory Requirements
To deploy IBM DB2 CENT charm, run the following command:
Make sure the appropriate memory requirements are made available
For deploying either use an existing machine, or create a new machine using
juju deploy ibm-db2-cent --resource ibm_db2_cent_installer=</path/to/installer.tar.gz>
juju agree ibmcharmers/ibm-db2-cent/1
Once you have agreed to the Terms, then only the IBM DB2 Connect Enterprise Edition charm will be deployed. Juju deploy command will install db2 connect enterprise edition and will expose the hostname, port number, db2 instance, install path and userid to the users.
Additional configuration parameters
Following shows the different configurable values for ibm-db2 charm:
If the user wants to set a different file path used to create databases and logs it can be set using the config value dftdbpath. Use the following command to set it
juju set ibm-db2-cent dftdbpath=<new-path-to-set>
juju set ibm-db2-cent dftdbpath="/tmp"
Once IBM DB2 CENT charm is deployed, the user can log into the container/machine where it is deployed using the default user/password (db2inst1/db2inst1). The user can run any db2 commands after this.
For creating a new DB the user may run the command:
db2 create database <db-name>
For listing the DBs created, run the command:
db2 list db directory
For getting db2 command prompt just run the command:
Relating with im-db2 charm
IBM DB2 CENT charm can be related to any ibm database server charm. For e.g ibm-db2 or ibm-db2-dae. You can connect to Databse charms using the following command.
juju add-relation ibm-db2 ibm-db2-cent
When IBM DB2 charm is related to IBM DB2 CENT charm, it creates a db2instance, username/password as per the service name and will be provided to the IBM DB2 CENT charm. IBM DB2 charm also creates a database
DB2CONN and returns the DB details once they are successfully created.
Without establishing relation with IBM DB2, IBM DB2 CENT can not connect to IBM DB2 charm.
See config.yaml file for more information.
dftdbpath: This parameter contains the default file path used to create databases under the database manager. If no path is specified when a database is created, the database is created under the path specified by the dftdbpath parameter.
IBM DB2 CENT Limitations
If you are running linux containers on a host with kernel < 3.16, be advised that db2start will not succeed because of a hard coded 32MB kernel.shmmax setting. You will need to upgrade your host to kernel 3.16 or greater by following the instructions here:
DB2 also needs to be deployed using a non-zfs filesystem for container deployment. ZFS file system might cause some of the db2 commands to error out.
IBM DB2 Links and Contacts
(1) General Information Information on IBM DB2 CENT available at the DB2 Knowledgecenter
(2) Download Information Information on procuring DB2 Connect product is available at the Passport Advantage Site
(3) Contact Information For issues with this charm, please contact email@example.com
- (string) This parameter contains the default file path used to create databases under the database manager. If no path is specified when a database is created, the database is created under the path specified by the dftdbpath parameter.