6 replies to this topic

[luwapula]

Hie guys

I have a problem of one of my update funct that locks the file .

Iam using proiv version 4.0 running on unix platform and the file is an indexed file (cisam). It locks after reading the first oo record record.

Pliz assist.

regards

bp

[Mike Nicholson]

Hi

I think you're going to have to clarify your problem a bit first.

Is it that the whole file is getting locked? Specific records? What's happening that you don't think should be?

FYI: A CISAM file will get the records locked as soon as you have read them in any mode other then 'L'ookup. The lock won't be released until the file write has completed.

Cheers

Mike

[luwapula]

IT is an update function the first record before the file is writen to is locked at after read no error and how then can i make my funct procced?

b luwapula

[Mike Nicholson]

You mean that the update stops and waits with a 'RECORD LOCKED' message?

If that is the case then there is another function (probably a screen if the record isn't being released) which has that record open. You will need to find out which process that is and get the user to come out (or kill it if necessary and you feel it is safe).

[luwapula]

It just freezes the machine and the processing is no longer continueing.Its not even showing the error message.


Luwapula

[Chris Mackenzie]

have you tried running bchk on the files in the function?

or fsck on the files in the partition?

[Rob Donovan]

Hi,

You should try enabling TRACEALL = 15, and see what the trace says, when it freezes....

Do a search for TRACEALL to see how to use it...

Rob D.