Page 1 of 1

VSAM & DB2 Comparion

Posted: Thu Jan 13, 2011 10:40 pm
by hparthas
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 !!!!

db2 table partitions

Posted: Fri Jan 14, 2011 2:01 pm
by Krishna
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.

Posted: Sun Jan 16, 2011 11:32 pm
by hparthas
Thanks Krishna, but my query was which is better either VSAM or DB2 in terms of performance !!!!

Thanks !!!!

Posted: Mon Jan 17, 2011 3:20 pm
by Krishna
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

Posted: Mon Jan 17, 2011 6:05 pm
by Anuj Dhawan
May be you'd like to start from here: http://www.google.co.in/search?hl=en&so ... vsam+or+db

Posted: Mon Jan 17, 2011 6:10 pm
by Anuj Dhawan
As Krishna talks about the size limit of VSAM files - to know more, you might like to start from here VSAM extended addressability.

Posted: Mon Jan 17, 2011 8:41 pm
by hparthas
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 !!!!

Posted: Tue Jan 18, 2011 3:59 pm
by Anuj Dhawan
You're welcome. By the way, have you had a chance to look at the links linked in my first post in this thread!?

Posted: Tue Jan 18, 2011 6:41 pm
by Krishna
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.

Posted: Tue Jan 18, 2011 9:43 pm
by hparthas
Thanks a lot, will check and proceed accordingly !!!!

Posted: Tue Jan 18, 2011 9:43 pm
by hparthas
Thanks a lot, will check and proceed accordingly !!!!