|
Problem IC88435
|
Status: Closed |
REORG INFORMATION GETS CLEARED ON EXECUTION OF SQLRLADMINGETTABINFO VIEW |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problem description: |
After running a reorg command against a specific table, running
db2pd or snapshot against that table will show details about the
reorg. For example:
$ db2 reorg table administrator.org
$ db2pd -d sample -reorg -tcb or db2 get snapshot for
tables on SAMPLE
The above commands display the reorg details.
Selecting from SYSIBMADM.ADMINTABINFO or running
sqlrlAdminGetTabInfo inadvertently clears the reorg information,
so that subsequent monitoring commands will no longer display
it.
$ db2 select * from SYSIBMADM.ADMINTABINFO where tabname='ORG'
After running the above command, when we run the db2pd or
snapshot
command again we do not see any reorg related information. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All users of sqlrlAdminGetTabInfo *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* upgrade to next fixpack (v95fp11) *
**************************************************************** |
| Local Fix: |
N/A |
| Solution |
Problem was first fixed in DB2 UDB version 9.5 fix pack 11. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 20.11.2012
13.10.2013
13.10.2013 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.FP11
|
| Problem solved according to the fixlist(s) of the following version(s) |
