Creating a Db2 v11.5 instance and the sample database.

DBplatz Support

Feb 20, 2020 — 2 min read

In the last post I installed Db2 11.5 on Ubuntu 16.4 and here I'll show how to create a Db2 instance and the SAMPLE database.

But first, I'll create the db2inst1 user (Db2 Instance user).

# Create the dba group
groupadd dba

# Create the db2inst1 user and assign it to the Dba group.
/usr/sbin/useradd -d /home/db2inst1 -g dba -s /bin/bash db2inst1

As root we execute the db2icrt command to create the instance.

cd /opt/ibm/db2/V11.5/instance

root@ubusrvdb2: /opt/ibm/db2/V11.5/instance>
$ ./db2icrt -u db2inst1 db2inst1
DBI1446I  The db2icrt command is running.


DB2 installation is being initialized.

 Total number of tasks to be performed: 4
Total estimated time for all tasks to be performed: 309 second(s)

Task #1 start
Description: Setting default global profile registry variables
Estimated time 1 second(s)
Task #1 end

Task #2 start
Description: Initializing instance list
Estimated time 5 second(s)
Task #2 end

Task #3 start
Description: Configuring DB2 instances
Estimated time 300 second(s)
Task #3 end

Task #4 start
Description: Updating global profile registry
Estimated time 3 second(s)
Task #4 end

The execution completed successfully.

For more information see the DB2 installation log at "/tmp/db2icrt.log.95716".
DBI1070I  Program db2icrt completed successfully.

and that's it. The instance has been created successfully.

Now, we can su to the Db2 instance user (db2inst1) and execute db2level to see the Db2 version (v11.5 fp0).

$ su - db2inst1

db2inst1@ubusrvdb2: /home/db2inst1>
$ db2level
DB21085I  This instance or install (instance name, where applicable:
"db2inst1") uses "64" bits and DB2 code release "SQL11050" with level
identifier "0601010F".
Informational tokens are "DB2 v11.5.0.0", "s1906101300", "DYN1906101300AMD64",
and Fix Pack "0".
Product is installed at "/opt/ibm/db2/V11.5".

and we can create the SAMPLE database.

db2inst1@ubusrvdb2: /home/db2inst1>
$ db2sampl

  Starting the DB2 instance...
  Creating database "SAMPLE"...
  Connecting to database "SAMPLE"...
  Creating tables and data in schema "DB2INST1"...
  Creating tables with XML columns and XML data in schema "DB2INST1"...
  Stopping the DB2 instance...

  'db2sampl' processing complete.

and once created, we can start the db2 instance and connect to the database.

db2inst1@ubusrvdb2: /home/db2inst1>
$ db2start
02/20/2020 16:42:08     0   0   SQL1063N  DB2START processing was successful.
SQL1063N  DB2START processing was successful.

db2inst1@ubusrvdb2: /home/db2inst1>
$ db2 connect to sample

   Database Connection Information

 Database server        = DB2/LINUXX8664 11.5.0.0
 SQL authorization ID   = DB2INST1
 Local database alias   = SAMPLE

Want to thank me?

MariaDB failing over primary to the replica.

In a previous post, we set up replication for MariaDB. This time we are failing over manually from the Primary node (master) to the Replica node (slave). Primary - mariadb01 We connect to mariadb01 as Primary. [centos@mariadb01 ~]$ mysql -u root -p --prompt "Primary> " We set all tables to be

Setting Up Replication - MariaDB 10.3

In a previous post we learned how to install MariaDB on Centos. In this one we are setting up replication. Official docs are here. So, let's get to it. Installing MariaDB I've used this guide to install MariaDB 10.3 on 2 Hyper-V VM servers called mariadb01 (PRIMARY) and mariadb02

IBM Db2 restore redirect

In the last article we installed IBM Db2 11.5 on Red Hat, and we also created the SAMPLE database using the db2sampl command, so in this article we will see how to use the restore redirect script to move that database to a different location. So let's connect to

Installing IBM Db2 11.5 on Red Hat.

In this article we are installing IBM Db2 on Red Hat linux. We can download Db2 from here - A free IBM account is required to download Db2 software. Once we've downloaded the software from the IBM website and uploaded to the Red Hat VM. root@redhat:/root> $ ls -lrt

Read more

MariaDB failing over primary to the replica.

Setting Up Replication - MariaDB 10.3

IBM Db2 restore redirect

Installing IBM Db2 11.5 on Red Hat.