What are two reasons to run the DB Batch backout utility?
Answers were Sorted based on User's Feedback
Answer / mahesh vasudevan
When the DL/I job abends then it might leave an update that
could be partial...and hence it requires a backout to the
last commit point. To undo the partial update the batch
backout utility is run so that you get a valid checkpoint
from which the job can be restarted with proper parameters
and log tapes.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / jak
1)The utility is used to recover databases to a point before
a program was initiated, or to a checkpoint or sync point.
2)It backs out all updates for all DL/1 data sets performed
in that time period.
That why for batch backout utility we need the job name,PSB.
It is run as a normal IMS batch job and uses the program
specification block (PSB) of the program whose
updates are to be backed out.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / jak
1)The utility is used to recover databases to a point before
a program was initiated, or to a checkpoint or sync point.
2)It backs out all updates for all DL/1 data sets performed
in that time period.
That why for batch backout utility we need the job name,PSB.
It is run as a normal IMS batch job and uses the program
specification block (PSB) of the program whose
updates are to be backed out.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / s
To backout the changes made by the failed job, DBRC=Y
To backout the changed made by a successful job, DBRC=C
| Is This Answer Correct ? | 2 Yes | 2 No |
What are all the possible inputs to the DB recovery utility?
What is the maximum number of levels allowed in ims db?
Can we give the GSAM-PCB in between the DB-PCB'S like below? I/O-PCB DB-PCB1 GSAM-PCB1 GSAM-PCB2 DB-PCB2
What is the maximum number of segment types allowed for a single database?
What is PSB,PCB & ACB?
Explain the advantage of creating the acbs well ahead of time?
Explain the maximum number of fields allowed per segment and what is the maximum number of fields per database?
I am totally confused on IMS message segments. When I create a message and it contains 5 segments does the entire message have a 32k limit or does each segment have a 32k limit? Is there a setting in the stage1 sys gen that defines if a transaction can receive/send multi-segmented messages?
What is the return code you get after a successful IMS call?
My IMS main progam is calling Db2 subroutine ...Its giving - 923 db2 sql code..so could any one tell how to solve this issue.
I found some good questions/answers regarding IMS here:
What are qualified and unqualified SSA's.