What is secondary indexing?
- 4 Answers
- 15576 Views
- I also Faced
- E-Mail Answers
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 |
how to create a changeman read only audit and update only audit Specifications for the Read only Audit 1) Read HFFD database unqualified. 2) Read FDRT, FDDM, FDAP segments. If FDAP-APP-STS is ‘2’ read the FDAV segment and get the FDAV segment which has FDAV-APV-OPTION as ‘X’ If FDAP-APP-STS is ‘5’ read the HFAC database. Read the ACRT segment qualified based on the key obtained from the FDAP segment from HFFD database. Conditions for writing into output file: a. App Type should be NEWR b. App Status should be 1, 2 & 5. c. Write 50 records per app status. For e.g. first 50 records for App status 1, 2 & 5 each The output file should contain the following fields from the database FDRT-COMP-CTRY-CODE X(03). FDRT-CUST-ID-NUM X(10) FDDM-DEM-SEQ-NUM X(01) FDAP-APP-SEQ X(02) FDAP-JNT-IND X(01) FDAP-APP-STS X(01) FDAV-APV-OPTION X(01) FDAV-APV-DT X(06) FDAV-APV-AMT X(07) ACRT-ACCT-NUM X(06) ACRT-SEG-BUS-TYPE X(02) ACRT-NM1-LAST X(19) ACRT-NM1-SS X(09) ACRT-NM1-1ST X(12) ACRT-NM1-INIT X(01) ACRT-NM1-SFX X(03) ACRT-NM1-TITLE X(02) PSB – DVAN2BMP In case you get a GE for any of the conditions, write to output file along with the details of the database segment which was not found. We need to complete this whole process by tomorrow. Run the audit in DLI mode. 2) Sort the output file created in step 1 on Cust ID, Dem Seq & App Seq. Specifications for the Update Audit 3) Take the output of step 2 as input for an update audit. Details are as follows: Read each record & check the app status. If app status is less than 2 then update the FDAP-NEW- MONEY-ENT to $25000.00 PSB - AUDBMPJ The job would be a BMP job. The test job would be run in IMSE region. Note - The proc (which will be called by the job) and the job should also be present in the change-man package itself. You’ll have a test job in your PDS along with overrides to execute the program in test regions. The job would be a DLI job. The test job would be run in IMSE region. It’ll have the following steps. 1) Delete-define output and error files. 2) Use a copybook for the output layout.
What is a Hierarchy path?
Explain acbgen process?
What is bmp mode?
What are the valid recovery points?
Can a variable length segment be declared in IMS? If yes, what is the structure; If no, why?
What is PSB,PCB & ACB?
I have a PSB which contains 3 PCB, how to write it ? please..
This question regarding Checkpoint. Suppose my program has checkpoint for every 100 records. If my program abends at 120 records, what will happen. I know first 100 records are committed and rest of 20 records where they gone and where they are stored.
What is difference between concurrent image copy and online image copy?
Write the format of program starting from identification division for checkpoint restart logic.
What are common status codes that you come across?
COBOL 
