Page 1 of 1

Difference between DB2 and IMS DB

PostPosted: Sat Oct 06, 2012 9:13 pm
by vandanashastri
Ques1. what is difference between db2 and imsdb. why are you use in the developing new and existing application programming? is it possible to both are use in the same applications-yes or no. if yes than why and how if no than why not? what's feature to use of this application?


Ques2.what is difference between cobol and pl1. why are you use in the developing new and existing application programming? is it possible to both are use in the same applications-yes or no. if yes than why and how if no than why not? what's feature to use of this application?


Ques3.what is difference between cics and vsam. why are you use in the developing new and existing application programming? is it possible to both are use in the same applications-yes or no. if yes than why and how if no than why not? what's feature to use of this application?

Re: Differences

PostPosted: Sat Oct 06, 2012 9:37 pm
by enrico-sorichetti
anything else ?

why not do a bit of reading Yourself

start from
http://www-03.ibm.com/systems/z/os/zos/ ... index.html

and read the general information manual for the <software> You are interested

Re: Difference between db2 and imsdb

PostPosted: Sun Oct 07, 2012 2:57 pm
by NicC
I suggest you read the forum rules FIRST - in particular the first one. Also, it is good etiquette to ask one question per post.

Re: Difference between db2 and imsdb

PostPosted: Mon Oct 08, 2012 8:27 am
by dick scherrer
Hello and welcome to the forum,

Even though this forum is for students and other beginners, there is still the expectation that people who have questions will follow our rather basic rules. . .

Before asking any more "unanswereable" questions, you really need to do a lot of reading or attend some introductory training. All 3 of your "differences" questions are much worse than comparing apples and oranges. These are not questions with actually usable answers.

Other than both are IBM database products, IMS and DB2 are totally different implementations.

Same with COBOL and PL/i - both are compiled programming languages.

Between CICS and VSAM there is not even this much commonality. CICS is a way to process transactions whike VSAM is a data access method.

When you learn more about what it is you want to learn, post back and someone should be able to clarify.

Re: Difference between db2 and imsdb

PostPosted: Fri Oct 12, 2012 12:12 am
by c62ap90
Of course to answer all these question in detail would take too much time but I'll try to answer briefly…

Ques1. what is difference between db2 and imsdb? DB2 is a relational structure database and IMS is a hierarchy structure database.
why are you use in the developing new and existing application programming? I develop in both DB2 and IMS but lately more DB2 since Web applications can use DB2 data directly whereas in IMS you cannot (would need to possibly convert some IMS data to, for example, XML - not recommended).
is it possible to both are use in the same applications-yes or no? Of course. For example, COBOL can read/write to both DB2 and IMS databases in the same program/application.
if yes than why and how if no than why not? what's feature to use of this application? Infinite amount of features!


Ques2.what is difference between cobol and pl1. I have "seen" PL1 and it is very similar to COBOL (both are compiled languages) but I do not know the specific differences. Different syntax and statements used.
why are you use in the developing new and existing application programming? is it possible to both are use in the same applications-yes or no? COBOL and PL1 are different languages so you cannot mix COBOL statements with PL1 and you cannot mix PL1 statements with COBOL statements. You can however run an application (job stream) with both COBOL and PL1 since they both are compiled to a executable load.
if yes than why and how if no than why not? what's feature to use of this application? I'm in a COBOL shop so - we do only COBOL.


Ques3.what is difference between cics and vsam. CICS is a way to display data (VSAM, DB2, IMS/db) and VSAM is a keyed data file.
why are you use in the developing new and existing application programming?
is it possible to both are use in the same applications-yes or no? Yes, VSAM is "data" and CICS displays data.
. if yes than why and how if no than why not? what's feature to use of this application?

Re: Difference between db2 and imsdb

PostPosted: Fri Oct 12, 2012 12:41 am
by Akatsukami
c62ap90 wrote:COBOL and PL1 are different languages so you cannot mix COBOL statements with PL1 and you cannot mix PL1 statements with COBOL statements. You can however run an application (job stream) with both COBOL and PL1 since they both are compiled to a executable load.

I'd note that you cannot include COBOL and PL/I code in the same source module, as a single module must compile under a single compiler*. However, a COBOL routine may call a PL/I routine, and vice versa, in the same load module.

* -- Almost always. I did once see a source module that would compile under both C and FORTRAN; it was an entry in the Obfuscated C Contest :mrgreen:

Re: Difference between db2 and imsdb

PostPosted: Fri Oct 12, 2012 1:14 am
by Robert Sample
PL/I is a block-structured language while COBOL is not.

CICS is an online transaction processing system and teleprocessing monitor wereas VSAM is a file access method for disk files. You cannot really compare the two since they are radically different in design and purpose.

A single application may use DB2, IMS, CICS, VSAM, COBOL, PL/I and many other things you haven't mentioned. Some applications consist of hundreds or thousands of programs using dozens of files and data bases.