DB2 FOR LUW / DB2FORLUW / A50 - DB2

Starting from v10.5FP5, db2top -d <db name> listing utilities 
doesn't show 
an executing LOAD task. The problem doesn't happen on v10.5FP4. 
 
To reproduce: 
 
1.  Session 1: 
db2sampl 
db2 connect to sample 
db2 export to staff.ixf of ixf "select * from staff" 
 
db2 +c "select * from staff fetch first 1 rows only with rr" 
 
2. Session 2: 
db2 connect to sample 
db2  "load from staff.ixf of ixf insert into staff"     (should 
hang there waiting for a lock) 
 
3.  Session 3: 
 
db2top  -d sample    (then press key u) 
 
[-]01:59:16,refresh=2secs(0.001) 
Utilities 
AIX,member=[1/1],DB2INST1:SAMPLE 
[d=Y,a=N,e=N,p=ALL] 
[qp=off] 
 
                          Hash       # of     Utility 
Utility         Uti Utility    Invoker    Completed        Work 
Phase           Progress 
                          Value      entries  Start Time 
Type            Pri State      Type       Work             Unit 
Prog% Start Time      Description 
                          ---------- -------- --------------- 
--------------- --- ---------- ---------- ---------------- 
------- ----- --------------- -------------------- 
 
EMPTY here! 
 
4.  Session 4: 
 
db2 list utilities show detail 
 
ID                               = 3 
Type                             = LOAD 
Database Name                    = SAMPLE 
Member Number                    = 0 
Description                      = [LOADID: 
15166.2015-02-16-01.59.06.312359.0 (2;15)] 
[*LOCAL.db2inst1.150216065833] OFFLINE LOAD Unknown file type 
AUTOMATIC INDEXING INSERT COPY NO AD920634.STAFF 
Start Time                       = 02/16/2015 01:59:06.320157 
State                            = Executing 
Invocation Type                  = User 
Progress Monitoring: 
      Description                = SETUP 
      Completed Work             = 0 bytes 
      Start Time                 = 02/16/2015 01:59:06.320178

**************************************************************** 
* USERS AFFECTED:                                              * 
* N/A                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to V105FP7 for the fix.                              * 
****************************************************************

Add spaces in the db2top command to make it 8 chars. E.g. db2top 
-d "sample  ", which should work.

Fix in V105FP7

keiner bekannt / siehe Local-Fix

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

18.02.2015
21.01.2016
27.04.2016