|
Problem IT07344
|
Status: Closed |
SOME 'MON_GET_XXXXX()' ROUTINES PERFORMANCE WILL DECREASE BASED ON THE NUMBER OF TABLESPACES |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
When scanning a system file which records the tablespaces by
using mon_get_database,
there could be slow performance when scanning a number of
tablespaces.
This could be due to lots of iterations of the following
function flow.
It can be found by db2 trace and the following flow can be found
under sqlrwFilteredTablespaceIterator::execute function
One iteration takes about 1.5 ms but when it iterates a lot(e.g.
over 1000 times),
there could be slow performance.
1031865 sqlbLazyLoad entry [eduid 563009 eduname db2agent]
1031867 | sqlbOpenMirroredFiles entry [eduid 563009
edunamedb2agent]
1031892 | sqlbOpenMirroredFiles exit
1031893 | sqlbReadPool entry [eduid 563009 eduname db2agent]
1032312 | | sqlbReadPoolOneFile entry [eduid 563009 eduname
db2agent]
1032325 | | | sqloseek entry [eduid 563009 eduname db2agent]
1032326 | | | sqloseek exit
1032327 | | | sqloread entry [eduid 563009 eduname db2agent]
1032328 | | | sqloread exit [rc = 0x870F0009 = -2029060087 =
SQLO_EOF]
1032349 | | sqlbReadPoolOneFile exit [rc = 0x870F0009 =
-2029060087 = SQLO_EOF]
1032350 | | sqlbReadPoolOneFile entry [eduid 563009 eduname
db2agent]
1032363 | | | sqloseek entry [eduid 563009 eduname db2agent]
1032364 | | | sqloseek exit
1032365 | | | sqloread entry [eduid 563009 eduname db2agent]
1032366 | | | sqloread exit [rc = 0x870F0009 = -2029060087 =
SQLO_EOF]
1032387 | | sqlbReadPoolOneFile exit [rc = 0x870F0009 =
-2029060087 = SQLO_EOF]
1032602 | sqlbReadPool exit [rc = 0x870F0009 = -2029060087 =
SQLO_EOF]
1032603 | sqlbCloseMirroredFiles entry [eduid 563009 eduname
db2agent]
1032608 | sqlbCloseMirroredFiles exit
1032609 sqlbLazyLoad exit [rc = 0x870F0009 = -2029060087 =
SQLO_EOF] |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 10.5 Fix Pack 7. *
**************************************************************** |
| Local Fix: |
|
| Solution |
First fixed in Version 10.5 Fix Pack 7. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 24.02.2015
25.01.2016
25.01.2016 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.7
|
 |
