Answer / guest

Secondary Index is used when we need to
* Access the IMS Database in an order other than its
primary hierarchical sequence
* Access a segment in the database directly without
supplying its complete concatenated key

Answer / david

I might add that batch processing thru a secondary index is
extremely slow with many IOs. It is best used in an online
transaction when just one record is being processed at a time.

Answer / sukanthi

Secondary indexes are based on any field (unique or non-
unique) in a IMS database. It provides for different
processing requirements other than the primary index key
sequence.

Answer / meenal

secondary indexing means accessing a segment in different
ways... using different primary keys..

Which DB access method (OSAM or VSAM) is better and why?

4 Answers  

---

What is the advantage of dynamic generation of acb?

0 Answers  

---

Explain acbgen process?

0 Answers  

---

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

1 Answers   Accenture,

---

What is a segment?

5 Answers  

---

What is check pointing, sync point?

3 Answers  

---

What are the path calls in imsdb?

2 Answers  

---

I have a PSB which contains 3 PCB, how to write it ? please..

5 Answers   EDS,

---

Which command code can be used for backing up IMS database?

6 Answers  

---

I am totally confused on IMS message segments. When I create a message and it contains 5 segments does the entire message have a 32k limit or does each segment have a 32k limit? Is there a setting in the stage1 sys gen that defines if a transaction can receive/send multi-segmented messages?

1 Answers  

---

Explain the advantage of creating the acbs well ahead of time?

0 Answers  

---

When do you do Build DBD, PSB for making changes in ACBLIB?

1 Answers  

---