What does the Change Accum do?1 4665
What are two reasons to run the DB Batch backout utility?4 8189
An application programmer comes to you and says your DB is no good, they got an II status code on an insert call from IMS, is this a DB problem?2 5000
What are all the possible inputs to the DB recovery utility?1 3886
Which DB access method (OSAM or VSAM) is better and why?4 14744
What is Program Isolation?1 5399
how do you invoke an IMS screen (coded in COOOLGEN) from a MQ transaction..... help plz?????1558
What will happens when a BMP programs takes a checkpoints?2 6184
15. Secondary indexes can be used with following databases a. HSAM,HISAM,HIDAM b. HIDAM, HISAM c. HDAM, HISAM, HIDAM d. All the above2 5599
What are the special considerations of the PROCOPT field based on the type of operation your program performs3 5590
Which command code can be used for backing up IMS database?6 6844
Can a variable length segment be declared in IMS? If yes, what is the structure; If no, why?2 6458
What are the ways to mapping external control block? a. ENTRY b. PROCEDURE DIVISION USING c. CALL ‘DLITCBL’ d. ALL ABOVE e. A & B
Write the format of program starting from identification division for checkpoint restart logic.1 5991
How many root segments do we have per database record?
Explain the maximum number of pcbs allowed in a psb?
Explain the advantage of creating the acbs well ahead of time?
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 ims (db/dc)?
Explain the maximum number of levels allowed in ims db?
What is the advantage of creating the acbs well ahead of time?
Explain ims software environment?
Explain the maximum number of segment types allowed for a single database?
Portfolio analysis application is an example of?
What is mpp mode?
What is batch dl/i mode?
Explain the maximum of key fields and search fields allowed in a segment?
What is the maximum number of segment types allowed for a single database?