|
Problem IC84834
|
Status: Closed |
TABLE DATA OF REORG INFORMATION GETS CLEARED ON EXECUTION OF SQLRLADMINGETTABINFO VIEW |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
After executing the reorg on specific table, db2pd or snapshot
on table shows the reorg information
of the table.
$ db2 reorg table administrator.org
$ db2pd -d sample -reorg -tcb or db2 get snapshot for
tables on SAMPLE
The above commands displays the reorg details.
$ db2 select * from SYSIBMADM.ADMINTABINFO where tabname='ORG'
After the above command when we run the db2pd or snapshot
command again then we don't see reorg related information.
By running sqlrlAdminGetTabInfo for this tables causes the
deletion of reorg table data. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 version 10.01.002 *
**************************************************************** |
| Local Fix: |
N/A |
| available fix packs: |
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Solution |
First fixed in DB2 version 10.01.002 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 22.06.2012
21.02.2013
21.02.2013 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.2
|
 |
| 10.5.0.2
|
|
