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