VSAM & DB2 Comparion
Moderators: Kalicharan, Moderator Group
VSAM & DB2 Comparion
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 !!!!
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
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.
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
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
-
- Moderator
- Posts: 1625
- Joined: Sat Aug 09, 2008 9:02 am
- Location: Mumbai, India
May be you'd like to start from here: http://www.google.co.in/search?hl=en&so ... vsam+or+db
Regards,
Anuj
Anuj
-
- Moderator
- Posts: 1625
- Joined: Sat Aug 09, 2008 9:02 am
- Location: Mumbai, India
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
Anuj
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 !!!!
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 !!!!
-
- Moderator
- Posts: 1625
- Joined: Sat Aug 09, 2008 9:02 am
- Location: Mumbai, India
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.
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.
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
- Cobol Interview Questions
50+ Interview Questions - JCL Interview Questions
50+ Interview Questions - DB2 Interview Questions
100+ Interview Questions - CICS Interview Questions
70+ Interview Questions - VSAM Interview Questions
27 Interview Questions
Other References
Mainframe Tools and others
- XPEDITER Reference
Explains how we can debug a program - FILEAID Reference
Explains how to browse , edit and delete datasets - Change Man Reference
Quick Start tutorial on Changeman - Abend Reference
Important Abend codes explained - FaceBook Page
MainframeGurukul FaceBook Page - LinkedIn Page
MainframeGurkul Linkedin Page