Krishnakant Parihar

DB2 is a popular database for integration and IBM Cloud deployments. So We may see lot of use in db2 in enterprises.

Benefits of using DB2® Multisystem include improved query performance, decreased data replication, larger database capacity, and so on.

But non of the system is perfect. So its pros and cons as described “https://www.trustradius.com/reviews/db2-2015-12-08-12-27-24” website are given bellow.

Following video tutorial describe the installation process properly.

DB2 Express-C version 10 and later no longer include a full suite of administration tools as part of the installer (the “Administration Tools” you installed might only include the ones you’re looking at…).

Like MySQL and SQL Server, the administration tools are now available as a separate download.

The official tool you’re looking for is IBM Data Studio, which is available free of charge.

Older versions of DB2 Express-C used to include the legacy Control Center apps, but IBM has deprecated those and is really pushing the Eclipse-based Data Studio.

Following url has the installation instructions and the download link.

As a example i will show how to install it in windows environment.

First download the latest IBM Data Studio client for windows extract it and run the launchpad.exe

Just click on Administrative Installation Or upgrade and installation process will begun by opening IBM installation Manager. First of all this process will install IBM Installation Manager and then IBM Installation Manager will install IBM Data Studio.

You may change the version hear. If you are ok with the latest version then click next and accept the policy agreement and then click next.

In next window you will be asked the file path to install. I am going with the default one.

Finally a summary of provided information will be displayed for confirmation.

Once you are start installation it will install IBM installation Manager and it will ask you to restart the installation manger to begin other installations.

Once Restart installation Manger it will be prompted following window which you can start installing Other IBM packages. Click on Install button.

Then you have to select the IBM Data Studio client and start installing it.

Then aggrement acceptance process.

Finally installation messages will be given.

Next come package group creation window.

Then select the language required for you.

Then features will be shown to be installed. By default SQL execution is not selected and if you want just check to add it to the list and start to install by clicking Next.

Finally summary page will be displayed and you can start the installation process.

Finally you will see the window you were waiting for. Successful completion and there is only one button to “Finish”.

Once you done you may find menu item to launch IBM Data Studio. Just click and start the party.

After workspace configuration you will see the welcome window.

First you have to check your current instance or if you want change the instance which you want to create the databae.

You may do it by DB2 Command Window Administratoty and use following command to view the current instances.

> db2ilist

If you want to change the instance to LDAPDB2 use the following command.

> set DB2INSTANCE=LDAPDB2

IBM has provided more informations about instance management in following url.

Then now you know your instance and now you can create a new database using IBM Data Studio. Its simple just click the New Database icon marked by read arrorw in the interface and first give instance information and then db information.

Once Instance is successfully created then you are able to create the database.

I tried to give the Database location as given in the following interface.

But When i click the Run button in the top of the window and error appeared as “Database Path Doesn’t Exists” in the Query running part in the Storage which instantly opened when we run.

The reason was this issue was given in one help page as follows.

In Windows you can use only C:,D:,E: drive letters for Database Pathsduring create db command.Please usedb2set DB2_CREATE_DB_ON_PATH=YESThen you should be able to create DB on sub folders.

So hear you have 2 options you may give the path as “C:” etc. Or Enable db on path option from Administration console. Remember to restart the instance after the configuration to take it in to effect.

commands used.

Then databases will be created in given subfolder.

It is required to create users grant privileges and user management for database. For this option first of all you have to connect to the specific database.

Right click on the database → Connect

Then Database should be connected. Now you database name in the Administration Explorer window can be expanded. Now Go to privilege management interface.

Right Click on the databae name → Manage Privilages.

In the bottom panel click on the diamond icon and create a new user with the privileges you want.

Connection conndb2 = DriverManager.getConnection(“jdbc:db2://localhost:50000/samesb”, “db2esb1”,”db2esb2");

Right click on the table then go to “Data” and “New “Select” Script and then execute the query by clicking on green arrow circle. Then click on the result set in bottom window. Right click on the record select “Export” then all result or any other your choice.

Right click on localhost DB2 Schemas and new Schema.

Give name as MIGRATION.

Click on save changes.

Then click on “Generate DDL”. It will commit the changes and if error found you have to correct it. Then refresh it see the changes.

Original table structure.

Click on Tables icon. Right click on it then click on Create Table.

Select the Schema you created early “MIGRATION”.

Then Give the name “DB_TABLE_CONFIG”.

Now you have to define columns. Original structure as follows.

So you have to create this schema in you local database also.

Then save the changes and and then click on “Generate DDL”.

Then you can execute this sql query and get the output as follows.

CREATE SCHEMA MIGRATION

CREATE TABLE MIGRATION.DB_TABLE_CONFIG ( TABLE_NAME VARCHAR(255 OCTETS), SOURCE_COLUMN VARCHAR(255 OCTETS), TARGET_COLUMN VARCHAR(255 OCTETS), TRANSFORMATION VARCHAR(255 OCTETS), DATA_TYPE VARCHAR(50 OCTETS), ORACLE_TABLE VARCHAR(255 OCTETS) )

Once done click on the Refresh button to see the changes.

Now time to import csv file to local table.

Click on the table and right click on it. — → Load → With Import Utility

Give the file you imported data and click on Run button then you will see the status of the import task.

A Successful message should come as number of record it has imported.

Now you can view all records you have imported.

Click on “Tables”

Click on record “MIGRATION “ with table name “DB_TABLE_CONFIG” record.

Right click on it select “Data” then “New “Select” Script”

It will give following query and by executing it you may see records.

Insert Query .

There will be a record added with column names. So you have to remove that record.

Run above commands in SQL window.

For administration the DB2 database you may use DBeaver . You may download this tool from bellow url.

Further Jdbc-db2 driver also required and it can be downloaded from the maven repository.

After installation DBeaver then try to make a connection as follows.

New → DBeaver -> DB Connection

Give db2admin username and password pwd@123

Then select the driver also.

Then you can connect and view SAMPLE database and schemas can be viewed .

DB2 installation using docker

From the command line terminal, create a new directory for your Docker image:

Go to this directory by entering the following command:

Log into your Docker container:

Pull the Db2 Docker image from Docker Hub:

From your Docker folder, create an environment variables file, .env_list, for your Db2 Community Edition image:

Be sure to include the quotation symbols when creating the file.

In a text editor, open the .env_list file and paste the following:

Parameter list of this can be find in the above url.

// Following command can be used to run the db2

Once it is running it should be visible by : docker ps cammand.

Starting and Stopping db2 containers

Now database should be created by a docker client.

Start the service

Then you have to create the database if it is not created by now.

https://www.tutorialspoint.com/db2/db2_databases.htm

db2 activate db

// if it is created you may connect it now

Use the below commands to create the database

db2 create database test3

db2 connect to test3 user db2inst1 using db2inst1

Further following source discuss on DB2 installation in ubuntu.

Additionally, “Training bases like the Joint Readiness Training Center here will be central to preparing America's Army for future conflicts

Get the geometry we want.

There are programs with different properties. While Rhinoceros is a good option for modeling complex surfaces and geometries with precision, it is not a good option for modeling with information. It is easy to implement and maximize our work when we work with both programs.

Most of the time, we will use the main platform of work to model complex geometry, and just need Rhinoceros to do it, which is really hard to do in Revit.

Will we need to measure volumes in the program? Are we going to create families in the model and just need to quantify the number of families? Is the geometry going to be used as a reference in the program?

If geometry is imported from other software, the first thing you should do is to check that the geometry is correct.

We have to check the control points of the curve to see if it is imported into Rhinoceros. To analyze the curve, first of all, select the curve, then press F10

If the curve is incorrect, you must rebuild it using the "Rebuild" command.

We have to check the isocurves to see if a surface is well imported. You can preview the isocurves of any surface in Rhinoceros.

The minimum number of isocurves is needed to have an accurate definition.

An excessive number of control points can cause problems when working with this geometry in Revit.

Each surface of a rhino has a front and a back face. The directionality of the surface is what this is called.

It is important that all surfaces have the same orientation, since different operations can be carried out on different surfaces. The normal direction of the surfaces will be oriented outward if we have a closed volume.

The direction of the surfaces can be seen by pressing the dir command.

Press the "Flip" command to change the direction of the surface.

One way to preview the direction of a surface is to change the Rhinoceros options of displaying geometry and backfaces.

When working with adjacent surfaces it is important to check the coincidence between edges and edges.

We have to consider the size of the file when summing up the best practices in Rhinoceros.

We will consider the use of worksessions.

Multiple users can work on a large project at the same time with a work session.

The source project is divided into several files that can be edited independently, however the rest of the team can't modify it.

We need to know which type of surface we're exporting from Rhinoceros. The results will be right or not depending on the surface you choose to export.

The following parameters are used to classify the Rhinoceros surfaces.

There are different types of surfaces in Rhinoceros.

To analyze the surface, we will use the "What" command and we will preview the Control Points by pressing "F10".

The use of the type of surface.

When there is no need to work later with the geometry, this type of workflows will be used.

It is appropriate only if the imported geometry will not be used in views such as sections and elevations.

It can't be converted to a native Revit element.

There are steps.

There are features.

It is advisable to import geometry into a mass if it will be represented in views.

When it is necessary to create native Revit elements such as walls, roofs and floors based on imported surfaces, this type of workflows will be chosen.

There are steps.

There are features.

This procedure will be used when the geometry is needed.