What is secondary indexing?
Answers were Sorted based on User's Feedback
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
| Is This Answer Correct ? | 16 Yes | 3 No |
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.
| Is This Answer Correct ? | 3 Yes | 0 No |
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.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / meenal
secondary indexing means accessing a segment in different
ways... using different primary keys..
| Is This Answer Correct ? | 3 Yes | 3 No |
Explain the maximum number of levels allowed in ims db?
What is a database record?
which is the first statement in COBOL-IMS programs?
How man key fields and search fields can a segment have?
How many sgment types can u have in a DL/I database?
Define DBD?
I found some good questions/answers regarding IMS here:
Which is the DL/I function used in CICS-IMS program? IBM
Explain the maximum number of fields allowed per segment and what is the maximum number of fields per database?
What is dbdgen process?
What is a Segment type?
What is difference between concurrent image copy and online image copy?