hi

in V 8 for snapshot of db we get a option
Appl id holding the oldest transaction

i m not able to get this details version 9.5 ?? is there an alternative to it

DB21085I Instance "vatprod" uses "64" bits and DB2 code release "SQL09055"
with level identifier "06060107".
Informational tokens are "DB2 v9.5.0.5", "s091123", "U829462", and Fix Pack
"5".
Product is installed at "/opt/IBM/dwe/db2/V9.5/fp5"

Kindly suggest
regds
Paul

Hi,

it's still there, but there has to be an open transaction. Otherwise it's not shown.