Xmeta roll backs

peep · Post by **peep** » Sun Dec 02, 2012 9:57 pm

IIS 8.7 AIX
we have large num of xmeta roll backs on all servers .
So I tested on a new lpar where DS Enginr is up and still (nt running) there no DS functionality. Dba could see xmeta roll backs .
Any thoughts , suggestions?

Tests:
Stopped dsengine .. Rollbacks occurs
Stopped node agents .. Rollbacks occurred .
With this test I can say xmeta rollbacks are independent with dsengine.

Question:
does WAS has anything to do with Xmeta rollbacks?

ray.wurlod · Post by **ray.wurlod** » Sun Dec 02, 2012 11:29 pm

Only where there are uncommitted transactions.

peep · Post by **peep** » Mon Dec 03, 2012 1:26 am

Thanks for the reply.
Uncommitted transaction I'm sorry can you be little more clear/ detailed .

Xmeta rollbacks has anything to do with web sphere ?
Because all our servers has this xmeta rollback issue.
Does this impact any functional or performance ?

ray.wurlod · Post by **ray.wurlod** » Mon Dec 03, 2012 2:24 pm

Why do you think it's an issue?
Rolling back uncommitted transactions (for example when a session is disconnected) is a perfectly normal part of database operations.

chulett · Post by **chulett** » Mon Dec 03, 2012 6:41 pm

If you are really concerned and want to track down the root cause of this behaviour, involve your official support provider. Afterwards, come back and let us know what you found out.