×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Check whether the RUNSQLSTMT is Performance unser commitment control or not.Birgitta
Von meinem Samsung Gerät gesendet.
-------- Ursprüngliche Nachricht --------
Von: "James H. H. Lampert" <jamesl@xxxxxxxxxxxxxxxxx>
Datum: 08.10.2016 03:39 (GMT+01:00)
An: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Betreff: Locked and yet not locked . . . .
This is weird.
I've got a CL program that runs RUNSQLSTM on a member containing code to
generate a view with the same name as the member. And at the end, to
ensure that the view has the same authorities as its based-on PF, I've
got the statement:
GRTOBJAUT OBJ(&LIB/&MBRNAME) OBJTYPE(*FILE) +
REFOBJ(&LIB/&PFNAME)
where &LIB is the library, &MBRNAME is the name of both the member and
the SQL View that member generates, and &PFNAME is the name of the
based-on PF.
The program has been in service for years, and this particular statement
for a year and a half, without any problems.
And yet recently, it's been going into a lock wait, and then throwing a
chain of exceptions:
File FOO in library BAR in use.
Function not done for user profile BAZ.
One or more errors occurred during processing of command.
CPF2227 received by PLUGH at 7500. (C D I R)
(FOO being the SQL View we just created) And yet, WRKOBJLCK doesn't find
any locks on FOO.
Anybody have any idea what could cause that?
--
JHHL
midrange.com
