VSAM & DB2 Comparion

Ask question on - DataBase Concepts, IBM Mainframe DB2, DB2/UDB, DB2 Tools, SQL , DB2 programming with languages like COBOL, PL1.

Moderators: Kalicharan, Moderator Group

Post Reply
hparthas
Member
Posts: 43
Joined: Thu Oct 21, 2010 11:17 pm

VSAM & DB2 Comparion

Post by hparthas » Thu Jan 13, 2011 10:40 pm

Hi,

I need to load 100 million of records. I need to refer this database based on 3 basic keys from my input file. I need to load 100 million records as this is the first time to load with live data.

Also this database will be refreshed on daily basis. Kindly can some tell me which is best suit to handle this situation, either VSAM or DB2 ?

Any inout would be great !!!!

Thanks !!!!

User avatar
Krishna
Site Admin
Posts: 1052
Joined: Fri Jan 27, 2006 7:50 am

db2 table partitions

Post by Krishna » Fri Jan 14, 2011 2:01 pm

Normally, loading those many records will take more time. Contact your DBA and get how the target table defined, i.e, normally based on table key , they will split the table into partitions. If that is true , get the partition info from DBA. load each partition separately to process the jobs faster.

hparthas
Member
Posts: 43
Joined: Thu Oct 21, 2010 11:17 pm

Post by hparthas » Sun Jan 16, 2011 11:32 pm

Thanks Krishna, but my query was which is better either VSAM or DB2 in terms of performance !!!!

Thanks !!!!

User avatar
Krishna
Site Admin
Posts: 1052
Joined: Fri Jan 27, 2006 7:50 am

Post by Krishna » Mon Jan 17, 2011 3:20 pm

VSAM has some limitations on size, it was 4 GB. It might have increased in recent
times. check this.
DB2 access always take more cost than VSAM file access.

Answer below questions, to give clear picture to other members.

1. Total size of data, based on Record size ( total no of records * total size )
2. No of applications going to use this data concurrently

Anuj Dhawan
Moderator
Posts: 1625
Joined: Sat Aug 09, 2008 9:02 am
Location: Mumbai, India

Post by Anuj Dhawan » Mon Jan 17, 2011 6:05 pm

May be you'd like to start from here: http://www.google.co.in/search?hl=en&so ... vsam+or+db
Regards,
Anuj

Anuj Dhawan
Moderator
Posts: 1625
Joined: Sat Aug 09, 2008 9:02 am
Location: Mumbai, India

Post by Anuj Dhawan » Mon Jan 17, 2011 6:10 pm

As Krishna talks about the size limit of VSAM files - to know more, you might like to start from here VSAM extended addressability.
Regards,
Anuj

hparthas
Member
Posts: 43
Joined: Thu Oct 21, 2010 11:17 pm

Post by hparthas » Mon Jan 17, 2011 8:41 pm

Thanks Krishna and Anuj !!!!

Please find my answers:

1. Total size of data, based on Record size ( total no of records * total size ) - 1 million records and 1300 Record length
2. No of applications going to use this data concurrently - Probably less than 4 jobs will access this database concurrently.

Thanks !!!!

Anuj Dhawan
Moderator
Posts: 1625
Joined: Sat Aug 09, 2008 9:02 am
Location: Mumbai, India

Post by Anuj Dhawan » Tue Jan 18, 2011 3:59 pm

You're welcome. By the way, have you had a chance to look at the links linked in my first post in this thread!?
Regards,
Anuj

User avatar
Krishna
Site Admin
Posts: 1052
Joined: Fri Jan 27, 2006 7:50 am

Post by Krishna » Tue Jan 18, 2011 6:41 pm

Normally, in batch process , for reporting purposes.
many shops use VSAM files to store data. They schedule all jobs in such a way , once VSAM file got created, those jobs will run one after another to generate reports.

If your scenario is similar to what is explained above.. you can go for VSAM.


if your data will be used by production applications, better go for db2 for
better concurrency.

hparthas
Member
Posts: 43
Joined: Thu Oct 21, 2010 11:17 pm

Post by hparthas » Tue Jan 18, 2011 9:43 pm

Thanks a lot, will check and proceed accordingly !!!!

hparthas
Member
Posts: 43
Joined: Thu Oct 21, 2010 11:17 pm

Post by hparthas » Tue Jan 18, 2011 9:43 pm

Thanks a lot, will check and proceed accordingly !!!!

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others