TAW_11 Chapter 8, Organization of Database updates Flashcards
Perform on commit occurs when..
when the commit work statement is issued
How can a rollback be initiated from a perform on commit?
type A message
What transaction is used for monitoring update requests
SM13
Update modules contain IMPORTING and EXPORTING?
No, only importing pass by value
How are update modules called from a dialog program?
Call the function module IN UPDATE TASK
How are LUW updates stored?
In VB tables with a VBKEY.
VBDATA and VBMOD, VBHDR after commit
How can FM IN UPDATE TASKS be aborted before commit?
ROLLBACK WORK, Message A or X
If I leave a transaction before commit work but without a rollback or message A or X, what happens to the log entries?
They remain in the VBDATA, VBMOD logs and must be removed later
There are 4 ways to reorg the update logs, what are they?
Directly from SM13
An auto update based on profile parameters
Deleted after ## days based on profile parameter
Scheduled run of RSM13002
What two things cannot be used in an update FM?
Commit work and Rollback work
What is the difference between COMMIT WORK and COMMIT WORK AND WAIT
COMMIT WORK is async COMMIT WORK AND WAIT is sync
During commit work and wait, is the work process retained?
No, it is rolled out
How is a local update initiated?
SET UPDATE TASK LOCAL before the commit
Are local updates written to the VB tables
No
It is best to use LOCAL updates in dialog programs?
No, LOCAL updates should only be used in batch processes because they tie up dialog processes
Are local updates sync or async
sync even though they don’t have a wait
what are the two ways to force a sync update
COMMIT WORK AND WAIT
Or SET UPDATE TASK LOCAL and COMMIT WORK
Can V1 updates be restarted?
Yes
What determines if an update is V1 or V2?
Immediate start is V1, delayed or collective is V2
If V1 fails do V2 requests occur?
No
If no UP2 work requests exist, where do V2 updates run?
UPD
The V2 process always runs without SAP locks?
Correct, locks are released by V1.
Does ABAP have SELECT …FOR UPDATE?
Yes, it locks at the database level.
How can I insure that a DB change is last in the Db LUW
In the update function module add a form with perform on commit. These will always be last
