|
Problem IT07210
|
Status: Closed |
DB2TOP LISTING UTILITIES DOESN'T SHOW AN EXECUTING LOAD TASK STARTING FROM V10.5FP5 |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
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 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* N/A *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to V105FP7 for the fix. *
**************************************************************** |
| Local Fix: |
Add spaces in the db2top command to make it 8 chars. E.g. db2top
-d "sample ", which should work. |
| Solution |
Fix in V105FP7 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 18.02.2015
21.01.2016
27.04.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
|
 |
