Instance in DB2 ?

dandapani · New User Joined: 13 Dec 2005 Posts: 7 Location: banglore

Hi ,
Can you brief about instance in DB2?

I mean levels in DB2.
1) Server
2) Instance
3) Database
4) Table space
5) Table.

Regards,
Dhans.

yeshao · New User Joined: 28 Dec 2005 Posts: 2

It seems that only DB2 UDB for Windows, Unix has the concept of an instance. An instance (sometimes called a database manager) is a complete environment which can have its own databases. Multiple instances may be created on the same machine.
The database manager configuration file is created when an instance of DB2 UDB for Windows, Unix is created. It contain parameter values that define the resources allocated to the instance.