.\" Automatically generated by Pod::Man 4.10 (Pod::Simple 3.35)
.\"
.\" Standard preamble:
.\" ========================================================================
.de Sp \" Vertical space (when we can't use .PP)
.if t .sp .5v
.if n .sp
..
.de Vb \" Begin verbatim text
.ft CW
.nf
.ne \\$1
..
.de Ve \" End verbatim text
.ft R
.fi
..
.\" Set up some character translations and predefined strings.  \*(-- will
.\" give an unbreakable dash, \*(PI will give pi, \*(L" will give a left
.\" double quote, and \*(R" will give a right double quote.  \*(C+ will
.\" give a nicer C++.  Capital omega is used to do unbreakable dashes and
.\" therefore won't be available.  \*(C` and \*(C' expand to `' in nroff,
.\" nothing in troff, for use with C<>.
.tr \(*W-
.ds C+ C\v'-.1v'\h'-1p'\s-2+\h'-1p'+\s0\v'.1v'\h'-1p'
.ie n \{\
.    ds -- \(*W-
.    ds PI pi
.    if (\n(.H=4u)&(1m=24u) .ds -- \(*W\h'-12u'\(*W\h'-12u'-\" diablo 10 pitch
.    if (\n(.H=4u)&(1m=20u) .ds -- \(*W\h'-12u'\(*W\h'-8u'-\"  diablo 12 pitch
.    ds L" ""
.    ds R" ""
.    ds C` ""
.    ds C' ""
'br\}
.el\{\
.    ds -- \|\(em\|
.    ds PI \(*p
.    ds L" ``
.    ds R" ''
.    ds C`
.    ds C'
'br\}
.\"
.\" Escape single quotes in literal strings from groff's Unicode transform.
.ie \n(.g .ds Aq \(aq
.el       .ds Aq '
.\"
.\" If the F register is >0, we'll generate index entries on stderr for
.\" titles (.TH), headers (.SH), subsections (.SS), items (.Ip), and index
.\" entries marked with X<> in POD.  Of course, you'll have to process the
.\" output yourself in some meaningful fashion.
.\"
.\" Avoid warning from groff about undefined register 'F'.
.de IX
..
.nr rF 0
.if \n(.g .if rF .nr rF 1
.if (\n(rF:(\n(.g==0)) \{\
.    if \nF \{\
.        de IX
.        tm Index:\\$1\t\\n%\t"\\$2"
..
.        if !\nF==2 \{\
.            nr % 0
.            nr F 2
.        \}
.    \}
.\}
.rr rF
.\"
.\" Accent mark definitions (@(#)ms.acc 1.5 88/02/08 SMI; from UCB 4.2).
.\" Fear.  Run.  Save yourself.  No user-serviceable parts.
.    \" fudge factors for nroff and troff
.if n \{\
.    ds #H 0
.    ds #V .8m
.    ds #F .3m
.    ds #[ \f1
.    ds #] \fP
.\}
.if t \{\
.    ds #H ((1u-(\\\\n(.fu%2u))*.13m)
.    ds #V .6m
.    ds #F 0
.    ds #[ \&
.    ds #] \&
.\}
.    \" simple accents for nroff and troff
.if n \{\
.    ds ' \&
.    ds ` \&
.    ds ^ \&
.    ds , \&
.    ds ~ ~
.    ds /
.\}
.if t \{\
.    ds ' \\k:\h'-(\\n(.wu*8/10-\*(#H)'\'\h"|\\n:u"
.    ds ` \\k:\h'-(\\n(.wu*8/10-\*(#H)'\`\h'|\\n:u'
.    ds ^ \\k:\h'-(\\n(.wu*10/11-\*(#H)'^\h'|\\n:u'
.    ds , \\k:\h'-(\\n(.wu*8/10)',\h'|\\n:u'
.    ds ~ \\k:\h'-(\\n(.wu-\*(#H-.1m)'~\h'|\\n:u'
.    ds / \\k:\h'-(\\n(.wu*8/10-\*(#H)'\z\(sl\h'|\\n:u'
.\}
.    \" troff and (daisy-wheel) nroff accents
.ds : \\k:\h'-(\\n(.wu*8/10-\*(#H+.1m+\*(#F)'\v'-\*(#V'\z.\h'.2m+\*(#F'.\h'|\\n:u'\v'\*(#V'
.ds 8 \h'\*(#H'\(*b\h'-\*(#H'
.ds o \\k:\h'-(\\n(.wu+\w'\(de'u-\*(#H)/2u'\v'-.3n'\*(#[\z\(de\v'.3n'\h'|\\n:u'\*(#]
.ds d- \h'\*(#H'\(pd\h'-\w'~'u'\v'-.25m'\f2\(hy\fP\v'.25m'\h'-\*(#H'
.ds D- D\\k:\h'-\w'D'u'\v'-.11m'\z\(hy\v'.11m'\h'|\\n:u'
.ds th \*(#[\v'.3m'\s+1I\s-1\v'-.3m'\h'-(\w'I'u*2/3)'\s-1o\s+1\*(#]
.ds Th \*(#[\s+2I\s-2\h'-\w'I'u*3/5'\v'-.3m'o\v'.3m'\*(#]
.ds ae a\h'-(\w'a'u*4/10)'e
.ds Ae A\h'-(\w'A'u*4/10)'E
.    \" corrections for vroff
.if v .ds ~ \\k:\h'-(\\n(.wu*9/10-\*(#H)'\s-2\u~\d\s+2\h'|\\n:u'
.if v .ds ^ \\k:\h'-(\\n(.wu*10/11-\*(#H)'\v'-.4m'^\v'.4m'\h'|\\n:u'
.    \" for low resolution devices (crt and lpr)
.if \n(.H>23 .if \n(.V>19 \
\{\
.    ds : e
.    ds 8 ss
.    ds o a
.    ds d- d\h'-1'\(ga
.    ds D- D\h'-1'\(hy
.    ds th \o'bp'
.    ds Th \o'LP'
.    ds ae ae
.    ds Ae AE
.\}
.rm #[ #] #H #V #F C
.\" ========================================================================
.\"
.IX Title "FB_LOCK_PRINT 1"
.TH FB_LOCK_PRINT 1 "2019-02-08" "Firebird 3.0" "Firebird documentation"
.\" For nroff, turn off justification.  Always turn off hyphenation; it makes
.\" way too many mistakes in technical documents.
.if n .ad l
.nh
.SH "NAME"
fb_lock_print \- Information about Firebird database locks
.SH "SYNOPSIS"
.IX Header "SYNOPSIS"
.IP "\fBfb_lock_print\fR \-d \fIdatabase\fR [\fIoption\fR...]" 4
.IX Item "fb_lock_print -d database [option...]"
.PD 0
.IP "\fBfb_lock_print\fR \-f \fIlockfile\fR [\fIoption\fR...]" 4
.IX Item "fb_lock_print -f lockfile [option...]"
.PD
.SH "DESCRIPTION"
.IX Header "DESCRIPTION"
\&\fBfb_lock_print\fR is a tool for displaying the information from the Firebird
lock system. These are useful when debugging lock
contention/conflict/performance problems.
.SH "OPTIONS"
.IX Header "OPTIONS"
.IP "\fB\-d\fR \fIdatabase\fR" 4
.IX Item "-d database"
Print lock information about the specified database.
.IP "\fB\-f\fR \fIlockfile\fR" 4
.IX Item "-f lockfile"
Print lock information from the specified lock file. Firebird lock files live
in \fI/tmp/firebird\fR.
.IP "\fB\-o\fR | \fB\-p\fR" 4
.IX Item "-o | -p"
Print information about lock owner blocks. On by default.
.IP "\fB\-c\fR" 4
.IX Item "-c"
Consistency mode. Blocks the lock manager so that no changes to the lock blocks
can be made while the information is gathered.
.IP "\fB\-l\fR" 4
.IX Item "-l"
Print information about lock blocks.
.IP "\fB\-r\fR" 4
.IX Item "-r"
Print information about lock request blocks.
.IP "\fB\-h\fR" 4
.IX Item "-h"
Print information about lock history.
.IP "\fB\-a\fR" 4
.IX Item "-a"
Print information about owner blocks, lock blocks, request blocks and history.
Same as \f(CW\*(C`\-o \-l \-r \-h\*(C'\fR
.IP "\fB\-s\fR \fInum\fR" 4
.IX Item "-s num"
Print information about lock series \fInum\fR.
.IP "\fB\-i\fR[\fIfilter\fR] \fIinterval\fR \fIcount\fR" 4
.IX Item "-i[filter] interval count"
Enter interactive mode and continuously display lock counters per second.
.Sp
Possible filters are:
.RS 4
.IP "\fBa\fR" 4
.IX Item "a"
lock acquires
.IP "\fBo\fR" 4
.IX Item "o"
lock operations: enqueues, conversions, downgrades, dequeues, reads, writes and
queries
.IP "\fBt\fR" 4
.IX Item "t"
lock operations by type.
.IP "\fBw\fR" 4
.IX Item "w"
lock waits
.RE
.RS 4
.Sp
If no filter is given, all activity is shown.
.Sp
\&\fIinterval\fR is the interval in seconds between displays. \fIcount\fR instructs
\&\fBfb_lock_print\fR to exit after that many displays.
.RE
.IP "\fB\-w\fR" 4
.IX Item "-w"
Print recursive list of locks each lock waits for.
.IP "\fB\-m\fR" 4
.IX Item "-m"
\&\s-1HTML\s0 output.
.SH "AUTHOR & COPYRIGHT"
.IX Header "AUTHOR & COPYRIGHT"
Copyright (C) Damyan Ivanov, 2009.
.PP
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.