What is check pointing, sync point?
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 |
What is the need of a secondary index in IMS?
I have PCB with structure: PCB TYPE=DB, C DBDNAME=EMPCADBD, C KEYLEN=18, C PROCOPT=LS SENSEG NAME=EMPLOYEE, C PARENT=0 SENSEG NAME=COMPDTL, C PARENT=EMPLOYEE SENSEG NAME=BANKDTL, C PARENT=COMPDTL SENSEG NAME=SALDTLS, C PARENT=BANKDTL SENSEG NAME=EDUCDATA, C PARENT=EMPLOYEE SENSEG NAME=EMERDETL, C PARENT=EDUCDATA SENSEG NAME=ADDRESS, C PARENT=EMPLOYEE ************************************************************ *********** PSBGEN PSBNAME=PSBCALDP,LANG=COBOL END Requirement is to Create a report based on Salary brackets. ( Use SSA’s for logic) · It should have CTCGROSS brackets and No of employees o Employee names falling in each bracket Salary < 100,000 No of Employees Employee-Name Level 100,000 < Salary < 300,000 No of Employees Employee-Name Level 300,000 < Salary No of Employees Employee-Name Level
What type of pointers should you specify on the root segment of a HIDAM DB to improve sequential processing?
What do you mean by hierarchical database?
What are the valid recovery points?
Which is the DL/I function used in CICS-IMS program?
What is the maximum number of segment types allowed for a single database?
What is the limitation on the no. of levels in a DL/I database?
What are the parameters used in CBLTDLI call?
What will happens when a BMP programs takes a checkpoints?
Which DB access method (OSAM or VSAM) is better and why?
Explain the advantage of creating the acbs well ahead of time?