Home > IT Answers > AS/400 > Check if the file is locked
Cool400
115 pts.
 Check if the file is locked
CL/400, CL/400 File Lock
Hi, How to check in CL that the file is locked. I want to do some operations after checking if the file is locked or not.

Software/Hardware used:
ASKED: May 19, 2009  1:09 PM
UPDATED: March 8, 2011  2:21 PM
RELATED QUESTIONS
Answer Wiki:
Hi, Just try to allocate the file in the CL if it fails, it's already locked. Regards, Wilson =========== Hi, You can use the command ALCOBJ to allocate the file. Regards, Martin Gilbert.
Last Wiki Answer Submitted:  May 19, 2009  1:57 pm  by  philpl1jb   44,150 pts.
All Answer Wiki Contributors:  philpl1jb   44,150 pts. , WilsonAlano   2,385 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Martin Gilbert,

I want to test for a dead lock scenario on a file. for this i used ALCOBJ command with EXCL lock status. But if i go a read operation on the file in COBOL400 pgm its not returning Sqlcode -913. But i want to have a dead lock on file i.e EXCL lock status.

I would be thannkful if u email ur reply to mohankmv@gmail.com.

BeginnerAS400
 10 pts.
 

Was the ALCOBJ command run in the same job that called the SQL program? If so, there was no conflict.

its not returning Sqlcode -913.

If there were two separate jobs, then what happened? What was the SQLCODE?

Finally, just to ensure that all possible details are covered, is it a COBOL/400 or an ILE COBOL program? Which compiler did you use?

Tom

TomLiotta
 108,055 pts.
 

Hi Martin,

Can you give me some safe step for decreasing my ASP in PROD. im using i595 server and i need to decrese my ASP. I already deleted the audit journal and the JOBLOG but still high ASP.

Thanks for your feedback.

Philip/AS400-Phils

Qwerty1234
 10 pts.
 

Check this Redpaper out

HMSSL2K
 3,175 pts.