Re: Query contents of a filespace?
2003-06-03 11:36:23
You can select from the BACKUPS table.
One of the columns is "filespace_name", so you can restrict your queries to
just the files you are interested in.
E.G.,
select hl_name, ll_name, state, date(backup_date) from backups where
node_name='XXXXXXX' and filespace_name <> 'SYSTEM OBJECT'
The BACKUPS table can be VERY LARGE and queries against it can run a VERY
LONG TIME if your DB is large or your server is slow. It usually works
pretty well for me when restricted to a single node name as in the example
above, because the table is indexed on NODE_NAME.
Wanda Prather
Johns Hopkins University Applied Physics Laboratory
443-778-8769
"Intelligence has much less practical application than you'd think" -
Dilbert/Scott Adams
-----Original Message-----
From: Greg Graves [mailto:gravesgr AT GRAVESWEB DOT COM]
Sent: Tuesday, June 03, 2003 11:06 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Query contents of a filespace?
Quick question: Is there a way to query the contents of a node's
filespace? I want to see what data a particular node has backed up..
--
**********************************************************
Greg Graves
Wesley Chapel, FL Phone: 813-973-2038
gravesgr AT gravesweb DOT com Fax: 586-283-7144
**********************************************************
|
|
|