Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
difference between DB2 UDB and DB2?

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

New User


Joined: 30 Aug 2006
Posts: 1

PostPosted: Wed Aug 30, 2006 12:27 am    Post subject: difference between DB2 UDB and DB2?
Reply with quote

Can someone let me know what is the difference between DB2 UDB and DB2?

Title changed from "HI.." to "difference between DB2 UDB and DB2?" : Priyesh.

Thanks,
Nithya R
Back to top
View user's profile Send private message

superk

Moderator Team Head


Joined: 26 Apr 2004
Posts: 4650
Location: Raleigh, NC, USA

PostPosted: Wed Aug 30, 2006 12:52 am    Post subject: Re: HI..
Reply with quote

Recently asked and answered here.
Back to top
View user's profile Send private message
twissi

Active User


Joined: 01 Aug 2005
Posts: 105
Location: Somerset, NJ

PostPosted: Wed Aug 30, 2006 10:21 am    Post subject:
Reply with quote

Nithya,

Please go through the post that Superk has kindly mentioned.

Now, there are a lot of differences between DB2 and UDB as far as mainframes are concerned!
One of them being "the DB2 storage is a part of the mainframe and that of the UDB used to be on an UNIX box connected to the mainframe".
DB2 is much faster and will be readily available where as the UDB needs to be brought online before you can execute any jobs against it and much slower as well.

Why people go for UDB at times is that it is damn cheap (when compared to that of DB2). Your business may somtimes require to store a huge amount of data that are not referenced all that frequently but have some importance, UDB is your best fit!

Hope these make some sense! I'm not an UDB expert myself, but I've developed a process that accesses the UDB and extracts the required data and inserts into DB2 tables on Mainframe, when the business has a requirement.

Cheers, Twissi.
Back to top
View user's profile Send private message
Karthik Chandrasekaran

New User


Joined: 21 Aug 2006
Posts: 8

PostPosted: Wed Aug 30, 2006 12:17 pm    Post subject: difference between DB2 UDB and mainframes
Reply with quote

I am not a db2 UDB expert.But as far as my knowledge the base architecture of UDB and mainframe is different.
The way you acess the catalog table to know the details abt the database(db) objects in the db.In mainframe you have a single catalog table for the entire subsystem, but in the case of UDB you have catalog for each database.
There are lot more differences b/w UDB and mainframes...
Back to top
View user's profile Send private message
Karthik Chandrasekaran

New User


Joined: 21 Aug 2006
Posts: 8

PostPosted: Wed Aug 30, 2006 12:18 pm    Post subject: difference between DB2 UDB and mainframes
Reply with quote

I am not a db2 UDB expert.But as far as my knowledge the base architecture of UDB and mainframe is different.
The way you acess the catalog table to know the details abt the database(db) objects in the db.In mainframe you have a single catalog table for the entire subsystem, but in the case of UDB you have catalog for each database.
There are lot more differences b/w UDB and mainframes...
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 Difference in SORT & ICETOOL Mohan Kothakota DFSORT/ICETOOL 5 Fri Sep 22, 2017 4:56 pm
No new posts Difference between TWALENG and TWASIZE Arunkumar Chandrasekaran CICS 3 Tue Jan 03, 2017 12:57 pm
No new posts Sticky: difference between ... DUMMY ... and ... enrico-sorichetti JCL & VSAM 0 Mon Oct 17, 2016 4:31 pm
No new posts Difference space showed for TS and it... autobox DB2 1 Thu Apr 14, 2016 1:07 pm
No new posts Difference Between CICS WebSupport an... sachinji84 CICS 1 Mon Mar 07, 2016 7:25 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us