Installation of DB2

The DB2 RDBMS is freely downlodable from IBM's website. Please use following link to download DB2 on your machine:

https://www14.software.ibm.com/webapp/iwm/web/preLogin.do?lang=en_US&source=swg-dm-db295trial

If you don't have an IBM id yet, you will have to register for the id. Don't worry the id is free and quite useful, so go ahead register and download the so called - IBM Data Server.

Once you have downloaded it on your machine, unzip it and then go to db2_v95_nt32_server\SERVER\image directory. Open setup.exe, click on
Install a Product. Follow the step by step instructions to complete the installation. Some tips:

I did a custom installation on my machine with following options:

Product to install: DB2 Enterprise Server Edition - DB2COPY1
Installation type: Custom

DB2 copy name: DB2COPY1
Set as default DB2 copy: Yes
Set as default IBM database client interface copy: Yes

Selected features:
XML Extender
DB2 WMI Provider
SQLJ Support
Sample database source
Replication tools
OLE DB Support
ODBC Support
MDAC 2.8
IBM Software Development Kit (SDK) for Java(TM)
JDBC Support
First Steps
IBM Data Server Provider for .NET
Control Center
Configuration Assistant
Base client support
Base application development tools

Languages:
English

Target directory: C:\Program Files\IBM\SQLLIB

Space required: 683 MB
Installation specific driver details
IBM Data Server Driver for ODBC and CLI name: IBM DB2 ODBC DRIVER - DB2COPY1
OLE DB Provider GUID: {F4E2537B-89B7-4081-B624-51B076DD51A6}

New instances:
Instance name: DB2
Start instance on reboot: Yes
TCP/IP configuration:
Service name: db2c_DB2
Port number: 50000
Instance user information:
User name: myuser

DB2 Administration server:
Instance user information:
User name: myuser

DB2 tools catalog:
Name: TOOLSDB
Schema: SYSTOOLS
Instance: DB2
Location: Local

After the istallation completes, you will see following message:

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

Optional steps:
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 (also 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, separately 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 on licensing, search the Information Center (http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp) using terms such as "licensing" or "db2licm".
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 access 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.
Your DB2 instance is created as a single-partition instance because this machine is not connected to a domain. To set up a multiple-partition instance environment, refer to DB2 documentation under "Adding a database partition server to an instance".
Refer to "What's new" http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.db2.luw.wn.doc/doc/c0052035.html in the DB2 Information Center to learn about the new functions for DB2 V9.5.

That's it - you are done with the installation. Enjoy!

No comments: