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
 
Compare DB2 on Z/OS and DB2 on LUW.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: Compare DB2 on Z/OS and DB2 on LUW.
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

Site Director


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

PostPosted: Mon Jan 24, 2011 10:01 am    Post subject:
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    Post subject: Reply to: Compare DB2 on Z/OS and DB2 on LUW.
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

Site Director


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

PostPosted: Mon Jan 24, 2011 11:46 am    Post subject:
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

Senior Member


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

PostPosted: Mon Jan 24, 2011 2:49 pm    Post subject:
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: http://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    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 File Aid tool to compare numeric data balaji81_k Compuware & Other Tools 2 Tue Sep 26, 2017 3:35 am
No new posts Compare yesterday's date to the one o... migusd SYNCSORT 11 Fri Sep 22, 2017 11:35 pm
No new posts compare 2 rows within the same file ram_vizag SYNCSORT 7 Wed Jun 14, 2017 12:34 am
No new posts member list compare jzhardy TSO/ISPF 6 Fri May 12, 2017 3:18 pm
No new posts Compare two files and subtract values ameetmund DFSORT/ICETOOL 7 Fri Mar 31, 2017 3:35 pm

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