Your question relates not just to active and expired versions, but also to inactive versions that are not expired (depending on the number of versions you keep).
For active backup versions: - the STATE column is ACTIVE_VERSION - the DEACTIVATE_DATE is null For inactive (but not expired) versions: - the STATE column is INACTIVE_VERSION - the DEACTIVATE_DATE column is the timestamp when that version became inactive For expired versions: - the STATE column is INACTIVE_VERSION - the DEACTIVATE_DATE column is midnight of 1 January 1900 (1900-01-01 00:00:00.000000) Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. "Good enough" is the enemy of excellence. "ADSM: Dist Stor Manager" <[email protected]> wrote on 2005-03-07 05:53:19: > Hi , > > When I do a select statement q * from backups, it lists all the backup > although some of them has been expired. How do I know, which is the active > backup and which one has been expired. > > Thanks > > NORITA BINTI HASAN > Senior Programmer > Enterprise Systems Services > Information Communication Tech.Div > 6th Floor, Pos Malaysia Berhad > 50670 Kuala Lumpur > > Tel : 03 - 22756638 > > > > Pos Malaysia Berhad is Malaysia's national postal company > Visit us online at www.pos.com.my > > NOTICE > This message may contain privileged and/or confidential > information. If you are not the addressee or authorised > to receive this email, you must not use, copy, disclose > or take any action based on this email. If you have > received this email in error, please advise the sender > immediately by reply e-mail and delete this message. > Pos Malaysia Berhad takes no responsibility for the > contents of this email.
