You may want to try "release"ing the security on the database.
To do so, you need to have exclusive access to the data base, log on as
it's creator, then do as follows:
:reset @ (to ensure no file equations set for data base)
:dbutil
release TK
exit
To find out who the creator of the data base is, log on as manager.sys, and
:listf tk.dataaf.truck,-3 (I'm assuming that your database is in the same
account as your dictionary)
That may be worth a try.
At 07:31 PM 2002-03-13, Deanna Cusic wrote:
>Thank you all for help with query. I now know that it is not full now
>I have to figure out why I am getting the 'Data Access Error'.
>
>I understand that it is usually caused by security errors but nothing
>has been done with the security in years but the system seems to mess up
>every 3-6 months. In the past I have done a subfile and it has fixed the
>problem, but I would like to know what the real problem is.
>
> ITEM CURRENT ENTRY ENTRY BLOCKING
>SETS: TYPE COUNT CAPACITY COUNT LENGTH FACTOR
>
> DEST D 19 59529 24544
>136 3
> PRODUCT D 19 114300 22042 69
>6
>
>These are the two files I am having problems with.
>"Deanna Cusic" <[log in to unmask]> wrote in message
>news:u8vmc1dppvvica@corp.supernews.com...
> > F I L E R E P O R T
> > For DICTIONARY: TKSCHMAC.DIC.TRUCK
> > File: DEST
> > Organization: DETAIL
> > Type: TURBOIMAGE
> > Open: DEST of TK.DATAAFF
> > Capacity: 59528 Records
> > Crit. Item Update: No
> > Records & Sizes: DEST 272 bytes
> >
> >
> > Some of you have helped me before and THANK YOU. But here I am again.
> >
> > I am soooooo confused the users keep getting a Data access error when
>trying
> > to update anything to the file. This problem seems to happen about every
> > 3-6 months and I subfile for later but I have subfiled all that they do
>not
> > need at the moment so I need to come up with some other fix. I need to
>see
> > if my file is full and I do not know how. I am a programmer that is now
> > doing a system admin job. There is only one system left on the HP and
>that
> > is why they do not want to spend much on it. None of the systems are even
> > on maint. contracts anymore.
> >
> >
> > --
> > Deanna Cusic
> > Nampa, Idaho
> > Powerhouse Programmer
> > (208)230-1593
> >
> >
>
>* To join/leave the list, search archives, change list settings, *
>* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
-------------------------------------------------------------------------------------------------
Gilles Schipper
GSA Inc.
HP System Administration Specialists
300 John Street, Box 87651 Thornhill, ON Canada L3T 7R4
Voice: 905.889.3000 Fax: 905.889.3001
email: [log in to unmask] web: http://www.gsainc.com
-------------------------------------------------------------------------------------------------
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|