DB2 FOR LUW / DB2FORLUW / A50 - DB2

By default, non-instance user has no read permission on 
transaction logs. So, when a non-instance user calls db2flsn, 
reading of logs should fail with "Access Denied" error, after 
that, db2flsn will attempt to use the history file to determine 
the correct log file. In this case, db2flsn may run very slowly 
if the database has a big size history file. 
 
To determinate this problem, you can collect a db2trc. You 
should find sqlpScanHistFileForRecoveryList() takes long time to 
return: 
 
29082          8.323103056   sqlpScanHistFileForRecoveryList 
entry 
<skipped> 
628801        28.911907613   sqlpScanHistFileForRecoveryList 
exit

**************************************************************** 
* USERS AFFECTED:                                              * 
* N/A                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2  V10.5 FIXPACK 7.                             * 
****************************************************************

PRUNE HISTORY FILE to reduce its size.

The problem is firstly fixed on V10.5 FIXPACK 7.

keiner bekannt / siehe Local-Fix

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

21.01.2015
20.01.2016
20.01.2016