DB2 FOR LUW / DB2FORLUW / A50 - DB2

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]

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.5 Fix Pack 7.                      * 
****************************************************************

First fixed in Version 10.5 Fix Pack 7.

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

24.02.2015
25.01.2016
25.01.2016