What are the subsystems of DB2

swati · New User Joined: 14 Sep 2005 Posts: 7

krishnaboya · New User Joined: 17 Nov 2005 Posts: 3

Swati,

Its depends on your Project/application how they configured DB2.
In few projects they use more than two DB2 subsystems, mostly one subsystem they use for Test and one subsystem for Production environment.
ex: DSNA for TEST
DSNZ for Production

Hope you get my point, if not revert back to me.

krishnaboya · New User Joined: 17 Nov 2005 Posts: 3

Swati,

Its depends on your Project/application how they configured DB2.
In few projects they use more than two DB2 subsystems, mostly one subsystem they use for Test and one subsystem for Production environment.
ex: DSNA for TEST
DSNZ for Production

Hope you get my point, if not revert back to me.

swati · New User Joined: 14 Sep 2005 Posts: 7

there are how many subsystems totally

parikshit123 · Active User Joined: 01 Jul 2005 Posts: 269 Location: India

Hi Swati,

It all depends as to how many DB2 subsystems are created on the shop.

Note that the subsystem is not "Database Instance".

Under one subsystem there can be a number of "Database Instance" the instance is refered to as "creator" in many environments.

So, basically subsystem is a logical part of the entire DB2 mainly created in order to seperate out different environments such as production, acceptance, development, testing etc.

Experts, please correct me if I am wrong.

Hames · New User Joined: 03 Oct 2005 Posts: 49

Hi,

Normally for the following the DB2 subsystems are created.

For

Development,
Testing,
Maintenance,
Production.

Depending Upon the project needs, sometime for testing 2 subsytems also used.

tam · New User Joined: 02 Nov 2005 Posts: 12 Location: zz

Hello,
Mainly there are 3 DB2 subsystems created : Testing, QA, Production.
Testing region is for the developers, QA for the UAT, and Production region is the db accessed by the users.