I should had better explained my reasons for suggesting data base security
could be a factor here.
I was speculating that perhaps the sporadic nature of the problem could in
some way be associated with the event of modifying a dataset capacity in
such a way that the data set security reverts back to a default which
results in a data access error.
I would still suggest releasing the data base security after finding out
what the exact name of the data base root file is.
Incidentally, if Deanna had the MPEX product, she could release
security by simply logging on as manager.sys and,
:mpex
%release [log in to unmask]
%exit
Would still need exclusive access to the data base.
At 08:35 PM 2002-03-13, Tom Emerson wrote:
>Actually, if it is a sporadic error (every 3-6 months), then I doubt it is
>an MPE security problem, but more likely an application security problem --
>MPE security would prevent you from accessing the database ALL the time, not
>once every few months. For a second clue, "Data access error" sounds like
>an application-generated error message, not an MPE error message.
>
>Unfortunately, finding the answer to this involves finding someone who
>helped develop [and hopefully document] your application -- was it written
>"in house", or is it commercially available [i.e., like the
>summit/amisys/etc. software that has been discussed the last few days]? If
>it is a commercial program, it would certainly help to let us know what
>program it is, then perhaps someone else who has the same program can
>provide assistance...
>
>
> > -----Original Message-----
> > From: Gilles Schipper
>
> > You may want to try "release"ing the security on the database.
> > [...]
> >
> > 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.
>[...]
>
>* 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 *
|