Re: Active Files
2000-05-24 15:59:11
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 03:59 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
|
|
|