DB2 FOR LUW / DB2FORLUW / B10 - DB2

Customer is running a pureScale server with db2level:  10.5 FP4.

He reports:

db2 "reorg  inplace allow write access start"
db2pd -d  -reorg           ---  reorg information shows in
db2pd output

db2 "reorg  inplace pause "
db2pd -d  -reorg           ---  reorg information shows in
db2pd output

db2 "reorg  inplace allow write access resume "
db2pd -d  -reorg         --  no reorg information shows in
db2pd output


I can reproduce the problem with the latest build "DB2
v10.5.0.8",  The problem only happens on a pureScale env.

db2 create db fdb1

db2 "create table test (c1 int, c2 char(10))"

>> insert 2M rows into the table

db2 -v "reorg table TEST inplace allow write access start" ;
db2pd -d fdb1 -reorg ; db2 -v "reorg table TEST inplace pause "
; db2pd -d fdb1 -reorg ;

$ db2 -v "reorg table TEST inplace allow write access start" ;
db2pd -d fdb1 -reorg ; db2 -v "reorg table TEST inplace pause "
; db2pd -d fdb1 -reorg ;

reorg table TEST inplace allow write access start
DB20000I  The REORG command completed successfully.
DB21024I  This command is asynchronous and may not be effective
immediately.



Database Member 0 -- Database FDB1 -- Active -- Up 0 days
00:01:28 -- Date 2015-03-11-00.58.17.334289

Table Reorg Information:
Address            TbspaceID TableID PartID MasterTbs MasterTab
TableName          Type    IndexID    TempSpaceID
0x077000004F8DCD00 2         4       n/a    n/a       n/a TEST
Online  0          2

Table Reorg Stats:
Address            TableName          Start               End
PhaseStart          MaxPhase   Phase      CurCount   MaxCount
Status  Completion
0x077000004F8DCD00 TEST               03/11/2015 00:58:16 n/a
n/a                 n/a        n/a        704        14391
Started 0

reorg table TEST inplace pause
DB20000I  The REORG command completed successfully.
DB21024I  This command is asynchronous and may not be effective
immediately.



Database Member 0 -- Database FDB1 -- Active -- Up 0 days
00:01:28 -- Date 2015-03-11-00.58.17.771606

Table Reorg Information:
Address            TbspaceID TableID PartID MasterTbs MasterTab
TableName          Type    IndexID    TempSpaceID
0x077000004F8DCD00 2         4       n/a    n/a       n/a TEST
Online  0          2

Table Reorg Stats:
Address            TableName          Start               End
PhaseStart          MaxPhase   Phase      CurCount   MaxCount
Status  Completion
0x077000004F8DCD00 TEST               03/11/2015 00:58:16
03/11/2015 00:58:17 n/a                 n/a        n/a 895
14391      Paused  0


$ db2 -v "reorg table TEST inplace allow write access
resume";db2pd -d fdb1 -reorg reorg table TEST inplace allow
write access resume
DB20000I  The REORG command completed successfully.
DB21024I  This command is asynchronous and may not be effective
immediately.



Database Member 0 -- Database FDB1 -- Active -- Up 0 days
00:01:39 -- Date 2015-03-11-00.58.28.492499

Table Reorg Information:
Address            TbspaceID TableID PartID MasterTbs MasterTab
TableName          Type    IndexID    TempSpaceID

Table Reorg Stats:
Address            TableName          Start               End
PhaseStart          MaxPhase   Phase      CurCount   MaxCount
Status  Completion

==>  reorg information doesn't show up in db2pd output


$ db2 get snapshot for tables on fdb1

            Table Snapshot

First database connect timestamp     = 03/11/2015
00:56:49.165245
Last reset timestamp                 =
Snapshot timestamp                   = 03/11/2015
01:00:34.178653
Database name                        = FDB1
Database path                        =
/net2/d_TMP/TMP/ad920634/ad920634/NODE0000/SQL00001/MEMBER0000/
Input database alias                 = FDB1
Number of accessed tables            = 0

==>  also not show in  snapshot output


==> start a new reorg, still cannot see the reorg information:

$ db2 -v "reorg table TEST inplace allow write access start" ;
db2pd -d fdb1 -reorg reorg table TEST inplace allow write access
start
DB20000I  The REORG command completed successfully.
DB21024I  This command is asynchronous and may not be effective
immediately.



Database Member 0 -- Database FDB1 -- Active -- Up 0 days
00:04:45 -- Date 2015-03-11-01.01.34.699291

Table Reorg Information:
Address            TbspaceID TableID PartID MasterTbs MasterTab
TableName          Type    IndexID    TempSpaceID

Table Reorg Stats:
Address            TableName          Start               End
PhaseStart          MaxPhase   Phase      CurCount   MaxCount
Status  Completion


After  deactivate & activate  the database, db2pd turns back to
show reorg information.

****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 11.1 Mod 2 Fix Pack 2 or higher               *
****************************************************************

not known / see Local fix

forerunner  : IT19268 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

04.08.2017
24.10.2017
24.10.2017