Which DB access method (OSAM or VSAM) is better and why?
Answers were Sorted based on User's Feedback
Answer / s
OSAM is better because with even block sizes you can have a
maximum size of 8 GB for a dataset. OSAM supports
sequential buffering, reads 10 consecutive blocks with one
1 I/O operation. This will reduce the elapsed time by 50%.
It also supports queued writes which also results CPU and
elapsed time savings.
Is This Answer Correct ? | 9 Yes | 0 No |
Answer / john i harper
With IMS HALDBs, OSAM or VSAM can go to 40 terabytes, so
size is no longer a problem. However, OSAM was written by
IMS to do one thing, hold IMS data securely, and move it
quickly. VSAM was written to do many things, making the code
path longer. That increases the time needed to run, and
presents
a greater risk of failure.
Finally, OSAM is written and owned by IMS, so you only have
to ask one development team instead of two if you want any
new features added.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / azharuddin khan
Hi Osam is better becoz we can extend upto 8GB in OSAM
whereas in VSAM its only 4GB.
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / rajasekhar
vsam
later i will give the clear information abt this.
Is This Answer Correct ? | 2 Yes | 2 No |
What are the path calls in imsdb?
what is the maximumm length of account information in job card of a jcl?
What is the difference between SIBLINGS and TWINS in IMS-DB database
What information does a psb contain?
What are the valid recovery points?
When do you do Build DBD, PSB for making changes in ACBLIB?
Can a variable length segment be declared in IMS? If yes, what is the structure; If no, why?
What are the parameters used in CBLTDLI call?
What will happens when a BMP programs takes a checkpoints?
What is dbdgen process?
What is the difference between HDAM & HIDAM DB types and when would you use each?
I have PCB with structure: PCB TYPE=DB, C DBDNAME=EMPCADBD, C KEYLEN=18, C PROCOPT=LS SENSEG NAME=EMPLOYEE, C PARENT=0 SENSEG NAME=COMPDTL, C PARENT=EMPLOYEE SENSEG NAME=BANKDTL, C PARENT=COMPDTL SENSEG NAME=SALDTLS, C PARENT=BANKDTL SENSEG NAME=EDUCDATA, C PARENT=EMPLOYEE SENSEG NAME=EMERDETL, C PARENT=EDUCDATA SENSEG NAME=ADDRESS, C PARENT=EMPLOYEE ************************************************************ *********** PSBGEN PSBNAME=PSBCALDP,LANG=COBOL END Requirement is to Create a report based on Salary brackets. ( Use SSA’s for logic) · It should have CTCGROSS brackets and No of employees o Employee names falling in each bracket Salary < 100,000 No of Employees Employee-Name Level 100,000 < Salary < 300,000 No of Employees Employee-Name Level 300,000 < Salary No of Employees Employee-Name Level