Subject Re: [firebird-support] Re: Row Locking
Author Paul Beach
<<Because i found sometime my client application (in C and using ODBC
API library) takes longer time to complete and sometime fast. I don't
know whether my query that send from my application is in deadlock or
not.>>

From gds_lock_print:

LOCK_HEADER BLOCK
Version: 114, Active owner: 0, Length: 32768, Used: 12976
Semmask: 0x0, Flags: 0x0001
Enqs: 10, Converts: 0, Rejects: 0, Blocks: 0
Deadlock scans: 0, Deadlocks: 0, Scan interval: 10

Deadlock scans. The number of times that the lock manager walked a chain of
locks and owners looking for deadlocks. The lock manager initiates a deadlock
scan when a process has been waiting 10 seconds for a lock.

This section is taken from a new document that Ann wrote that will be on the
next IBPhoenix CD, and was sent out automatically to all IBPhoenix support
customers and subscription holders on how to read and understand the
lockprint.....

Regards
Paul