ADSM-L

Re: Active Files

2000-05-24 16:16:00
Subject: Re: Active Files
From: Bill Colwell <bcolwell AT DRAPER DOT COM>
Date: Wed, 24 May 2000 16:16:00 -0400
(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
<Prev in Thread] Current Thread [Next in Thread>