Hello Team ,
We have been encountered another issue with the Database locks recently ,
yesterday there was been Table locks identified from the Database team , and
after certain period of time we have received the below error on the Apache
logs and we have to restart the tomcat/Apache instances.
: [Mon Oct 17 04:21:04.599196 2022] [mpm_event:error] [pid 10576:tid
140052698470144] AH00484: server reached MaxRequestWorkers setting, consider
raising the MaxRequestWorkers setting
we needed your suggestion as how these errors can cause the Apache to go with
worker exhaustion error.
Apache version - 2.4.25
*******************************************************************************************
Below are details given by DB team -
INSTANCE: db2inst
DATABASE: tirehq
TIMESTAMP: 2022-10-17.02.20.01
HOLDAPP HOLDER AGNTHLDLCK WAITTAPP WAITER WTAGNTID
HOLDMODE OBJTYPE TABNAME SCHEMA WTNGSECS
--------------- ---------- ---------- --------------- ---------- ---------
---------- ------------------ ------------------------- ---------- -----------
db2bp DB2INST 25726 db2jcc_applicat WING2 26171 U
TABLE_LOCK SALESDOCLI WING2 616
db2bp DB2INST 25726 db2jcc_applicat WING2 26217 U
TABLE_LOCK SALESDOCLI WING2 336
db2bp DB2INST 25726 db2jcc_applicat WING2 26263 U
TABLE_LOCK SALESDOCLI WING2 135
db2bp DB2INST 25726 db2jcc_applicat WING2 26276 U
TABLE_LOCK SALESDOCLI WING2 13
db2bp DB2INST 25726 db2jcc_applicat WING2 26151 U
TABLE_LOCK SALESDOCLI WING2 781
db2bp DB2INST 25726 db2jcc_applicat WING2 26197 U
TABLE_LOCK SALESDOCLI WING2 540
db2bp DB2INST 25726 db2jcc_applicat WING2 26164 U
TABLE_LOCK SALESDOCLI WING2 663
db2bp DB2INST 25726 db2jcc_applicat WING2 26210 U
TABLE_LOCK SALESDOCLI WING2 420
db2bp DB2INST 25726 db2jcc_applicat WING2 26256 U
TABLE_LOCK SALESDOCLI WING2 237
db2bp DB2INST 25726 db2jcc_applicat WING2 131 U
TABLE_LOCK SALESDOCLI WING2 3071
db2bp DB2INST 25726 db2jcc_applicat WING2 26144 U
TABLE_LOCK SALESDOCLI WING2 764
db2bp DB2INST 25726 db2jcc_applicat WING2 26269 U
TABLE_LOCK SALESDOCLI WING2 75
db2bp DB2INST 25726 db2jcc_applicat WING2 26190 U
TABLE_LOCK SALESDOCLI WING2 560
db2bp DB2INST 25726 db2jcc_applicat WING2 111 U
TABLE_LOCK SALESDOCLI WING2 1782
db2bp DB2INST 25726 db2jcc_applicat WING2 26157 U
TABLE_LOCK SALESDOCLI WING2 721
db2bp DB2INST 25726 db2jcc_applicat WING2 26203 U
TABLE_LOCK SALESDOCLI WING2 459
db2bp DB2INST 25726 db2jcc_applicat WING2 26170 U
TABLE_LOCK SALESDOCLI WING2 636
db2bp DB2INST 25726 db2jcc_applicat WING2 26216 U
TABLE_LOCK SALESDOCLI WING2 357
db2bp DB2INST 25726 db2jcc_applicat WING2 26262 U
TABLE_LOCK SALESDOCLI WING2 159
db2bp DB2INST 25726 db2jcc_applicat WING2 26275 U
TABLE_LOCK SALESDOCLI WING2 16
db2bp DB2INST 25726 db2jcc_applicat WING2 26150 U
TABLE_LOCK SALESDOCLI WING2 794
db2bp DB2INST 25726 db2jcc_applicat WING2 26196 U
TABLE_LOCK SALESDOCLI WING2 540
db2bp DB2INST 25726 db2jcc_applicat WING2 26242 U
TABLE_LOCK SALESDOCLI WING2 257
db2bp DB2INST 25726 db2jcc_applicat WING2 117 U
TABLE_LOCK SALESDOCLI WING2 2806
db2bp DB2INST 25726 db2jcc_applicat WING2 26163 U
TABLE_LOCK SALESDOCLI WING2 660
db2bp DB2INST 25726 db2jcc_applicat WING2 130 U
TABLE_LOCK SALESDOCLI WING2 1399
db2bp DB2INST 25726 db2jcc_applicat WING2 26176 U
TABLE_LOCK SALESDOCLI WING2 563
db2bp DB2INST 25726 db2jcc_applicat WING2 110 U
TABLE_LOCK SALESDOCLI WING2 1527
db2bp DB2INST 25726 db2jcc_applicat WING2 26156 U
TABLE_LOCK SALESDOCLI WING2 676
db2bp DB2INST 25726 db2jcc_applicat WING2 26202 U
TABLE_LOCK SALESDOCLI WING2 478
db2bp DB2INST 25726 db2jcc_applicat WING2 26169 U
TABLE_LOCK SALESDOCLI WING2 621
db2bp DB2INST 25726 db2jcc_applicat WING2 26215 U
TABLE_LOCK SALESDOCLI WING2 338
db2bp DB2INST 25726 db2jcc_applicat WING2 26261 U
TABLE_LOCK SALESDOCLI WING2 176
db2bp DB2INST 25726 db2jcc_applicat WING2 26274 U
TABLE_LOCK SALESDOCLI WING2 31
db2bp DB2INST 25726 db2jcc_applicat WING2 116 U
TABLE_LOCK SALESDOCLI WING2 2705
db2bp DB2INST 25726 db2jcc_applicat WING2 26162 U
TABLE_LOCK SALESDOCLI WING2 663
db2bp DB2INST 25726 db2jcc_applicat WING2 26208 U
TABLE_LOCK SALESDOCLI WING2 439
db2bp DB2INST 25726 db2jcc_applicat WING2 129 U
TABLE_LOCK SALESDOCLI WING2 927
db2bp DB2INST 25726 db2jcc_applicat WING2 26175 U
TABLE_LOCK SALESDOCLI WING2 599
db2bp DB2INST 25726 db2jcc_applicat WING2 26221 U
TABLE_LOCK SALESDOCLI WING2 277
db2bp DB2INST 25726 db2jcc_applicat WING2 26267 U
TABLE_LOCK SALESDOCLI WING2 117
db2bp DB2INST 25726 db2jcc_applicat WING2 109 U
TABLE_LOCK SALESDOCLI WING2 1229
db2bp DB2INST 25726 db2jcc_applicat WING2 26155 U
TABLE_LOCK SALESDOCLI WING2 719
db2bp DB2INST 25726 db2jcc_applicat WING2 26201 U
TABLE_LOCK SALESDOCLI WING2 521
db2bp DB2INST 25726 db2jcc_applicat WING2 26214 U
TABLE_LOCK SALESDOCLI WING2 378
db2bp DB2INST 25726 db2jcc_applicat WING2 26260 U
TABLE_LOCK SALESDOCLI WING2 155
db2bp DB2INST 25726 db2jcc_applicat WING2 26273 U
TABLE_LOCK SALESDOCLI WING2 12
db2bp DB2INST 25726 db2jcc_applicat WING2 26148 U
TABLE_LOCK SALESDOCLI WING2 824
db2bp DB2INST 25726 db2jcc_applicat WING2 115 U
TABLE_LOCK SALESDOCLI WING2 3294
db2bp DB2INST 25726 db2jcc_applicat WING2 26161 U
TABLE_LOCK SALESDOCLI WING2 662
db2bp DB2INST 25726 db2jcc_applicat WING2 26207 U
TABLE_LOCK SALESDOCLI WING2 399
db2bp DB2INST 25726 db2jcc_applicat WING2 128 U
TABLE_LOCK SALESDOCLI WING2 843
db2bp DB2INST 25726 db2jcc_applicat WING2 26174 U
TABLE_LOCK SALESDOCLI WING2 601
db2bp DB2INST 25726 db2jcc_applicat WING2 26220 U
TABLE_LOCK SALESDOCLI WING2 317
db2bp DB2INST 25726 db2jcc_applicat WING2 26266 U
TABLE_LOCK SALESDOCLI WING2 96
db2bp DB2INST 25726 db2jcc_applicat WING2 26154 U
TABLE_LOCK SALESDOCLI WING2 743
db2bp DB2INST 25726 db2jcc_applicat WING2 26167 U
TABLE_LOCK SALESDOCLI WING2 642
db2bp DB2INST 25726 db2jcc_applicat WING2 26259 U
TABLE_LOCK SALESDOCLI WING2 195
db2bp DB2INST 25726 db2jcc_applicat WING2 134 U
TABLE_LOCK SALESDOCLI WING2 2928
db2jcc_applicat WING2 135 db2bp DB2INST 25726 IX
TABLE_LOCK SALESDOCLI WING2 3524
db2bp DB2INST 25726 db2jcc_applicat WING2 26272 U
TABLE_LOCK SALESDOCLI WING2 36
db2bp DB2INST 25726 db2jcc_applicat WING2 26147 U
TABLE_LOCK SALESDOCLI WING2 785
db2bp DB2INST 25726 db2jcc_applicat WING2 114 U
TABLE_LOCK SALESDOCLI WING2 2523
db2bp DB2INST 25726 db2jcc_applicat WING2 26160 U
TABLE_LOCK SALESDOCLI WING2 664
db2bp DB2INST 25726 db2jcc_applicat WING2 26081 U
TABLE_LOCK SALESDOCLI WING2 1094
db2bp DB2INST 25726 db2jcc_applicat WING2 26206 U
TABLE_LOCK SALESDOCLI WING2 439
db2bp DB2INST 25726 db2jcc_applicat WING2 127 U
TABLE_LOCK SALESDOCLI WING2 846
db2bp DB2INST 25726 db2jcc_applicat WING2 26173 U
TABLE_LOCK SALESDOCLI WING2 622
db2bp DB2INST 25726 db2jcc_applicat WING2 26219 U
TABLE_LOCK SALESDOCLI WING2 298
db2bp DB2INST 25726 db2jcc_applicat WING2 26265 U
TABLE_LOCK SALESDOCLI WING2 136
db2bp DB2INST 25726 db2jcc_applicat WING2 26153 U
TABLE_LOCK SALESDOCLI WING2 763
db2bp DB2INST 25726 db2jcc_applicat WING2 26199 U
TABLE_LOCK SALESDOCLI WING2 500
db2bp DB2INST 25726 db2jcc_applicat WING2 26166 U
TABLE_LOCK SALESDOCLI WING2 638
db2bp DB2INST 25726 db2jcc_applicat WING2 26212 U
TABLE_LOCK SALESDOCLI WING2 378
db2bp DB2INST 25726 db2jcc_applicat WING2 26258 U
TABLE_LOCK SALESDOCLI WING2 197
db2bp DB2INST 25726 db2jcc_applicat WING2 133 U
TABLE_LOCK SALESDOCLI WING2 1794
db2bp DB2INST 25726 db2jcc_applicat WING2 26100 U
TABLE_LOCK SALESDOCLI WING2 870
db2bp DB2INST 25726 db2jcc_applicat WING2 26146 U
TABLE_LOCK SALESDOCLI WING2 842
db2bp DB2INST 25726 db2jcc_applicat WING2 26271 U
TABLE_LOCK SALESDOCLI WING2 55
db2bp DB2INST 25726 db2jcc_applicat WING2 113 U
TABLE_LOCK SALESDOCLI WING2 2624
db2bp DB2INST 25726 db2jcc_applicat WING2 26159 U
TABLE_LOCK SALESDOCLI WING2 682
db2bp DB2INST 25726 db2jcc_applicat WING2 26251 U
TABLE_LOCK SALESDOCLI WING2 256
db2bp DB2INST 25726 db2jcc_applicat WING2 126 U
TABLE_LOCK SALESDOCLI WING2 865
db2bp DB2INST 25726 db2jcc_applicat WING2 26218 U
TABLE_LOCK SALESDOCLI WING2 319
db2bp DB2INST 25726 db2jcc_applicat WING2 26264 U
TABLE_LOCK SALESDOCLI WING2 134
db2bp DB2INST 25726 db2jcc_applicat WING2 26139 U
TABLE_LOCK SALESDOCLI WING2 781
db2bp DB2INST 25726 db2jcc_applicat WING2 26152 U
TABLE_LOCK SALESDOCLI WING2 743
db2bp DB2INST 25726 db2jcc_applicat WING2 26198 U
TABLE_LOCK SALESDOCLI WING2 499
db2bp DB2INST 25726 db2jcc_applicat WING2 26165 U
TABLE_LOCK SALESDOCLI WING2 658
db2bp DB2INST 25726 db2jcc_applicat WING2 26211 U
TABLE_LOCK SALESDOCLI WING2 417
db2bp DB2INST 25726 db2jcc_applicat WING2 26257 U
TABLE_LOCK SALESDOCLI WING2 218
db2bp DB2INST 25726 db2jcc_applicat WING2 132 U
TABLE_LOCK SALESDOCLI WING2 3172
db2bp DB2INST 25726 db2jcc_applicat WING2 26178 U
TABLE_LOCK SALESDOCLI WING2 577
db2bp DB2INST 25726 db2jcc_applicat WING2 26099 U
TABLE_LOCK SALESDOCLI WING2 804
db2bp DB2INST 25726 db2jcc_applicat WING2 26145 U
TABLE_LOCK SALESDOCLI WING2 725
db2bp DB2INST 25726 db2jcc_applicat WING2 26270 U
TABLE_LOCK SALESDOCLI WING2 73
db2bp DB2INST 25726 db2jcc_applicat WING2 26191 U
TABLE_LOCK SALESDOCLI WING2 539
db2bp DB2INST 25726 db2jcc_applicat WING2 112 U
TABLE_LOCK SALESDOCLI WING2 2442
db2bp DB2INST 25726 db2jcc_applicat WING2 26158 U
TABLE_LOCK SALESDOCLI WING2 703
Thanks & Regards,
Priyanka Kumawat | Middleware Admin
T +91.7879364483
EMail - priyanka.kuma...@dxc.com<mailto:priyanka.kuma...@dxc.com>
DL -
ams-leveraged-webadmin-offsh...@dxc.com<mailto:ams-leveraged-webadmin-offsh...@dxc.com>
DXC Technology
Thanks & Regards,
Priyanka Kumawat | Middleware Admin
T +91.7879364483
EMail - priyanka.kuma...@dxc.com<mailto:priyanka.kuma...@dxc.com>
DL -
ams-leveraged-webadmin-offsh...@dxc.com<mailto:ams-leveraged-webadmin-offsh...@dxc.com>
DXC Technology
DXC Technology Company -- This message is transmitted to you by or on behalf of
DXC Technology Company or one of its affiliates. It is intended exclusively for
the addressee. The substance of this message, along with any attachments, may
contain proprietary, confidential or privileged information or information that
is otherwise legally exempt from disclosure. Any unauthorized review, use,
disclosure or distribution is prohibited. If you are not the intended recipient
of this message, you are not authorized to read, print, retain, copy or
disseminate any part of this message. If you have received this message in
error, please destroy and delete all copies and notify the sender by return
e-mail. Regardless of content, this e-mail shall not operate to bind DXC
Technology Company or any of its affiliates to any order or other contract
unless pursuant to explicit written agreement or government initiative
expressly permitting the use of e-mail for such purpose.
