Shulou(Shulou.com)06/01 Report--

The new unit comes into contact with db2, IBM's heavyweight database product, or need to familiarize themselves with it. The old routine, first look at the basic information, understand the basic concepts, start to set up the experimental environment hands-on experiment.

First use virtual box virtual machine to prepare a centos7 64-bit linux operating system environment, and then go to IBM's official website to download the latest version of the 90-day use version, download address:

https://www-01.ibm.com/marketing/iwm/iwm/web/pick.do? source=swg-dm-db2trial&lang=zh_CN

Maybe when you see this blog address has expired, then go to the official website db2 home page (http://www-01.ibm.com/software/cn/data/db2/), there should be a free version of the download link, should be the same. The latest version I downloaded was v11.1.

Download the software at the same time, find the corresponding installation guidance documents, the same, go to the official website to see the relevant documents, the URL is as follows:

http://www-01.ibm.com/support/docview.wss? rs=71&uid=swg27009474

Select the corresponding topic, mainly db2 version new features, installation conditions, different installation methods, installation methods for different operating systems, etc., to find the corresponding linux 64-bit installation documentation. I read this article:

Installing DB2 servers using the DB2 Setup wizard (Linux and UNIX)

Version 11.1.0 Version 10.5.0 Version 10.1.0 Version 9.7.0 Version 9.5.0

The installation file has 2 G's, I don't want to pass such a large file around, I use ultraISO to make the installation file into a mirror ISO file, with the mention that the ultraISO installed at that time is version 9.6.5, to find a registration code online activation, simplified Chinese version registration code: username: Wang Tao registration code: 7C81 -1689-4046- 626F, here thank you for this good man. After registration, ultraISO can only generate content larger than 300 megabytes. Mount the ISO image file on the virtual machine. After mounting, the path on the virtual machine is/run/media/root/MYCD/. Go directly to see it. Right, intoxicated with the command line, this installation should be graphical installation mode, so, or directly to the virtual machine above the graphical interface, command window on the desktop (and windows operation like, what? There is no graphical interface, sorry, please reinstall centos desktop environment), extract the installation file to a directory of the system (tar xvf product.tar ), such as/software, and then enter the installation directory, find the db2setup file, execute: ./ db2setup

An installation interface popped up. Select NEW INSTALL and the following interface popped up:

Well, I'll just pick the first one and click NEXT:

Although it is the first time to install, install B, learn more about some installation features, select Custom, don't forget to check the agree IBM terms, click NEXT:

In the above step, you can see the detailed feature options, I did not change, directly next:

In the above step, simplified Chinese and traditional Chinese are added (because the project owner is Taiwanese, it is estimated that traditional Chinese will be used). Next step:

The above step, do not change, the next step NEXT:

The above step is to create the installation user and installation directory, select the default, the production environment needs to change the corresponding parameters according to the plan, click NEXT:

Select the default above, is the partition ah what, look back at the related concept, click NEXT:

The above is to determine the instance user, select the default, the production environment needs to change the corresponding parameters according to the plan, click NEXT:

The above is to determine the fenced user, select the default, the production environment needs to change the corresponding parameters according to the plan, click NEXT:

The above is to determine the open port, select the default, the production environment needs to change the corresponding parameters according to the plan, click NEXT:

Above is the configuration notification message, click NEXT:

Above is the health check notification, click NEXT:

Above is the installation summary, click FINISH:

Above is the beginning of installation...

That's it up here. The first installation, choose to view the steps after installation, is to tell you what to do after installation, I will be wordy, copy down, as follows:

Required steps:

In order to start using DB2 you need to logon using a valid user ID such as the DB2 instance owner's ID "db2inst1".

You can connect to the DB2 instance "db2inst1" using the port number "50000". Record it for future reference.

Optional steps:

To validate your installation files, instance, and database functionality, run the Validation Tool, /opt/ibm/db2/V11.1/bin/db2val. For more information, see "db2val" in the DB2 Information Ce

nter.

Open First Steps by running "db2fs" using a valid user ID such as the DB2 instance owner's ID. You will need to have DISPLAY set and a supported web browser in the path of this user ID.

You should ensure that you have the correct license entitlements for DB2 products and features installed on this machine. Each DB2 product or feature comes with a license certificate file (al

so referred to as a license key) that is distributed on an Activation CD, which also includes instructions for applying the license file. If you purchased a base DB2 product, as well as, sepa

rately priced features, you might need to install more than one license certificate. The Activation CD for your product or feature can be downloaded from Passport Advantage if it is not part

of the physical media pack you received from IBM. For more information about licensing, search the Information Center (http://publib.boulder.ibm.com/infocenter/db2luw/v10r5/index.jsp) using t

erms such as "license compliance", "licensing" or "db2licm".

To use your DB2 database product, you must have a valid license. For information about obtaining and applying DB2 license files, see http://pic.dhe.ibm.com/infocenter/db2luw/v10r5/topic/com.

ibm.db2.luw.qb.server.doc/doc/c0061199.html.

Refer to "What's New" http://publib.boulder.ibm.com/infocenter/db2luw/v10r5/topic/com.ibm.db2.luw.wn.doc/doc/c0052035.html in the DB2 Information Center to learn about the new functions for D

B2 11.1.0.0.

Verify that you have access to the DB2 Information Center based on the choices you made during this installation. If you performed a typical or a compact installation, verify that you can acc

ess the IBM Web site using the internet. If you performed a custom installation, verify that you can access the DB2 Information Center location specified during the installation.

Review the response file created at /root/db2server.rsp. Additional information about response file installation is available in the DB2 documentation under "Installing DB2 using a response

file".

The first installation of db2 is complete. Let's look at the basic usage later.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.