on 07-31-2014 4:05 PM
Hi Team,
I have a doubt , how does HANA handle undo data compared oracle , db6. Oracle like we have the undo tablespaces.
Here is there no requirement to have undo ?
Message was edited by: Tom Flanagan
Hey there 3CPO (or what was the name again? )
As SAP HANA comes with two storage engines for table data, there exist two different ways to keep information required for an UNDO.
For the row store tables, the old data is internally saved in virtual UNDO files and removed after the transaction that created it finished.
For column store tables all data changes are happening in the delta store anyhow. As the delta store is an append-only data structure the old version of records (that's what is required for the UNDO) are present in the main, the delta or in both stores. To perform the UNDO all that's required is to mark those records as 'current' again.
- Lars
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Krishna,
Its worth enough to respond to your post.
If you would have worked on SAP then you would have known what i meant by SAP on hana.
Let me explain for the benefit of other users, i meant was business suite or BW or any other netweaver application.
My query was that how does hana handle undo , provided we are running sap applications on hana.
Responses from you were related to sql editor , now tell me if this is related.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello P517710,
Here is there no requirement to have undo ? ( )
Anyways, If you collectively want to undo the records containing the actions of transactions, then you will have to set the "AUTO COMMIT" flag of the Sql Editor to false.
=> use a simple command called " ROLLBACK; "
Regards,
Krishna
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Looking at the previous question that you have posted i am assuming that you are facing an issue while resetting a node in hana repository.
Check this out:
http://scn.sap.com/thread/3373968
Cheers,
Krishna
User | Count |
---|---|
85 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
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.