fb_lock_print - Information about Firebird database locks

       Copyright (C) Damyan Ivanov, 2009.

       This manpage was written by Damyan Ivanov for the Debian project but may be used by others. Permission is
       granted to use this document, with or without modifications, provided that this notice is retained. If we
       meet some day, and you think this stuff is worth it, you can buy me a beer in return.

Firebird 4.0                                       2025-02-17                                   FB_LOCK_PRINT(1)

fb_lock_print  is  a  tool for displaying the information from the Firebird lock system. These are useful
       when debugging lock contention/conflict/performance problems.

       fb_lock_print - Information about Firebird database locks

-ddatabase
           Print lock information about the specified database.

       -flockfile
           Print lock information from the specified lock file. Firebird lock files live in /tmp/firebird.

       -o | -p
           Print information about lock owner blocks. On by default.

       -c  Consistency mode. Blocks the lock manager so that no changes to the lock blocks can be made while the
           information is gathered.

       -l  Print information about lock blocks.

       -r  Print information about lock request blocks.

       -h  Print information about lock history.

       -a  Print information about owner blocks, lock blocks, request blocks and history.  Same as "-o -l -r -h"

       -snum
           Print information about lock series num.

       -i[filter] intervalcount
           Enter interactive mode and continuously display lock counters per second.

           Possible filters are:

           a   lock acquires

           o   lock operations: enqueues, conversions, downgrades, dequeues, reads, writes and queries

           t   lock operations by type.

           w   lock waits

           If no filter is given, all activity is shown.

           interval is the interval in seconds between displays. count instructs  fb_lock_print  to  exit  after
           that many displays.

       -w  Print recursive list of locks each lock waits for.

       -m  HTML output.

fb_lock_print -d database [option...]
       fb_lock_print -f lockfile [option...]