|
Problem IC80930
|
Status: Closed |
TABLE DATA OF REORG INFORMATION GETS CLEARED ON EXECUTION OF SQLRLADMINGETTABINFO VIEW |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - 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: *
* Users using the DB2 version prior to V9.7 FP6 *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 V9.7 Fixpack 6 *
**************************************************************** |
| Local Fix: |
N/A |
| available fix packs: |
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
First Fixed in DB2 V9.7 Fixpack 6 |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC84834 IC88435
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 20.01.2012
12.06.2012
12.06.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP6
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.6
|
 |
