Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

What are the subsystems of DB2

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
swati

New User


Joined: 14 Sep 2005
Posts: 7

PostPosted: Thu Nov 17, 2005 3:32 pm    Post subject: What are the subsystems of DB2
Reply with quote

What are the subsystems of DB2
Back to top
View user's profile Send private message

krishnaboya

New User


Joined: 17 Nov 2005
Posts: 3

PostPosted: Thu Nov 17, 2005 4:24 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
krishnaboya

New User


Joined: 17 Nov 2005
Posts: 3

PostPosted: Thu Nov 17, 2005 4:25 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
swati

New User


Joined: 14 Sep 2005
Posts: 7

PostPosted: Thu Nov 17, 2005 5:40 pm    Post subject: one query about the same question
Reply with quote

there are how many subsystems totally
Back to top
View user's profile Send private message
parikshit123

Active User


Joined: 01 Jul 2005
Posts: 269
Location: India

PostPosted: Thu Nov 17, 2005 6:18 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
Hames

New User


Joined: 03 Oct 2005
Posts: 49

PostPosted: Mon Nov 21, 2005 5:00 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
tam

New User


Joined: 02 Nov 2005
Posts: 12
Location: zz

PostPosted: Tue Nov 22, 2005 12:29 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Can a COBOL program access two tables... dejunzhu DB2 7 Tue Oct 30, 2012 6:32 am
No new posts Compare structures in two Subsystems guptae DB2 5 Tue Feb 02, 2010 2:42 pm
No new posts updating DB2 table across different s... smachohalla DB2 3 Tue Feb 10, 2009 5:18 am
No new posts Establish a dblink between two subsys... nagesh54 DB2 10 Tue Nov 04, 2008 1:08 pm
No new posts Compare 2 tables from 2 different sub... sunibabi DB2 5 Fri Apr 27, 2007 8:11 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us