|
Problem IT40651
|
Status: Closed |
DB2LOGGX PROCESS CONSUMING HIGH CPU
|
| product: |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 |
| Problem description: |
For example in a test environment, hen there is nothing running
on the system, vmstat shows that the system is using 5% user cpu
and 12% system cpu.
kthr   memory        page        faults      Â
cpu     Â
----- ----------- ------------------------ ------------
-----------------------
 r  b  avm  fre  re  pi  po  fr  sr  cy  in  sy  cs us sy id
wa   pc   ec
 1  0 3171475  9529  0  0  0  0   0  0  4 9971 2164  5 12
83 Â 0 Â 0.12 Â 30.8
 2  0 3171475  9529  0  0  0  0   0  0  2 9905 2197  5 12
83 Â 0 Â 0.12 Â 30.1
and top shows that db2sysc is the process consuming the most CPU
(~5.4%)
?  PID    %CPU   Size    Res   Res    Res   Char Â
RAM    Paging     Command                Â
?
?       Used    KB    Set   Text   Data   I/O Â
Use  io  other repage                    Â
?
?17498446 Â Â 5.4 Â Â 62392 Â Â 62576 Â Â Â 472 Â Â 62104 Â Â 1575 Â
0%    0    0    0 db2sysc  Â
db2pd -edus shows that db2loggx is the agents that is using the
most resources inside db2:
Database Member 0 -- Active -- Up 0 days 00:41:32 -- Date
2022-04-12-14.11.13.423550
List of all EDUs for database member 0
db2sysc PID: 17498446
db2wdog PID: 11600382
db2acd  PID: 32506154
EDU ID   TID          Kernel TID      EDU Name  Â
USR (s) Â Â Â SYS (s)
================================================================
===================================================
...
9511 Â Â Â 9511 Â Â Â Â Â Â Â Â 61079825 Â Â Â Â Â Â db2loggx.0
(SAMPLE) Â Â Â Â Â Â Â Â Â Â 34.186424 Â Â 85.987600 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* AIX, with DB2_ADVANCED_LOG_SPACE_MGMT enabled *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to 11.5.8.0. *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* AIX, with DB2_ADVANCED_LOG_SPACE_MGMT enabled *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to 11.5.8.0. *
**************************************************************** |
| Comment |
Problem was first fixed in Db2 Version 11.5.8.0. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 14.04.2022
02.05.2022
02.05.2022 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
