Is there a way by which we can know the progress of the Rollback
process. The rollback process on my machine is running for the past 24
hrs. I am not sure whether the process is actually running or hanging.
Using nmon tool on my AIX box I can see the db2 process 'db2sysc'
running but it would be better if I can know the progress of RollBack.
There are no other applications running on the machine.
Is it normal for RollBack to continue for 24 hrs.
We had to "db2stop force" yesterday (which in turn induced this RollBack
process) when one of our applications occupied the whole of transaction
log file (20 GB size) and killing that application did not work. There
are no errors in db2diag.log
-----Original Message-----
From: Yennaram Kondal [mailto:[Email address protected]
Sent: Monday, August 29, 2005 8:55 PM
To: Divakar Goel (WT01 - Technology,Media,Transportation&Services)
Subject: RE: db2stop force
**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email, **and removed
any attachments, and kept your email address secret **from this person,
and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal **Anything below this line is the original email text
I think it's doing rollback, I would not do anything because even if you
stop it, when you restart it has to go through crash recovery and
rollback.
It's very normal depends on how long your transaction has been running.
Regards,
Kondal R YENNARAM
The Home Depot
-----Original Message-----
From: divakar
[Email address protected]
Sent: Monday, August 29, 2005 10:14 AM
To: LazyDBA Discussion
Subject: db2stop force
Our DB2 transaction Log File was full. We tried to kill the application
that was responsible for it. But even after using DB2 force applications
all' several times the application was still running. Lastly we tried
'd2stop force'. It has been more than 1.5 hours but the command('d2stop
force') is still executing. Is it normal?
While it is still running NO errors has been reported in db2diag.log.
Our Log File size is almost 20GB.
Environment DB2 8.2 / AIX.
Divakar
Confidentiality Notice
The information contained in this electronic message and any attachments
to this message are intended for the exclusive use of the addressee(s)
and may contain confidential or privileged information. If you are not
the intended recipient, please notify the sender at Wipro or [Email
address protected] immediately and destroy all copies of this message
and any attachments.
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Confidentiality Notice
The information contained in this electronic message and any attachments to this message are intended
for the exclusive use of the addressee(s) and may contain confidential or privileged information. If
you are not the intended recipient, please notify the sender at Wipro or [Email address protected] immediately
and destroy all copies of this message and any attachments.
DB2 & UDB email list listserv db2-l LazyDBA home page