CODEWITHSUNDEEP
databasedb2instance
vaisakh
vaisakh

Reputation: 1031

Is DB2 instance the same as a database instance?

I am pretty confused trying to figure out the difference between a DB2 instance and a database instance. I did quite a bit of search online, but almost all comes up with 'database instances'.

From what I have gathered, a database instance consists of the RDBMS software along with tables and other structures.

My doubt is whether there is such a thing as a 'DB2 instance' or is it the same as a database instance?

Upvotes: 4

Views: 9031

Answers (3)

bhamby
bhamby

Reputation: 15469

Check out the Information Center article on instances.

Basically, you can have multiple instances of DB2 running on the same physical machine, and each of those instances can have their own separate databases, administration groups, tunings, etc.

This applies to DB2 for Linux/Unix/Windows. I believe the rough equivalent would be "subsystem" in z/OS-land.

Upvotes: 2

V.J
V.J

Reputation: 1

A DB2 instance is an environment which allows you to store data and run application. You also need to create an instance owner.

Upvotes: 0

Adrian J. Moreno
Adrian J. Moreno

Reputation: 14859

DB2 is a Database from IBM. http://www-01.ibm.com/software/data/db2/

So "an instance of DB2" is a database instance, but a database instance is not always "an instance of DB2".

Upvotes: 0

Related Questions