ADSM-L

Re: Q BA syntax on *nix

2003-02-19 16:58:07
Subject: Re: Q BA syntax on *nix
From: "Prather, Wanda" <Wanda.Prather AT JHUAPL DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 19 Feb 2003 16:57:33 -0500
You can do it this way from the server end -

Select node_name,filespace_name, hl_name,ll_name,state, date(backup_date)
from backups where node_name='XXXXXXXX' and state='ACTIVE_VERSION'

I prefer running it in comma-delimited mode:

Dsmadmc -id=xxxxx -password=yyyyyy -commadelimited "selectstatementfrom
above"

That makes it easy to grep the output, or suck it into EXCEL (if there
aren't too many files for excel)....

(I don't recommend running that query without specifying the node name in
the WHERE clause; the table can be quite large, but it's indexed on
node_name.)

-----Original Message-----
From: Ted Byrne [mailto:tbyrne AT DSSCORP DOT COM]
Sent: Tuesday, February 18, 2003 5:10 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Q BA syntax on *nix


Please feel free to point me to the documentation if I've overlooked
something here, but I'm running into a brick wall...

        Client version 5.1.5.5
        Client OS - AIX 5.1 ML 02
        Server version 5.1.5.4
        Server OS - AIX 5.1 ML 02

I've been asked to produce a list of all current files that are backed up
on two  particular AIX nodes.  Based on the syntax described in the manual,
when logged in as root, I enter the command

        q ba -subdir=y "/*"

expecting to get a list of all files from the "/" directory on
down.  However, what I get appears to be all of the file in the "/"
filespace.  When I enter another FS name in place of the "/*" filespec,
"/u06/*" for example, the files in that filesystem are displayed.

Is there a way to display all files backed up using "q ba"  without
explicitly listing each FS by name in a separate command (for example with
a macro)?

Thanks,

Ted

<Prev in Thread] Current Thread [Next in Thread>