Sum of inactive versions
2003-04-02 12:26:34
Folks,
Management would like to know what kind of impact we would have on the
volume of data we have stored in TSM if we were to lower the retention periods.
They are expecting something like "if we lower the 'retain only version' from
180days to 60 days we will free up X GB of tapes and X GB of database space."
Unfortunately no "what if" tools exist, so I have to build one to accomplish
this.
Anybody gone through this exercise? Have any good queries they'd like
to share?
It looks like I can get a count of all the objects from the BACKUPS
table, but then equating that to volume of data is going to take another table,
although I don't see how to get that at this point.
To take the first whack at this and get a ballpark figure, I thought
I'd at least get a count of all the inactive objects in the database. You think
I should count DIRs and FILEs or just FILES?
This simple query is not working because I'm not getting the state correct.
Anybody know what an ENUMERATED(BACKUPSTATE); value should be? I tried 0 and 1
and that wasn't it. I've tried various quotes and values, but can't seem to get
it.
TSMSERV1A>select * from backups where node_name like 'TSMHOST6' and
filespace_name like '/export/home' and state like INACTIVE_VERSION
ANR2921E The SQL data type of expression 'STATE' is ENUMERATED(BACKUPSTATE);
expecting a character string expression.
|
....................................V..........................
espace_name like '/export/home' and state like INACTIVE_VERSION
Anybody with more SQL experience want to help?
Thanks,
Ben Bullock
Unix Admin
Micron Technology Inc.
Boise ID
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- Sum of inactive versions,
bbullock <=
|
|
|