DB2 Architecture

DB2 Environment has three layered Hierarchy

1. Physical Server Machine
1. Workstation on which database is installed forms the highest element in this hierarchy.It an physical machine.
2.  Virtual Server Machine
1. An Virtual Server is created on the machine when we install the DB2 Setup. It is commonly know as DAS( DB2 Admin Server).
2. It is collection of Instances.
3. It runs as a Windows services which can be start or stop using services.msc console.
4. It can also be start or stop using command prompt as 
1. db2admin stop or
2. db2admin start commands
5. It is required for 
1. Network database discovery
2. Remote Administration
3. Tools Catalog task scheduling
3. DB2 Virtual Registry( DB2 Profile Registry)
1. Similar to the Windows registry, which is used to save windows related info/path into variables, DB2 Profile registry also save Environment related information into variables.
2. From the command prompt ""db2set" is used to view or change all the option
4. Database Instance or Database Manager (DBM)
1. Instance can be defined as collection of processes which are used by the user to access the database as well as collection of resources.(memory)
2. In a single installation of DB2, we can generate multiple Instances from installation files. 
3. Instance acts as an manager for all the database residing within it. 
4. It can be started or stopped using command "db2start" or "db2stop" command ( Note:- this command needs to be executed from the db2 prompt unlike the command prompt)
5. It consists of DB2 Database Manager Configuration File per instance.( DBM CFG)
6. DBM CFG can be accessed using the command "get dbm cfg"( Note:- this command needs to be executed from the db2 prompt unlike the command prompt)
7. Instance configuration file consists of
1. security plan
2. performance attributes
3. communication
8. There are four types of Instances
1. ESE
2. WSE
3. Standalone
4. Client
5. Database
1. Database can be defined as collection of tables and related objects.
2. Each database include
1. system catalog tables
2. database configuration file
3. recovery log
3. Similar to the Instance configuration file, each database consists of its own configuration file.(DB CFG)
4.  DB CFG can be accessed using command "get db cfg".( Note:- this command needs to be executed from the db2 prompt unlike the command prompt)