on 02-23-2015 8:23 PM
Hi Team,
Wanted to know, if suppose i cancel a job. Wanted to know if we can monitor the rollback progress. Undo data is stored in the data volumes but wanted to track it if its possible.
Has anyone tried to monitor the rollback area in hana?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Folks,
Has anyone tried to attempt track the rollback progress.
Suppose i have a job running in SAP, i cancel it sql trace is the only option i see for tracking rollback progress. That too i cannot properly see it.
How much data has been rolled back or else what sql query was being run.
Mechanism of rollback is still kind of abstract to me.
Martin,
Thanks so much for the response and thank you for making an exception.
The question is like this, how are we managing undo and then rollback of that data.
How does it work in HANA. we would love to know more about the control flow as to how it works in SAP HANA.
Now in db2 we can use "db2 get snapshot for all applications global" and then track the rollback progress.
Roughly speaking the following happens during a rollback in SAP HANA environments:
"In case a transaction is rolled back, write locks are released and transaction-specific change information of the consistent view manager is deleted. The versions remain in delta storage until the next merge operation but they will not be visible for any transaction."
So compared to other databases the rollback work is minor with SAP HANA due to the delta storage concept. Uncommitted data is never merged into the main and so we are sure that a rollback never has to touch the typically large main storage.
Martin,
Thanks so much for the insight. Dont you think this is an area which is kind of greyish and not much documentation has been mentioned. Here in DB2 whenever we see rollbacks we get the alerts related to log full situations. Wanted to understand in depth of the control flow as to how it happens in HANA.
just to recap as to what i have understood. We have the main and delta , during an update and delta gets updated and if a savepoint gets triggered then its written to the disk.
Now if we want to rollback then it gets rolled back from delta portion of the data and the next savepoint will change it on the disk as well right martin.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.