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/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com
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" <ADSM-L AT VM.MARIST DOT EDU> 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.
|
