I'm not sure if its fixed in fix pack 6 either.
"Rai Amit "
<db2udbdba-ezmlms
hield-x57554969.x To
[Email Address Removed] "LazyDBA Discussion"
a.com> <[Email address protected]
cc
02/24/2005 04:27
PM Subject
RE: Application ID holding oldest
Transaction
Check this APAR in V8 related to application ID holding the oldest
transaction log in DB snapshot.
http://www-1.ibm.com/support/docview.wss?rs=71&context=SSEPGG&dc=DB520&dc=D600&dc=DB530&dc=D700&dc=DB500&dc=DB540&dc=DB510&dc=DB550&q1=application+holding+oldest+log&uid=swg1IY54968&loc=en_US&cs=utf-8&lang=en
Amit Rai.
-----Original Message-----
From: henrysteinhauer
[mailto:db2udbdba-ezmlmshield-x80906230.[Email address protected]
Sent: Thursday, February 24, 2005 3:32 PM
To: LazyDBA Discussion
Subject: Application ID holding oldest Transaction
I see this in the Database Snapshot -
Just what does it really mean ?
It stays the same for long periods of time .
- We are taking snapshots every 5 minutes for tracking purposes and I am
seeing this value stay the same for many days at a time.
The Doc says something about this being a transaction that still has an
uncommited activity.
I thought there is a way to time these out so they do not last for many
many hours.
Is there a way ?
Henry Steinhauer
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
-------------------------------------------------------------------------------------------
***National City made the following annotations
-------------------------------------------------------------------------------------------
This communication is a confidential and proprietary business
communication. It is intended solely for the use of the designated
recipient(s). If this communication is received in error, please contact
the sender and delete this communication.
===========================================================================================
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
DB2 & UDB email list listserv db2-l LazyDBA home page