What type of pointers should you specify on the root
segment of a HIDAM DB to improve sequential processing?
Answers were Sorted based on User's Feedback
Answer / s
PTR=TB to suppress the RAPS to improve sequential
processing.
If PTR=T or PTR=H is specified, only RAP is created per
CI/block and the RAP points to the last root segment
inserted and the hierarchic or physical twin pointers will
point to the previous root segment inserted and the
hierarchic or TF pointer in the first root is set to zero.
This means that the HIDAM index has to used to process
roots sequentially as the pointer from one root to another
cannot be used.
| Is This Answer Correct ? | 0 Yes | 0 No |
How can we distinguish between an online and batch program in IMS environment?
What are all the possible inputs to the DB recovery utility?
What is the maximum number of fields allowed per segment and what is the maximum number of fields per database?
What information does a psb contain?
How to write the PCB code ? if in thic PCB i have 3 PSB ?
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.
When do you do Build DBD, PSB for making changes in ACBLIB?
What are common status codes that you come across?
What are the special considerations of the PROCOPT field based on the type of operation your program performs
what are the control blocks in IMS ?
What are the command codes and their purposes?
what is the use of ENTRY in IMS?