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.
===========================================================================================

DB2 & UDB email list listserv db2-l LazyDBA home page