Interested to Buy Any Domain ? << Click Here >> for more details...
What is check pointing, sync point?
- 3 Answers
- 15797 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / pranav
Checkpoint is synonymous to Sync point, commit point or
point of integrity. Whenever a checkpoint is issued all the
records are committed and after a checkpoint system is in a
stable state. A checkpoint record entry is written to the
Log file and also generates a checkpoint ID which is used
for restarting the job from a particular checkpoint.
Database changes before the most recent checkpoint are not
reversed by backward recovery.
Database changes logged after the most recent checkpoint are
not applied to an image copy of the database during forward
recovery.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / srikar
check point is the one which will holds the last abended
record address,so that when ever the job got abended we can
restart the job from the abended record with using the
check point.
sync point is nothing but a commit if you issue a sync
point after 100 records,those 100 records will be committed
after that if at all job got abended
| Is This Answer Correct ? | 9 Yes | 4 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 key field in an IMS database?
Static & Dynamic PSB
Explain the maximum of key fields and search fields allowed in a segment?
Define pcb?
What is mpp mode?
How do you write a PSB code ?
Define the terms Parent & Child.
What is the maximum number of pcbs allowed in a psb?
Is it necessary that all the segments in a Dl/i database have key fields ?
Looking for mainframes IMS DB training @ 9912598882
What are Twins?
COBOL 
