View previous topic :: View next topic
|
Author |
Message |
Nithyasarath
New User
Joined: 30 Aug 2006 Posts: 1
|
|
|
|
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 |
|
|
superk
Global Moderator
Joined: 26 Apr 2004 Posts: 4652 Location: Raleigh, NC, USA
|
|
|
|
Recently asked and answered here. |
|
Back to top |
|
|
twissi
Active User
Joined: 01 Aug 2005 Posts: 105 Location: Somerset, NJ
|
|
|
|
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 |
|
|
Karthik Chandrasekaran
New User
Joined: 21 Aug 2006 Posts: 8
|
|
|
|
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 |
|
|
Karthik Chandrasekaran
New User
Joined: 21 Aug 2006 Posts: 8
|
|
|
|
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 |
|
|
|