Conference ilbbak::ibi_focus

212.0. "Focus creating file rather than reading!" by SALEM::ESTES () Tue May 16 1989 16:11

							FOCUS_PROB.TXT

We have a Focus environment for snapshot reporting and under the following 
conditions Focus will CREATE a 0 block focus file rather than reading 
the focus file.  Some Snapshot!

        Master (.mas) on Disk 1
	AND Focus file (.foc) on Disk 2
	AND Disk 2 has quota's disabled (or permitted for user)
	AND Focus database is identified by foc$dir logical 
	AND foc$dir logical is a Searchlist of logical areas 
	AND the database is in the first logical area mentioned in the 
	    searchlist (not master)
	AND the ACL database directory permits the user to Read and Write 
	    within the directory
	AND the ACL on the Focus file permits the user read priv only
	AND privs for user and priv's are identified by acl protection
	    (not UIC based protection)

Seems like a lot of conditions BUT that the way it was! A work around
to this problem is to move any files that need read/write access to another
directory and set the Focus snapshot directory to read only.

A log illustrating this problem is attached

PATSPK-STU$ @FOCUS_TEST
$ ! FOCUS_TEST.COM - SETUP FOR SIMULATION OF FOCUS PROBLEM 
$ !                  FOC$DIR% AS SEARCH LIST WITH LOGICALS 
$ !                  FOCUS DATA BASE WITH LESS SEC THAN UPPER LEVEL DIRECTORY
$ ! 
$ ! FOCUS SEEMS TO TAKE PROTECTION FROM DIRECTORY AND IF THE FILE HAS 
$ !       LESS THAN CREATE A NEW FILE
$ 
$  ! 
$ DEFINE PRO$TST $3$DUS1:[FOCUS_TEST]		! DB IS HERE
$ DEFINE PRO$TST1 USER$DISK9:[STUESTES.WRK] 	! MASTER FILE IS HERE
$ ! SHOULD PERMIT MY GROUP TO RWED
$ DIR/SEC $3$DUS1:[0,0]FOCUS_TEST.DIR

Directory $3$DUS1:[000,000]

FOCUS_TEST.DIR;1     [1,1]                 (RWE,RWE,RWED,E)
          (IDENTIFIER=[ISE,*],ACCESS=READ+WRITE+DELETE)

Total of 1 file.
$ ! SHOULD PERMIT ME TO R ONLY
$ DIR/SEC PRO$TST:DDCT.*

Directory $3$DUS1:[FOCUS_TEST]

DDCT.FOC;135            888  [1,1]                 (RWED,RWED,R,)
          (IDENTIFIER=[ISE,ESTES],ACCESS=READ)
DDCT.FOC_SAVE;1    no privilege for attempted operation

Total of 2 files.
$ 
$ ! NOW SET THE DB FIRST IN LOGICAL AS A SEARCHLIST
$ ! DB IN 1ST, MAS IN SEC AND ON DIFF DISKS
$
$ DEFINE FOC$DIR1 PRO$TST,PRO$TST1
$ 
$ ! NOW IF YOU RUN FOCUS AND TABLE FILE DDCT IT WILL FAIL AND CREATE A NEW
$ ! VERSION OF THE FILE AT ZERO BLOCKS, IF QUOTA PERMITS
$
$ FOCUS
FOCUS  5.2     VX5.2.1 CREATED 01/03/89
(C)Copyright 1988 Information Builders Inc.
>

TABLE FILE DDCT
%RMS-E-EOF, end of file detected
ERROR READING PAGE     1 FILE FOC$DIR1:DDCT.FOC
%NONAME-W-NOMSG, Message number 00000000
QUIT
FIN
%DCL-W-SKPDAT, image data (records not beginning with "$") ignored
$ ! 
$ DIR/SEC/SIZE  PRO$TST:DDCT.*

Directory $3$DUS1:[FOCUS_TEST]

DDCT.FOC;136              0  [ISE,ESTES]           (RWED,RWED,R,)
          (IDENTIFIER=[ISE,ESTES],ACCESS=READ)
DDCT.FOC;135            888  [1,1]                 (RWED,RWED,R,)
          (IDENTIFIER=[ISE,ESTES],ACCESS=READ)
DDCT.FOC_SAVE;1    no privilege for attempted operation

Total of 3 files, 888 blocks.
$
PATSPK-STU$