IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Compare DB2 on Z/OS and DB2 on LUW.


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
deepag02

New User


Joined: 23 Jul 2007
Posts: 20
Location: India

PostPosted: Mon Jan 24, 2011 9:43 am
Reply with quote

Hello,

I am trying to find out what should be the deciding factor to use DB2 on Z/OS or on LUW. What are the advantages and disadvantages of using either. Tried googling also not much luck :-(
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Mon Jan 24, 2011 10:01 am
Reply with quote

Hello,

Possibly not much luck because of the approach being used. . .

Usually a strategic direction is determined as to which platform is to be used first. Then options on that patform are considered.

I have not yet been involved with a selection decision that was based on picking some version of some product and from that choosing the platform/tier.

Maybe there is something i misunderstand. . .

Also, no one "outside" can tell you the advantages of one over another. What might be an advantage to someone else could be a disadvantage to your requirements.
Back to top
View user's profile Send private message
deepag02

New User


Joined: 23 Jul 2007
Posts: 20
Location: India

PostPosted: Mon Jan 24, 2011 11:18 am
Reply with quote

Thanks Dick,

Keeping in mind that the desicion will be based on the platform, what if the volume and process are desiding factors.
For e.g the amount of volume, security aspects, process such as Batch and OLTP how should one take a call?

I am trying to come up with basic differences between them and why and when one would go for either of it.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Mon Jan 24, 2011 11:46 am
Reply with quote

Hello,

Quote:
what if the volume and process are desiding factors. For e.g the amount of volume, security aspects, process such as Batch and OLTP how should one take a call?

They often are. . . This is why the platform is decided first. . . A platform that can carry the load needs to be used regardless of the attraction of some particular product feature (unless there is some really bad management on the loose icon_smile.gif ).

Quote:
I am trying to come up with basic differences between them and why and when one would go for either of it.

If the decision is to use some flavor of db2, then once the platform is selected, the flavor will already be determined.

And (repeating fwiw) - this is not the way i've seen organizations operate.

This sounds more like a class exercise that the material has already been presented to help the students "decide".
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India

PostPosted: Mon Jan 24, 2011 2:49 pm
Reply with quote

There are significant differences at the database administration level, but the DML (select, insert, update, and delete) is very similar and getting closer with each new release. The biggest problem is learning the operating systems. If the person is proficient in z/OS (JCL, TSO, etc) and proficient in Linux/UNIX, then it will not be hard to learn the differences in the database products.

Here is some more: db2news.wordpress.com/2010/01/31/db2-for-luw-and-db2-for-zos-are-converging/
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Compare two files with a key and writ... SYNCSORT 3
No new posts Compare latest 2 rows of a table usin... DB2 1
No new posts How to compare two rows of same table DB2 11
This topic is locked: you cannot edit posts or make replies. Compare files with duplicates in one ... DFSORT/ICETOOL 11
Search our Forums:

Back to Top