Re: Active Files
2000-05-24 16:16:00
(Sorry about the ugliness of my 1st reply, let me try again.)
Gary, Gerald,
The export node command with preview=yes is much faster.
Here is some text from my server log.
05/24/00 15:50:52 ANR2017I Administrator WFC1450 issued command: EXPORT NODE
wfc1450 filespace=E-
05/24/00 15:50:52 ANR2017I _G200 filed=backupactive p=y
05/24/00 15:50:52 ANR0984I Process 15 for EXPORT NODE started in the BACKGROUND
at 15:50:52.
05/24/00 15:50:52 ANR0610I EXPORT NODE started by WFC1450 as process 15.
05/24/00 15:50:53 ANR0890I EXPORT NODE: Processing optionset MAC1.
05/24/00 15:50:53 ANR0890I EXPORT NODE: Processing optionset PC1.
05/24/00 15:50:53 ANR0890I EXPORT NODE: Processing optionset PC2.
05/24/00 15:50:53 ANR0890I EXPORT NODE: Processing optionset PC3.
05/24/00 15:50:53 ANR0890I EXPORT NODE: Processing optionset TS1.
05/24/00 15:50:53 ANR0890I EXPORT NODE: Processing optionset UNIX1.
05/24/00 15:50:53 ANR0890I EXPORT NODE: Processing optionset UNIX2.
05/24/00 15:50:53 ANR0635I EXPORT NODE: Processing node WFC1450 in domain
CSDL_STANDARD1.
05/24/00 15:50:53 ANR0637I EXPORT NODE: Processing file space E_G200 for node
WFC1450.
05/24/00 15:52:29 ANR0616I EXPORT NODE: Preview processing completed
successfully.
05/24/00 15:52:29 ANR0891I EXPORT NODE: Copied 7 optionset definitions.
05/24/00 15:52:29 ANR0626I EXPORT NODE: Copied 1 node definitions.
05/24/00 15:52:29 ANR0627I EXPORT NODE: Copied 1 file space 0 archive files,
8770 backup files,
05/24/00 15:52:29 ANR0627I and 0 space managed files.
05/24/00 15:52:29 ANR0629I EXPORT NODE: Copied 624884439 bytes of data.
05/24/00 15:52:30 ANR0611I EXPORT NODE started by WFC1450 as process 15 has
ended.
05/24/00 15:52:30 ANR0986I Process 15 for EXPORT NODE running in the BACKGROUND
processed 8779
05/24/00 15:52:30 ANR0986I items for a total of 624,884,439 bytes with a
completion state of
05/24/00 15:52:30 ANR0986I SUCCESS at 15:52:30.
--
--------------------------
--------------------------
Bill Colwell
Bill Colwell
C. S. Draper Lab
Cambridge, Ma.
bcolwell AT draper DOT com
--------------------------
In <F550CB472FA8D31194D300104B757DF384AF1C@AGENCY14>, on 05/24/00
In <F550CB472FA8D31194D300104B757DF384AF1C@AGENCY14>, on 05/24/00
at 04:16 PM, Gary Ison <Gary.Ison AT MAIL.STATE.KY DOT US> said:
>Gerald,
> The following select statement may be what you are looking for. It
>doesn't use the occupancy table, just the backups table. It will count the
>number of active files; the size of the files would have to be computed from
>a cross table select from the contents table where the name is used to match
>them up.
> Select filespace_name, count(ll_name) from backups where
>node_name='NODE-NAME' and
> state='ACTIVE_VERSION'
> Select sum(file_size) from contents where file_name in -
> (select ll_name from backups where
>node_name='NODE-NAME' and state='ACTIVE_VERSION'
>The second query is very long running and hasn't completed my test run yet,
>but the server didn't complain about he syntax. I'm not sure the file name
>match I have specified will work, but it's a place to start from.
> Gary L. Ison
> Governor's Office for Technology
> 101 Cold Harbor Drive
> Frankfort, Ky. 40601
> Phone: (502) 564-8724
> Fax: (502) 564-6856
>E-mail: Gary.Ison AT mail.state.ky DOT us <mailto:Gary.Ison AT mail.state.ky
>DOT us>
>-----Original Message-----
>From: Gerald Wichmann [SMTP:gwichmann AT SANSIA DOT COM]
>Sent: Wednesday, May 24, 2000 12:58 PM
>To: ADSM-L AT VM.MARIST DOT EDU
>Subject: Active Files
>We have a specific desire to be able to query occupancy on only active
>files. That is we would like to know how much data a given node has stored
>on it but only in active files (don't count inactive's in the tally). Anyone
>know if there's a way to do this? Thanks..
>Gerald Wichmann
>RS Engineer
>Sansia System Solutions
>408-844-8893 work
>408-844-9801 fax
|
|
|