Subject: | |
From: | |
Reply To: | |
Date: | Mon, 21 Aug 2000 15:36:41 -0400 |
Content-Type: | text/plain |
Parts/Attachments: |
|
|
Actually there is a ) that is missing. I started out with what we are now using
in production:
!RUN MAIN.PUB.VESOFT,MPEX;PARM=1
LISTF ^KSFILES.group.account &
( (ISKSAM) AND &
(INTCODE > -1 OR INTCODE < -499) AND &
(EOF // FLIMIT) > .8 ),2
and tried to make it simpler for my note to the list. The absence of a test...
===================
Leonard S. Berkowitz
Perot Health Care Systems
(Harvard Pilgrim Health Care account)
voice: 617-509-1212
fax: 617-509-3737
pager: 781-226-2431
Larry Barnes <[log in to unmask]> on 08/21/2000 03:32:21 PM
Please respond to Larry Barnes <[log in to unmask]>
To: [log in to unmask]
cc: (bcc: Leonard Berkowitz/CORP/HPHC)
Subject: Re: [HP3000-L] Flat File Capacity Checking
[log in to unmask] wrote:
> It just so happens that I recently created the following additional step to
our
> regular data-base capacity monitoring:
>
> !RUN MAIN.PUB.VESOFT,MPEX;PARM=1;INFO=&
> ! "LISTF ^KSFILES.PHCDBASE.AMISYS(EOF // FLIMIT) > .8 ),2"
>
> For flat files,
>
> !RUN MAIN.PUB.VESOFT,MPEX;PARM=1;INFO=&
> ! "LISTF @[log in to unmask]@(EOF // FLIMIT) > .8 ),2"
>
>
I tried a version of the above and it didn't show anything when compared to the
first version of the listf command. See below.
listf [log in to unmask](code="KSAM" and eof>flimit*.8),2
MPEX %LISTF [log in to unmask](code="KSAM" and eof>flimit*.8) PAGE 1
LAB,MANAGER.FMTRAIN1,TEST MON, AUG 21, 2000, 12:26 PM
ACCOUNT= FMTRAIN1 GROUP= DATA
FILENAME CODE ------------LOGICAL RECORD----------- ----SPACE---- --DAYS--
SIZE TYP EOF LIMIT R/B SECTORS #X MX ACC MOD
BRTERMS KSAM 38B FA 414 500 13 64 1 4 5 24
BRWCLM KSAM 50B FA 411693 500000 1 81280 2 8 5 5
GROUP TOTAL: 2 FILES 20 MEGABYTES 81344 SECTORS
LISTF [log in to unmask](EOF//FLIMIT) > .8 ),2
I believe there is a misplaced ")" mark in the original equation???
--
Larry Barnes
Director of I.T.
Mitek Corp.
602-438-4545 x1366
Phoenix, AZ 85040
Check Us Out !
http://www.mitekcorp.com
|
|
|