Which DB access method (OSAM or VSAM) is used for primary
index or secondary index and why?
Answer / s
VSAM is used for primary or secondary index because the
data need to stored in key sequence datasets.
| Is This Answer Correct ? | 2 Yes | 0 No |
What is an ims database?
Which command code can be used for backing up IMS database?
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
What is multi positioning ?
What is secondary indexing?
What are the valid recovery points?
What is batch dl/i mode?
What are the processing modes available in ims db?
What are the two types of fields available in ims db?
How man key fields and search fields can a segment have?
Explain the maximum of key fields and search fields allowed in a segment?
What is the maximum number of pcbs allowed in a psb?