Posts

Instance

-
Image
DB2 Instance Definition "An instance in DB2 for LUW is like a copy of the RDBMS including all the processes that run DB2 and memory (address spaces) associated with that instance of DB2 and some configuration parameters to control that instance". A DB2 instance includes memory areas – memory areas that contain all the memory areas for all of the databases. A DB2 instance includes processes/threads. Some processes/threads are associated with specific databases and even specific connections, but they are all tracked back to just one instance. A DB2 Instance also stores information specific to that instance, in the instance owner’s home directory, including: Node directory Database directory db2diag.log, db2 notification log, and dump files DBM configuration file db2nodes.cfg Instance=Memory+Process/Threads There could be multiple instances on a single server (development, production, testing) but it's highly unlikely that a server would have multiple...
Post a Comment
Read more

Installation

-
Image
Pre-requisites For installing DB2 we would need Virtual Machine with any one of Linux/Unix distro (Ubuntu, CentOS, Fedora) installed in it. Next we require the DB2 installation binaries that can be downloaded from the following links. You have two options to install on your system, The DB2 Express-C(free) edition or the DB2 Sever(90 day trial edition). As of now you are recommended to install the Express-C edition as it's more than sufficient to learn DB2 although it does not contain all the advance features. DB2 Download Installation Methods There are three methods that can be used to install DB2 Data Setup Wizard This is a GUI based installation. This technique can also be used to generate a response file what can be used for silent installation. This method would hardly be used in work environments. The DB2 Install wizard This installation method is run on the terminal. It's an interactive utility where you need to enter ...
Post a Comment
Read more

Introduction

-
Image
About DB2 Intro DB2, a product developed by IBM corporation in 1983 is one of the most widely used database engines used int he world. Primarily designed as a RDBMS it now supports object relational features and JSON as well as XML. DB2 Family Product Platform DB2 is available for the following platforms. DB2 Editions  There are various editions of DB2 offered by IBM. According to requirements client can opt for any of the editions matching their requirement.Currently DB2 is available in the following editions, you can also compare the editions that would be suitable according to your planned deployment.   Features of each licensing would be discussed in the coming blog posts.
Post a Comment
Read more